Web Develop Forum: What's your favorite database engine? - Web Develop Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

What's your favorite database engine? Rate Topic: -----

#1 User is offline   Alex Leeds Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 26
  • Joined: 29-January 09
  • Location:South Florida
  • Interests:Website Development in HTML, CSS, Javascript / AJAX, and PhP

Posted 30 January 2009 - 02:30 PM

As the web keeps on getting better so do our ways of storing data. Back in the day everything was done in a text file, then we were able to move onto XML (which is still a text file but in an easier format) and now we have database engines that can be used to store massive amounts of data. Although this meathod is a tad bit slower it makes life a whole lot easier.

Some common database engine are:
Mysql - Most popular in the web development community.
MsSQL - In my opinion Microsofts fail attempt, but I love using when I code in C#.
Oracle - An amazing database engine but its hella expensive.

Those are the most popular. There are others like: Firebird, PostgreSQL and SQlite. But this list can go on forever.

As of right now, I always try to stick with the MySQL, it's eeasy to use, fast (not really but doesn't bother me), and best of all - ITS FREE.

So now you know my choice, whats yours?
Imglot.com - Free Image Hosting
0

#2 User is offline   Salathe Icon

  • Advanced Member
  • Icon
  • Group: Moderator
  • Posts: 138
  • Joined: 15-January 09
  • Gender:Male
  • Location:Scotland

Posted 30 January 2009 - 03:30 PM

I have to say that SQLite has been growing on me over say the last year or so. Just because it's neat and tidy, extremely portable and particularly useful for (but not restricted to) those instances where flat files are too much of a hassle and a full-on RDBMS like MySQL is overkill. All that said, MySQL will still remain the clear winning in the race for my time and energies during development.
salathe@php.net
0

#3 User is offline   Diffraction Icon

  • Advanced Member
  • Icon
  • Group: Moderator
  • Posts: 279
  • Joined: 26-January 09
  • Gender:Male
  • Location:USA
  • Interests:Web Development, Reading, Writing, Computers in general...
  • Your specialities (detailed)::HTML 5
    CSS 3
    jQuery

Posted 30 January 2009 - 04:19 PM

MySQL. Very very good.
Want to report something to a moderator? Use the 'report' button located on every post.
0

#4 User is offline   Sam Granger Icon

  • Administrator
  • PipPipPip
  • Group: Root Admin
  • Posts: 431
  • Joined: 22-October 08
  • Gender:Male

Posted 30 January 2009 - 10:46 PM

MySQL here, love the fact that SUN bought it too. Should be interesting if they do manage to speed it up with Java. smile.gif
0

#5 User is offline   Diffraction Icon

  • Advanced Member
  • Icon
  • Group: Moderator
  • Posts: 279
  • Joined: 26-January 09
  • Gender:Male
  • Location:USA
  • Interests:Web Development, Reading, Writing, Computers in general...
  • Your specialities (detailed)::HTML 5
    CSS 3
    jQuery

Posted 30 January 2009 - 11:01 PM

What is the difference between MySQL and MySQLi? Anyone know?
Want to report something to a moderator? Use the 'report' button located on every post.
0

#6 User is offline   Alex Leeds Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 26
  • Joined: 29-January 09
  • Location:South Florida
  • Interests:Website Development in HTML, CSS, Javascript / AJAX, and PhP

Posted 30 January 2009 - 11:24 PM

MySQLi is in php. it's php's improved mysql interface, it interacts faster and is a lot better. But it isn't itself a database engine.
Imglot.com - Free Image Hosting
0

#7 User is offline   Blambu Icon

  • Advanced Member
  • Icon
  • Group: Administrators
  • Posts: 126
  • Joined: 22-October 08
  • Gender:Male

Posted 07 January 2010 - 03:56 PM

Would love to know the difference between a few different ones, I just don't get it. And even using MYSQL, InnoDB, MyISAM etc.. I've been taught to use InnoDB and relationship DBs in InnoDb...
[twitter]escensi[/twitter]
http://escensi.com
0

#8 User is offline   Rejoynic Jonson Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 17-February 10
  • Gender:Male
  • Your specialities (detailed)::New learner

Posted 02 March 2010 - 01:10 PM

I like MySQL, PostgreSQL, Oracle. :)
Website Hosting Kolkata Website Hosting India Logo Design Company
0

#9 User is offline   theinc Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: 22-April 10

Posted 22 April 2010 - 10:44 AM

For me MYSQL is the best and the easiest database engine to use. Although Oracle is more powerful its not a good idea to use it in small applications ;)
Flexible server colocation makes your life easier. 1u colocation is the most suitable rack space.:)
0

#10 User is offline   Nuno Moura Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: 14-December 10
  • Gender:Male
  • Location:Vale de Cambra, Aveiro, Portugal
  • Interests:Rich Internet Applications
    Web Develops
    etc...
  • Your specialities (detailed)::FLEX, ActionScript 3, MySQL, PHP, XML, WebServices

Posted 14 December 2010 - 11:23 AM

MySQL, and you can use the new MySQL Workbench it's new, free and very powerful. ;)
0
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users