I am searching for a good database for a server application. I am thinking about MySQL, Postgresql, sqlite or Firebird. My favorite at the moment is sqlite. I like it. I don’t need any special things. Just storing and managing data. But there is one negative point with sqlite. It’s bad on multiple request at the same time, because sqlite cannot run more then one request at a time. It would be necessary to write a little dbms to manage more requests.
What do you think? [import]uid: 7645 topic_id: 1814 reply_id: 301814[/import]
What are your needs? If you have a rather huge app that will generate a large number of requests and have to manage them extremely well, then I would go with PostgreSQL. MySQL is another strong option, but make sure to look through the Oracle licensing information. If you are looking at large-scale commercial-level databases, then Oracle or MSSQL are nice options as well as long as you have the server infrastructure and pocketbook for them. If you are looking at a simple storing method of usernames, passwords, settings data, etc then any of them should be good. [import]uid: 7077 topic_id: 1814 reply_id: 5586[/import]
Mysql is probably the most ubiquitous and as most hosting companies running Linux use it, it’s everywhere. I think it’s a solid DB let down by poor tools. I run mysql workbench on os x which I find quirky and buggy. As a commercial developer I’ve used mssql for 10 years now and I’m no m$ fanboy but it absolutely rocks. [import]uid: 7334 topic_id: 1814 reply_id: 5593[/import]
For an easy setup, cheep costs and reliability I recommend getting a cheep linux hosting package from 1and1.co.uk / 1and1.com.
They do cheap php / MySQL packages and while their customer service can be a bit hit and miss at times, everything pretty much works 100% of the time and ive never has any issues. Any ive cained their services in the past, including running up a £8000 bandwidth charge a couple of years back when a website I control had a very busy weekend.
im running alienhorde.com and the highscores for the game from their business package. [import]uid: 5354 topic_id: 1814 reply_id: 5653[/import]