| |||||||||||||
Accounting systems: a rant and a questAccounting systems: a rant and a questPosted May 31, 2012 15:09 UTC (Thu) by nybble41 (subscriber, #55106)In reply to: Accounting systems: a rant and a quest by tuxino Parent article: Accounting systems: a rant and a quest
> 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 ? :)
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?
(Log in to post comments)
Accounting systems: a rant and a quest Posted Jun 1, 2012 12:04 UTC (Fri) by tuxino (guest, #84530) [Link]
That's what happens, in a way, when you schedule a database dump as part of a backup strategy.
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.
|
|||||||||||||