9. Some tips for django

   Sommaire

   • View last executed query
   • Migrations
   • Model proxies
   • Easily increment migrations numbers
   • Create a widget with custom display
   • Use a nginx reverse proxy in dev

   View last executed query

   Run (the query will be as executed by the database with values correctly replaced and escaped):

   from django.db import connection …

   read more

10. JavaScript tips

    Sommaire

    • Normalize an UTF-8 string

    Normalize an UTF-8 string

    Rely on String.prototype.normalize().

    const str = "Crème Brulée"
    str.normalize('NFD').replace(/[\u0300-\u036f]/g, "")
    > 'Creme Brulee'
    

    Source: https://stackoverflow.com/questions/990904/remove-accents-diacritics-in-a-string-in-javascript/37511463#37511463

    read more

11. PostgreSQL tips

    Sommaire

    • Update fields in JSONB format
    • CSV export/import
    • Update rows in bulks
    • Understand lock issues
    • Use variables in query

    Update fields in JSONB format

    Use the jsonb_set(COLUMN_NAME, PATH_TO_CHANGE, VALUE) function. The value must be a valid value in JSON (ie use '500' for numbers, 'true' for boolean and …

    read more

12. How to cache Python module in Gitlab CI

    By default, pip cache will be in ~/.pip. However, this folder cannot be cached by Gitlab. The trick is to force pip to use a folder located in the build directory with the --cache-dir option. You can then cache this folder.

    For instance, you can use .pip as in the …

    read more

13. nginx tips

    CORS for multiple domains

    location ~* \.(?:ttf|ttc|otf|eot|woff|woff2)$ {
        if ( $http_origin ~* (https?://(.+\.)?(domain1|domain2|domain3)\.(?:me|co|com)$) ) {
            add_header "Access-Control-Allow-Origin" "$http_origin";
        }
    }
    

    Source: https://stackoverflow.com/a/27879729/3900519

    read more

14. Chiffrer des fichiers avec GPG

    Voici deux fonctions bash qui permettent de chiffrer et déchiffrer un fichier ou un dossier avec GPG.

    Les dossiers sont compressés dans une archive ZIP avant le chiffrement.

    Le chiffrement laisse les fichiers d'origine intacts. Le déchiffrement laisse le fichier chiffré intact.

    Ces fonctions auront leur place dans votre .bashrc …

    read more

15. Extraire le HTML d'un email au format mbox

    Voici un petit script Python pour convertir un mail au format mbox en HTML. Pour que le script fonctionne, il faut soit que le corps du message soit du HTML (recommandé) soit que la première pièce jointe du message contienne le message en HTML.

    Par défaut, le script traitera tous …

    read more

16. Docker compose tips

    For my tips about docker, go here.

    Sommaire

    • Use docker-compose.override.yml

    Use docker-compose.override.yml

    As describe here, if you create a docker-compose.override.yml next to your docker-compose.yml, you can override or add values to the docker file. This file is loaded by default. To ignore it …

    read more

17. Create python virtual enviroments on Windows

    1. Before creating the venv you will need to open a PowerShell terminal as root and run the commands below to allow the script that activates the virtual env to run:

       cd ..
       Set-ExecutionPolicy Unrestricted
       

    2. Create the venv. Run in a terminal as a normal user: python3 -m venv .venv If the …

    read more

18. Use squid and squidGuard to redirect all URLs from a domain to another one

    Sommaire

    • Configure squid
    • Configure squidGuard
    • Activate squid

    You may find yourself in a situation where you will need to redirect all URLs from a domain (lets say www.example.com) to another one (lets say www.example.org). This can be done with squid, a proxy server, and squidGuard, an …

    read more

« Page 2 / 6 »