2024

08-25 Hetzner ARM Update Fix

2023

11-23 English-only embedding models for multilingual docs
11-18 A performant embedding processing pipeline & tutorial for big XML/HTML data dumps
10-22 Semantic Search Tutorial
05-06 Zulip Server Setup Tutorial: zulip.gis.chat
04-11 SemanticFinder - frontend-only live semantic search with transformers.js
04-04 Semantic Search with Qdrant, Hugging Face, SentenceTransformers and transformers.js
01-23 Geospatial Vector Search with Qdrant

2022

10-03 Pyscript File Handling
07-24 Connect Pandas to a remote PostgreSQL database via SSH
06-30 PyScript-fueled Jupyter Notebooks for your browser
05-03 PyScript - A Game Changer For Your Browser
04-24 HyperLogLog Simply Explained
03-28 Life Hacking 2.0: Adding Geographical Filters to Flat Search Websites with QGIS and Python
02-03 HDMI Remote Screen Control
01-21 City Skylines
01-18 Basic River Animations with Blender - Mosel Edition
01-04 How to create Paper (Mario) Maps

2021

12-13 Guide to 3D OSM Building Models - Milan Edition
12-11 Guide to 3D OSM City Models - Trier Edition
12-01 Raster-Based 3D Models with QGIS, OSM and Aerialod
11-07 Tips for neat splash pages
10-22 SSH Port Forwarding Guide
06-25 Convert Python Scripts to Windows Executables (.py to .exe) - Pyinstaller and Pandas | 2022 WORKING VERSION
04-13 An Introduction to HyperLogLog
02-18 Life Hacking: Adding Geographical Filters to Flat Search Websites with Turf.js
02-11 Using HyperLogLog with Leaflet-Hexbins
02-11 HyperLogLog Javascript (js-hll) & Postgres (postgres-hll): making them talk to each other!
02-10 Querying Postgres with Python Fastapi Backend and Leaflet-Geoman Frontend - Applying Geometry Filters
02-08 Leaflet Data Visualization Strategies - Markers, Marker Clusters, Heatmap, Hexbins
01-13 Hugo blog routine - write, preview, edit, commit
01-05 Run a Background Thread in Python - Torpy Image Download

2020

12-15 VM Port Forwarding
12-13 SSH in Virtual Machine Ubuntu Server 20.04
12-09 Requests in Python with requests package and Torpy
12-06 Using Jupyter Notebook as GIS
12-04 QGIS - How to use custom SVG-Markers
12-01 A complete guide to preprocess Instagram post data
11-22 Mining Instagram efficiently with Torpy - Fast Instagram Scraper
11-16 A quick readthedocs Wiki with mkdocs
11-15 Debugging Python
11-13 Writing Your Own Scraper - Simple Instagram Scraper
11-12 Deleting Browser Cache with Python Selenium and Chromedriver
11-04 Mining Instagram location IDs
05-30 Social Media Mining
05-30 Processing data mined from instagram-scraper with Python and Pandas
05-09 Creating a simple Windows Powershell shortcut
05-09 Creating a simple Ubuntu Bash shortcut
05-09 Most common Hugo pitfalls and their solutions
05-03 Go professional - Creating your personal homepage with custom domain name & email for less than 1$