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.
Prisma relationships, finally explained (with MySQL side by side)
edriso profile

Prisma relationships, finally explained (with MySQL side by side)

#prisma #beginners #database #sql
Comments 1
12 min read
How to Make xt850 Match xt 850
sanikolaev profile

How to Make xt850 Match xt 850

#database #nlp #sql #tutorial
Comments
6 min read
SQLite Internals & Audit Patterns; New Open-Source PostgreSQL UI
soytuber profile
soy

SQLite Internals & Audit Patterns; New Open-Source PostgreSQL UI

#database #sql #sqlite
Comments
4 min read
Elasticsearch & Inverted Indices — The Death of SQL ILIKE (2026)
kaushikcoderpy profile

Elasticsearch & Inverted Indices — The Death of SQL ILIKE (2026)

#elasticsearch #sql #python
Comments
2 min read
1.2.2 Semantic analysis: name resolution, type checking, catalog lookup
joonghyukshin profile

1.2.2 Semantic analysis: name resolution, type checking, catalog lookup

#postgres #database #internals #sql
Comments 1
10 min read
PostgreSQL Plan Signatures: Quick Reference
philip_mcclarence_2ef9475 profile

PostgreSQL Plan Signatures: Quick Reference

#database #performance #postgres #sql
Comments
7 min read
Automating SQL Server Database Administration with T-SQL Utility Scripts
dominic_robinson_ff89e6b5 profile

Automating SQL Server Database Administration with T-SQL Utility Scripts

#automation #database #opensource #sql
Comments
4 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
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
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
SQL Views Explained: Write Once, Query Forever
vivekdraxlr profile

SQL Views Explained: Write Once, Query Forever

#sql #database #postgres #beginners
Comments 1
6 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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.