GS-Base is a database that can be used for various purposes thanks to its scalability: from creating photo albums to managing (transforming, splitting, merging, normalizing) large, multi-GB data sets.

• Up to 256 million records in one table; 16,384 fields in one record.
  When filtering and loading CSV / text files, you can process files of any size and with any number of records regardless of the amount of RAM.
• 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.
• Efficient memory usage to quickly load, edit and save large files.
  → Examples.
• Several 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.
• Pivot table data functions GS-Base vs Excel:
  Excel: 11 functions, 1 million rows;
  GS-Base: 25 functions, 256 million rows, full regex filtering.
  
• Performing any types of table joins and the opposite functions: easy automatic normalization (splitting) of tables with single clicks.
• Around 300 built-in calculation function used for calculated fields and data validation. Formulas to obtain aggregated field values and statistics from other tables. Extracting and processing EXIF tags from photos. Any number of mini-charts in fields.
• Searching for file duplicates, for duplicated photos and mp3/mp4 files; listing and monitoring all file changes on disks or in folders;
  adding any type of metadata to files and much more.
• Pivot tables with up to 256 million records and 16,384 columns with advanced data calculation functions.
• 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.
• 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/edting/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.
• Listing all files from folders and disks. Monitoring file changes. Finding file duplicates, finding similar photo, music, video files and file duplicates, filtering files by EXIF tags and multimedia (e.g. mp3/mp4) tags.
• A password generator.
• VBScript and JScript scripting (e.g. to automatically merge/split/edit a large number of tables and database files). Direct COM programming.
• Multiple panes displaying synchronized tables, forms, memo fields and pivot tables.
• Convenient plain zip file format enabling users to view and modify records, tables and embedded files/images even without using GS-Base.
• Strong standard password protection and encryption. 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.
• Optional system spell checker for selected fields.
• Support for various methods of entering Unicode characters.

• GS-Base can be installed on any portable storage device and used without performing any registry modifications.
  Fully offline - doesn't need internet connection.