Messages

1

Found Deals and Discounts / GS-Base 20.3 50% discount [ 4/26/2024 - 4/27/2024 ]

« on: Today at 03:19 PM »

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)

2

Found Deals and Discounts / Re: GS-Calc 18.7 50%off for 24h

« on: March 26, 2023, 01:45 PM »

Thanks. As this was one day only and around the weekend, in case someone overlooked it and still would like to use this offer (or has any questions), please feel free to email me (for the code) on Monday 3/27 as well.

3

Found Deals and Discounts / GS-Calc 18.7 50%off for 24h

« on: March 24, 2023, 09:18 AM »

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..../watch?v=EoRQghsNZUI

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

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

4

Found Deals and Discounts / GS-Base 18.5 50%off for 24h

« on: March 15, 2023, 05:39 PM »

GS-Base - a database with spreadsheet functions and up to 256 million rows.
Pivot tables (with the same max number of rows), around 300 functions in calculated fields. Filtering (regex), searching for duplicates, for unique values, search-as-you-type, full-text searches, fuzzy searches and so on. GS-Base uses up to 100 processor cores to perform field and pivot table calculations.
Opening an over 0.5GB csv text file with 20 columns and around 3.5 million rows can take several seconds on a low end pc. Loading about 12GB MySql *.sql file with over 10 million records and Long Text (Memo) fields can take around 2 minutes. Filling a field in a 150 million record set with some 1...n sequence will take a few seconds. Same as filtering a field using regular expressions. 150 million records with four text field containing up to several characters each with calculated fields and formulas can use around 15GB of RAM.

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

dcode2e08  | 50% off [for 24 hours]

5

Mini-Reviews by Members / Re: GS-Base Mini-Review

« on: August 02, 2016, 08:14 PM »

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

6

Found Deals and Discounts / Re: GS-Calc (spreadsheet, 32- & 64-bit) 50% off till May 14.

« on: May 10, 2014, 11:03 AM »

Thanks for the discount, took advantage of the offer. I actually had a use for an earlier version a couple years ago, the row limit in Excel was too small for what I needed even though the calculations were fairly simple.

Excel 2013 still has a column advantage (16k over 4k, which is also Libre Office's limit) but Excel and Libre Office are both stuck at 1 million rows.

-x16wda (May 09, 2014, 07:36 PM)

Thanks.
Rebuilding would be sufficient to increase that limit to 16K (or to 64K max, without changing the code) in GS-Calc, but verifying that there are no performance issues for various functions/actions might take much more time.

Anyway, further increasing these (row and column) limits for both GS-Calc and GS-Base is on the todo list.

(If you would like to, please feel free to e-mail me something more about the type/size of data you're
using. Just curious.)

Best regards
Citadel5, www.citadel5.com

7

Found Deals and Discounts / GS-Calc (spreadsheet, 32- & 64-bit) 50% off till May 14.

« on: May 09, 2014, 09:46 AM »

Hi,

GS-Calc is a spreadsheet for Windows. Both 32- and 64-bit are available. 50% off till May 14.

Btw, any comments and suggestions (via e-mail, support forums or this forum) concerning the current functionality, possible improvements, other OS support etc. will be appreciated.

Main features:

• 12 million rows x 4,096 columns.
• Organizing worksheets in a tree form.
• Efficient memory usage to quickly load and save the largest files.
• Fast pivot tables, optimization and other advanced statistical functions.
• Using up to 16 processor cores during calculations.
• Working in up to 100 synchronized panes.
• GS-Calc can be installed on any portable device and used without performing any registry modifications.
• Free new versions for 12 months from the date of purchase.

Home page:  http://www.citadel5.com/gs-calc.htm
Trial version 64-bit:  http://www.citadel5.com/gscalc11.6_x64.exe
Trial version 32-bit:  http://www.citadel5.com/gscalc11.6_x32.exe
Ordering form:  http://www.citadel5.com/ordering.htm

Thanks!
Citadel5, www.citadel5.com

8

Found Deals and Discounts / Re: GS-Base - 50% off

« on: April 02, 2014, 04:35 PM »

Thanks. Yes, it's as the nick suggests - I'm the author of GS-Base.

Re: the default file format, this is a native/private ("partially binary") file format. Nevertheless it should be quite safe as all the data is stored in the zip file in its original format. That is, tables with records as plain utf-8 text files, memo files as *.txt or *.rtf files etc.
To clarify this better I just uploaded a page from the help file:

http://www.citadel5.com/help/gsbase/file_format.htm
(Just one page at this time.)

The supported file formats are listed on the homepage: dBase, Clipper, FoxPro, text, XML, Excel XML, HTML, PDF. (XML, PDF - export only.)

The coupon is valid for GS-Base licenses only.

9

Found Deals and Discounts / GS-Base - 50% off

« on: April 01, 2014, 04:44 PM »

A database with some spreadsheet features. 50% off till April, 8.

• 12 mln records in one table; 2,047 fields in one record; any number of tables in one file.
• Versatile record filtering methods, searching for duplicates, full-text searches and quick statistical breakdown analysis.
• Printing serial forms, letters/reports and any type of mailing labels.
• Sending serial personalized e-mail messages with customized attachments.
• Creating and editing text, dBase, Clipper and FoxPro files.
• Pivot tables with up to 12 mln rows.
• Around 300 built-in calculation function used for calculated fields and data validation.
• GS-Base can be installed on any portable device and used without performing any registry modifications.

Homepage: http://citadel5.com/gs-base.htm
Sample screen: http://citadel5.com/images/gsb12_scr1.png
Trial version: http://citadel5.com/gsbase12.exe  (1.85MB)