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.
Capítulo 2 - Modelos de Datos y Lenguajes de Consulta
pabloar profile

Capítulo 2 - Modelos de Datos y Lenguajes de Consulta

#data #sql #nosql #dataengineering
2
Comments
7 min read
Unlocking speed: the power of indexing in database performance
prahladyeri profile

Unlocking speed: the power of indexing in database performance

#webdev #database #mysql #sql
4
Comments
4 min read
Indexing for a Scalable Serialization Isolation Level
franckpachot profile

Indexing for a Scalable Serialization Isolation Level

#sql #yugabytedb #postgres #database
4
Comments 2
5 min read
How to Use Unique Key Constraints in Database Tables
j700abe profile

How to Use Unique Key Constraints in Database Tables

#sql #softwareengineering #database #sqlserver
Comments
2 min read
😻🦾 Top 5 Text2SQL AI Tools in 2024 🤖🔁
op3ratordec profile

😻🦾 Top 5 Text2SQL AI Tools in 2024 🤖🔁

#ai #database #sql #productivity
41
Comments 3
2 min read
Upsert a row in a DB that doesn't use primary keys or unique constraints
tylerlwsmith profile

Upsert a row in a DB that doesn't use primary keys or unique constraints

#mysql #sql
3
Comments
3 min read
Access IRIS database with ODBC or JDBC using Python
intersystemsdev profile

Access IRIS database with ODBC or JDBC using Python

#database #python #sql #documentation
1
Comments
5 min read
ACID properties in SQL
mrcaption49 profile

ACID properties in SQL

#sql #backend #fullstack #webdev
5
Comments
1 min read
How to Use Common Table Expressions (CTEs) to Avoid N+1 Queries in Hierarchical Data
naveed profile

How to Use Common Table Expressions (CTEs) to Avoid N+1 Queries in Hierarchical Data

#performance #postgres #sql #database
1
Comments
5 min read
How to connect and query multiple databases with a single REST API
thadguidry profile

How to connect and query multiple databases with a single REST API

#webdev #api #database #sql
2
Comments
3 min read
Choose the Best Database Management Tool for PostgreSQL in 2025
roxana_haidiner profile

Choose the Best Database Management Tool for PostgreSQL in 2025

#database #postgres #sql #design
10
Comments 4
12 min read
The Ultimate Database Tools with Git in 2025
roxana_haidiner profile

The Ultimate Database Tools with Git in 2025

#database #git #sql #management
12
Comments 4
5 min read
Structured vs. Unstructured Databases: The Ultimate Guide to Understanding the Key Differences
abhinowww profile

Structured vs. Unstructured Databases: The Ultimate Guide to Understanding the Key Differences

#database #coding #sql #learning
2
Comments
3 min read
Functional indices for lightning-fast queries on many-to-many relationship tables
intersystemsdev profile

Functional indices for lightning-fast queries on many-to-many relationship tables

#indexing #sql #beginners #programming
Comments
15 min read
Simplifying SQL View Management in Laravel Migrations
nasrulhazim profile

Simplifying SQL View Management in Laravel Migrations

#laravel #sql
1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.