Databases & Life

I have finally managed to get to the bottom of the "pop" problem on my Bowers and Wilkins ASW608 subwoofer.

You are reviewing a PR.

To set an “ordering key” on a message sent to Google Pub/Sub via Spring Boot using “Spring Integration”, you need to do the following:

The Spring PropertiesLoaderUtils.loadAllProperties method seems to have a bug where it returns entries from lower-priority classpath entries in preference to higher-priority classpath entries.

Git had a bug from version 2.33 onwards, fixed in 2.35.

If you are trying to get Debian 10 Buster to run in Vagrant and are receiving the following error default: /dev/vda does not exist, so cannot grub-install to it!

Links in web applications can be Relative links like <a href="/foo">, or Absolute links like <a href=“https://www.site.com/foo">.

Around 2003 I changed companies and accepted the title “Software Architect” at the new company.

Turning off a great server from Hetzner with over 1.5k days uptime (4.6 years).

To use XML Java DOM objects with PostgreSQL's XML datatype, do the following.

I hate when pressing the “backspace” key on the keyboard a certain number of times doesn’t wipe out that number of previous keystrokes.

The database system like PostgreSQL serves requests from many clients simultaneously.

When trying to send an email, using JavaMail, from my application deployed via the Jetty web server in Docker, I kept on getting the following errors: java.lang.NoClassDefFoundError: javax/activation/DataSource Caused by: java.lang.ClassNotFoundException:…

There is no way to get Java to automatically use find out many cores are available and use them all, on AWS ECS using Docker.

Spring’s Consuming web service guide is great at describing how to go about being a client of a SOAP service, but it doesn’t mention how to consume web services which are protected by any sort of security.

If you have a SOAP service written in Java using Spring, you have written methods that are called with Java objects representing the body of the SOAP request.

There is a nice new feature introduced by type-inference in Java.

I always learn things about usability when watching my Dad use a computer.

Sad day!!!

When I first started working, I noticed my boss at the time had a coding convention that I’d not seen elsewhere.

A Guide to the Project Management Body of Knowledge (PMBOK Guide) defines Resource Leveling (also known as Predictive Planning or Priority-Based Scheduling) in the context of project management tools as: A technique in which start and finish dates are adj…

Tool Cost What it does What it doesn't do Microsoft Project https://products.office.com/en-us/project/project-online-professional $30 per user per month (if you pay monthly) Has a lightweight online version to show workers their tasks, but for resource le…

Back in 2010 I worked for a company that had daily stand-ups at 10am every day.

Email delivery providers such as Mandrill, Mailgun, SendGrid, AWS SES etc. all provide proprietary APIs and SDKs to send email over their service.

So this is your setup.

In a similar vein to my previous article, here is a script to change the line endings of all files across all revisions in a Git repository to UNIX line endings. git filter-branch -f --tree-filter 'find .

So your product bills customers and produces invoices.

The traditional way of dealing with a checked exception being thrown from a place where you know it can’t actually be thrown, is to re-throw it as a RuntimeException.

Deadlocks are: One session/user has acquired access to resource A (and won’t let anyone touch it), and is waiting for resource B.

Recently a customer requested that a piece of software should “move companies” from company A to company B, henceforth appearing as if it’d always been created by company B, and never appear to have been produced by company A at all.

I have been thinking about emails vs phone, or more generally asynchronous vs synchronous communication, and have realized: If you receive a call, it breaks your flow, which is bad.

So today I got access to a customer’s new JIRA task management system.

I wrote down a note on my task list on the current project, “Investigate whether docker build always gets the latest version of the base image”.

I have long been inconsistent when creating Java Exception classes, in terms of how I name them.

A friend of mine asked me for my opinions on what programming language should be taught in the introductory class of computer science at university.

If you write a method like “add product to user’s cart”, you want to test that that method works.

One of the functions of backups is to be able to restore the system and data in the case of a successful hacking attack.

The trouble with toString() in Java (or ToString() in C#) is that every object implements it.

In the REST specification, there is no way to group individual requests together into a transaction (in the way that it's possible to group multiple modifications to a database into a database transaction, or in a distributed J2EE system use a distributed…

In draw.io in the browser, go to the File menu, Export submenu, export as PDF.

The arrow of time may famously only point only one way, but the progress in computer science takes a weaving non-linear path through the thing we understand as time.

Today I've released a new version of my blog and homepage.

If you replace code, and commit out the original while you are working, please delete the commented out code before you commit.

It is a requirement of many customer projects of mine to have a "remember me" or "keep me logged in" checkbox on the log-in form.

I think it's important, that in a software development company, as all others, customers get transparent up-to-the-minute information about what costs they have incurred.

The program “Facebook Background Task Host” was consuming the entirety of my disk bandwidth on my Windows 8.1 computer.

When I was at university in the 90s, studying computer science, my final-year bachelor project was a “fractal raytracer”.

Ubuntu 14.04 (and various versions of Debian) come with MySQL 5.5.

Recently, when reviewing code, I saw a commit resembling the following: - if (x) foo(); - if (y) bar(); + if (y) { + bar(); + } It’s not easy to see that of the two “if” statements, only one was actually deleted.

I went to a lecture recently and the CEO of Runtastic spoke.