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.
SQLite vs PostgreSQL: Choosing the Right Database
qingluan profile
qing

SQLite vs PostgreSQL: Choosing the Right Database

#database #sql #tutorial #programming
Comments
5 min read
Databricks launches AI agent for legacy SQL migration
vpodk profile

Databricks launches AI agent for legacy SQL migration

#databricks #sql #ai #cloudmigration
3
Comments
4 min read
Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.
votiakov profile

Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.

#bigquery #gcp #dataengineering #sql
Comments 1
3 min read
I built a free, interactive SQL practice tool for data engineering interviews
harishdataengineer profile

I built a free, interactive SQL practice tool for data engineering interviews

#dataengineering #sql #webdev #interview
Comments 1
1 min read
Performance Engineering: What Is the System Waiting For?
tigerbluejay profile
Jose

Performance Engineering: What Is the System Waiting For?

#performance #dotnet #sql #csharp
1
Comments
13 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.