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.
Redefining ETL: Data Flows Powered by C# (Part III)

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

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

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

Comments
11 min read
MySQL x Flask: Add MySQL database with Flask App

MySQL x Flask: Add MySQL database with Flask App

6
Comments
9 min read
SPL computing performance test series: in-group accumulation

SPL computing performance test series: in-group accumulation

5
Comments
12 min read
How to easily migrate Heroku Postgres database between apps.

How to easily migrate Heroku Postgres database between apps.

9
Comments
1 min read
How I built a session recommender in 1 hour using Open AI

How I built a session recommender in 1 hour using Open AI

10
Comments
5 min read
Storing Salesforce embeddings with pgvector and OpenAI

Storing Salesforce embeddings with pgvector and OpenAI

4
Comments
10 min read
SQLite AND Operator: Understanding Logical Operators in SQLite

SQLite AND Operator: Understanding Logical Operators in SQLite

1
Comments
3 min read
How to Connect Java Applications to Databases with JDBC

How to Connect Java Applications to Databases with JDBC

Comments
1 min read
Cost of Serialization

Cost of Serialization

89
Comments 1
5 min read
SQLite Insert Query: A Detailed Guide

SQLite Insert Query: A Detailed Guide

Comments
2 min read
SQLite UPDATE Query: A Comprehensive Guide

SQLite UPDATE Query: A Comprehensive Guide

Comments
5 min read
SQLite Expressions: A Complete Guide

SQLite Expressions: A Complete Guide

Comments
4 min read
The RETURNING clause in SQL

The RETURNING clause in SQL

8
Comments 2
2 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
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
Sql Service Broker

Sql Service Broker

Comments
19 min read
Intro to Relational DBMS

Intro to Relational DBMS

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

Hummock: A Storage Engine Designed for Stream Processing

5
Comments
6 min read
How QuestDB saved a project and the team's mental health

How QuestDB saved a project and the team's mental health

5
Comments
7 min read
Developing with Dragonfly: Solve Caching Problems

Developing with Dragonfly: Solve Caching Problems

Comments
11 min read
Automate Database Processes: Supabase Triggers

Automate Database Processes: Supabase Triggers

7
Comments
4 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
Announcing the Winners of the Xata Content Hackathon

Announcing the Winners of the Xata Content Hackathon

12
Comments
3 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
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

1
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

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

Database Normalization: A Simple Tale of Ignoring 1NF

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

From Good to Great: Scaling Applications with TypeORM Optimization

1
Comments
4 min read
Recommendation algorithm with vector database

Recommendation algorithm with vector database

6
Comments
4 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
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

Comments
2 min read
Log Analysis: How to Digest 15 Billion Logs Per Day and Keep Big Queries Within 1 Second

Log Analysis: How to Digest 15 Billion Logs Per Day and Keep Big Queries Within 1 Second

Comments
6 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
SPL computing performance test series: associate tables and wide table

SPL computing performance test series: associate tables and wide table

Comments
6 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
🐣 Step-by-Step Guide to Data Masking 🎭

🐣 Step-by-Step Guide to Data Masking 🎭

9
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
How to Build a Blog API using MongoDB Aggregation Pipeline Framework

How to Build a Blog API using MongoDB Aggregation Pipeline Framework

12
Comments
24 min read
Top 5 Best Database Design Tools in 2023: Elevate Your Web Development Game

Top 5 Best Database Design Tools in 2023: Elevate Your Web Development Game

6
Comments
3 min read
ACID and Transactions in SQL

ACID and Transactions in SQL

9
Comments
6 min read
PostgreSQL and Temporary Tables

PostgreSQL and Temporary Tables

7
Comments
9 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
Building a Robust Backend in Just 30 Minutes with Outerbase

Building a Robust Backend in Just 30 Minutes with Outerbase

Comments
11 min read
Data Analysis of the Titanic with Python!

Data Analysis of the Titanic with Python!

17
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
CRUD Operations in SQL

CRUD Operations in SQL

2
Comments 1
14 min read
SQLite with Python

SQLite with Python

17
Comments 7
7 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?

1
Comments
5 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
loading...