Replying to Avatar Mo Bitar :ferris:

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.

Avatar
Mo Bitar :ferris: 2y ago

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.

Reply to this note

Please Login to reply.

Discussion

Avatar
Mo Bitar :ferris: 2y ago

nostr:npub1e08ly78d02u00zjqy4y647vw6mlw2m7wragpehrxvmft4cgul5wqxs6ucj This means that I should settle on one database. Since PostgreSQL is much more flexible, I would prefer keeping it.

But since you are the first one trying to use OxiTraffic, I could also make a breaking change to only support SQLite and hope that no one did host it until now except me. I can do a hacky migration for myself.