Re: [gentoo-user] Databases - which one

2003-07-03 Thread Kevin S. Dome
I really like MySQL,it is especially made wasy with phpMyAdmin, which will also show you the SQL syntax as well as making administration easier. kevin On Thu, 2003-07-03 at 09:05, brett holcomb wrote: I'm looking for a database for use on my home systems - doesn't have to handle large

Re: [gentoo-user] Databases - which one

2003-07-03 Thread brett holcomb
Thanks. I had considered MySQL but it doesn't have (at the last time I checked) some of the features of databases like DB2, Sybase, etc. in the area of data integrity, etc. I want to have the features of those databases. On 03 Jul 2003 09:07:24 -0500 Kevin S. Dome [EMAIL PROTECTED] wrote: I

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Andrew Gaffney
Kevin S. Dome wrote: I really like MySQL,it is especially made wasy with phpMyAdmin, which will also show you the SQL syntax as well as making administration easier. I second the recommendation for MySQL. I have it running as the database backend for the scheduling backend I designed for my

RE: [gentoo-user] Databases - which one

2003-07-03 Thread Joan . Ribas
referencial in spanish)... I recommend you to see the specifications and features of each database and then make a choose. -Original Message- From: Kevin S. Dome To: [EMAIL PROTECTED] Sent: 03/07/2003 16:07 Subject: Re: [gentoo-user] Databases - which one I really like MySQL,it is especially

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Mike Roest
Mysql with a InnoDB table backend is much better in those respects. It enforces foreign key constraints, has a transaction log so if the server dies in the middle of a transaction it can rollback or forward. Quite nice actually, it is a little more of a pain to setup as there are some

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Mikhail P.
Personally I prefer Postgresql, as it is more stable and has features mysql does not have. Although MySQL is faster than postgres. So it really depends on your needs - large php driven sites with database probably will consider mysql (because it is faster), while small commercial organizations

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Zachary P. Landau
I'm looking for a database for use on my home systems - doesn't have to handle large transactions. I was planning on using PostGRESQL but noticed Firebird and was doing some reading on it. Any pros or cons, experiences of one vs the other? I know a lot of people like MySQL and if you

Re: [gentoo-user] Databases - which one

2003-07-03 Thread brett holcomb
-user] Databases - which one I really like MySQL,it is especially made wasy with phpMyAdmin, which will also show you the SQL syntax as well as making administration easier. kevin On Thu, 2003-07-03 at 09:05, brett holcomb wrote: I'm looking for a database for use on my home systems - doesn't have

Re: [gentoo-user] Databases - which one

2003-07-03 Thread brett holcomb
is called in this way, integridad referencial in spanish)... I recommend you to see the specifications and features of each database and then make a choose. -Original Message- From: Kevin S. Dome To: [EMAIL PROTECTED] Sent: 03/07/2003 16:07 Subject: Re: [gentoo-user] Databases - which one I

Re: [gentoo-user] Databases - which one

2003-07-03 Thread brett holcomb
From research I've done it appears MySQL does things that are non-standard for SQL or the ANSI specs. On Thu, 03 Jul 2003 08:19:03 -0600 Mike Roest [EMAIL PROTECTED] wrote: Mysql with a InnoDB table backend is much better in those respects. It enforces foreign key constraints, has a

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Matthew Kennedy
brett holcomb [EMAIL PROTECTED] writes: Thanks. I had considered MySQL but it doesn't have (at the last time I checked) some of the features of databases like DB2, Sybase, etc. in the area of data integrity, etc. I want to have the features of those databases. I would go with PotgreSQL as

Re: [gentoo-user] Databases - which one

2003-07-03 Thread brett holcomb
Thank you. On Thu, 03 Jul 2003 09:30:14 -0500 Matthew Kennedy [EMAIL PROTECTED] wrote: brett holcomb [EMAIL PROTECTED] writes: Thanks. I had considered MySQL but it doesn't have (at the last time I checked) some of the features of databases like DB2, Sybase, etc. in the area of data

RE: [gentoo-user] Databases - which one

2003-07-03 Thread Brenden Walker
03, 2003 10:30 AM To: [EMAIL PROTECTED] Subject: Re: [gentoo-user] Databases - which one brett holcomb [EMAIL PROTECTED] writes: Thanks. I had considered MySQL but it doesn't have (at the last time I checked) some of the features of databases like DB2, Sybase, etc. in the area

RE: [gentoo-user] Databases - which one

2003-07-03 Thread Brenden Walker
10:30 AM To: [EMAIL PROTECTED] Subject: Re: [gentoo-user] Databases - which one brett holcomb [EMAIL PROTECTED] writes: Thanks. I had considered MySQL but it doesn't have (at the last time I checked) some of the features of databases like DB2, Sybase, etc. in the area of data

Re: [gentoo-user] Databases - which one

