Twitter conversation : Database index nodes are doubly linked to allow bi-directional scans
Twitter conversation of the day is related to SQL Performance Tip : Database index nodes are doubly linked to allow bi-directional scans
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Firebird-Mezzanine = Firebird and Django’s WordPress alternative : Mezzanine
Here are my install instructions on Ubuntu/Debian for Mezzanine CMS
First install Firebird 2.5.2 , Then install django and fdb driver
sudo pip install djangosudo pip install fdbsudo pip install mezzanine
Install django-firebird driver like is described on the github page
Create new mezzanine project:
mezzanine-project firebird-mezzaninecd firebird-mezzanine
create empty database from isql-fb / flamerobin
isql-fb
SQL> create database “localhost:/var/lib/firebird/2.5/data/firebird-mezzanine.fdb” user ‘SYSDBA’ password ‘masterkey’;
SQL> quit;
create local config for firebird
python manage.py createdbpython manage.py runserver
look at the first results after the wordpress import (i was so impressed that i have removed the old wordpress.com account)
next step : blogspot import is in progress
Firebird default character set
Question and answer of the week is related to Firebird default character set by Mark Rotteveel on Stack Overflow
Firebird Training for DB Admins: Firebird database pages
This tutorial takes a brief look at Firebird’s database pages.
For a detailed Database Structure introduction please read Firebird Internals document
Jugglingdb Firebird adapter is ready for testing.
Jugglingdb (NodeJS ORM) Firebird adapter is ready for testing
News via Henri’s tweet
Can not load default Firebird clients (libfbembed.so or libfbclient.so). Check your installation
If you are using Free Pascal / Lazarus to develop applications that needs to access FireBird database, or you need to run applications that has been written using FreePascal/Lazarus and Firebird database, make sure you have installed Firebird client library
Firebird Training for DB Admins: configuration file parameters and database aliases
This session explains a few of the more important firebird.conf parameters.
In this tutorial we take a look at configuring Firebird aliases, files and paths
.NET Data provider : Firebird POSITION unexpected behavior?
Question and Response of the day on the Stack Overflow firebird tag.
The result is a bug filled in the Firebird tracker
Firebird on Debian + Raspberry PI = Love
All in all the Debian Firebird port on Raspberry is very good : It’s quite a nice ARM server for 35$
here are my experiments and all worked as it should (like a similar
x86/x64 server) without issues.
http://mapopa.blogspot.ro/2012/11/debian-and-raspberry-pi-love-small-arm.html
Firebird Database Events and Message-oriented Middleware
Firebird developers can use Firebird events to notify clients about changes in database record data. In this article, I will show and discuss some limitations of Firebird events and compare possible workarounds with a solution based on message-oriented middleware.