The topic of JOINs was thoroughly covered (JOINs are old news), but one user (Mani) made this comment: I have gone through videos, but lateral join concept is missing. Please update course with lateral join and use case. This prompted a digression into LATERAL JOINs as it was a new thing to me. My reply… Continue reading LATERAL JOINs in PostgreSQL
Author: admin
Linux admin, JS / React / Python / Perl developer.
\gexec in PostgreSQL
\gexec in PostgreSQL is handy when running a function that outputs dynamically generated SQL to be run to get final results
Numeric column names in PostgreSQL
In the Udemy PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours course, there was a lesson where we wrote a function to output some SQL to enable dynamic pivot tables:pass the table_name, vertical_header_column, horizontal_header_column, value_column, and data_type and any table can be “pivoted”. Pretty nifty. But… it was hideously difficult to transcribe the code… Continue reading Numeric column names in PostgreSQL
PostgreSQL Pivot Tables
PostgreSQL Pivot Tables using \crosstabview with sortation based upon various criteria
systemd & resource monitoring
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
Email lists with Mailman3
Is migrating from Mailman2 to Mailman3 too much of an ordeal?
Is it worthwhile?
Does Mailman3 consume too many resources?
Deploying React Apps
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
Give me http, Firefox
Firefox … forcing https. Great! How do I override it for my niche situation?
http server – in bash!?!
A discussion came up on one of the LUGs this weekend (Victoria’s VLUG). Craig had a situation with a router with low specs that he wanted to retrieve some info from. The idea of a simple http server in bash came up. I thought, “Nah, can’t be done.” I was wrong. He found a Github… Continue reading http server – in bash!?!
ReactJS handleClick
Thoughts on styles of handling Click events in ReactJS