Category Archives: SQL

Continuous Floatation in Wineries

There are two common methods to clarify juice before it goes into fermentation. Firstly there is cold-settling, where you just leave the juice alone for several days and wait for the clear juice and lees (the juice particulates) to separate. … Continue reading

Posted in boz, Boz NZ, Bulls-i, C Programming, Indevin, MRP, Pascal Programming, Process Automation, Programming, SCADA, SQL, Uncategorized | Tagged , , , , , , , , , , | Comments Off on Continuous Floatation in Wineries

On-Time and Under-Budget. Where some IT projects are Probably Going Wrong.

This will be a short post, and not technical like my usual ones, it is about many of the seemingly hundreds of failed IT projects out there, where companies have been let down by the big IT companies and consultants. … Continue reading

Posted in boz, Boz NZ, C Programming, Electronics, ESP32-C3, IT Failures, LoRa, Motor Controllers, MySQL, New Zealand, NZ, Other Programming, Pascal Programming, Project Management | Tagged , , , , , , , , , , , | Comments Off on On-Time and Under-Budget. Where some IT projects are Probably Going Wrong.

2025, My Final Vintage and Open For New Business

Fran, Allison and Me by the Wineries Continuous Floatation System March 2025 I developed the original Bulls-i winery management program for Indevin Ltd back in 2008 when they were just a small winery based in a single site in Blenheim, … Continue reading

Posted in Boz NZ, Bulls-i, C Programming, Electronics, Indevin, MRP, MySQL, New Zealand, NZ, Other Programming, Pascal Programming, Programming, Project Management, SQL, Villa Maria | Tagged , , , , , , , , , , , | Comments Off on 2025, My Final Vintage and Open For New Business

Adding a Message Of the Day or Quote of the Day to your system

Got handed a nice SQL file a few years back, one which I slip into most of my applications and one that generates quotes of the day, (or Message of the day – MOTD) there are 1462 records or about … Continue reading

Posted in FOSS, Funny, MySQL, Uncategorized | Comments Off on Adding a Message Of the Day or Quote of the Day to your system