Things to know about databases

#1

Post by grech » Mon, Jun 27, 2022, 3:08 PM UTC

Things to know about databases
architecturenotes.co

Re: Things to know about databases

#2

Post by googletron » Mon, Jun 27, 2022, 3:19 PM UTC

This is a quick rundown of database indexes and transactions. Excited to continue sharing these notes with community!

Re: Things to know about databases

#3

Post by yla92 » Mon, Jun 27, 2022, 3:23 PM UTC

Great post. Also highly recommend Designing Data-Intensive Applications by Martin Kleppmann (https://www.amazon.com/Designing-Data-Intensive-Applications...). The sections on "Storage and Retrieval", "Replication", "Partitioning" and "Transactions" really opened up my eyes!

Re: Things to know about databases

#4

Post by mgrouchy » Mon, Jun 27, 2022, 3:46 PM UTC

googletron wrote: post #2

This is a quick rundown of database indexes and transactions. Excited to continue sharing these notes with community!

I have been really enjoying the content so far, any hits on whats coming up?

Re: Things to know about databases

#5

Post by itsmemattchung » Mon, Jun 27, 2022, 3:48 PM UTC

yla92 wrote: post #3

Great post. Also highly recommend Designing Data-Intensive Applications by Martin Kleppmann ( https://www.amazon.com/Designing-Data-Intensive-Applications... ). The sections on "Storage and Retrieval", "Replication", "Partitioning" and "Transactions" really opened up my eyes!

Second this.

I really like how he (Martin Kelppman) in the book starts with a primitive data structure for constructing a database design, and then evolves the system slowly and describes the various trade offs with building a database from the ground up.

Re: Things to know about databases

#6

Post by googletron » Mon, Jun 27, 2022, 3:49 PM UTC

mgrouchy wrote: post #4

googletron wrote: post #2

This is a quick rundown of database indexes and transactions. Excited to continue sharing these notes with community!

I have been really enjoying the content so far, any hits on whats coming up?

We have another couple of notes from a few companies like Temporal, Sentry, and Gadget.

Re: Things to know about databases

#7

Post by otherflavors » Mon, Jun 27, 2022, 3:51 PM UTC

why is this tagged "MySQL" but not also "SQL"

Re: Things to know about databases

#8

Post by bironran » Mon, Jun 27, 2022, 3:57 PM UTC

Nice post, though for the indexing "introduction-deep-dive" I would still recommend newbies to look at https://use-the-index-luke.com/ .

Re: Things to know about databases

#9

Post by itsmemattchung » Mon, Jun 27, 2022, 3:58 PM UTC

googletron wrote: post #6

mgrouchy wrote: post #4

Earlier quoted context omitted.

I have been really enjoying the content so far, any hits on whats coming up?

We have another couple of notes from a few companies like Temporal, Sentry, and Gadget.

Awesome. Looking forward to additional content.

If possible, would be great to get Mark Brooker (Principal at AWS) to provide some notes on bridging the gap between CAP theorem and how AWS relaxes constraints for building out Elastic Block Storage (EBS).

https://brooker.co.za/blog/2014/07/16/pacelc.html

Re: Things to know about databases

#10

Post by wrs » Mon, Jun 27, 2022, 4:02 PM UTC

From the SERIALIZABLE explanation: “The database runs the queries one by one … It is essential to have some retry mechanism since queries can fail.”

I know they’re trying to simplify, but this is confusing. If the first part is true, the second part can’t be. In reality the database does execute the queries concurrently, but will try to make it seem like they were done one by one. If it can’t manage that, a query will fail and have to be retried by the application.