Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sulik
Starting Member
2 Posts |
 Posted - 2002-11-18 : 05:15:49
|
| I have to choose a free database to start a DB server. For now it seems to be a choosing between PostgreSQL and MySQL. As far as I understand, the differences are:1) MySQL has no transactions (rollbacks) - very unpleasant; it has no views, no triggers, no procedural languages - not very bad, but does a ittle headache sometimes.2) MySQL is more fast, easy to install/manage, more reliable, but less secure. Is the above info right? is there anything esli I didn't mention? The second question here is if there's a feature letting acess to the server and to the local database copy be the same. I mean, ususally you have to write different code for working with a DB server and local DB copy. Is there any features fixing it up in Postgre or MySQL? I have found the d/l version of MySQL for Window, but not PostgreSQL. Will be grateful for any links. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-11-18 : 05:58:06
|
| HiYou are right, MySQL has no foreign keys or procs or transactions. It is basically a SQL interface to a file system. It is a very good read only, low transaction storage engine, however Postgres is much more fully featured.Postgres may be a bit more work to set up and manage. But if you look around, there are some decent looking tools to manage it.If you can, run those servers on Unix. They are written to run on a Linux/Unix box and you will get better results that way.Another thing to look into is SAP DB, www.sapdb.orgThe database owned by SAP has been open sourced. It is a little tricky to set up and run, but is of high enough standard to run SAP (whatever that means, but otherwise they only recommend Oracle and SQL Server i think ..could be wrong).Hope that helps a little. But, don't belive the hype, MySQL isn't a proper RDBMS. It has a bunch of fanatical followers, but there are better options if you need a real database.Damian |
 |
|
|
|
|
|
|
|
Free Databases copmarison. Important!!