Not logged in
Log in now
Create an account
Subscribe to LWN
LWN.net Weekly Edition for December 5, 2013
Deadline scheduling: coming soon?
LWN.net Weekly Edition for November 27, 2013
ACPI for ARM?
LWN.net Weekly Edition for November 21, 2013
apt-cache search ledger gives some interesting strings, which I've not seen mentioned so far.
Frontaccounting doesn't look bad to my (very) untrained eye.
From the FAQ:
"FA is PHP 4 and PHP 5 compatible and should run on MySQL 4.0 - 5.X.X Server"
They've got an online demo too,.
hledger looks bare but its main disadvantage IMHO is its data format (formatted text files, IIUC) and the fact that it's written in haskell.
sql-ledger seems quite featureful. Postgresql and perl are a plus to my eyes, but obviously that's irrelevant :)
Just my 2 cents.
Accounting systems: a rant and a quest
Posted May 31, 2012 0:29 UTC (Thu) by nybble41 (subscriber, #55106)
If those are the main _dis_advantages, it must be very nearly perfect. You're essentially saying that the disadvantages are that its storage is resilient and future-proof and that it's written in a language which is resistant against programming errors.
Personally, I'd list the user interface and security issues as the disadvantages, both due to its nature as an HTML-based webapp.
Posted May 31, 2012 7:17 UTC (Thu) by tuxino (guest, #84530)
Haskell is a problem _for me_ simply because I don't know it :-)
Seriously, though, I was thinking about the popularity of the language the ERP is written in and the ease of finding a developer to customize and maintain it.
This is probably a moot point, though, as the software publisher would probably be glad to receive money for this type of work :)
Text files don't seem to me like the best storage format for accounting data. RDBMS with ACID compliance where written for a reason, weren't they ? :)
Posted May 31, 2012 15:09 UTC (Thu) by nybble41 (subscriber, #55106)
Well, I was thinking that it's a lot easier to recover data from plain text file if something happens to go wrong. However, ACID compliance is also important, particularly if there are multiple users. Perhaps an RDBMS for active storage, and plain text for backups?
Posted Jun 1, 2012 12:04 UTC (Fri) by tuxino (guest, #84530)
Oh, and let's not forget things like foreign key constraints, stored procedures, views and other goodies, which are quite helpful when implementing accounting systems or any other similar application.
Posted May 31, 2012 19:42 UTC (Thu) by mathstuf (subscriber, #69389)
Posted May 31, 2012 20:13 UTC (Thu) by nybble41 (subscriber, #55106)
Oh, that's good. I saw the demo on their web site and assumed that HTML was the primary/only interface.
> It's also data-file compatible with ledger itself.
And here is a good reason for using plain text files: an RDBMS storage backend would have been unlikely to interoperate with other programs. Note that it couldn't be shared, of course, but the programs would need to agree on a precise database schema where text files, given an extensible syntax, offer more flexibility.
Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds