pgRouting on (very) large graphs

Posted on March 23, 2023 in Dev • 4 min read

I recently performed routing and graph analysis on a very large graph built on top of some OpenData file. The underlying graph had about 40M edges, which is about the size of the road network mapped by OpenStreetMap in North America. Not that much, but still a bit tricky to handle.


Continue reading

Parallel GPG decryption

Posted on January 14, 2023 in Dev • 3 min read

I recently had to decrypt about 500k asymetrically GPG-encrypted strings and found out that it can take quite a lot of time while not being as straightforward as one might think to process in a concurrent manner to accelerate the computation time. Here is a quick work around for GPG parallel decryption.


Continue reading

Tp-Link Tapo C210 camera without internet

Posted on December 07, 2021 in Misc • 3 min read

It is quite challenging today to find a “security camera” (IP camera) which offers cloudless features, decent price and standard RTSP feeds. The only one I could come across is the Tp-Link Tapo C210 with this setup.


Continue reading

Audio / video quality of streaming services

Posted on February 14, 2021 in Misc • 2 min read

This is a quick reminder for myself about ways to check the audio / video quality of streaming services.


Continue reading

Android 10 without Google services (replacement with microg) on an LG G6 (H870)

Posted on November 22, 2020 in Smartphone • 4 min read

This article is a quick summary of the steps I used to get a working Lineage + microg setup on my European LG G6 (h870), acting as a reminder for me and hoping it can help others. I voluntarily give little details since I expect the reader to be already familiar with Android alternative ROMs and flashing them.


Continue reading