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.
Goodbye NoSQL: Why I Migrated My Stack from Firebase to Supabase.
frankdotdev profile

Goodbye NoSQL: Why I Migrated My Stack from Firebase to Supabase.

#supabase #firebase #sql #nosql
1
Comments
2 min read
Case Study: Data-Driven Pricing Strategy for Toman Bike Share🚲📊
rahimah_dev profile

Case Study: Data-Driven Pricing Strategy for Toman Bike Share🚲📊

#sql #powerbi #dataanalytics #datavisualization
1
Comments
4 min read
How Real Databases Work Internally ?
farhadrahimiklie profile

How Real Databases Work Internally ?

#database #data #sql #nosql
2
Comments
3 min read
The Dangerous Elegance of ActiveRecord::Store
zilton7 profile

The Dangerous Elegance of ActiveRecord::Store

#rails #architecture #sql #designpatterns
Comments
3 min read
Full-Text Indexing in MySQL: A Developer's Guide
hinlocaesar profile

Full-Text Indexing in MySQL: A Developer's Guide

#webdev #sql
Comments
7 min read
How to Create Indexes in MySQL: A Complete Guide
hinlocaesar profile

How to Create Indexes in MySQL: A Complete Guide

#mysql #ddatabase #performance #sql
Comments
5 min read
SQL Restaurant Kitchen ---Indexes and Partitions
igornosatov_15 profile

SQL Restaurant Kitchen ---Indexes and Partitions

#database #performance #sql
9
Comments 1
9 min read
Google BigQuery Cost Optimization: 7 Proven Strategies to Slash Your 2026 Cloud Bill
tech_croc_f32fbb6ea8ed4 profile

Google BigQuery Cost Optimization: 7 Proven Strategies to Slash Your 2026 Cloud Bill

#bigquery #programming #sql #mariadb
7
Comments
3 min read
PostgreSQL RLS in Go: Architecting Secure Multi-tenancy
__8fa66572 profile

PostgreSQL RLS in Go: Architecting Secure Multi-tenancy

#go #sql #rls #programming
Comments
6 min read
The Object-Relational Impedance Mismatch: Why Your Java Objects and Database Tables Don't Play Nice
phouchens profile

The Object-Relational Impedance Mismatch: Why Your Java Objects and Database Tables Don't Play Nice

#java #hibernate #sql #springboot
4
Comments
4 min read
SQL - Index Optimization - Complete Guide
hkj13 profile

SQL - Index Optimization - Complete Guide

#tutorial #sql #database #optimization
Comments
2 min read
Solving the N+1 Query Problem: A Developer's Guide to Database Performance
vasughanta09 profile

Solving the N+1 Query Problem: A Developer's Guide to Database Performance

#webdev #sql #postgres #productivity
2
Comments
7 min read
Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)
jsontotable profile

Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

#json #sql #postgres #mysql
Comments
4 min read
Tu Nube como una Base de Datos: Guía Práctica de Steampipe para AWS
kevinlupera profile

Tu Nube como una Base de Datos: Guía Práctica de Steampipe para AWS

#aws #security #sql
5
Comments
4 min read
Learning SQL Server the Hard Way: 16 Days of Real-World Database Work
lfariaus profile

Learning SQL Server the Hard Way: 16 Days of Real-World Database Work

#sql #sqlserver #database #dataengineering
6
Comments 2
8 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.