Except MS Access and Oracle, any other recommended Database??

Except MS Access and Oracle, any other recommended Database??

Moved to General Developer

MS SQL Server

Or if price is an issue, MS SQL Server Express. Its free.
http://msdn2.microsoft.com/en-us/express/bb410792.aspx

Oracle Lite (Oracle XE) is also free.

Quote:

---

Originally Posted by GaryMazzone

Oracle Lite (Oracle XE) is also free.

---

And I would choose it over MySql or Ms SQL 2005 Express.

However, you didn't mention whether you need it for business or personal use as well as volume of data - those things important to know.

Oh god I would stay away from GaySQL :lol:

You might want to look at the database forums faq for the item on "How to choose the right database".

Rob, care to explain? :)

Well MySql is what runs on the backend of vBulletin and vBulletin could do allot better in preformance by using stored procedures in SQL Server since GaySql doesnt support them until the recent versions.

Its management panel is cumbersome and stupid. It doesnt even have any performance analyzers like SQL Server has. Basically its too limited and n00bish. :D

I meant the name? ;)

:lol: Because its stupid and gay-ish. MS SQL Sever is a real mans RDBMS :thumb: :D

Hmmmmmmmmmmmmmm... Interesting evaluation... :rolleyes: I hope you are not serious. ;)

I don't know why people bag out MySQL so much. It doesn't have the headroom or all of the features that Oracle has, but then, it doesn't have the price either. I consider it on a par with SQL Server.

I haven't used Oracle XE, but it looks awfully limited from the specs. Fine for developers working on projects that use the full version, but there's no way it would be chosen for deployment, so I don't see why anyone would place it above MySQL.

That said, this is probably one of those debates that could drag on and on, when really the best solution depends completely upon your needs and there isn't any 'best' option.

Quote:

---

Originally Posted by RobDog888

Well MySql is what runs on the backend of vBulletin and vBulletin could do allot better in preformance by using stored procedures

---

That's vBulletin's fault. If their product was designed better it wouldn't be so hard to change how it interacts with the database server.

Quote:

---

Originally Posted by penagate

I haven't used Oracle XE, but it looks awfully limited from the specs...

---

When compared to what? Just curious.

Specifically the limitations on CPU and memory usage, compared to SQL Server Express or MySQL.
I may be wrong, though. I'd like to see an opposing argument, since I like Oracle in general.

Can you post link to that info please? I couldn't find any. Thanks.

I only read this document
http://www.oracle.com/technology/pro...f/dbxe_faq.pdf

Thanks pen but I saw that one already. I was hopping you'd found some other. :thumb:

Anyhow, I think for a express edition it's pretty good and because it's Oracle you shouldn't have any major issues. :)
But seriously, I read many reviews and most experts are quite happy with it.

MySQL performance can't be too bad since it is used by high-traffic websites such as wikipedia, flickr, digg.com, slashdot.org, youtube.

After saying that, my vote goes towards using PostgreSQL, which I think is much higher quality software.

Why's that? From all accounts that I've read, it's a worse performer than MySQL.

Quote:

---

Originally Posted by tr333

MySQL performance can't be too bad since it is used by high-traffic websites such as wikipedia, flickr, digg.com, slashdot.org, youtube.

After saying that, my vote goes towards using PostgreSQL, which I think is much higher quality software.

---

Something doesn't make sense so I wish you would explain:

- you said "MySQL performance can't be too bad since it is used by high-traffic websites ..." :thumb:
- but then you said that your vote "goes towards using PostgreSQL" :confused:

Also, in terms of what PostgreSQL is [as you said] "much higher quality software" ??? :confused:


Would care to explain all of the above please? Thanks.

PostgreSQL is anothe DB that came out of the same 'free communal development' ethos as MySQL so they often get compared. I've dabbled in both but don't have extensive knowledge of either. My experience was that PostGreSQL had a few more features but MySQL had a slightly better performance.

When deciding on a production DB we find SQL Server comes out on top 9 times out of 10 but we've got a few customers who are small enough to use access and a few who are large enough to merit Oracle.

Thanks FD but I am familiar with basically evrything you said - I was just wondering what tr333 had in mind when he replied. :thumb: :)

Quote:

---

Originally Posted by RhinoBull

Also, in terms of what PostgreSQL is [as you said] "much higher quality software" ??? :confused:

---

That observation was based on looking at the source code of both MySQL and PostgreSQL. I found it much easier to see what was happening with the PostgreSQL code. Cleaner code is much easier to maintain.

This was about a year ago, so the situation might have changed since then.

Interesting "observation".

Where can I get MySQL Database?? its free izzit?

Quote:

---

Originally Posted by wenight

Where can I get MySQL Database?? its free izzit?

---

You want to download the Community Server.

This is another reason why I prefer PostgreSQL: it's all licensed under the BSD license so there's no "enterprise" version. A lot less confusion when trying to download it :).

After I download the MySQL, there is nothing for me to open... only have the configure setting... after configure there is nothing appear also... MySQL no any .exe file to open like MS Access to create column, table...??

Anyone know what's the problem......??

MySQL doesnt have an interface like Access for creating tables etc AFAIK.

Wouldn't this be what he's looking for?

MySQL GUI Tools

You should have the MySQL Client (Start -> Run -> mysql, or MySQL Server 5.0 -> MySQL Command Line Client from the Programs menu) as well as the configuration wizard.

MySQL is a tad hard to configure at first, but once you are past the first few stumbling blocks, it's great.

I run one on a Linux server (Fedora 7) that runs 24/7/365 (sans power outages.) If you really want to learn SQL, then command-line is the way to go. :)

Quote:

---

Originally Posted by Campion

...If you really want to learn SQL, then command-line is the way to go. :)

---

I must agreee - that's one of the best way to learn when you actually have to type your statements.

Ya~~ MySQL is hard to configure...