Notes on Migrating from MS SQL Server to PostgreSQL

I’m not a database guru or SQL sherpa, but from time to time I do fill the role of de facto DBA. The following are some notes and observations from a recent, successful, migration from Microsoft SQL Server to PostgreSQL. Is it everything you need to know? Absolutely not. But there are some points and resources that will hopefully be helpful.

Continue Reading

Sizing Your Redis Cache for Sessions - A Quick Lesson Learned

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. The embarrassing TLDR; is that you should make sure that your Redis cache is appropriately sized for your session data or you might end up with errors that are difficult to debug.

Continue Reading

Contributing to CommandBox - Steps for Building and Developing Locally

One of the appeals of open source software is that anyone can contribute. When you encounter a problem with an open source project, beyond simply reporting the bug, you have the means of resolving it - anyone can send a PR. Having recently gone through this process with CommandBox, I thought it might be helpful to share the steps for contributing.

Continue Reading

Using Redis with Lucee: An Approach with the CommandBox Docker Image and Ortus Redis Extension

Well, the title feels a bit like word soup, but I think it’s accurate. When I got started with Lucee, containers, and external cache providers, I blogged about using Memcached. At work, we’ve since shifted our stack, and now primarily use Redis for caching.

Continue Reading

TIL: Generating .xlsx Files with CFML - An Easy Way to Reduce File Size

Just a quick note about generating XLSX (Excel) files with ColdFusion, which basically amounts to me regurgitating the documentation. It’s a small change in code, but the reduction in spreadsheet file size can be considerable.

Continue Reading