Skip to content

DEV Community

select * from SQL

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

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

Andrea Debernardi

Apr 3

I am building a Notebook Environment for SQL Inside a Database Client

#sql #database #productivity #opensource

5 min read

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

Power BI DAX Pattern Library

#datascience #sql #python #analytics

3 min read

Mar 23

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

#mcp #sql #ai #typescript

4 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

Mar 3

Mastering Joins and Window Functions in SQL

#beginners #database #sql #tutorial

4 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

xh1m

Mar 12

From ERD to SQL: Implementing a Normalised Database Step-by-Step

#sql #database #learning #datastructures

3 min read

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