HN Explorer

Been in embedded for 20 years, and SQL sucks

2 points by catsareok ↗ HN
so what's a good alternative for low footprint embedded these days? i'd rather use json files and jq than sql tbh.

7 comments

[ 0.21 ms ] story [ 23.8 ms ] thread
joezydeco
Are you on 64-bit ARM? Maybe MongoDB.
catsareok
Yeah mostly Nvidia Jetson parts, so that'd prob work. Mongo seems to be a massive fav - I should dig in.

What do people think of CockroachDB?

Thanks.

aliasEli
What are your requirements?

It seems like you don't need ACID transactions or joins.

catsareok
I want to avoid joins at all costs. I’ve encountered far too many of them for purposes of “it would be fun to use a join,”. Basic requirements are storage of ints and strings, and mutex. Doesn’t need to be lighting fast, or have complex caching.
airbreather
sql light, source available, in c.

Don't know if it would fit your platform, but if it doesn't you could argue it doesn't need it, or maybe the database is off board?

catsareok
Sqlite3 blows. Worked it for years. It has caching and flash burn issues and also is just the worst “language” when it comes to schema updates and general use.
airbreather
Seems very popular for something so problematic.