SQL - My Docs

SQL
Notes
High cardinality = unique. Low cardinality = less unique.
Nice to alias tables by their first letters. i.e. supplier_domains sd or supplier_inferred_properties sip. Then can use the alias as sd. in select clause.
Links
​Learn SQL the hard way​
​Quick SQL cheat sheet - Quick reminder of all SQL queries and examples on how to use them.
​SQLCheck - Automatically identify anti-patterns in SQL queries.
​SQL Fundamentals course​
​q - Run SQL directly on CSV or TSV files.
​Learn Modern SQL with PostgreSQL (HN)
​PartiQL - SQL-compatible access to relational, semi-structured, and nested data.
​BlazingSQL - Lightweight, GPU accelerated, SQL engine built on RAPIDS.
​Ways to Tweak Slow SQL Queries (HN)
​osquery - SQL powered operating system instrumentation, monitoring, and analytics. (Web) (osquery launcher)
​SQL queries don't start with SELECT (2019)​
​OctoSQL - Query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
​SQL Murder Mystery - Designed to be both a self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime. (HN)
​usql - Universal command-line interface for SQL databases. (HN)
​SQL Performance Explained book​
​How a SQL database works (2019) (HN)
​When an SQL database makes a great Pub/Sub (2019) (HN)
​Cosette - Automated SQL solver.
​BlazingSQL - GPU accelerated SQL engine built on top of the RAPIDS ecosystem. (Web)
​libinjection - SQL / SQLI tokenizer parser analyzer.
​SQL Tutorial for Beginners (2020)​
​SQL Koans - Set of koans to introduce you to SQL. (Code)
​eSQLate - Build minimum viable admin panels quickly with just SQL.
​Presto - Distributed SQL Query Engine for Big Data. (Code)
​SQL Language Server​
​The rise of SQL-based data modeling and DataOps (2019) (HN)
​NULL Values in SQL Queries (2020) (HN)
​RapidQL - Join, combine, and aggregate data from multiple APIs and databases — all in one call. (Code)
​sqlfmt - SQL Formatter.
​Domain Logic and SQL (2013) (HN)
​Database basics: writing a SQL database from scratch in Go (2020) (HN)
​sqls - Implementation of the Language Server Protocol for SQL.
​Compiling PL/SQL Away (2019)​
​Constexpr SQL - Light weight single header alternative to DBMS.
​SELECT wat FROM sql (HN)
​Advanced SQL and database books and resources (2020) (HN)
​Medium-hard SQL interview questions (HN)
​SQL Police Department – Learn SQL while solving crimes (HN)
​Preventing SQL injection: a Django author's perspective (2020)​
​SQL for the rest of us​
​Demystifying JOIN Algorithms (2019)​
​SQLsmith - Random SQL query generator.
​forma - Opinionated SQL formatter.
[How Does SQLAlchemy Manage Database Transactions? (2019)https://capnfabs.net/posts/sqlalchemy-connection-management/)
​Falcon - Free, open-source SQL editor with inline data visualization.
​querycafe - Import, query, and share any dataset.
​AlaSQL - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL).
​RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers (2020) (Code)
​Some SQL Tricks of an Application DBA (2020) (Lobsters)
​Scaling relational SQL databases (2020)​
​The Troublesome Active Record Pattern (2020) (HN)
​Implementing subqueries in go-mysql-server (2020)​
​We Can Do Better Than SQL (2019) (Lobsters) (HN)
​How to level up your SQL skills (2019) (Lobsters)
​Lateral Joins and Demand-Driven Queries (2020)​
​SQL Templates​
​PopSQL - Collaborative SQL editor for teams.
​Nested SQL Queries​
​GlueSQL - SQL Database Engine as a Library.
​TS SQL - SQL database implemented purely in TypeScript type annotations. (Tweet) (HN)
​Simple Anomaly Detection Using Plain SQL (2020) (Lobsters) (HN)
​A Short Story About SQL’s Biggest Rival (2020) (HN)
​What ORMs Have Taught Me: Just Learn SQL (2014) (HN)
​SQL Formatter - JavaScript library for pretty-printing SQL queries. (Code)
​SQL Joins Visualizer - Help to you build SQL JOIN between two tables by using of Venn diagrams. (Code)
​Top 10 Most Important SQL Commands to Know (2020)​
​Automate Business Logic With Logic Bank - Rule engine automates SQLAlchemy update logic for remarkable agility - 40X more concise. Scalable. Extensible and manageable using Python. (Tweet)
​SQL overview (Code)
​cloudquery - Transform your cloud config and metadata to SQL. (Code)
​mfsqlchecker - Statically validate correctness of all your SQL queries. TypeScript, PostgreSQL.
​SQLiterally - Lightweight SQL query builder.
​sqlmap - Automatic SQL injection and database takeover tool. (Web)
​SQL Conventions​
​SQLFlow - Brings SQL and AI together. (Web)
​Practical SQL (2018) - Beginner’s Guide to Storytelling with Data.
​Recursion in SQL Explained Visually (2020)​
​FuseQuery - Distributed SQL Query Engine at scale. (Web)
​Introduction to Window Functions in SQL (2020) (HN)
​Preql - Interpreted relational query language that compiles to SQL. (Lobsters)
​What can we learn from SQL's 50 year reign? A story of 2 Turing Awards (2021) (Lobsters)
​SQL Next Steps: Optimization (Code)
​The surprisingly difficult problem of user-defined order in SQL (2018) (HN)
​Why SELECT * is bad for SQL performance (2020) (HN)
​Use The Index, Luke - SQL indexing and tuning tutorial for developers.
​SQL and aggregated data: is there a better way?​
​Double-thinking in SQL (2009)​
​Objection to ORM Hatred (2019) (HN)
​Lobsters: Why is SQL so successful? (2021)​
​How Materialize and other databases optimize SQL subqueries (2021)​
sql
blockchain
Last modified 5mo ago
Copy link
Contents
Notes
Links