What is GS-Base?
GS-Base is a database with spreadsheet and ETL functions that can be used to store any type of data: text and numeric fields, dates, long text memo fields, files, images, code snippets with syntax highlighting for 16 programming languages.
It can also analyze very large data sets using pivot tables with up to 256 million rows and 16,384 columns. It features around 300 built-in calculation function in calculated fields, for data validation, cleaning and conversion. GS-Base can use from 1 to 100 processor cores when updating calculated fields and pivot tables (e.g. Excel: 11 data functions, 1 million rows; GS-Base: 25 functions, 256 million rows, full regex filtering).
The user can perform both simple and complex record filtering, searching for duplicates, for unique values and frequencies, full-text searches, find-as-you-type, fuzzy searches, searching quartiles, random searches and one-click statistical breakdown analysis. You can use unlimited in-cell charts to spot trends.
GS-Base can filter text/CSV files of any size regardless of the installed RAM. With GS-Base things like performing tables joins, normalizing (splitting) tables, merging records are easy and fast, even for millions of records.
Through its scalability GS-Base can be also useful for simple applications like organizing large photo collections and processing any EXIF tags from photos and images to find duplicates or similar objects, playing filtered/random mp3 files or listing all disk (e.g. millions of) files, monitoring file changes and adding any type of metadata to files, to clean data, transform using regex, analyze multi-GB data sets with up to 256 million rows.
GS-Base can be installed on any portable storage device and used without performing any registry modifications. It requires around 10MB of free space and it's fully offline - no internet connection needed.
It can also analyze very large data sets using pivot tables with up to 256 million rows and 16,384 columns. It features around 300 built-in calculation function in calculated fields, for data validation, cleaning and conversion. GS-Base can use from 1 to 100 processor cores when updating calculated fields and pivot tables (e.g. Excel: 11 data functions, 1 million rows; GS-Base: 25 functions, 256 million rows, full regex filtering).
The user can perform both simple and complex record filtering, searching for duplicates, for unique values and frequencies, full-text searches, find-as-you-type, fuzzy searches, searching quartiles, random searches and one-click statistical breakdown analysis. You can use unlimited in-cell charts to spot trends.
GS-Base can filter text/CSV files of any size regardless of the installed RAM. With GS-Base things like performing tables joins, normalizing (splitting) tables, merging records are easy and fast, even for millions of records.
Through its scalability GS-Base can be also useful for simple applications like organizing large photo collections and processing any EXIF tags from photos and images to find duplicates or similar objects, playing filtered/random mp3 files or listing all disk (e.g. millions of) files, monitoring file changes and adding any type of metadata to files, to clean data, transform using regex, analyze multi-GB data sets with up to 256 million rows.
GS-Base can be installed on any portable storage device and used without performing any registry modifications. It requires around 10MB of free space and it's fully offline - no internet connection needed.
Categories & Use Cases
Media
1 / 4
Screenshot of data stored and displayed in configurable, synchronized view panes.
