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.

Murad Aghamirzayev

Mar 15

Creating a Cross-platform Data Sandbox that makes Working with Data Easier and Faster

#dataengineering #python #datascience #sql

3 min read

Faizan Firdousi

Apr 17

I Tested PostgreSQL on 5 Million Rows, Here’s What Actually Makes Queries Fast

#database #postgres #sql #distributedsystems

5 min read

Mar 14

Schema-risk

#rust #postgres #sql #cli

2 min read

ZevinChen

Mar 15

5 SQL Formatting Rules That Make Your Queries Actually Readable

#sql #database #productivity #beginners

3 min read

SysLayer

Apr 17

Coding Cat Oran Ep4, Speaking Human

#sql #developer #systemdesign

3 min read

Karan

Mar 27

🚀 Built a Cross-Database(AI) Recommendation System using FDW + Prisma

#architecture #sql #prisma #postgres

2 min read

Mar 17

SurrealDB: Why JOINs are So 2010 and How Graphs Change Everything (Part 3)

#webdev #sql #database #backend

2 min read

SysLayer

Apr 16

Coding Cat Oran Ep3, Five Tables Changed Everything

#sql #systemdesign #programming #backend

3 min read

Apr 15

Oracle SQL/JSON: The Developer's Guide to Querying JSON Like a Pro

#database #sql #tutorial

58 min read

Ramakrishna Chilaka

Apr 13

The $15 Per Ride You Didn't Know About: What 243 Million NYC Taxi Rides Reveal

#rust #sql #database #elasticsearch

11 min read

Philip McClarence

Mar 13

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

#database #postgres #sql #tutorial

3 min read

Philip McClarence

Mar 13

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

#architecture #database #postgres #sql

11 min read

Apr 15

SQL LIMIT and OFFSET: Paginate Your Query Results Like a Pro

#sql #database #beginners #tutorial

5 min read

Yao Luo

Mar 12

SQL JOIN Tutorial: INNER, LEFT, RIGHT, FULL OUTER Explained

#sql #database #programming #tutorial

6 min read

Philip McClarence

Mar 12

Query Planning Overhead with Many Chunks (And How to Fix It)

#database #performance #postgres #sql

4 min read

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