Show HN: GS-Base – A multifunctional database tool with Python integration https://ift.tt/yHgkdSG

Show HN: GS-Base – A multifunctional database tool with Python integration A wide range of possible use: from simple contact/inventory lists, photo albums to editing CSV/text files and processing (transforming, splitting, merging, normalizing) large, multi-GB data tables in various file formats. Text, Numeric, Long Text / Memo fields, Image / File fields; Code fields for code snippets with syntax highlighting for 16 programming languages. You can analyze, query and consolidate data, generate pivot tables, perform calculations, merges and joins with up to 256 million rows, 16K columns and 4GB+ files efficiently using even older PC's. Several filtering methods, searching for duplicates, for unique values and their frequencies, search-as-you-type, random and quartile searches, full-text searches, fuzzy searches. RegEx filtering of millions of records in seconds regardless of the number of the returned found records. Searching for file duplicates, finding similar photos/images, music and video files using any EXIF tags and multimedia (e.g. mp3/mp4) tags. Playing filtered lists of mp3's. Very fast data consolidation - you don't have to bother with permanent indices; internal indexes are created automatically whenever aggregation and binary lookup functions need them. Generating disk/folder listings and monitoring all file changes with searchable history of modifications. Mass-renaming, -copying and -deleting files based on filtered file listings. GS-Base can be installed on any portable storage device and used without performing any registry modifications. Fully offline - doesn't need internet connection. To move it to another computer you can simply copy the installation folder containing a few files. Questions and suggestions are welcome. https://ift.tt/dF9nNDa May 13, 2025 at 02:32AM