PostgreSQL tips
Here are some tips to manipulate or inspect postgresql To know the size of your table And for a specific schema, just add the condition …
Category: Code
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 …
Search in a BoundingBox with GeoDjango
My need was to search in a limited square area. Actually it was a little bit more tricky, I implemented a « Search in this …
Django tips, order randomly
Using Django Queryset, to get a random order by, just use the ? parameter Django doc : https://docs.djangoproject.com/en/dev/ref/models/querysets/#django.db.models.query.QuerySet.order_by