 The Best Database, What do you think is the best database? |
|
|
|
|
  |
 Jul 14 2005, 08:17 AM
Post
#1
|
|
|
Newbie [ Level 1 ]  Group: Members Posts: 2 Joined: 14-July 05 Member No.: 7,092  |
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? |
 |
 
|
|
Jul 14 2005, 08:30 AM
Post
#2
|
|
|
the Q  Group: [HOSTED] Posts: 1,022 Joined: 13-July 05 From: Lithuania, Vilnius Member No.: 7,059 |
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.
|
|
|
|
|
Jul 14 2005, 08:35 AM
Post
#3
|
|
|
Newbie [ Level 1 ] Group: Members Posts: 2 Joined: 14-July 05 Member No.: 7,092 |
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 |
|
|
|
|
Jul 14 2005, 09:02 AM
Post
#4
|
|
|
Newbie [ Level 2 ] Group: Members Posts: 25 Joined: 13-July 05 From: Portugal Member No.: 7,061 |
I believe so. You should really try MySQL.
|
|
|
|
|
Jul 14 2005, 09:42 AM
Post
#5
|
|
|
the Q Group: [HOSTED] Posts: 1,022 Joined: 13-July 05 From: Lithuania, Vilnius Member No.: 7,059 |
you can export and import the mysql database in different ways, I recommend using phpmyadmin to do things like that.
|
|
|
|
|
Aug 1 2005, 03:49 PM
Post
#6
|
|
|
Member [ Level 1 ] Group: Members Posts: 36 Joined: 1-August 05 Member No.: 7,569 |
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.
|
|
|
|
|
Aug 4 2005, 07:42 AM
Post
#7
|
|
|
Hedonist at large Group: Members Posts: 610 Joined: 30-July 05 From: another realm Member No.: 7,524 |
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. |
|
|
|
|
Aug 5 2005, 12:25 PM
Post
#8
|
|
|
Advanced Member Group: Members Posts: 131 Joined: 21-May 05 From: New Delhi, India Member No.: 5,295 |
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.
|
|
|
|
|
Aug 5 2005, 04:50 PM
Post
#9
|
|
|
Super Member Group: Members Posts: 572 Joined: 25-April 05 From: Nashville Tennessee Member No.: 4,340 |
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. |
|
|
|
 Aug 16 2005, 07:36 PM
Post
#10
|
|
|
Way Out Of Control - You need a life :)  Group: [MODERATOR] Posts: 1,980 Joined: 16-August 05 Member No.: 7,896 |
QUOTE(volrathxiii @ Jul 14 2005, 10:17 AM) 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 ? |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 5th September 2008 - 08:59 AM |