Other articles

1. JavaScript tips

   Contents

   • 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

2. PostgreSQL tips

   Contents

   • Update fields in JSONB format
   • CSV export/import

   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 '"str"' for strings). Examples:

   -- Set the postcode field to the 92600 …

   read more

3. 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

4. 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

5. 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

6. 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

7. Docker compose tips

   For my tips about docker, go here.

   Contents

   • 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

8. 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

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

   Contents

   • 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 1 / 5 »