DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SQL And PHP: People whose birthday is today

SQL And PHP: People whose birthday is today

Comments
1 min read
Oracle AI Database 26ai: Utilizing Memoptimized Rowstore Without Setting a Hint

Oracle AI Database 26ai: Utilizing Memoptimized Rowstore Without Setting a Hint

Comments 1
2 min read
AWS KMS Customer Managed Key (CMK) for DB Integration

AWS KMS Customer Managed Key (CMK) for DB Integration

Comments
3 min read
Slow SQL? Diagnose & Fix Bottlenecks Fast!

Slow SQL? Diagnose & Fix Bottlenecks Fast!

Comments
6 min read
Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

1
Comments
8 min read
$lookup: more than just a SQL join (understand performance)

$lookup: more than just a SQL join (understand performance)

8
Comments 1
5 min read
The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck

The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck

Comments
2 min read
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

Comments
3 min read
Free PostgreSQL Hosting Now Available – Public Access Included

Free PostgreSQL Hosting Now Available – Public Access Included

Comments 1
3 min read
Which LLM writes the best SQL?

Which LLM writes the best SQL?

Comments
10 min read
Why the Future of Stream Processing Is Rust + Iceberg + Postgres + S3

Why the Future of Stream Processing Is Rust + Iceberg + Postgres + S3

Comments
2 min read
Create Columns from Distinct Values of a Column — From SQL to SPL #26

Create Columns from Distinct Values of a Column — From SQL to SPL #26

6
Comments 1
1 min read
Understanding Database Schema Structure for Beginners

Understanding Database Schema Structure for Beginners

1
Comments
4 min read
Educational Credentials in the Digital Age: Ensuring Authenticity and Portability

Educational Credentials in the Digital Age: Ensuring Authenticity and Portability

Comments
3 min read
Why Transactional Databases Matter: Concepts, Use Cases, and Examples

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

2
Comments 2
3 min read
How to Think in Access Patterns First With DynamoDB

How to Think in Access Patterns First With DynamoDB

Comments
3 min read
Why Postgres is Your App’s Secret Superpower (And Why You’re Overcomplicating Everything)

Why Postgres is Your App’s Secret Superpower (And Why You’re Overcomplicating Everything)

Comments 1
4 min read
🚀 Boosting React Native Performance with Caching — Made Simple

🚀 Boosting React Native Performance with Caching — Made Simple

Comments 1
3 min read
How I Got x311 Faster Analytics on 110M Rows

How I Got x311 Faster Analytics on 110M Rows

Comments
3 min read
How Excel is Used in Real-World Data Analysis

How Excel is Used in Real-World Data Analysis

4
Comments 2
3 min read
Oracle AI Database 26ai — Storing Flashback Logs Outside FRA

Oracle AI Database 26ai — Storing Flashback Logs Outside FRA

Comments
2 min read
Substring from a Column of Strings — From SQL to SPL #25

Substring from a Column of Strings — From SQL to SPL #25

5
Comments 1
2 min read
Total under Recursive Relationship — From SQL to SPL #33

Total under Recursive Relationship — From SQL to SPL #33

7
Comments 1
2 min read
Learning PostgreSQL

Learning PostgreSQL

Comments
2 min read
Importing Excel with multiple headers into a database

Importing Excel with multiple headers into a database

Comments
1 min read
loading...