TQ
dev.com

Blog about software development

Subscribe

Why I use Bitlocker without TPM

04 Apr 2021 - by 'Maurits van der Schee'

Bitlocker is the Full Disk Encryption (FDE) solution in Windows, similar to FileVault in OSX and LUKS in Linux. I do advocate the use of full disk encryption on any device, but especially on devices that are prone to theft, such as laptops...

Continue reading...

Storing JSON strings in MariaDB

11 Mar 2021 - by 'Maurits van der Schee'

In SQL every column has a name, a type and a single value (that may be NULL in some cases). These strong guarantees makes working with SQL very nice. Nevertheless people seem intrigued by these "limitations" and propose "improvements"...

Continue reading...

Installing PDO_SQLSRV on Debian 10

18 Feb 2021 - by 'Maurits van der Schee'

Installing the PHP SQL Server driver (PDO_SQLSRV) on a Debian 10 Linux system requires several steps, starting with the installation of the Microsoft ODBC Driver. Note that Debian requires TLS 1.2 and if your SQL Server does not support that you will run into "Error code 0x2746"...

Continue reading...

Should table names be singular or plural?

02 Jan 2021 - by 'Maurits van der Schee'

As we all know "naming things" is jokingly named as one of the two hard problems in software engineering (the other one being "cache invalidation"). This post is about the question whether your (database) table names should be plural or singular...

Continue reading...

Free OTP 'soft token' written in Go

08 Nov 2020 - by 'Maurits van der Schee'

I have written open-source software that you can use as an alternative to Google/Microsoft Authenticator on any device (that Go can cross-compile for). You may (for instance) run it on your Raspberry Pi (zero) and use it as a "semi-hardware" token...

Continue reading...

Beelink Gemini T34 modding

11 Sep 2020 - by 'Maurits van der Schee'

I bought a "Beelink Gemini T34" mini PC for 120 EUR with 8GB RAM, 128 mSATA SSD and a N3450 quad core 2.2 Ghz CPU with an Scenario Design Power (SDP) of only 4W. It is the successor of my "Beelink T4" mini PC with 4GB RAM, 64 GB eMMC and a Z8500 quad core 2.24 Ghz CPU...

Continue reading...

Free GDPR scanner online!

05 Aug 2020 - by 'Maurits van der Schee'

I have created a free GDPR scanner at: TQdev.com/gdpr-scanner. You can use it to see what domains are connected by your website and see who is running those domains and where they are hosted. Ideally you see only one entry with only the domain that you have entered...

Continue reading...

PHP-CRUD-API now on Docker Hub

01 Aug 2020 - by 'Maurits van der Schee'

PHP-CRUD-API is an "automatic" API: software that turns your database into a REST API. This is possible thanks to database reflection (asking the database which tables and fields it has). Support for Docker and Docker Compose has been added...

Continue reading...

OSX clean install error messages

26 Jul 2020 - by 'Maurits van der Schee'

When you buy a second hand Mac you should do a clean install of OSX from a USB drive for security reasons. This sounds easy, but there are some problems you may run into. In this post we discuss 2 common, but cryptic, error messages...

Continue reading...

uBlock Origin on Android

17 Jul 2020 - by 'Maurits van der Schee'

On Xubuntu I protect my privacy by using an ad-blocker (uBlock Origin) in my browser (Firefox). On my phone (Android) I also use Firefox, but I was not able to install uBlock Origin in Firefox on Android, until now!...

Continue reading...