2025-04-25 –, Main hall
What happens behind the scenes when you send a query to your database? How is the data stored, retrieved and modified? Why should you care?
With a basic understanding of the way select, insert and update operations work, you can make sure your code and database play nicely together!
If the inner workings of your database are a mystery to you, and you want to change that, this talk is for you!
The talk will look at what happens behind the scenes when you send a query to your database. What happens when you insert, update or delete data, and how data is retrieved and returned to you during a select operation.
We’ll also talk about why you should care about those things. Although you can often get away with thinking of your database as a black box, it’s very useful to have a basic understanding of the way in which data is stored and retrieved. If you do, you can make sure your code and database play nicely together and potentially save yourself a lot of trouble later.
Intermediate
Topics –DB
Karen was a database administrator for over 20 years and was once described as "quite personable for a DBA", which she decided to take as a compliment! She's now a Senior Solutions Architect at Crunchy Data, helping her customers to design and manage their (PostgreSQL) database environments.
Karen gives talks about databases at PostgreSQL and developer conferences because she loves sharing knowledge. She is a PostgreSQL Europe board member and conference organiser, and chairs the PostgreSQL Europe Diversity Committee.