 The Best Database, databases |
|
|
|
|
  |
 Mar 22 2005, 12:16 PM
Post
#1
|
|
|
Member [ Level 2 ]  Group: Members Posts: 59 Joined: 3-November 04 From: uruguay Member No.: 1,302  |
te best database for my is sql server yukon
for you? |
 |
 
|
|
Mar 22 2005, 12:51 PM
Post
#2
|
|
|
End Of Computer Group: Members Posts: 346 Joined: 1-September 04 From: .:: MARS ::. Member No.: 28 |
QUOTE(pedro @ Mar 22 2005, 03:46 PM) te best database for my is sql server yukon for you?  MYSQL because: taken from internet: QUOTE It's relatively clean (no huge grammar quirks, simple privilege administration) easy to maintain and upgrade, does not have a slew of administrative tasks to put up its table format does not vary between releases (but the old ISAM table format is being dropped out after having been shipped sidy-by-side with the new(er) MyISAM format for quite a few years) it does not have its own data / index caching but uses the filesystem's one (when using MyISAM tables). Result: faster, can take advantage of OS's fs caching and journaling, simple backups, less vulnerable to crashes. it has cleanly separated table handler modules and can mix access to different types of tables. it seems to be developed iteratively, and the features are very stable when they ship them. This is the biggest reason I like MySQL more for production environments than PostgreSQL. one gets a lot of control on how things are done. it's fast. (This, they advertise a lot. But in practice, it seems to be so.) it doesn't carry a lot of historical baggage, thus for example the transaction support can use state-of-the-art solutions like MVCC. |
|
|
|
|
Mar 22 2005, 02:07 PM
Post
#3
|
|
|
Premium Member Group: Members Posts: 382 Joined: 5-September 04 Member No.: 255 |
I suppose mysql is the most popular database because it's open source and hence many other open-source scripts and applications make use of it. Examples: this IPB forum, phpBB, phpList, and many php scripts.
|
|
|
|
|
Mar 22 2005, 03:05 PM
Post
#4
|
|
|
PsYcheDeLiC dR3aMeR  Group: Admin Posts: 2,242 Joined: 29-January 05 From: Nakorn Chaisri, Thailand Member No.: 2,411 |
QUOTE(jcguy @ Mar 22 2005, 09:07 PM) I suppose mysql is the most popular database because it's open source and hence many other open-source scripts and applications make use of it. Examples: this IPB forum, phpBB, phpList, and many php scripts. Not just that. Take a look at the features it offers - can give any of the commercial giants a big run.. And of course it's opensource and got this incredible support forum. |
|
|
|
|
Mar 24 2005, 08:27 AM
Post
#5
|
|
|
Advanced Member Group: Members Posts: 173 Joined: 22-March 05 From: Hyderabad,India Member No.: 3,155 |
Thats true..Me and my friends use mySql for our forum too....really nice and easy to use..
|
|
|
|
|
Mar 24 2005, 10:56 AM
Post
#6
|
|
|
Member - Active Contributor Group: Members Posts: 93 Joined: 21-March 05 Member No.: 3,136 |
mysql is the best choice cause it's free, open source and quite fast. Support many platforms.
 )
|
|
|
|
|
Mar 25 2005, 09:22 AM
Post
#7
|
|
|
Member - Active Contributor Group: Members Posts: 86 Joined: 4-February 05 From: Bangalore Member No.: 2,508 |
mysql is the best by far.. simple and easy to use.. most of installable scripts are available in mysql. also mysql is opensource and has a huge community of users to help you out (that is if you have somehow got some problem.. which doesn't happen very often with mysql)..
slightly of topic.. but i feel that sometimes guys use mysql databases to often when its not required... even storing data in text files is good for small scripts like polls, guestbooks, etc. but for bigger applications, its better to use mysql. |
|
|
|
|
Mar 30 2005, 06:56 AM
Post
#8
|
|
|
Super Member Group: Members Posts: 595 Joined: 4-September 04 Member No.: 228 |
This kind of is in topic....
I'm actually taking a advanced course on databases. Not SQL 101 but getting more into inside the dbms's. We've had so far three lectures and the lecturer hasn't mentioned the open-source databases once, although Postgre and MySQL (especially) are really widely used and one would think it's easier to get under their hoods them being OS and everything. No it's just Oracle, Oracle, Oracle... |
|
|
|
|
Mar 30 2005, 08:20 AM
Post
#9
|
|
|
Member [ Level 1 ] Group: Members Posts: 33 Joined: 29-March 05 Member No.: 3,343 |
MySQL, you'll be hard pressed to find a script that is written not for mysql (unless specificilly written for another database type or doesnt require one at all
 )Mysql is the easest and most used database, and most webservers (and now free webservers) support and install mysql |
|
|
|
|
Mar 30 2005, 08:34 PM
Post
#10
|
|
|
Newbie [ Level 1 ] Group: Members Posts: 7 Joined: 30-March 05 Member No.: 3,415 |
I'm a complete newb to PHP and databases, and I'll have to say that MySQL has been easy to use, clean, efficient, and it works. That's more than I can say for PHP when I tried to set it up with Apache on Windows.
MySQL is quite powerful for a scripting language that has only ten or so commands. I recommend it to any newbs out there. |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 12th October 2008 - 09:33 AM |