New Flamerobin snapshot revision 2105 in #debian unstable

You can download and install the package directly from debian sid (tested and works on ubuntu natty too )
http://packages.debian.org/sid/flamerobin
ChangeLog:
-New upstream SVN snapshot : revision 2105
-If main window close event can be vetoed then loop through all other BaseFrame instances and check whether they veto the closing (check for open transactions, unsaved changes to files, active background work and so on). Replaces the previous confirmation dialog that was always shown.
-Store last selected authentication mode for database creation as selection index of the choice control instead of string selection because the entries are translatable strings
-Correct value of ExecuteSqlFrame status bar pane with database connection info restored
-LogTextControl modified to be read-only, custom context menu implemented for selecting, copying and clearing the content
-Regression fixed: parameter data type weren’t shown in procedure property pages any more

pyfirebirdsql 0.4.1 – pure python driver released

pyfirebirdsql 0.4.1: pure python dbapi for firebird rdbms released new version  with these changes:
-Python 2.5 support
-connect() dsn can set port number. ex) dsn=’example.com/3050:foo.fdb’
You read in the full commit log
Hajime Nakagami commented on firebird-python:

The most important reason to supoort Python2.5 is “Jython”.
Now 0.4.1 work on CPython 2.5+(include 3.x), IronPython and Jython.

I have never test on PyPy

New Flamerobin snapshot revision 2100 in #debian unstable

The main change is that now it requires firebird2.5-dev instead of firebird3.0 headers and decided that is better to  have a flamerobin 0.9.3 in the distros released for the next 1-2 years with a stable firebird 2.5.x and add firebird 3.0 requirement when is ready and stable ~1-2 years
Changelog:
* New upstream SVN snapshot : revision 2100
Uploaded to unstable
* Stop using system-wide ibase.h.Unstable has no fb3.0 so system-wide ibase.h has no boolean defines,which are used by FR and were ported to IBPP’s embedded copy of ibase.h
* build-depend on firebird2.5-dev instead of firebird-dev(firebird-dev is only in experimental)

You can download and install the package directly from debian sid (tested and works on ubuntu natty too )
http://packages.debian.org/sid/flamerobin
Also for ubuntu the install guide is now updated

Using Firebird inside Azure (without VM role)

Here are the notes on using Firebird Embedded in Azure

Recently I was playing with Amazon EC2 trying what I could use it for. I was playing with Firebird there as well. But in fact you have virtual machine you can use. So using Firebird there wasn’t that hard. But I got and idea about Azure, because it’s more platform for applications than computers.

Then the VM role was introduced and the challenge was somehow not so challenging.

Some thoughts on denormalization

Jiri wrote his thoughts on howto apply list function to create denormalized view of data
From time to time I have an idea for helpful project I could do to help myself or people around me to finish some task faster/easier. And, of course, it often involves database. And though I’m a strong believer in normalization (3NF is must), at least during initial design, sometimes I see this project being partly simple and partly I want it done in no time (because I’m doing it in my own spare time) I think about storing data denormalized and doing the work in application.

Design it normalized, because it’s what you should do. But then you can create a simple view where you use some kind of “LIST” function (i.e. Firebird has exactly that named one). This view will create you denormalized form of data. With a small help from triggers you can also update that view hence underlying data (left as an exercise for reader).

1 128 129 130 131 132 294