TLDR Web Dev · OPINIONS & ADVICE

DATABASE PROTOCOLS ARE UNDERWHELMING

byroot.github.io14 min read

Summary from the TLDR Web Dev newsletter

Database protocols like those of MySQL and PostgreSQL are underwhelming in terms of their developer experience. Since they use a mutable connection state, it requires complex connection management and makes error recovery difficult. Also, there aren't safe retry mechanisms for queries due to the uncertainty of idempotency.