You could go with Postgresql. The corresponding viewer/tool is pgAdmin
III - both free, both excellent.
Bob G
On 02/23/2015 12:57 AM, Paul wrote:
Thanks for the idea John.
I had look around for an sqlite tool for analysing the database.
Theres a nice little sqlite reader/editor called sqliteman. However,
when i try to open the gnucash database it responds with:
Unable to open or create file accounts.gnucash. It is probably not a
database
I also found a free reporting tool for sql called openRPT but this
requires an interface to sqlite as its designed for "proper"
databases. The only interface i found is qsqlite which the developer
has declared obsolete and it needs sqlite 2.8. Clearly not a good path
to go down.
Does anyone know of any tools (for linux) that will empower me to view
and/or create reports from the database?
On 23/02/15 01:11, John Ralls wrote:
On Feb 22, 2015, at 4:04 PM, Bob Gustafson <[email protected]> wrote:
On 02/22/2015 05:48 PM, John Ralls wrote:
On Feb 22, 2015, at 3:37 PM, Paul <[email protected]> wrote:
Hello all
I admire what you are trying to do and wish to support you with
some feedback.
My usecase: "We want to see whats happening to our money."
I downloaded and installed gnucash a couple of days ago because
the need arose to manage our accounts. After connecting to online
banking services and downloading all our transactions I got
everything working perfectly. AWESOME!! Problem solved I thought
as I proceeded to the reporting to pull out some data for my
partner...
What a disappointment. The stock reports are imo ugly and
inadequate for our use case. We are interested in cash flow and
the editing options for this report are minimal. Very minimal.
Being a qualified programmer I investigated the options for
customising our reports somehow. I quickly found the answer to all
of my reporting woes. I have to learn not one, but two obscure
programming langages, namely guile/eguile and scheme.
In conclusion: I can't be bothered. I will have a look for
something else that can output beautiful, professional and, if
necessary, customizable reports.
I will report back with my findings if you like.
Actually, Guile and Scheme are the same language.
You might consider the SQL backend; one variant, SQLite3 requires
no server. Using that instead of the default XML backend will allow
you to query the database with standard SQL tools and use a
SQL-based report writer to generate prettier reports.
Regards,
John Ralls
That is a great idea John - SQL report generation is quite a
flexible solution.
I forgot to throw in the usual caveat: There’s at least one spot in
the current release, the company information on the Business tab in
the File>Properties dialog, that isn’t correctly synced to the SQL
backend. That’s fixed for the next release, and in the meantime you
can use File>Save As to force a complete rewrite of your database to
save it if you need to. There may be other bits that I don’t know
about, though I just did another thorough audit and I didn’t find
any. Also you mustn’t write to the database except with GnuCash as
all of the business logic is in GnuCash, not in the database. We
haven’t even declared foreign keys in the database tables.
Regards,
John Ralls
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
____________________________________________________________
FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!
Check it out at http://www.inbox.com/earth
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
