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

[volrathxiii 0]

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?

[Quatrux 4]

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.

[volrathxiii 0]

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

[m3moreX 0]

I believe so. You should really try MySQL.

[Quatrux 4]

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

[matrixlover 0]

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.

[abhiram 0]

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://forums.xisto.com/no_longer_exists/

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

http://forums.xisto.com/no_longer_exists/

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:

http://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.

[solankyno1 0]

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.

[Houdini 0]

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.

[yordan 10]

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 ?

[Himanshu1405241508 0]

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

[thedevil 0]

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...

[GameUltra 0]

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...

[soleimanian 0]

if you use PHP scripts you should use MYSQLif you use asp scripts you should use Microsoft SQLeach script has its capability,but to day php/mysql

[ajmal 0]

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?