Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

Python logo

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.

Read the full story...

Microsoft Access logo

Add a simple search box to a Microsoft Access form

Posted 12th November 2020

No comments

A step-by-step guide to adding a simple search box to a Microsoft Access form.

Read the full story...

PostgreSQL: Add columns to a query table with variables

Posted 3rd July 2020

No comments

Generate a new column in your PostgreSQL database query from data in other columns or other tables.

Read the full story...

Python logo

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.

Read the full story...

PostgreSQL: Store a PSQL COUNT query result as a Bash variable

Posted 5th June 2018

No comments

Use this nifty code to isolate the result of a PSQL COUNT query as a variable within a Bash script.

Read the full story...

Export a PostgreSQL query to a CSV

Posted 24th November 2017

2 comments

Export the contents of a database table to a CSV file using the psql PostgreSQL utility in PuTTY.

Read the full story...

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.

Read the full story...