Posts tagged #sql

The CSV magician. Contribute to medialab/xan development by creating an account on GitHub.

A tricky thing to remember in Active Record is how to query multiple associations vs. nested associations. Multiple associations take a list of symbols, nested associations take a hash with a symbol. pic.twitter.com/XhGiJdcH7h— Colleen Schnettler (@leenyburger) March 3, 2022

A list of things that we can do when we need to scale a SQL database.

An interesting variation on how to represent a many to many relationship in rails.

Under the right circumstances this is an amazingly useful tool

Interesting account of all the ways that SQL sucks and of course a proposed fix!

Surprising and useful way to think about correct SQL statements.