Databases & DBA
Checking OpenSearch Compatibility Before Leaving Elasticsearch
Learn how to assess Elasticsearch-to-OpenSearch compatibility by reviewing versions, clients, APIs, mappings, analyzers, security, and search-result relevance.
Loading
Working With the New 50 MB Query Result Limit in Cloudflare D1
Learn how Cloudflare D1's 50 MB query result limit affects API design and how pagination, filtering, and selective columns keep SQL responses manageable.
Using OpenSearch for Application Search Without a Managed Elasticsearch Service
Learn how to build and operate a self-managed OpenSearch setup for application search, including cluster architecture, indexing, mappings, integrations, and operational responsibilities.
Using OpenSearch for Application Search Without a Managed Elasticsearch Service
Learn how to build and operate a self-managed OpenSearch application search system, including cluster architecture, indexing, mappings, and application integration.
Reducing Large Query Results in Cloudflare D1 With Pagination
Learn how to paginate large Cloudflare D1 query results using LIMIT/OFFSET and cursor-based queries, stable sorting, validated page sizes, and API response design.
Replacing RocksDB With SurrealKV: What Changes for SurrealDB Applications
Learn how SurrealDB 4.0 replaces RocksDB with SurrealKV, including automatic data migration, storage configuration changes, backups, and operational considerations.
Faster Partial-Word Searches in SQLite With the FTS5 Trigram Tokenizer
Learn how SQLite FTS5's trigram tokenizer accelerates partial-word and substring searches with LIKE and GLOB, including limitations for short search terms.
DuckDB Query Profiling: How to Find Slow Queries on Parquet Files
Learn how to profile DuckDB queries against Parquet files with EXPLAIN ANALYZE, interpret execution plans, find bottlenecks, and test targeted SQL optimizations.
SQLite WAL Checkpoints: Why Your Database File Keeps Growing
Learn how SQLite WAL mode and checkpointing work, why WAL files grow, and how active readers and checkpoint modes affect disk usage.
ClickHouse Materialized Views: How to Keep Dashboard Aggregates Up to Date
Learn how to use ClickHouse incremental materialized views and SummingMergeTree tables to maintain accurate, efficient dashboard aggregates as new data arrives.
How to Find Slow Elasticsearch Queries with the Profile API
Learn how to use the Elasticsearch Profile API to identify expensive query components, interpret profiling output, and diagnose slow search requests.
How to Check Whether a Database Connection Pool Is Too Small
Learn how to detect database connection pool bottlenecks, measure acquisition waits and pool usage, identify root causes, and tune connection limits safely.
How to Find Slow Queries in Elasticsearch Using Query Profiling
Learn how to use Elasticsearch's Profile API to find expensive query, collector, aggregation, and shard operations, then investigate and improve slow search performance.
Data API Builder 2.1.5 Adds JSON and Vector Data Types
Learn how Data API Builder 2.1.5 exposes JSON and vector database columns through REST and GraphQL APIs for flexible metadata and AI semantic-search workloads.
MySQL vs PostgreSQL for AI: Which Is More Intelligent?
Compare MySQL and PostgreSQL for AI, vector search, RAG, machine learning, and automation. See when PostgreSQL, MySQL AI, or HeatWave fits best.
MySQL vs PostgreSQL: A Developer and Architect Guide
Compare MySQL and PostgreSQL for performance, JSON, indexing, transactions, scaling, and .NET. Learn which database fits your application and team.
What Happens When an AI Agent Needs Database Access for Only Five Minutes?
temporary database access AI agents, C# AI agent database access, PostgreSQL temporary credentials, short-lived database access, PostgreSQL temporary roles, AI agent security, database least privilege, temporary PostgreSQL access, agent credential expiration, C# PostgreSQL security
How to Create, Connect, and Use a SQLite Database with .NET
Learn how to use SQLite with C# and Microsoft.Data.Sqlite to create databases and tables, insert and retrieve data, use transactions, and understand SQLite use cases.
PLS-00201 in Multi-Schema Oracle Applications: A Verification Approach, Not a Permissions Reflex
Troubleshoot Oracle PLS-00201 errors in .NET ADO.NET applications by checking object names, schema, package status, procedure signatures, privileges, and synonyms.
Vector Databases with .NET: PostgreSQL pgvector vs Azure AI Search vs Qdrant
Compare PostgreSQL pgvector, Azure AI Search, and Qdrant for .NET AI apps. Choose the best vector database for RAG, semantic search, and more.
Vector Databases vs Traditional Databases: Choosing the Right Storage for AI Applications
Explore vector vs. traditional databases for AI. Learn their strengths, use cases, and how to choose the right storage for your intelligent applications.
Database Sharding Explained: Scaling Applications Beyond a Single Database
Database sharding explained: Scale apps beyond single servers with this powerful technique for performance and availability.
SurrealDB Tutorial: Combining Relational, Document, and Graph Databases
Learn how SurrealDB combines relational, document, graph, and real-time database capabilities into a single platform for modern application development.
DuckDB Tutorial: Building Analytics Applications Without a Data Warehouse
Learn how DuckDB enables fast analytics without a traditional data warehouse. Explore architecture, use cases, benefits, and implementation tips.
Building an AI-Powered Knowledge Base Using Vector Databases and C#
Build AI-powered knowledge bases with C# & vector databases for semantic search, understanding user intent & delivering accurate, context-aware answers.
Vector Databases Explained: Pinecone vs Weaviate vs Qdrant
Explore vector databases like Pinecone, Weaviate, and Qdrant for AI. Understand RAG, semantic search, and choose the best fit for your application.
Apache Iceberg Explained: The Foundation of Modern Data Lakehouses
Apache Iceberg: The open table format revolutionizing data lakehouses with ACID transactions, schema evolution, and time travel for massive analytics.
Vitess Explained: Scaling MySQL Databases for Modern Applications
Vitess scales MySQL horizontally for modern apps. Discover its architecture, sharding, and benefits for high-traffic, large-dataset applications.
Meilisearch vs Elasticsearch: Which Search Engine Is Right for Your Application?
Meilisearch vs. Elasticsearch: Compare features, architecture, and use cases to choose the right search engine for your application's needs.
Zed Editor Explained: Why Developers Are Switching from VS Code
Zed Editor: A fast, collaborative alternative to VS Code. Explore its native performance, built-in collaboration, and modern features.
