Tips for Designing a Minimalist Data Warehouse Suitable for an Embedded Device

I am trying to create a data warehouse implementation such as SQLite, BerkeleyDB or CouchDB suitable for a small embedded computer platform. The main criteria are a minimal bloated and simple API.

I could not find any products that fit my needs. SQLite is too small and mimics relational databases. CouchDB has a nice RESTful API, but it's bloated.

Mostly my goals:

  • Written in C.
  • A key value model preferred by the relational model.
  • RESTful web server and API.

I am struggling with developing a database backend. What is the best way to store data? How to organize it with minimal loss of performance? How do other implementations handle this (e.g. SQLite)? Is there any literature on this?

Thanks!

+3
source share
2 answers

try the Qdbm suite (qdbm.sourceforge.net). This is the fastest and most flexible key / value store I have used. Here you can find a comparazone with other similar packages:

http://qdbm.sourceforge.net/benchmark.pdf

If the repository is hard to read, you can also try the CDB package from DJB.

Hope this helps!

+2
source

, Redis - , ?

+1

Source: https://habr.com/ru/post/1724177/


All Articles