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

Restrict PostgreSQL row edits by username

2025-03-04
Minimal Examples

A minimal example on how to limit row edits on a PostgreSQL table to a user matching a username value in one of the row’s columns.

Using CGI scripts in Caddy

2025-01-11
Quick Tips

A quick tip on how to compile and configure Caddy for the purpose of running CGI scripts.

Email about available updates with cron-apt

2024-10-10
Quick Tips

A quick tip on how to send an automatic email notification about available application updates on a Debian VPS.

Run Shiori locally on Windows

2024-06-19
Quick Tips

A quick tip on how to set up a local install of Shiori to automatically run on Windows startup.

Load and preview WFS data with Geopandas

2024-06-17 (Last Modified: 2024-06-20)
Minimal Examples

A minimal example for loading WFS data into a Geopandas dataframe and displaying its preview on a map.

Fill XY attributes from point feature geometry with Arcade

2024-06-16
Minimal Examples

A minimal example for updating XY attribute values in a geodatabase via an Arcade attribute rule.

Update attribute values in enterprise geodatabase with Python

2024-06-15
Minimal Examples

A minimal example for updating attribute values in an ESRI enterprise geodatabase via a Python script.

Conda Python env for JupyterLab Desktop

2024-04-23 (Last Modified: 2025-07-12)
Quick Tips

A quick tip on how to create a Python environment with Conda, and then use it in JupyterLab Desktop.

Daily server status notifications with Ntfy

2024-04-02
Quick Tips

A quick tip on how to send a daily notification through Ntfy with three basic server statistics: memory usage, disk usage, and CPU load.

Block crawlers with Caddy

2024-01-20
Quick Tips

A quick tip on how to block crawlers from accessing your website by rejecting requests containing their user agent tokens in Caddy.

« 2/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.