---
title: Blog
url: 'https://www.trancart.eu/en/blog'
markdown: 'https://www.trancart.eu/en/blog.md'
lang: en
date: '2021-06-18'
---

1st May 2025  

##### [Nix + python = 💖 ?](https://www.trancart.eu/en/blog/20250428-nix-and-python-equals-heart)

Well, it seems that quite a lot of people struggle with python on NixOS! Actually, I don't think it's that difficult so let's dive in! This post is meant to be a definitive guide to python usage in NixOs. By usage, I mainly mean 2 things:

- make any python application work, whether it is a cli too...

    8th Sep 2021  

##### [Rendez-vous With Cassidoo #211: longuest prefix, in sql](https://www.trancart.eu/en/blog/rendez-vous-with-cassidoo-211-longuest-prefix-in-sql)

I've skipped quite a lot of Cassidoo's question of the week this summer, but let's get back to it, in SQL of course!

# The question

> This week’s question: **Write a function to find the longest common prefix string in an array of strings.**
> 
> Example:
> 
> ```
> $ longestPrefix(["cranberry","crawfish","crap"...
> ```

  [cassidoo](https://www.trancart.eu/en/blog/tag:cassidoo#body-wrapper) [sql](https://www.trancart.eu/en/blog/tag:sql#body-wrapper) [puzzle](https://www.trancart.eu/en/blog/tag:puzzle#body-wrapper)  

 [![](https://www.trancart.eu/images/7/a/3/3/6/7a3369a0e46c0832cdcf079e9b8993e3467ee691-pexels-rostislav-uzunov-5011647.jpg)](https://www.trancart.eu/en/blog/20210621-rendezvous-cassidoo-201) 

    23rd Jun 2021  

##### [RDV with Cassidoo #201 : Cubes!](https://www.trancart.eu/en/blog/20210621-rendezvous-cassidoo-201)

I feel like I'm gonna like this serie a lot :-) It's so much fun!

Let's dive right in!

### The interview question

> Write a function that draws an ASCII art cube of given height x.

Example:

```
$ drawCube(2)
  +----+
 /    /|
+----+ |
|    | +
|    |/
+----+

$ drawCube(4)

   +--------+
  /...
```

  [sql](https://www.trancart.eu/en/blog/tag:sql#body-wrapper) [puzzle](https://www.trancart.eu/en/blog/tag:puzzle#body-wrapper) [cassidoo](https://www.trancart.eu/en/blog/tag:cassidoo#body-wrapper)  

 [![](https://www.trancart.eu/images/9/7/5/d/8/975d815f94ae9c36bd8dfa5ad9de4c72ed777e9f-arrow.jpg)](https://www.trancart.eu/en/blog/20210618-rendezvous-cassidoo-200) 

    18th Jun 2021  

##### [Rendez-vous with cassidoo #200, interview question of the week](https://www.trancart.eu/en/blog/20210618-rendezvous-cassidoo-200)

I've recently discovered [Cassidy's newsletter](https://cassidoo.co/newsletter/), more precisely [this one](https://buttondown.email/cassidoo/archive/there-will-always-be-enemies-time-to-stop-being/) and really liked it:

- it's short
- it's fun
- and there is a fun interview question

I admit I haven't read the linked articles :-)

## This week’s question:

> Given a direction and a number of columns, write a function...

  [cassidoo](https://www.trancart.eu/en/blog/tag:cassidoo#body-wrapper) [sql](https://www.trancart.eu/en/blog/tag:sql#body-wrapper) [puzzle](https://www.trancart.eu/en/blog/tag:puzzle#body-wrapper)  

 [![](https://www.trancart.eu/images/1/5/b/9/8/15b98ef6e61a4bc02dc3413eba93433b38f732ee-pexels-kindel-media-8326329.jpg)](https://www.trancart.eu/en/blog/20211806-flask-werkzeug) 

    18th Jun 2021  

##### [Werkzeug needs to be pinned on old version of flask (<= 0.12)](https://www.trancart.eu/en/blog/20211806-flask-werkzeug)

I have encountered this issue several times already, including one time where I was called by a *former* customer. Enough of this, let's document this:

## The issue: an old flask (<= 0.12) suddenly stopped working

This flask app was working fine for some time already. Maybe you tried to update some...

  [python](https://www.trancart.eu/en/blog/tag:python#body-wrapper) [pip](https://www.trancart.eu/en/blog/tag:pip#body-wrapper) [sysadmin](https://www.trancart.eu/en/blog/tag:sysadmin#body-wrapper)  

#### Syndicate

 [ Atom 1.0](https://www.trancart.eu/en/blog.atom) [ RSS](https://www.trancart.eu/en/blog.rss)

---

## Navigation

- Previous: [Home](https://www.trancart.eu/en/index.md)
- Children:
  - [Rendez-vous With Cassidoo #211: longuest prefix, in sql](https://www.trancart.eu/en/blog/rendez-vous-with-cassidoo-211-longuest-prefix-in-sql.md)
  - [RDV with Cassidoo #201 : Cubes!](https://www.trancart.eu/en/blog/20210621-rendezvous-cassidoo-201.md)
  - [Rendez-vous with cassidoo #200, interview question of the week](https://www.trancart.eu/en/blog/20210618-rendezvous-cassidoo-200.md)
  - [Werkzeug needs to be pinned on old version of flask (<= 0.12)](https://www.trancart.eu/en/blog/20211806-flask-werkzeug.md)
  - [Nix + python = 💖 ?](https://www.trancart.eu/en/blog/20250428-nix-and-python-equals-heart.md)