Firebird News: May 2006

Monday, May 29, 2006

Remastering DSL: A Short HOWTO - candidate for small Firebird+Flamerobin live CD

[Another very good candidate for an very small Firebird + Live CD , Milan mentioned it and now i will try to remaster it . Is very good for < 100M live cd or to install it/boot on USB, with qemu starts very fast]

Debian Live +Firebird

[Seems to be smaller than ubuntu with gnome or xubuntu , so if i can remaster it maybe i can make the default firebird+flamerobin live cd ]

Saturday, May 27, 2006

Lazarus - Delphi like ide -Appliance

Here the firebird dbaware components are active and and dbgrid populated at
design time

Ultimat Firebird Database Appliance

Here is when install firebird components in lazarus ide

Monday, May 22, 2006

Mono Live + Firebird - work in progress this summer

I will create an Firebird Live Cd + mono applications this summer (be it if i'm accepted for

google summer of code or not)

Here is the list of application i intend to add to the dapper live cd (the list is taken from the mono-live.org )

Desktop Applications (written in Mono)
Beagle - Desktop Search (done with apt-get)
Blam - Blog Reader
F-Spot - Photo Album
Muine - Music Player or Banshee (itunes like with apt-get install)
Tomboy - Simple Note-Taking

Web Applications (ASP.NET)
ASP.NET Forums - 1.0 on Firebird (if it works or will be ported)
BlogX - Weblog Engine
IBuySpy - Portal on Firebird (if it works or will be ported)
mojoPortal - Community Portal
nGallery - Web Photo Gallery

Developer Tools (Mono and non-Mono)
MonoDevelop - Mono IDE (done apt-get)
Monodoc - Documentation Browser (done apt-get)
Glade - GTK+ / Gtk# GUI Builder (done apt-get)
FirebirdSQL- Best Open Source Database [DONE]
Flamerobin - Graphical Firebird Administration and Development Tool[DONE]

Other possible inclusions:
Reports Starter Kit using Mono/Firebird

Time Tracker Starter Kit using Mono/Firebird

DotNetFirebirdBB It should work with Mono/Firebird
Lucene.net (with firebird support addded) and optional spider (Hard work)
Read more about the original mono-live cd www.mono-live.org/Defau...

Saturday, May 20, 2006

Firebird 2.0 From source howto (ubuntu dapper drake)

download the Firebird 2.0 RC 2 kit
wget http://ovh.dl.sourceforge.net/sourceforge/firebird/Firebird-2.0.0.12654-ReleaseCandidate2.tar.bz2

tar -jxvf Firebird-2.0.0.12654-ReleaseCandidate2.tar.bz2
cd firebird-2.0.0.12654-ReleaseCandidate2/
sudo apt-get install libreadline5-dev
sh autogen.sh --prefix=/opt/firebird2 --enable-superserver
make
sudo make install
ps -awwwx | grep firebird (see if is working)

/opt/firebird2/bin/isql -u SYSDBA -p masterkey /opt/firebird2/examples/empbuild/employee.fdb

Database: /opt/firebird2/examples/empbuild/employee.fdb, User: SYSDBA
SQL> show tables ;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT JOB
PROJECT PROJ_DEPT_BUDGET
SALARY_HISTORY SALES

SQL>select * from sales;

Here is one screenshot

.:(firebird):..:(databases):..:(sql):..:(ubuntu):..:(debian):.

Friday, May 19, 2006

Firebird Backups

[some notes on backup process - blog of the day]

Thursday, May 18, 2006

MySQL PowerPC optimizations

[maybe is time for firebird on powerpc , this time i need some hardware : g4/g5 with ubuntu x.xx ]

Monday, May 15, 2006

Firebird locking from 10.000 ft

[small intro to locking and MGA in firebird ]

ZeosDBO intro and call for help

[they need more delphi/lazarus developers]

installing JEDI VCS

An alternative to cvs/subversion for delphi users, what is interesting about it ? you can install it on an firebird server or use the firebird 1.5.x ebedded included in the JCVS app server setup

Read more (in portuguese) at www.delphiman.com.br/bl...

related to nhibernate and firebird support

[ What NHibernate Supports: DB2, Firebird, SQL Server 2000 / 2005, MySQL (3? ) / 4 /5, Oracle, PostgreSQL, SQLite, Sysbase, AccessYes, I guess that NHibernate is so much less flexible than their product.]

Firebird locking

[firebird blog of the day]

How open source databases will kill mssql server

[I agree with the open source databases vs mssql part, i don't have comments on the other things]

10.MySQL / PostgrSQL / Firebird threatens MS SQL Server. SQL Server is the one division that showed a modest profit in 2004, but many database professionals are switching Open Source alternatives. Even though sales for SQL Server is growing, it is growing at a slower rate than the overall market.

Firebird used in ethernus (embedded devices)

[Firebird used in embedded device ]

DB/CRM module accompanied with Lefthand CRM is a great extension of Your ethernus .Stable, preconfigured [Firebird] database server for your company and flexible Customer Relationship Management encourage your employees to more efficient work.

Read more in polish at www.idg.pl/news/93067.h...

Wednesday, May 10, 2006

Sequoia 2.8.1 (C-JDBC) - new release new features

[Seems that Clustered JDBC got new release out- Now they renamed the project to Sequia also project have new license : apache]

DBReplicate - Firebird dump tool ?

[interesting perl tool for dumping firebird's database structure- didn't test it yet]

Perl program to help extracting a database's data and metadata and dumping it as a set of SQL commands (similar to pg_dump or mysqldump).

firebird-docs - quote of the day - Paul Vinkenoog

I guess is time for more action in documentation area , if you can help please give a hand

[Please don't apologize! We're all volunteers, we're doing our best andwe have limited spare time. You should read some of my announcementson this list, stating that this-or-that will be ready in one day / oneweek / a couple of weeks... and compare to the actual delivery dates.In december 2002 (or 2003?) I estimated that we could have a full setof Firebird documentation ready in two years, everything written fromscratch, no copying from IBPhoenix or other docs. Of course I wouldn'thave to do it alone - there were as many as TWO active members in themanual subpoject then :-) :-)]

Ragetutorials.com » 1. History and definition of PHP

[I din't knew php was started as an bunch of perl scripts ;) . Good news is that you can use it with firebird , and in the future someone will fix the pdo driver in php5.x too - seems to be the next jdbc like interface to databases ]

Tuesday, May 09, 2006

myTracker - firbird project of the day

[MyTracker is tracking and collaboration system that allows users to collect, file, share, and discuss any type of information, whether it is news, a thought, bug, task, idea, document, graph and report. MyTracker is powerful, well-organized, efficient, fully customizable and easy to use.]

SitePoint Forums - Anyone suggest a good Firebird Database Host?

[i guess i could reply with ibphoenix firebird hosters lists and ... reea.net]

Ingress "Enterprise" database 2006 released

quote of the day "Its not as simple or straight forward as PostgreSQL or MySQL (or even Firebird) but its not much of a chore either. The one thing that I can't figure out is the 'sql' or 'isql' interfaces. I can't find explanations beyond how to invoke them in the guide and nothing I do has an effect.... I'll figure it out in time."

Monday, May 08, 2006

FBReplicator 4.1 - released

For those who are interested, a new version of FBReplicator is now released. New features include the following

* Fixed bug with ReplManager to allow addition of target databases

* Fixed bug with ReplManager Preferences to allow for test email

* Enhanced ReplManager to provide for better form design on different screen sizes

* Changed ReplManager to run maximised

* Changed all icons to new form

* Updated to Indy 10 component set for all three packages