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.
Autoincrement en Oracle

Autoincrement en Oracle

Comments
1 min read
Building a vector database sidecar for semantic search & entity resolution

Building a vector database sidecar for semantic search & entity resolution

1
Comments 1
7 min read
Partial Indexes in MongoDB: A Brief Overview

Partial Indexes in MongoDB: A Brief Overview

3
Comments
2 min read
Demystifying the Internals of PostgreSQL - Chapter 1

Demystifying the Internals of PostgreSQL - Chapter 1

Comments
3 min read
How to implement real-time data sync in your Next.js app with Appwrite Cloud

How to implement real-time data sync in your Next.js app with Appwrite Cloud

5
Comments
6 min read
Global Secondary Index of AntDB-M

Global Secondary Index of AntDB-M

1
Comments
5 min read
Designing and implementing a weather data API

Designing and implementing a weather data API

2
Comments
16 min read
mysql: three things you (probably) didn't know you could do with the mysql command

mysql: three things you (probably) didn't know you could do with the mysql command

3
Comments 1
4 min read
Analyzing LEGO Sets Using a Graph Database

Analyzing LEGO Sets Using a Graph Database

4
Comments
5 min read
Oracle JSON_TABLE: Transforming JSON into Relational Format

Oracle JSON_TABLE: Transforming JSON into Relational Format

3
Comments
2 min read
GraphQL for Beginners

GraphQL for Beginners

23
Comments 2
3 min read
Understanding SQL Commands

Understanding SQL Commands

3
Comments
4 min read
20 databases to pick in 2023 - simplified

20 databases to pick in 2023 - simplified

67
Comments 33
8 min read
MongoDB: Unlocking the Power of Data Storage and Retrieval

MongoDB: Unlocking the Power of Data Storage and Retrieval

15
Comments
3 min read
Database Design: "How to Create a Robust and Scalable Data Model"

Database Design: "How to Create a Robust and Scalable Data Model"

2
Comments
3 min read
Desbravando os Segredos do SQL: Um Guia Completo para Dominar a Linguagem de Bancos de Dados

Desbravando os Segredos do SQL: Um Guia Completo para Dominar a Linguagem de Bancos de Dados

2
Comments
3 min read
YugabyteDB fast path write

YugabyteDB fast path write

1
Comments
9 min read
Understanding Data Compaction in 3 Minutes

Understanding Data Compaction in 3 Minutes

Comments
6 min read
Baserow vs. NocoDB: two open source Airtable alternatives

Baserow vs. NocoDB: two open source Airtable alternatives

Comments
6 min read
Understanding database indices by (poorly) implementing one

Understanding database indices by (poorly) implementing one

Comments
12 min read
Chaos Engineering: Efficient Way to Improve System Availability

Chaos Engineering: Efficient Way to Improve System Availability

Comments
8 min read
How to Start Using psql in Terminal (for Beginners)

How to Start Using psql in Terminal (for Beginners)

5
Comments
3 min read
Why does wide table prevail?

Why does wide table prevail?

5
Comments
13 min read
A Comparative Analysis: PostgreSQL vs. MongoDB

A Comparative Analysis: PostgreSQL vs. MongoDB

Comments
2 min read
How I use Nano ID in Rails

How I use Nano ID in Rails

4
Comments 1
10 min read
How to Check Your PostgreSQL Version

How to Check Your PostgreSQL Version

1
Comments
1 min read
Indexing for LIKE Queries in PostgreSQL

Indexing for LIKE Queries in PostgreSQL

1
Comments
1 min read
Indexing JSON in PostgreSQL

Indexing JSON in PostgreSQL

Comments
1 min read
Terraforming AWS RDS : Scaling Postgres

Terraforming AWS RDS : Scaling Postgres

5
Comments
3 min read
Leveraging the power of Lua scripting with Dragonfly

Leveraging the power of Lua scripting with Dragonfly

1
Comments
7 min read
What is Inverted Index and How We Made Log Analysis 10 Times More Cost-Effective With It

