Explore the hidden costs of poor database access in this 40-minute conference talk from GOTO Copenhagen 2019. Delve into common anti-patterns in database access, learn about alternative data models, and compare major database architectures. Discover how to optimize current projects and make informed decisions for future ones. Cover topics such as performance vs. productivity, database bottlenecks, SELECT * usage, prepared statements, blocking vs. non-blocking calls, joins, hierarchical data, and SQL++ compatibility. Gain insights on querying complex data structures and understand the implications of SQL:2016's JSON support. Walk away with key takeaways to improve database access and overall application performance.
Overview
Syllabus
Intro
Performance vs productivity
Databases are the bottleneck of most apps
SELECT *
Prepared statements
Blocking vs non-blocking calls
Joins
I want to be productive!
Wait, why do we have to choose?
Hierarchical data
But how do I query that?
SQL++ is backwards compatible
But SQL:2016 introduced JSON support
Key takeaways
Outro
Taught by
GOTO Conferences
