I tried using DuckDB in a recent project. In their Python API, it had trouble correctly handling binary blob inserts. I really should have started poking at the code and tried to submit a patch, but I also realized I'd probably need to write my own schema migration layer (I'm use to yoyo-migrations for sqlite3).

I ended up back on sqlite3. It seemed cool though; might pick it up again for a future project.