MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 nano) Apply It source ~/.zshrc Test It whisper --help Run the whisper on the original MP3: whisper output_audio.mp3 --model small Error(s): PATH breaks, no commands work: echo 'export...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• Language: *

Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 counter_field_value= WHERE column1='this_article' Combined with a PHP script this could be a few lines for something really small. The quick trick to this is to do it all in one query: UPDATE table1 SET counter_field_value=counter_field_value+1 WHERE...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

AutoHotkey Ternary Operatorhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 in AutoHotkey. A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the statement: If...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Php convert filesizes to bytes kb mb gbhttps://www.joellipman.com/articles/web-development/php/php-convert-filesizes-to-bytes-kb-mb-gb.html

03 January 2013 Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Free Translator API using Googlehttps://www.joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 (2 million) every month. Microsoft's Bing has added itself to the fray pretending to offer free services but in the small print, you will find they too charge the same price. How? The Google Translate API still actually exists. Just don't try to exceed...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Android Background Image Resolutionshttps://www.joellipman.com/articles/google/androidos/android-background-image-resolutions.html

01 December 2014 to for various screen sizes. Why? A background image I was using was unedited at 1600x2133 (364kb) and was not displaying on smaller devices. Configuring drawables for each layout seemed to be the only solution. res/drawable-ldpi 240x320...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 display on the first page, the product line items would then print on the second page, with the terms and conditions or small print notes on a third page. How? Printing to PDF or saving as a PDF lets me preview the page breaks based on the paper size I...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB