A new front-end interface powered by Bitmagnet

[journey-ad]

Hi everyone,

I made a new web UI using Next.js and NextUI. The repo is here: https://github.com/journey-ad/Bitmagnet-Next-Web. Maybe someone will find it interesting.

It query the DB directly because the original Bitmagnet graphql API didn't meet my needs. I needed accurate total counts for pagination, but The graphql API returned inaccurate numbers. Also, I needed hash queries for torrent info.

The graphql API was slow (over 1 minute for 1.8 million torrents). So, I used the pg_trgm extension and added indexes to the torrents.name and torrent_files.path columns:

CREATE EXTENSION pg_trgm; -- Enable pg_trgm extension

-- Create indexes on `torrents.name` and `torrent_files.path`
CREATE INDEX idx_torrents_name_1 ON torrents USING gin (name gin_trgm_ops);
CREATE INDEX idx_torrent_files_path_1 ON torrent_files USING gin (path gin_trgm_ops);

This reduced the response time to a few hundred milliseconds ~ a few seconds, which should be good enough for personal use.

I am not a professional backend developer and don't have extensive PostgreSQL knowledge, just sharing some recent work. Hope it helps someone.

[journey-ad]

This is a copy of #275. Thanks to @mgdigital for the response. I will research it later.