User:Dim

Hello world, this is dim. I'm more often than not available on the #postgresql IRC channel (nickname: dim)

Projects

Active projects

• pgloader, the PostgreSQL parallel ETL
  • See Prato 2008 slides here: File:Prato 2008 pgloader.pdf
• prefix GiST opclass, stable software (more than 10 millions queries without error, live)
  • See Prato 2008 slides here: File:Prato 2008 prefix.pdf
• Skytools 2.2 branch mainteneur
• Skytools PGQ PHP extension, libphp-pgq
  • see pgfoundry CVS
  • and debian package and browsable sources at pgql.tapoueh.org
• WIP, PGQ Cooperative Consumers
  • see http://lists.pgfoundry.org/pipermail/skytools-users/2008-July/000671.html
• munin plugins for pgq and pgbouncer
  • pgbouncer_
  • pg_queue_

Past Project

Not active any more by lack of interest, but you can still raise some :)

• DBT2 tsung module

• Solution finder for placing students into groups and foreign language subgroups, implemented with some backtracking in PL/pgSQL, active every summer...
  • http://pgsql.tapoueh.org/gpl/finder.sql

Off topic projects

Sometime I'm not "working" on PostgreSQL related stuff:

• ClusterSSH emacs implementation
• tsung-plotter which is now included into Tsung itself, see SVN

Conferences

• I've been a speaker at European_PGDay_2008 in Prato, Italie (3 conferences)

TODO

Ideas for contributing to PostgreSQL include:

• Extension Manager as previously seen in
  • http://archives.postgresql.org/pgsql-hackers/2008-11/msg01667.php
  • http://archives.postgresql.org/pgsql-hackers/2008-07/msg01098.php
  • the Extension Manager page found on this wiki reflects other user ideas, to take into account into some kind of design
  • so let's prepare an ExtensionPackaging wiki page where to discuss
• Write a Tsung HowTo with nice graphics etc
• Implement an escape sequence for COPY to support DEFAULT values, \D

Other projects:

• Add ideas given at Prato to pgloader TODO list
  • support more than one database as target
  • implement some kind of map/reduce for column transformation load spreading

Ideas

Other less realistic ideas, just to keep track of them somewhere:

• Multiple backends per query and pgbouncer integration into -core
• COPY support into FROM clause (has been discussed in -hackers)
• LATERAL support
• Distributing PostgreSQL with remote tablespace as the central point