Part 2/2 - Continued from above
>>1345446Why use THIS one?
- It has ALMOST 3 MILLION magnets from RARBG. It's the largest one.
- It's a DATABASE - "kinda like" a special set of Excel tables for efficient searching. MUCH better than some unwieldy text file.
- It has EXTRA INFORMATION about these magnets, such as torrent size and more.
To view it and search it, install
https://sqlitebrowser.org/ or any other SQLite Viewer/Browser/Editor/etc.
Open the file rarbg_db.sqlite in this Browser. Go to the "Execute SQL" tab there.
Write the following and press Ctrl+Enter or the "Play" button:
SELECT printf("%.2f GiB", CAST(size AS FLOAT) / 1073741824.0) AS size_gib, title, dt, printf("magnet:?xt=urn:btih:%s&dn=%s", hash, title) AS magnet_link FROM items WHERE imdb = "tt1745960" ORDER BY size DESC;
> SELECTa command to pick certain data and arrange it as follows
> printf("%.2f GiB", CAST(size AS FLOAT) / 1073741824.0) AS size_gib,the first column in the table of results will be the size of the torrent. it's stored in the db in bytes. this formats it to gigabytes to be readable
> title,next is the title of the torrent
> dt,date of the upload to RARBG, to help you guess if it still has seeders
> printf("magnet:?xt=urn:btih:%s&dn=%s", hash, title) AS magnet_linkthis assembles a ready-to-use MAGNET LINK from hash and title. you can COPY it from the table of results with RIGHT CLICK
> FROM itemswe're searching in the table called "items"
> WHERE imdb = "tt1745960"we want only the entries that have the "imdb" field matching Top Gun Maverick
> ORDER BY size DESC;results are ordered by size, largest to smallest
Some torrents don't have an imdb field. Either they are not movies, or the uploader messed up. To find them, write this instead:
> WHERE title LIKE "%Top%Gun%Maverick%"Use % before and after and between words, like this. It's a wildcard for text search. You don't know how EXACTLY each torrent is called ("Top_Gun" or "2022 Top Gun"?)
Beware, this is much slower.
