Skip to content

Forem

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Cover image for Best Practices for Connecting LLMs to SQL Databases

Dec 24

Best Practices for Connecting LLMs to SQL Databases

#security #llm #sql #architecture

5 min read

Hemanath Kumar J

Dec 24

SQL - Index Optimization - Complete Guide

#tutorial #sql #database #optimization

2 min read

Li

Dec 22

easy-query vs jOOQ

#java #database #sql #architecture

6 min read

InterSystems Developer for InterSystems

Dec 22

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

#sql #tutorial #vectordatabase #programming

4 min read

Dec 22

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

#sql #database #tutorial #learning

2 min read

Dec 22

DCL & TCL in SQL

#webdev #sql #ai #programming

2 min read

Franz

Dec 21

Uniface 10.4 + Informix: Simple Guide to Stored Procedures 🚀

#database #sql #performance #tutorial

4 min read

Cover image for Amazon RDS vs Amazon DYNAMODB

Mukesh B

Dec 22

Amazon RDS vs Amazon DYNAMODB

#database #aws #sql #architecture

2 min read

Franz

Dec 21

Uniface 10.4 + Informix: Simple Guide to DSQL Support 🧩

#database #sql #tutorial

3 min read

Safwan Abdulghani

Dec 20

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

#dotnet #csharp #sql #database

10 min read

Cover image for “How I Built an End-to-End ETL Pipeline Using Databricks & Delta Lake”

Khandare Shubham

Dec 19

“How I Built an End-to-End ETL Pipeline Using Databricks & Delta Lake”

#databricks #sql #pyspark #etl

2 min read

Cover image for SQL Interview Prep: Last-Minute Brushup for Experienced Professionals

Data Tech Bridge

Dec 18

SQL Interview Prep: Last-Minute Brushup for Experienced Professionals

#career #interview #sql

13 min read

Cover image for How SQLite Replaced PostgreSQL as My First Choice

Wolfgang Rathgeb

Dec 15

How SQLite Replaced PostgreSQL as My First Choice

#sql #database #programming

4 min read

Cover image for From CSV to Insights: Analysing Walmart Sales with Python & PostgreSQL

Akanle Tolulope

Dec 15

From CSV to Insights: Analysing Walmart Sales with Python & PostgreSQL

#database #python #sql #beginners

2 min read

Cristian Sifuentes

Dec 19

Entity Framework Core Raw SQL — From FromSql() to Production‑Grade Safety

#dotnet #csharp #entityframework #sql

3 min read

Cover image for SQL Injection Audit Challenge Week 1

fosres

Dec 13

SQL Injection Audit Challenge Week 1

#security #sql #python #appsec

27 min read

Prabhu

Dec 17

Why Your Fast PostgreSQL Query Suddenly Became Slow: A Deep Dive into MVCC and Index Bloat

#database #performance #postgres #sql

5 min read

Mahmoud Ramadan

Dec 13

Two Overlooked Laravel Features: `fresh()` and Attribute Visibility

#php #laravel #sql #community

1 min read

Cover image for 5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

Yukti Sahu

Dec 14

5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

#tutorial #beginners #sql #database

4 min read

Prashant Sharma

Dec 11

DuckDB: how to fine tune parameters?

#database #performance #tutorial #sql

2 min read

Michal Cyncynatus

Dec 23

When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL

#postgres #sql #database #performance

8 min read

SGTSanjay

Dec 11

How I Reduced a 53-Minute MySQL Job to 15 Minutes on MySQL 5.7 (Without Changing Hardware)

#database #performance #sql

1 min read

Cover image for The One Thing You Can't Refactor: How to Architect Bulletproof Database Schemas with AI

Hui

Dec 15

The One Thing You Can't Refactor: How to Architect Bulletproof Database Schemas with AI

#database #sql #architecture #systemdesign

5 min read

Dec 11

sql9

#help #database #sql

2 min read

Dec 11

sql2

#cli #sql #tooling

1 min read

loading...