SQLite based app self hosted on VPS architecture & approach help needed

Thanks, that’s very valuable. I was hoping duckdb would be the panacea and the all in one tool for both, analytics/transformation and as a backend. Well, it’s good to hear that SQLite is faster as a backend because it’s very well integrated with Elixir/Phoenix.

I did some experiments with duckdbex for reading parquet files. It was good but messy due no support with Ecto.

Anyway, good luck with your own duckdb for Elixir and the Ecto support.