Skip to content

Blog

MS SQL Installation

Just a note to self, that when installing the developer edition of MS SQL, TCP is not enabled, by default, so you cannot connect to the instance via the port, 1433, until you open Sql Server Configuration Manager, find SQL Server Network Configuration and enable TCP/IP. You can now connect.

Sudo Two-Factor Authentication

Two factor authentication for Sudo access gives you an awesome security enhancement so that a hacker still will not be able to use sudo, i.e. admin privileges, even if they have discovered your password.

Fireship.io tutorial

These are notes I ook on the flutter fireship io tutorial.

To create new project

flutter create --org com.wildetechsolutions myapp

To check flutters compatibility with all build modes, run

flutter doctor --verbose

Using Ubuntu Snap Store

Download Immich Distribution. When finished it will run on port 80, i.e. localhost. The persisted locations are found in

/var/snap/immich-distribution/common

i.e. you'll see the pgsql and upload folder here.

To see the snap variables run

snap get immich-distribution

Using Umbrel

Installing UmbrelOS in VM

Using OracleVM, set up a new machine as usual. You will need to manually select Linux and Oracle Linux (64-bit) and also be sure to Enable EFI.

After installing the medium to the disk the machine will turn off. Change the boot order ot only include the hard disk. Go to storage and click on the installation disk. There is an option to eject the disk on the far right.

You can then navigate to umbrel.local in the browser.

Serverless Relational Databases

Here are some services I should look into that would likely end up costing a lot less than something like RDS.

Service Compute Pricing Storage Pricing Ideal For
Amazon Aurora Serverless Billed per ACU per second. $0.10 per GB-month. Variable workloads with MySQL/PostgreSQL compatibility.
Azure SQL Database Serverless Billed per vCore per second; e.g., ~$0.5218 per vCore-hour for Gen5. Billed separately per GB. Intermittent workloads with auto-scaling and pausing capabilities.
Google Cloud SQL On-demand and committed use pricing; e.g., ~$0.0825 per hour for 1 vCPU instance. $0.17 per GB per month for SSD. Managed relational databases with automated scaling.
PlanetScale Free tier available; paid plans based on resource consumption. Included in usage-based pricing. MySQL-compatible databases with serverless scaling and modern development features.
CockroachDB Serverless Free tier available; usage-based pricing beyond free tier. Included in usage-based pricing. PostgreSQL-compatible distributed SQL databases requiring high availability and global scaling.