GS-Base is a versatile database that can be used for variety of tasks thanks to its scalability: from photo albums or video collections to analyzing very large multi-GB data sets. * Up to 256 million records in one table; 16,384 fields in one record. Any number of tables in one file; tables in nested subfolders. * Text, Numeric, Long Text / Memo fields, binary / image fields, code fields for snippets with syntax highlighting for many programming languages. * Various record filtering methods, searching for duplicates and for unique values, search-as-you-type, full-text searches, fuzzy searches and one-click statistical breakdown analysis. * Around 300 built-in calculation function used for calculated fields and data validation. * Pivot tables with up to 256 million records and 16,384 columns with advanced data calculation functions. * Definable number (1 to 100) of processor cores used for field and pivot table calculations. * Small RAM usage and great speed - you can expect importing e.g. a 1GB *.csv file in several seconds. * Easy database synchronization: (un-)merging records from other users' databases, batch database/record updates based on other databases/tables. * Fast and convenient creating the one-to-many relations, linking individual records by hyperlinks. * Easy to use JScript and VBScript scripting extending GS-Base functionality: automatic merging records or tables from folders with Excel, text and other files. Mass adding, updating, merging and joining tables from folders with several millions of records can take e.g. a couple of tens of seconds. * Printing serial forms, letters/reports and any type of mailing labels. * Sending serial personalized e-mail messages with customized attachments. * Using multi-GB CSV/text, dBase/Clipper/FoxPro, MySQL (*.sql), SQLite *.db, HTML, PDF files. * Editing existing files in their own file formats, without conversion and without changing their parameters. * 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. * Verifying www links/URLs. * A password generator. * Programmable COM interfaces to embed GS-Base functions in your own programs. * Multiple panes displaying synchronized tables, forms, memo fields and pivot tables. * GS-Base can be installed on any portable storage device and used without performing any registry modifications. * Strong standard password protection and encryption (of entire databases or individual fields). AutoSave and AutoClose. * Easy one-click optional editing of the RTF (rich text) memo field contents in external applications. * Easy one-click editing of any embedded images and files in external applications.

GS-Base

A database with spreadsheet functions and 256 million rows

A database with spreadsheet functions and 256 million rows