what is the best db to use?

[BoR|S]

When answering the poll, pls write a comment and explain why...

[Dynasty]

Personally I'd say mysql, for the simple fact it is what I use :p

[classicwingcook]

Personally, I like MySQL. just a lot easier to work with, plus it's free. :D

Access isn't too bad. I've read and heard that it's unreliable ot times, but I haven't had any problems with it personally.

[BoR|S]

Personally, I also prefer MySQL, easy, relyable, stable, GPL...

But, for newbies (I dunno, I still consider myself as a newbie thought) I'd suggest to use MS-Access based DB with ASP, it's very easy, and has so little amount of problems (I remember only one time when a site based on asp/ms-access crashed to me (I mean site I built)).

[-TheDarkEye-]

mysql sucks azz. it doesnt support:

check constraints
foreign key constraints
triggers
stored procedures
replication
compressed binary table dumps (cvs blows)
row level locking
ect. ect. ect.

oh and the sql optimizer in mysql is a pile of rancid horse pooopy. also EXPLAIN PLAN is pretty much useless in mysql.

right now i use oracle 9i dev. but i learned a lot of my basic db skill on ms access.

why is oracle the best? well, imo it has a lot to do with power. what cant i do with oracle? well i havent found a way to make it perform fellatio on me while i code...

oracle does have a steep learning curve but oracle dba's dont get paid $100+/h for nothing.

[Kilia]

i use MySQL because it's free ;), easy and fast.
Access as i know sux because it's speed.
And using files as db, well it has it's disadvantages.

[BoR|S]

2-TheDarkEye-: Well, I knew I forgot to add this option to the poll, and now I can't change, maybe dbindel will add... (I hope he'll see this post, better I'll send him pm)

[-TheDarkEye-]

dont bother.

[BoR|S]

Thanks!

Also, is there a possibilaty to let the poll starter to change it's settings after being posted? I don't feel like pming the moderator each time I want to fix a poll...

[BoR|S]

No problem!

I'll also check later on vB website if this is possible at all...

[Askalon]

Although I do not use DB's much, I would have to agree with what Darkeye said. Oracle is the top of the bunch for db's. Yes I want to be a DBA, but so far no luck getting in the door.

[stewis]

ummm isnt oricle a SQL as well???

[-TheDarkEye-]

i thought he was talking about mysql.

[BoR|S]

Yea, my mistake once again, I was talking about MySQL... :rolleyes:

[Sky]

No, user poll-editing is not possible (at leastnot in 2.2.6)

[-TheDarkEye-]

i see you are up for some fixing of the poll... :D

why not add:

sql server,
sybase,
postgresql,
db2,
other open-source,
other commercial

?

[-TheDarkEye-]

perhaps most the people who visit this forum arent into databasing?

[Josh]

ya,many don't experience database(like me):D

[jamesdoz]

