GORM VS photoview

GORM is a comprehensive ORM tool in Go, offering a code-first approach which allows defining database schemas using struct tags in Go. It's known for its developer-friendly nature, making it suitable for both beginners and experienced users. GORM supports a variety of SQL databases like MySQL, PostgreSQL, and SQLite. It's designed to be flexible, allowing developers to drop down to raw SQL when necessary. However, it's important to be cautious about its performance implications in large-scale applications.

Homepage: https://gorm.io/

Since most of these APIs will be simple CRUD (Create/Read/Update/Delete) endpoints, let's build this service using GORM, an ORM library that makes building CRUD endpoints really simple.

After successfully configuring the application, it's time to delve into integrating the data layer. For this purpose, I will utilize gorm, a powerful SQL ORM that facilitates rapid development of the data layer using model structs.

For basic INSERT ... VALUES ... or SELECT ... WHERE ... JOIN ..., use a library such as GORM. For INSERT .... SELECT ... statements where one combines two round trips (SELECT and INSERT) into one, ORMs have a hard time performing this query. Particularly when you start doing joins. Joins are the heart of Relational database theory (they denote relationships). So get to know what an INNER, LEFT, RIGHT and OUTER join is and why you would use them. Also learn INSERT ... SELECT ...

I have never hated gorm and it serves me well. However I tend to feed it raw SQL very often.

Array of values with embedded value all pointed to the last value, reflect code was broken: https://github.com/go-gorm/gorm/pull/5901 data corruption

Most lightweight one I've found so far: https://photoview.github.io/

I looked at a bunch of these 2 years ago and ended up using PhotoView for a private gallery. It had the right mix of simplicity and features, and I was actually able to get it running.

https://github.com/photoview/photoview

Take a look at Photoview: https://photoview.github.io/ . I think that it will fit all your needs (or at least, most all of them)

I use Photoview with Nextcloud, because I like its UI more than Nextcloud.

I can suggest 3 options. * Photoview - It is like a gallery with recursive folder structure (folders inside folders) support. You can create shareable links for the folders, with password protection. The UI is great. And your clients will be able to download the complete folder, also individual images at either full resolution or reduced. The issue is you cannot use the UI to add or delete photos, but it can be a great thing for security and stability. * Chevereto - It is more like imgur. You upload all the files using the UI and create albums and their sharable links. I do not think if it supports videos at all. * Nextcloud - Another great option if you want to give your clients a Google Drive or a Dropbox like experience. You can create custom links, like example .com/client-name, which can look more professional. For better videos experience you'll need hardware acceleration.

I have tried A LOT of solutions and I finally stopped after using Nextcloud and Photoview. I synchronise files from my computer to Nextcloud using rclone and view them on Photoview whenever I need. You can sync to you nextcloud using their official app on phone. I use Photoview because I have not found a single self-hosted solution that keeps the folder structure and lets me view them as both, in folder structures as well as in a chronological timeline.

Bl4ckB1s3ct0r gave the right answer - Photoprism and Immich can be considered as open-source alternatives of Google Photos. Another one is Photoview.

PhotoView