Database Workbench 4.1 released

Ladies, gentlemen,

Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:

Database Workbench 4.1.0 Pro

This release includes the FREE Lite versions for InterBase, Firebird
and MySQL.

Version 4 introduced full Unicode support, 4.1.0 adds new features,
latest DBMS support and improved functionality.

For more information, see here.

Click here for the full list of changes in v4.1

Database Workbench supports:
– Borland InterBase ( 4.x – XE )
– Firebird ( 1.x, 2.x )
– MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 & 2, SQL Express )
– MySQL 4.x, 5.x
– Oracle Database ( 8i, 9i, 10g, 11g )
– Sybase SQL Anywhere ( 9, 10, 11 and 12 )
– NexusDB ( 3.0 and up )

The Perfect Database Server : Firebird 2.5 and FreeBSD 8.1

Here is the guide on installing Firebird 2.5 from FreeBSD 8.1 Ports and creating your first test database also we show you howto install Flamerobin GUI (administation tool) and the PHP driver for it .
This was tested on fresh freebsd 8.1 on a virtual machine

Testing identity columns in Firebird 3.0

Someone on support list asked about identity column in Firebird and how it can be managed easier and i remembered that identity is already supported firebird 3.0 so i fired up flamerobin and created a table with new identity column type similar to MSSQL “identity”, MySQL “auto_increment” or PostgreSQL “serial”
All worked as in documentation 🙂 inserting and selecting from the table no generators/triggers were needed to be created by hand

Boolean datatype implemented in FB 3

The support for a BOOLEAN datatype was the third most voted feature in the Firebird tracker. The deal with it was about make it right and complete, having booleans expressions allowed where values are expected, and vice versa. Oracle did it wrong and they BOOLEAN is crap.

Yesterday I finished and committed this support for Firebird 3. You can use them like any other type. You can index it, aggregate by it and sort by it. If you have an index on a boolean field, you can also do indexed searches by its negated form (NOT field).

Read full post in Adriano’s blog.

ibphoenix.com relaunched with new interface

I like the new style for ibphoenix , minor glitch is the firebird image in corner is quite blurry and should be replaced with higher quality image
also on my monitor is too small 1920×1080 and i have to do 3xCTRL+ to fit the screen, maybe a liquid layout should be applied (i will send the bug and the fix) . In rest is great maybe is too much white in background and the stripped green background should be a added back ?

1 2 3