mangatsu / server Goto Github PK

https://github.com/pressly/goose

• SQLite3
• #18
  • MySQL
  • MariaDB
  • PostegreSQL

Sources to pull metadata from for galleries like manga and doujinshi.

Create separate issues for individual sources.

• AniList
• nhentai
• e(x)-hentai

What else?

Either

• Save the raw user agent as the session name and let client handle the parsing
• OR
• Parse the UserAgent and save the result

• Initial rework #20
• Handle the scenario when the ID exists in db in newLibrary
• Rewrite CombinedLibrary struct

• https://github.com/go-chi/chi
• https://github.com/gorilla/mux (used currently)

Mangatsu/server and Mangatsu/web as single (or one for each OS: Windows, Linux, MacOS if needed) all-in-one binary which could be run as-is.

The rework is being work on in https://github.com/Mangatsu/server/tree/goqu-rework

Currently only SQLite3 is supported. Support for more databases would be nice.

Supported databases

• SQLite3
• PostgreSQL
• MySQL/MariaDB (optional)

Tasks

• #17
• #16
• #15
• #14
• #23
• #24

https://github.com/gen2brain/go-fitz is probably useful.

Web TODO here

Short term

• #12
• #5
• #1
• #2
• #3
• #28
• #4
• #7
• #26
• Better plain file support and general improvements for the scanner and tagger
• More testing especially for the server (db, parsers)
• Allow disabling internal file server to allow for external file serving (like NGINX)
• Group structured manga with the same series names

Long term

• #6
• Improvements to cache policy (e.g. max size)
• Rework sessions to utilize JWT refresh tokens (expire in 5-15 minutes or so)?
• Flutter (or something else) mobile app frontend

Initialize database and database user on first launch if needed. Also an environmental to disable this should be present.

For example for MySQL/MariaDB it'd be:

CREATE USER '<USERNAME>'@'<ADDRESS>' IDENTIFIED BY '<PASSWORD>';
CREATE DATABASE IF NOT EXISTS <DATABASE_NAME> CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES on <DATABASE_NAME>.* to '<USERNAME>'@'<ADDRESS>';
FLUSH privileges;

The utf8mb4 COLLATE utf8mb4_unicode_ci helps with support for Japanese, Chinese etc. characters.

Video support (at least mp4, webm) in galleries for both the backend and frontend.

Many cosplay and art collections include them.

Support for periodical scanning. Allow users to specifify the interval. Maybe library specific (as multiple library locations is supported)?

We could probably use the types Jet generated as a base: pkg/types/model.

This one might be the most challenging part of the goqu rework.

• GetGalleries function is very elaborate and prone to bugs if not converted carefully.
• UpdateGallery can probably be refactored to be much shorter and better written overall. The Jet library made it hard to do partial updates.
• NeedsUpdate isn't used anywhere currently and can be pretty much ignored

Allow admins to edit gallery metadata through the web app.

• Gallery data
• Gallery reference data
• Tags