Embedded Database with OceanBase: vscode + Python + SeekDB

Embedded Database with OceanBase: vscode + Python + SeekDB

Experience Vibe Coding Through Hands-On Experiments The prerequisites before the experiment are: 1. Install VSCode properly 2. Set up the Python environment 3. Need SeekDB 4. Need PowerMem 5. Jupyter plugin (not mandatory, but it’s recommended after practical use) Developers are already familiar with 1 and 2. However, few people know about 3 and 4. … Read more

TileDB: Unlocking the Infinite Potential of Multidimensional Arrays with a Powerful C++ Library

TileDB: Unlocking the Infinite Potential of Multidimensional Arrays with a Powerful C++ Library

Beyond File Storage: Unlocking the Infinite Potential of Multidimensional Arrays with the TileDB Library In today’s data-driven era, we are no longer just dealing with tabular data (like CSV) or documents (like JSON). Fields such as scientific computing, Geographic Information Systems (GIS), genomics, remote sensing imagery, and time series analysis generate vast amounts of multidimensional … Read more

Introducing a Database for Embedded Design

Introducing a Database for Embedded Design

Introduction: Due to limited resources, embedded systems cannot store important data as conveniently as databases interfacing with operating systems. Therefore, this article will introduce the principles and applications of an embedded database, TinyFlashDB, analyze its advantages in resource-constrained environments, summarize pain points and solutions in practical development, and complete the porting and functional verification of … Read more

DuckDB: An Embedded In-Memory Database

DuckDB: An Embedded In-Memory Database

Introduction Traditional relational databases, such as MySQL and PostgreSQL, often face performance bottlenecks when handling large-scale data. Data warehouses require complex deployment and maintenance. A “newcomer” in the database field—DuckDB—is changing the way we analyze data with its unique charm. What is DuckDB? In simple terms, DuckDB is anembedded, in-process, OLAP database. Embedded: This means … Read more

Lightweight Embedded Database FlashDB

Lightweight Embedded Database FlashDB

“Currently, I am using FlashDB in mass-produced medical products. It is stable, reliable, and convenient, so I recommend it. I will continue to share the technologies I use in embedded systems and artificial intelligence, so follow me for more references to accelerate your development process.” —Love Programming, Love Life FlashDB: A Lightweight Embedded Database Providing … Read more

Stop Tying Down MySQL! The Ultimate Guide to Nacos Embedded Derby Solutions and Database Selection

Stop Tying Down MySQL! The Ultimate Guide to Nacos Embedded Derby Solutions and Database Selection

When you are struggling locally with Nacos and exclaim, “Installing MySQL, configuring master-slave, changing ports… I just want to run a demo locally!” In fact, 90% of developers do not know: you can start Nacos with zero dependencies without installing MySQL—the secret lies in the embedded database Derby. 1. Derby: The Overlooked King of Embedded … Read more

Introduction to ITTIA DB Lite 9.x

Introduction to ITTIA DB Lite 9.x

1 Product Introduction ITTIA DB Lite is a high-performance embedded transactional and time-series database that natively supports eMMC (embedded multimedia card), SD cards, NOR (non-volatile random access memory), and NAND flash memory. It is designed for real-time operating systems (RTOS) and bare-metal applications to facilitate data streaming, analysis, and storage on edge microcontroller (MCU) devices. … Read more

Embedded Databases in Real-Time Systems

Embedded Databases in Real-Time Systems

The Future of Database Real-Time Performance “Real-time” is a term frequently mentioned by database system vendors, but real-time has a specific meaning in embedded systems. According to geeksforgeeks.org[1]: “A real-time system is one where the system is affected by real-time constraints, meaning it must respond within specified timing constraints or meet defined deadlines. For example, … Read more

Implementing a Lightweight Embedded Database in C++

Implementing a Lightweight Embedded Database in C++

Creating a Mini Embedded Database with C++ – A Practical Journey from 0 to 1 Databases might sound intimidating, but we can actually create a simple one using C++. Today, I will guide you in implementing a lightweight embedded database that, despite its small size, is fully functional with basic CRUD capabilities. This small project … Read more