Firebird News

Thursday, July 21, 2005

Grid-powered network thin clients run embedded Linux and ... Firebird database


"ThinLinx has launched a line of Linux-based thin-clients that access
Ubuntu Linux desktops and commercial Linux applications hosted on
ThinLinx's grid network. The Hot-E initially offers Firebird database,
Compiere and OpenCRX ERP/CRM"


http://www.linuxdevices.com/news/NS4609128375.html

..::::..

Monday, July 18, 2005

99 Bottles of Beer in Firebird relational database SQL


/*
* beer_song.sql - 99 Bottles of Beer in Firebird relational database SQL
* Firebird is at firebird.sourceforge.net
* Author: Jim Dunleavy
* 2003-11-27
*/


..::::..

Friday, July 15, 2005

Newest Concern on Sun's Open Source Strategy - Firebird/Interbase mentioned


Firebird/Interbase license is mentioned on theserverside.com

"Several years ago, Borland released the Interbase Database source
code as an Open Source project. They then, quickly, turned around and
brought it back in house. Obviously, it was immediately forked and
today we have Firebird, which as far as I can tell is on a divergent
course from Interbase.

Interbase wasn't free long enough for any community work to have been
done on it before it was taken back, and I'm not familiar with their
license. But it is an example of a company "changing its mind"
regarding an open source project."

http://www.theserverside.com/news/thread.tss?thread_id=35242


..::::..

Firebird switch - dot net provieder story

And MySQL is not being entirely upfront either. What is also interesting is that the new database connectors are being released under GPL only. For example if you were doing .NET development you have to release all of your software under GPL. This switch by MySQL stems from the fact that a court in the US deemed connecting to a database using a standard API is not an infraction of the GPL. As MySQL is trying to squeeze developers and admins to buy commercial licenses I switched to Firebird.

Found it on this blog

..::::..

libgda/libgnomedb 1.3.4 released


libgda/libgnomedb are a complete framewok for developing
database-oriented applications, and currently allow access to PostgreSQL,
MySQL, Oracle, Sybase, SQLite, FireBird/Interbase, IBM DB2, mSQL and MS
SQL server, as well as MS Access and xBase files and ODBC data sources.

libgda/libgnomedb are the base of the database support in the GNOME
Office application suite, providing database access for many features in
both Gnumeric and Abiword.

1.3.4 is another step in the road to 2.0, which will be out with GNOME 2.12

You can find more information at the projects' homepage: http://www.gnome-db.org


..::::..

Wednesday, July 13, 2005

Firebird Internals: OAT, OIT, and Sweep in Episode 4 (A New Hope)

A long time ago in a galaxy far, far away...

Firebird for the Database Expert: Episode 4 - OAT, OIT, and Sweep by Ann Harrison.

..::::..

New Norwegian Search Vendor using Firebird

It seems like we now have an other Scandinavian contender in the Search Engine space.
They base their technology around SQL and native integration (porting) into each supported database. For the moment they support Microsoft SQL, Oracle, Interbase and Firebird , DB2 later this year or on customer request.

Source of news is unstruct.org

..::::..

Bugtracking With Track+Firebird

Arno from australia wrote this

I have been looking for some decent, easy-to-use bugtracking software lately for one of our projects. My first recommondations were Bugzilla and Mantis, simply because I knew them from the past and they were freely available. But their installation procedures (e.g. Perl, MySQL as prerequisites for Bugzilla) overstrained the sysadmin responsible for setting up and maintaining the server (external staff - to his defense, he had no experience in these areas). Plus I never liked Bugzilla's nor Mantis' user interface.

So I continued searching, and finally found Track+. Originally a Sourceforge project, the licensing model was very attractive (free license for up to ten users), the featureset looked good, it supported all kinds of operating systems and databases, and it came with a complete Windows installer. I did a test installation and had it up and running in ten minutes.

The only prerequisite is an existing JDK1.4.2. The setup package also provides Tomcat 5 as web/application container and the free Firebird database. I only had to add tools.jar to Tomcat's classpath (seems as if the installer forgot about that - otherwise Tomcat's JSP engine Jasper would not be able to compile JSP pages)

..::::..

Monday, July 11, 2005

Firebird Internals Episode 3 - On Disk Consistency (Revenge of the crash)

Ann Harrison published her 3rd expert whitepaper, this time on disk consistency.

Read more

..::::..

Friday, July 08, 2005

Firebird Client 2.0 Alpha 1 for .NET 2.0 Beta 2 - released

Carlos announced the availability of Firebird Client 2.0 Alpha 1 for .NET 2.0 Beta 2, with the following notes: "For now only source and installation packages (for .NET 2.0 Beta 2) are available. Remember that it's an alpha version and it should be used only for testing. Release notes are here.
..::::....::::....::::..

Thursday, July 07, 2005

Europe Parliament Nixes Software Patent Law

The European Parliament overwhelmingly rejected a proposed law Wednesday
to create a single way of patenting software across the European Union,
calling instead for comprehensive rules for granting patents to inventions
in all fields.

..::::..

Wednesday, July 06, 2005

Open Source is the Future. Open Source is Now.

Open source databases white paper (firebird,ibphoenix,fyracle mentioned):
pdf download

More papers on the same site http://virtuas.com/opensource.html

..::::..::::..::::..::::..

firebird on SCO Openserver 5.0.7 ! doh

> I have attempted to build firebird (1.0 and 1.5) on SCO Openserver 5.0.7

I don't think is worth the time to port on it , you can get a
free/open/gnu linux
very easy ;) and firebird is compiling well on recent distro's (minus
ones with gcc 4)

..::::..::::..::::..

Tuesday, July 05, 2005

STOP Software Patents in Europe - last day call


How you can help




If you cannot attend the demonstation in Strasbourg in person please phone or fax your member of the European Parliament (MEP). Or better yet discuss the situation with others you work with and send a company FAX to show them how this new legislation will hurt your business if the Buzek-Rocard-Duff amendments are not adopted by parlement on Wednesday. If you don't inform your parliament, mega-corporations are doing the job for you: "The European Parliament is filled with lobbyists of Microsoft, Eicta, CompTIA and so on. There are 30 to 40 lobbyists permanently roaming the halls."


Join us now...

..::::..
..::::..
..::::..
..::::..

Monday, July 04, 2005

Firebird SQL Service monitor and Server Config - screenshots

DISCLAIMER:

Software downloadable here is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. If you live or are intended to use this software in countries where this is not applicable ("AS IS" basis), DO NOT USE IT

FBMonitor

Firebird SQL Service monitor

Application Tray can Monitoring, Start, Stop, Restart Firebird SQL 1.5 Services over network.
Like as apache monitor

Download it from, EXE file included

http://www.parmaja.com/downloads/fbMonitor-1.0.0.zip

Forum Page

Screenshots

http://www.parmaja.com/projects/firebirdtools/screenshot1.png

fbConfig 1.0.0

Firebird SQL 1.5 Config tools
It is a simple tools for edit "firebid.conf" and "aliases.conf" as easy without define the path of server (taked from registry),
- Easy Hash Unhash line (comment it),
- Recognize hashed value for Unhasing it,
- Description for every values.

Download it from, EXE file included

http://www.parmaja.com/downloads/fbConfig-1.0.0.zip

Forum Page

Screenshots

http://www.parmaja.com/projects/firebirdtools/screenshot2.png


..::::..

Saturday, July 02, 2005

what is new in Firebird Alpha3

raw changelog is updated on sf.net

Added some Alpha 3 changes
  **************
* v2.0 Alpha 3
**************

* DDL improvement
Allow to create foreign key constraints without need to get exclusive lock
on whole database
Contributor(s):
Vlad Horsun

* Fixed unregistered bug
Fix 'partner index not found' error when one classic process
dropped FK and another process trying to delete master record
Contributor(s):
Vlad Horsun

* ISQL improvement
Make SQLDA_DISPLAY display input SQLDA parameters of INSERTs, UPDATEs and DELETEs
Contributor(s):
Adriano dos Santos Fernandes

* Fixed unregistered bug
Server crashed when PLAN for VIEW is specified but no table alias was given
Contributor(s):
Vlad Horsun

* Fixed Alpha 2 bug (SF #1184591)
Invalid ROW_COUNT variable value after DELETE
Contributor(s):
Dmitry Yemanov

* Fixed unregistered bugs
1) redundant attempts to get an exclusive database lock during shutdown
2) inaccurate timeout counting
3) database lock is not released after bringing database online in the exclusive mode
4) removed a 5 sec timeout when bringing database online in the shared mode
Contributor(s):
Dmitry Yemanov

* Fixed bug SF #1016040
Missing external libraries causes engine exception
Contributor(s):
Adriano dos Santos Fernandes

* DML enhancement
Implemented RETURNING clause for the INSERT statement
See also:
/doc/sql.extentions/README.returning
Contributor(s):
Dmitry Yemanov

* Fixed bug SF #1186607
Foreign key relation VARCHAR <-> INT
Contributor(s):
Vlad Horsun

* Fixed bug SF #1211325
BLOBs in external tables
Contributor(s):
Vlad Horsun

* New charsets/collations
1) KOI8-R (Russian language) and KOI8-U (Ukrainian language) charsets and dictionary collations
2) WIN1257_LV (Latvian), WIN1257_LT (Lithuanian), WIN1257_EE (Estonian) collations
Contributor(s):
Oleg Loa
Aleksey Karyakin

