Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Calculate monthly account balance and fill in missing dates:From SQL to SPL

Calculate monthly account balance and fill in missing dates:From SQL to SPL

5
Comments
2 min read
The Columnar Approach: A Deep Dive into Efficient Data Storage for Analytics 🚀

The Columnar Approach: A Deep Dive into Efficient Data Storage for Analytics 🚀

Comments
4 min read
🚀 Mastering Delta Encoding: The Secret to Smarter Data Compression 💡

🚀 Mastering Delta Encoding: The Secret to Smarter Data Compression 💡

Comments
3 min read
Resumo de conceitos de bancos de dados relacionais

Resumo de conceitos de bancos de dados relacionais

Comments
4 min read
Working with JSON in MySQL

Working with JSON in MySQL

2
Comments
3 min read
A Quick Guide to SQL Data Modification Commands with Examples

A Quick Guide to SQL Data Modification Commands with Examples

1
Comments
3 min read
Enterprise Data Architecture and Modeling: Key Practices and Trends

Enterprise Data Architecture and Modeling: Key Practices and Trends

1
Comments
1 min read
Real-Time Data Integration Techniques Using PostgreSQL Foreign Data Wrapper (FDW)

Real-Time Data Integration Techniques Using PostgreSQL Foreign Data Wrapper (FDW)

1
Comments
10 min read
A Simple Guide for Choosing the Right Database

A Simple Guide for Choosing the Right Database

Comments
8 min read
Curiosity: Using Ably.io Realtime Messaging as a Lightweight Database

Curiosity: Using Ably.io Realtime Messaging as a Lightweight Database

Comments
2 min read
Why You Should Use ORM Tools in Your Projects in 2025

Why You Should Use ORM Tools in Your Projects in 2025

Comments
3 min read
Index Filtering in PostgreSQL and YugabyteDB (Index Scan instead of Index Only Scan)

Index Filtering in PostgreSQL and YugabyteDB (Index Scan instead of Index Only Scan)

Comments
12 min read
SQL VS NoSQL

SQL VS NoSQL

Comments
2 min read
Subqueries

Subqueries

Comments
1 min read
On the Andy Pavlo's DB review

On the Andy Pavlo's DB review

1
Comments
2 min read
How to Test for Equal JSON Columns in Laravel Models

How to Test for Equal JSON Columns in Laravel Models

1
Comments
2 min read
2024 in Review: Key Highlights in Cloud Databases

2024 in Review: Key Highlights in Cloud Databases

Comments
5 min read
How And Why The Developer-First Approach Is Changing The Observability Landscape

How And Why The Developer-First Approach Is Changing The Observability Landscape

Comments
11 min read
Decoding ORM: A Deep Dive into Object-Relational Mapping

Decoding ORM: A Deep Dive into Object-Relational Mapping

Comments
6 min read
SQL 101 | Chapter 2: Setting Up Your Database Environment

SQL 101 | Chapter 2: Setting Up Your Database Environment

Comments
5 min read
Metrics Mayhem

Metrics Mayhem

Comments
1 min read
15 Databases, 15 Use Cases — The Ultimate Guide That No One Asked For (But Everyone Needs)

15 Databases, 15 Use Cases — The Ultimate Guide That No One Asked For (But Everyone Needs)

1
Comments
2 min read
Query Optimization: How the Query Optimizer Works Using Relational Algebra

Query Optimization: How the Query Optimizer Works Using Relational Algebra

Comments
5 min read
Redefining Telehealth for Vulnerable Populations

Redefining Telehealth for Vulnerable Populations

Comments
1 min read
MongoDB Command Shortcuts: The Ultimate Guide

MongoDB Command Shortcuts: The Ultimate Guide

Comments
3 min read
MongoDB: Startup replica sets with a config file

MongoDB: Startup replica sets with a config file

Comments
2 min read
MongoDB: How to setup replica sets

MongoDB: How to setup replica sets

Comments
3 min read
Dev Video Review: Firestore Data Structure, Limitations, and IMHO

Dev Video Review: Firestore Data Structure, Limitations, and IMHO

