Query a PostgreSQL database via Python
Posted 11th December 2020
No comments
Use this simple template script created in Python to connect to your PostgreSQL database and run a query.
SQL to CSV via Python, with Headers
Posted 7th June 2019
1 comment
Nifty Python code that converts a SQL database file into a CSV file and includes column headers.
Create a non-superuser role in PostgreSQL
Posted 18th April 2018
No comments
Use this easy procedure to establish a non-superuser role in PostgreSQL.
Migrate a local LemnaTec database
Posted 8th June 2016
No comments
A step-by-step guide for migrating a local LemnaTec database between network drives.
Easily update WordPress with cPanel 11 and phpMyAdmin
Posted 30th September 2011
2 comments
A simplified method for updating your WordPress website using the latest tools in cPanel 11.