Beware of Firebird 2.0 Debian package and UDF
when you upgrade in debian from firebird 1.5.x to 2.0.x beware of some UDF issues
when you upgrade in debian from firebird 1.5.x to 2.0.x beware of some UDF issues
We have similar databases running on MySql, Postgresql and Firebird. One of the reasons for moving away from MySql was that the UTF8 support didn’t work properly.
Read the rest of the article here http://nikolajlindberg.blogspot.com/2008/03/firebird-vs-postgresql.html
I’m using last jruby release with rails 2.0.2 and activerecord-jdbc-adapter.
Here is the rest of the article http://www.forniol.cat/?p=91
flamerobin – 0.8.6 added to ubuntu hardy/gutsy repository and uploaded
Hi all,
This is mostly a bug-fix release, probably a first ‘stable’ 0.8
version without major bugs. Windows, Linux and Mac OS X binaries and
source code package are available for download. I recommend all Linux
distribution packagers to upgrade (especially if you still use 0.8.3
or lower). Here’s the changelog since 0.8.3:
New features
– DataGrid: BLOB data is now (optionally) shown in cells. Read-only for now.
– DataGrid: A basic ORDER BY clause building when column header is
double-clicked
– Support for LIST function in Firebird 2.1
– Support for MON tables in Firebird 2.1 (Read-only for now.)
Enhancements and Bug fixes
– DataGrid: FR no longer crashes when transaction has ended
(commit/rollback) and grid edit control is active
– DataGrid: Complete string is now shown for editing and copying multiline text
– DataGrid: Copy command now copies a single cell if nothing is selected
– DataGrid: Fixed mixup between BLOB ID and data it contains
– DataGrid: Fixed bug when editing or deleting in grid causes exceptions.
– DataGrid: Successfully deleted rows are deselected, so user can
easily see what is done.
– DDL extraction for GRANTs now only quotes names when needed
– DDL extraction for defaults does not use double quotes anymore.
– Database property page now shows minor ODS version when it is not zero
– Hovering over icons in privileges window, now really shows the grantor
– Improved parsing of SELECT statements
– Support for INSERT..RETURNING and EXECUTE STATEMENT that return a
single record
– Fixed messagebox flood when Execute Procedure called and it doesn’t
return anything
– Print preview and SaveToHtmlFile works again for manual and changelog
– Extracting invalid DDL (missing domain data in system tables) does
not crash FR anymore
– Silent installation (on Windows) does not show changelog window anymore
– Autogenerated domains (system domains) do not show up in the tree anymore
– Added ALTER DOMAIN action for domains
– Tree now shows NOT NULL for columns that inherit NOT NULL from domain
– Fixed parsing bug when non-reserved keyword is used as identifier
– Fixed autocomplete for selectable procedure alias when procedure
call contains parameters (in PSQL)
Enjoy.
php5-interbase package fixes php-api dependencies (LP: #179803) and (LP: #135695)
and ibwebadmin is an update release for ubuntu gutsy
the repository can be used by adding it in /etc/apt/sources.list
deb http://ppa.launchpad.net/mapopa/ubuntu gutsy main
deb-src http://ppa.launchpad.net/mapopa/ubuntu gutsy main
then
$sudo apt-get update
$sudo apt-get install ibwebadmin
as bonus firebird2.0-super from repository fixes startup bug when server is restarted
Welcome to VVV. VVV is an application that catalogs the content of removable volumes like CD and DVD disks for off-line searching. Folders and files can also be arranged in a single, virtual file system. Each folder of this virtual file system can contain files from many disks so you can arrange your data in a simple and logical way
Here is howto compile it from source on Ubuntu and windows
The next IB LogManager release 2.9.0, which is currently in BETA, will have support for Firebird 2.1 database triggers. This allows you to create a log entry e.g. when someone connects to the database or disconnects from the database. Or even transaction starts and commits can be logged. This is very useful if you need more enhanced auditing capabilities.
Beside database trigger support, version 2.9.0 will also have the following enhancements:
– NULL states in log data grids are shown with a user-definable color now.
– Better visual support for partially registered tables and operations by using separate icons.
– Fully register a database for logging after showing the partially analyzed database dialog.
– MUCH better filtering capabilities in logging schema.
If you would like to give IB LogManager 2.9.0 BETA a try, please send an email to “t.steinmaurer AT upscene.com”.
As you may know, the KInterbasDB project is without maintainer, and
because Firebird project depends on it (for QA and other things), we
have to do something to ensure it’s bright future. I have considered the
option to take over this project, but at the end we decided to fork it
under Firebird Project for next reasons:
Finally, the new PEAR::MDB2 1.5.0beta1 is out!
The number of fixed bugs and new features since the last stable release is impressive. The bravest of you that already installed the alpha version may have tried some of these already,