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 a Realistic Banking Dummy Data Generator with Bad-Data Simulation

Building a Realistic Banking Dummy Data Generator with Bad-Data Simulation

Comments
1 min read
easy-query: The Most Powerful ORM Subquery for Java

easy-query: The Most Powerful ORM Subquery for Java

Comments
5 min read
Kapper 1.6: Faster Performance, Bulk Operations, and a Brand New Documentation Site

Kapper 1.6: Faster Performance, Bulk Operations, and a Brand New Documentation Site

1
Comments
3 min read
Streamline Financial Analysis with MindsDB’s Knowledge Bases and Hybrid Search

Streamline Financial Analysis with MindsDB’s Knowledge Bases and Hybrid Search

1
Comments
14 min read
AbeMon MS SQL Tool v1.0.0 Monitor and Debug

AbeMon MS SQL Tool v1.0.0 Monitor and Debug

5
Comments
3 min read
Goodbye NoSQL: Why I Migrated My Stack from Firebase to Supabase.

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

1
Comments
2 min read
Case Study: Data-Driven Pricing Strategy for Toman Bike Share🚲📊

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

1
Comments
4 min read
How Real Databases Work Internally ?

How Real Databases Work Internally ?

2
Comments
3 min read
The Dangerous Elegance of ActiveRecord::Store

The Dangerous Elegance of ActiveRecord::Store

Comments
3 min read
SQL Restaurant Kitchen ---Indexes and Partitions

SQL Restaurant Kitchen ---Indexes and Partitions

9
Comments 1
9 min read
Google BigQuery Cost Optimization: 7 Proven Strategies to Slash Your 2026 Cloud Bill

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

6
Comments
3 min read
PostgreSQL RLS in Go: Architecting Secure Multi-tenancy

PostgreSQL RLS in Go: Architecting Secure Multi-tenancy

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

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

3
Comments
4 min read
Best Practices for Connecting LLMs to SQL Databases

Best Practices for Connecting LLMs to SQL Databases

1
Comments
5 min read
SQL - Index Optimization - Complete Guide

SQL - Index Optimization - Complete Guide

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.