Jump to content


Photo

Flatfile Databases...


  • Please log in to reply
4 replies to this topic

#1 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 19 April 2006 - 05:01 PM

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
~ D Kuang

#2 Roberto

Roberto
  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationLondon, England

Posted 19 April 2006 - 05:59 PM

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
*************************************
Mad Mouse Media Web Design
t: (+34) 610 837 558
e: rob@madmousemedia.co.uk
w: www.madmousemedia.co.uk
w: www.madmouseart.com *************************************

#3 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 19 April 2006 - 06:06 PM

[!--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.
~ D Kuang

#4 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 20 April 2006 - 06:14 PM

Any ideas?

Thanks
~ D Kuang

#5 Roberto

Roberto
  • Members
  • PipPip
  • Member
  • 16 posts
  • LocationLondon, England

Posted 20 April 2006 - 06:34 PM

[!--quoteo(post=366526:date=Apr 19 2006, 07:06 PM:name=poirot)--][div class=\'quotetop\']QUOTE(poirot @ Apr 19 2006, 07:06 PM) View Post[/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
*************************************
Mad Mouse Media Web Design
t: (+34) 610 837 558
e: rob@madmousemedia.co.uk
w: www.madmousemedia.co.uk
w: www.madmouseart.com *************************************




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users