SQL
All articles
What is a Database?
A database is an organised system for storing and retrieving data. Every app that remembers anything uses one.Stored Procedures and Triggers
Server-side database programs that encapsulate reusable logic and automatically respond to data events, …SQL Fundamentals
Structured Query Language, the standard language for defining, manipulating, and querying data in relational …Relational Algebra
The formal mathematical foundation for querying relational databases, defining operations like select, …pgvector - Vector Search in PostgreSQL
A comprehensive reference for pgvector: adding vector similarity search to PostgreSQL, indexing strategies, …DuckDB - Embedded Analytical Database
DuckDB is an in-process analytical database management system designed for fast OLAP queries on local data …dbt - Data Build Tool for Analytics Engineering
dbt (data build tool) is an open-source transformation framework that enables analytics engineers to transform …BigQuery - Serverless Data Warehouse and Analytics Engine
Google BigQuery is a serverless, highly scalable data warehouse that supports SQL analytics, ML model …Azure Synapse Analytics - Unified Analytics and Data Warehousing
Azure Synapse Analytics is an integrated analytics platform that combines enterprise data warehousing, big …Apache Superset - Open-Source Business Intelligence Platform
Apache Superset is a modern, open-source data exploration and visualization platform designed for interactive …Apache Hive - Data Warehouse on Hadoop
Apache Hive is a data warehouse infrastructure built on top of Apache Hadoop that provides SQL-like querying …Amazon Redshift - Cloud Data Warehouse
A comprehensive reference for Amazon Redshift: columnar data warehousing, ML integration, and analytics …Amazon Athena - Serverless SQL Analytics
A comprehensive reference for Amazon Athena: serverless query engine for S3 data, integration with Glue Data …
Open source projects