Linux pros and enthusiasts
Various servers in a Linux environment
Had some fun exploring JSON and JSONB features in PostgreSQL recently.
First task was to flatten two tables’ rows into a single field of JSON data. Nice intro to json_agg() and row_to_json().
Where it got real fun was extracting that data back out from JSON to rows & columns with the help of jsonb_path_query().
\gexec in PostgreSQL is handy when running a function that outputs dynamically generated SQL to be run to get final results
I found a nifty trick for measuring the resource consumption of various services using systemd. This was while trying to gauge the differences between Mailman v2 and Mailman v3 resource management. I have ranted about how much more expensive MM3 is in resource consumption (basically, about ¾ of a 2GB RAM VPS is consumed). I… Continue reading systemd & resource monitoring
Is migrating from Mailman2 to Mailman3 too much of an ordeal?
Is it worthwhile?
Does Mailman3 consume too many resources?
When deploying React apps on Apache or nginx, in a sub-folder of the root / DocumentRoot, there are some issues to consider. While the deployment guide suggests setting “homepage”: “.” in package.json, others have advised against this. Taking that at face value, I used “homepage”: “/react/react-hooks”, which initially appeared to work. However… static images from… Continue reading Deploying React Apps
If an email gets stuck in postfix’s deferred queue, there are a couple of ways to deal with it.
For general discussion, the “discuss” list:
https://lists.bclug.ca/mailman/listinfo/discuss
Alternately, send an email to discuss-subscribe@lists.bclug.ca, then simply reply to the confirmation email message.