GS-Base is a high-performance desktop database adaptable to a wide range of data‑management tasks — from photo and multimedia albums, disk archives, and inventory lists to large, complex databases linking multiple tables. You can use simple filtering as well as advanced methods such as regex, formula‑based, and predefined filters to load and search tables containing up to 256 million records.
GS-Base provides super-fast native editing of CSV, text, Excel, xBase, SQLite, MySQL files, 4GB and above, opening and saving them directly without format conversion, while keeping all data in RAM.

• Up to 256 million records in one table; 16,384 fields in one record.
• Fast filtering of CSV and text files of virtually any size, independent of available RAM.
• Any number of tables in one file; tables in nested subfolders.
• Text, Numeric, Long Text/Memo fields, Image/File fields; Code fields for code snippets with syntax highlighting for 16 programming languages.
• Pivot table data functions in GS-Base: up to 256 million rows and 16,384 columns; 25 data field functions (vs. 11 in Excel), full regex filtering.
• Several record filtering methods, searching for duplicates, for unique values and their frequencies, search-as-you-type, random and quartile searches, full-text searches, fuzzy searches and one-click statistical breakdown analysis. RegEx filtering of millions of records in seconds, regardless of the number of records returned.
• Searching for file duplicates and finding similar photos, images, music, and video files using EXIF and multimedia tags, with the ability to play filtered lists of MP3 files.
• Around 300 built-in calculation functions used for calculated fields, data validation and automatic conversions of the entered text. Formulas to obtain aggregated field values and statistics from other tables. Extracting and processing EXIF tags from photos.
• Python integration. Create your own data processing functions in Python to automatically update calculated fields, e.g. to load CSV files into fields, or mass-create any charts/graphics to be displayed in GS-Base fields.
• Any number of fields/records with mini-charts (column, line and area charts).
• Instant calculation of running totals and moving averages with weights in columns.
• Definable number (1 to 100) of processor cores used for searching, field and pivot table calculations.
• Drop-down/input lists dynamically selected based on the data from other fields.
• Efficient memory usage to quickly load, edit and save large (greater than 4GB) GS-Base databases and files in other formats. → Examples.
• Loading listings of all files from folders and disks along with their metadata. Adding any type of your own metadata to any file (which can be text of any size, images, the older versions of the file itself, other files etc.).
• Monitoring file changes with a searchable history of modifications.
• Mass-renaming, -copying and -deleting files based on filtered, auto-generated listings.
• Performing all types of table joins and the opposite functions: easy automatic normalization (splitting) of tables with a single click.
• Very fast data consolidation - you don't have to bother with permanent indices; internal indices are created automatically whenever aggregation and binary lookup functions need them.
• Linking individual records by any number of hyperlinks.
• Easy database synchronization between database copies: (un-)merging records from other users' databases, batch database/record updates based on other databases/tables.
• Convenient zip/zip64 native self-describing file format enabling users to view and modify records, tables and embedded files/images even without using GS-Base.
• Using multi-GB CSV/text, dBase/Clipper/FoxPro, MySQL (*.sql), SQLite *.db, HTML, PDF files.
• Native file editing in many file formats, for example, processing CSV files without any undesirable conversions or hidden formatting.
• Loading/editing/saving Excel *.xlsx and *.xls workbooks; databases containing tables with records exceeding the *.xlsx and *.xls row limits are automatically split and saved (or loaded and merged) either as multiple *.xlsx/*.xls workbooks or as multiple worksheets in one workbook.
• A password generator.
• Strong (Twofish CFB) standard password protection and encryption. AutoSave and AutoClose.
• Encrypting either entire files or just individual fields in your tables, and enabling other users to browse/edit the rest.
• Using SHA-256 checksums to verify whether the data remains unmodified, for example when switching between file formats.
• Easy-to-use JScript and VBScript scripting extending GS-Base functionality: automatic merging of records or tables from folders with Excel, text and other files.
• Mass adding, updating, merging and joining tables from folders with several million records can take, for example, just a couple of tens of seconds. Direct COM programming.
• Printing serial forms, letters/reports and any type of mailing labels.
• Sending serial personalized email messages with customized attachments.
• Verifying web links/URLs.
• Multiple panes displaying synchronized tables, forms, memo fields and pivot tables.
• System or user-defined spell checkers for selected fields.
• GS-Base can be installed on any portable storage device and used without performing any registry modifications.
• Fully offline - doesn't need an internet connection.
• To move it to another computer, you can simply copy the installation folder containing a few files.

Back