databases
Tips for Building Knowledge Graphs
Some thoughts about constructing knowledge graphs
Scaling a Monolith to 1M LOC: 113 Pragmatic Lessons from Tech Lead to CTO
For context, I work in a Django/React TS/React Native codebase on a 20-person team at MorphMarkethttps://www.morphmarket.com/. I have 17 years experience wit...
Google just open-sourced their MCP server for databases. Connect any database to any AI agent in 10 lines of code. It's called MCP Toolbox…
Google just open-sourced their MCP server for databases. Connect any database to any AI agent in 10 lines of code. It's called MCP Toolbox. What it handles: → Connection pooling → Authentication → Query execution → Tool generation → OpenTelemetry tracing Supported databases: →…
Comparing Memory Systems for LLM Agents: Vector, Graph, and Event Logs
Learn how different memory systems affect multi-agent planning. Comparing Memory Systems for LLM Agents highlights key performance metrics.
Plain Vector RAG
sublinear scaling
What is a Database? Modern Database Types, Examples, and Applications (2025)
What is a database? major database types, real-world examples, key features, and trends for choosing the best database in 2025
Getting Started with Neo4j: Installation and Setup Guide - KDnuggets
Learn how to install and set up Neo4j. This article will help you start using Neo4j to explore connected data.
Data definition language (DDL)
Data Definition Language (DDL) is a subset of SQL used to define and modify the structure of database objects like tables and constraints.
What are acid properties
ACID properties are principles ensuring data reliability and integrity in transaction processing, focusing on Atomicity, Consistency, Isolation, and Durability.
From Self-Hosted to Cloud: An Interview About Oil & Gas Software Infrastructure
Databases in 2024: A Year in Review
Andy rises from the ashes of his dead startup and discusses what happened in 2024 in the database game.
"We ran out of columns" - The best, worst codebase
Parquet File Format: Everything You Need to Know
New data flavors require new ways of storing them. Learn all you need to know about the Parquet file format
Lessons Learned from Scaling to Multi-Terabyte Datasets
This post is meant to guide you through some of the lessons I’ve learned while working with multi-terabyte datasets. The lessons shared are focused on what someone may face as the size of the…
The Great Migration from MongoDB to PostgreSQL
How Infisical migrated from MongoDB to PostgreSQL.
The race to replace Redis
Understanding databases: A comprehensive guide to different types for begin
Learn about different types of databases and find out how to design a functional and efficient database system, and compare popular RDBMSs like MySQL, Oracle, and PostgreSQL.
S3 is files, but not a filesystem
"Deep" modules, mismatched interfaces - and why SAP is so painful
The Internals of PostgreSQL: Database Cluster, Databases, and Tables
PostgreSQL, a widely adopted open-source relational database management system (RDBMS), offers robust...
Scalar Quantization and Product Quantization - Zilliz blog
A hands-on dive into scalar quantization (integer quantization) and product quantization with Python.
Not All Vector Databases Are Made Equal
A detailed comparison of Milvus, Pinecone, Vespa, Weaviate, Vald, GSI and Qdrant
What is a Vector Database? | Pinecone
Discover Vector Databases: How They Work, Examples, Use Cases, Pros & Cons, Selection and Implementation. They have combined capabilities of traditional databases and standalone vector indexes while specializing for vector embeddings.
Top 10 Best Vector Databases & Libraries
Vector database is a type of database that stores data as high-dimensional vectors, which are...
Why YAML is better than JSON (read before screaming)
You have probably seen or used the YAML format in configuration files. YAML (a recursive acronym for...
Mastering PostgreSQL Views and CTEs for Rails Developers: A Comprehensive G
Introduction Views and Common Table Expression or CTE are two important concept in...
The Tough Climb To Profitability For MongoDB
There is something weird about storage companies that were started around the same time as the Great Recession. The big ones that have gone public after
Build Your Own Redis with C/C++ | Build Your Own Redis with C/C++
Build Your Own Redis with C/C++ | Learn network programming and data structures
Dense Vectors | Pinecone
19 Graph Algorithms You Can Use Right Now
The fastest to run any graph algorithm on your data is by using Memgraph and MAGE. It’s super easy....
Data Indexing, Replication, and Sharding: Basic Concepts
A database is a collection of information that is structured for easy access. It mainly runs in a...
Three ways to scale your Database (Replication vs Sharding vs Partitioning)
Taking your database to the next level regarding scale is often harder than scaling web servers. In...
10 Essential SQL Commands for Data Science
Learn SQL commands for filtering, string operations, alias, joining tables, if-else statements, and grouping.
Quirks, Caveats, and Gotchas In SQLite
How to setup MongoDB with Jupyter Notebook
I have to conclusion how to setup MongoDB (NoSQL) with Jupyter Notebook by summary step like...
https://about.maps.earth/
How Discord Stores Billions of Messages
We decided early on to store all chat history forever so users can come back at any time and have their data available. This is a lot of data: how do we do it?
Advanced Database Programming with Rails and Postgres
Learn about Active Record and subqueries, views and materialized views, and domain types and composite types in Postgres and Ruby on Rails.
Introduction to The World of Data - (OLTP, OLAP, Data Warehouses, Data Lake
Redis Explained
A deep technical dive into all things Redis. Covering various Redis topologies, data persistence and process forking.
SQLite Internals: Pages & B-trees
Let's open a hex editor and see what this thing is made of
How to Make a Database Connection in Python for Absolute Beginners
3 steps (+examples) to connect to MS SQL Server, MySQL, Oracle and many other databases
PostgreSQL 14 Internals
Postgres Professional is a PostgreSQL company delivering Postgres Pro DBMS and all kinds of PostgreSQL professional services worldwide
10 Modern Data Engineering Tools - KDnuggets
Learn about the modern tools for data orchestration, data storage, analytical engineering, batch processing, and data streaming.
Postgres Vs MySQL syntax comparison with cheatsheet
When migrating from PostgreSQL to MySQL we often get stuck with syntax between databases. Here are...
Apt - PostgreSQL wiki
5 Useful Database Command Line Tools
Mycli - Python https://github.com/dbcli/mycli star 10.3k A Terminal Client for MySQL...
Wesley Aptekar-Cassels | Consider SQLite
Optimizing Rails connections
How to configure database connections in your Rails app
Eager Loading and the N+1 Query Problem | Learn Enough News & Blog
News & blog about Learn Enough (including the Ruby on Rails Tutorial)