Forgot Password
GS-Base
GS-Calc

*

GS-Base

GS-Base is a database that can be used for various purposes thanks to its scalability: from creating photo albums, contact/inventory lists, editing CSV/text files to processing (transforming, splitting, merging, normalizing) large, multi-GB data sets.

  • Up to 256 million records in one table; 16,384 fields in one record.
    Fast filtering CSV / text files of any size regardless of the amount of 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 12 in Excel), 256 million rows, 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 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.
  • Around 300 built-in calculation function 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 in fields, 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.
  • Dop-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 searchable history of modifications.
  • Mass-renaming, -copying and -deleting files based on filtered, auto-generated listings.
  • Performing any types of table joins and the opposite functions: easy automatic normalization (splitting) of tables with single clicks.
  • 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.
  • Editing existing files in their own file formats, in-place, for example CSV without any conversion and without any information loss.
  • 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.
  • 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 enable other users to browse/edit the rest.
  • Using SHA-256 checksums to verify whether the data stay unmodified for example when switching between file formats.
  • 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. Direct COM programming.
  • Printing serial forms, letters/reports and any type of mailing labels.
  • Sending serial personalized e-mail messages with customized attachments.
  • Verifying www 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 internet connection.
    To move it to another computer you can simply copy the installation folder containing a few files.

Version: 22.2 64-bit
File size: 6.5 MB
System: 7/8.x/10/11 64-bit
*
Trial version limitations

- or -

Download and install GS-Base using
Winget, the Windows Package Manager:

winget show GS-Base
winget install GS-Base

*
Free upgrades for 12 months or for ever

→ GS-Base HTML Online Help

→ CHANGELOG


Store any type of data and display
it in configurable, synchronized view panes.

Optional dark/night mode to reduce the harmful
blue light and to help with eye strain.

Cross highlighting to make viewing/editing
tables easier and faster.

Create complex search filters with ease. Use definable
record flags to select and look up records.

Analyze your data using pivot tables containing
up to 256 millions of rows and 16,384 columns.

Use multi-column drop-down lists with up to 256 million items based on static data
or dynamic lists containing filtered (unique) table fields values.

Use nearly 300 formulas to create calculated fields
and advanced search expressions.

Encrypt either entire files or just individual fields in your tables and allow
others to edit the data without any risk of viewing or changing the encrypted fields.

Use tables or automatic forms to browse and edit records.

Display images and objects in tables cells, forms and in the image/files view panes.

Print serial letters with embedded Memo and Images/Files fields and any type of mailing labels.

Verify up to 256 millions of files in folders or entire disks;
search for file duplicates; monitor all file changes and search them;
add any type of metadata to files and much more.

Load multi-GB CSV / text files in seconds. Use input filters to process files of any size
and any number of records. Edit, save text files in-place.
Convert fields however you want to or without any conversions.

Load / edit / save / create largest XLSX files.
Split datasets exceeding the XLSX 1M row limit however you want
and merge the result back.

Using SHA-256 checksums verify whether the data remain unmodified
e.g. when switching the file format.

Send mass email messages, each with customized form with the inserted recipients' fields
and each with individually chosen file attachments.


Loading progress.
Sample performance when opening CSV files [i9-13900, 192GB RAM]

Playing MP3's freely filtered or randomly selected from large sets.

Videos created on Intel Core i5-7500 @3.40GHz / 16GB RAM, HDD; CPU benchmark 8K [ vs 60K for Intel Core i9-13900K ]

Mass-(un)merging records from tables based on fields from CSV/text/xBase/xlsx/MySQL files.

Consolidating tables from multiple CSV/text/xBase/xlsx/MySQL files.

Finding file/photo/image/mp3/mp4 duplicates on disk(s)/in folders
using EXIF/mm tags; monitoring file changes/additions/deletions on disk(s).

Finding field(s) value duplicates, unique values, frequencies,
normalizing date/time strings (to ensure proper sorting).
(Using the 1.84GB yellow_tripdata.csv sample CSV from kaggle.com)

Inserting and managing photos/images/files in GS-Base.

Loading photos and htm files from an entire folder as a new table in GS-Base.