Flatfile Databases...

[poirot]

Well, let's say I have some sort of prejudice against MySQL (which just became worse thanks to dozens of "Too Many Connections" errors) so instead of using a MySQL server, I am going to use a Flatfile DB for my site.

The thing is, it's not hard to make FF work, as long as I don't have much connections. But supposing my site gets more and more hits, so anytime a user updates the FF db, if there is another user, at exactly the same time, some changes will be lost.

In this scenario, I'd create a "queue" thing, but I'd also use FlatFile for the queue. Wouldn't I be falling back to the original problem?

Thanks

[Roberto]

Ha! So you won't use mySQL because it has this problem, but you find you can't solve it yourself. Do you really think you can make a FF database yourself which is going to perform better than mySQL which has lots of developers and has been going for years?

Have you tried Postgress SQL database? It's supposed to be better than mySQL, and is also Open Source - [a href=\"http://www.postgresql.org/\" target=\"_blank\"]http://www.postgresql.org/[/a] (although I've never used it myself, mySQL has always been good enough.)

Rob

[poirot]

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Ha! So you won't use mySQL because it has this problem, but you find you can't solve it yourself.[/quote]
Actually that I got the "Too Many Connections" error trying to access this forum.
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Do you really think you can make a FF database yourself which is going to perform better than mySQL which has lots of developers and has been going for years?[/quote]
Sort of. I am not expecting it to be better than MySQL (which would be impossible), but as I said before, I just don't like MySQL.

And basically I want an alternative if the server doesn't have a SQL server.

[poirot]

Any ideas?

Thanks

[Roberto]

[!--quoteo(post=366526:date=Apr 19 2006, 07:06 PM:name=poirot)--][div class=\'quotetop\']QUOTE(poirot @ Apr 19 2006, 07:06 PM) [snapback]366526[/snapback][/div][div class=\'quotemain\'][!--quotec--]
And basically I want an alternative if the server doesn't have a SQL server.
[/quote]
Do you know about sqlLite? It provides an SQL database from php without the server needing any database installed. The info is here:

[a href=\"http://uk2.php.net/manual/en/ref.sqlite.php\" target=\"_blank\"]http://uk2.php.net/manual/en/ref.sqlite.php[/a]

Rob