Skip to content

DEV Community

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.

Chandrashekhar Kachawa

Dec 31 '25

A Practical Guide to Backing Up Your Linux Server: PostgreSQL, Jenkins, and More

#sql #backup #ubuntu #beginners

4 min read

dss99911

Dec 31 '25

MySQL 기초 - 명령어, DDL, 테이블 관리

#backend #database #mysql #sql

1 min read

dss99911

Dec 31 '25

MySQL 쿼리 완벽 가이드 - SELECT, INSERT, UPDATE, JOIN

#backend #database #mysql #sql

1 min read

Dec 29 '25

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

#sql #rag #llm #texttosql

7 min read

MindsDB Team for MindsDB

Dec 29 '25

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

#mariadb #sql #ai #analytics

11 min read

Dec 29 '25

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

#webdev #laravel #programming #sql

1 min read

SQLFlash

Dec 29 '25

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

#sql #mysql #sqlflash

5 min read

Aviral Srivastava

Dec 28 '25

Database Migrations and ORM in Go (GORM, sqlc)

#database #go #sql #tutorial

9 min read

Benjamin Ibrulj

Dec 29 '25

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

#dataengineering #python #opensource #sql

1 min read

Li

Dec 28 '25

easy-query: The Most Powerful ORM Subquery for Java

#database #java #opensource #sql

5 min read

Jan 1

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

#sql #kotlin

3 min read

MindsDB Team for MindsDB

Dec 29 '25

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

#ai #sql #agents

14 min read

Dec 24 '25

Best Practices for Connecting LLMs to SQL Databases

#security #llm #sql #architecture

5 min read

Hemanath Kumar J

Dec 24 '25

SQL - Index Optimization - Complete Guide

#tutorial #sql #database #optimization

2 min read

Jan 13

SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

#database #postgres #beginners #sql

3 min read

Florian

Dec 27 '25

Week 4_b of 40 – Adding Persistence with SQLite

#python #database #backend #sql

1 min read

Tech Croc

Dec 28 '25

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

#sql #postgres #alloydb #googlecloud

4 min read

Tech Croc

Dec 28 '25

Google Cloud SQL: The Ultimate Guide to Managed Relational Databases

#cloud #sql #sqlserver #database

4 min read

Jan 5

Why is offset pagination slow

#backend #database #performance #sql

2 min read

Li

Dec 22 '25

easy-query vs jOOQ

#java #database #sql #architecture

6 min read

InterSystems Developer for InterSystems

Dec 22 '25

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

#sql #tutorial #vectordatabase #programming

4 min read

Dec 22 '25

DCL & TCL in SQL

#webdev #sql #ai #programming

2 min read

Dec 22 '25

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

#sql #database #tutorial #learning

2 min read

Franz

Dec 21 '25

Uniface 10.4 + Informix: Simple Guide to Stored Procedures 🚀

#database #sql #performance #tutorial

4 min read

Mukesh B

Dec 22 '25

Amazon RDS vs Amazon DYNAMODB

#database #aws #sql #architecture

2 min read

loading...