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.
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
Learning SQL Server the Hard Way: 16 Days of Real-World Database Work

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

2
Comments 2
8 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
Why is offset pagination slow

Why is offset pagination slow

Comments
2 min read
easy-query vs jOOQ

easy-query vs jOOQ

Comments
6 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
SQLNet is A social network that looks like Twitter, but you write SQL to do anything

SQLNet is A social network that looks like Twitter, but you write SQL to do anything

2
Comments
7 min read
The second-highest salary: Why the simplest SQL query is often the smartest

The second-highest salary: Why the simplest SQL query is often the smartest

Comments
4 min read
Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It

Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It

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