Meet the Tools

The tools that leverage SQL are incredible these days. Below are some tools that I personally use on a regular basis.

Tools

• DBeaver - just a great SQL client that supports a lot of databases. DBeaver pretty much supports any database that’s out there - DBeaver simply downloads drivers on demand. If your database has proper metadata, DBeaver is extremely convenient for navigating entity relationship diagrams, dependencies, indices and descriptions.
• DB Fiddle - an online sandbox to run your SQL queries. You can think of this as GitHub gists but you can run the code and share it with others. I use this when running SQL interviews.
• SQLime - another online sandbox to write queries
• DuckDB Local UI - haven’t tested it yet but looks neat so far
• DuckDB Shell
• SQLGlot and Polyglot - transpile any SQL flavor to any other flavor. This is great for porting codebases, taking examples from this book into your own database or just learning different SQL flavors.
• DuckDB’s query visualizer

Learning Resources

• Advanced SQL Puzzles
• Use the Index, Luke
• Arena Games - Data Analysis

Reading material

https://www.scattered-thoughts.net/writing/against-sql/