Been in embedded for 20 years, and SQL sucks

[catsareok]

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

[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.