me talking out loud: "getting" joins
a good explaination of SQL joins
MySQL AB :: MySQL 5.0 Reference Manual :: 6.2.1 Optimizing Queries with EXPLAIN
assert_efficient_sql - O'Reilly Ruby
rails plugin that can detect inefficient queries in test cases
Logging SQL statistics in rails - Robot Has No Heart
ruckusing - Google Code
php based database migration suite
DeadWisdom / Migratory / wiki / Home — bitbucket.org
another db migration tool for django
Architecture of ARel 2.0 |
I want to talk about how ARel 2.0 is architected. I’m doing this for a few reasons, I would like it to be easier for other people to contribute (please read this as “Pink Warrior doesn’t want to be the only one maintaining ARel”), and I’m tired of repeating myself! I hope to eventually take this blog post, summarize it, and add it to the ARel documentation.
John Ewart » MySQL, Sub-selects and IN()
Trace a query to its origin
really handy snippet for tracking where an SQL statement comes from in a rails app
SQL Window Functions and You - The Hashrocket Blog
SQL Window Functions and You
sql - PostgreSQL Index Usage Analysis - Stack Overflow
handy SQL snippet for finding possible missing indexes in psql
Parse Postgresql Queries In Ruby - pganalyze blog
Postgres Window Functions
Models for hierarchical data
understanding_explain.pdf
postgresql - SELECT or INSERT a row in one command - Stack Overflow
handy SQL technique for SELECTING And INSERTING in a single command
The Codex » Do Not Pass This Way Again
Postgres Guide
How to query for null values in json field type postgresql?
Rob Conery | Inserting And Using A New Record In Postgres
ŷhat | 7 handy SQL features for data scientists
Nuncupatively: Naive Bayes in SQL
mysql - Naive bayes calculation in sql - Stack Overflow
Classifying Names by Gender with Naive Bayes in SQL
MADlib: Naive Bayes Classification
We’re announcing a new connection option, private networking beta, making connecting to Cloud SQL from applications in Google Cloud easier and even more secure. | Google Cloud Blog
Cockroach DB
Postgres 12 highlight - WITH clause and materialization
Starting with postgres 12, CTEs will no longer be an optimisation fence for many kinds of basic SELECT queries