GS-Base is a database that lets you 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.

GS-Base can be useful for both simple applications like organizing your photo collections and extracting any EXIF tags from photos to find photo duplicates or similar photos, playing filtered/random mp3 files, or listing all your disk 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.

You 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.

You can also analyze very large data sets using pivot tables with up to 256 million rows and 16,384 columns. You can use 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).

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.

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.

Home page (details, screenshots, videos, online html help):
https://citadel5.com/gs-base.htm

Ordering:
https://citadel5.com/ordering.htm
Discount code:  dc49824     valid: 4/26/2024 - 4/27/2024 (GMT)

GS-Calc is a full featured spreadsheet that can be used for editing huge files and to build complex data models with millions of formulas and GBs of data.
Worksheets and pivot tables can use 12 million rows. No limitations for using cell references to external closed workbooks.
No limitations for the number of hyperlinks. Users can add their own DLL libraries with new functions or functions replacing the default ones, with the same performance, dynamic array ("spilling") functionality and multi-core calculations. Extensive use of regular expressions in the built-in functions (Filter(), Find(), lookups) and Find&Replace functions. Automatic use of binary searching in lookup functions with any number of ranges sorted in the background.

Opening an over 4GB workbook with over 500 million cells with random floating-point numbers and text strings (8 worksheets, ~12 million rows each) should take around 30s on a low-end office pc with 16GB RAM.
Filtering (regex/operators/formulas/duplicates) a few million rows should take a few seconds (and the result can include millions of rows as well).
GS-Calc can be installed on any portable storage device and used without performing any registry modifications.

https://citadel5.com/gs-calc.htm

dcode3Gq7  50%off $9.95 [for 24 hours]  incl. free new versions for one year

12 million fast binary VLOOKUP's in GS-Calc
https://www.youtube.com/watch?v=EoRQghsNZUI

Saving/loading workbooks with 12 million rows and 100 million cells
https://www.youtube.com/watch?v=-_pn8rbfrNg

Creating a script in GS-Calc to mass-import tables from CSV/text/xBase/xlsx/MySQL files
https://www.youtube.com/watch?v=kmE1-IMInbY

Hi,

For what it's worth, my two cents to this discussion:

1. The website and every other docs clearly state that you can log on to the download page to download the latest versions for 12 months for free. And it's clear that the page always displays the latest versions only.
(I do what I can to educate users that the license doesn't "expire".)

2. Almost all old versions are still on the website. For the full versions, it's sufficient to e-mail the support, which (un)surprisingly some users do.
Trial versions dating back I guess 10 years are free downloads all the time.

3. It's ca 2MB. Not 2TB...

4. Hope that the respective modifications to the download page will be implemented rather sooner than later. It was requested by other users and it's surely is going to be helpful.

5. IMHO captcha is easy(?). An easier registration method means verifying (addresses, IPs) 10-20 spambot submissions a day. (Unless this can be done automatically for the phpBB forum.)

Thanks,
Citadel5