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.
BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL
jedidah_ondiso_887753d76e profile

BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

#backend #database #sql #tutorial
1
Comments
5 min read
Migrating 200 Million Records in .NET without crashing production: From Row-by-Row to a Crash-Safe Batched Pipeline
arash_zand profile

Migrating 200 Million Records in .NET without crashing production: From Row-by-Row to a Crash-Safe Batched Pipeline

#dotnet #csharp #sql #postgres
Comments
7 min read
Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning
ameer_abdullah_68d48c8496 profile

Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning

#sql #datascience #software #saas
1
Comments
3 min read
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
Building a School Database with PostgreSQL: My SQL Week 2 Journey
angellicah_2ed8aa8f01f176 profile

Building a School Database with PostgreSQL: My SQL Week 2 Journey

#sql #postgressql #database #dataengineering
1
Comments
4 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
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
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
# AI-Generated SQL Has a Silent Failure Problem. Here's a Way to Catch It.
chetanchirag24 profile

# AI-Generated SQL Has a Silent Failure Problem. Here's a Way to Catch It.

#sql #ai #dataengineering #machinelearning
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
Where Should the Foreign Key Go?
hugodcarmo profile

Where Should the Foreign Key Go?

#database #architecture #sql #databasedesign
Comments
6 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.