select * from SQL - DEV Community Skip to content Powered by Algolia Log in Create account DEV Community select * from SQL Posts on tips and tricks, using and learning about SQL for database development and analysis. Follow Hide Create Post submission guidelines Allowed Posts about learning SQL Posts about tips, tricks, problems, and answers Posts about news or commentary of the field Posts about specific tooling or frameworks Think what would someone wanting to learn more about SQL want to see. Not Allowed Articles that mention SQL in passing Articles that break the terms of use about #sql SQL is the language of data, has been for nearly 50 years now! Older #sql posts 1 2 3 4 5 6 7 8 9 …75 …515 Posts 👋 Sign in for the ability to sort posts by relevant, latest, or top. The Past Keeps Changing Matty Stratton Matty Stratton Matty Stratton Follow Aug 17 The Past Keeps Changing #postgres #database #sql #programming Add Comment 11 min read QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway. Tracepoint Data Tracepoint Data Tracepoint Data Follow Aug 17 QUERY_HISTORY has no PARENT_QUERY_ID. Here's how I traced which statement inside a Snowflake procedure regressed anyway. #snowflake #sql #dataengineering #database Add Comment 4 min read Webtabellen Converteren naar SQL INSERT-Statements circobit circobit circobit Follow Aug 17 Webtabellen Converteren naar SQL INSERT-Statements #javascript #sql #webdev #database Add Comment 5 min read I Thought MSSQL and MySQL Were the Same. I Was Wrong. Satyam Gupta Satyam Gupta Satyam Gupta Follow Aug 17 I Thought MSSQL and MySQL Were the Same. I Was Wrong. #mysql #sql #database #programming Add Comment 20 min read Closing the Tax Gap with a Data Model: Invoice Traceability in SQL Ricardo de Melo Ricardo de Melo Ricardo de Melo Follow Aug 17 Closing the Tax Gap with a Data Model: Invoice Traceability in SQL #sql #database #datamodeling #fintech Add Comment 4 min read Speed Up Your Queries: A Plain-English Guide to Database Indexing Saurav Pandey Saurav Pandey Saurav Pandey Follow Aug 17 Speed Up Your Queries: A Plain-English Guide to Database Indexing #databaseindexing #database #sql #performance Add Comment 3 min read Understanding Subqueries and CTEs in SQL: A Complete Guide Samuel Mwai Samuel Mwai Samuel Mwai Follow Aug 17 Understanding Subqueries and CTEs in SQL: A Complete Guide #beginners #database #sql #tutorial Add Comment 4 min read Export a Database Data Dictionary: HTML, Markdown and Excel from Your ERD Son Tran Son Tran Son Tran Follow Aug 17 Export a Database Data Dictionary: HTML, Markdown and Excel from Your ERD #database #documentation #sql #postgres Add Comment 7 min read OrioleDB Multi-Version Concurrency Control Franck Pachot Franck Pachot Franck Pachot Follow Aug 16 OrioleDB Multi-Version Concurrency Control #postgres #sql #database #orioledb Add Comment 7 min read DIA 0 -> Começando a documentar minha jornada DEV. Matheus Martins Matheus Martins Matheus Martins Follow Aug 17 DIA 0 -> Começando a documentar minha jornada DEV. #sql #database #php #github Add Comment 1 min read Why I Built SeedSQL: Generating Schema-Aware Synthetic Data Without Leaking PII Dhanush Gowda Dhanush Gowda Dhanush Gowda Follow Aug 17 Why I Built SeedSQL: Generating Schema-Aware Synthetic Data Without Leaking PII #database #sql #devtools #webdev Add Comment 2 min read Demystifying Vector Distance in PostgreSQL 💻 Arpad Kish 💻 💻 Arpad Kish 💻 💻 Arpad Kish 💻 Follow Aug 16 Demystifying Vector Distance in PostgreSQL #algorithms #database #postgres #sql 1 reaction Add Comment 2 min read How to Turn Plain-English Requirements into SQL You Can Actually Trust Craftloop Craftloop Craftloop Follow Aug 16 How to Turn Plain-English Requirements into SQL You Can Actually Trust #sql #database #ai #productivity Add Comment 2 min read I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer. Luis Henrique Vasconcelos Luis Henrique Vasconcelos Luis Henrique Vasconcelos Follow Aug 15 I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer. #reverseengineering #database #career #sql Add Comment 4 min read Your acquisitions table needs a status field, not a boolean corpdigest corpdigest corpdigest Follow Aug 14 Your acquisitions table needs a status field, not a boolean #database #sql #datascience Add Comment 2 min read 👋 Sign in for the ability to sort posts by relevant, latest, or top. trending guides/resources Oracle ORA-00600 Error: Causes and Solutions Complete Guide Turso: A Rust Rewrite of SQLite. Setup Guide and Whether It's Worth Your Time Getting Started with pg_durable: Workflows Inside PostgreSQL From Joins to Graph Edges: SQL/PGQ in PostgreSQL 19 How to Format SQL Queries in Python: Best Practices, Gotchas, and Real-World Examples I Shipped 12 BI Dashboards With 5 Different Tools. Here Is the Honest Comparison. PostgreSQL query planner parameters and prepared statements Oracle ORA-00472 Error: Causes and Solutions Complete Guide Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained PostgreSQL Connection Pooling Explained: How It Works and Why It Matters PostgreSQL 19 REPACK: Choosing the Right FILLFACTOR Bitmap Heap Scan in Postgres: When It’s Smart and When It’s a Symptom Oracle ORA-00308 Error: Causes and Solutions Complete Guide Real-Time Metrics Dashboards with SQL: Patterns That Actually Scale SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN AI-Native Data Engineering: From ETL Pipelines to Agentic Data Serving PostgreSQL vs MySQL vs NoSQL: The Complete Guide to Understanding Modern Databases Postgres: force drop a database that is being accessed by other users Why `SqlBulkCopy` Is So Fast: Under the Hood of SQL Server Bulk Loading Day 5 of 100 Days of ClickHouse®: Writing Your First Query The customer_id that isn't a customer Diseñando una Base de Datos para una Tienda Online con PostgreSQL y DBeaver PostgreSQL 22003 Error: Causes and Solutions Complete Guide Oracle ORA-00909 Error: Causes and Solutions Complete Guide Open Source Project of the Day (#116): SAG — Multi-Hop RAG Retrieval via SQL JOINs Instead of Pag... DEV Community — A space to discuss and keep up software development and manage your software career Home DEV Challenges Reading List DEV++ Videos DEV Education Tracks DEV Help Advertise on DEV Organization Accounts DEV Showcase About Contact DEV Shop MLH Code of Conduct Privacy Policy Terms of Use Built on Forem — the open source software that powers DEV and other inclusive communities. Made with love and Ruby on Rails. DEV Community © 2016 - 2026. We're a place where coders share, stay up-to-date and grow their careers. Log in Create account