DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Vector‑native RAG on Oracle: embeddings, HNSW/IVF, and hybrid search under database governance

Vector‑native RAG on Oracle: embeddings, HNSW/IVF, and hybrid search under database governance

1
Comments
12 min read
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension

DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension

Comments
3 min read
AI SQL Assistants: What to Actually Look For Before You Commit

AI SQL Assistants: What to Actually Look For Before You Commit

1
Comments 1
6 min read
How I built a fallback loop to save my recommendation engine

How I built a fallback loop to save my recommendation engine

Comments
2 min read
Semantic Search with PostgreSQL: Pragmatism Beats Hype - Most of the Time

Semantic Search with PostgreSQL: Pragmatism Beats Hype - Most of the Time

10
Comments 2
8 min read
DuckDB Lance Lakehouse Integration for Vector Search; SQLite Journaling; pgrls RLS Linter

DuckDB Lance Lakehouse Integration for Vector Search; SQLite Journaling; pgrls RLS Linter

Comments 1
3 min read
HOW DO YOU FEEL??

HOW DO YOU FEEL??

Comments
2 min read
Preventing double-bookings with PostgreSQL exclusion constraints

Preventing double-bookings with PostgreSQL exclusion constraints

Comments
6 min read
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

Comments
3 min read
I built a tool that lets you query websites using SQL

I built a tool that lets you query websites using SQL

Comments
1 min read
Learning SQL As If You Built It Yourself

Learning SQL As If You Built It Yourself

1
Comments
12 min read
Building a Simple Java JDBC Project with MySQL: Displaying Cricket Players and Scores

Building a Simple Java JDBC Project with MySQL: Displaying Cricket Players and Scores

3
Comments
2 min read
T-SQL on Microsoft Fabric - Episode 1: Mastering Data Retrieval with SELECT, WHERE, and ORDER BY

T-SQL on Microsoft Fabric - Episode 1: Mastering Data Retrieval with SELECT, WHERE, and ORDER BY

Comments
3 min read
PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production

PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production

Comments
3 min read
Come estrarre una singola tabella da un file dump MySQL

Come estrarre una singola tabella da un file dump MySQL

Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.