Re: String lengths in the SQL backend

Derek Atkins wrote: > If you're loading all data all the time then the only benefit to the DB > backend over the XML backend is save-on-commit. For me, the biggest benefit is accessability of the data. XML query tools don't match their SQL counterparts even remotely. I'd go as far as saying that

Re: String lengths in the SQL backend

2008/11/18 Rolf Leggewie <[EMAIL PROTECTED]>: > Derek Atkins wrote: >> If you're loading all data all the time then the only benefit to the DB >> backend over the XML backend is save-on-commit. > > For me, the biggest benefit is accessability of the data. XML query > tools don't match their SQL co

Re: String lengths in the SQL backend

Rolf Leggewie wrote: > While it will complicate things > a little bit, I may probably use the guid space as key which is > inherently larger than the code space. Not only does it complicate things quite a bit (I have yet to find a tool that allows to link SQL tables and update the data in them ->

Re: Importing Data

On November 13, 2008 02:08:44 pm Marcus Wolschon wrote: > Derek Atkins schrieb: > > "Marcus Wolschon" <[EMAIL PROTECTED]> writes: > >> The linked sourceforge-project consists of * jGnucashLib, a > >> stable library for reading and writing gnucash's data-format, * > >> jGnucashEditor, a java-tool m

Re: Importing Data

2008/11/18 Phil Longstaff <[EMAIL PROTECTED]>: >> I remember talk about the gnucash-db-backend back when I started >> my first version, about 2 years ago. I'm still looking forward to seeing >> it completed and in actual use. It can scale so much better then the >> xml-file. > > How can I best supp

Re: String lengths in the SQL backend

"Marcus Wolschon" <[EMAIL PROTECTED]> writes: > Or using stored procedures to create transactions > uppon changes being made in other databases > on the same DBMS (like a webshop-database). We cannot depend on Stored Procedures because not all the supported DBs support them. > Please remember to

Re: String lengths in the SQL backend

Rolf Leggewie <[EMAIL PROTECTED]> writes: > One potentially VERY huge advantage of the SQL backend that I forgot is > of course simultaneous access by more than one user. Multi-user access is not a goal in the first release, but it is certainly something that would be nice to add. And yes, a SQL

Re: install etc

Carol, Carol Brown <[EMAIL PROTECTED]> writes: > Hi there, > > I am starting a small business and have done some research and most > agree that GnuCash is the best accounting program for Linux. But I am > dismayed to see that I have to download /source code/, which to me means > /compile/ and

Re: String lengths in the SQL backend

Derek Atkins wrote: Multi-user access is not a goal in the first release, but it is certainly something that would be nice to add. And yes, a SQL Backend is necessary but not sufficient for multi-user. Not addressing the multi user issue now will cause a significant number of bugs to be repo

Quickbooks to Gnucash conversion?

Hello, I ran across a reference that you were making a conversion from Quickbooks Pro to Gnucash 2.2.4 My accountant uses Quickbooks and I wish to convert the files over -- the accountant is basically computer iliterate. Can you help me out? Thanks, Gwyll __

Re: String lengths in the SQL backend

2008/11/18 Derek Atkins <[EMAIL PROTECTED]>: > "Marcus Wolschon" <[EMAIL PROTECTED]> writes: > >> Or using stored procedures to create transactions >> uppon changes being made in other databases >> on the same DBMS (like a webshop-database). > > We cannot depend on Stored Procedures because not all

Re: install etc

Carol Brown wrote: I am starting a small business and have done some research and most agree that GnuCash is the best accounting program for Linux. But I am dismayed to see that I have to download /source code/, which to me means /compile/ and /build/. Arghhh. I don't do compile and build. I a

Re: Importing Data

On November 18, 2008 09:54:41 am Marcus Wolschon wrote: > 2008/11/18 Phil Longstaff <[EMAIL PROTECTED]>: > >> I remember talk about the gnucash-db-backend back when I started > >> my first version, about 2 years ago. I'm still looking forward to seeing > >> it completed and in actual use. It can sc

Re: install et

Carol Brown wrote: I am starting a small business and have done some research and most agree > that GnuCash is the best accounting program for Linux. But I am dismayed to > see that I have to download /source code/, which to me means /compile/ and > /build/. Arghhh. I don't do compile and build.