* Parser improvement
Try report the line/column of an incomplete statement.
Contributor(s):
Claudio Valderrama

* Fixed unregistered bugs
1) Charset/collation issues for expression-based view columns
2) Lost charset/collation for local PSQL variables
Contributor(s):
Dmitry Yemanov

* Fixed Alpha 2 bug (SF #1171256)
Local Protocol (XNET) isn't using aliases
Contributor(s):
Dmitry Yemanov

* Fixed unregistered bug
Database alises didn't work in WNET
Contributor(s):
Dmitry Yemanov

* Fixed bug SF #1211354
Redundant evaluations in COALESCE
Contributor(s):
Arno Brinkman

* Fixed unregistered bug
Client crashed while disconnecting with active event listener
Contributor(s):
Dmitry Yemanov

* Fixed SF bug #1208932
SHOW GRANT does not distinguish object types
Contributor(s):
Claudio Valderrama

* Optimizer improvement
Use more realistic cost value for unique retrieval
Contributor(s):
Arno Brinkman

* Fixed SF bug #494981
Bad exception report
Contributor(s):
Claudio Valderrama

* DDL enhancement
Implemented ALTER EXTERNAL FUNCTION to change the entry_point or the module_name when the UDF cannot be dropped due to existing dependecies
Contributor(s):
Claudio Valderrama

* Fixed Alpha 2 bugs
1) bug with selectivity of non-equality comparisons
2) changed the invertions selection code to help in both MERGE and JOIN paths
3) implemented metadata extract for expression indices
4) the threading issues in fbembed
Contributor(s):
Dmitry Yemanov

* DDL enhancement
Implemented the COMMENT statement to set the metadata descriptions
See also:
/doc/sql.extentions/README.ddl.txt
Contributor(s):
Claudio Valderrama

* Fixed bug SF #908319
1.5 wrong err msg using gbak with service_mgr
Contributor(s):
Vlad Horsun

* Fixed unregistered bug
A few internal buffer overflows are fixed
Contributor(s):
Alex Peshkov

* Fixed unregistered bug
After an attempt to "create view v(c1) as select 1 from v" all clones of system request remained active forever
Contributor(s):
Alex Peshkov

* Fixed Alpha 2 bug
Server crashed in incorrect written EXECUTE BLOCK statement
Example(s):
EXECUTE BLOCK AS BEGIN
INSERT INTO DUMMY (ID) VALUES(?);
END
Contributor(s):
Vlad Horsun

* Fixed unregistered bug
ISQL_disconnect_database overwriting the Quiet flag permanently
Contributor(s):
Miroslav Penchev
Claudio Valderrama

* Fixed unregistered bug
Server crashed during the table metadata scan in some cases
Contributor(s):
Dmitry Yemanov

* Fixed unregistered bug
Error "index key too big" when creating a descending index
Contributor(s):
Vlad Horsun

* Fixed SF bug #1191006
Using where params in SUM return incorrect results
Contributor(s):
Arno Brinkman

* Fixed Alpha 2 bug
Problem with distributing sort to deeper RSE
Example(s):
SELECT RDB$RELATION_NAME FROM (SELECT FIRST 10 * FROM RDB$RELATIONS ORDER BY RDB$RELATION_NAME DESC) ORDER BY RDB$RELATION_NAME
Contributor(s):
Arno Brinkman

* Fixed SF bug #1122344
gbak -kill option drops existing shadow
Contributor(s):
Dmitry Yemanov

* Fixed SF bug #750662
Multiple declaration of blob filters
Contributor(s):
Dmitry Yemanov

* Parser improvement
UNIONs are allowed in ANY/ALL/IN subqueries
Contributor(s):
Dmitry Yemanov

* Fixed SF bug #743679
FIRST / SKIP not well implemented
Contributor(s):
Dmitry Yemanov

* Optimizer improvement
NOT conditions are simplified and optimized via index when possible
Example(s):
(NOT NOT A = 0) -> (A = 0)
(NOT A > 0) -> (A <= 0)
Contributor(s):
Dmitry Yemanov

* Fixed SF bug #450404
ISQL uppercases role in the command line
Contributor(s):
Claudio Valderrama

* Fixed unregistered bug
100% CPU load when an I/O error causes a rollover to non-existing shadow
Contributor(s):
Dmitry Yemanov

