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.
SQLite Expressions: A Complete Guide

SQLite Expressions: A Complete Guide

Comments
4 min read
The RETURNING clause in SQL

The RETURNING clause in SQL

22
Comments 2
2 min read
Exploring Ways of Performance Tuning Your Postgresql Database

Exploring Ways of Performance Tuning Your Postgresql Database

3
Comments
6 min read
Understanding How DynamoDB Scales

Understanding How DynamoDB Scales

11
Comments
12 min read
Schemas em SQL: Indexes e B+ trees

Schemas em SQL: Indexes e B+ trees

5
Comments 2
4 min read
Sql Service Broker

Sql Service Broker

Comments
19 min read
Hummock: A Storage Engine Designed for Stream Processing

Hummock: A Storage Engine Designed for Stream Processing

2
Comments
6 min read
The most important project in the world: Overview

The most important project in the world: Overview

Comments
3 min read
FileMaker vs. Access: A Comparison of Two Popular Database Solutions

FileMaker vs. Access: A Comparison of Two Popular Database Solutions

Comments
15 min read
Automate Database Processes: Supabase Triggers

Automate Database Processes: Supabase Triggers

4
Comments
4 min read
GreptimeDB User Guide — Leveraging our Tools for Efficient PromQL Queries

GreptimeDB User Guide — Leveraging our Tools for Efficient PromQL Queries

Comments
5 min read
Xata's JSON Column Type

Xata's JSON Column Type

2
Comments
5 min read
Announcing the Winners of the Xata Content Hackathon

Announcing the Winners of the Xata Content Hackathon

8
Comments
3 min read
The "Postgres First" Trend

The "Postgres First" Trend

Comments
3 min read
SQLite vs PostgreSQL: Choose the Right Database for Your App

SQLite vs PostgreSQL: Choose the Right Database for Your App

1
Comments
9 min read
How Does Partitioning Work in PostgreSQL and Why Should You Care?

How Does Partitioning Work in PostgreSQL and Why Should You Care?

1
Comments
6 min read
POSTGRESQL PSEUDOCOLUMNS: CTID

POSTGRESQL PSEUDOCOLUMNS: CTID

7
Comments
6 min read
How best to learn RDBMS Part 1

How best to learn RDBMS Part 1

2
Comments
2 min read
Log Analysis: Elasticsearch VS Apache Doris

Log Analysis: Elasticsearch VS Apache Doris

2
Comments
11 min read
Database Normalization: A Simple Tale of Ignoring 1NF

Database Normalization: A Simple Tale of Ignoring 1NF

Comments
7 min read
Recommendation algorithm with vector database

Recommendation algorithm with vector database

6
Comments
4 min read
From Good to Great: Scaling Applications with TypeORM Optimization

From Good to Great: Scaling Applications with TypeORM Optimization

2
Comments
4 min read
Migrating from Oracle to PostgreSQL: A Comprehensive Guide

Migrating from Oracle to PostgreSQL: A Comprehensive Guide

2
Comments
3 min read
Squeezing out MongoDB’s available storage

Squeezing out MongoDB’s available storage

Comments
5 min read
Using MySQL as a NoSQL Document Store - Introduction

Using MySQL as a NoSQL Document Store - Introduction

Comments
7 min read
Neo4j, A Database on Crack 🚬

Neo4j, A Database on Crack 🚬

2
Comments
1 min read
The most important project in the world: Intro

The most important project in the world: Intro

Comments
4 min read
SPL computing performance test series: funnel analysis

SPL computing performance test series: funnel analysis

5
Comments
16 min read
Mastering Data Modeling in PostgreSQL

Mastering Data Modeling in PostgreSQL

1
Comments
2 min read
Harnessing the Power of Apache AGE: Integrating Graph Databases with Business Intelligence Tools

Harnessing the Power of Apache AGE: Integrating Graph Databases with Business Intelligence Tools

1
Comments
3 min read
The Xata Playground Now Runs Python in the Browser

