On: DuckDB – An embeddable SQL database like SQLite, b...

[KingOfCoders]

Sorry for my perhaps stupid question,

has anyone tried this with ESP32/Arduino? I would need an anlytical DB for an hiking application (Temperatur/Pressure data etc.)

[Avamander → KingOfCoders]

Ooh, this sounds like a fun use-case but a power loss sounds super painful.

[KingOfCoders → Avamander]

Would also store on MicroSD.

[jimsmart → KingOfCoders]

That’s part of the problem. Power loss during SD card write will, more likely than not, cause corruption - FAT file systems do not have journaling.

[KingOfCoders → jimsmart]

Well yes. But then it's just hiking not emergency services, SD cards also do break, so I would need dual slot etc.