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.
Український лематизатор тепер вбудовано в 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
Following ROWIDs Through an Oracle Unique Index Update
franckpachot profile

Following ROWIDs Through an Oracle Unique Index Update

#oracle #postgres #sql #index
1
Comments
13 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
SQL Project: Build a Greenlake Academy Database with PostgreSQL
angellicah_2ed8aa8f01f176 profile

SQL Project: Build a Greenlake Academy Database with PostgreSQL

#sql #postgressql #database #tutorial
1
Comments
4 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
Modelling, Joins, Relationships and different Schemas
pepsy11y profile

Modelling, Joins, Relationships and different Schemas

#beginners #data #database #sql
Comments
2 min read
Database Indexing and Query Optimization for Python Developers
gpuneet profile

Database Indexing and Query Optimization for Python Developers

#python #database #performance #sql
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.