Author: mariuz

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).

If you want to test the new firebird 3.x api here are some test added to fbstuff git repository

The fix was “Only dump config params on failure to connect when verbose option is specified.”
Also you can check the commits log for other small changes