My Python Setup

The Python programming language is, I think, a fantastic tool. But there is two fucking thing that really makes me sad: packaging and dependency management. Today, my Linux distribution, Arch, decide that it was OK to migrate python 3.8. And it broke tons of shit on my machine. So I took a moment to re-install and harden stuff so that it doesn’t happen again. Pyenv To Have Multiple Version I use Pyenv with the plugin to handle virtualenv....

November 18, 2019 · 2 min · 228 words · Rémi Desgrange

Why You Should Use Timestamptz

I see a lot project using timestamp data type in there databases. I tend to think that this is a bad idea. Dev Is Not Prod Your local setup may have a timezone which reflect your physical location. This may not be the case of your server(s), which could have a specific timezone, or, UTC time. Which is better by the way (more on than later). So you will experience bug and issues if you do not pay attention to it....

July 10, 2019 · 2 min · 332 words · Rémi Desgrange

Idea For A Multitenant PostgreSQL

I recently migrate a PostgreSQL DB from an ubuntu server VM to Azure PostgreSQL. If you use this DBaaS before, you may have noticed you need to add @<my_instance_name> after your login. For exemple if you create a test_azure_db, your url for this PostgreSQL instance is test_azure_db.postgres.database.azure.com. And imagine the name of your user is remi, to login you need to do psql -h test_azure_db.postgres.database.azure.com -U remi@test_azure. I don’t know what sort of magic Azure is doing, but it gave me an idea....

June 7, 2019 · 5 min · 1049 words · Rémi Desgrange

Right Management in Postgresql

Recently I though about (re)starting a blog, but didn’t find subject to fill it. Then I got a new job with tons of news subject to learn and I need a place to store it, maybe it will help some. Enjoy. Right Management in Postgresql @Fibrea we use postgresql a lot, it’s the heart of our system. Operating this DB day to day is quite challenging some time. So here is what I understand from my experience and reading on right management in postgresql....

November 28, 2017 · 4 min · 694 words · Rémi Desgrange