Skip to main content
← All Tags

Databases

36 articles in this category (Page 1 of 2)

AI NewsDatabasesSoftware Engineering

Best Vector Databases in 2026: Pricing, Scale, and Architecture Tradeoffs

Compare nine leading vector databases in 2026 including Pinecone and Milvus, featuring Zilliz Cloud's Cardinal engine which delivers 10x higher throughput than HNSW.

Read more
AI NewsDatabasesArtificial Intelligence

Vector Search vs. Lucene: Engineering Trade-offs in Semantic Discovery

Bryan O’Grady of Qdrant explores the technical shift from Lucene-based exact matches to high-performance vector search for semantic discovery and video embeddings.

Read more
AI NewsDatabasesDevOps

Optimizing High-Throughput Workloads with InfluxDB Time-Series Database

InfluxDB handles millions of writes per second using columnar storage and delta encoding, outperforming traditional RDBMS for time-stamped metrics and IoT data.

Read more
AI NewsData EngineeringDatabases

ClickHouse Native JSON: 2,500x Faster Than MongoDB in 2026

ClickHouse v25.3 native JSON support achieves 2,500x faster aggregations than MongoDB on 1 billion documents via columnar subcolumn storage.

Read more
AI NewsBig DataDatabases

An Implementation Guide to Building a DuckDB-Python Analytics Pipeline

Master DuckDB-Python for high-performance analytics, featuring zero-copy integration with Pandas and Polars, vectorized UDFs, and Hive-partitioned Parquet workflows.

Read more
AI NewsDevOpsDatabases

PGArchive: Zero-Knowledge Database Backups with Verified Restores

PGArchive provides zero-knowledge Postgres and MySQL backups using local AES-256-GCM encryption and automated Docker-based restore verification.

Read more
AI NewsDatabasesArtificial Intelligence

Optimizing AI Agent Memory: Why SQLite and FTS5 Outperform Traditional Vector Databases

SQLite and FTS5 achieved sub-1ms latency for 4,300 AI memories, eliminating the $70/month cost of managed vector databases.

Read more
AI NewsSoftware DevelopmentDatabases

Evaluating the 2026 TypeScript ORM Landscape: ZenStack vs. Prisma vs. Drizzle

A technical evaluation of the 2026 TypeScript ORM landscape comparing ZenStack, Prisma, and Drizzle for modern backend engineering.

Read more
AI NewsAgentic AIDatabases

OpenViking: A Hierarchical Filesystem-Based Context Database for AI Agents

OpenViking introduces a virtual filesystem for AI memory, reducing token consumption from 24.6M to 4.2M while increasing task completion rates to 52.08% on the LoCoMo10 dataset.

Read more
AI NewsDatabasesAI

PostgreSQL Vectorization: Transforming Databases with Docker and pgvector

Turn PostgreSQL into a vector database using Docker to streamline AI workflows. Allan Roberto demonstrates how to integrate embeddings into SQL in 2026.

Read more
AI NewsDatabasesVector Database

Alibaba Open-Sources Zvec: An Embedded Vector Database for Edge Applications

Alibaba releases Zvec, an open-source embedded vector database, achieving over 8,000 QPS on VectorDBBench with the Cohere 10M dataset.

Read more
AI NewsSQLDatabases

Understanding the ROLLUP Operator in SQL for Hierarchical Aggregation

The ROLLUP operator in SQL enables hierarchical aggregation, creating subtotals and grand totals for multi-level summaries.

Read more
AI NewsDatabasesAlgorithms

Expired Oracle Patent Opens Fast Sorting Algorithm to Open Source Databases

A 20-year-old Oracle sorting algorithm patent has expired, potentially increasing open-source database speeds by up to 5x.

Read more
AI NewsDatabasesScalability

Scaling PostgreSQL to power 800 million ChatGPT users

OpenAI scaled a single PostgreSQL instance with nearly 50 read replicas to reliably support 800 million ChatGPT users and millions of queries per second.

Read more
AI NewsSQLDatabases

MSSQL DBCC: How Good Are They Really?

DBCC commands in SQL Server offer powerful tools for database health, with DBCC CHECKDB potentially requiring data loss in severe corruption cases.

Read more
AI NewsSQLDatabases

SQL Code Library: A Comprehensive Guide to Database Management

A detailed SQL guide covering database basics, major systems (MySQL, PostgreSQL, SQL Server, Oracle, SQLite), and practical code examples for efficient data manipulation.

Read more
AI NewsData EngineeringDatabases

GCAIDB Certification: Bridging AI and Database Expertise

The GCAIDB certification validates skills needed to manage databases supporting AI workloads, addressing a key failure point in AI initiatives.

Read more
AI NewsDatabasesMachine Learning

How to Build Portable, In-Database Feature Engineering Pipelines with Ibis Using Lazy Python APIs and DuckDB Execution

Ibis enables building portable in-database feature engineering pipelines, executing entirely within DuckDB, and demonstrating a 100% reduction in data transfer overhead.

Read more
AI NewsDatabasesIoT

Introduction to IoTDB

Explore the Apache IoTDB time-series database designed for IoT data, offering SQL compatibility and a tree-structured storage model.

Read more
AI NewsJPADatabases

Joining Tables Without Relation Using JPA Criteria

Explore how to construct a JPA criteria query to join tables without explicitly defining the JPA relationship, addressing challenges in legacy database designs.

Read more
AI NewsCloud ComputingDatabases

AWS Database Options: RDS, DynamoDB, and Aurora

AWS offers three primary database services—RDS, DynamoDB, and Aurora—each optimized for different application requirements.

Read more
AI NewsCloudDatabases

Amazon S3 Vectors Reaches GA, Delivering Storage-First Architecture for RAG

AWS launches Amazon S3 Vectors GA, increasing per-index capacity to 2 billion vectors and reducing RAG workload TCO by up to 90%.

Read more
AI NewsDatabasesPostgreSQL

Resolving PostgreSQL ERROR: canceling statement due to user request

Understand the root causes of the 'canceling statement due to user request' error in PostgreSQL and how to effectively handle statement cancellations.

Read more
AI NewsCybersecurityDatabases

MongoDB Vulnerability CVE-2025-14847 Under Active Exploitation

A critical MongoDB flaw, CVE-2025-14847, is under active exploitation, impacting over 87,000 servers globally.

Read more