Understanding Zope Database Adaptaters
This document tries to explain how Zope Database adaptaters are working.
Recently I have worked on two Zope database adaptaters: One for PostgreSQL (ZPsycoPGDA) and the other for Oracle (ZcxOracleDA).
Lately, we were hacking on PostgreSQL (PostGIS) triggers, and we quickly felt
like debugging our code... Here is a cheap and quick way of printing out
triggers variables and context through Django.
PostgreSQL server configuration
In postgresql.conf, adjust the minimum level of notice sent to the client :
Si vous avez déjà touché à un Oracle vous connaissez peut-être le mot clef CONNECT BY qui permet d'effectuer des requêtes arborescentes.
On Ubuntu 10.04 (tested on server and desktop editions), the PostgreSQL database created by default, uses the SQL_ASCII encoding!
It's not possible to create new utf-8 databases so check the encoding with
psql -l as PostgreSQL user and you can use the following radical way (drop everything) to fix this:
I did not find the time earlier to post about it.
Minitage 1.0 is out for a week now.
With the new PostgreSQL server versions in place (8.2 and 8.3) and in a more general way with the 8.x series some nice fonctionnalities have benn added. Let's have a short look at som interesting ones: FILLFACTOR=50/Id on INSERT/TOAST FIELDS/TABLE INHERITANCE/TABLE PARTITIONNING/NOTIFY and LISTEN