Is there any sql server over fedora core linux

Discussion of programming on Linux, including shell scripting, perl, python, c/c++, mono, java. Whatever tickles your fancy.
Post Reply
swatiantigers
Lance Naik
Posts: 44
Joined: Tue Feb 22, 2005 11:54 am
Location: swat
Contact:

Is there any sql server over fedora core linux

Post by swatiantigers »

hi
is there any sql server for linux. i have seen gre sql in fc1. i have installed it but dont know how to install it and is it will be same like microsoft sql server 2000? if you know some one better plz tell me ?
and one thing more, how will i use it with java?

thanx alot in advance
Image
Qadri-409
Battalion Havaldaar Major
Posts: 286
Joined: Sun May 09, 2004 4:16 pm
Location: Peshawar
Contact:

Re: Is there any sql server over fedora core linux

Post by Qadri-409 »

swatiantigers wrote:hi
is there any sql server for linux. i have seen gre sql in fc1. i have installed it but dont know how to install it and is it will be same like microsoft sql server 2000? if you know some one better plz tell me ?
and one thing more, how will i use it with java?

thanx alot in advance
Dear swatian tiger ;-

there are mysql and postgres sql in linux
have a look at following links

http://www.linuxpakistan.net/forum2x/vi ... stgres+sql

http://www.linuxselfhelp.com/howtos/Pos ... WTO-5.html
http://linas.org/linux/db.html
http://www.faqs.org/docs/Linux-HOWTO/En ... TO.html#s6

take care
M Shahzad Qadri
whizkid
Cadet
Posts: 8
Joined: Sat Oct 16, 2004 8:18 pm
Location: Karachi
Contact:

i'd recommend mysql

Post by whizkid »

I've never actually used postgres and I've seen comparisons that it is faster than mysql in some regards and offers a bunch of functionality which MySQL does NOT, at this time! ;)

I'd like to make my recommendation for MySQL, it should come with your FC cdroms... you'd have to download the Query and Admin interface to get the SQL Server like Enteprise Management console (you can find them at www.mysql.com). To connect MySQL with Java, you'd need to have Java installed on your machine and you can obtain the JDBC connector from (obviously!) mysql website.
farhantoqeer
Major General
Posts: 917
Joined: Thu Jun 27, 2002 5:45 pm
Location: Karachi
Contact:

Post by farhantoqeer »

MySQL 5 is still in beta stage, prior to that there is not support of views and triggers. I would suggest PostgreSQL
A: Yes
Q: Is top-posting bad?
fawad
Site Admin
Posts: 918
Joined: Wed Aug 07, 2002 8:00 pm
Location: Addison, IL
Contact:

Post by fawad »

I second the recommendation for PostgreSQL. It has support for the enterprise level functionality that MySQL is only beginning to get now. As an added bonus, none of its interface libraries is GPLed.
kadnan
Battalion Quarter Master Havaldaar
Posts: 208
Joined: Wed Aug 07, 2002 8:00 pm
Location: Karachi,Pakistan
Contact:

Post by kadnan »

you asked for server otherwise i could suggest you SqLite(http://sqlite.org)

it has triggers and SP and faster than both PostgreSql and Mysql Server :P
Post Reply