SQL
dsq is neat. SQL Indexing and Tuning book has many tips. PRQL & GlueSQL seem nice too.
Arctype is a nice tool.
Notes
- High cardinality = unique. Low cardinality = less unique.
- Nice to alias tables by their first letters. i.e.
supplier_domains sdorsupplier_inferred_properties sip. Then can use the alias assd.inselectclause. - When you have a problem, build two solutions - a deep Bayesian transformer running on multicloud Kubernetes and a SQL query built on a stack of egregiously oversimplifying assumptions. Put one on your resume, the other in production. Everyone goes home happy.
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. (Docs) (HN)
- Learn Modern SQL with PostgreSQL (HN) (Solutions)
- PartiQL - SQL-compatible access to relational, semi-structured, and nested data. (Rust Code)
- 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, analyze and transform data from multiple databases and file formats using SQL. (HN)
- 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) (Using SQL to query Kafka, MongoDB, MySQL, PostgreSQL and Redis with Presto)
- 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) (HN)
- 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 (2022) - Beginner’s Guide to Storytelling with Data. (Code)
- 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)
- Advanced SQL Questions From Amazon (2021)
- Streaming SQL: What is it, why is it useful? (2021)
- Steampipe - Extensible SQL interface to your favorite cloud APIs. (Code)
- Speeding up SQL queries by orders of magnitude using UNION (2021) (HN)
- Some opinionated thoughts on SQL databases (2021) (Lobsters)
- How to create a 1M record table with a single query (2021)
- fselect - Find files with SQL-like queries.
- Thinking in Questions with SQL (2021)
- Best practices for writing SQL queries (HN)
- Arctype - Fast and easy-to-use SQL client. (HN)
- Don’t we all just want to use SQL on the front end? (2021) (HN)
- TinySQL - Course designed to teach you how to implement a distributed relational database in Go.
- Ask HN: Is there a way to efficiently subscribe to an SQL query for changes? (2021)
- Practical SQL for Data Analysis: What you can do without Pandas (2021) (HN)
- sqlbench - Measures and compares the execution time of one or more SQL queries.
- Efficient SQL on Pandas with DuckDB (2021)
- SQL - SQL injection protection module.
- DuoRAT: Towards Simpler Text-to-SQL Models (2020) (Code)
- SQL Jobber - Lightweight SQL job-server for scaling read queries. (HN)
- SQL Query Optimization: Understanding Key Principle (2021) (Reddit)
- SQLizer - Easily convert files into SQL Databases.
- sql-lint - Does sanity checks on your queries as well as bring errors back from the DB.
- Actual order of execution of SQL
- sqlgg - SQL Guided (code) Generator. (Web)
- sqldef - Idempotent MySQL/PostgreSQL schema management by SQL. (Web)
- SQL Fiddle - Application for testing and sharing SQL queries.
- TextQL - Execute SQL against structured text like CSV or TSV.
- SQL Join Types Explained in Visuals (2021) (HN)
- Against SQL (2021) (HN) (Lobsters)
- SQLBolt - Interactive lessons and exercises to learn SQL. (HN)
- Load CSV files and write SQL (HN)
- Why you should learn SQL (2019) (HN)
- Write an SQL query builder in 150 lines of Python (2021) (HN)
- SQL vs. NoSQL Is the Wrong Distinction (2021) (HN)
- Cloud Infrastructure as SQL (HN)
- SQL Explorer - Easily share data across your company via SQL queries.
- fsql - Find files with SQL.
- A single person answered 76,229 questions about SQL on StackOverflow (HN) (Reddit)
- Why NoSQL (HN)
- What ORMs have taught me: just learn SQL (2014) (HN)
- ZetaSQL - Analyzer Framework for SQL.
- SQL for Distributed Systems (2021) (HN)
- sqlcommenter - Suite of middlewares/plugins that enable your ORMs to augment SQL statements. (Code)
- What is a slow SQL query? (2021)
- xyr - Lightweight, simple, and powerful data ETL platform that helps you to query available data sources using SQL.
- go-mysql-server - SQL engine which parses standard SQL (based on MySQL syntax) and executes queries on data sources of your choice.
- List of MySQL joins types
- SQL: The difference between WHERE and HAVING (HN)
- trdsql - CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.
- Trino - Distributed SQL query engine for big data. (Code) (Getting Started) (A decade of query engine innovation) (HN)
- Better SQL JOINs (2021)
- Running SQL JOINs on multiple CSV files
- PGSpider - High-Performance SQL Cluster Engine for distributed big data.
- SQL language proposal: JOIN FOREIGN (HN)
- Dremio - SQL Data Lakehouse Platform for High-Performance BI. (Code)
- SQLPad - Web-based SQL editor run in your own private cloud.
- tree-sitter-sql - SQL grammar for tree-sitter.
- Graph Pattern Matching in GQL and SQL/PGQ (2021)
- Dsq - Command line tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. (Article) (HN) (March 2022 update)
- Treating SQL like code (2022) (HN)
- SQL Formatter - Polyglot SQL formatter. (Code)
- Sqllogictest - Program designed to verify that an SQL database engine computes correct results by comparing the results to identical queries from other SQL database engines. (Sqllogictest-rs)
- PRQL - Modern language for transforming data — a simpler and more powerful SQL. (HN) (HN)
- Malloy - Better SQL, from Looker. (HN)
- SpyQL - SQL with Python in the Middle. (HN)
- Bdash - Simple SQL Client for lightweight data analysis.
- StackQL - Query, provision and operate Cloud and SaaS resources and APIs using an extensible SQL based framework. (Code)
- XNGIN - SQL Engine built from scratch in Rust.
- Ask HN: Tools to visualize data in SQL databases? (2022)
- Rivers and Axis (2022) - How to format SQL queries.
- mgrt - Simple SQL migrations.
- Learn SQL with Datasette
- SeaSchema - SQL schema management suite.
- SQL Injection in a Parameterized Query (HN)
- SQLreduce - Reduce verbose SQL queries to minimal examples.
- Understanding Bitemporal Data (2022)
- sqlfmt - Opinionated SQL Formatter. (Code)
- Postgrator - PostgreSQL, MySQL, and SQL Server migration tool using plain sql scripts.
- Animate SQL - Visualize SQL Queries. (HN)
- RestQ - Compacting the SQL into the URL rest API.
- Is SQL going out of fashion? (2022)
- ReadySet - Same database, (much) faster queries. SQL caching engine. (Intro) (HN) (Code) (HN)
- Surveying 10+ SQL parser libraries in a few high-level languages (2022)
- Sneller - Vectorized SQL for JSON at scale: fast, simple, schemaless.
- Open Source SQL Parsers (2021) (HN)
- More SQL Parsing - Parse SQL into JSON so we can translate it for other datastores.
- Analyzing iMessage with SQL (2022)
- Balsa - Learned SQL query optimizer. It tailor optimizes your SQL queries to find the best execution plans for your hardware and engine.
- Learn BigQuery
- SQL Graphviz - Python 3 script that generates a Graphviz visualization of a SQL schema dump.
- Functional Programming on Top of SQL Engines (2022)
- What is the difference between single and double quotes in SQL?
- Toy Query Engine & SQL interface
- DataFusion - Extensible query execution framework, written in Rust, that uses Apache Arrow as its in-memory format.
- Essential elements of high performance applications: SQL indexes (2022)
- A Gentle(-ish) Introduction to Worst-Case Optimal Joins (2022)
- SQL Style Guide - Consistent code style guide for SQL to ensure legible and maintainable projects. (Code)
- SQL tricks and concepts you didn't know about - Aleksandra Sikora (2022)
- SQL Habit - Practical SQL course.
- Monaco SQL Languages
- Use Checkerboard Diagrams to Visualize Joins Instead of Venn Diagrams
- Semantic Diff for SQL (HN)
- ts-sql-plugin - TypeScript Language Service Plugin for SQL with a tagged template strings SQL builder.
- Having, a less understood SQL clause (2022) (HN)
- Nice intros to SQL