What a web-developer should know about databases and how deep?

1 点作者 sashash大约 6 年前

Only main things like SQL, transactions, about ACID (Atomicity, Consistency, Isolation, Durability) or deeper knowledge like how Postgres works inside. About b-tree, relational algebra PostgreSQL etc. ?

1 comment

dpods大约 6 年前

SQL joins, SQL aggregates, Table schema modifications and which ones lock tables, Transactions, Indexing, Replication