Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SOLID.JS & SUPABASE Authentication App

SOLID.JS & SUPABASE Authentication App

13
Comments
2 min read
Chat with your SQL database

Chat with your SQL database

1
Comments
3 min read
Why Vector Search Is Not Enough for Your GenAI Applications?

Why Vector Search Is Not Enough for Your GenAI Applications?

8
Comments
7 min read
Investigating and Optimizing Over-Querying

Investigating and Optimizing Over-Querying

Comments
13 min read
Unlocking the Power of SQL Server: The Importance of Stored Procedures for Complex Queries

Unlocking the Power of SQL Server: The Importance of Stored Procedures for Complex Queries

Comments
2 min read
The Role of Ontologies in Data Management

The Role of Ontologies in Data Management

1
Comments
6 min read
Mastering SQL Aggregate Functions: SUM, MAX, MIN, AVG

Mastering SQL Aggregate Functions: SUM, MAX, MIN, AVG

2
Comments
4 min read
Effortless Privacy Protection: Simplifying Account Deletions

Effortless Privacy Protection: Simplifying Account Deletions

Comments
2 min read
Beyond the Basics: Leveraging ACID for Advanced Database Management

Beyond the Basics: Leveraging ACID for Advanced Database Management

Comments
2 min read
Essential Database Optimizations Before Re-Architecting Your Backend

Essential Database Optimizations Before Re-Architecting Your Backend

Comments
5 min read
Meus aprendizados com a Rinha de Backend 2023 Q3

Meus aprendizados com a Rinha de Backend 2023 Q3

6
Comments
4 min read
Consistency isn’t consistent at all!

Consistency isn’t consistent at all!

Comments
2 min read
Normalization in Relational Databases

Normalization in Relational Databases

Comments
3 min read
MYSQL VS POSTGRESQL: CHOOSING THE RIGHT DATABASE FOR YOUR NEEDS

MYSQL VS POSTGRESQL: CHOOSING THE RIGHT DATABASE FOR YOUR NEEDS

Comments
3 min read
Thinking Inside The Box: Relational Style Joins in SurrealDB

Thinking Inside The Box: Relational Style Joins in SurrealDB

19
Comments
7 min read
Breaking IndexedDB consistency to explore its transactions

Breaking IndexedDB consistency to explore its transactions

Comments 2
10 min read
Studio 3T Performance Suite: How to Identify and Resolve Performance Bottlenecks in MongoDB

Studio 3T Performance Suite: How to Identify and Resolve Performance Bottlenecks in MongoDB

Comments
5 min read
SQL Interview Questions.

SQL Interview Questions.

1
Comments 2
6 min read
How to Build an Advanced AI-Powered Enterprise Content Pipeline Using Mixtral 8x7B and Qdrant

How to Build an Advanced AI-Powered Enterprise Content Pipeline Using Mixtral 8x7B and Qdrant

4
Comments
10 min read
Prisma vs Sequelize: A Comprehensive Comparison of Node.js ORMs

Prisma vs Sequelize: A Comprehensive Comparison of Node.js ORMs

9
Comments
3 min read
🏁🐘Winning Race Conditions With PostgreSQL

🏁🐘Winning Race Conditions With PostgreSQL

44
Comments 2
10 min read
Sparse Vectors in Qdrant: Pure Vector-based Hybrid Search

Sparse Vectors in Qdrant: Pure Vector-based Hybrid Search

36
Comments 2
15 min read
Why we are betting on Rust!

Why we are betting on Rust!

31
Comments 2
4 min read
🦉 AthenaDB: Distributed Vector Database Powered by Cloudflare 🌩️

🦉 AthenaDB: Distributed Vector Database Powered by Cloudflare 🌩️

7
Comments 1
4 min read
Adminer With Custom Login Servers Selector Plugin Run In Docker

Adminer With Custom Login Servers Selector Plugin Run In Docker

Comments
3 min read
Unlocking the Power of Databases: A Brief Overview of SQL

Unlocking the Power of Databases: A Brief Overview of SQL

3
Comments
9 min read
How to Downsample Your Data Efficiently?

How to Downsample Your Data Efficiently?

Comments
3 min read
Music Monitor x Five: Building a Modern Database Solution for Music Schools

Music Monitor x Five: Building a Modern Database Solution for Music Schools

