Database

Using an audit trail table on Oracle

Posted on Saturday, 5 October 2024

Embracing SQLite and living with micro-services

Posted on Saturday, 22 October 2022

Checking for liveness on databases for health checks

Posted on Tuesday, 14 July 2020

Docker controlled from Jupyter Notebook C# with PostgresDB

Posted on Tuesday, 12 November 2019

Testing SQLite in C# Jupyter notebook

Posted on Tuesday, 12 November 2019

Using bulk inserts on databases

Posted on Monday, 11 November 2019

Oracle Getting a list of all columns, data types, lengths of column for every table in your schema

Posted on Tuesday, 16 September 2014

Oracle - Reclaiming LOB space after deletion (CLOB, BLOB)

Posted on Monday, 3 February 2014

Oracle SQL Developer - Set NLS to give you full date and time

Posted on Friday, 31 January 2014

SqlFiddle - A way to share SQL snippets so that they can be tested in the browser

Posted on Tuesday, 5 November 2013

Oracle 10g - Pivoting data

Posted on Friday, 27 January 2012