The Best Database What do you think is the best database?

	The Best Database - What do you think is the best database?
	Discussion by volrathxiii with 48 Replies. Last Update: September 29, 2007, 2:25 am (View Latest)	Page 1 of 4 pages.

volrathxiii

Ive been planning to create a online application which requires tons of stuff from database.

Ive been using interbase, at first it was good but after a month i find it not user friendly at all... Its to hard to code in php..

Can any of you guys give me a good database which is easy to use?

Thu Jul 14, 2005 Reply New Discussion

Quatrux

well, sql is very easy to learn and understand and it is quite powerful, I think you can just go with mysql which is very easy using with php.

Thu Jul 14, 2005 Reply New Discussion

volrathxiii

does mysql has some sort of data pump? like in interbase? it uses data pump to backup or to migrate from another database to interbase..

Because i need to get the table and datas from a foxpro db

Thu Jul 14, 2005 Reply New Discussion

m3moreX

I believe so. You should really try MySQL.

Thu Jul 14, 2005 Reply New Discussion

Quatrux

you can export and import the mysql database in different ways, I recommend using phpmyadmin to do things like that.

Thu Jul 14, 2005 Reply New Discussion

matrixlover

I agree, I think MySQL is the most popular and the most easy to use. Almost all webhosts offer MySQl instead of anyother databases. Personally, I would go and learn it because it is extremly useful when you are making websites with different login places and such.

Mon Aug 1, 2005 Reply New Discussion

abhiram

Hi,

I agree with the others that MySQL is the best database. MySQL is actually made so that it can be integrated with web applications using PHP very easily. There is very good support for MySQL in PHP. That is why people always use LAMP (Linux Apache MySQL PHP). Since you need to use foxpro tables, try these following links:

A program to export tables to different formats:
http://www.softpedia.com/get/Programming/P...ta-Wizard.shtml

Here is another link for different applications to convert from one format to another. There is one for foxpro as well:

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mys...converters.html

There are plenty of tutorials on the net for MySQL. If you want a hassle-free installation of a webserver in your windows PC with PHP and MySQL, I would suggest WAMP:

www.wampserver.com/en/index.php

I hope these help.
One reason why MySQL is so popular is that it can be used in both windows AND linux.

Thu Aug 4, 2005 Reply New Discussion

solanky

I have never worked with MySQL but I have heard that is very good database. At my workplace I work in SQL Server 2000 and I have found it very easy and powerful also. I have earlier used Oracle also but I think it is not easy to use. The user interface of SQL Server is very good and easy like any other Microsoft product. The Stored Procedures used in it are very helpful in creation of application programs.

Fri Aug 5, 2005 Reply New Discussion

Houdini

MySQL is simple and works very well in conjunction with PHP, or maybe the other way around, but MySQL refers to an sql export as a data dump not a data pump hopefully that was a typo or they refer to normal sql matter with different lingomaking it even more confusing.

Learn how to use phpMyAdmin and MySQL has a new program they have developed but I have been using phpMyAdmin for so long that I am not sure that it would compare but I am gonna download and give it a try.

Fri Aug 5, 2005 Reply New Discussion

yordan

QUOTE (volrathxiii)

Can any of you guys give me a good database which is easy to use?

I see a lot of guys loving mysql, nobody talking about oracle ?

Tue Aug 16, 2005 Reply New Discussion

Himanshu

hi,

MySql is a very good database and best of all it comes free.
Earlier this had a problem of no support for stored procedures. But MySql 5.0 onwards it does support stored procedures. Though I am not sure whether it supports triggers/cursors.

Cheers,
Himanshu

Wed Aug 17, 2005 Reply New Discussion

thedevil

Using mysql with conjuction with PHP gives you better result than any other pairs...

I used to use Access(or call it mdb file) and ASP for my web stuffs before I got to know about PHP and MySql... and lo... when I first tried... I could not leave it that easy....

I started loving the pair... and it just gets most of the things get done on web without a hassle....

About Oracle... I prefer it using with Java when the security and robustness really matters... Though I have not made such a huge secure and robust app on web till date... As I am a web developer I really love that pair... (Oracle and Java) but still when talking about a website today in current scenario where it is really a open community... MySql and PHP really beats the Oracle and Java...

So I suggest you to use MySql and PHP coz they are made for each other...

Wed Aug 17, 2005 Reply New Discussion

little0run

The best database is MySQL hands down, it's very efficient and secure, and is free, and downloadable from the MySQL website, and almost any host you can imaging will have it...

Wed Aug 17, 2005 Reply New Discussion

soleimanian

if you use PHP scripts you should use MYSQL
if you use asp scripts you should use Microsoft SQL
each script has its capability,but to day php/mysql

Wed Aug 17, 2005 Reply New Discussion

ajmal

my opinion is the same as always, mySQL is widely supported, free and easy to use, but lacks features; pgSQL has more features than mySQL but it's sluggish ...

what means that the best SQL server, with no doubt is the powerful ORACLE. Or do you think people waste thousands of dollars in Oracle for nothing?

Thu Aug 18, 2005 Reply New Discussion