Comments
4 min read
Helpful Tools for Quant丨Efficiently Calculate Transaction Costs from Tick Data

Helpful Tools for Quant丨Efficiently Calculate Transaction Costs from Tick Data

Comments
2 min read
Database Triggers in PostgreSQL: A Deep Dive using AWS RDS

Database Triggers in PostgreSQL: A Deep Dive using AWS RDS

3
Comments
5 min read
What is the Most Efficient Way to Calculate ETF IOPV?

What is the Most Efficient Way to Calculate ETF IOPV?

Comments
7 min read
Laravel API - Import 1 million records with validation in few seconds.

Laravel API - Import 1 million records with validation in few seconds.

14
Comments
8 min read
Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 2 Executing SQL statements

Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 2 Executing SQL statements

2
Comments
3 min read
Benchmark: Snowflake vs UUIDv4

Benchmark: Snowflake vs UUIDv4

19
Comments 4
5 min read
Introduction to NoSQL Databases: Working with MongoDB

Introduction to NoSQL Databases: Working with MongoDB

Comments
2 min read
SQL Database Normalization with Easy Examples

SQL Database Normalization with Easy Examples

2
Comments
2 min read
Exploring LEAD(): Enhancing SQL Data Comparing And Analysis

Exploring LEAD(): Enhancing SQL Data Comparing And Analysis

Comments
2 min read
Working with different IDs through the application

Working with different IDs through the application

Comments
4 min read
Docker para iniciantes: Criando Containers de Bancos de Dados

Docker para iniciantes: Criando Containers de Bancos de Dados

19
Comments 1
10 min read
Since When Did APIs Become Databases?

Since When Did APIs Become Databases?

Comments
4 min read
What is SQL and SQLite?

What is SQL and SQLite?

Comments
3 min read
Make your app faster - Use Caching 💨⚡️

Make your app faster - Use Caching 💨⚡️

Comments
3 min read
What We Learned When We Built a Vector Database-and Our Customers Started Using It (part 1)

What We Learned When We Built a Vector Database-and Our Customers Started Using It (part 1)

40
Comments 1
7 min read
PostgreSQL Isolation Levels and Locking Summary

PostgreSQL Isolation Levels and Locking Summary

2
Comments
5 min read
AI Softwareentwicklung mit Ninox und arcBot

AI Softwareentwicklung mit Ninox und arcBot

Comments
4 min read
Mastering Node.js: Building Scalable Web Applications

Mastering Node.js: Building Scalable Web Applications

Comments
1 min read
GreptimeDB v0.6 Released - Support Migrating Table's Regions between Datanodes

GreptimeDB v0.6 Released - Support Migrating Table's Regions between Datanodes

Comments
2 min read
SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

6
Comments
11 min read
How to write Database Procedures

How to write Database Procedures

Comments
4 min read
Mastering Common Database Objects - Series 1 .. n

Mastering Common Database Objects - Series 1 .. n

Comments
1 min read
AWS Database Migration-Heterogenous Approach using DMS.

AWS Database Migration-Heterogenous Approach using DMS.

4
Comments
3 min read
Three questions to always ask when data modeling for NoSQL

Three questions to always ask when data modeling for NoSQL

5
Comments
2 min read
Concepts of Cosmos DB: Data Consistency Levels

Concepts of Cosmos DB: Data Consistency Levels

1
Comments
4 min read
Upgrading PostgreSQL on Heroku: A Step-by-Step Guide

Upgrading PostgreSQL on Heroku: A Step-by-Step Guide

5
Comments
2 min read
6 Ways You're Using ORMs Wrong and How To Fix

6 Ways You're Using ORMs Wrong and How To Fix

11
Comments 7
6 min read
Best Practices for Massive-Scale Deployments: Multitenancy and Custom Sharding

Best Practices for Massive-Scale Deployments: Multitenancy and Custom Sharding

19
Comments 2
6 min read
🚀 Day 18-19/100 🚀

🚀 Day 18-19/100 🚀

Comments
1 min read
The Importance of Data Concurrency

The Importance of Data Concurrency

1
Comments
3 min read
In-Memory Caching in AWS: Accelerating Application Performance.

In-Memory Caching in AWS: Accelerating Application Performance.

Comments
3 min read
Share your dev wishes 👍

Share your dev wishes 👍

Comments
1 min read
loading...