Jump to content

Flatfile Databases...


poirot

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.