Re: Installing GNU Cash with PostGreSQL

2009-07-09 Thread Albert Lash
Hi Anders, I believe the SQL backend uses libdbi, so that might be a good starting place. That's about all the advice I can offer as I don't use Windows. - Albert On Thu, Jul 9, 2009 at 8:24 PM, Anders Johansson wrote: > How do I install GNU Cash to use PostGreSQL as the backend?  I am running W

Re: GnuCash and PHP

2008-10-05 Thread Albert Lash
> b) can you verify that this is what the new dbi-sql-backend looks like? > > -derek > > Quoting Albert Lash <[EMAIL PROTECTED]>: > >> Hi Jeremy, >> >> This is a great idea. I've been working on a web-based accounting >> system, and I've been w

Re: GnuCash and PHP

2008-10-05 Thread Albert Lash
Hi Jeremy, This is a great idea. I've been working on a web-based accounting system, and I've been working to get it to use the same SQL backend as GnuCash. Its not there yet, but I've done some research on the SQL backend, though its a little out dated now: http://www.pbooks.org/wiki/GnuCash_Da

Re: GDA: Status

2008-06-03 Thread Albert Lash
>> >> One problem with libdbi is that its scope doesn't cover everything that >> libgda's does. From what I can tell, libdbi doesn't have any apis to >> cover table/index creation, and that is one area that has a lot of >> individuality (e.g. autoinc integer fields). > > Is that the only individua

Re: GDA: Porting to libgda 4

2008-05-11 Thread Albert Lash
I'm available to assist if I can be of any help. On 5/11/08, Phil Longstaff <[EMAIL PROTECTED]> wrote: > The writing seems to be on the wall for the rev3 branch of libgda. > Their response to a bug report I filed against rev3 was that they > weren't going to be maintaining it but that I should s

Re: More GDA Testing

2008-04-24 Thread Albert Lash
Phil, Please let me know what other information or help I can provide. I'm all thumbs when it comes to c but fairly capable with SQL. Albert > > #5 > > #6 0xb75ce3a0 in qof_instance_set_guid (ptr=0x80a9d20, guid=0x0) > > at qofinstance.c:490 > > #7 0xb75cef8f in qof_instance_set_prope

Re: More GDA Testing

2008-04-23 Thread Albert Lash
Hi Derek, Thanks for helping, I hope this is what you mean: System: Linux 2.6.22-3-686 #1 SMP Sun Feb 10 20:20:49 UTC 2008 i686 X Vendor: The X.Org Foundation X Vendor Release: 1030 Selinux: No Accessibility: Disabled GTK+ Theme: Glossy Icon Theme: gnome Memory status: size: 80785408 vsize:

More GDA Testing

2008-04-23 Thread Albert Lash
Hello, I've been trying out the gda-dev2 branch today and I'm able to start up, create a file, and save it as "barf.db". When I quit the program and try to start up again, I get an error: #14 0xb75daf8a in qof_session_load (session=0x84e81e8, percentage_func=0xb747d9f0 ) at qofsession.c:1

GDA Testing SQLite

2008-02-06 Thread Albert Lash
Oh yeah here is the non-strace error: Implementation missing: database_constraints_update_list() in gda-dict-database.c line 1214 Implementation missing: database_constraints_update_list() in gda-dict-database.c line 1214 Segmentation fault (core dumped) -- My Blogs: http://www.docunext.com/ ht

GDA Testing SQLite

2008-02-06 Thread Albert Lash
Hi, I am trying to use gda-dev2 with sqlite, and I'm able to start up and create a database, but after I save and exit, I receive a segfault upon restarting. I straced and see this: access("/home/user/.gnucash/data/test.db-journal", F_OK) = -1 ENOENT (No such file or directory) Is there somethin

Fwd: GDA svn 16927 performance

2008-02-06 Thread Albert Lash
That is terrific news! I'm almost ready to start testing gda, just been wrestling with dependencies so far. I'm using xfce4 so I don't have all the gnome stuff yet. On Feb 6, 2008 4:32 AM, Mark Johnson <[EMAIL PROTECTED]> wrote: > Phil, > > I just did some timing tests with the latest svn (16927)

Re: GDA: possible problem

