Skip to content

Tech I learned

Each week, I share a technical trick that I learned

  • Home
  • Code
  • Home
  • Code

Category: Code

Code / PostgreSQL

PostgreSQL tips

07/05/202507/05/2025

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 …

Convert a UUID in base57 with PostgreSQL (like Shortuuid)
Code / PostgreSQL / Python

Convert a UUID in base57 with PostgreSQL (like Shortuuid)

22/03/2025

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
Code

PostgreSQL doesn’t know how to do division

22/03/202522/03/2025

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
Code / Git/Github

GIT Blame in VSCode

30/01/2025

Here is a very simple extension to add to your VSCode IDE : Git Blame. It shows you the last person who updated the line …

Code

Manage MAX_ID and auto_increment value

02/12/2024

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 …

Generate PDF using python, docx templating and libreoffice deployed on Scalingo
Code / Deploiment / Django / Python

Generate PDF using python, docx templating and libreoffice deployed on Scalingo

24/08/202424/08/2024

What I need to achieve ? For one of my client project, I need to produce legal documents (named CERFA) filled with information entered by …

Code

Inspect postgresql ongoing queries and kill it

24/08/2024

To check the ongoing query And kill the one is blocked

Code / Tailwind

Navigate with panel using tailwind classes

09/02/202409/02/2024

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
Code / Django

Search in a BoundingBox with GeoDjango

03/01/202403/01/2024

My need was to search in a limited square area. Actually it was a little bit more tricky, I implemented a « Search in this …

Code / Django

Django tips, order randomly

18/10/202327/01/2024

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

Posts navigation

1 2 3 Next

Recent Posts

  • PostgreSQL tips
  • Convert a UUID in base57 with PostgreSQL (like Shortuuid)
  • PostgreSQL doesn’t know how to do division
  • GIT Blame in VSCode
  • Manage MAX_ID and auto_increment value

Categories

  • Code
  • Deploiment
  • Django
  • Flutter
  • Générale
  • Git/Github
  • Management
  • PostgreSQL
  • Python
  • Security
  • Tailwind
Copyright © 2025 Tech I learned. Powered by WordPress and Bam.