Free (but not GPL!) database systems with Fulltext index?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tomfra
Forum Contributor
Posts: 126
Joined: Wed Jun 23, 2004 12:56 pm
Location: Prague, Czech Republic

Free (but not GPL!) database systems with Fulltext index?

Post by tomfra »

I am working on a project that involves running a database system on the client's PC. I need to be able to bundle the database system together with my product which will not be distributed under GPL, therefore the database system itself must not be GPL. MySQL is out of discussion, I just enquired about their commercial license and was told I would have to pay for one license per one copy of my product sold (or given away unless it's GPL).

Could you please suggest one or more database systems that meet the following criteria?

1. Support for Fulltext indexes
2. Free or reasonable pricing
3. License allows it to be bundled with a commercial product (without having to pay for one license per copy of my product)
4. MS Windows version available
5. Binaries must have reasonable size - Oracle's "Express Edition" does not qualify (is around 150MB)

SQLite would be a great option but it does not offer fulltext indexes, neither does Firebird. So what's left? PostgreSQL? Additionally, it would be great if there was a "stand-alone" version of the database which would not require installation. I have seen something like that for MySQL.

Your suggestions are very welcome!

Tomas
Last edited by tomfra on Wed Apr 05, 2006 7:14 pm, edited 1 time in total.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

is this using PHP or some other language?
tomfra
Forum Contributor
Posts: 126
Joined: Wed Jun 23, 2004 12:56 pm
Location: Prague, Czech Republic

Post by tomfra »

It will be using PHP.
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Re: Free (but not GPL!) database systems with Fulltext index

Post by Roja »

tomfra wrote:I am working on a project that involves running a database system on the client's PC. I need to be able to bundle the database system together with my product which will not be distributed under GPL, therefore the database system itself must not be GPL.
Keep in mind that as long as the database itself is seperate, and not connected into your product, you are not required to release the product under the gpl.

But presuming the details are such that that isn't possible..
tomfra wrote:So what's left? PostgreSQL?
PGSQL is under the GPL as well.

A large amount of the well-supported free db software is under the GPL these days. I'm not aware of any that fit all your criteria without being under the GPL. As a result, I suggest digging into the assumption that you cannot use GPL software in your solution.
tomfra
Forum Contributor
Posts: 126
Joined: Wed Jun 23, 2004 12:56 pm
Location: Prague, Czech Republic

Re: Free (but not GPL!) database systems with Fulltext index

Post by tomfra »

Roja wrote:PGSQL is under the GPL as well.
Nope, PostgreSQL is under BSD: http://www.postgresql.org/about/licence . But I haven't used PostgreSQL before so I know relatively little about it.

Tomas
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Re: Free (but not GPL!) database systems with Fulltext index

Post by Roja »

tomfra wrote:
Roja wrote:PGSQL is under the GPL as well.
Nope, PostgreSQL is under BSD: http://www.postgresql.org/about/licence . But I haven't used PostgreSQL before so I know relatively little about it.

Tomas
WOW, I was totally mistaken there! Thank you for the correction!!

I use PGSQL all the time. Its excellent, full-featured, and very similar to MySQL (but without as many shortcomings).

You may stumble on a few of the transition issues, but not many.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

I agree... if you can use MySQL you'll manage Postgres just fine providing you've not always relied upon many of MySQL's non-standard functions etc.
Post Reply