The Xata Playground Now Runs Python in the Browser

3
Comments
4 min read
Exploring the Power of PostgreSQL: Unique Features and Advanced Capabilities

Exploring the Power of PostgreSQL: Unique Features and Advanced Capabilities

Comments
3 min read
🐣 Step-by-Step Guide to Data Masking 🎭

🐣 Step-by-Step Guide to Data Masking 🎭

6
Comments
4 min read
How to Build a Blog API using MongoDB Aggregation Pipeline Framework

How to Build a Blog API using MongoDB Aggregation Pipeline Framework

15
Comments
24 min read
Streaming Queries for Real-Time Analytics in Spring Boot

Streaming Queries for Real-Time Analytics in Spring Boot

1
Comments
3 min read
PostgreSQL and Temporary Tables

PostgreSQL and Temporary Tables

16
Comments
9 min read
ACID and Transactions in SQL

ACID and Transactions in SQL

6
Comments
6 min read
MarkdownDB: A rich SQL API to your markdown files in seconds.

MarkdownDB: A rich SQL API to your markdown files in seconds.

2
Comments
2 min read
Client-side data storage with IndexedDB

Client-side data storage with IndexedDB

1
Comments 1
2 min read
Redefining ETL: Data Flows Powered by C# (Part I)

Redefining ETL: Data Flows Powered by C# (Part I)

10
Comments
11 min read
Building a Robust Backend in Just 30 Minutes with Outerbase

Building a Robust Backend in Just 30 Minutes with Outerbase

Comments
11 min read
PostgreSQL and its ACID features: A Comprehensive Guide

PostgreSQL and its ACID features: A Comprehensive Guide

Comments
3 min read
ReductStore v1.7.0 has been released with provisioning and batch writing

ReductStore v1.7.0 has been released with provisioning and batch writing

10
Comments
2 min read
Data Analysis of the Titanic with Python!

Data Analysis of the Titanic with Python!

49
Comments 1
6 min read
SQLite Create Table If Not Exists: Conditional Table Creation

SQLite Create Table If Not Exists: Conditional Table Creation

Comments
2 min read
Should you use an enum column or a table to store allowed values in SQL?

Should you use an enum column or a table to store allowed values in SQL?

13
Comments 1
5 min read
CRUD Operations in SQL

CRUD Operations in SQL

2
Comments 1
14 min read
SQLite with Python

SQLite with Python

18
Comments 7
7 min read
Storing Salesforce embeddings with pgvector and OpenAI

Storing Salesforce embeddings with pgvector and OpenAI

1
Comments
10 min read
Using the LangChain Integration with a Serverless Database

Using the LangChain Integration with a Serverless Database

1
Comments
4 min read
Discover the Xata SDK for Python

Discover the Xata SDK for Python

3
Comments
3 min read
Top Firebase Alternatives

Top Firebase Alternatives

4
Comments 3
10 min read
Your Free and Offline SQL console in a few steps

Your Free and Offline SQL console in a few steps

1
Comments
5 min read
Exploring the Power of pgvector as an Open Source Vector Database

Exploring the Power of pgvector as an Open Source Vector Database

1
Comments
12 min read
Best practices for HarperDB projects using TypeScript

Best practices for HarperDB projects using TypeScript

12
Comments
18 min read
Rust SQLx CLI: database migration with MySQL and PostgreSQL.

Rust SQLx CLI: database migration with MySQL and PostgreSQL.

8
Comments
11 min read
6 Cache Strategies to Save Your Database's Performance

6 Cache Strategies to Save Your Database's Performance

5
Comments
9 min read
MongoDB Quick Start Guide 🍃⚡️

MongoDB Quick Start Guide 🍃⚡️

35
Comments 4
9 min read
instant distributed database- gun.js

instant distributed database- gun.js

17
Comments
2 min read
Replicating Data from Oracle to PostgreSQL - A Comprehensive Guide

Replicating Data from Oracle to PostgreSQL - A Comprehensive Guide

Comments
3 min read
loading...