“Managing” a SQLite Database with J (Part 2)

When faced with unfamiliar program code Roger Hui, the co-creator of the J Programming Language would sometimes wipe out all the code comments. He told me this forced him to concentrate on the actual code and not the opinions of previous developers. Roger was an exceptional programmer; he knew that program comments are often dated, … Continue reading “Managing” a SQLite Database with J (Part 2)

“Managing” a SQLite Database with J (Part 1)

Previously, I promised to write three posts about dispatching irritants with J. This, my third post, is proving more irritating than the others, so I will split it over two posts. SQLite, by many estimates, is the most widely deployed SQL database system on Earth. It's everywhere. It's in your phone, your laptop, your cameras, … Continue reading “Managing” a SQLite Database with J (Part 1)

JETL – J Extract Transform and Load

I have been surreptitiously using the J programming language on the job for many years. With rare exceptions, I haven't advertised my clandestine use of J simply because it's strange and scary and nonstandard, and IT departments are filled with cowardly little bedwetters that run away like Brave Sir Robin when confronted with something really … Continue reading JETL – J Extract Transform and Load

More J Pandoc Syntax HighLighting

Syntax highlighting is essential for blogging program code. Many blog hosts recognize this and provide tools for highlighting programming languages. WordPress.com (this host) has a nifty highlighting tool that handles dozens of mainstream programming languages. Unfortunately, one of my favorite programming languages, J, (yes it’s a single letter name), is way out of the mainstream … Continue reading More J Pandoc Syntax HighLighting

NumPy another Iverson Ghost

During my recent SmugMug API and Python adventures I was haunted by an Iverson ghost: NumPy An Iverson ghost is an embedding of APL like array programming features in nonAPL languages and tools. You would be surprised at how often Iverson ghosts appear. Whenever programmers are challenged with processing large numeric arrays they rediscover bits of … Continue reading NumPy another Iverson Ghost

SWAG a J/EXCEL/GIT Personal Cash Flow Forecasting Mob

While browsing in a favorite bookstore with my son, I spotted a display of horoscope themed Christmas tree ornaments. The ornaments were glass balls embossed with golden birth signs like Aquarius, Gemini, Cancer, et cetera, and a descriptive phrase that “summed up” the character of people born under a sign. Below my birth sign golden … Continue reading SWAG a J/EXCEL/GIT Personal Cash Flow Forecasting Mob