Matthew J. Clemente

A couple of weeks ago I put together a CFMl wrapper for the Claude API and blogged about it.

I haven't had much of a chance to play with (or actually utilize) Claude Code, so I thought putting together a CFML wrapper for the Claude API would be a good jumping off point.

While digging into some potential memory issues in a Lucee container, I found myself needing to analyze a JVM heap dump.

I recently learned about the function arraySet.

On more than one occasion I've wanted to quickly check the size of a database.

While there may be times you need a full-featured Slack integration, just being able to send messages to a channel can be a win for many applications.

In ColdFusion applications, I tend to use the AntiSamy Java library to sanitize user-supplied input.

I'll begin by saying that a substantial portion of this post is deeply indebted to Tony Junkes, who has blogged quite a bit about using ColdBox modules with FW/1.

As a quick follow-up to my last post about storing database credentials in AWS Secrets Manager, I wanted to walk through retrieving them using CFML, so you can actually use them in your application.

Today I learned that AWS Secrets Manager enables you to store the login credentials and connection information for a database in a single secret.

This should be a short post, on a pair of complimentary functions that I just learned: objectSave and objectLoad.

Just a small note here, for my own reference, and also to get myself back into the habit of blogging.

Thanks to my ignorance, PostgreSQL is an ongoing source of TILs.

File this under interesting SQL features that I just learned - you can GROUP BY and/or ORDER BY the numeric column position in your SELECT statement, rather than writing out the full column identifier.

This post touches on two subjects - the first involves reading a range of lines from a file in ColdFusion - and the second is a question: if you have a useful CFML function, where can you share it?

For reasons irrelevant to this post, I wanted to run a query directly via the PostgreSQL JDBC Driver, bypassing cfquery.

A quick note on a very convenient PostgreSQL function that I learned today - GREATEST - which can be used when you want a database column updated only if the incoming value is greater (more recent) than the existing value in the column.

Despite 10+ years of CFML programming, I'm still stumbling across new functions.

Two days before Thanksgiving, I decided to put together a simple way for our family to share pictures, because we couldn't be together in person.

The applications I've built up to this point haven't needed to account for time zones (and for that I consider myself fairly fortunate), which is probably one of the reasons that I only just discovered that ColdFusion's date/time functions can accept a ti…

Recently, I set up a demo Github account.

During a recent live-coding session, I tried to build a website uptime monitor with Pipedream.

My shell startup has felt laggy for a while, but never quite slow enough that I felt compelled to track down the cause.

Arrow functions have been around in CFML since Lucee 5 and Adobe ColdFusion 2018 (Update 5), respectively.

We recently ran into a puzzling issue with cfhttp and CommandBox 5.

Building on my previous post, which covered writing a basic custom command for the CommandBox CLI, I put together another video, detailing how to pass parameters to your command.

I posted a video, walking through the process of building your first CommandBox custom command.

I'm not a database guru or SQL sherpa, but from time to time I do fill the role of de facto DBA.

Hindsight being 20/20 makes the lesson of this post appear comically obvious, but as the underlying issue took a while to track down, I thought it worth documenting.

One of the appeals of open source software is that anyone can contribute.

Well, the title feels a bit like word soup, but I think it's accurate.

Just a quick note about generating XLSX (Excel) files with ColdFusion, which basically amounts to me regurgitating the documentation.

I had the opportunity to present two sessions at this year's Adobe ColdFusion Summit in Las Vegas - the first on Docker Swarm, the second on CFML API wrappers.

Addition, subtraction, multiplication, and division.

Okay, so this is slightly embarrassing, in that I'm writing about a "feature" that was added in ColdFusion 8... so, over 11 years ago.

One of my goals for the coming months is to improve my proficiency with Java; that is, to put some real knowledge behind my current patchwork understanding, pieced together over the years via trial-and-error.

Many thanks to the (growing) team at Ortus Solutions for their tremendous work with this year's Into the Box conference.

My goal here was to put together a script for easily setting up a Swarm on DigitalOcean.

Months ago I ambitiously began a series of posts about setting up and deploying a production Docker Swarm.

I blogged, in two earlier posts, about installing and deploying FusionReactor Cloud to monitor CFML applications on Docker Swarm.

Following my previous post about setting up FusionReactor on Docker Swarm, we encountered an issue with deployments failing to report.

Moving a standard ColdFusion installation to Docker Swarm requires rethinking - and frequently rewiring - portions of our infrastructure.

It's not difficult to use ColdFusion spreadsheet functions (e.g. spreadsheetNew() and cfspreadsheet) in Lucee.

This will be old news - very old news - for some people.

I was very fortunate to attend my second Adobe ColdFusion Summit this year.

One of the issues you need to tackle when deploying Lucee containers is automating the installation of server extensions; there are a few methods, each with its own tradeoffs.

This post started as an investigation of how best to extract text from a PDF; it then turned into an exploration of PDFBox, lead me down the rabbit hole of PDF sanitization, and ultimately resulted in developing pdfbox.cfc.

This is the first post in a series about setting up and deploying Docker Swarm for production.

I haven't had a lot of time to blog recently.

Ok, the title isn't entirely accurate.