2005 LinuxQuestions.org Members Choice AwardsThis forum is for the 2005 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2005. This is your chance to be heard! Voting ends March 6th.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
If you like organization, excellent documentation, and compliance with standards, then PostgreSQL is the right choice.
If you prefer chaos; if you like having certain features unavailable to you unless you choose a certain database engine; if you like reading that the syntax accepted before version 3.x.y is not available afterward, or that you are allowed to use a subqueries only after version 4.1, but only if you don't do it on the same table; if you like reading errata to learn that certain operations cannot be performed on temporary tables, but that that feature is planned for versions starting with 5.2, MySQL is the thing for you.
PostgreSQL, the most complete FOSS database out there :}
I'm using SQL myself, but I'm starting to get very worried about the license...
Is their any difference with PostgreSQL. If not what databases should I start using to avoid all this license stuff. For me this is a very important issue(I don't mind using something less good if it's completely free). This one would also be my database of the year
Originally Posted by jens
I'm using SQL myself, but I'm starting to get very worried about the license...
Is their any difference with PostgreSQL. If not what databases should I start using to avoid all this license stuff. For me this is a very important issue(I don't mind using something less good if it's completely free). This one would also be my database of the year
PostgreSQL 8.x includes most of SQL 99 plus a couple of its
own extensions. Just have a look at their web-site, and read
up on their features. Or tell me which features you're currently
using with whateverSQL, and I'll try to tell you whether PostgreSQL
can ...
I can't afford MySQL licence for my commercial customers, and my customers can't afford to hire a database manager to manage Postgres.
It's not clear to me why you feel the need for a commercial license for MySQL, a GPL'ed application. Do you plan to make extensions or modifications that you don't want to release? That kind of work sounds quite expensive, too.
Post seems to stick closer to the "GPL" theme than MySQL, so that makes it my fav, though they each have their advantages from a performance perspective.
It's not clear to me why you feel the need for a commercial license for MySQL, a GPL'ed application. Do you plan to make extensions or modifications that you don't want to release? That kind of work sounds quite expensive, too.
No, I have no plans or desire to extend or modify and RDBMS, but I want to use one for a commercial application. If I use MySQL I have to pay license fees. With Firebird I don't.
Quote from MySQL site:
#
If you include the MySQL server with an application that is not licensed under the GPL or GPL-compatible license, you need a commercial license for the MySQL server.
#
If you develop and distribute a commercial application and as part of utilizing your application, the end-user must download a copy of MySQL; for each derivative work, you (or, in some cases, your end-user) need a commercial license for the MySQL server and/or MySQL client libraries.
#
If you include one or more of the MySQL drivers in your non-GPL application (so that your application can run with MySQL), you need a commercial license for the driver(s) in question. The MySQL drivers currently include an ODBC driver, a JDBC driver and the C language library.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.