wish: SQLite or SQL backend

[Matt]

I've read the old #1343168 wish, but I'll request this again since many things may have changed since then. I don't really have the exp to contribute with the coding, but, if it is possible somewhere in the future i think it would be really great to have a sqlite backend and/or mysql powered network accounting (in addition, and not replacing, the current xml storage; kinda like GNUcash offering different choices). Homebank is awesome, thanks for this great work Maxime!

[Maxime DOYEN (mdoyen)]

the #1343168 purpose was about sharing a file, an the proposal of using SQL was a wrong path for that.
is your goal the same or different ?
what are your argument/requirements to ask for, not having SQL capabilities, but having a SQL backend ?

[Matt (blunt21)]

Hi, sorry for the confusion, what I wanted to mean with 'SQL capable' and 'having a SQL backend' was the same thing, so I used them interchangeably. With all this I was thinking it would be great to be able to use homebank in a kind of networked fashion in addition of the current single-user/single-machine model, maybe it could be useful for small bussiness or proyects with multiple users simultaneosly (thus sharing the same set of accounts and transfers); maybe this could be achieved adding the capacity to connect to some SQL backend (with some changes in the form the data is stored of course) e.g.:
*multiple homebank clients working with a central SQL backend (like mysql)
*something like various homebank running using a shared sqlite db over a networked filesystem (SMB, NFS..) -the obvious disadvantage of this scenario over the previous one is the blocking nature of writings to the db, however, for small projects I guess would be pretty rare for two users saving transferences in the exact same moment-

(I still love the current XML storage, and I don't want it to dissapear, but maybe if such networked features are possible, they could coexist)

Thanks for such amazing software!

[Éliás Tamás (i-et-8)]

more recently libsql instead of sqlite:
https://turso.tech/libsql

This offers database encryption out of the box, so there are lot of awesome things that can be easily integrated using this lib.