libfq 0.4.2 has been released with following changes:
- output of FQexplainStatement() fixed
This is a maintenance release which does not introduce any new features.
Source code is available at the libfq GitHub page.
RPM packages are available via the libfq copr repository.
Online libfq documentation is available here: https://libfq.sql-info.de/.
The long-awaited Firebird 4 release is drawing closer, so I thought it would be a nice idea to check it out and verify that it works with firebird_fdw (and possibly add support for new features). As part of that I thought I'd try and build Firebird from source, something I've never done before. The aim is to be able to build and start an ad-hoc instance running under my local system user on a custom port, to prevent any kind ofconflict with the existing Firebird 3.x installation, installed from standard packages.
With PostgreSQL this is fairly straightforward:
./configure --prefix=/home/wherever/builds/postgresql-13 make -s -j 4 && make install
With Firebird the process is somewhat less straightforward. The basic source installation process is documented here:
but this assumes an install on a system where another Firebird version is not already installed and running.
In particular, the normal "
./configure && make install" process will end up launching an interactive install script, which refuses to run if it detects a running Firebird instance, and requires root permission to perform the install.
After some false starts and some assistance from the firebird-devel list I was able to get a purely local install running, with the following steps:
After upgrading to OX X 10.11 "El Capitan", attempting to connect to Firebird - which had always started on boot - failed with the message:
Statement failed, SQLSTATE = 08006 Unable to complete network request to host "localhost". -Failed to establish a connection.
This is evidently to do with OS X StartupItems being deprecated for starting daemons; this blog provides a solution.
Let's assume you have a CSV file which looks like this:
$ head -5 /tmp/prod.csv 1,14,ACADEMY ACADEMY,PENELOPE GUINESS,25.99,0,1976 2,6,ACADEMY ACE,EWAN RICKMAN,20.99,0,6289 3,6,ACADEMY ADAPTATION,VIVIEN KAHN,28.99,0,7173 4,3,ACADEMY AFFAIR,ALAN MARX,14.99,0,8042 5,3,ACADEMY AFRICAN,CARRIE HANNAH,11.99,1,2183
Well I've finally fulfilled one of my 2013 New Year's resolutions, which was to write some kind of foreign data wrapper, so with no further ado here is the initial implementation. It is basically working but is still very much in the proof-of-concept/unstable/may-eat-your-data stage. Having said that, if anyone has a practical use for this I'd be very interested to hear about it - my main motivation for creating this FDW is to learn more about PostgreSQL internals.