Firebird News

Friday, September 30, 2005

Last day for early bird discount

Today is the last day that a conference attendee can get the "early bird" discount. The conference will cover Firebird developments and roadmap, development technologies (delphi, java, .net & php; 1/2/3-tier, SOA's), user experiences and applications, and developer tips and tricks. Best of all, the conference will enable you to meet many of the core developers and personalities.

..::::..

IBAnalyst 1.9 -released

We are proudly present to you the new version of our unique analytic
tool – IBAnalyst 1.9. Now IBAnalyst brings you

the new quality of database statistics analysis – it can load metadata
of the database and provide more exact hints

and recommendations.

Also the full version contains several white papers and "how-to guides"
regarding database statistics interpretation

and database optimization.

What’s new In IBAnalyst 1.9

* New "Load metadata" option in Services API dialog. Enabling this
option will load metadata (table structure)
* Added column Statistics (Index view). Information is taken from
Services API (if Load Metadata is On). Column

shows rdb$indices.rdb$statistics data. If this information is outdated,
it will be marked yellow for less than 20%

difference with calculated index selectivity, or red if difference
greater than 20%. For that indices right mouse

click on Statistics column enables to recompute selectivity.
* Added total index size into row "Data version percent" at Summary view
* Added column "Size, mb" to Index view.
* TIP size report in recommendations fixed from bytes to kilobytes
* Option "take only header page" in Services API dialog is saved/restored
* Added recommendation about outdated index statistics.
* ODS 9.x information about numeric fields is now taken correctly
* "Wrong ODS" error now processed and reported correctly
* Fixed report in recommendations about gap between Oldest Snapshot and
Oldest Active
* Several interface improvements
* and more!

Download trial version of IBAnalyst 1.9 now from www.ibanalyst.com!

--
Sincerely yours,
Alexey Kovyazin
www.ibsurgeon.com

..::::..

Requesting news about your products (fbdeveloper.com)

Dear Colleagues!

As you know we've published the first issue of "The InterBase and
Firebird Developer Magazine" at September 1.
The second issue will be published at October 15.

We will be glad to publish fresh news about your products - please send
your press releases to press@...
Exclusive news, news about forthcoming products/releases and news
regarding open source initiatives have the highest priority for publication.

Sincerely yours,
Alexey Kovyazin
www.ibdeveloper.com
The Interbase and Firebird Developer Magazine

..::::..

request for fbconference ad on debiancentral.org

It should apear in banner top area (they host ads for open source projects)
http://debcentral.org/modules/news/article.php?storyid=38

..::::..

Sunday, September 25, 2005

Spreading the word about the firebird conference

If you want to help spreading the word about the conference, attached
to this message is a banner that you can use.




Cantu (Membro do TeamFB - FireBase)
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br

..::::..

Friday, September 23, 2005

Version 1.11 of FBCopy tool is released

Version 1.11 of FBCopy tool is released. Grab it while it's hot. :)

With FBCopy, you can easily copy data between Firebird tables and
databases. FBCopy is a command-line tool, so you can use it
inside batch scripts, cron jobs, etc. You can also use the HTML output
option to get a clear overview of database differences.

There are a lot of nice GUI tools that do it, but they all require
thay you have fast access to database. If you have databases on remote
server, which are too big to copy them to your computer, pump the
data, and copy back, FBCopy is the choice.

Also, if you need to pump data on Linux or FreeBSD, this is (AFAIK) the
only native program that does it.


New features:

- Automatic detection of database's charset
- Option to keep going even if some data could not be copied
- Option to disable triggers during copying


Bugfixes and enhancements:

- Computed fields aren't copied anymore
- Detect when tables depend on each other via CHECK constraints
- Fixed dependency sorting (code contributed by Thiago Borges)
- Dependencies via check constraints are taken in consideration


More info and downloads:
http://fbexport.sourceforge.net/fbcopy.html


The tool is open sourced, download and use is free.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org

..::::..

Thursday, September 22, 2005

Fyracle OCI Connector

In the Fyracle newsgroup several requests have been
made for support for applications that use Oracle's
native API, called "OCI".

Users can help with adding support for the OCI API.
Please see: http://www.fyracle.org/oci

The files in this directory contain a stub for
the most common functions in Oracle's oci.dll
By taking these stubes and adding code to translate
the calls to the OCI functions to the equivalent
Firebird API functions an "OCI Connector" for
Fyracle can be created.

All and any community support with this task is
much appreciated.

Questions? Please ask them in the Fyracle forum.

..::::..

Fyracle Delphi Connector

In the Fyracle newsgroup several requests have been
made for support for Delphi/Kylix/FreePascal.

The Fyracle connector has been designed with just
enough of the Firebird API implemented to support the
ODBC and JDBC drivers. Users can help by adding support
for the full API.

Have a look at: http://www.fyracle.org/delphi

The files in this directory generate an 'empty' connector
library, named "delphi_conn.dll". This DLL exposes (part
of) the Firebird API -- i.e. the isc_* functions -- and
dynamically loads the "fbclient.dll" library to handle
the calls to those functions.

In order to help with adding Delphi support to Fyracle,
please help with adding the missing API functions to this
connector library. We will add these to the Fyracle
library in turn. If your Delphi application works with
the 'empty' connector, it will work with Fyracle as well.

Questions? Please ask them in the Fyracle forum.
..::::..

Wednesday, September 21, 2005

The list and details of all the speaker papers for the Firebird Conference

The Firebird conference will take place at the Hotel Olsanka in Prague, Czech Republic from the evening of Sunday the 13th of November (opening session) until the evening of Tuesday the 15th of November (closing session).

The list and details of all the speaker papers is now available. There is a great selection of speakers and topics. A conference schedule should follow shortly.

Note: If you want early bird registration, you will need to register before the end of September.

..::::..

Firebird Surgeon Released

Alexey Kovyazin announced Version 1.1 of IBBackupSurgeon, a tool that can read and save data from corrupted Firebird or InterBase backup files. The Basic version can save data from most corrupted backups. Pro version can use the structure of intact backup in order to read heavily corrupted backups.

..::::..

Firebird Global Usage Survey

Carlos Cantu announced the opening of the Firebird Global Usage Survey to determine how and where Firebird is being used all around the world. The survey ends in 10 days.

..::::..

Tuesday, September 20, 2005

Multi-core licensing and virtualization promote open source databases

Multi-core licensing and virtualization promote open source databases .
" More flexible licensing is one of the biggest draws open source software has for enterprise users, and the current shift toward dual-core and multi-core processors and use of virtualization technologies may give Linux and open source software even more of an advantage, say analysts and open source project leaders."

http://business.newsforge.com/business/05/09/12/1515200.shtml?tid=37

..::::..

Sunday, September 18, 2005

Human Profile announces DWebPro Version 6.0 with Firebird support

With DWebPro 6.0 you can distribute on CD/DVD your PHP, Perl, ASP 3.0, ASP.Net, JSP/Servlet, ColdFusion, Python, Ruby, Rebol, Delphi Web Script II, EXEs, CGIs and ISAPIs dynamic websites without any change.

Human Profile announces DWebPro version 6.0, a stand alone web server created to run directly from CD/DVD. This software is available for any Windows 32-bit platform including 95/98/98SE/NT4/ME/2000/2003 and XP.

DWebPro is designed to support the standard CGI and ISAPI interfaces so it can work with PHP, Perl and a lot of other server side scripting engines. It supports also MySQL, PostgreSQL and Firebird (also embedded) database servers in addition to SQLite and Ms Access database file. Both server side scripting languages and databases support are provided by our unique "ready to run" preconfigured packages.

Source for news http://www.irishdev.com


..::::..

Friday, September 16, 2005

Firebird Embedded use on Linux

To use Firebird on Linux without needing to add users or set permissions, you can use the Classic server and get it down to just a few files. I used FirebirdCS-1.5.2 on SuSE 9.2 but it should work for any Linux distribution and any recent Firebird release. What you need is:

1. A directory to setup a mini Firebird environment. I used ~/firebird and you need these files in the directory:

libfbembed.so
firebird.conf
security.fdb
intl/fbintl
bin/fb_lock_mgr

2. You need to link with or dynamically load the libfbembed.so library. It will allow direct connection to the database without needing a server process.

3. The firebird.conf file just needs one line with "RootDirectory=?" where ? is the full path of the mini Firebird environment directory.

4. The security.fdb file will be used to validate the username and password when you connect so you can either setup users in it or just set the sysdba password to a known value and login using sysdba. This security file is really a dummy file and will not provide any real security but its an embedded database so you are not looking for the same type of security a networked server would need.

5. The files all need to be owned by the user who will be opening the database so in my case they were all owned by me. Special care needs to be taken with the fb_lock_mgr since the one in /opt/firebird/bin is setup owned by firebird.firebird and with the setuid bit turned on but you will not need any of this for this configuration. In general if you're application is running as user "foo" then that user needs to have read/write access to the database you are trying to open, to the security.fdb file, and to the directory you installed the Firebird mini environment.

In your code you need to set the environment variable FIREBIRD to the location of the mini Firebird environment and then you should be able to use isc_attach_database and just pass a full pathname to the database file you want to use.
Source for article : bpepers on fbtalk.net

..::::..

Monday, September 12, 2005

Phoenix PHPServer - PHP5 and firebird in same package (Easy LAMP)

Paul Ruizendahl releases an easy-install "LAMP"-style stack for webserver development. Currently named "Phoenix PHPServer", it wraps a webserver, PHP 5 and Firebird. Version 0.9 is available for download.

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

Sunday, September 11, 2005

Firebird (and IBExpert) on German Magazine CD

we just wanted to let everybody know that the german magazine ct
(www.heise.de/ct, i would say the most important serious computer
magazine in german language, about 500000 times printed each issue)
will have a major topic regarding free Database Systems in
their next issue 20/2005 (coming on 19th Sept 2005).

The major players there are mysql, postgresql and firebird.

We were asked for a special IBExpert Version for the magazine cd
and we created a special Version for it. On the CD will also be
the firebird server.

There will be a kind of a programming Championship in the magazine
regarding a portable webshop system, that should work on all three
database systems. Since there is a large community of mysql users
and also postgresql users, we should also have a look what we can
do to support the firebird database solution in this championship.

I will inform everybody here when we have seen the final
printed version of the article in the magazine and the
stuff on the cd.

Best Regards

Holger Klemt

The Worldwide Firebird Conference, November 13th - 15th,
Prague, Czech Republic

The most Expert for InterBase and Firebird --- www.ibexpert.com
HK Software - Gerhard Stalling Str 47A - 26135 Oldenburg - Germany
Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de
Training and Support for Delphi, InterBase, Firebird, AS/400
..::::..

Saturday, September 10, 2005

Mono 1.1.9 Releasead - firebird provider mentioned

Firebird provider

>From Carlos: Support for the new INSERT ... RETURNING statement of Firebird v2.0

Added support to the new CREATE SEQUENCE and SET GENERATOR statements to the FbBatchExecution class.

Add parameter information for DML statements and allow the configuration of quoted identifiers usage to the DataAdapter Configuration Wizard.

Mono full release notes http://www.go-mono.com/archive/1.1.9/

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

Firebird in ArkLinux

For ArkLinux.org users or those seeking one of the best user-friendly Linux distros. They are adding FirebirdSQL to their repository...
http://www.arklinux.org/forum/viewtopic.php?showtopic=1327
http://www.arklinux.org/

Ark Linux 2005.2 RC1 has received a SoftPedia pick award.
According to SoftPedia's awards page, these awards are given to "products that we think are excellent and above average in their category. Awards are given based on our experience and judgement, and only to products which the majority of our reviewers agree deserve it."

ps: source fyracle.org

..::::..

FBLib Firebird Library 0.81 released

Source : fyracle.org


FBLib Firebird Library 0.81 is released , Open Source Library No Data Aware for direct access to Firebird Relational Database from Borland Delphi / Kylix , Freepascal and Lazarus
Read more

..::::..

Friday, September 09, 2005

KInterbasDB 3.1.2 released

What is KInterbasDB?
--------------------
KInterbasDB is a Python extension package that implements Python
Database API 2.0-compliant support for the open source relational
database Firebird and some versions of its proprietary cousin Borland
Interbase. In addition to the minimal feature set of the standard
Python DB API, KInterbasDB also exposes nearly the entire native
client API of the database engine.

KInterbasDB is free--covered by a permissive BSD-style license that
both commercial and noncommercial users should find agreeable.


What's new in release 3.1.2?
----------------------------
KInterbasDB 3.1.2, a maintenance release of the stable 3.1 branch,
fixes a handful of bugs, most fairly obscure. A changelog is
available here:
http://kinterbasdb.sourceforge.net/dist_docs/changelog.txt


Where can I learn more about and download KinterbasDB?
------------------------------------------------------
http://kinterbasdb.sourceforge.net

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

The Firebird ADO.NET Data Provider 1.7.1 Release Candidate 1 for Microsoft.NET 1.1 and Mono 1.1.x

Carlos Guzmán Álvarez announced that The Firebird ADO.NET Data Provider 1.7.1 Release Candidate 1 for Microsoft.NET 1.1 and Mono 1.1.x is available for download.

..::::..::::.#.::::..

dbdesc 1.0 added firebird support

dbdesc is a powerful command-line tool to help you document your databases. It can produce detailed documents describing your databases.

Here is described how it was created

..::::..

Thursday, September 08, 2005

The Firebird Conference 2005 details



..::::..

Open Source Database Conference 2005

Spoted on blogosphere
The Open Source Database Conference 2005 deserves some coverage as it is the only forum in recent years that focuses on all of the major Free Software and Open Source DBMS, and includes business sessions that focus on how Free/Open databases fit into the business world, along with solid technical sessions (usually from core developers of the DBMS in question) on:
* Apache Derby
* Berkeley DB
* Firebird
* HSQLDB
* Ingres
* MaxDB
* MySQL
* PostgreSQL
* SQLite

Additionally, conference organizer Software and Support Verlag has graciously made exhibition space available for the Free/Open DBMS projects that are not supported by a company. (Contact me for details)

So, if you can, please attend - you won't find a better event for Free/Open databases anywhere else this year. See http://www.opendbcon.net/ for more details on sessions, speakers, travel and rates.


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