I voted for mySQl in the poll, the latest site I developed used mySQl and ASP (http://www.quest-net.org/cte). I found it much better than using an Access database which I'd (WRONGLY) used in my previous project (http://www.quest-net.org - very slow!)

I'm still having trouble with aggregate functions in mySQL (with Access you can prototype your SQL in the query builder wizard and they work with ASP most of the time) I can't get aggregate functions to work at all when I use aliases.

Does anyone know a good place (or book) to learn more? I have a few new projects coming up soon and would like to use mySQL but need to solve these problems first before deciding on which DB to use.

[BoR|S]

Hmm try O'Reilly's "MySQL and mSQL - Databases for Moderate-Sized Organizations and Web Sites"...

[jamesdoz]

Do you know of any online mySQL resources?

[Ganon of Evil]

MySQL is simple, fast, and powerful enough for most users. Its also free. Thats why I prefer MySQL. My entire site is being ran with PHP/MYSQL. It loads fast most of the time (pages are created in around 0.006 seconds). If you need speed, use PHP/MySQL/GZIP Compression. I havent tried Oracle though, but I heard its more powerful than MySQL but slightly slower.

[-TheDarkEye-]

mysql is fast at reads (select's) because it isnt a true rdbms (they sacrificed data integrity rules for speed, basicly). its really just a glorified file system. because of this, mysql is sometimes regarded as faster than oracle and many other expensive db's. however, the only people that take this seriously, dont know what they are talking about.

mysql is a toy compared to oracle.

[-TheDarkEye-]

oh and a forgot... mysql links:

http://www.mysql.com/

http://www.devshed.com/

http://www.sitepoint.com/

http://hotwired.lycos.com/webmonkey/backend/databases/index.html

[melvis]

If you really want to know the "best" in general terms, I would have to agree with TheDarkEye and say Oracle.

If you are looking for the best to use for the unwashed masses, then MySQL MAX is my vote.

There are a lot of commercial web sites platformed on both systems. I know of an on-line grocer who switched from Oracle to MySQL who actually got far better performance from MySQL.

Bottom line - know your needs. It's a lot like buying a car, there is always a "better" one, but what do you need and what can you afford.

[MikeParent]

Originally posted by dbindel
MySQL is almost definitely the most popular database... it's open-source and is considered to be the standard database for database-driven website development.

I am afraid that just isnt so. In the corporate world I think you will find that most major stuff runs on Oracle or MS SQL Server (and perhaps DB2 or SyBase). MySQL just isnt there yet for reasons mentioned in DarkEye's first posting.

MySQL might be fine for a single server small web appplication, but its lack of triggers, transactions, stored procedures, etc. not to mention the horrible admin interfaces, makes it a poor choice for an enterprise-class database solution (web or otherwise).

That said I like MySQL and use it for a lot of stuff I do, but sorry to burst the bubble here, but Open Source still aint where the corporate world is at, and thats where the bucks are my friends.

[Freon22]

I voted for access for a database. I see that a lot of people voted for MySQL would like to know if there is any other reason other then speed.

[MikeParent]

I daresay price... from what I can tell these development forums are very heavily biased towards open-source.

And the ease of making changes to the table structures: in access, any change to the database and you have to DL it, make the change and then upload it back - hoping no one has entered any data...

Also access is a desktop database, it was never designed to power web sites...

[ByteWizard]

Quote...

"I agree with you, allowing poll starters to edit their poll is a good idea, and I will talk to Admin about this to see if it is possible"


I would agree to that.
Al Gore

[MikeParent]

Originally posted by dbindel


Sorry to burst your bubble, but Open Source isn't about the bucks, my friend. So your above comment is really illogical.

I have no bubble to burst, and my statement is most certainly not "illogical". I think you may have missed my point David; which, to clarify, was that if you actually want to *get paid* for what you do, most web database development work is *not* open source.

Mike

[MikeParent]

you do NOT need to use open source databases to develop websites for money, but it is usually easier and less costly for you (the developer) to do so.

Well at least that much we can agree on. :-)

And just to clarify, the job reference thing was in relation to landing an actual job doing web development, not to doing freelance work (where basically you tell the customer what to use :-)


MySQL as a "get a job"-type skill is not nearly as marketable as MS SQL or Oracle. That is what I was referring to. Sorry for any confusion there.

In all honesty MySQL is OK for simple sites. Again, I DO use it for some stuff, so I am not saying it totally sucks. I wrote a forums software in it, and I gotta say I wouldnt want to do anything more complicated than that with it.

I am currently working on a fairly complex site for a consumer computer/electronics manufacturer and MySQL's lack of stored procedures especially makes it a poor candidate for anything very complex. I had to use MS SQL to avoid having the database programming turn into a nightmare.

[PsychoticDude85]

You can do stored procedures since MySQL 5.0 http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html and it is definately applicable to larger projects. Yahoo uses it for a large percentage of its database needs.

I like MySQL personally, but then I've not tried many others apart from Access which I disliked, but I think Oracle or PostgreSQL might be interesting to use. The only other one I've used much is SQLite, which is a very nice SQL server for small integrated projects (Qt has very nice SQLite integration for example).

EDIT: Crap, I hate that voting brings old topics up. I thought there was something new here. :(

[Terminator1138]

EDIT: Crap, I hate that voting brings old topics up. I thought there was something new here. LOL

at least you are not in denial...

Its okay to bring up some topics if they are good and serve its purpose. But yeah I had that fact also. I do think you get the longest time since post record there PD85 :)
No worries.

[Freon22]

Wol this is an olddddd thread. Just just an email that someone posted in it. lol

10-31-2002, 02:52 PM #32
Freon22

Time flys so fast. Hi everyone :hellother

[John_Dean]

I prefer MySQL.

URL Removed. No signatures allowed until you have the required number of posts. Thank you

[BigMumu]

Wol this is an olddddd thread. Just just an email that someone posted in it. lol

10-31-2002, 02:52 PM #32
Freon22

Time flys so fast. Hi everyone :hellother
WOW! Didn't notice before I saw your post & it's also a bit old ...

[John_Dean]

But, now I using ORACLE. I thing it's better than MySQL.