web2py or Django ? for #python firebird web development
web2py is another python famework that supports Firebird out of the box , the question is if is worth investigating it
Category: Blogroll
Quick Start Guide to index optimisation
Below a five point Quick Start Guide to index optimisation, courtesy of Pavel Cisar.
Pictures from Firebird course
Kelver Merlotti posted (a few moths already) about the Firebird course and took pictures of one happy event:
Good morning! Saturday was a party in the course of # Firebird, to celebrate my birthday
Really nice guys! Following pictures:
Tips : create/alter/drop user in firebird 2.5 , or howto get rid of gsec
On .net provider list Rick Roen is writing a utility to change user password , the best way to change it is from sql :).
Read the user create/delete/update notes.
Now a regular user can change it’s own password without the need for sysdba intervention:
The new DDL command ALTER USER enables an “ordinary” user (a regular Firebird user, a non-root user on POSIX or a trusted user on a Windows system where trusted authentication is enabled) the ability to change his or her password and/or personal name elements, while logged in to any database.
#Ruby on Rails Driver updates
Using CMake to Install Firebird embedded on Linux and OS X
As described in previous posts deploying a program that uses an embedded copy of Firebird requires shipping some database server files. For Windows this can be done by the software that creates the installation package.
For Linux and OS X it is possible to use the CMake INSTALL command.
Testing boolean columns in Firebird 3.0
After the new year eve i wanted to test the new boolean columns in the new build that added them for firebird 3.0 , so i have created the columns and then inserted some random bool vaules for test after that i have started to test the bool expressions (and , or …) in a select from the new bool values.
ps: the select worked in isql-fb only , in flamerobin the datatype is not implemented yet (default from ubuntu 0.9.2)
Firebird SQL linkedin Community is now an open group
I am pleased to announce that, as the owner of this group, I have just switched us to an open discussion group. All future discussions will be fully visible, searchable, and shareable on the Web. All past discussions are now closed in a members-only archive. I look forward to our future discussions now joining the broader conversation of the wider Web.
Posted By Dumitru Condrea
Go to the complete announcement
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
Trace API support in ADO.NET provider for Firebird (FbTrace)
Trace API support in ADO.NET provider for Firebird (FbTrace). Read more…