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.
One Practical SQL Trigger Example You Can Actually Use
baldwin_apps profile

One Practical SQL Trigger Example You Can Actually Use

#sql #database #dataengineering #programming
Comments
6 min read
Maybe SQLite Is Still Better Than DuckDB for My Workloads
soytuber profile
soy

Maybe SQLite Is Still Better Than DuckDB for My Workloads

#database #sqlite #duckdb #sql
Comments
8 min read
The Hard Truth About Choosing a Database and Why Most Projects Get It Wrong
charity254 profile

The Hard Truth About Choosing a Database and Why Most Projects Get It Wrong

#database #buildinpublic #sql
1
Comments
4 min read
A-Z Database Glossary
preetid profile

A-Z Database Glossary

#database #beginners #basic #sql
Comments
17 min read
SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro
vivekdraxlr profile

SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro

#sql #database #postgres #dataengineering
Comments
6 min read
Leveling up: Adding SQLite Persistence to my Rust Guessing Game
uc_yussy profile
Yussy

Leveling up: Adding SQLite Persistence to my Rust Guessing Game

#rust #sql
Comments
1 min read
Automate Cloud Monitoring and Alerts: A Complete Guide
maria_harger_9eb67f1e777f profile

Automate Cloud Monitoring and Alerts: A Complete Guide

#tutorial #software #sql #development
Comments
4 min read
In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here
random_coco profile
Coco

In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here

#ai #sql #database #opensource
Comments
4 min read
Understanding SQL Joins and SQL Functions, CTEs and Subqueries.
josengash profile

Understanding SQL Joins and SQL Functions, CTEs and Subqueries.

#beginners #database #sql #tutorial
Comments
4 min read
Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.
baldwin_apps profile

Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.

#sql #database #programming #beginners
Comments
3 min read
SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning
soytuber profile
soy

SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning

#database #sql #sqlite
Comments
3 min read
How to Migrate MySQL to PostgreSQL Without Breaking Everything (With Real Examples)
rehman_afzal_536 profile

How to Migrate MySQL to PostgreSQL Without Breaking Everything (With Real Examples)

#database #postgressql #mysql #sql
Comments
5 min read
Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)
fanduzi profile
Fan()

Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

#showdev #cli #database #sql
2
Comments
8 min read
Stop Hardcoding Country Lists — Use a Proper World Geo Dataset (MySQL + JSON + CSV)
rakshitshah94 profile

Stop Hardcoding Country Lists — Use a Proper World Geo Dataset (MySQL + JSON + CSV)

#webdev #database #sql #beginners
1
Comments
3 min read
We Ran One SQL Query… And Broke Production
cicd_samurai profile

We Ran One SQL Query… And Broke Production

#devops #database #sql #security
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.