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.
The Fastest Way to Add Reporting to Your Internal Tool
vivekdraxlr profile

The Fastest Way to Add Reporting to Your Internal Tool

#sql #database #webdev #productivity
1
Comments
6 min read
SQL Design & Query Reference
andreimerlescu profile

SQL Design & Query Reference

#webdev #sql #tutorial #ai
1
Comments 1
35 min read
The Afternoon We Put Magento's Schema on SQL Server
andreimerlescu profile

The Afternoon We Put Magento's Schema on SQL Server

#sql #beginners #webdev #programming
1
Comments
40 min read
Top N per group is the query `LIMIT` can't write
omer_hochman profile

Top N per group is the query `LIMIT` can't write

#sql #database #webdev
Comments
3 min read
Український лематизатор тепер вбудовано в Manticore Search
sanikolaev profile

Український лематизатор тепер вбудовано в Manticore Search

#news #database #nlp #sql
Comments
1 min read
Building an Analytics Layer on Top of Your Existing Database
vivekdraxlr profile

Building an Analytics Layer on Top of Your Existing Database

#sql #database #analytics #webdev
Comments
5 min read
Stop Pasting Your Database Schema Into Every AI Prompt
siddharth_pandey_27 profile

Stop Pasting Your Database Schema Into Every AI Prompt

#opensource #typescript #ai #sql
1
Comments 2
5 min read
Why I Built a Free SSMS Extension to Stop Destructive Queries
manuelenzo profile

Why I Built a Free SSMS Extension to Stop Destructive Queries

#database #security #sql #tools
Comments 2
3 min read
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive
soytuber profile
soy

DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive

#database #sql #sqlite
Comments
3 min read
PostgreSQL Said No to Query Hints for 20 Years. Postgres 19 Ships Them.
polliog profile

PostgreSQL Said No to Query Hints for 20 Years. Postgres 19 Ships Them.

#postgres #database #performance #sql
17
Comments 3
7 min read
ERD-First Database Design: One 60-Entity Schema, Sketch to Production
tbson87 profile

ERD-First Database Design: One 60-Entity Schema, Sketch to Production

#database #sql #programming
Comments
7 min read
Session 4 summary
hvdineshbabu profile

Session 4 summary

#backend #database #learning #sql
Comments
2 min read
Product Analytics with SQL: Tracking What Actually Matters
vivekdraxlr profile

Product Analytics with SQL: Tracking What Actually Matters

#sql #database #analytics #webdev
Comments
6 min read
Natural-language SQL needs metric contract tests, not just valid SQL
mads_hansen_27b33ebfee4c9 profile

Natural-language SQL needs metric contract tests, not just valid SQL

#sql #database #testing #ai
4
Comments 1
2 min read
From 8s to 1s: Truly Understanding Rails N+1 by Opening Up ActiveRecord
danewu profile

From 8s to 1s: Truly Understanding Rails N+1 by Opening Up ActiveRecord

#rails #activerecord #performance #sql
2
Comments
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.