Plurrrr

database

January

18

Efficient Pagination Using Deferred Joins

February

03

Using org-mode as an SQL playground

25

Various Meanings of SQL’s PARTITION BY Syntax

March

14

Storing UTC is not a silver bullet

20

How sharding a database can make it faster

29

Understanding Bitemporal Data

April

22

Open Source SQL Parsers

May

10

Demystifying Database Performance for Developers

July

11

Code in database vs. code in application

20

Soft Deletion Probably Isn't Worth It

21

You Should Use This to Visualize SQL Joins Instead of Venn Diagrams

August

16

Rise of the Anti-Join

24

A Critique of SQL, 40 Years Later

September

13

3 Common Misconceptions About Object-relational Mapping

13

What is a LSM Tree

October

07

Future Proofing SQL with Carefully Placed Errors

December

22

For Want of a JOIN