Re: [sqlite] Double entry bookkeeping

2009-03-05 Thread Alan Cohen
What you have laid out as a schema might me a bare minimum for most purposes. I've spent most of the last 30 years configuring and implementing financial systems, mostly General Ledger for a variety of clients and developers. Here are the top group of items I think you have missed: - multiple

Re: [sqlite] Best GUI?

2009-02-26 Thread Alan Cohen
This is a bit of a religious question, but which are the mest/most popular *nix GUIs out there? I'm using a firefox plugin but not entirely happy with it. What do you use and why? A lot depends on what you are trying to accomplish. For example, I move between several machines, mixed between

[sqlite] looking for data entry screen suggestions

2009-01-02 Thread Alan Cohen
I'm a relatively new SQLite user and I'm not much of a programmer, although I have used several database GUI Tools over the years, including code generators on PickOS and Windows. I've been able to extract my data from Palm Desktop (twelve years of accumulation), build tables and import my data