2008-01-31 Thread Albert Lash
wouldn't want to entrust live data to it yet. > So unless you want to set up parallel gnucash instances and test data > files, it will be some time yet before it makes sense to try what you > ask. > > Dave > > On Jan 31, 2008, at 6:10 AM, Albert Lash wrote: > > >

Re: GDA: possible problem

2008-01-31 Thread Albert Lash
wrote: > > On Jan 30, 2008, at 5:55 PM, Albert Lash wrote: > > > Just wanted to chime in here and mention that I'm also interested in > > using a SQL powered storage mechanism with GnuCash. Since GnuCash is a > > desktop application, I was thinking SQLite might be a g

Re: GDA: trouble with MySql

2008-01-30 Thread Albert Lash
On second thought I'm not sure if MySQL has ever been used with GnuCash, or if it supported On Jan 30, 2008 5:48 AM, Nigel Titley <[EMAIL PROTECTED]> wrote: > Mark Johnson wrote: > > Phil, > > I wanted to try gnucash-gda with MySql. I suspect the postgresql > > provider of poor performance an

Re: GDA: possible problem

2008-01-30 Thread Albert Lash
Just wanted to chime in here and mention that I'm also interested in using a SQL powered storage mechanism with GnuCash. Since GnuCash is a desktop application, I was thinking SQLite might be a good candidate. I think GnuCash has connected with Postgres and MySQL, but has anyone ever tried SQLite?

Locales

2008-01-09 Thread Albert Lash
Hello, I've noticed a few emails on the list about locales and translations lately, so I thought it might make sense to see if PBooks and GnuCash could share some translation docs. I looked in the GnuCash source and found some XML files (nice! - that's how PBooks is handling i18n so far), and then

Re: SQL Backend?

2007-07-24 Thread Albert Lash
> That's right; each backend is basically stand-alone. Of course it shares a > rough outline with the runtime object model and XML data-model, just by > nature. Hmm, I'm a little confused now. The code referenced earlier had to do with GDM, right? And GDM was replaced by QOF? Or is it that they t

Re: SQL Backend?

2007-07-21 Thread Albert Lash
Yep, thanks for digging the gnc-transaction-gda.c code up. This is sort of what I was looking for: 107 static col_cvt_t split_col_table[] = 108 { 109 { "guid",CT_GUID, 0, COL_NNUL|COL_PKEY,NULL, 110 get_guid, set_guid }, 111 { "tx_guid",

Re: SQL Backend?

2007-07-20 Thread Albert Lash
Very interesting, that's probably what I'm looking for so I'll try to dig that up. On 7/20/07, Hale Boyes, Kevin <[EMAIL PROTECTED]> wrote: > Albert Lash wrote: > > Is the data model that is / was used for the SQL backend around > > anywhere? > > >

Re: SQL Backend?

2007-07-19 Thread Albert Lash
Is the data model that is / was used for the SQL backend around anywhere? On 7/19/07, Nathan Buchanan <[EMAIL PROTECTED]> wrote: > > On 7/19/07, Derek Atkins <[EMAIL PROTECTED]> wrote: > > > > keith <[EMAIL PROTECTED]> writes: > > > > > There was a thread going last year on the SQL backend. I'd be

Re: Generating a PR buzz for 2.2.0

2007-07-11 Thread Albert Lash
I will be happy to post about GnuCash 2.2.0 on our finance related blogs: http://www.informedbanking.com/resources/blog/ and http://www.pbooks.org/ Great work you guys! On 7/11/07, Nathan Buchanan <[EMAIL PROTECTED]> wrote: > > Hi Manfred! > > Thanks for the list, and my apologies for not resp

Re: MySQL

2007-06-01 Thread Albert Lash
Hi Phil, Can you CC me as well. This is something I would be interested in as well. Thanks, Albert On 6/1/07, Phil Longstaff <[EMAIL PROTECTED]> wrote: > > Hi William, > > I have an official project underway to develop a backend for GnuCash using > GDA (Gnome Data Access?) which allows differen

Re: Similarities between CSV and QIF importers?

2007-05-29 Thread Albert Lash
Hi Benny, I just happen to have examined the code for Finance::IIF, and I'm surprised at how similar the IIF format is to TSV (tab separated values). If what I think is correct, IIF is TSV. I realize you are talking about QIF, but since you also mentioned CSV, it might be an easy addition to incl