LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-25-2003, 10:37 AM   #1
chapzilla
Member
 
Registered: May 2003
Posts: 37

Rep: Reputation: 15
Cool I need a database recommendation


I'd like to install a database so that I can start on some development work. The requirements are:
1. EASY! I tried Oracle, but the install failed in the first 10 seconds
2. JDBC. I need a JDBC interface
3. SQL I'm used to Oracle's SQL*Plus interface for creating and working with tables. I'd like the same.

Please let me know what's freely available for development.
 
Old 06-25-2003, 11:09 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974
mysql or postgresql should do the trick fine
 
Old 06-25-2003, 12:48 PM   #3
Rick422
Member
 
Registered: Apr 2003
Location: Arizona
Distribution: Red Hat Linux 9
Posts: 158

Rep: Reputation: 30
Lately I have been learning to use MySQL and PHP. That combination seems to mainly be designed to create databases that are accessed using forms on web pages. MySQL is the actual database program. PHP is a server side scripting language that is used to access MySQL from a browser and to create the forms. That combination requires having a MySQL server and a webpage server. On my computer the server and the client are both on the same computer.

On my computer I use Apache as the web server and I also have the MySQL server daemon running. I have heard that many E-commerce commerce sites are created with PHP, MySQL and Apache. It seems to me that it could also be used for a database in a companys own intranet or extranet. Is that sometimes done? Would they then configure the Linux iptables firewall or a router to block incoming access to certain port numbers so rest of the world could not access that information?

I have been wondering if that combination is overkill for what I want to do? For the last couple of years I have been maintaining the membership database for for a small local club. So far I have been using the Microsoft Access database that I created. The trouble is that I have to boot up into Windows to access that database. People keep calling me wanting to join the club when I am usually booted up into Linux at the time. I am tired of having to reboot my computer when people call. MySQL and PHP are available for both Windows and Linux so I have figured out how to create a database that I can access no matter which I am booted up into.

Is that overkill for what I want to do? When I originally installed Linux on this computer I chose to have Apache, MySQL and PHP installed at the time. In the last couple of weeks I have figured out the essentials of using those to create my database. Would there have been an easier way to create a simple database that could be accessed from both Linux and Windows.
 
Old 06-25-2003, 12:59 PM   #4
Rick422
Member
 
Registered: Apr 2003
Location: Arizona
Distribution: Red Hat Linux 9
Posts: 158

Rep: Reputation: 30
Chapzilla also said he needed a JDBC interface. I see that there is a chaper on JDBC and Java in one of the two PHP/MySQL I have. I have not yet read that chapter. I wonder if the Java is used instead of the PHP or in addition or what? I am not sure. Several years ago I took a Java course so that feature might eventually be of use to me. I am not a computer professional or a total expert on this although I did once take a database course.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Laptop Recommendation Kernel_Sanders *BSD 1 11-16-2005 09:26 AM
Snort database: Closing connection to database "" Homer Glemkin Linux - Security 2 07-14-2005 06:58 PM
MB recommendation zbrox Linux - Hardware 1 06-22-2004 12:18 PM
Book Recommendation jasonmantey Linux - Newbie 4 12-14-2003 07:19 AM
Software recommendation automicro Linux - Software 1 08-19-2003 04:53 PM


All times are GMT -5. The time now is 10:43 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration