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

1 Star2 Stars3 Stars4 Stars5 Stars (9 votes, average: 4.89 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

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.

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 5.00 out of 5)
Loading...

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 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

1 221 222 223 224 225 485