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.

Ali Hamza

Jun 27

Day 77 of Learning MERN Stack

#sql #backend #database #programming

1 min read

RODRIGO SIDNEY COLQUE QUISPE

Jun 27

Breaking the SQL Barrier: How to Build a Natural Language Database Assistant

#ai #python #sql #tutorial

2 min read

Jun 26

I Reverse Engineered a Closed-Format App. Everything Was in SQLite.

#database #productivity #software #sql

4 min read

Jun 26

SQL window functions: what separates a mid-level from a senior developer

#sql #postgres #backend #database

5 min read

Jun 26

Prompting AI for Complex Multi-Table SQL: A Practical Guide

#sql #database #ai #tutorial

5 min read

Devanshu Biswas

Jun 25

I Built a Tool That Shows the SQL Behind Any Spring Data Method Name

#spring #java #sql #webdev

2 min read

Vikas Maheshwari

Jun 25

Star Schema vs Snowflake Schema: Which to Use and When

#dataengineering #database #sql #datascience

4 min read

Jun 25

Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

#database #performance #sql #tutorial

2 min read

Dane Wu

Jun 25

A 1000x Speedup From One Index — and Why It Sometimes Does Nothing

#rails #database #sql #performance

7 min read

Serina

Jun 25

When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data

#ai #database #llm #sql

8 min read

Jun 25

Day 1 of My Microsoft Fabric Learning Journey – Exploring Lakehouses

#dataengineering #learning #microsoft #sql

1 min read

Jun 25

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

#sql #database #ai #productivity

6 min read

Zubair Iftikhar

Jun 25

How to Convert Plain Text into JavaScript Arrays, Python Lists, JSON, and SQL IN Clauses

#javascript #productivity #python #sql

8 min read

Jun 24

The Fastest Way to Add Reporting to Your Internal Tool

#sql #database #webdev #productivity

6 min read

Ben Witt

Jun 24

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

#ai #database #postgres #sql

8 min read

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