![Logo icons for PhotoPrism, FreeBSD and MariaDB](/posts/2024/05-29-migrate-photoprism-db-sqlite-mariadb/images/cover_hu2584955623991746042.jpg)
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. ...