[g15jv2dp]

Another thing to consider is that sqlite dynamically allocates memory. You typically want to avoid that in embedded. Everything is slow, memory is scarce. The sheer code size is also a issue.

[FredFS456]

Sqlite has a mode where you can give it an area of memory and it will never use any other memory.

[g15jv2dp]

It's still going to dynamically allocate its memory in there, isn't it? This is a slow operation.

[jmole]

Memory allocation isn’t that slow (in fact all the ram is SRAM which is typically quite fast), it’s just that you only have 256k-1M RAM in total. This means that any time you’re saving later by trying to fill space now ends up getting wasted when that memory needs to be reclaimed.