2003-07-03 Thread brett holcomb
Argghhh!! Choices G! I guess that's what makes OpenSource so nice - but it means I have to make a decision G. At least with Gentoo I can unmerge cleanly if I don't like something! On Thu, 3 Jul 2003 10:55:02 -0400 Brenden Walker [EMAIL PROTECTED] wrote: But Firebird is based on Interbase

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Peter Ruskin
On Thursday 03 Jul 2003 15:07, Kevin S. Dome wrote: I really like MySQL,it is especially made wasy with phpMyAdmin, which will also show you the SQL syntax as well as making administration easier. kevin There's also a nice GUI in portage (knoda), that works with MySQL, PostGreSQL and

Re: [gentoo-user] Databases - which one

2003-07-03 Thread brett holcomb
Thanks. I'll check it out. On Thu, 3 Jul 2003 18:57:43 +0100 Peter Ruskin [EMAIL PROTECTED] wrote: On Thursday 03 Jul 2003 15:07, Kevin S. Dome wrote: I really like MySQL,it is especially made wasy with phpMyAdmin, which will also show you the SQL syntax as well as making administration

Re: [gentoo-user] Databases - which one

2003-07-03 Thread raptor
On Thu, 03 Jul 2003 10:05:11 -0400 brett holcomb [EMAIL PROTECTED] wrote: |I'm looking for a database for use on my home systems - |doesn't have to handle large transactions. I was planning |on using PostGRESQL but noticed Firebird and was doing |some reading on it. Any pros or cons,

RE: [gentoo-user] Databases - which one

2003-07-03 Thread Brenden Walker
PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [gentoo-user] Databases - which one On Thu, 03 Jul 2003 10:05:11 -0400 brett holcomb [EMAIL PROTECTED] wrote: |I'm looking for a database for use on my home systems - |doesn't have to handle large transactions. I was planning

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Zachary P. Landau
As I wrote earlier : ]- firebird(interbase) - multiversioning engine(i.e not lock based), small-footprint, installforget, forkthreaded variants, subselects/joins/triggers/etc all is there... very simple way to add new functions via Delphi/Kylix or C (UDF) Just for the curious, PostgrSQL

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Martin LORANG
SAPDB the open source DB from SAP is more like DB2 or ORACLEDB it worth a try http://www.sapdb.org Martin Le Jeudi 3 Juillet 2003 16:05, brett holcomb a écrit : I'm looking for a database for use on my home systems - doesn't have to handle large transactions. I was planning on using

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Andrei Ivanov
But the documentation sucks... On Thu, 3 Jul 2003, Martin LORANG wrote: SAPDB the open source DB from SAP is more like DB2 or ORACLEDB it worth a try http://www.sapdb.org Martin Le Jeudi 3 Juillet 2003 16:05, brett holcomb a écrit : I'm looking for a database for use on my home

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Martin LORANG
Le Jeudi 3 Juillet 2003 22:00, Andrei Ivanov a écrit : But the documentation sucks... Not with MSIE : I dont know why -- [EMAIL PROTECTED] mailing list

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Mario Udina
On Thu, 2003-07-03 at 16:33, brett holcomb wrote: From research I've done it appears MySQL does things that are non-standard for SQL or the ANSI specs. Yes it does, in fact it si the least SQL standard database I have seen. I prefer postgresql (linux) sapDB (windows) because of the

Re: [gentoo-user] Databases - which one

2003-07-03 Thread brett holcomb
Thank you and all the others. I didn't want to get locked into MySQL pecularities and then if I switch be stuck with a rewrite. It also doesn't support things like views, etc. I didn't check the license though. On 03 Jul 2003 22:41:21 +0200 Mario Udina [EMAIL PROTECTED] wrote: On Thu,

RE: [gentoo-user] Databases - which one

2003-07-03 Thread Brenden Walker
a compliant engine, but you still end up having to rewrite a bit... -Original Message- From: brett holcomb [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: Re: [gentoo-user] Databases - which one Thank you and all the others. I

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Mike Principito
This is a fun topic to jump into -- so I will :) First off I'm not going to talk about Firebird, mainly because I don't know enough about firebird to say anything good or bad. I have however done some research into the big debate of PostgreSQL vs Mysql. Actually I was starting a project and I

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Brett I. Holcomb
[mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 4:52 PM To: [EMAIL PROTECTED] Subject: Re: [gentoo-user] Databases - which one Thank you and all the others. I didn't want to get locked into MySQL pecularities and then if I switch be stuck with a rewrite. It also doesn't

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Brett I. Holcomb
Thanks for the input. This is a fun topic to jump into -- so I will :) First off I'm not going to talk about Firebird, mainly because I don't know enough about firebird to say anything good or bad. I have however done some research into the big debate of PostgreSQL vs Mysql. Actually I was

Re: [gentoo-user] Databases - which one

2003-07-03 Thread Brett I. Holcomb
Thanks, but it's for KDE and I don't run KDE. On Thursday 03 Jul 2003 15:07, Kevin S. Dome wrote: I really like MySQL,it is especially made wasy with phpMyAdmin, which will also show you the SQL syntax as well as making administration easier. kevin There's also a nice GUI in portage