John, et al, My experience with GNUCash and using a MySQL over LAN and to a remote web hosting provider have been good. I have used it over a dial-up connection, satellite internet, cable, and usin FoxFi on the Android for internet. What I have found is that if the connection is lost, GNUCash will report that it cannot write to the server, but it writes when the Internet connection has been re-established. I found this out when I was using GNUCash on my netbook with WinXP, over PDAnet when someone called me while I was entering in transaction data from receipts. GNUCash gave me the error I already stated, and when the internet connection was restored, it wrote the data to the MySQL server.
I checked the accuracy of the data on a Windoz desktop, and it was all there. I'm not much into MySQL yet, but so far I have yet to see any massive rewrites on my local MySQL server. I watch the logs and see what it does when I leave GNUCash open for a while without doing anything and see what it does when I am entering transactions. The vision I had for the GFA was a simple one. Not an application that made reports or anything of that craziness, just a way to enter in transaction data, and get an updated balance. The rest of the accounting/financial wizardry that GNUCash can be left up to the desktop version. Other users that I've run into over the years that use GNUCash made statements along the lines of just being able to use their smartphone or tablet to enter in transaction data. Some wanted reports, but seriously, I really don't see a major reason for serious reporting while on the go. Catering to some kinds of people can be a real pain the ass. Some will never be satisfied, and so what. I do not know much about coding, but I can find the "appliance user" situations and give reports back that hopefully will provide somewhat reasonable and intelligent answers. ~Benjamin On Mon, 2012-11-26 at 17:32 +0900, John Ralls wrote: > On Nov 26, 2012, at 11:41 AM, Benjamin L. Naber <benja...@project23d.com> > wrote: > > > I hope I got the right listing for this... > > > > Anyway, after seeing that GNUCash has been released on Google Play, I > > got to playing around with GNUCash on my Ubuntu 10.04 laptop. It was > > stated that Android doesn't yet support MySQL, but I'm not sure I > > understood what he meant by that are there are RDBMS clients and > > applications that can upload MySQL data such as QuickNote, available on > > Google Play. > > > > I had to get the 2.4 version from getdeb.net as the version that comes > > with Ubuntu 10.04 is 2.2 or something like that. Either way, the older > > version of GNUCash I had did not support MySQL for data reading/writing. > > > > After a few rounds getting it work, and fussing with MySQL, I realized > > that I was making the errors, and needed to fix myself. So I did. > > > > I read some of the lists and from the wiki that folks want to have cross > > platform access to GNUCash. There are a number of ways, none of which > > seemed to me, as I know nothing compared to some of you, that there was > > already something in place that will work for most, if not all. > > > > I have GNUCash for both Windoz XP Pro, and Ubuntu. I'm able to build > > MySQL database tables with each GNUCash program, if the tables did not > > already exist. > > > > The caveat is that I'm able to access the same tables for both reading > > and writing with either operating system platform. No errors have been > > discovered....yet, and as long as I exit out of GNUCash on one machine > > before going to another, GNUCash doesn't have any issues. > > > > So, what I'd like to do is this. I have setup a small oscommerce and > > MySQL database webserver that I would like some of the developers to > > reply to me direct who is interested, and I will provide access details. > > I'm looking for your feed back as to how well it performs for you over a > > internet connection that goes out of my city, state, and possibly > > country. > > > > Should this be successful, I'm looking to market this on the gnucash.org > > website to users of GNUCash and other database users who only need one > > or a small amount of hosted databases for a small amount of cash each > > year. > > > > Of course, financial donations will be made to gnucash.org to show my > > appreciation as I know nothing of coding. > > Here's the fundamental issue with Android: Gnucash for Android (GFA) is a > separate application from Gnucash. In order to directly access a Gnucash > database, GFA would need the rather ungainly library code written in C with > GLib contained in Gnucash, which it doesn't. > > As for the web-backed service, well, that's kind of interesting. We were > discussing that a couple of weeks ago. There are at present some known or > suspected holes in our SQL implementation: Most things work, but there are > some reported bugs that indicate not everything does. We're working on better > test coverage to find the holes so that we can plug them. The next problem is > that Gnucash isn't a database application, it just uses the database as a > store. Most things it writes immediately and in reasonable transactions, but > a few things aren't set up correctly and it needs to delete and re-write the > whole database. That's going to kill performance over the net. We do intend > to fix that, but lack of good and complete tests lies between here and there. > > Regards, > John Ralls > _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
