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.
What Has To Be True Before You Trust An AI Data Agent
paulcrinigan profile

What Has To Be True Before You Trust An AI Data Agent

#ai #data #sql #agents
2
Comments 2
3 min read
Postrges: Stop Fighting schema.sql — Export PostgreSQL into a Clean, Git-Friendly Project Structure
roman_shevel_a41af9e39d8a profile

Postrges: Stop Fighting schema.sql — Export PostgreSQL into a Clean, Git-Friendly Project Structure

#postgres #database #sql #devops
Comments 2
1 min read
SQL Execution Order Internals: Why WHERE Fails on Aliases but ORDER BY Succeeds
arpitmbangre profile

SQL Execution Order Internals: Why WHERE Fails on Aliases but ORDER BY Succeeds

#sql #database #dataengineering #backend
1
Comments 2
1 min read
Why SQL Is Still the Most Important Skill for Data Engineers
akonagalla28 profile

Why SQL Is Still the Most Important Skill for Data Engineers

#dataengineering #sql #python #programming
Comments
3 min read
Why I Built SeedSQL: Generating Schema-Aware Synthetic Data Without Leaking PII
dhanush_gowda_f54b58cdea6 profile

Why I Built SeedSQL: Generating Schema-Aware Synthetic Data Without Leaking PII

#database #sql #devtools #webdev
Comments 2
2 min read
Lucidchart ERD Alternative: A Desktop ERD Tool That Connects to Your Database
tbson87 profile

Lucidchart ERD Alternative: A Desktop ERD Tool That Connects to Your Database

#database #sql #tooling #programming
Comments
10 min read
An ERD MCP Server: AI Agents That Follow Your Naming Standard
sqemo profile

An ERD MCP Server: AI Agents That Follow Your Naming Standard

#ai #mcp #database #sql
Comments
5 min read
Building an Interactive Sales Dashboard with Power BI and PostgreSQL
ron-njuguna profile

Building an Interactive Sales Dashboard with Power BI and PostgreSQL

#analytics #data #database #sql
Comments
2 min read
Scythe: SQL as a first-class language (and where that leaves your ORM)
nhirschfeld profile

Scythe: SQL as a first-class language (and where that leaves your ORM)

#sql #rust #database #opensource
1
Comments 2
7 min read
Redesigning Organizational Hierarchy Queries in HR Platforms
shubhamshaw profile

Redesigning Organizational Hierarchy Queries in HR Platforms

#architecture #sql #backend #database
Comments 1
1 min read
SQL to Cypher - 10 Queries You Already Know
jeremycmorgan profile

SQL to Cypher - 10 Queries You Already Know

#data #database #neo4j #sql
1
Comments
14 min read
Comparing Staging and Production Database Schemas Side by Side
tbson87 profile

Comparing Staging and Production Database Schemas Side by Side

#database #devops #sql #postgres
Comments
6 min read
SQL for Beginners: Building a Mini School Database from Scratch!
neema_kirui profile

SQL for Beginners: Building a Mini School Database from Scratch!

#sql #postgres #database #beginners
Comments
5 min read
Why ERD Tools Draw Your 1:1 Relationship as 1:N
tbson87 profile

Why ERD Tools Draw Your 1:1 Relationship as 1:N

#database #sql #mysql #postgres
Comments
6 min read
Text2SqlTalent in Solon AI: Safe Natural-Language Database Agents
solonjava profile

Text2SqlTalent in Solon AI: Safe Natural-Language Database Agents

#agents #ai #llm #sql
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.