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.
The Missing Layer Between Data and AI Agents

The Missing Layer Between Data and AI Agents

Comments
13 min read
🗄️ SQLite3 in Python

🗄️ SQLite3 in Python

Comments
4 min read
Database troubleshooting for Umami

Database troubleshooting for Umami

Comments
6 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
A Complete Guide to MariaDB: Architecture, Features, Installation, and Best Practices

A Complete Guide to MariaDB: Architecture, Features, Installation, and Best Practices

Comments
4 min read
Pandas Task:

Pandas Task:

3
Comments
1 min read
MyScaleDB: Why Vector Databases Need SQL (The 2025 Reality Check)

MyScaleDB: Why Vector Databases Need SQL (The 2025 Reality Check)

9
Comments 2
10 min read
I Built a Tool to Turn Any SQL Dump File into a Live Database in Seconds

I Built a Tool to Turn Any SQL Dump File into a Live Database in Seconds

Comments
2 min read
How did I learn about Transaction Log, Redo Log, and Undo Log as a developer?

How did I learn about Transaction Log, Redo Log, and Undo Log as a developer?

Comments
1 min read
Building a FHIR Vector Repository with InterSystems IRIS and Python through the IRIStool module

Building a FHIR Vector Repository with InterSystems IRIS and Python through the IRIStool module

Comments
5 min read
GoREST is dead...

GoREST is dead...

1
Comments
4 min read
The Future of Data-Native & Grounded AI with MindsDB: Moving Data to Models No Longer Makes Sense

The Future of Data-Native & Grounded AI with MindsDB: Moving Data to Models No Longer Makes Sense

5
Comments
8 min read
Entenda os JOINS no SQL e como aplicar certo tipo para cada cenário

Entenda os JOINS no SQL e como aplicar certo tipo para cada cenário

Comments
1 min read
Leveraging Service Stored Procedures (SSPs) in Uniface 10.4

Leveraging Service Stored Procedures (SSPs) in Uniface 10.4

Comments
3 min read
Commenting in MySQL: Syntax, Hints, and Practical Examples

Commenting in MySQL: Syntax, Hints, and Practical Examples

Comments
2 min read
Data Locality vs. Independence: Which Should Your Database Prioritize?

Data Locality vs. Independence: Which Should Your Database Prioritize?

1
Comments
10 min read
Nested Loop and Hash Join for MongoDB $lookup

Nested Loop and Hash Join for MongoDB $lookup

17
Comments 1
10 min read
loading...