The Hidden Costs of Poor Database Access • Denis Rosa • GOTO 2019

This presentation was recorded at GOTO Copenhagen 2019. #GOTOcon #GOTOcph http://gotocph.com Denis Rosa - Speaker, Developer Advocate at Couchbase ABSTRACT Developers love to try new programming languages, use different frameworks or experiment with new architectures. But when it comes to databases, we pretty much have been using the same approach for the past 30 years. In this session, I will quantify and expose some of the most common anti-patterns in database access, propose additional data models and compare major databases architectures. With the findings of this talk, you will be able to optimize your current projects and break the cycle of automatic decisions in the next ones [...] TIMECODES 00:00 Intro 01:34 Performance vs productivity 03:06 Databases are the bottleneck of most apps 07:31 SELECT * 08:52 Prepared statements 11:37 Blocking vs non-blocking calls 15:14 Joins 17:55 I want to be productive! 21:12 Wait, why do we have to choose? 23:12 Hierarchical data 27:40 But how do I query that? 32:41 SQL++ is backwards compatible 34:52 But SQL:2016 introduced JSON support 37:38 Key takeaways 39:22 Outro Download slides and read the full abstract here: https://gotocph.com/2019/sessions/1151/the-hidden-costs-of-poor-database-access RECOMMENDED BOOKS Vlad Mihalcea • High-Performance Java Persistence • https://amzn.to/3EMYgBR Don Chamberlin • SQL++ For SQL Users • https://amzn.to/3EEfvFq https://twitter.com/GOTOcon https://www.linkedin.com/company/goto- https://www.facebook.com/GOTOConferences #Database #DatabaseCosts #Data #SoftwareArchitecture #NoSQL #NoSQLDatabase #JSON #XML #YAML #SQLplusplus #Couchbase #AsterixDB #PartiQL #ApacheDrill #ORM Looking for a unique learning experience? Attend the next GOTO conference near you! Get your ticket at https://gotopia.tech SUBSCRIBE TO OUR CHANNEL - new videos posted almost daily. https://www.youtube.com/user/GotoConferences/?sub_confirmation=1