SQL

Sort by:

Database Performance and Optimization with Andrew Davidson

When a database gets large, it can start to perform poorly. This can manifest in slow query speed. You can speed up a query by defining an index, which is a data structure that allows

Postgres Sharding and Scalability with Marco Slot

Relational databases have been popular since the 1970s, but in the last 20 years the amount of data that applications need to collect and store has skyrocketed. The raw cost to store

CockroachDB with Ben Darnell

“Eventual consistency is really kind of a marketing term from some of these NoSQL systems – it’s not really consistent in any strong sense of the term.” Google has published

Apache Drill with Tomer Shiran

"It’s a great world to be a developer in. If you’re a developer today, you have so many tools and so many options." Continue reading…

SQLite with D. Richard Hipp

“Everybody that sees SQL thinks its ugly and dirty and they want to try and rewrite it to be better. There’s a bazillion attempts to do this - I’ve tried it several times myself.