Re^5: Database in a folder?

I'm glad you didn't list anything that people actually expect from a database. Atomicity. Consistency. Isolation. Durability.

Consider the following. Your database monitors your flock of sheep, and the number of gold coins in your pocket. ${$sheep}{$count} stored in \somedatadir\sheep and ${$coins}{$gold} stored in \somedatadir\coins.

Now you sell a sheep for 15 coins. Now you've got to subtract 1 from one counter, and add 15 to another. What happens if your program fails after finishing one task, and before starting the other? Your data is no longer consistent, and in the best case, you go bankrupt, and in the worst case you'll be arrested after failing the SEC's audit.

Comment on Re^5: Database in a folder? Select or Download Code

Replies are listed 'Best First'.
Re^6: Database in a folder? by Anonymous Monk on Feb 19, 2010 at 03:27 UTC
So you don't keep any information in non-ACID compilient storage huh? You're a programmer right, so your source code is pretty important to you.	[reply]
Re^6: Database in a folder? by AriSoft (Sexton) on Feb 19, 2010 at 17:48 UTC
Atomicity. Consistency. Isolation. Durability. Have your ever seen database which has lost consistency and durability giving you a great isolation to your data which practically appears to be broken into atoms? I think you have :-) There must be some reason why /etc/passwd is not in a database.	[reply]