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.
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
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
Fastest way to count in sql
volland profile

Fastest way to count in sql

#sql
Comments
1 min read
How to pass an Array of Structs in Bigquery's parameterized queries
matthieucham profile

How to pass an Array of Structs in Bigquery's parameterized queries

#bigquery #python #googlecloud #sql
12
Comments 2
3 min read
Optimizing SQL Queries
mrpercival profile

Optimizing SQL Queries

#mysql #sql #mariadb
2
Comments
5 min read
Core PHP CRUD Operations: A Beginner's Tutorial
prahladyeri profile

Core PHP CRUD Operations: A Beginner's Tutorial

#php #database #sql
12
Comments 1
4 min read
Associative Arrays in PL/SQL
mrcaption49 profile

Associative Arrays in PL/SQL

#webdev #javascript #sql #beginners
6
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.