Re: [gentoo-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 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? Thanks. -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 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 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? Thanks. -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 father's aircraft rental business. It is also very easy to manage. Webmin has a nice module for managing it, too. -- Andrew Gaffney -- [EMAIL PROTECTED] mailing list
RE: [gentoo-user] Databases - which one
I like sapdb (http://sapdb.org/) it is really complete it has even stored procedures, just compare download sizes: Sapdb for Linux 46 Mb mysql for linux 12 mb mysql does not support views, subqueries, referencial intintegrity (i don't know if in english 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 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 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? Thanks. -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 additional my.cnf directives that need to be added. Compiling the support in is pretty easy USE=innodb emerge mysql. brett holcomb wrote: 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 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 -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 will probably use Postgres, because it is more stable and powerful. On Thursday 03 July 2003 14:05, brett holcomb 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, experiences of one vs the other? Thanks. -- [EMAIL PROTECTED] mailing list -- Windows and DOS -- a turtle and it's shell. -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 are looking for an open source database with the most utilities written for it, MySQL may win. I happen to likst PostgreSQL a lot though. I haven't kept up with MySQL development much, so I don't know what of the following it may already have, but I PGSQL has sub-SELECTs and transactions. I'll admit though, I don't really need these things that often. Mostly, I just PGSQL because it gives me a warm feeling inside. No real reason beyond that. -- Zachary P. Landau [EMAIL PROTECTED] GPG: gpg --recv-key 0x24E5AD99 | http://kapheine.hypa.net/kapheine.asc pgp0.pgp Description: PGP signature
Re: [gentoo-user] Databases - which one
On Thu, 3 Jul 2003 16:17:45 +0200 [EMAIL PROTECTED] wrote: I like sapdb (http://sapdb.org/) it is really complete it has even stored procedures, just compare download sizes: Sapdb for Linux 46 Mb mysql for linux 12 mb mysql does not support views, subqueries, referencial intintegrity (i don't know if in english 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 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 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? Thanks. -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
Thank you. Some of what you have listed is why I'm not looking at MySQL. I have been going through the specs - which is why I asked G. Several have good specs but I'm looking for feedback from those who have actually tried to make the specs work in real life! On Thu, 3 Jul 2003 16:17:45 +0200 [EMAIL PROTECTED] wrote: I like sapdb (http://sapdb.org/) it is really complete it has even stored procedures, just compare download sizes: Sapdb for Linux 46 Mb mysql for linux 12 mb mysql does not support views, subqueries, referencial intintegrity (i don't know if in english 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 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 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? Thanks. -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 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 additional my.cnf directives that need to be added. Compiling the support in is pretty easy USE=innodb emerge mysql. brett holcomb wrote: 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 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 -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
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 integrity, etc. I want to have the features of those databases. I would go with PotgreSQL as the Firebird community is not as large, and thus not as well supported. -- Matthew Kennedy Gentoo Linux Developer Bugs go to http://bugs.gentoo.org! -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 integrity, etc. I want to have the features of those databases. I would go with PotgreSQL as the Firebird community is not as large, and thus not as well supported. -- Matthew Kennedy Gentoo Linux Developer Bugs go to http://bugs.gentoo.org! -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
RE: [gentoo-user] Databases - which one
But Firebird is based on Interbase which has been around a bit longer than PostgreSQL (well, a couple of years) ;-). I don't think you can go wrong with either PostgreSQL or Firebird. Our company uses Interbase (I'm in the process of converting to Firebird) on 100's of database with many of them exceeding 20gig.. The performance is awesome, and the ease of administration is very nice. I've never run PostgreSQL databases of that size (or that extensively) so I don't know how it stacks up. -Original Message- From: Matthew Kennedy [mailto:[EMAIL PROTECTED] Sent: Thursday, July 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 of data integrity, etc. I want to have the features of those databases. I would go with PotgreSQL as the Firebird community is not as large, and thus not as well supported. -- Matthew Kennedy Gentoo Linux Developer Bugs go to http://bugs.gentoo.org! -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
RE: [gentoo-user] Databases - which one
As far as 'not as well supported', not quite so. Most of the active developers are on the lists, and response to questions with quick answers. Support shouldn't be an issue with either. -Original Message- From: Matthew Kennedy [mailto:[EMAIL PROTECTED] Sent: Thursday, July 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 of data integrity, etc. I want to have the features of those databases. I would go with PotgreSQL as the Firebird community is not as large, and thus not as well supported. -- Matthew Kennedy Gentoo Linux Developer Bugs go to http://bugs.gentoo.org! -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 which has been around a bit longer than PostgreSQL (well, a couple of years) ;-). I don't think you can go wrong with either PostgreSQL or Firebird. Our company uses Interbase (I'm in the process of converting to Firebird) on 100's of database with many of them exceeding 20gig.. The performance is awesome, and the ease of administration is very nice. I've never run PostgreSQL databases of that size (or that extensively) so I don't know how it stacks up. -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 UnixODBC. Peter -- == Gentoo Linux: Gentoo Base System version 1.4.3.8p1 kernel-2.4.22_pre2-gss i686 AMD Athlon(tm) XP 1600+ == -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 easier. kevin There's also a nice GUI in portage (knoda), that works with MySQL, PostGreSQL and UnixODBC. Peter -- == Gentoo Linux: Gentoo Base System version 1.4.3.8p1 kernel-2.4.22_pre2-gss i686 AMD Athlon(tm) XP 1600+ == -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
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 |on using PostGRESQL but noticed Firebird and was doing |some reading on it. Any pros or cons, experiences of one |vs the other? | |Thanks. ]- I will bet on Firebird. :) I have used PostgeSQL in the past and was not so impressed... at that time it lacked alot of features (notably outer joins), now I think it is OK. Some good feature of PG object-oriented TABLE specs(inheritance) and such.. Interbase have been around for much longer time. 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) - SUSPEND in stored-procs i.e. stored-proc may behave like normal TABLE ( i.e. SELECT * FROM storedproc() ) - before/after triggers - The creator of interbase still work on FireBird. - afaik interbase is used in M1 tank :) - from all DB I know, it is avail. on more platforms that others - long history, do u remember Borland was No1 in DB - there is records of working DB as large as 200-400GB http://firebirdsql.org/ http://firebirdsql.org/index.php?op=historyid=beginning -- [EMAIL PROTECTED] mailing list
RE: [gentoo-user] Databases - which one
Interbase was started in 1984, first released in 1985 I believe.. PostgreSQL started in 1986 (not sure when it was 'released'). I think Interbase has been in the mainstream longer however. -Original Message- From: raptor [mailto:[EMAIL PROTECTED] Sent: Friday, July 04, 2003 5:29 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 |on using PostGRESQL but noticed Firebird and was doing |some reading on it. Any pros or cons, experiences of one |vs the other? | |Thanks. ]- I will bet on Firebird. :) I have used PostgeSQL in the past and was not so impressed... at that time it lacked alot of features (notably outer joins), now I think it is OK. Some good feature of PG object-oriented TABLE specs(inheritance) and such.. Interbase have been around for much longer time. 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) - SUSPEND in stored-procs i.e. stored-proc may behave like normal TABLE ( i.e. SELECT * FROM storedproc() ) - before/after triggers - The creator of interbase still work on FireBird. - afaik interbase is used in M1 tank :) - from all DB I know, it is avail. on more platforms that others - long history, do u remember Borland was No1 in DB - there is records of working DB as large as 200-400GB http://firebirdsql.org/ http://firebirdsql.org/index.php? op=historyid=beginning -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 has multiversioning, subselects, joins (including outer joins) and triggers. Not sure about the other stuff. -- Zachary P. Landau [EMAIL PROTECTED] GPG: gpg --recv-key 0x24E5AD99 | http://kapheine.hypa.net/kapheine.asc pgp0.pgp Description: PGP signature
Re: [gentoo-user] Databases - which one
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 PostGRESQL but noticed Firebird and was doing some reading on it. Any pros or cons, experiences of one vs the other? Thanks. -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 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? Thanks. -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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
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 features and because of the licence which in my opinion is better than mysql. ciao -- Mario Udina [EMAIL PROTECTED] -- [EMAIL PROTECTED] mailing list
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 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, 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 features and because of the licence which in my opinion is better than mysql. ciao -- Mario Udina [EMAIL PROTECTED] -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
RE: [gentoo-user] Databases - which one
You may find that switching from one database to another (any database) isn't that easy if you utilize the more 'advanced' features such as triggers, stored procedures, etc.. Even complicated sub-select queries may work on one database engine and not another. You can minimize the pain by choosing 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 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, 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 features and because of the licence which in my opinion is better than mysql. ciao -- Mario Udina [EMAIL PROTECTED] -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 asked the same questions that you are. Why pick one over the other, what if I don't like it, choice choice choice! I did some websearching on articles from people benching them against eachother, explored postgres' and mysql's webpages, and asked some good [geek] friends. In the end I ended up choosing MySQL 4 stable (mysql-4.0.13). The reason why I picked it, is because it suited my needs better, on a different project I may have picked something else. The one major downfall to MySQL 4.0.13 is there is no subselect. They are implementing subselects in the 4.1.x series, and truthfully I don't need them. Everything I can do w/ subselect I can do another way. I even figured out how to a NOT IN (SELECT) w/ a join. :) I also found that MySQL was generally faster than Postgres, however benchmarkers stated that Postgres was much better with handling a higher load. I talked to a friend who used to work at VA Linux Systems who mentioned that was why Slashdot was going to migrate to Postgres from MySQL. This never happened because there have been many improvements in performance from 3.x to 4.x and Slashdot is (to the best of my knowledge still running MySQL). Some other reasons why I went with MySQL are: + Transactions have been added with version 4 + Bigger developer base (internally and external support) + I stumbled on a really nice GUI (mysqlcc) Mysql still is lacking many feature of bigger database like triggers, views, stored proceedures, etc. Right now I don't need those things so why bother? There are many other factors and it took me a few weeks to decide, but contingency wise I have build a Database object which could support other databases. That way if I do change databases in the future the upgrade will be much easier (and so will regression testing). Anyway, thats my 2.5 cents. Hope my rambling is some what useful. Cheers, Mike -- And don't tell me there isn't one bit of difference between null and space, because that's exactly how much difference there is. :-) --Larry Wall in [EMAIL PROTECTED] On Thu, 3 Jul 2003, brett holcomb 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, experiences of one vs the other? Thanks. -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
Yes, you're right but I figure if I get one that's compliant - or as much as possible the pain won't be so bad G. I'd probably switch before I got in too deep anyway. You may find that switching from one database to another (any database) isn't that easy if you utilize the more 'advanced' features such as triggers, stored procedures, etc.. Even complicated sub-select queries may work on one database engine and not another. You can minimize the pain by choosing 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 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, 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 features and because of the licence which in my opinion is better than mysql. ciao -- Mario Udina [EMAIL PROTECTED] -- [EMAIL PROTECTED] mailing list -- [EMAIL PROTECTED] mailing list -- Brett I. Holcomb AKA Grunt -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 starting a project and I asked the same questions Anyway, thats my 2.5 cents. Hope my rambling is some what useful. Cheers, Mike -- And don't tell me there isn't one bit of difference between null and space, because that's exactly how much difference there is. :-) --Larry Wall in [EMAIL PROTECTED] On Thu, 3 Jul 2003, brett holcomb 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, experiences of one vs the other? Thanks. -- [EMAIL PROTECTED] mailing list -- Brett I. Holcomb AKA Grunt -- [EMAIL PROTECTED] mailing list
Re: [gentoo-user] Databases - which one
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 (knoda), that works with MySQL, PostGreSQL and UnixODBC. Peter -- Brett I. Holcomb AKA Grunt -- [EMAIL PROTECTED] mailing list