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 dot commands: run system shell commands

SQLite dot commands: run system shell commands

1
Comments
1 min read
From legacy to leverage - unlocking financial data with SurrealDB

From legacy to leverage - unlocking financial data with SurrealDB

18
Comments
3 min read
SQLite dot commands: read command is recursive?

SQLite dot commands: read command is recursive?

1
Comments
2 min read
Building High-Performance Time-Series Applications with tsink: A Rust Embedded Database

Building High-Performance Time-Series Applications with tsink: A Rust Embedded Database

1
Comments
4 min read
Database Connection Settings in Java: How to Optimize MongoDB Usage

Database Connection Settings in Java: How to Optimize MongoDB Usage

1
Comments
3 min read
Why Data Partitioning Is Harder Than It Looks

Why Data Partitioning Is Harder Than It Looks

1
Comments
2 min read
MongoDB Hands-On: Delete Data, Create Indexes & Master Queries

MongoDB Hands-On: Delete Data, Create Indexes & Master Queries

Comments
2 min read
Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)

Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)

8
Comments
4 min read
SQLite dot commands: read file or standard output

SQLite dot commands: read file or standard output

1
Comments
3 min read
Provisioning AWS Infrastructure using Terraform and GitHub Actions

Provisioning AWS Infrastructure using Terraform and GitHub Actions

8
Comments
18 min read
White-Label Crypto Exchange Architecture: A Developer’s Guide

White-Label Crypto Exchange Architecture: A Developer’s Guide

1
Comments
4 min read
SQL Commands Explained: DDL vs DML vs DQL vs DCL vs TCL

SQL Commands Explained: DDL vs DML vs DQL vs DCL vs TCL

Comments
3 min read
Swiss Tables the superior performance hashmap

Swiss Tables the superior performance hashmap

3
Comments
7 min read
AWS OpenSearch Full Documents Reindexing: When? Why? How?

AWS OpenSearch Full Documents Reindexing: When? Why? How?

1
Comments
5 min read
NORMALIZATION

NORMALIZATION

1
Comments
3 min read
How to Install PostgreSQL 18 on Ubuntu 24.04

How to Install PostgreSQL 18 on Ubuntu 24.04

2
Comments
5 min read
SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)

SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)

Comments
4 min read
How defence is changing and why databases are critical to the shift into AI

How defence is changing and why databases are critical to the shift into AI

20
Comments
4 min read
SQLite functions: Generate Series Examples

SQLite functions: Generate Series Examples

Comments
2 min read
Beyond Functional: Writing Professional and Performant SQL Queries

Beyond Functional: Writing Professional and Performant SQL Queries

3
Comments
2 min read
The Ultimate Guide to SQL Joins and Subqueries Explained

The Ultimate Guide to SQL Joins and Subqueries Explained

11
Comments
7 min read
Optimize Read Performance in Supabase with Postgres Materialized Views

Optimize Read Performance in Supabase with Postgres Materialized Views

6
Comments
9 min read
EF Core prototyping

EF Core prototyping

4
Comments
2 min read
Stop Hammering Your Database: A Guide to Request Coalescing

Stop Hammering Your Database: A Guide to Request Coalescing

Comments
6 min read
How to create an Oracle Autonomous Database@Google Cloud

How to create an Oracle Autonomous Database@Google Cloud

1
Comments
5 min read
loading...