Comments
2 min read
JavaScript using Node.js and accessing and modifying phpMyAdmin database.

JavaScript using Node.js and accessing and modifying phpMyAdmin database.

Comments
2 min read
The Popcorn Problem - lowCal_update 8

The Popcorn Problem - lowCal_update 8

Comments
1 min read
SQL Server: Get database port

SQL Server: Get database port

Comments
1 min read
The difference between the (DDL AND DML) DATABASE

The difference between the (DDL AND DML) DATABASE

Comments
1 min read
How can I securely store user data in a cryptocurrency exchange database?

How can I securely store user data in a cryptocurrency exchange database?

1
Comments
1 min read
Database Scaling NLogN 📈

Database Scaling NLogN 📈

Comments
3 min read
Troubleshooting "canceling statement due to conflict with recovery" in PostgreSQL: A Practical Guide

Troubleshooting "canceling statement due to conflict with recovery" in PostgreSQL: A Practical Guide

1
Comments
4 min read
Monitoring AWS RDS Postgres Parameter Changes

Monitoring AWS RDS Postgres Parameter Changes

Comments 1
4 min read
How to do Review Sentiment Analysis using Python

How to do Review Sentiment Analysis using Python

Comments
6 min read
Do you think schema flexibility justifies using NoSQL? Think twice.

Do you think schema flexibility justifies using NoSQL? Think twice.

Comments
4 min read
Why 54% of Organizations Are Moving to Cloud Data Warehouses

Why 54% of Organizations Are Moving to Cloud Data Warehouses

Comments
5 min read
A Deep Dive into Database Architecture: Building the Backbone of Modern Systems 🏗️

A Deep Dive into Database Architecture: Building the Backbone of Modern Systems 🏗️

Comments
4 min read
Understanding PDO in PHP and Why It is Recommended Over `mysql_*` Functions

Understanding PDO in PHP and Why It is Recommended Over `mysql_*` Functions

Comments
4 min read
Trees in SQL

Trees in SQL

Comments
9 min read
SQL 101 | Chapter 1: Understanding SQL and Databases

SQL 101 | Chapter 1: Understanding SQL and Databases

1
Comments
3 min read
Trees in SQL (part 2)

Trees in SQL (part 2)

Comments
5 min read
3 Things You Need To Take Control Of Your Database

3 Things You Need To Take Control Of Your Database

Comments
3 min read
Sequelize seeders for static data

Sequelize seeders for static data

Comments
2 min read
Sequelize migrations

Sequelize migrations

Comments
2 min read
HadiDB: A Lightweight, Horizontally Scalable Database in Python

HadiDB: A Lightweight, Horizontally Scalable Database in Python

Comments
3 min read
Exploring OSM changesets via DuckDB

Exploring OSM changesets via DuckDB

Comments
9 min read
SQL Filtering and Sorting with Real-life Examples

SQL Filtering and Sorting with Real-life Examples

Comments
4 min read
Big Discovery - lowCalAlt_update 7

Big Discovery - lowCalAlt_update 7

Comments
1 min read
lowCalAlt_update 6

lowCalAlt_update 6

Comments
1 min read
Iterations

Iterations

Comments
6 min read
Trying to predict the performance of file reads/writes

Trying to predict the performance of file reads/writes

7
Comments
10 min read
How PostgreSQL Powers the Future of Data-Driven Applications

How PostgreSQL Powers the Future of Data-Driven Applications

Comments
1 min read
Understanding Optimistic and Pessimistic Locking in Ruby on Rails

Understanding Optimistic and Pessimistic Locking in Ruby on Rails

2
Comments
2 min read
When Should You Create Views in Your Database?

When Should You Create Views in Your Database?

Comments
5 min read
T-SQL avanzato: tecniche da ricordare

T-SQL avanzato: tecniche da ricordare

Comments
3 min read
🔍 MongoDB Data Modeling: Embedding vs. Referencing - A Strategic Choice!

🔍 MongoDB Data Modeling: Embedding vs. Referencing - A Strategic Choice!

Comments
1 min read
Data Warehousing Architectures

Data Warehousing Architectures

Comments
5 min read
loading...