Articles, notes and random thoughts on Software Development and Technology
There’s many ways to this, like getting epoch millis, calculating the difference and then converting back into the units you need. With java.time apis and java.time.temporal.ChronoUnit you can calculate the difference between 2 LocalDateTime instances easily in one step with:
long elapsedMins = ChronoUnit.MINUTES.between(start, end);
I was looking for a refresher on how to do this and found my own post from 3 years ago in a Google search here (funny when that happens).
It’s been a while since I’ve written any notes about the Serverless framework, so here’s a few notes as a refresher on typical steps I use for local development.
As a reminder to self, regions I typically deploy to are:
AWS regions are listed here.
To deploy:
serverless deploy --region eu-west-2
To invoke local:
serverless invoke local --function functionName
To invoke remotely:
serverless invoke --function functionName --region eu-west-2
To check logs from last invoke:
serverless logs --function functionName --region eu-west-2
It’s been a while since I’ve run MySQL server on my MacBook Pro (see past notes here , here and more here) and since I got my new M1 MBP I haven’t installed it yet. Rather than doing a native install, I want to run it as a Docker container so I can throw it away easily when I’m done.
From the MySQL Docker page, run:
docker run -p 3306:3306 --name mysql-springboot -e MYSQL_ROOT_PASSWORD=your-root-pass-here -d mysql
The important part here is -p to expose port 3306 in the container as 3306 on the host. This will allow you to connect to localhost:3306 locally to MySQL in the container as if it’s running locally.
Connect with mysql shell as if the server is running locally:
mysqlsh -u root
and enter the password when prompted. Create a db and setup a user that you use from your app running locally:
create database example; create user 'exampleuser' identified by 'examplepassword'; grant all on example.* to 'exampleuser'
Running CSpect on Windows is pretty much download and go, but on MacOS you need to download some additional support, specifically mono in order to run the Windows .exe on MacOS. This page here, describes downloading mono using homebrew, but when starting it up it would give a segv error and crash. Instead of installing Mono via brew, download and install using the latest .pkg installer from here. It’s possible downloading via brew misses some needed dependencies, but the .pkg installer has everything needed.
To run with the Next rom I downloaded, I used these options:
mono cspect.exe -w3 -basickeys -zxnext -nextrom -mmc=sn-emulator-22.10a.img
