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.
MySQL & MindsDB Unlocks Intelligent Content Discovery For Web CMS with Knowledge Bases and Cursor

MySQL & MindsDB Unlocks Intelligent Content Discovery For Web CMS with Knowledge Bases and Cursor

Comments
11 min read
How to Build a Text-to-SQL Agent With RAG, LLMs, and SQL Guards

How to Build a Text-to-SQL Agent With RAG, LLMs, and SQL Guards

Comments
7 min read
MariaDB & MindsDB Turns WooCommerce Data to Insights with Real-Time AI Analytics for eCommerce Teams

MariaDB & MindsDB Turns WooCommerce Data to Insights with Real-Time AI Analytics for eCommerce Teams

Comments
11 min read
How do I get the query builder to output its raw SQL query as a string?

How do I get the query builder to output its raw SQL query as a string?

Comments
1 min read
Stop Using NOT EXISTS? Unveiling the Optimization Secrets of LEFT JOIN Anti-Join

Stop Using NOT EXISTS? Unveiling the Optimization Secrets of LEFT JOIN Anti-Join

Comments
5 min read
Database Migrations and ORM in Go (GORM, sqlc)

Database Migrations and ORM in Go (GORM, sqlc)

Comments
9 min read
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
EP 13: SQL Injection Isn't Dead - It Just Evolved

EP 13: SQL Injection Isn't Dead - It Just Evolved

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
Best Practices for Connecting LLMs to SQL Databases

Best Practices for Connecting LLMs to SQL Databases

1
Comments
5 min read
I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.

I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.

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

SQL - Index Optimization - Complete Guide

Comments
2 min read
Week 4_b of 40 – Adding Persistence with SQLite

Week 4_b of 40 – Adding Persistence with SQLite

Comments
1 min read
AlloyDB for PostgreSQL: The Ultimate Guide to Google’s Hyper-Scale Database

AlloyDB for PostgreSQL: The Ultimate Guide to Google’s Hyper-Scale Database

6
Comments 1
4 min read
Google Cloud SQL: The Ultimate Guide to Managed Relational Databases

Google Cloud SQL: The Ultimate Guide to Managed Relational Databases

5
Comments
4 min read
easy-query vs jOOQ

easy-query vs jOOQ

Comments
6 min read
How I Create PDF Reports from SQL Server in C# Using IronPDF (Beginner Guide)

How I Create PDF Reports from SQL Server in C# Using IronPDF (Beginner Guide)

Comments
5 min read
Questionnaire Made Easy – with IRIS, FHIR SQL Builder, and Vector Search

Questionnaire Made Easy – with IRIS, FHIR SQL Builder, and Vector Search

Comments
4 min read
DCL & TCL in SQL

DCL & TCL in SQL

1
Comments
2 min read
Company-Level SQL Learning Mode Now Available on SQL Practice Online

Company-Level SQL Learning Mode Now Available on SQL Practice Online

Comments
2 min read
Uniface 10.4 + Informix: Simple Guide to Stored Procedures 🚀

Uniface 10.4 + Informix: Simple Guide to Stored Procedures 🚀

Comments
4 min read
Amazon RDS vs Amazon DYNAMODB

Amazon RDS vs Amazon DYNAMODB

Comments
2 min read
Uniface 10.4 + Informix: Simple Guide to DSQL Support 🧩

Uniface 10.4 + Informix: Simple Guide to DSQL Support 🧩

Comments
3 min read
RoomSharp v0.4.3: Production-grade migrations, safe-by-default concurrency, and new companion packages

RoomSharp v0.4.3: Production-grade migrations, safe-by-default concurrency, and new companion packages

Comments
10 min read
loading...