What is Inverted Index and How We Made Log Analysis 10 Times More Cost-Effective With It

1
Comments
9 min read
Simplifying Database Operations with JPA and Hibernate: Creating and Persisting Objects

Simplifying Database Operations with JPA and Hibernate: Creating and Persisting Objects

1
Comments
3 min read
The next era of databases are serverless, adaptive, and collaborative

The next era of databases are serverless, adaptive, and collaborative

11
Comments
6 min read
Base64 and other encodings in SQLite

Base64 and other encodings in SQLite

Comments
2 min read
Predicate Functions in Apache AGE

Predicate Functions in Apache AGE

1
Comments
2 min read
Database schema migrations on AWS with Custom Resources and CDK

Database schema migrations on AWS with Custom Resources and CDK

5
Comments
4 min read
PostgreSQL Crash Course

PostgreSQL Crash Course

10
Comments
3 min read
Introducing SwiftData the successor of CoreData

Introducing SwiftData the successor of CoreData

3
Comments
5 min read
Covering Index in SQL

Covering Index in SQL

2
Comments 3
2 min read
Data Import and Export: Techniques for Streamlining Data Transfer

Data Import and Export: Techniques for Streamlining Data Transfer

2
Comments
2 min read
🛢 9 Free Resources to Learn and Practice SQL

🛢 9 Free Resources to Learn and Practice SQL

12
Comments
8 min read
A Deep Dive into EDB Postgres Advanced Server: Features and Benefits

A Deep Dive into EDB Postgres Advanced Server: Features and Benefits

10
Comments
3 min read
Introducing a Rate Limiting API for Dragonfly

Introducing a Rate Limiting API for Dragonfly

1
Comments
8 min read
Building a Graph-Based Search Engine with Apache AGE

Building a Graph-Based Search Engine with Apache AGE

3
Comments
3 min read
Advanced Query Optimization Techniques in PostgreSQL

Advanced Query Optimization Techniques in PostgreSQL

2
Comments
2 min read
Vector Database: New Hype or Hope for AI's (LLM) and Industry 4.0? :)

Vector Database: New Hype or Hope for AI's (LLM) and Industry 4.0? :)

Comments
1 min read
Creating a Chatbot using the data stored in my huge database

Creating a Chatbot using the data stored in my huge database

2
Comments
2 min read
Logarithmic Functions in Apache AGE

Logarithmic Functions in Apache AGE

Comments
2 min read
5 criteria for data quality and how to test for them

5 criteria for data quality and how to test for them

Comments
6 min read
A/B Testing was a Handful, Until we Found the Replacement for Druid

A/B Testing was a Handful, Until we Found the Replacement for Druid

Comments
5 min read
Shard Key Best Practices: Ensuring Balanced and Efficient Data Distribution

Shard Key Best Practices: Ensuring Balanced and Efficient Data Distribution

2
Comments
4 min read
PGLOADBALANCEHOSTS

PGLOADBALANCEHOSTS

Comments
4 min read
An Intro to Structured Query Language(SQL)

An Intro to Structured Query Language(SQL)

Comments
3 min read
SQL, NoSql, and 5 DB types you'll never need

SQL, NoSql, and 5 DB types you'll never need

19
Comments 3
3 min read
Blog Post 3: Exploration of Scalar Functions in Apache Age

Blog Post 3: Exploration of Scalar Functions in Apache Age

Comments
2 min read
Blog Post 2: More Scalar Functions in Apache Age

Blog Post 2: More Scalar Functions in Apache Age

Comments
2 min read
Blog Post 1: Scalar Functions in Apache Age

Blog Post 1: Scalar Functions in Apache Age

Comments
2 min read
Composite Data types part 2

Composite Data types part 2

1
Comments
2 min read
Backend without ORM

Backend without ORM

11
Comments 2
5 min read
PostgreSQL's Foreign Data Wrappers

PostgreSQL's Foreign Data Wrappers

1
Comments
8 min read
loading...