poirot Posted April 19, 2006 Share Posted April 19, 2006 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 Quote Link to comment Share on other sites More sharing options...
Roberto Posted April 19, 2006 Share Posted April 19, 2006 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 Quote Link to comment Share on other sites More sharing options...
poirot Posted April 19, 2006 Author Share Posted April 19, 2006 [!--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. Quote Link to comment Share on other sites More sharing options...
poirot Posted April 20, 2006 Author Share Posted April 20, 2006 Any ideas?Thanks Quote Link to comment Share on other sites More sharing options...
Roberto Posted April 20, 2006 Share Posted April 20, 2006 [!--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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.