Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Working with Multiple Databases, Transactions, and SQLite Internals
Cover image for Working with Multiple Databases, Transactions, and SQLite Internals

Working with Multiple Databases, Transactions, and SQLite Internals

10
Comments
5 min read
Performance Degradation Due to Inefficient Apex / ORM Usage (salesforce)

Performance Degradation Due to Inefficient Apex / ORM Usage (salesforce)

Comments
3 min read
Inside SQLite Backend: Virtual Machine, Storage, and the Build Process
Cover image for Inside SQLite Backend: Virtual Machine, Storage, and the Build Process

Inside SQLite Backend: Virtual Machine, Storage, and the Build Process

10
Comments
3 min read
B2B Wellness Infrastructure: Securing Sensitive Data with Scalable Database Design

B2B Wellness Infrastructure: Securing Sensitive Data with Scalable Database Design

Comments
2 min read
What is Redis and Why to Use Redis?
Cover image for What is Redis and Why to Use Redis?

What is Redis and Why to Use Redis?

Comments
3 min read
CineDB: Building a Movie Catalog with DocumentDB 📽️

CineDB: Building a Movie Catalog with DocumentDB 📽️

Comments
8 min read
If Swagger Works but Your SDK Fails, Your SDK Is Lying
Cover image for If Swagger Works but Your SDK Fails, Your SDK Is Lying

If Swagger Works but Your SDK Fails, Your SDK Is Lying

1
Comments 2
2 min read
SQL Server Indexes Explained: Column Order, INCLUDE, and the Mistakes That Taught Me
Cover image for SQL Server Indexes Explained: Column Order, INCLUDE, and the Mistakes That Taught Me

SQL Server Indexes Explained: Column Order, INCLUDE, and the Mistakes That Taught Me

3
Comments
14 min read
PostgreSQL backup tools comparison — Databasus, WAL-G, pgBackRest and Barman
Cover image for PostgreSQL backup tools comparison — Databasus, WAL-G, pgBackRest and Barman

PostgreSQL backup tools comparison — Databasus, WAL-G, pgBackRest and Barman

Comments
9 min read
I Built a Hybrid AI Database - Cache in Go (And It Runs Stable on My Old Dell Latitude)

I Built a Hybrid AI Database - Cache in Go (And It Runs Stable on My Old Dell Latitude)

1
Comments
7 min read
Home Assistant langsam? So rettest du deine SD-Karte & machst das Dashboard wieder schnell
Cover image for Home Assistant langsam? So rettest du deine SD-Karte & machst das Dashboard wieder schnell

Home Assistant langsam? So rettest du deine SD-Karte & machst das Dashboard wieder schnell

Comments
3 min read
Snowflake Data Cloud: A Comprehensive Guide
Cover image for Snowflake Data Cloud: A Comprehensive Guide

Snowflake Data Cloud: A Comprehensive Guide

Comments
31 min read
We’re Launching Vizora (Private Beta) — Paste Your DB Schema, Understand It Instantly
Cover image for We’re Launching Vizora (Private Beta) — Paste Your DB Schema, Understand It Instantly

We’re Launching Vizora (Private Beta) — Paste Your DB Schema, Understand It Instantly

1
Comments
2 min read
JDBC Connection issue to Sybase Server

JDBC Connection issue to Sybase Server

Comments
1 min read
Database connection in NextJS (App Router)

Database connection in NextJS (App Router)

Comments
2 min read
The Myth of ‘Just Connect Lambda to RDS’
Cover image for The Myth of ‘Just Connect Lambda to RDS’

The Myth of ‘Just Connect Lambda to RDS’

Comments
8 min read
QUICK SQL REVISION
Cover image for QUICK SQL REVISION

QUICK SQL REVISION

Comments
14 min read
UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()
Cover image for UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

Comments
5 min read
Track Blocking and Deadlocks in MSSQL with my custom script
Cover image for Track Blocking and Deadlocks in MSSQL with my custom script

Track Blocking and Deadlocks in MSSQL with my custom script

1
Comments
4 min read
How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)
Cover image for How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)

How to Sync Stripe Data to PostgreSQL in 5 Minutes (No Code)

Comments
3 min read
Wait, what? PK is not needed for HABTM?

Wait, what? PK is not needed for HABTM?

Comments
2 min read
Why I Built DDL to Data
Cover image for Why I Built DDL to Data

Why I Built DDL to Data

Comments
4 min read
Week 8 of 40 – Giving CatAtlas a Real Identity (and Tests)

Week 8 of 40 – Giving CatAtlas a Real Identity (and Tests)

Comments
2 min read
MariaDB mysqldump guide — Using mysqldump for MariaDB database backups
Cover image for MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

MariaDB mysqldump guide — Using mysqldump for MariaDB database backups

Comments
9 min read
Stop Manually Tracing Azure Synapse Dependencies

Stop Manually Tracing Azure Synapse Dependencies

Comments
1 min read
loading...