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.
Top 5 SQL questions asked in interviews

Top 5 SQL questions asked in interviews

5
Comments
4 min read
Planning and creating a database before you start working on your backend can save you time

Planning and creating a database before you start working on your backend can save you time

Comments
1 min read
DuckDB in Action

DuckDB in Action

11
Comments
2 min read
Finding Tables Without Primary Keys in PostgreSQL Databases

Finding Tables Without Primary Keys in PostgreSQL Databases

Comments
4 min read
AI-Driven Content Retrieval with PostgreSQL, Ollama and Open-Source models

AI-Driven Content Retrieval with PostgreSQL, Ollama and Open-Source models

30
Comments 2
3 min read
In-Memory Databases vs. Relational Databases: Key Advantages and Use Cases

In-Memory Databases vs. Relational Databases: Key Advantages and Use Cases

1
Comments
7 min read
Idempotency in DynamoDB

Idempotency in DynamoDB

26
Comments 2
12 min read
Dynamic SQL in PL/SQL

Dynamic SQL in PL/SQL

7
Comments 1
2 min read
Weekly Updates - Nov 8, 2024

Weekly Updates - Nov 8, 2024

1
Comments
1 min read
Intro to SQL using Apache Iceberg and Dremio

Intro to SQL using Apache Iceberg and Dremio

4
Comments
22 min read
How to use Prisma Postgres 🚀

How to use Prisma Postgres 🚀

19
Comments 6
3 min read
System design | High Level Design and Low Level Design | Part 2

System design | High Level Design and Low Level Design | Part 2

5
Comments
2 min read
Collection and Record | Context of Oracle SQL

Collection and Record | Context of Oracle SQL

5
Comments
2 min read
GBase数据库 | GBase 8s Database: Understanding the LISTAGG Function

GBase数据库 | GBase 8s Database: Understanding the LISTAGG Function

5
Comments
4 min read
GBASE数据库 | GBase 8a MPP Cluster Cluster Management Tool (2)

GBASE数据库 | GBase 8a MPP Cluster Cluster Management Tool (2)

5
Comments
11 min read
How I Went From Being a DBA to DevOps Engineer

How I Went From Being a DBA to DevOps Engineer

Comments
1 min read
How to Move Data From MySQL to Redis in Real Time

How to Move Data From MySQL to Redis in Real Time

2
Comments
3 min read
How to self-host Postgres Database on Linux

How to self-host Postgres Database on Linux

2
Comments
3 min read
Accelerating ClippyAI with Embedding LLM and Vector Database

Accelerating ClippyAI with Embedding LLM and Vector Database

1
Comments 1
4 min read
What is ORM

What is ORM

Comments
1 min read
Cut AWS Costs by 90%: How We Saved Big and Gained Flexibility

Cut AWS Costs by 90%: How We Saved Big and Gained Flexibility

Comments
7 min read
What's behind the Call Home option?

What's behind the Call Home option?

1
Comments
2 min read
Layer 4 vs Layer 7 Load Balancer

Layer 4 vs Layer 7 Load Balancer

6
Comments 1
4 min read
Concurrency and Consistency: Juggling Multiple Users Without Missing a Beat

Concurrency and Consistency: Juggling Multiple Users Without Missing a Beat

7
Comments
6 min read
How to Access Databases using One SQL Statement #eg71

How to Access Databases using One SQL Statement #eg71

6
Comments
1 min read
loading...