Thema: CD/DVD/Film-Verwaltungsprogramme & Tools

[SiLæncer]

EMDB is a small utility to keep track of your DVD collection. With an automatic import from the database of IMDB, export to csv, text or complete website, thumbnail cover preview, a loan tracker, search function and multi-language user interface. EMDB is written in C++ using Microsoft Visual Studio 2008 and doesn't need a .NET framework or any other external libraries.

Freeware

Changelog

    Database: Added re-indexing based on current sorting and renaming of thumnbails.
    PayPal: Fixed the donate and order customized version of EMDB buttons on the about page.
    Export to HTML: Fixed title sorting for some foreign titles with prefixes (e.g. "L'Étudiante").
    Groups: Fixed incorrect stored group sorting strings.
    TV Series: Added warning when selecting Single Season.
    Poster screensaver: fixed hanging of EMDB when no posters are available.
    Add From Hard Disk: Improved filtering of keywords.
    Add / Edit Movie: Fixed MediaInfo update freezes EMDB when the Location is a folder.
    Add / Edit Movie: Fixed EMDB moved behind other applications after IMDb lookup.
    MediaInfo: Fixed detection of DD Plus 7.1 and AAC 1.0 Audio streams.
    MediaInfo: Retrieve framerate when adding movies from Hard Disk.
    MediaInfo: Retrieve info from a m3u playlist now retrieves info from the first file instead of failing as playlists are not supported by MediaInfo.
    PlayLists: Fixed creation of playlists in Add / Edit dialog sometimes failed.
    Translations: Updated the Spanish, German, Simplified Chinese, Arabic, French, Italian and Dutch translations.

[close]

http://www.emdb.eu/

[SiLæncer]

If you frequently work with large numbers of video files, you probably know how difficult it is to find what you need without watching every single clip. Thankfully, there are various types of applications that can help you out.

Scene Explorer is one of them, a fairly simple utility that generates thumbnails for every video in a directory, making it easier for you to see their contents without actually playing them.

Donationware

Whats new:>>

    tooltip on directories
    stop refreshing of directory tree at the time the main window activates

https://github.com/ambiesoft/SceneExplorer

[SiLæncer]

Whats new:>>

    Add Files from Hard Disk: If a found file exists in the database but with a different path, the file sizes are the same and the existing entry does not exist anymore, the file is now considered to be moved and the path of the existing entry is updated.
    Startup Checks: Added check for moved files (see previous for the logic).
    Add Files from Hard Disk: You can now simply drag and drop movie files or folders on the Bookshelf to add them to EMDB.
    Database Merge: fixed covers / posters from the selected database were not properly transfered to the current database.
    User interface: Improved zooming and scrolling of the bookshelf.
    Translations: Updated the Dutch translation.

http://www.emdb.eu/

[SiLæncer]

Manage large media collections and re-organize them using tags instead of folders that you can share via custom servers with this application.

The Unlicense

