I've just committed an initial version of PostgreSQL support to my repository.
Some work on this was done against an earlier version of Laconica by Thomas Legg - see http://www.the-eleven.com/tlegg/index.php?/archives/46-PostgreSQL-backed-Laconica.html (although the site is down at the time of writing). However, I have started from scratch because: a) I wanted to know exactly what changes were involved and why, b) the database and code have changed significantly since then, and c) that version involved changing table names and data types, while I wanted to make as few changes as possible to keep things compatible and maintainable going forward. I have a test installation up and running and so far everything seems good except for the fulltext search which I haven't attempted to convert yet. More testing is necessary, so if anyone would like to help out you just need the current darcs version of laconica along with this patch: <http://darcs.ciarang.com/darcsweb.cgi?r=laconica;a=commit;h=20080909072224-f6e2c-881bd2e7fb032f336fecae9ca5ce527dd821d3dc.gz> Instructions for setup are as normal except: 1. Create the database using "create dbname with encoding 'utf8'" 2. Use the db/laconica_pg.sql as the create script 3. In config.php, set ['db']['quote_identifiers'] = true and ['db']['type'] = 'pgsql' 4. Set the database connection string accordingly, i.e. pgsql:// instead of mysql:// I'm using PostgreSQL 8.1, which I think is probably the minimum requirement (at least for the way I've done things). Cheers, Ciaran _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