* Fixed Alpha 2 bug (SF #1173988)
Minor glitches in GBAK output
Contributor(s):
Claudio Valderrama

* Fixed unregistered bug
Fix for the -b (Bail On Error) option when SQL commands are issued and no db connection exists yet.
Apply Miroslav Penchev's patch for bug with -Q always returning 1 to the operating system, discovered by Ivan Prenosil.
Contributor(s):
Claudio Valderrama

* New INTL interface
A new interface allowing the following enhancements and features
Contributor(s):
Nickolay Samofatov

* INTL enhancements
1) Well-formedness checks of string constants and parameters
2) Uppercase and lowercase all possible (and not only ASCII) characters in default collation orders
3) Check length of characters (and not bytes) for new MBCS (including UTF8)
4) Inform original character set in sqlsubtype of XSQLVAR when connecting with NONE
Contributor(s):
Adriano dos Santos Fernandes

* BLOB enhancements
1) Allow usage of collations
2) Perform comparison using entire content
3) Convert between character sets when assigning from string or BLOB
Contributor(s):
Adriano dos Santos Fernandes

* Unicode 4.0 support
UTF8 character set with collations UCS_BASIC and UNICODE
Contributor(s):
Adriano dos Santos Fernandes

* Brazilian collations
1) Collation PT_BR for ISO8859_1 and WIN1252 character sets
2) Collation WIN_PTBR for WIN1252 character set
Contributor(s):
Adriano dos Santos Fernandes
Paulo Henrique Albanez

* New string functions
LOWER, BIT_LENGTH, CHAR_LENGTH/CHARACTER_LENGTH, OCTET_LENGTH, TRIM.
See also:
/doc/sql.extentions/README.length
/doc/sql.extentions/README.trim
Contributor(s):
Adriano dos Santos Fernandes

* INTL plugins
Character sets and collations are installed using a manifest file. Server write to the log when conflicts exist.
Contributor(s):
Adriano dos Santos Fernandes

* Fixed SF #1073212
Order by big columns (collate) terminates server
Contributor(s):
Adriano dos Santos Fernandes

* Fixed SF #939844
Queries > 263 chars with UNICODE DB throws GDS Exception
Contributor(s):
Adriano dos Santos Fernandes

* Fixed SF #977785
Wrong character lengths MBCS (UTF-8, East-Asian charsets)
Contributor(s):
Adriano dos Santos Fernandes

* Fixed SF #536243
UNICODE_FSS charset and UPPER function
Contributor(s):
Adriano dos Santos Fernandes

* Fixed SF #942726
UPPER does not convert aacute to Aacute for ISO8859_1
Contributor(s):
Adriano dos Santos Fernandes

* Fixed SF #544630
Problems when connecting using UNICODE
Contributor(s):
Adriano dos Santos Fernandes

* Fixed SF #540547
Concatenation, numeric fields & charset
Contributor(s):
Adriano dos Santos Fernandes

* Fixed unregistered bug
Query produce different result depending on index presence when the last character of the string is the first character of a compression pair
Contributor(s):
Adriano dos Santos Fernandes

* Fixed unregistered bug
SUBSTRING and multi-byte BLOB don't work correctly
Contributor(s):
Adriano dos Santos Fernandes

* Fixed unregistered bug
Pattern matching with multi-byte BLOB is performed in binary mode
Contributor(s):
Adriano dos Santos Fernandes

* Fixed unregistered bug
It's not safe to connect with MBCS if database has columns using different character set
Contributor(s):
Adriano dos Santos Fernandes



..::::..

bitweaver released


It's been a while coming, but the Firebird powered wiki site is running
and stable
http://home.lsces.co.uk/tikifirebird
Not much in the way of content yet, apart from the words list, which has
been split down into single letter pages, and just a few logos to start
the gallery. It is powered by bitweaver which is the new name for tikipro.
There has been a major re-write of the code, much like Firebird, but now
there is a clean modular shell onto which other packages can be grafted.
http://www.bitweaver.org/


It runs on Apache/PHP which means any OS you like, and your favourite
installation of Firebird. I'm running the demo sites split across two
machines, Firebird on one and Apache2/PHP5 on the second, and all
running 'as installed'.

The magic bit is that bitweaver will install
using Firebird as the database 'out of the box'. Just tell the installer
where your copy of isql is located (the default location is provided) and
the bitweaver installer will do the rest. Add an alias before you start
and you can use that in the install. Now we just need a few more users to
iron out any remaining bugs and
start to build Firebird pages.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services


source for news : firebird-php

..::::....::::....::::..

Friday, July 01, 2005

New database discussion forum

Martijn Tonies and Arno Brinkman have created a new database-development forum website. It's a single website for discussing all kinds of different database engines.

::::::::::

Fyracle 0.8.8 released

Fyracle is the nick-name for Oracle-mode Firebird. By using Oracle-mode Firebird, you can bring the cost of porting major Oracle based enterprise application down to manageable levels. Fyracle does this by matching Oracle syntax idiosyncrasies and by providing the ability to compile and execute PL/SQL procedures unchanged.

Continued

..::::..::::..::::..