PostgreSQL
Sustainable Open Source Development
Current trend in software deployments is to rely on open source software for entire production stacks. You can find open source software in the core technical stacks of …
tag
Pgloader
30 posts
PostgreSQL
Migrating to PostgreSQL, the White Paper
After having been involved in many migration projects over the last 10 years, I decided to publish the following White Paper in order to share my learnings. The paper is …
PostgreSQL
from MySQL to PostgreSQL
Today pgloader v3.4.1 is released and available! This new release comes with 110 commits as show in github compare view. This release of pgloader is following the …
Projects
Quicklisp and debian
Common Lisp users are very happy to use Quicklisp when it comes to downloading and maintaining dependencies between their own code and the librairies it is using.
Conferences
Back From FOSDEM 2015
The FOSDEM 2015 edition has been awesome this year, the usual mix of meeting with old friends, talking about interesting topics, seeing tremendous activity in all Open …
Projects
Why is pgloader so much faster?
pgloader loads data into PostgreSQL. The new version is stable enough nowadays that it’s soon to be released, the last piece of the 3.1.0 puzzle being full debian …
Projects
Import fixed width data with pgloader
A long time ago we talked about how to Import fixed width data with pgloader, following up on other stories still online at Postgres OnLine Journal and on David …
Projects
Migrating Sakila from MySQL to PostgreSQL
As presented at the PostgreSQL Conference Europe the new version of pgloader is now able to fully migrate a MySQL database, including discovering the schema, casting data …
Conferences
Back From Dublin
Last week I had the pleasure to present two talks at the awesome PostgreSQL Conference Europe. The first one was actually a tutorial about Writing & using Postgres …
Projects
A Worthwile Micro Optimisation
In our previous article about Loading Geolocation Data, we did load some data into PostgreSQL and saw the quite noticable impact of a user transformation. As it happens, …
Projects
Loading Geolocation Data
As I’ve been mentionning in the past already, I’m currently rewriting pgloader from scratch in Common Lisp. In terms of technical debt that’s akin to …
Projects
Migrating from MySQL to PostgreSQL
About the only time when I will accept to work with MySQL is when you need help to migrate away from it because you decided to move to PostgreSQL instead. And it’s …