AGNIESZKA.DEV
 Python ★ GIS ★ Linux  
  • About me
  • Blog
  • Links
  • Projects

Block crawlers with UFW

2023-12-13
Quick Tips

A quick tip on how to use UFW to block all IP adresses used by Google and by AI-related crawlers.

SQLAlchemy minimal setup for SQLite

2023-07-22
Minimal Examples

A minimal example for managing an SQLite database with Python via SQLAlchemy library. Includes a definition of a relationship between tables for the purpose of implementing a dictionary.

Python script as a Windows service

2023-07-15
Quick Tips

A quick tip on how to make a Python script run automatically as a Windows service.

« 3/3

Recent Posts

  • Check size of PostgreSQL databases
  • Log message with QGIS Python script
  • Run PostgreSQL function from Windows commandline
  • Add created and edited user and date in PostgreSQL
  • Get QGIS version in Python script
  • Update QGIS window title with Python
  • Archive deleted PostgreSQL rows by copying them to another table
  • Set up Rust on Windows
  • Automate PostgreSQL database backup
  • Cast point geometry from 2D to 3D

Categories

  • Minimal Examples
  • Quick Tips

Tags

arcade arcgis enterprise arcgis online arcgis pro automation backup bat caddy cgi cmd conda cron-apt crontab curl debian geopandas gmail go jupyter jupyterlab desktop monitoring ntfy pg_dump postgis postgresql privacy psql pyqgis python qgis rust sde self-hosting shiori sql sqlalchemy sqlite ssmtp ufw vps wfs windows xcaddy
© 2025 Agnieszka. Generated with Hugo and Mainroad theme.