Jump to content

Archived

This topic is now archived and is closed to further replies.

poirot

Flatfile Databases...

Recommended Posts

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
[!--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.

Share this post


Link to post
Share on other sites
[!--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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.