select * from SQL Page 115 - DEV Community

Skip to content

DEV Community

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

SQL is the language of data, has been for nearly 50 years now!

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Erika S. Adkins

Mar 5

Refactoring the Nike Scraper: Replacing In-Memory Deduplication with SQLite

#webscraping #devops #sql #python

4 min read

Philip McClarence

Mar 1

pgvector Distance Functions: Cosine vs L2 vs Inner Product

#database #machinelearning #postgres #sql

3 min read

Rebooter.S

Feb 27

Text-to-SQL Finally Gets Real: DySQL-Bench, BibSQL, DLBench Fix the 'Perfect Query' Myth

#ai #database #llm #sql

3 min read

Mar 23

ajan-sql: Giving AI Safe, Read-Only SQL Access with MCP

#mcp #sql #ai #typescript

4 min read

Sergey Nikolaev

Apr 3

Prepared statements in Manticore Search

#backend #database #security #sql

7 min read

Mar 4

# Understanding Joins and Window Functions in SQL

#sql #postgres #data #database

7 min read

Vlad Ganușceac

Apr 2

Getting Started With Seal Report: Applying Custom Joins

#sealreport #analytics #sql #tutorial

4 min read

Mar 4

From Pixels to Calories: Building an Unstructured Food Estimation Pipeline with GPT-4o & DINOv2 🍕🔬

#ai #sql #fastapi #webdev

4 min read

CodeWithDhanian

Apr 2

SQL vs. NoSQL in System Design

#architecture #database #sql #systemdesign

5 min read

Feb 28

Introducing Duck-UI 0.0.32: A Streamlined Web Interface for DuckDB

#database #sql #ui #webdev

3 min read

Son Tran

Apr 2

dbdiagram.io Alternative: Offline Desktop ERD Tool

#database #sql #tooling #programming

12 min read

Apr 2

CTEs vs Subqueries in SQL: Which One Should You Use?

#sql #dataengineering #beginners #programming

3 min read

Apr 2

Cryogenic Storage: A Developer's Guide (Yes, Really)

#architecture #database #science #sql

2 min read

Ajani luke Kariuki

Mar 2

PostgreSQL Joins and Window Function

#database #postgres #sql #tutorial

2 min read

Philip McClarence

Mar 12

PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

#database #performance #postgres #sql

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.