GNOME Bugzilla – Bug 90375
SQL Backend for Business
Last modified: 2018-06-29 20:15:40 UTC
Implement a SQL backend for the business objects
*** Bug 101234 has been marked as a duplicate of this bug. ***
*** Bug 162502 has been marked as a duplicate of this bug. ***
Err.. Derek, can you add some quick notes about how this is achieved and what needs to be done? The very same steps needs to be done for the HBCI importing modules bug#165096 , so I would be glad to have some hints on how to do this.
What needs to be done to solve this is a complete SQL re-write. The whole way the SQL backend interacts with GnuCash objects needs to be fixed. The Query mechanism needs to be extended to handle queries for objects besides transactions. And each "new" object needs to get sql tables and lookup/commit functions. Basically, the code just isn't modular enough.
*** Bug 330798 has been marked as a duplicate of this bug. ***
I'm wondering, I've been watching this bug for over a year now I think. Are there coders on the project capable of doing this proposed re-write? If so, what kind of monetary compensation would those coders require to knock this out? Our company could seriously use a db backend (preferably postgres) so that we can integrate with our billing system.
As far as I know there is nobody actively working on a SQL rewrite. I don't know how to answer your other questions, I'm afraid.
Tony Shadwick, how much is this worth to your company. I'm not a current gnucash developer, but I'd be willing to look into it. I have quite a bit of sql programming experience, so it wouldn't be too hard to figure out I think. Currently I just use gnucash personally.
Is this still something that needs to be done? The SQL backend has recently been added for gnucash as a whole. Or is this something else?
Well, it's something that needs to get into a major release... And I think there still needs to be lots of testing of this feature. But yeah, the new dbi backend does indeed solve this request.
In some future, I'm sure GnuCash will want to support multi-user access to the stored transactions through a database backend. If that is to happen, GnuCash will want to move to quick searches in the database, as it cannot rely on locally stored data. There is a very useful bit of research on storing XML-ish data in plain relational databases, and searching information in it _very_ fast. This approach uses an indexing method that is a truly clever find. I think it is worth an investigation by anyone contemplating to take on a database backend mapping: http://www-db.informatik.uni-tuebingen.de/research/pathfinder http://wwwhome.cs.utwente.nl/~keulen/wordpress/2006/06/mxq-sigmod2006/ http://wwwhome.cs.utwente.nl/~keulen/wordpress/category/research/pf-mxq/ I hope this is useful. Best regards, Dr.ir. Rick van Rein OpenFortress Digital signatures
The dbi/sql backend is a resolution to this and is targetted for 2.4.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=90375. Please update any external references or bookmarks.