What is verifiable
References
Public work can be checked without asking me. Contract work is under confidentiality — references are given during the conversation.
A reference sheet can be manufactured. A commit in the PostgreSQL core cannot. So this page leads with what you can verify yourself, without writing to me.
PostgreSQL core
Two core features
I contributed
CREATE EXTENSIONand Event Triggers to PostgreSQL core. That code has been running in every PostgreSQL installation, everywhere, since versions 9.1 and 9.3.tools
Three tools in production
pgloader is the de facto standard for migrating to PostgreSQL. pgcopydb and pg_auto_failover run for teams who have never had to talk to me. The code, the issues and the discussions are all public.
migrations
Migrations actually delivered
pgloader migrates whole databases from MySQL, SQLite and MS SQL Server. The quotes below are from its users, published on pgloader.io.
written
The Art of PostgreSQL
52 chapters on writing SQL for developers, and twenty years of technical writing on tapoueh.org. It is the Onsite material, and you can judge it before buying anything.
What users say
We were able to migrate our main database from MySQL to Postgres, moving hundreds of tables used by our complex Django project. Dimitri implemented a new feature for us quickly and smoothly.
— Andrea Crotti, Iwoca
Fusionbox used pgloader on a project for a large government agency. We needed to migrate a large set of data from an existing SQL Server cluster to a new PostgreSQL solution. pgloader greatly reduced the time required to accomplish this complex migration.
It made our migration from MySQL to PostgreSQL really easy (~1Tb) — almost too easy: I just ran the one-liner and waited for 48 hours. Nothing to change in the app, thanks to Hibernate.
As published in pgloader’s 2018 white paper, or in the case of CommaFeed, in their own tweet.
migration · Redpill Linpro
- Situation
- One of Redpill Linpro's customers asked them for the most efficient way to migrate from Microsoft SQL Server to PostgreSQL.
- Diagnosis
- No pgloader source connector covered MS SQL Server at the time — the customer's fastest path didn't exist yet.
- Outcome
- Redpill Linpro sponsored the connector. It shipped as open source, so it now benefits every pgloader user, not only the customer who first needed it.