Why KaiwuDB Lite?
Lightweight Embedded Architecture
KaiwuDB Lite is a lightweight version that can run stably in environments as low as 1 core and 2 GB of memory. It supports an embedded integration solution, where the database services can be directly integrated into business applications without launching an independent process, enabling efficient local data processing and low-latency analytics.
High-performance Data Storage
With an optimized storage engine built in, KaiwuDB Lite supports schema-less writing and high-efficiency batch writing, and thus ensuring fast reading/writing and efficient storage for time-series data even in resource-constrained environments.
Flexible Data Query
KaiwuDB Lite supports multi-dimensional data analytics including time-range queries, aggregate computation, grouping and sorting, interpolation, and status windows. It is compatible with standard SQL, supports both routine queries and complicated time-series data analysis, providing efficient and accurate real-time data insights.
Various Accesses
KaiwuDB Lite is compatible with mainstream access methods such as HTTP, PostgreSQL, JDBC, ODBC, MyBatis-Plus and EMQX, adapting to a variety of technology stacks and integration solutions.
Complete O&M Services
KaiwuDB Lite provides all-around services including data lifecycle management, performance parameter configuration, data migration, backup and recovery, as well as user permission management, ensuring the long-term stablity and maintainability of the system.
Core Features
Lightweight Embedded Architecture
Specifically designed for edge IoT and embedded scenarios, KaiwuDB Lite offers flexible deployment options. It can run as a standalone database, providing standard services via the PostgreSQL protocol; alternatively, it can be embedded into applications, too. KaiwuDB Lite can offer plug‑and‑play services for edge devices such as Raspberry Pi, enhancing data processing efficiency and response speed.
High‑performance Data Processing
- KaiwuDB Lite was specifically optimized for data read/write performance during its design, delivering exceptional efficiency in both data writing and querying. It supports standard SQL writes as well as batch importing, and can write millions of data in seconds.
- It has a complete built‑in function ecosystem to meet diverse data query and analysis requirements.
- By adopting a column-based storage structure, it only reads data on target column, significantly reducing disk I/O and response latency.
- It has a built‑in intelligent query optimization mechanism—including parallel execution, dynamic plan adjustment, adaptive JOIN, multi‑level caching, and runtime statistics collection—effectively reduces data scanning volume and further improves computational efficiency.
Cost-effective Storage
KaiwuDB Lite adopts multiple technical approaches to achieve cost-effective storage.
- The column-based storage compression technique intelligently selects the optimal compression algorithm for different data types, achieving a 5–30× data compression ratio.
- It supports online real‑time compression, which means compression is performed simultaneously during data writing to balance storage efficiency and writing performance.
- It supports table‑level data lifecycle configuration, enabling automatic cleaning of historical data beyond a specified retention period, effectively control disk usage and further reduce storage and O&M costs.
Cloud‑edge-end Collaboration
KaiwuDB Lite can work with Enterprise KaiwuDB to build a comprehensive edge-to-cloud collaboration system. For key scenarios such as energy production and industrial manufacturing, KaiwuDB Lite is deployed on the edge side and end side, enabling real-time collection, storage, and millisecond-level data query of sensors and devices data. KaiwuDB, as the central database deployed on cloud, supports aggregation and integrated analysis of massive time-series data from various edge and end nodes, as well as relational data such as personnel statistic, device profiles, and business information. Taking the energy industry as an example, this solution delivers precise decision support for peak shaving and frequency regulation, operational monitoring and early warning, as well as other actionable business insights for enterprises.By integrating KaiwuDB Lite(high-performance end-side TSDB) with NeuronEX(an industrial edge gateway product of EMQ), this solution offers data capabilities including real-time data collection, processing, local storage and cloud‑edge-end collaboration, and thus forming a complete, efficient, low‑latency, and secure data foundation for industrial digitalization.
Open Ecosystem
- KaiwuDB Lite is compatible with mainstream programming languages including C/C++, C#, Java and Python, allowing developers to choose accordingly.
- It is also compatible with mainstream operating systems including Ubuntu, Kylin, and Windows, ensuring stable operation and multi‑environment deployment.
- It can be integrated with third‑party tools such as EMQX and Telegraf, enabling efficient data reading/writing with simple configuration.
KaiwuDB Lite & EMQX Joint Solution
Built on KaiwuDB and its data service platform, KaiwuDB Lite Plus is an all-in-one data solution designed for industrial edge-computing scenarios.