GitHub - medialab/xan: The CSV magician
The CSV magician. Contribute to medialab/xan development by creating an account on GitHub.
Posts tagged sql
7 posts
Colleen Schnettler on Twitter
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
Scaling relational SQL databases
A list of things that we can do when we need to scale a SQL database.
ebobby/has-many-with-set
An interesting variation on how to represent a many to many relationship in rails.
harelba/q
Under the right circumstances this is an amazingly useful tool
We Can Do Better Than SQL
Interesting account of all the ways that SQL sucks and of course a proposed fix!
SQL queries don't start with SELECT - Julia Evans
Surprising and useful way to think about correct SQL statements.