“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

Running SSIS Packages with Python

Microsoft's SSIS (SQL Server Integration Services) is a ubiquitous ETL (Extract Transform and Load) tool. Despite its widespread use, SSIS is not loved! At best, it's tolerated for its undeniable utility, but SSIS's “utility” comes with a host of hideous warts with the ugliest being its file handling. You would think that an ETL tool … Continue reading Running SSIS Packages with Python

Tweaking Jupyter export HTML with Templates

In a previous post, I outlined some handy hacks for converting Jupyter notebooks to WordPress.com oriented HTML. This addendum describes the use of Jupyter templates and CSS edits to fine-tune exported HTML. Jupyter exports notebooks in a variety of formats. I regularly export notebooks as Markdown, HTML, and $latex \LaTeX$. When blogging I mainly use … Continue reading Tweaking Jupyter export HTML with Templates

Better Blogging with Jupyter Notebooks on WordPress.com

When I discovered Jupyter notebooks a few years ago I instantly recognized their potential as a technical blogging tool. Jupyter notebooks support mixtures of text, mathematics, program code, and graphics in a completely interactive environment. It's easy to convert notebook JSON .ipynb files to markdown, $latex \LaTeX$, and HTML so it's not a big leap … Continue reading Better Blogging with Jupyter Notebooks on WordPress.com