Changelog

    the hydrus network version is increased this week from 18 to 19. clients and servers can only talk to each other when they are on the same version, so please update your clients if you wish to keep talking to the PTR, and your own servers if you have a home network setup or similar. if a server and client are on different versions, you will get a polite error when they next try to talk, and sync will be paused
    added 'run all export folders now' shortcut command to 'main window' shortcut set
    added shortcuts to the 'main gui' shortcut set for navigating the currently selected page. you can move left, right, to the leftmost on the current row, or to the rightmost. the left and right will cycle up a page of pages layer when at left/rightmost boundaries, letting you iterate through all pages in a depth-first manner
    updated the default newgrounds parser to deal with artists with more than 60/70 items in one art gallery (essentially, some clever 'next page' fetching now occurs to get older info that in your browser is drawn in as you scroll down). if you have some subscriptions for artists where you know this is true, try doing a full reset on them
    added realbooru to the hydrus defaults. they also apparently just switched away from a gelbooru 0.2.x site, so if you have a gelbooru parser with a realbooru example URL, I remove that example URL
    updated the page initial media load routine to my new async job
    updated the imported file presentation page-publish routine to my new async job
    when drag and drop or import file presentation now wants to add files to a page that is not yet fully loaded (rare, but possible for large sessions), that page now remembers the files it should add and appends them once load is done. these files-to-be-added are also preserved through a session save, if the client is closed before this long-loading page is initialised
    updated windows mpv, the reported api version is now 1.09
    updated windows ffmpeg to 4.3.1
    updated windows release to sqlite 3.33.0
    updated windows opencv to 4.4.0
    just a little thing--I took the source links out of the release post. anyone running from source is probably pulling straight from the github repo anyway
    cleaned up some misc inelegant string code
    misc other cleanup

    upnp:

    fixed the awful typos in the upnp add-mapping error handling I changed last week. I am sorry for this!
    improved the async mappings and external ip fetch routines in upnp dialog. closing the dialog while a job is going on should now be completely ok
    upnp dialog add, edit, and delete actions are now async (they won't hang the UI while they work)!
    all the upnp async jobs should now disable the main list controls while they work
    fixed the 'edit' action on upnp dialog to correctly remove old and existing mappings depending on what was edited
    when adding a mapping for an (external_port,protocol) that is already mapped, the upnp dialog now asks if you want to overwrite, rather than just failing with a notification
    after an async action in upnp dialog, and a mappings refresh triggered, the cached external IP should now be properly restored to the status area
    pulled parsing code out of upnp code and wrote some proper unit tests for this so stupid typo errors should not happen again

    parsing:

    subsidiary page parser separation formulae that throw an exception will now be ignored, as if they parsed nothing. in the weird case that you might receive json or html, you can now create subsidiary parsers for both types, and the one that fails will do so gracefully and silently
    URL Classes now have a key->value 'header override' value. any time one of these URLs is hit, these headers are added!!! be careful with this, but it may solve some tough problems. also, sorry, the URL Class UI is becoming a hellstack, I need to break it into tabs or similar

    client api:

    added documentation for the new add_files commands, delete_files, undelete_files, archive_files, and unarchive_files
    added unit tests for the new commands

[close]

https://hydrusnetwork.github.io/hydrus/

[SiLæncer]

The Music Collection is a free program that allows you to archive your music collection. Using it you can enter in a collection any kind of music media that you own or you intend to. Also you can add or edit any kind of information concerning the albums in the collection.

The album info can be manually entered or automatically via the Internet. After saving the albums, you can browse them, filter albums by all possible criteria and search for particular album tracks you are interested. Also the program can display and print all data from your music collection in different ways, so you can pick the desired one.

The idea for creating the program was to manage my own music collection and i hope that it would be also useful to any music collector.

Freeware

Whats new:>>

    Added : Composer field in track search.
    Added : Additional search in tracks when looking for artist/composer in advanced album search.
    Added : Track composer field in exports.
    Fixed : Some minor bugs.

http://www.gsoft4u.com/

[SiLæncer]

Spoiler

=Changelog[

    Almost all system predicates are now editable if you shift+double-click them! you can also edit several at once in the same dialog
    If you double-click on any predicate type that is not editable but does have an inverse version (e.g. archive/inbox, has audio/no audio, and tag/-tag), the inverse version(s) will be swapped in
    All legacy custom system predicate defaults are eliminated this week. the panels now show a fixed default on launch, and will get a flexible favourites system in future, along with 'recently entered' quick buttons
    Restored the 'show system:everything' and 'hide archive/inbox' options, which were inadvertantly hidden when file system predicate defaults were hidden, to the new options->search panel
    Fixed the borked list height for the file viewing statistics system pred panel checkbox lists
    Fixed an issue where namespace:anything predicates would not propagate to new pages on 'open page with these tags' commands.

    Boring code specifics:

    Updated almost all the system predicate panels to take arbitrary initialisation values, and wrote a 'can I edit this' test for all predicate types to help some finnicky which-panel-and-pred-to-use issues
    Wrote some new filtering code and a little UI to handle editing of system preds
    Cleaned up some of the taglist item activation code

[close]

https://hydrusnetwork.github.io/hydrus/

[SiLæncer]

Die Musikbibliothek MusicBee bietet durchdachte Funktionen: Der CD-Grabber überprüft anhand der Online-Datenbank AccurateRip, ob Lesefehler entstanden sind; der „Auto DJ“ sorgt für abwechslungsreiche Berieselung. Zudem befüllt das Programm alle gängigen portablen MP3-Player

Freeware

Whats new:>>

- hotkey to collapse all nodes in a tree nodes panel eg. the tag hierarchy panel
- album covers and artist views can now be configured to show album tracks in a separate panel
- improved handling for high-dpi screens with theater-mode skins
- improved handling for high-dpi screens with skinned custom player controls panel
- more standardised UI handling for star rating selection
- play previous now remembers all play history for a session (previously it was restricted to when the playing tracks list was last set)
- various bug fixes

http://www.getmusicbee.com/

[SiLæncer]

Changelog

    Tag lists and editing predicates:

    You can now set the default value for any editable system predicate. a star button beside each panel lets you set or clear the custom default
    All editable system predicate panels now put 'recent' predicate buttons up top, for the five most entered predicates of the respective types. this is a little jank and grows pretty tall with multi-pred-type panels, but let me know what you think
    All tag lists now support drag-selection!
    Taglists now have 'open a new OR page' menu entry when more than one tag is selected
    When taglists can change the current search, they now have an 'add an OR to current search' menu entry when more than one tag is selected
    OR Predicates are now editable! they launch their own little autocomplete input that is a little jank because you can technically make nested ORs, but it works!
    System:rating is now editable! it launches the whole stack every time. the stack alignment is messed up though :/
    Invertible predicates (inbox/archive, tag/-tag, etc...) now flip on double-click only if you have one selected. if you have more than one selected, they appear as invertible buttons along with the rest of the edit UI
    The active search predicates taglist now has an 'edit search terms' menu entry, if you find shift+double-click a pain
    When you shift+double-click on more than one tag to add them to the current search, this is now added as an OR
    Similarly if you shift+middle-click on more than one tag, the new page is now an OR
    When editing predicates, edited predicates now stay selected
    Shift+clicking on an already selected tag no longer adds any new selections (i.e. shift+click filling-in). this should make it nicer to do shift+double-click on selections. furthermore, the 'last clicked' focus ghost (from which a shift+click selection cascade starts) on tag lists is now cleared on edits or removes, which should reduce some other crazy/annoying select behaviour here
    The list of active search predicates now correctly initialises sorted
    Entering hex hashes into system:hash or :similar_to now has unified hash parsing, auto-removes 'md5:'-style prefixes, and presents detailed error information when a hash is too long or short.

    Faster and snappier file and tag searching:

    Searching for files by complicated wildcard (i.e. a search phrase that includes an asterisk in a non-rightmost character position) is now greatly optimised when the tag does not start with an asterisk (e.g. 'sm*l' is now much faster, '*all' is still hellmode), and now cancels (due to hitting the stop button or changing the query before results come in) much faster thanks to a new unified results fetching and cancel-checking routine
    Rewrote my autocomplete tag search to use the new namespace and subtag lookup code from the virtual siblings and parents system, unifying lookup logic and benefitting from the same new complicated wildcard optimisation and fast-cancel tech
    Autocomplete tag count aggregation (a later step, after the initial lookup) benefits from a little faster cancel tech
    All file queries based on tag, wildcard, namespace, tag count, and tag existence now use the new fast-cancel tech. if you put in a 'has >4 tags' query and it is taking ages, changing the query or just hitting the 'stop' button should now free up the db pretty fast
    Related tags suggestions also gets the cancel tech and is now more timing precise for tags with either huge or tiny count.

    Client api:

    The /get_files/file_metadata call now returns a service_names_to_statuses_to_displayed_tags structure, which reflects the sibling-collapsed and parent-added tags, as displayed to the user in UI. the help is updated to reflect this
    The client api version is now 15.

    The rest:

    Fixed an issue where regenerating the tag definition search cache would not tidy up the 'I am busy' modal dialog once it was done, resulting in a soft lock
    Fixed another upnp error handling bug, this time in the upnp daemon
    Updated Qt to 5.15.2 on Windows and Linux builds. this should fix the unusual button clicking area problem for some custom styles.

    Boring specific code changes:

    Wrote widgets to edit invertible preds and OR preds
    Pulled the messy rating code out of the rating system predicate ui code to their own widgets
    Wrote some special predicate ui definitions and initialisation handling for OR preds and grouped 'multiple' preds (for ratings)
    Refactored search and predicate ui code to a new 'search' module
    Refactored collect and sort widgets away from search code
    Misc layout improvements for system pred edit ui

[close]

https://hydrusnetwork.github.io/hydrus/

[SiLæncer]

tinyMediaManager is a compact tool designed to scan your movie folders and organize the information into multiple categories. The program is able to detect the movie files and retrieve posters and other information form IMDB or other websites.

You can use this program to sort your collection, retrieve movie trailers and additional content with minimum effort.

Freeware

Changelog

    Added support of Kodi v19 style extrafanart (fanartX.ext)
    Added support of sorting in movie set/TV show tree #540
    Provide a filter for multi select combo boxes
    Added file name options for movie set artwork
    Added support for downloading TV show themes #825
    Added video bitrate to movie columns
    Added audio language filter
    Added subtitle language filter
    Major rework of the TV show renamer (cleanup of TV show related files)
    Added first aired date to the episode chooser
    Added the media source .WEB. to WEB-DL
    Added "decade" tokens to movie renamer
    Better movie title search (#1089)
    Add support for syncing MP2, FLAC and DTS-ES metadata to Trakt.tv
    Enhanced visualization of the image chooser #1090
    Enhanced detection of container formats #1038
    Added more icons for media sources #1069
    Fetching 0.0 rated movies
    Detect 4 digit episode numbers
    Fixed TV show genre filter #1104
    Separated reload media information from rewriting the mediainfo.xml file #1105
    Skip data sources in "update data source" which are excluded in the settings
    Prevent a possible memory leak in the trailer downloader #1099
    Do not show missing seasons as shown #1102
    Added aac logo

[close]

http://www.tinymediamanager.org/

[SiLæncer]

Changelog

    Fixed the bad position indexing when drag-selecting taglists that were scrolled down. this also caused some weird selection when scrolled and clicks included a little mouse movement. sorry for the trouble!
    Ctrl+drag-select now deselects!
    Fetching tag autocomplete results when you have thumbnails and 'searching immediately' on, which has been way too slow recently, now cancels much faster. in some large page situations, it was adding multi-second lag on the first character-press. it also runs faster overall
    Hydrus should now deal better with invalid tags that contain the null character (there it one we know about on the PTR, from a decode of botched Shift JIS, which could crash the client from too many errors during critical paint periods). when a tag like this turns up in a taglist, thumbnail, or canvas background, it now renders as an appropriate 'invalid tag' string, and a one-time 'woah, bad tag, run fix tags now' popup appears
    Regular tag cleaning now looks for and removes null characters, so all new sources of these bad tags should now be eliminated
    Database->check and repair->fix invalid tags now fixes tags with the null character. it also fixes tags so broken that after cleaning they have no subtag left. it also now forces a full media tag reload when it is done for all media
    The 'regen storage mappings', 'regen display mappings', and repopulate from cache' database routines now have an additional step where you can order them only to work on one tag service, so regenning or repopulating local tags, which usually takes a couple seconds, doesn't need to wait two hours for the PTR to go as well
    Added some menu help to the 'profile modes' debug menu, and gave 'reducing program lag' help page a pass
    Fixed virtual display regeneration on service delete

    Parents and siblings:

    Fixed situations where some grandparent and sibling relationships would not appear in the virtual system. it was a bug when certain links of a multi-part display 'chain' were updated at different times. when repopulating chain data, the sibling and parent update routines now correctly chase their complete chains both when wiping ideal data and repopulating from raw data, hitting all levels of the chain, ensuring to go back up and down chains when there are multiple grandsiblings/children/parents, and chasing parents where one or both members have better siblings. thank you to the several users who reported and helped figure out this problem, which was not simple to reproduce (issue #725)
    Your ideal display data will be regenerated on update, which should not take more than a couple of seconds. it will likely correct some siblings and add some grandparents to be filled in by the siblings/parents sync. my PTR test environment went up from about 189,000 display rows to 192,000
    While sibling and parent lookup is more thorough (and hence more expensive), I also optimised many parts of lookup week. I believe tag display sync and tag processing will be much faster for tags with simple sibling and parent relationships, and slightly slower for tags with complex relationships and many instances to files on your drive. as always, let me know what sort of processing speeds and lag you get, and if you know how to make a db profile, please send them in when it gets bad
    When a 'write' autocomplete results list includes parent expansion rows (as in manage tags), parents now show duplicated and properly for all the tags that have them, including siblings and other children/grandchildren (previously, a parent label could only exist once in a list, which meant parents were ending up hanging off the last valid tag for which they applied)
    'write' autocompletes now show results that exactly match the text entry, and all their siblings, when they do not have count but do have sibling or parent data. so, if you type in 'samus aran', and it has a sibling to 'character:samus aran', but 'samus aran' doesn't actually have count, you now get it and all siblings anyway. this may need tuning, but it solves a persistent and annoying lookup and quick-sibling-access problem in manage tags
    Copying tags and their indented parents now removes the parent indent whitespace
    Tag sync display now takes way longer breaks (now 30 seconds, was 2.5) between 'normal' background work periods. this thing was hammering people far harder than needed and could clog up db write/commit time and nobble UI responsitivity when big bumps collided
    The tag display maintenance manager now also tries to detect when many siblings or parents are streaming in (from a migration or a repository process with a heap of data), and pauses work while that continues
    Greatly sped up mass imports of sibling and parent data, either from tag migration or big dialog pastes. what was 40 rows/s should now be about 1,000 rows/s
    Fixed the database menu's 'regenerate tag parents lookup cache', which wasn't hooked up

    Boring changes:

    Gave tag parents and siblings update, regen, and chain fetch a full pass, correcting bad queries to fix the above, fixing raw pair chain level navigation and parent-sibling idealisation, and optimised these lookups as well
    Fixed some tag_id vs ideal_tag_id nomenclature (and related bugs) in tag parents cache
    Optimised 'all known tags' autocomplete count fetching a little. tag autocomplete and search should be a bit faster in this domain
    Reduced display sync pre-processing overhead by about 30% with a better random pair sampling routine
    Reduced the overhead of my now very commonly used single integer memory table select optimisation. this now recycles tables after use, which reduces overhead about 50% in small number scenarios. all features of the database will enjoy this speed improvement, particularly small repetitive tag lookup jobs (such as the new display sync and repository tag processing)
    Reduced overhead on some sibling chain lookup code
    Reduced overhead on the sibling lookup used by manage tag dialog taglist
    Reduced overhead on some parent chain lookup code
    Tiny optimisation on single sibling chain lookup
    Sped up the ancient OG single tag->tag-id fetching routine, seems to work about twice as fast now
    More misc optimisations, mostly list/set/dict comprehension rewriting to reduce overhead, across virtual sibling and parent code
    Added a full combined siblings and parents unit tests for the main missing parent chain link problem solved this week
    Added a full combined siblings and parents unit test for large real world data added in multiple pieces
    'a file identifier was missing!' critical errors now print a stack trace to the log for further debugging info
    Updated the 'help my db is broke.txt' document with a couple new comments

[close]

https://hydrusnetwork.github.io/hydrus/

[SiLæncer]

Changelog

    Misc:

    Thanks to a user's contribution, added the export 'filename pattern' to the discord drag and drop mode, under options->gui. this lets you auto-rename files in this export mode. I like how this works, but the overall pattern-based filename creation system really needs updating. let me know how this works for you, and I'll finally start the job to update filename generation
    Fixed a bug when importing files with the 'only add tags that already exist' filter active, and added a unit test so this should not fail due to a typo again
    Fixed an issue where ctrl-selecting on taglists was weird, where any mouse movement during ctrl+click would deselect. drag select and deselect can now only start when the drag crosses two indices
    Prototyped a basic profile mode for the client api. it is insufficient (due to the asynchronous nature of twisted), but a start
    When the client catches an invalid tag with the new error handling code, when it shows you that bad tag in a popup, it now clips that to 24 characters (some PTR invalid tags are just a few hundred null characters in a row, wew lad)
    The client now recovers from a repository giving it a new invalid tag definition. all such tags are, for now, called 'invalid repository tag'. a plan to auto-hide these tags clientside and fully eliminate them serverside will come later
    The clipboard url watcher settings should stick a bit more firmly. those users who had trouble, please let me know how you get on
    Fixed an issue editing duplicate action options when they contained tag or rating preferences for services that no longer exist
    I think I fixed some issues getting autocomplete results when you type the whole namespace before moving on to the subtag. when you hit 'namespace:', it should invalidate the old cache and start a new search
    When the database is given content updates for services that no longer exist, those content updates filtered out of UI update broadcast
    Fixed an issue where URL status check could fail when the url map contained orphan hash_ids. proper orphan clearance will come later
    Reduced overhead of tag filtering, which should improve display speed of taglist for very large pages
    Parents should now work through repository processing faster. periods of 2 rows/s at the end up of updates should be up to 100 times faster.

    Duplicates search improvements:

    Potential duplicate search now works in the background! it will not interrupt you and is easily cancellable. duplicate search pages disable their search buttons while it is going
    The search distance in duplicates pages is now synchronised across all pages--when one updates, they all do
    All the updates to potential search maintenance numbers are now routed through one cached manager. updates here are repeated less often
    Misc cleanup for duplicates page.

    Database modes:

    A new 'program launch arguments' help page now talks about all the available command line switches, here: https://hydrusnetwork.github.io/hydrus/help/launch_arguments.html
    Added the '--db_journal_mode' launch switch to set the SQLite journal mode. default is WAL, permitted values are also TRUNCATE, PERSIST, and MEMORY
    Ensured --db_synchronous_override was hooked up correctly
    The old disk cache options under speed and memory are removed, along with various deprecated disk cache load calls and code
    Fixed some shutdown maintenance check logic that was saying 'I think a vacuum is due' when it wasn't actually true
    Db_journal_mode, synchronous value, and no_db_temp_files is now shown in help->about.

    Technical database nonsense:

    PERSIST is new to hydrus, and may in future versions of SQLite be boost performance for HDD drives with larger databases (e.g. those that sync to the PTR), although unfortunately in our case (which uses multiple ATTACH databases), it seems current SQLite must ultimately treat this as DELETE, as here https://sqlite.org/atomiccommit.html#_clean_up_the_rollback_journals. damn
    Hydrus now tries to always trim WAL (and PERSIST, if it worked) journal files down to 1GB after commits (which happen every 30 seconds), so giganto WALs should clear up promptly after big work is done
    Hydrus no longer refreshes the database connection every thirty minutes, meaning WAL journal files will persist (and hopefully regularly clip back to 1GB when exceeded), which should improve some elements of long-running write performance, but may result in some surprise memory issues, we'll see
    In lieu of the db connection not refreshing, the memory database now reattaches every ten minutes, which should stop it leaking in certain situations
    When in WAL journal mode, the hydrus db now cleans up any lingering checkpointing work every half hour
    After testing and feedback from users, the database is now default SQLite synchronous 1 (down from 2) when in WAL. the db is still consistent, so sudden program stop (crash, power cut) should not result in software-caused corruption, but the database may lose more than just the last 30 seconds of work. this speeds up tag processing in an SSD test environment by approx 33%
    The 'no_wal' (TRUNCATE) and 'db_memory_journaling' (MEMORY) launch switches remain valid but are now deprecated
    Improved launch switch code generally
    Boosted cache size for each of the four db files to ~200MB-this will likely become a launch argument in future, along with some other specific db values
    The client and server no longer disconnect from the db to check whether it is possible to vacuum databases

[close]

https://hydrusnetwork.github.io/hydrus/

[SiLæncer]

A mix between an encyclopedia of movies, a video collection manager and a store catalog, this app will prove useful to all movie lovers.

Donationware

Whats new:>>

    [NEW] added 700 movies & series
    [NEW] improved the movie recommendations

http://www.coollector.com/

[SiLæncer]

Changelog

    added decades filter for movies
    added new column (audio title) in MediaInformationPanels (Movie / TvShows)
    added HDR Format filter for movies and episodes
    added movie set artwork completeness check options (like for movies) #1145
    added "_" as a colon separator in the renamer settings #974
    better error messages for SSL errors #1122
    fixed downloading trailers #1136
    detecting video resolution for certain 3D SBS files #1133
    writing of movie set artwork with a path separator in the name #1145
    smaller fixes to the movie search #1140
    fixed renaming of episode extras (e.g. extra text files)
    fixed loading of Kodi scrapers
    fixed: do not set "episode guide" tag when selecting KODI preset

[close]

http://www.tinymediamanager.org/

[SiLæncer]

Whats new:>>

    Added : Artist\Composer helper lists in the track properties.
    Added : Select Artist role to all checked albums at the audio file scan dialog.
    Added : Create log for the files that could not be processed during the audio file scan.
    Fixed : Access violation while saving an audio file album, if an audio file can't be read.
    Fixed : Incorrect sorting on the "Last played" column.

http://www.gsoft4u.com/

[SiLæncer]

Changelog

    New tag caches:

    as 2020 ended, I attempted but failed to tune fast search for all kinds of clients, big and small and simple and complex. unable to guarantee decent speeds with just code, I have redesigned the tag text search cache. rather than checking the gigantic master table for all namespace and subtag lookups, the client can now zoom in on a small fast cache limited to the current search context, so doing a clever lookup on 'my tags' will no longer be hampered by having PTR beside it, and doing a solid lookup on the PTR or 'all known tags' will no longer be accidentally hampered by an optimisation for another situation
    the 424 update will take some time to generate the new caches for your existing data. if you don't sync with the PTR, it should be a few seconds. if you do sync, it will be about ten minutes on an SSD (seems about 30,000 definitions a second), and somewhat longer on an HDD. it will count up the tags as it goes, and on the PTR there will be a bit of deletion work, then one or two counts up to perhaps a million, and then one big count up to about 16 million.
    in my initial tests, this cache adds about 1-2% additional processing time to mass tag changes, but a wide variety of tag lookups and file searches are now significantly faster, have much nicer worst-case lag spikes, and should cancel quicker. these are best in any specific tag domain, although 'all known tags' should still be much better. a future expansion of the tag cache is planned to finally address clean and accurate 'all known tags' searches

    summary; all these should be faster and cancel faster:

    autocomplete searches for 'subtag*' (most normal searches) are optimised
    autocomplete searches for 'namespace:*' are optimised, including when the namespace itself is a wildcard
    autocomplete searches for wildcards with an asterisk in the middle of the subtag are optimised
    autocomplete searches for wildcards with an asterisk at the beginning of the subtag are optimised (but this is still generally the slowest query)
    autocomplete searches for namespace and subtag wildcard combinations are optimised, with either or both as a wildcard of any type
    autocomplete searches for '*' are optimised
    tag file searches without a namespace (i.e. in file search, with any namespace) are optimised
    namespace file searches are optimised, including when the namespace is a wildcard
    wildcard file searches are optimised, for all the classes of wildcard above
    'tag as number' file searches are optimised
    'has ><= x namespace tags' file searches are optimised for speed, including when the namespace is a wildcard, but still have bad cancelability on large domains. I'll work on this more

    Other tag cache info:

    the 'tag text search cache' regeneration routine under the database->regenerate menu is replaced with a service specific routine for the new cache
    on boot, if the client sees any of the new cache tables are missing, it notifies you and regenerates the affected subsection of the cache
    an old method of performing complex wildcard searches was using surplus data and has been eliminated. these searches are now also computationally cheaper beyond the other domain-based optimisations this week
    I have identified the next bottleneck in the tag search pipeline and have a plan to speed all the above up even further, which can all be done in code
    thanks to user feedback, I have also identified other wasteful overhead in tag processing. I'll keep working!
    while the planned 'all known tags' cache will be useful since most file searches are in this domain, it will be a bit of work, so I will first let this new lookup cache breathe for a bit. 'all known tags' will not be nearly as big as the 'all known files/combined file' caches that have hit us with so much CPU recently. I expect it to increase the client.caches.db size by about 5%
    unified all increments or decrements to autocomplete count caches, no matter the service domain, to one location
    unified how autocomplete counts are fetched across different service domains
    optimised specific and combined autocomplete count cache update overhead for new, existing, and deleted tags
    optimised display autocomplete count cache updates for tags with multiple siblings or parents
    optimised the 'local tags cache', which does fast tag text fetching for local files, when new tags or files are added/removed from the 'all local files' domain. this now occurs in the same unified autocomplete count update process. it now also caches pending tags that have no current count
    merged 'exact match' autocomplete tag searching code into generalised wildcard search
    misc autocomplete and other tag code cleanup and harmonisation
    ditched some old mass UNION queries that were not cancelling well

    The rest:

    when you paste queries into a sub, the summary 'these were/were not added' dialog now always appears, and if you paste empty whitespace, it now says so
    the manage siblings/parents dialogs now specify which services apply which siblings, whether they are fully synced, the current display tag sync maintenance settings, and ultimately whether you can expect changes to apply quickly after dialog ok
    when a text entry dialog comes with suggestion buttons, it now focuses the text box by default. sorry for the trouble here! (issue #765)
    updated a couple petition reason suggestions in manage tags and parents
    added a shortcut to 'main window' to refresh manage tags' related tags suggestions with 'thorough' duration. in future, these dialog-specific actions will be moved out of 'main window', these have just been a 'temporary' patch
    updated the 'running from source' and 'install' help with some new numbers and info about mpv, and updated the 'server' help with a document helpfully provided by a user explaining that the server does not do what many new users think
    sped up 'has tags' file searches in certain situations, mostly when there are few if any other search predicates
    the default e621 parser now pulls meta tags, thank you to a user for providing this
    the default nitter timeline url classes are updated, thank you to a user for providing this
    the new little hook that takes 'file:///' off of paths pasted into the filename tagging path text now also normalises the path, so if you are on Windows, the URI's slashes will be Windows-corrected to backlashes. it also now removes wrapping quotes
    the hydrus logger again correctly restores stdout and stderr after it is closed on program exit (this was disabled for some reason, but fingers crossed it seems fine now!)
    an issue where automatically started duplicate potentials file search could not cancel when shutdown 'stop work' button was clicked or where idle maintenance mode turned off should be fixed
    the shutdown maintenance work for the first client shutdown now has a little text saying it is just some quick initialisation work
    for hopefully the last and completely final time, I think I fixed the invalid tag repair function for certain sorts of tags applied to currently local files
    improved the way a job thread was pulling new jobs (issue #750)

[close]

https://hydrusnetwork.github.io/hydrus/