Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Building a Redis Clone in Zig—Part 1

Building a Redis Clone in Zig—Part 1

Comments
5 min read
Sequelize, Postgresql column does not exist Fix
Cover image for Sequelize, Postgresql column does not exist Fix

Sequelize, Postgresql column does not exist Fix

Comments
1 min read
Concurrency and Row Versioning - Part 1
Cover image for Concurrency and Row Versioning - Part 1

Concurrency and Row Versioning - Part 1

Comments
2 min read
POO con BBDD #1

POO con BBDD #1

Comments
3 min read
Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]
Cover image for Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]

Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]

Comments
2 min read
Expression-Based Parameter Value Feature in Oracle 21c

Expression-Based Parameter Value Feature in Oracle 21c

Comments
1 min read
🚀 From Excel to Web App: How I Built a Smart Assignment Management System for 125 Students
Cover image for 🚀 From Excel to Web App: How I Built a Smart Assignment Management System for 125 Students

🚀 From Excel to Web App: How I Built a Smart Assignment Management System for 125 Students

Comments
4 min read
Why Your Analytics Queries Are Slow: A Deep Dive into Columnar Databases

Why Your Analytics Queries Are Slow: A Deep Dive into Columnar Databases

Comments
6 min read
PostgreSQL WAL: The Backbone of Reliable and Scalable Databases

PostgreSQL WAL: The Backbone of Reliable and Scalable Databases

1
Comments
3 min read
What I Learned from Digging into the SolidCache Gem
Cover image for What I Learned from Digging into the SolidCache Gem

What I Learned from Digging into the SolidCache Gem

Comments
1 min read
Star vs Snowflake Schema: key difference, pros & cons, and when to use each.
Cover image for Star vs Snowflake Schema: key difference, pros & cons, and when to use each.

Star vs Snowflake Schema: key difference, pros & cons, and when to use each.

Comments
3 min read
The Card Whisperer: Predicting Database Query Costs... Without Data by Arvind Sundararajan

The Card Whisperer: Predicting Database Query Costs... Without Data by Arvind Sundararajan

Comments
2 min read
An Introduction to Commonly Used PL/SQL Data Types

An Introduction to Commonly Used PL/SQL Data Types

Comments
4 min read
Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Comments
2 min read
Undo Redo Database Queries

Undo Redo Database Queries

Comments
25 min read
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Comments
18 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Comments
8 min read
Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins
Cover image for Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

1
Comments 2
3 min read
SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

1
Comments
7 min read
Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?
Cover image for Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Comments
4 min read
🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

Comments
3 min read
py schema

py schema

Comments
2 min read
Database Normalization: From 1NF to 3NF

Database Normalization: From 1NF to 3NF

Comments
2 min read
Cursor +Trigger

Cursor +Trigger

Comments
2 min read
Understanding SQL Databases

Understanding SQL Databases

1
Comments
1 min read
loading...