The Elephant in the Room: Our Relation to Databases and their Secrets
The Elephant in the Room: Our Relation to Databases and their SecretsTo sign up
It's Meetup time once again! 🎉 Join us on August 22nd for an amazing evening, all about databases. 😍 As always, 🍺 and 🍕 are on us!
- 18:00: Doors open 🚪
- 19:00: Talk by Sjoerd Cranen (Picnic): The Elephant in the Room: Our Relation to Databases
- 19:45: Talk by Lukas Eder (Data Geekery GmbH): How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of
- 20:30: Networking 🙋🏼♂️🙋🏼♀️
- Sjoerd Cranen
We’ll talk about which database technologies are in use at Picnic, what we use them for, and what we learned while using them. After that, we will briefly look at how software engineering and data engineering come together at Picnic, and what that means for our data infrastructure.
- Lukas Eder
Lukas Eder is founder and CEO of Data Geekery GmbH, the company behind jOOQ, located in St. Gallen, Switzerland.
He is fascinated by the interaction of Java and SQL. Most of this experience he has obtained in the Swiss E-Banking field through various variants (JDBC, jOOQ, Hibernate, mostly with Oracle and PostgreSQL). As a Java Champion and Oracle ACE, he is happy to share this knowledge at various conferences, JUGs, in-house presentations and on his blog.
SQL is the only ever successful, mainstream, and general-purpose 4GL (Fourth Generation Programming Language) and it is awesome!
With modern cost-based optimization, relational databases like Oracle, SQL Server, PostgreSQL finally keep up to the promise of a powerful declarative programming model by adapting to ever-changing productive data without performance penalties. Thousand-line-long, complex SQL statements can be run in far below a millisecond against billion-row strong tables if database developers know their ways around the SQL language - and the best news is: It’s not that hard!
In this talk, I’ll show how the SQL database will constantly outperform any handwritten data retrieval algorithm - or in other words - how SQL, being a logic language, is the best language for business logic.