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.
isql

isql

Comments
1 min read
База Данных 5 Views

База Данных 5 Views

Comments
3 min read
Building a Hybrid Site Generator with Go + SQLite

Building a Hybrid Site Generator with Go + SQLite

1
Comments
1 min read
AI-Driven SQL Dataset Optimization 202509: REEF&text2SQL4PM

AI-Driven SQL Dataset Optimization 202509: REEF&text2SQL4PM

1
Comments
4 min read
Free SQL courses for beginners in 2026

Free SQL courses for beginners in 2026

Comments
4 min read
Build a Customer Support AI Agent with smolagents + InterSystems IRIS (SQL, RAG & Interoperability)

Build a Customer Support AI Agent with smolagents + InterSystems IRIS (SQL, RAG & Interoperability)

Comments
5 min read
Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

2
Comments
3 min read
MySQL学习

MySQL学习

Comments
2 min read
Entendendo Flyway

Entendendo Flyway

Comments
2 min read
Understanding MySQL Backup Consistency: A Practical Example

Understanding MySQL Backup Consistency: A Practical Example

Comments
2 min read
Understanding Primary Keys in Relational Databases: A Key to Data Integrity and Fast Lookups

Understanding Primary Keys in Relational Databases: A Key to Data Integrity and Fast Lookups

2
Comments
3 min read
🗄️ SQLite3 in Python

🗄️ SQLite3 in Python

Comments
4 min read
Stop Waiting for the Cloud: Building a Hybrid SQL+Python Data Pipeline Locally with DuckDB

Stop Waiting for the Cloud: Building a Hybrid SQL+Python Data Pipeline Locally with DuckDB

Comments
5 min read
When Your Database Became a Library: Guide to PostgreSQL Indexes

When Your Database Became a Library: Guide to PostgreSQL Indexes

Comments
13 min read
How We Reduced 98.9% Load Time for a Tableau Dashboard: Optimizing OR Conditions with the IN Function

How We Reduced 98.9% Load Time for a Tableau Dashboard: Optimizing OR Conditions with the IN Function

5
Comments
7 min read
Run Your AI Agent with InterSystems IRIS and Local Models using Ollama

Run Your AI Agent with InterSystems IRIS and Local Models using Ollama

1
Comments
3 min read
Automate PostgreSQL & MySQL Database Management on Linux Servers

Automate PostgreSQL & MySQL Database Management on Linux Servers

1
Comments
2 min read
Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before

Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before

1
Comments
6 min read
Unlocking Salesforce CRM Intelligence with MindsDB’s AI Powered Knowledge Bases

Unlocking Salesforce CRM Intelligence with MindsDB’s AI Powered Knowledge Bases

Comments 1
14 min read
Level Up Your SQL Skills: 8 Interactive Games That Make Learning Fun

Level Up Your SQL Skills: 8 Interactive Games That Make Learning Fun

5
Comments
4 min read
Why I am Building an alternative to PostgREST

Why I am Building an alternative to PostgREST

1
Comments
5 min read
Announcing Cloud SQL free trial instances: Experience the power of a fully managed database

Announcing Cloud SQL free trial instances: Experience the power of a fully managed database

137
Comments
3 min read
MariaDB Database — Complete Technical Guide (Architecture, Internals, Advanced Usage)

MariaDB Database — Complete Technical Guide (Architecture, Internals, Advanced Usage)

1
Comments
4 min read
Pandas Task:

Pandas Task:

3
Comments
1 min read
Amazon Cloud Solutions Architect Shows You How to Migrate Data to Amazon Aurora DSQL Using Apache SeaTunnel

Amazon Cloud Solutions Architect Shows You How to Migrate Data to Amazon Aurora DSQL Using Apache SeaTunnel

Comments
4 min read
loading...