django-extensions – display sql query in shell_plus
Small Django tip of the day. I use django-extensions as dev dependencies of all my project. Among the useful command, I use shell_plus which colorify …
Category: Code
Why I migrate from Leaflet to MapLibre
On the project quefairedemesdechets.fr we recently migrate from Leaflet to MapLibre. Here I try to explain why and how. Performance MapLibre has better performances, this …
PostgreSQL tips
Here are some tips to manipulate or inspect postgresql To know the size of your table # SELECT relname as table_name, pg_size_pretty(pg_total_relation_size(relid)) as total_size, pg_size_pretty(pg_relation_size(relid)) …
Code / PostgreSQL / Python
Convert a UUID in base57 with PostgreSQL (like Shortuuid)
I was implementing DBT in one of my project and I needed to keep the same behavior than shortuuid python package. Shortuuid is basically encode …
PostgreSQL doesn’t know how to do division
Recently, I experienced that PostgreSQL is wrong while divided big numbers. I was converting uuid to base57, to do it I need to convert uuid …
GIT Blame in VSCode
Here is a very simple extension to add to your VSCode IDE : Git Blame. It shows you the last person who updated the line …
Manage MAX_ID and auto_increment value
In some strange cases, I experienced a lost of synchronization between the auto-increment id and the and the sequence which manage the auto-increment. Here is …
Code / Deploiment / Django / Python
Generate PDF using python, docx templating and libreoffice deployed on Scalingo
What I need to achieve ? For one of my client project, I need to produce legal documents (named CERFA) filled with information entered by …
Inspect postgresql ongoing queries and kill it
To check the ongoing query And kill the one is blocked
Navigate with panel using tailwind classes
On «Longue vie aux objets» project, I had to create a new way to navigate in the application. However, I didn’t want to introduce to …