Відео

For most web application, MySQL stands out to be better because most of the applications are read-heavy in nature. PostgreSQL is good for write-heavy applications only. Both the DBs are strong ACID compliant.

gr8 tutorial , and what is archive_moce, archive_command, restore_command etcc........

18:00 one doubt here, as fixed window counter may face double amount of requests for short period in case of bursts, that server may not able to handle it should be false right?

If you would build a tinder like application with chat function and recommendation system. Which database would you choose and why

can I run pgbouncer without specifying the default database postgres? like leaving dbname empty? what if I set dbname = * wildcard?

Perfect video!

Hi, really like your content. The only question I have is that in the cache, does user_id refers to the id of the person who made the tweet? Tell me if I'm getting this right: Whenever a user wants retrieve newsfeed we get ids of all the users that this particular user follows from graph database, then use those ids to pull out the tweet_ids that corresponds to those user_ids (so that we only pull tweets were made by the users that this user is following) from the newsfeed cache, then pull out user info from user cache and finally use tweets_id to pull out tweets data from tweets cache. Is this how it works? Would really appreciate your reply! I'm really confused about the mapping between tweet_id and user_id, does the user_id refers to the id of the user who made the tweet?

Excellent

pg_ctl: could not open PID file "/tmp/publication_db/postmaster.pid": Permission denied i changing owner to postgres already but still have errors

does this replication works in version 10, too?

This is amazing content, thank you very much, won another subscriber

That was great, thanks!

vow hatsoff you have explianed too good

75+ are not old, they are senior 😁

incredibilly well done tutorial. keep up the good work!

Thank you for this video. It makes me more confident to join my new team !

01:52 are you referring to the size of the table > 200 GB or was it the response time 200ms, because if it was size then its contradictory to your statement on size of postgres table with 8KB block size can't be crossing 32GB in size.

comeback pls goddddddddddddddddddddddddddddddddddd

two Spanish students owe you our database project score

Best play at 1.75 speed =)

Thank you so much for the effort you put into this video! Your explanation is incredible and the graphic is easy to understand 😊. I instantly subscribed.

comeback pls goddddddddddddddddddddddddddddddddddd

amazing videos, Thanks very clear and helpfull

I understand this could be beneficial to READS, but why is beneficial to WRITES ?

you forgot to mention columnar databases for high performance analytics

Sorry, this design is not best practice. You have 3 to 5 seconds to process a payment request and if that response is not delivered it is reversed, you don't use idempotency or retries to try to get an approval, if it was not approved in the initial attempt time window it is dead. Maybe this design works for b2b payments where you control the clients attempts, but it does work when you are servicing a live customer waiting. But your design would work for things like account creation or something else, just mot money movement when a live customer is involved.

Marvelous video!! Thank you!

Please do it for collection too

Best video!! Explained everything I learned in 4 months in 24 mins

gj copying Fireship's visual style

Good content, thank you very much

Great video! Where do you make your slides?

pretty good video, great diagram usage, maybe spend more time on index

What if after hasing for a server and a key, the hash value is the same, i.e, it refers to the same position in the circle?

Great video. Could you please share a link to the final design diagram as well, and if possible api design and db model? That would really clear major system design concepts

Do we have the SQL script? DDLs

i am getting error Error: Could not find or load main class org.apache.solr.util.SimplePostTool . please i searched across internet and found nothing to fix this error. please help

Could you please make a video on Wide column vs column family vs columnar vs column oriented DBs

Thanks for this informative video

My question, if I have server on premise with cpu 8 core , and ram 32Gb, how to recommend tuning mysql , thanks a lot

Thanks :)

man you are awesome! thank you!

Thanks for your useful content!!

this is really useful video, thank you

Good stuff! Congrats and thank you

Very good and relevant explanation. Just edit the video and add the HLD.

DDL statements seem to flow thru on PGv14. At least our replica has changes that were made to the schema from our prod db.

17:42 i love that sql injection in the 3rd id

@high-performance programming, on 15:03 of your video. how can I enter in pgpool.conf (backend_data_directory0) the path of the “data” folder of my pgsql if it is in windows environment? I am your one of your student in udemy.

Best ever. This is so excellently structured and summarize. thank you agaiN!