nostr:npub129gvast08lj986yftn7q5qlnj8yfqufxx0m33s9u5xssjm8c64rsve4kwg so I looked into it, and I don't have the energy to manage PostgreSQL 😅. Any reason you chose that over an embedded SQLite database?
nostr:npub1e08ly78d02u00zjqy4y647vw6mlw2m7wragpehrxvmft4cgul5wqxs6ucj It just became the default database system for me since it is more flexible than SQLite. But since I don't have any complex queries in OxiTraffic, I will look into supporting SQLite as well. I will let you know when I have progress :D
For me personally, it is just an additional Podman container. But I understand that it is not as convenient as SQLite.
nostr:npub1e08ly78d02u00zjqy4y647vw6mlw2m7wragpehrxvmft4cgul5wqxs6ucj I did look into it and did also update my helper crate to support SQLite too:
https://codeberg.org/mo8it/oxi-axum-helpers/src/branch/main/CHANGELOG.md
BUT, when I wanted to implement support for both databases in OxiTraffic, I did realize that SQLx does not have good support for multiple databases yet:
https://github.com/launchbadge/sqlx/issues/916
and
https://github.com/launchbadge/sqlx/issues/121
I could use one of the suggested workarounds like having multiple crates in a workspace, but that would be really overwhelming for testing, publishing etc.
