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

39:48 1060 views 85% Published 4 weeks ago

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



Watch on YouTube