Setting up and using PostgREST

Notes on general unix tools and shell scripting

Excel VBA code

Data matters

English Premier League data analysis in DuckDB

Code for DuckDB book

All mt Python Tkinter code

Tk examples - Perl & Python

Data for use in GAS Book

General utility functions for Excel and Google Sheets

Create HTML tables from Sheets with formatting preserved

PostgreSQL version of DB for book "SQL Practice Problems" by Sylvia Moestl Vasilik

Google Sheets GAS comaprisons with Excel VBA

Notes and code snippets on databases, SQL and general database programming

Shiny Apps with PostgreSQL back-end.

Shows how to define PL/pgSQL stored procedures and call them from R client code.

my postgresql blog

VBA classes written for use in Excel to interact with SQLite

Contains all code examples given in the 2015 version of my Leanpub book "Google Spreadsheet Programming". Each chapter is given its own GAS file (.gs).

JavaScript and Google App Script code

GAS code to convert values in a spreadsheet to SQL statements. Header row is used to for the "CREATE TABLE" statement, data rows are used to create "INSERT" statements. Cangenerate SQLite, MySQL an…

Contains GAS and HTML that shows how to use a spreadsheet named range to dynamically populate a Html Service dropdown list. See blog entry: