Luca Ferrari
Open Source advocate, human being
pgenv get configuration!
I have already written about a very useful and powerful small pearl by theory: pgenv. Now the tool does support for user configuration!
Managing Multiple PostgreSQL Installations with pgenv
pgenv is a shell script that allows you to quickly manage multiple PostgreSQL installations within the same host. It reminds somehow perlbrew (for Perl 5) and systems like that. In this post I briefly show how to use pgenv as well as I explain which changes I made to it.
PostgreSQL negative PID
PostgreSQL uses a simple trick to recognize if the server has started in single-user mode.
An example of PostgreSQL rules: updating pg_settings
Rules are a powerful mechanism by which PostgreSQL allows a statement to be transformed into another. And PostgreSQL itself does use rules in order to make your life easier.
Is it me writing in Python?
I never wrote a row of Python, until…
Emacs Org-mode and the not exported caption problem
Org-mode is an amazing tool I use every day for pretty much a lot of stuff. In these day I’ve written technical documents in org, but due to a fault of mine, every code snippet was without the appropriate caption. It took me a while to find out what I was missing…
pgxnclient and beta version
pgxnclient is a wonderful cpan like tool for the PGXN extension network. Unlickily, the client cannot handle PostgreSQL beta version, so I submitted a really small patch to fix the issue.
PostgreSQL 11 and PL/Java: it can work!
PL/Java is a wonderful piece of code that allows the definition of functions in Java directly within PostgreSQL. Unluckily, PostgreSQL 11 introduced a few changes that made PL/Java not compiling. But keep calm, experts are already working on this!
PostgreSQL Extended Statistics
PostgreSQL 10 allows users to define extended statistics to help the planner understand data dependencies.
Sqitch and Sqitchers
Sqitch has nothing particular to do with PostgreSQL, except it does support our beloved database!