How To: Migrate PhotoPrism DB from SQLite to MariaDB on FreeBSD
Thanks to the porting efforts of huo-ju (photoprism-freebsd-port) and psa (libtensorflow1-freebsd-port), it is quite easy to get PhotoPrism up and running on a FreeBSD system or jail. The port uses SQLite 3 for the DB implementation by default, and while that runs fine for a few thousand pictures, things start slowing down a bit when reaching the tens of thousands. This post will help you to migrate your PhotoPrism FreeBSD installation from SQLite to MariaDB. ...