GnuCash Oracle File Format
John Ralls
jralls at ceridwen.us
Wed Feb 8 10:32:57 EST 2012
On Feb 8, 2012, at 12:20 AM, JonBL wrote:
> Thanks, John for your response. I suggested my preferred back end was Oracle,
> because I'm an experienced Oracle DBA, and am familiar with using it as a
> repository for application development. While Oracle Enterprise and Standard
> editions are not free for commercial users, they are free for download by
> any user for evaluation purposes, and (I think) are free for use by
> non-commercial users such as home users. Oracle provides a free database and
> development environment called APEX, which is out there to encourage users
> of other database products to migrate to Oracle, and to provide an Oracle
> environment that any developer can manage without needing assistance from a
> DBA. APEX might provide a viable Oracle backend for apps such as GnuCash
> that anyone can use without violating Oracle's licensing requirements.
>
> For what it's worth, I would be happy to consider contributing to an Oracle
> backend option for GnuCash.
>
> I note your comment "Gnucash will create the database if it can and needs
> to." In my original post, I indicated I have mySQL now installed, but I
> can't select mySQL as a File -> Save As option. What specifically do I need
> to do to see mySQL as an available Save As option?
>
> I note that some other respondents to my original post suggest that it might
> be better to stick with XML for the time being. Is this your recommendation?
>
You also need the libdbi-driver for mysql. What that's called depends upon your distribution, but searching on that in your package installer should get you close enough.
Unless you want to use SQL queries against the data, yes, the XML backend is likely to be faster. With 2.4.9 we've got the data-loss issues that we know about fixed, but our test suite is not yet comprehensive enough to be sure that it's perfect.
Regards,
John Ralls
More information about the gnucash-user
mailing list