Alternative to SQL Server
- Started
- Last post
- 25 Responses
- nh
I've got a client that can't afford SQL Server but wants to be able to handle a great deal of traffic (don't they all). What's the best alternative. I'm not so much of a programmer but would like to give some sound advice.
I'd assume just going with SQL?
Thanks.
- mitsu0
mysql
- Mimio0
Word to that, Mitsu.
- tfs__mag0
if they think they'll be needing an enterprise type solution oracle is another choice... php and asp can both talk to most database platforms out there too.
- nh0
thanks a bunch, what kind of loads can mySQL handle?
- ********0
MySQL, freebie! ;)
- ********0
this kind of DB thread you are talking on right now ;)
- unfittoprint0
when will people learn... PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL PHP+MySQL
- Mimio0
It's a server process. So it depends on how the database is designed and how well it runs.
- sparker0
mysql is a great rdbms, but if it is enterprise level or mission critical applications that they need, then i suggest PostgreSQL for their db server.
PostgreSQL offers some better features. Things more closely related to Oracle and SQL Server that they might need...like replication tools, etc.
It is a more robust system. Of course this come at a cost to performance. MySQL is built on the premise of speed and economy...while the latest versions of MySQL support more features...it does still lack the enterprise level support needed by some clients.
here.
http://www.postgresql.org/it all depends on what the client needs from their database.
is it a web project? or is it an application project? is it mission critical (i.e., financial software, internal applications, pricing software, etc etc)?
- mitsu0
yeah, if this is a full blown ecommerce or high-end web app, then go with sql server. i can attest to MS's amazing support on this product. if they can't figure out your problem, they will either fly to your location or write you a custom solution.
- davetufts0
I'd go with MySQL or PostgreSQL.
Mysql - Fast, simple, easy to administer, huge user-base
Postgres - more features, similar to SQL Server/Oracle, better suited for larger progects
- enobrev0
it all depends on what your site requires. If you're looking for stored proceedures and better transaction handling, postGre is comparable. It's slower tham mysql though.
If you're simply dealing with queries and run of the mill sql commands, mysql is all you need.
Oracle and MS SQL are incredible db servers, but highly expensive in maintainence and cost.
- nh0
Oops forgot one thing. Can Postgre SQL and MySQL handle ASP.
It's a pretty large web app.
- tfs__mag0
i know asp can use mySQL not sure about postgre though.
- sparker0
there should be a way, through some abstract logic layer, to connect ASP to it.
that is another question, what type of server is the site using?
i've not head of postgresql running on MS servers before. doesn't mean it can't or hasn't been done before, i just don't know about it.
- nh0
It's all kind of up in the air. They are feeling the project out and I'm sort of their main contact.
MySQL runs on Linux right, and SQL Server on Windows?
*Shows how much I really know about this stuff eh?
:)
- tfs__mag0
yeah you would have to have the database server running on a different box than the web server... ASP can run on linux, but not very efficiently from what I've heard. You are correct, SQL server is windows, and MySQL can run on Windows or Linux.
- sparker0
yea. mysql can run on multiple platforms...postgresql seems to only be available unix/linux, to my knowledge anyway.
oracle can run on multiple platforms as well, and sql server seems to be strictly ms.
- ********0
yepo
- sparker0
does it have to be asp?