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
Analyzing Crime against women in India.

Analyzing Crime against women in India.

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

AI-Driven SQL Dataset Optimization 202509: REEF&text2SQL4PM

2
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
Building a Library Management System with SQL: My Journey, Insights, and Best Practices ✨

Building a Library Management System with SQL: My Journey, Insights, and Best Practices ✨

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
Neovim Treesitter highlighting with sql generic types (Typescript)

Neovim Treesitter highlighting with sql generic types (Typescript)

5
Comments 1
3 min read
🗄️ SQLite3 in Python

🗄️ SQLite3 in Python

Comments
4 min read
SQL vs. NoSQL: Choosing a Database Is Like Finding a Partner — Compatibility Matters Most

SQL vs. NoSQL: Choosing a Database Is Like Finding a Partner — Compatibility Matters Most

2
Comments
3 min read
Database troubleshooting for Umami

Database troubleshooting for Umami

Comments
6 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

3
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
Day 5: Advanced SELECT Queries and JOINs

Day 5: Advanced SELECT Queries and JOINs

Comments
3 min read
📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

1
Comments
2 min read
Why I am Building an alternative to PostgREST

Why I am Building an alternative to PostgREST

1
Comments
5 min read
Turso, a Bright Future for SQLite Written From Scratch in Rust

Turso, a Bright Future for SQLite Written From Scratch in Rust

3
Comments
4 min read
Pandas Task:

Pandas Task:

3
Comments
1 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
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
loading...