LWN.net Logo

Firebird 1.5 Final Release

Version 1.5 of the Firebird relational database is available. "The v1.5 release represents a major upgrade to the engine, which has been developed by an independent team of voluntary developers from the InterBase(tm) source code that was released by Borland under the InterBase Public License v.1.0 on 25 July 2000. Development on the Firebird 2 codebase began early in Firebird 1 development, with the porting of the Firebird 1 C code to C++ and the first major code-cleaning. Firebird 1.5 is the first release of the Firebird 2 codebase. It is a significant milestone for the developers and the whole Firebird project, but it is not an end in itself. As Firebird 1.5 goes to release, major redevelopment continues toward the next point release on the journey to Firebird 2."
(Log in to post comments)

Looking for free native Windows database

Posted Feb 24, 2004 19:04 UTC (Tue) by proski (subscriber, #104) [Link]

My friend is learning programming and I'm encouraging her to use free software. She is not yet ready to dump Windows. She wants to learn databases and I helped here install PostgreSQL 7.4.1 on Cygwin. I'm afraid that it's not too reliable and too complicated, e.g. because of the different paths as seen by native and Cygwin programs.

I'm looking for a native Windows database that would be easy to set up and administer for somebody with modest skills (plus a strong desire to learn). I wonder if Firebird would be a good choice.

Looking for free native Windows database

Posted Feb 24, 2004 21:22 UTC (Tue) by hingo (subscriber, #14792) [Link]

I haven't used Firebird (nor any of its' InterBase predecessors) myself, but I would think it's okay, if you find it easy enough to install. Certainly it should be easier than Postgresql on Gygwin.

The other open source db is of course MySQL, which is easy to install and get started with. MySQL is also more widely used, so there is plenty of documentation and helpful people available on the net.

I don't know about the current situation with graphical user interfaces to MySQL, but when I used it, I actually found phpMyAdmin to fit my taste best. phpMyAdmin is easy to install, but it requires you have a web server running somewhere, since it's a php-application. Oh yes, then you need to have PHP installed on the web server. So there are pre-requisites, but after that it is easy to install. (Of course, you don't need a web server on the internet, just apache or IIS on your own computer will do fine.)

Some links:
http://www.devside.net/web/server/win32
http://apache2triad.sourceforge.net/
http://www.foxserv.net/portal.php

This is all assuming you want phpMyAdmin. MySQL only is: http://www.mysql.com/.

Looking for free native Windows database

Posted Feb 24, 2004 23:30 UTC (Tue) by parimi (subscriber, #5773) [Link]

I used mysql-front for quite a while and was impressed by it. Anyone wanting to run a mysql client from windows should give it a shot. It is available at http://www.mysqlfront.de/

Looking for free native Windows database

Posted Feb 25, 2004 18:08 UTC (Wed) by hingo (subscriber, #14792) [Link]

Based on the screenshots, I'd recommend this too. Looks nice.

henrik

Looking for free native Windows database

Posted Feb 24, 2004 22:15 UTC (Tue) by tomsi (subscriber, #2306) [Link]

Having used Borland Interbase before on Windows and Linux; I can recommend FireBird as it is stable and feature rich.

Tom

Looking for free native Windows database

Posted Feb 26, 2004 3:01 UTC (Thu) by yodermk (subscriber, #3803) [Link]

A simple solution for learning database programming?

http://sqlite.org/

Highly doubt you could top that one.

Looking for free native Windows database

Posted Feb 26, 2004 4:34 UTC (Thu) by eyal (subscriber, #949) [Link]

Firebird is a VERY good choice, for both Windoze and *nix platforms. I use it for a product that I develop so I can testify based on actual (and extensive) usage:

* Installation is a no-brainer.
* Administration is usually not needed.
* Modest resources requirements (Win9x with 32MB can be a server...)
* Many SQL features among them updatable views, triggers, stored procedures, domains, foreign keys, constraints, default values, and plenty more.
* Good to excellent performance.
* Under intensive development, so new features are added and peformance is improved.
* Stable and (also pretty stable) development versions available.
* Knowledgeable and helpful community.
* If needed commercial support and consulting is available.
* Many DB development tools (free and commercial).
* Interface through native client DLL/SO, ODBC, Java, .Net provider, etc.

All in all I highly recommend Firebird. MySQL and PostgreSQL are still great DBs and each of them has important advantages, but if you require native Windoze support and good compliance with the SQL standard - FB is the choice.

Eyal.

Copyright © 2004, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds