BestHub
Sign in
Tagged articles

embedded database

17 articles · Page 1 of 1
dbaplus Community
dbaplus Community
Sep 20, 2026 · Databases

SQLite: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More

This article argues that SQLite, often dismissed as a toy database, can replace specialized systems like Elasticsearch, MongoDB, Kafka, ClickHouse, Redis, and even microservices due to its stability, zero-configuration deployment, built-in full-text search, JSON support, vector extensions, and local-first architecture, reducing operational complexity.

CachingFTS5JSON
0 likes · 25 min read
SQLite: The Embedded Database That Replaces Solr, MongoDB, Kafka, and More
TonyBai
TonyBai
Mar 13, 2026 · Backend Development

Why DuckDB Beats ClickHouse for Light‑Weight Analytics: 18 M Rows/sec in a Single Go Binary

The article analyzes why traditional row‑oriented databases struggle with high‑volume analytics, introduces DuckDB as an embedded columnar engine for Go, presents benchmark results of up to 18.6 M rows per second writes and 6 M rows per second scans, walks through the Appender API code, and outlines the trade‑offs and ideal hybrid architecture.

DuckDBGoOLAP
0 likes · 11 min read
Why DuckDB Beats ClickHouse for Light‑Weight Analytics: 18 M Rows/sec in a Single Go Binary
dbaplus Community
dbaplus Community
Oct 11, 2025 · Databases

Why SQLite Is the World’s Most Ubiquitous Database and Its Road to 2050

SQLite, the lightweight embedded SQL engine created by Richard Hipp, powers virtually every smartphone, computer, browser and countless desktop apps, and thanks to its strict backward‑compatible C API, exhaustive documentation, extensive comments, rigorous cross‑platform testing, and a tiny dedicated team, it aims to remain reliable and widely used through 2050.

SQLitebackward compatibilitydocumentation
0 likes · 9 min read
Why SQLite Is the World’s Most Ubiquitous Database and Its Road to 2050
dbaplus Community
dbaplus Community
Sep 9, 2024 · Databases

Why SQLite Powers Billions of Devices: Real-World Use Cases Explained

SQLite, the lightweight embedded SQL engine created in 2000, is the world’s most deployed database, powering mobile apps, embedded systems, desktop software, data analysis tasks, and even browser‑based acceleration via WebAssembly, thanks to its zero‑configuration design and broad language support.

Data AnalysisMobile DevelopmentSQLite
0 likes · 8 min read
Why SQLite Powers Billions of Devices: Real-World Use Cases Explained
ITPUB
ITPUB
Sep 4, 2024 · Databases

Why SQLite Is the Tiny Yet Powerful Database for Mobile and Embedded Apps

This article introduces SQLite, explains why it is the most widely deployed lightweight SQL engine, outlines its common use cases in mobile, desktop and IoT devices, compares it with MySQL and PostgreSQL, and provides step‑by‑step installation instructions.

Database InstallationSQLiteembedded database
0 likes · 6 min read
Why SQLite Is the Tiny Yet Powerful Database for Mobile and Embedded Apps
Java Tech Enthusiast
Java Tech Enthusiast
Sep 2, 2024 · Databases

Understanding SQLite: Usage Scenarios and Advantages

SQLite, a lightweight serverless relational database written in C, powers billions of devices and is used for mobile app storage, embedded systems, offline desktop applications, small‑to‑medium data analysis, and browser‑based acceleration via WebAssembly, supporting languages such as C, C++, Java, Python, and Swift.

Data AnalysisIoTSQLite
0 likes · 5 min read
Understanding SQLite: Usage Scenarios and Advantages
ITPUB
ITPUB
Jan 22, 2024 · Databases

Why SQLite Became the World’s Most Popular Embedded Database

This article traces SQLite’s origins from a 2000 Navy project, explains how its first version wrapped GDBM, details its layered architecture and code flow, and shows how Richard Hipp’s philosophy of building every component himself turned SQLite into the ubiquitous embedded database we see everywhere today.

GDBMRichard HippSQLite
0 likes · 10 min read
Why SQLite Became the World’s Most Popular Embedded Database
dbaplus Community
dbaplus Community
Jan 21, 2024 · Databases

Why SQLite Dominates Everywhere: Origins, Architecture, and Secrets

This article explores why SQLite is the world’s most ubiquitous database, tracing its birth from a Navy project, its early implementation atop GDBM, the layered architecture that processes SQL statements, the transition to a B‑tree engine, and the creator’s philosophy of self‑contained software.

GDBMRichard HippSQL Engine
0 likes · 10 min read
Why SQLite Dominates Everywhere: Origins, Architecture, and Secrets
Laravel Tech Community
Laravel Tech Community
Nov 16, 2022 · Databases

DuckDB New Release Highlights and Feature Changes

The article introduces DuckDB, a high‑performance embedded analytical database, outlines its new release’s storage, performance, and memory improvements, describes its C/C++ integration and build process, and lists key feature changes such as parallel execution, novel compression methods, and enhanced SQL capabilities.

CompressionDuckDBParallelism
0 likes · 3 min read
DuckDB New Release Highlights and Feature Changes
Java Architecture Diary
Java Architecture Diary
Jun 6, 2020 · Cloud Native

Explore Nacos 1.3.0: Embedded DB, New Raft Protocol, and High‑Availability

Nacos 1.3.0 introduces an embedded relational database, unified cluster management, an upgraded Raft consistency layer, security patches, Snowflake ID configuration, data migration guidance, new cluster addressing modes, and a set of Open‑API operations for Raft administration, all aimed at simplicity, performance, and high availability.

NacosRaftSecurity
0 likes · 10 min read
Explore Nacos 1.3.0: Embedded DB, New Raft Protocol, and High‑Availability
Programmer DD
Programmer DD
Aug 8, 2019 · Databases

How to Quickly Set Up H2 Embedded Database with SpringBoot and MyBatis

This article explains the lightweight features of the pure‑Java H2 embedded database, demonstrates its various modes—including in‑memory, file‑based, and standalone server—and provides step‑by‑step integration with SpringBoot and MyBatis for rapid development and testing.

JavaMyBatisSpringBoot
0 likes · 9 min read
How to Quickly Set Up H2 Embedded Database with SpringBoot and MyBatis
MaGe Linux Operations
MaGe Linux Operations
Aug 25, 2015 · Databases

Why SQLite Might Be the Perfect Database for Mobile Apps

This article introduces SQLite, a lightweight ACID‑compliant relational database widely used in mobile devices, detailing its zero‑configuration design, key features, limitations, transaction and locking mechanisms, and the Write‑Ahead Logging mode that enables concurrent reads and writes.

Mobile DevelopmentSQLiteTransactions
0 likes · 11 min read
Why SQLite Might Be the Perfect Database for Mobile Apps