TLDR Web Dev · OPINIONS & ADVICE
DATABASE PROTOCOLS ARE UNDERWHELMING
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.