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 String Functions: Clean, Transform, and Tame Messy Data Like a Pro

SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro

Comments
6 min read
🚀 MongoDB Full Course 2026 (Beginner Advanced) + Free Notes & Code

🚀 MongoDB Full Course 2026 (Beginner Advanced) + Free Notes & Code

1
Comments
1 min read
Common Reasons for INSERT Failures in GBase Databases

Common Reasons for INSERT Failures in GBase Databases

3
Comments
1 min read
GBase 8a Backup and Restore Guide: Full and Incremental Backups with gbackup

GBase 8a Backup and Restore Guide: Full and Incremental Backups with gbackup

2
Comments
3 min read
In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here

In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here

Comments
4 min read
Controlled Oracle Actions with SQLcl MCP

Controlled Oracle Actions with SQLcl MCP

1
Comments 1
9 min read
What is Dremio? The Unified Lakehouse and AI Platform

What is Dremio? The Unified Lakehouse and AI Platform

Comments
5 min read
When Execution Plans Go Wrong in GBase 8a: A Tuning Guide from Statistics to Hints

When Execution Plans Go Wrong in GBase 8a: A Tuning Guide from Statistics to Hints

2
Comments
2 min read
Building Persistent Memory That Makes AI Characters Feel Real

Building Persistent Memory That Makes AI Characters Feel Real

Comments
4 min read
Tuning GBase RTSync for Better Replication Performance

Tuning GBase RTSync for Better Replication Performance

2
Comments
1 min read
Handling Concurrent Access on Tables with Exclusive Locks in GBase 8s

Handling Concurrent Access on Tables with Exclusive Locks in GBase 8s

2
Comments
1 min read
When GBase 8a Execution Plans Go Wrong: Mastering Statistics Management

When GBase 8a Execution Plans Go Wrong: Mastering Statistics Management

2
Comments
4 min read
Understanding SQL Joins and SQL Functions, CTEs and Subqueries.

Understanding SQL Joins and SQL Functions, CTEs and Subqueries.

Comments
4 min read
Practicing “Database Insights”: where to find real schemas?

Practicing “Database Insights”: where to find real schemas?

Comments
1 min read
SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning

SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.