A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL and SQLite, Turso and more. - Maxteabag/sqlit

In alpha at this stage, but another alternative to SQL with an enhanced syntax that supports JSON-like notation, and more importantly, relation traversal.

An interpreted relational query language that compiles to SQL. - erezsh/Preql

A tool for visual exploration of a large database’s schema.

There is potentially a huge amount of value to be unlocked by replacing SQL, and more generally in rethinking where and how we draw the lines between databases, query languages and programming languages.

Reactive Data Board. Rabbit is a hyper-composable data platform that feels more like a creative game engine than a basic “dashboard” utility. Built on Clojure and SQL—but open to everyone—Rabbit gives you a direct-manipulation canvas where drag-and-drop meets livecoding, so you can shape, filter, pivot, visualize, and automate data exactly how you want.

This blog post offers a tutorial on mastering PySpark SQL, guiding readers through the core concepts from basic data manipulation to advanced querying techniques for large-scale data processing.

SQL tips and tricks. This GitHub repository is a curated list of SQL tips and tricks, offering various code snippets and techniques intended to help users enhance their SQL query writing and database manipulation skills.

This blog post provides a detailed look at various techniques and methods for performing data sampling using SQL, including stratified and random sampling, and discusses the nuances and pitfalls of each approach.

The website IMDb-SQL provides a tool to query the complete IMDb database using SQL directly in the browser, serving as a powerful resource for film data analysis and practice.

Sekuel provides artisanal analytics services, along with practical learning materials for SQL and a zero-setup online DuckDB Playground for users to practice and experiment with data queries.

How to perform keyword search on columns in postgresql using tsvector and tsquery. This allows us to perform Full-Text-Search for keywords in database.

here’s how to load custom dbs:

• https://sqliteonline.com/#urldb=https://raw.githubusercontent.com/thomasnield/oreilly_sql_fundamentals_for_data/master/databases/rexon_metals.db
• https://sqliteonline.com/#urldb=https://raw.githubusercontent.com/thomasnield/oreilly_sql_fundamentals_for_data/master/databases/weather_stations.db

Go SQL Access Toolkit