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

Check size of PostgreSQL databases

2025-10-26
Minimal Examples

A minimal example on how to check size of all databases in a PostgreSQL server.

Log message with QGIS Python script

2025-10-26
Minimal Examples

A minimal example on how to add a message to Log Messages panel in a QGIS Python script.

Run PostgreSQL function from Windows commandline

2025-10-25
Minimal Examples

A minimal example on how to run a PostgreSQL function from Windows commandline using psql.

Add created and edited user and date in PostgreSQL

2025-10-24
Minimal Examples

A minimal example on how to add attributes in PostgreSQL table with autofilling created user and date and last edited user and date.

Get QGIS version in Python script

2025-10-20
Minimal Examples

A minimal example on how to get QGIS version number and name in a QGIS Python script.

Update QGIS window title with Python

2025-07-11
Minimal Examples

A minimal example for a script that edits the title bar of the QGIS app window on application launch by adding a QGIS version number to it.

Archive deleted PostgreSQL rows by copying them to another table

2025-07-10 (Last Modified: 2025-10-26)
Minimal Examples

A minimal example for PostgreSQL on how to copy database rows into another table when they are deleted in the original table.

Set up Rust on Windows

2025-03-21
Quick Tips

A quick tip on how to set up a Rust programming environment on Windows.

Automate PostgreSQL database backup

2025-03-07
Minimal Examples

A minimal example on how to use pg_dump in a .bat script to automate PostgreSQL database backups on Windows operating system.

Cast point geometry from 2D to 3D

2025-03-06
Minimal Examples

A minimal example on how to use SQL in PostGIS to cast table’s point geometry between Z- and/or M-enabled points.

1/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.