Daily Bits Email

The email you entered is already receiving Daily Bits Emails!

Virus Scan for GS-Base

All About GS-Base, A Cool Database

GS-Base is a database that lets you organize photos, music, icons, and contacts, with the ability to analyze very large data sets and produce print jobs.

Our virus scan reports this website is 100% Clean View Deal

Website Malware/Phishing Scan - Citadel5

We've scanned using a variety of antivirus software and can bring you the following results.

Website 100% Clean Badges

Let your website visitors know that they can trust your download is 100% safe by using the following badges on your website.

GS-Base Virus Scan Report
GS-Base Virus Scan Report
GS-Base Virus Scan Report
GS-Base Virus Scan Report
GS-Base Virus Scan Report

What are people saying about GS-Base

Roberto Great software, the developer update this tool frequently. Really inexpensive and does the job. The plus here are the pivot tables feature. Dont think about its a bad tool because the cheap price. I own licenses of gs-base and gs-calc, both from same developer. Recomended.
Apr 19 2015 at 3:15am Copy Link
Mariusz Lewandowski Any plans for discounted bundle GSBase + GSCalc?
Apr 21 2015 at 1:45am Copy Link
Chris It seems that the downloads after I purchased are just for the trial version, I see nowhere to put the Login Password so I went to their site and have to log in with my email and the given password to get downloads to the full versions.

To BDJ ~ Your payment page isn't secure and after I purchase something, it doesn't show up as purchased anymore.
Apr 22 2015 at 12:31am Copy Link
Roberto On the top of the page you should see a login and pass form.
Apr 22 2015 at 12:44am Copy Link
Citadel5 Re: Discounted bundle GSBase + GSCalc

There are no such plans at the moment.
Citadel5 - Apr 22 2015 at 12:56am Copy Link
Pavi Johnson This program is quite fantastic! I downloaded the trial after reading very positive reviews on donationcoder: http://www.donationcoder....ic=37655.0

Put simply, the power and ease of use of this program is really amazing. The price makes it a steal.

I plan to use it as a home inventory (at first), as one can easily put thumbnails of an item in a column and the full photo in a side frame. Oh, and of course one can enter information about each item and calculate different criterion with pivot tables.

It is strange that one doesn't seem to be able to register using the trial version. I have not yet received my key having just purchased, so hopefully the process is not too cumbersome.

Best, /Pavi
Apr 22 2015 at 12:56am Copy Link
Citadel5 Thank you for your order. To download the full version(s), please go to and log onto the download page (at the top of each page),
entering the password included in your e-mail notification.
Citadel5 - Apr 22 2015 at 1:26am Copy Link
Bertie Brummel Does the GUI support other languages than English?
Is it possible to import Paradox databases?
Apr 22 2015 at 2:13am Copy Link
Citadel5 Only the English version is available at the moment. (There is a German translation done in - say - at least 50%, but I can't guarantee any publishing date.) The Paradox file format is not supported.
Citadel5 - Apr 22 2015 at 2:45am Copy Link
Bertie Brummel @ citadel5:

OK. I managed to to export from Paradox to dBase4, then to import to
GS Base. No big problem. A few questions remain:

a) The trial version refused to install to another location than C:\ ....
Is this a limitation only for the trial or the full version too?
(It makes no sense to offer the path dialogue if you can't select IMHO)
And I hate the Windows standard to throw everyting on the C: Drive ;-)

b) When I used F12 to save the imported file as a GS database, only the *zip-
format was offered. I expected *.gsb or something similar. Again a trial-
limitation? Does this conflict with standard zippers, when the zip-extension
is bound to them in system control?

c) Do you offer kind of a "family license", perhaps outside of this promotion?

Apr 22 2015 at 3:57am Copy Link
Citadel5 Ad. a) You can install it in any location. For example: on some currently plugged usb device. Please simply enter the desirable path or select it clicking the "Browse" button.

Ad. b) The *.zip and *.gsb file extensions are used interchangeably. The is the same file format. You can specify the preferred extension in the "Options" dialog box.

Ad. c) No, at the moment no such licensing is offered.
Citadel5 - Apr 22 2015 at 4:26am Copy Link
Bertie Brummel @ Citadel5:

"You can install it in any location. .... Please simply enter the desirable path or select it clicking the "Browse" button."

Exactly what I did, but nothing happened when I tried to proceed. Maybe the problem was caused by unckecking the shortcut tick box?

Ready to order :-)
Apr 22 2015 at 4:42am Copy Link
Citadel5 Could you please explain what you mean by "nothing has happened"?
Also, please make sure your Windows account has permission to access this location.
Citadel5 - Apr 22 2015 at 5:11am Copy Link
Mariusz Lewandowski Hi Citadel
Is "validation code" needed during installation the same as "Login password" I received in the confirmation e-mail? Does not work in my case :(
-- M.
Apr 22 2015 at 5:16am Copy Link
SFuji Will you have a deal on your GS-Calc?
Apr 22 2015 at 5:17am Copy Link
Citadel5 > Is "validation code" needed during installation the same as "Login password"

The "login password" included in the BDJ's confirmation e-mail allows you to log onto the download page for registered users.
The "validation code" required by the setup program is displayed on that download page just under the "Download" button.
Citadel5 - Apr 22 2015 at 5:25am Copy Link
Citadel5 > Will you have a deal on your GS-Calc?

There are no such plans at the moment.
Citadel5 - Apr 22 2015 at 5:26am Copy Link
Mariusz Lewandowski "The "validation code" required by the setup program is displayed on that download page just under the "Download" button."

Thank you!
-- M.
Apr 22 2015 at 5:33am Copy Link
Overtkill Thanks for the offer...

Does GS-Base support the importing and handling of SQL (MS & MySQL) databases? I don't see it mentioned here or on your site.

Apr 22 2015 at 8:28am Copy Link
BOB Hawkins I have gotten the validation code and download but the software will not install.
It says: Incorrect registration data...

I have copied and pasted exactly the email address and the validation code.
Am I doing something wrong?
Apr 22 2015 at 8:31am Copy Link
Bertie Brummel @ vendor:
> Could you please explain what you mean by "nothing has happened"?

In the words sense :-)
But don't worry, meanwhile I got my code and installed on another computer w/o
any problems.

@ BOB: Are you sure you did not mix password (from your confirmation mail) and validation code (from the DL site? Installation worked fine here.
Apr 22 2015 at 9:14am Copy Link
Citadel5 @ Overtkill:
Importing from SQL/MySQL is not supported at the moment. (Though connections to SQL databases were possible in some early versions.)
I'll add this to the todo list (tentatively). If you want, please feel free to add this to the "(suggested) features" section of the forum.
Citadel5 - Apr 22 2015 at 10:43am Copy Link
Citadel5 @ BOB Hawkins:
The answer was already sent to your e-mail address. If I can be of any further assistance, please let me know.
Citadel5 - Apr 22 2015 at 10:49am Copy Link
Leo User I have followed the instructions in my email as to the download process. No where along the way do I get asked for my email address or login password and it appears that once installed there is no where to enter registration information

Apr 22 2015 at 10:51am Copy Link
Citadel5 @ Leo User:
Thank you for your order. The "login password" included in the BDJ's confirmation e-mail allows you to log onto the download page for registered users and to download the full version of GS-Base.

The setup program requires your e-mail address and the validation code from the above page. It's used only once, during the installation.
Citadel5 - Apr 22 2015 at 12:05pm Copy Link
BOB Hawkins @Citadel5 - Thanks for the quick response
Apr 22 2015 at 12:27pm Copy Link
K. Christoph I'm no specialist, but I have a good feeling.
Runs on USB-stick very quick !
I'm looking for german translation.
Thanks !
Dec 10 2015 at 2:21am Copy Link
Gde Swart Great software. I bought it a couple years back, it does everything most folks need in a db. It's Tiny and Fast! Support is good and development is continuous. There is hardly any learning curve to get started and at this price it's just crazy not to try it.
Dec 10 2015 at 3:43am Copy Link
SFuji Any plans for GS-Base and GS-Calc bundle deal in future or now, like $15 for both?
Dec 10 2015 at 6:53am Copy Link
Citadel5 @K. Christoph :
Completing the German version is high on the todo list and I hope it'll be done rather sooner than later (at least re: a beta version).
Citadel5 - Dec 10 2015 at 7:07am Copy Link
Citadel5 @ SFuji:
GS-Calc was available @ BDJ last month - no other plans at the moment.
Citadel5 - Dec 10 2015 at 7:12am Copy Link
Stimpy I tried the test version on my 32bit Windows 7 but it would not install. It didn't give me any error or anything to why.
Dec 10 2015 at 12:54pm Copy Link
Citadel5 @ Stimpy:
Thanks for reporting this. Both the 32- and 64-bit trial versions files were updated a few hours ago and it seems the 32-bit one became corrupted - I'm not sure why.
It was already re-published. (The 32-bit full version is a separate/different file.)
Citadel5 - Dec 10 2015 at 1:27pm Copy Link
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Dec 11 2015 at 12:11am Copy Link
Rockfield Jam Last night I paid for this software via PayPal. Still I didn't receive registration information.
Dec 11 2015 at 1:27am Copy Link
Adi Abir I have purchased the software but when trying to Installed it I was able to key in only 8 of the 9 characters of the validation code that was sent to me so that the GS-Base 15.4 64 bit setup returned an 'Incorrecr registration data' error.

What should I do?
Dec 11 2015 at 3:14am Copy Link
Constantin Florea @Adi Abir, I just contacted the vendor regarding the issue you mention.
BitsDuJour Admin - Dec 11 2015 at 3:21am Copy Link
Citadel5 @ Adi Abir:
The validation code is displayed on the download page, below the download button.
(You can log on to that page also after the 12-month free-upgrade period.)
Citadel5 - Dec 11 2015 at 3:29am Copy Link
Ennovy This is a great deal, thanks!
Discovered GS-Base on BDJ and bought it after 1 day trial
Dec 11 2015 at 3:51am Copy Link
Constantin Florea @Rockfield Jam, I have just resent you the receipt email.
BitsDuJour Admin - Dec 11 2015 at 3:57am Copy Link
Que La @Rockfield Jam, I have just sent your receipt email. Please check your inbox and spam folders, you should receive it shortly.
BitsDuJour Admin - Dec 11 2015 at 4:57am Copy Link
Jeffrey Krzysztow Wish you would run the sale of both at the some time instead of a few months apart. Sigh..
Dec 11 2015 at 7:42am Copy Link
Ivo Stika Very good product. I have been using fox pro, bought dbase 10 (just nostalgy) last month, but this one would be my favourite app (for quick data management).
Dec 12 2015 at 1:13am Copy Link
Petr Hello to GS-Base and GS-Calc Support/Developers:

I purchased GS-Calc recently and find it a fast, light-weight spreadsheet editor. I am am now interested in GS-Base when it becomes available on BitsDuJour. But, I have a bug to report and this really needs to be fixed before I can use either of your software titles. This bug is with the Export to TXT or CSV files with GS-Calc. When I export I specify TAB delimiter and no text qualifier (I delete the " or ' character). I only want a TAB character between fields for several of my other importing needs. GS-Calc does insert the tab but also inserts {NULL} characters which crashes the import of the resulting file.

Please fix GS-Calc (and GS-Base if it has the same problem) such that exporting to CSV or TXT files has the ability to use no-text-qualifiers, only TAB field delimiters. Thank you.

On the import side, I would like to import a CSV or TXT file specifying the delimiter character and globally setting all imported fields to be TEXT type (without automatically converting numbers to a number type, or date text to a date type. I just want to import and export TEXT with my specified delimiter.

A second request is to add the feature of selectively selecting multiple rows using Ctrl-key for non-adjacent selections AND Shift-key for selecting multiple adjacent rows. If I want to apply the same text formatting, for example, to multiple rows, or copying multiple rows, I need the ability to select several at once. Thank you.
Jul 24 2016 at 12:24pm Copy Link
Citadel5 @Petr

Thank you for your previous purchases and your comments. Specifying a quoting symbol is a must because otherwise your exported text file will (potentially) not be loaded correctly by any other programs if the cells/fields contain newline/linefeed characters or the TAB itself.

Please note that this option is completely transparent to you if your data doesn't contain any TA/LF/CR characters. (The quoting symbol is simply not used in such a case.)

I assume that crashing you mentioned (when importing such exported files) concerned some other programs you have? GS-Calc/GS-Base should use correctly any quoting symbol you specify, including an "empty" symbol.
Citadel5 - Jul 24 2016 at 1:20pm Copy Link
Petr @Citadel5
When I export using MS-Access, I have the option to specify a field delimiter where I choose the {TAB} character. Then I can also choose a text-qualifier with the drop-list option given are (1) quote, (2) double-quote, or (3) {none}. This gives me the desired result.

Same with OpenOffice, I can use a {TAB} field delimiter and delete the text-qualifier. This gives me the desired result.

With GS-Calc, I can specify the {TAB} field delimiter but when I delete the text-qualifier (because I don't want a text-qualifier for text fields), I get the {NULL} characters displaying when I open the exported file in Notepad++ with the option to display-all-symbols. This exported file from GS-Calc crashes several of my programs used to import the file exported from GS-Calc.

Using Notepad++ to view the exported files exported from MS-Access or Open Office just show the {TAB} and {CR|LF} correctly (no {NULL} symbols. I can provide screen shot images upon your request.

I would be happy to test a version of GS-Calc when you provide a fix. At this point GS-Calc, which I purchased, and GS-Base which I want to purchase, are useless for me if I can't export in the same way as with MS-Access and Open Office.

I do not have a Tab character in my text fields. If I do expect a Tab, then I will use a different delimiter character. My import programs in my other apps also import any text-qualifiers, this is why I need an option in GS-Calc (like with Ms-Access and Open Office) to have no text-qualifiers. Thanks.

I want to recommend your GS-Calc to my clients, as it is much easier to use than Open Office and less costly than MS-Access. Please provide the fix to select {none} for text-qualifier while exporting with a {TAB} or other specified character for the delimiter. Thanks.
Jul 24 2016 at 1:51pm Copy Link
Citadel5 Initially, after reading your comment, I thought about adding quoting symbol validation in the "Save Text File" dialog box, but - sure - to follow users' habits the "none" option can be allowed as well.
However, let me write it again, this is a one-way export as you will lose information about cells/fields positions and contents if you set the quoting symbol to "none" (and displaying some warning might be necessary).

That change should be included in the next update. Please note that you
don't have to wait for it. If you specify e.g. ^ as a quoting symbol (or anything
else not occurring your data), the result will be the same as "none" if you
don't have TAB/LF /CR.
Citadel5 - Jul 24 2016 at 3:15pm Copy Link
Petr Maybe we should have this interaction via private email so I can attached a screen shot of the bug. Where can I email you?

Using GS-Calc, let me describe the step-by-step actions to recreate the bug:
(a) With a spreadsheet open, goto File | Save-as
(b) Select Save-as-type: (txt, csv, tsv) and enter a file name to save as.
(c) click the [Save] button. Click [Yes] on the warning about formatting dialog
(c) The Save-Text-File dialog displays. Select {tab] as CellSeparator
(d) On the Save-Text-File dialog, next the Quoting-symbol: droplist only has " {double quote} or ' {single quote} characters. But, I can save with a blank (no selection for Quoting-symbol) which exports the text file with NUL symbols displayed before and after each field (cell) when viewed with a text editor such as Notepad++ using View All Symbols. This is a BUG.

The solution is to fix the export such that no extra characters are used for the Quoting-symbol when I leave the drop-list blank. Or add a new option to the droplist called {none}. Ms-Access calls this a Text-qualifier and do have the option for {none}. OpenOffice lets me delete the Quoting-symbol. Both Ms-Access and OpenOffice export correctly. At this time, GS-Calc exports with the NUL symbol displaying in the output file. I'm happy to work with you in a private email to send you screen shot images and test a fix in GS-Calc.

If the export with no Quoting-symbol works correctly with your GS-Base, I want to also purchase GS-Base when GS-Calc is fixed. You have great software except for this minor bug. Thanks.
Jul 24 2016 at 4:49pm Copy Link
Citadel5 @ Petr
Quoting symbols are used to enclose strings containing separators, LF/CR and quoting symbols themselves.
Since you're specifying (and you should not) an empty string as the quotation symbol, it's compared against the terminating NULL in every text string and every text string in your exported text file becomes: NULL ...string...NULL.

Please:) give it a try and enter anything (not occurring in your data) as the quoting symbol and you'll have your desirable output. It's really as simple as that.:)
Citadel5 - Jul 24 2016 at 5:30pm Copy Link
Petr @Citadel5
I followed your directions, specifying a Quoting-symbol as the pipe character: |
And did get your predicted result. The pipe character does not show up anywhere.

But, I find this not very intuitive. As stated before, MS-Access has an option to select {none} for the Quoting-symbol. With OpenOffice, I can delete the Quoting-symbol to get the same result. I prefer how MS-Access does this because it is simple to select.

I understand the possibility that I have a text character that might be the same as my field (cell) delimiter. In your next version, you could display a warning, as you described earlier.

For the next version, will you add the {none} option for the Quoting-symbol in the drop-list options for both GS-Calc and GS-Base? This would make the export option more intuitive and the same as MS-Access. If 'yes', how long before the {none} option is added to each of Calc and Base?

I would like to buy GS-Base when it is on sale at BitsDuJour. Thank you for your patience.
Jul 24 2016 at 7:16pm Copy Link
Bruno User Well, well, well, so much for GS...-CALC. "I would like to buy GS-Base when it is on sale at BitsDuJour.": That was about 3 days ago around here. :-) And which is worse, I'll continue to speak about GS-Calc here...


See the discussion there ("Past Deals"). I did finally not buy, but entered reminders "Buy GS-Calc?"* in my agenda, since I've heard promises "will be done within the next months" many times, but also think that that if the promises are fulfilled (i.e. also, work without fail), paying 20 bucks in some months instead of 10 "today" will be what they call a no-brainer (and my 1-year-free-updates period will start then).

Also, I discovered that GS-Calc allows for 1024 bytes in text fields, whilst MS Excel theoretically allows for up to 32 KB in them (since "2007" version) but that's really not something you should really try to do with it, and some paid add-in that appeared on the market in order to correctly handle large text from within Excel vanished from the market rather fast, after lots of problems with it being reported.

So I think I can live with a 1024 characters limitation per text field in GS-Calc IF it's 1024 (latin) characters (including öäüéàè and such), but the dialoge which appears says "1024 bytes", so this might not be 1024 characters for languages like Chinese (which is not a problem for me, but might be for other users), but before buying, I'll trial 1024 accented characters within a text field, too, since if they counted for several bytes, the "1024 limit" became unpredictable.

* = I hope I'll be able to trial again, since trial is 30 days, and I de-installed after 2 or 3 days; not every program allows for re-trial at all in such a scenario.


I have read the above conversation with the utmost interest, since the problem discussed there concerns me (but I didn't get that far in my GS-Calc trial after deciding to wait some months before trialling again, and thus didn't discover the problem for myself).

Petr (who obviously does not have read the GS-Calc conversation just days before) seems to use the spreadsheet for tasks similar to the ones I do there, more or less "text analysis", but for texts containing numbers so as text editors alone not doing the trick. Let me explain. More-or-less** defunct askSam (search for it here, in the "Search for Software" field, for more information) was the only text processing software of my knowledge that was able to easily process numbers in texts, too, by its means of virtual (and even implicit) "fields" which were in fact processed as "number x near text a", allowing for searches / selections like "if the postal code (the number of employess...) in the record in question is GREATER (or lesser) than y, then it's a hit" - try to do this with text editors, even with KEdit (which allows for forther processing of (JUST!) the lines which are "hits" for a search, as a group):

You can try to do this with regex, but regex was never intended for processing numbers, i.e. for evaluating if a given number is greater or lesser to another, given one, so you CAN in fact do this with regex, but it's an incredible chore.

Hunce the interest in doing some of the work within a spreadsheet, and then it's important for import AND export being smooth (and as said, I had only trialled import), and it goes without saying that if you use a spreadsheet in the aforementioned way, you need cell delimiters (tabs, or the above-mentioned pipe character), but you don't need to enclose cell content (with spaces or not) in (single or double) quotes; of course, your script could easily delete unwanted quotes, but then, before import already (and not only on export, as mentioned by Petr), your script should identify "natural" (double or single) quotes (i.e. those which might be included within the original texts), and defuse them, so as they won't compromise further processing.

** = Well, (among others, perhaps,) some German website continues to offer a German version 6, it seems.


I want my remarks - I only take time to discuss software I'm highly interested in - to be as constructive as possible, also marketing-wise (here: "Very useful for processing texts containing numbers, too, since..."); otherwise, it would be outright paradoxical to mention little flaws just for software I want to promote, when "leaving alone" software I might have a low opinion of. Thus, I'm looking forward to the next months in GS-Calc development! (Hoping that it's 1024 characters for European languages, not 1024 bytes!)

Well, so much upon GS...CALC here. ;-)
Jul 25 2016 at 3:52am Copy Link
Citadel5 @ Petr
Yes, like I wrote above, it'll be changed/corrected in the next update. I think it should be published in 3-4 weeks.

If you don't need quoting symbol you may also consider the fixed-width text export/import. Unlike the "none" symbol that you want to use, it'll preserve the information about the data structure when reading/importing it back.
Citadel5 - Jul 25 2016 at 4:02am Copy Link
Citadel5 @ Bruno User
As always, thanks for comments.

That's correct - in GS-Calc it's 1024 byte limitation as internally strings are stored in UTF-8.
(In GS-Base it's 8K for the plain text field and theoretically up to 2GB for Files/Memo fields. "Theoretically" because the GS-Base max. 2GB *.zip database file size matters.)
Note that GS-Calc displays a warning when you try to exceed the 1K UTF-8 limit.

Will consider consistently increasing that limit to 8K in GS-Calc as well, though
at the moment the performance has the highest priority (where GS-Calc is used
e.g. to deal with tens millions of cells or more) and it may take more time to optimize.

Yes, you can "re-trial". Neither the trial nor the full version leave any "traces" after de-installation.

Ad. 2)
Yes, both GS-Base and GS-Calc handle text quoting correctly. No unnecessary quoting symbols and the inner ones are doubled.

In GS-Base there are several filter types for numerical data as well and the default one for numeric fields is the "equal" relation. You can also use formulas for filtering/searching.
Filtering added to GS-Calc will be similar.

Ad. 3)
Ok. No reason not to post GS-Calc questions on the BDJ GS-Calc page. They will be answered as well. And - of course - there is the support forum.
Citadel5 - Jul 25 2016 at 4:57am Copy Link
Tim Parsons Just a small note, as I'm already a happy user: in case the above exchanges didn't give it away already, the developer is a committed and responsive person who fixes bugs very quickly and has added features and facilities to the program that have made it, for me, an absolute must-have for non-SQL database applications.Excellent, fast and -- subject only to available RAM -- capable of handling the biggest .DBF files I've needed to throw at it.

And it runs portably.

I don't think there's anything else out there that even gets close, when you consider the price and the fact that you don't have to learn SQL to use it.
Jul 27 2016 at 10:02am Copy Link
William W. Geertsema Purchased and installed the program, which showed to be a trial version.
Using my e-mail address and the receipt email Login Password, I had downloaded the program (apparently a trial version) and from the same download page I had obtained the Validation Code.
When running the program, I could find no way to register. I assume that perhaps my e-mail address and the validation code are required for registering, but I could not find a way to do this.
Please let me know how to proceed.

William W. Geertsema
Jul 27 2016 at 2:58pm Copy Link
Harold User Also problem registering. Under 'Settings' in program, choice is offered to register or unregister. When I choose 'register' message appears stating do not have permission to update the registry database !??!

Whats happening here?
Thanks for any help.
Jul 27 2016 at 3:27pm Copy Link
Citadel5 @ William W. Geertsema
If you're correctly downloading the full version(s) file from the download page for registered users after logging on to it, you already have the full version that doesn't require any further registration. In the setup window, you just have to enter that validation code.
If your system run some previously downloaded trial setup file instead of the full version setup, you may try to clear your browser cache and re-download the full version.

@ Harold User
Same as above, you just need to download the full version and enter the validation code in the setup window (offline). No other registration procedure is required.

The "(Un-)Register GS-Base *.gsb File Type" commands are used simply to (optionally) register/unregister the *.gsb file extension and associate it with GS-Base. It's necessary if you want to start GS-Base and open a database via double-clicking (a database file).
Citadel5 - Jul 27 2016 at 4:31pm Copy Link
Petr @Citadel5, I am buying GS-Base today. I assume it has import/export of text that is the same or similar to GS-Calc. Will you also be adding the {none} option for the Quoting-Symbol droplist options (in addition to the existing single-quote and double-quote)?

In Ms-Access I can define the table such that I set each field as 'text' type. Then when I import CSV or TXT files, it forces everything to be treated as 'text' type fields, even numbers are imported as text (which is my requirement). Please confirm or comment? Thank you.

Also, about licensing. Can one purchase be installed on two of my own personal computers (desktop and laptop)? Thanks.
Jul 27 2016 at 5:12pm Copy Link
Citadel5 @ Petr
1. Yes, there'll be similar updates for both GS-Calc and GS-Base.
2. Yes, there are the "Convert text to dates" and "Convert text to numbers" check boxes in the "Open Text File" dialog box.
3. Yes, one license entitles you to install it on your desktop and laptop.
Citadel5 - Jul 27 2016 at 5:50pm Copy Link
PC USER Dear @Citadel5
Can one run scripts using GS-Base? That is add loops, conditionals or even write functions/procedures using the various script functions in GS-Base?

If not, are there any plans to add scripting to GS_Base?

Also, does GS-Calc have scripting?

Thank you
Jul 27 2016 at 6:20pm Copy Link
Harold User It would have been much easier to install if there were information that the trial version would not upgrade to paid without uninstalling and re-downloading the program.
Jul 27 2016 at 9:56pm Copy Link
Bruno User Re GS-CALC (not: GS-BASE) again: Hello,

Thank you for your kind answer. For info: Some googling told me that in regular cases, in UTF-8, basic ASCII characters (like a...z, A...Z) take 1 byte, accented characters (é,ä...) take 2, Chinese characters take 3 to 4; problems might arise in special cases where the original text is not UTF-encoded, then UTF-8 may take up to 6 bytes for special characters.

Thus, for English texts, a reasonable estimation would be near to 1024 characters per cell, for Continental European texts around 850 per cell, for Asian texts the traditional 256 characters; for most real life uses in Europe even for "text-with-numbers crunching", that would be sufficient, and I also understand your speed argument.

What the GS offerings both would need - and other questions in both threads show this, too, I think, is a comparison table, like the ones we know for standard / "prof." software offerings, NOT in the line of "functionality x: Calc: elaborate, Base: basic" or for functionality y vice-versa, but giving the number of the respective functions in every respective area, with some comments for important aspects/functionality, i.e. rather detailed (and even, for lesser functionality, with "(to be amended)", in case. Since I seriously suppose that more than one prospect will loop at both descriptions and then not decide themselves, for lack of quickly-available differentiation (i.e. without trialling both), and go back to MS Excel (well, there are not many of other spreadsheets left (even lesser if you discard the ones that come within a big package only), even the wikipedia comparison table mentions defunct ones within the non-defunct group). That had been my reaction at least, some time ago. ;-)
Jul 28 2016 at 2:50am Copy Link
Citadel5 @ PC USER
GS-Base currently doesn't use any internal scripting. However, if you mean some additional data processing only, it can be done with any external programming as the database file is a zip file with a simple structure containing tables as text files, memo data as rtf or txt files and other objects as streams with their original data.

There are no plans re: scripting in GS-Base, but if you have any specific applications potentially requiring scripting, please send them to the support address or forum.

Yes, GS-Calc supports JScript and VBscript scripts. (See the sample GS-Calc screens.)
Citadel5 - Jul 28 2016 at 3:02am Copy Link
Citadel5 @Harold User
You can install the full version "over" the trial and vice-versa. No uninstalling is necessary. Both file names are the same so perhaps there were some problems with the browser cache or some download manager.
Citadel5 - Jul 28 2016 at 3:06am Copy Link
Citadel5 @Peter R
The current version number is 15.7.2. There was a minor, cosmetic change after 15.7.1 and it was initially available as the full versions only.
If you already own 15.7.1, you can simply log on to the download page to update.
Citadel5 - Jul 28 2016 at 3:10am Copy Link
Citadel5 @ Bruno User
Yes, your estimations re: UTF-8 in GS-Calc should be correct.

The current descriptions and screens generally should already focus on what seems to be the most important/helpful features of both programs. There are some plans for (adding) some more detailed information with benchmarks.

If you meant comparing GS-Base with GS-Base: despite some similarities (concerning interface elements and calculation fields vs formula cells), GS-Base and GS-Calc offer significantly different functionality. Comparing a database with a spreadsheet might be more useful for some specific application and data only.
Citadel5 - Jul 28 2016 at 4:12am Copy Link
Steven Avery Nice Program. Good review on Donationcoder. I've used ListPro some for these simple quick flat-file database, but I can see that GS-Base is more robust, e.g. in printing and other areas like the pivot table and maybe some table relations.

While still seeking to maintain that ability to design quick and read quickly, without falling into the vortex of a full-blown heavyweight, which is often overkill.

Ready to roll.

Jul 28 2016 at 11:11pm Copy Link
Christopher User I was lucky enough to stumble across the GS class of software (Base and Calc) while looking for a software to handle large amounts of tabular data; data in excess of the 1 million row limit in Excel. I quickly tested GS-Base and found it to be very fitting for my needs. There was one limitation that prevented me from moving forward with my implementation in which I reached out to support for. Support was/is top notch! They replied timely, discussed the options and in less than a week had a feature implemented to meet my needs in the software. Since that first interaction their support has continually worked with me to ensure the product(s) are meeting the requirements I have; even to the extent of adding additional features. The software is simple, FAST and lightweight. I have imported 4GB+ CSV files without issue in a matter of minutes all while maintaining a file footprint a fraction of the size of Excel (without the Excel limitations!). I highly recommend both GS-Base and GS-Calc as well as the entire Citadel team; they are top notch!
May 9 2017 at 10:00am Copy Link
Citadel5 @Christopher: Thanks a lot for your kind comments.
Citadel5 - May 10 2017 at 12:16pm Copy Link
Gunderic Hagen Which of these two statements is correct?

GS-Base is licensed per computer, and not per user.
Each license allows installation on a single computer and a laptop.

In short, can I download it to my PC and my laptop?
Jul 26 2017 at 4:35am Copy Link
Citadel5 @Gunderic Hagen
Yes, the license text included with the program contains the following:
"If you own both a stationary pc computer and a laptop,
you can use the SOFTWARE on both at the same time"
Citadel5 - Jul 26 2017 at 7:23am Copy Link
Gunderic Hagen OK, I bought it and downloaded it to my Laptop. Tomorrow I will download it to my PC, I assume, using the same license data. The only weird thing is that when I click on the icon on my desktop to open the program, I get D:\My Documents\ How can I change this?
Jul 26 2017 at 7:50am Copy Link
Citadel5 @Gunderic Hagen
If you mean a screen like this:

it's the list of recently used databases. You can manage it via the context menu. The sample "" database containing several tables is included with the program. You need to create your own databases.

(BTW, unless you plan to browse/edit the databases with any other 3rd party tools, it's recommended that you change the "default file extension" option to "*.gsb" to prevent Windows from indexing such zip's which can contain e.g. thousands of memo text streams.)
Citadel5 - Jul 26 2017 at 8:43am Copy Link
Gunderic Hagen I thought that clicking the icon would open the app, however, I get first said page and only clicking on the link mentioned is when the app. opens. Is this the way it is supposed to be?
Jul 26 2017 at 8:58am Copy Link
Citadel5 @Gunderic Hagen
Yes, clicking the application icon opens the application. Then you can choose which file you want to open or create a new one.
Citadel5 - Jul 26 2017 at 12:11pm Copy Link
Ben User Hi, so you aren't offering a lifetime license for GS-Base like the one you had for GS-Calc?
Jul 26 2017 at 1:30pm Copy Link
Citadel5 @Ben User
All licenses are "lifetime", but - correct - free upgrades are available for the first 12-13 months.
If you're satisfied with the development/progress and features, after e.g. a year or two you can upgrade @50% off to the license with lifetime free upgrades.
Citadel5 - Jul 26 2017 at 1:56pm Copy Link
_*_ @Citadel5, would you mind stating how much a lifetime upgrade license is presently at 50% off? Thank you
Jul 26 2017 at 5:42pm Copy Link
Citadel5 @ _*_
It's $18.00.
Citadel5 - Jul 26 2017 at 5:57pm Copy Link
Gunderic Hagen @Citadel5
Actually, I don't think this is working as you say. Once I click the icon I get an empty page with only: D:\My Documents\ Shouldn't I get the normal welcome screen of the app., and only then look for data base examples, create a new one, etc.?
Jul 26 2017 at 9:25pm Copy Link
Citadel5 @Gunderic Hagen
Don't know what you mean by "empty pages" or "welcome screens". Neither of these things exist in GS-Base.
To avoid misunderstandings, I would suggest that you e-mail to Citadel5
some screen shots showing what you mean. I'll gladly help then.
Yes, you can re-install it (not changing any default setup folders/settings unless you're sure what you're doing is correct).
Citadel5 - Jul 27 2017 at 4:21am Copy Link
Mike Lively How do I order the software and the lifetime updates? I don't see a way to add the lifetime updates to the order page. It just shows the $9.95 price for the software.
Jul 27 2017 at 6:51am Copy Link
Citadel5 @Mike Lively
As I wrote above regarding this standard offer:
"free upgrades are available for the first 12-13 months. If you're satisfied with the development/progress and features, after e.g. a year or two you can upgrade @50% off to the license with lifetime free upgrades."
Citadel5 - Jul 27 2017 at 7:51am Copy Link
William W. Geertsema I am puzzled as to which version is offered here. Yesterday I bought and installed the version announced as 15.8.6 at that time. Today the announcement reads 15.8.7. The version I received and installed is, however,

Are you offering 15.8.7 or 15.8.6 or ?

Can I now download and get a validation code for 15.8.7 ?

William W. Geertsema
Jul 27 2017 at 10:38am Copy Link
Citadel5 @William W. Geertsema
Yesterday morning, before this promotion started, GS-Base 64-bit was updated from 15.8.6 to 15.8.7. BDJ updated this page a few hours later.

GS-Base 32-bit 15.8.4 remains without updating at this time.

Edit: I double-checked this and the 64-bit version was updated 2-3 hours after the promotion started. Sure, you can (should) login and re-download whenever there is any update.
Citadel5 - Jul 27 2017 at 12:22pm Copy Link
HJ B I purchased this software and downloaded it using my email address and the password that were sent to me. I then installed the program and when I installed it, the program asked again for my email address and the password. Following entry of them, the program refused to proceed, and kept telling me that the email address or password were incorrect. Therefore, have not been able to implement the program.
Jul 28 2017 at 2:38am Copy Link
Virginia User Thanks
Jul 28 2017 at 2:39am Copy Link
Citadel5 @HJ B
The "login password" included in the BDJ's confirmation e-mail allows you to log onto the download page for registered users.
The "validation code" required by the setup program is displayed on that download page just under the "Download" button.
Citadel5 - Jul 28 2017 at 5:43am Copy Link
Mappi75 New deal soon ?

Oct 6 2017 at 6:12am Copy Link
GC Thanks for offering the lifetime - bought it!


in my account (citadel5) i can't dowload the newest files:

Full Version: 16.8 64-bit
Full Version: 16.6.1 32-bit

(Download Buttons are greyed out)

Only the links on the right side works for downloading:
Full Version: 16 64-bit (its only offering version 16.0.1)
Full Version: 15.8.8 32-bit

Why i cant download the newer files?

Thanks for helping.
Dec 15 2017 at 6:33am Copy Link
Peter Dr Hi GS people:

Like Bright Spark, I also bought the lifetime licence version. However, the confirmation email at the top ways:

GS-Base - Lifetime use with Lifetime Upgrades v16 - PC
But then, under Registration Information

is this phrase

Upgrades to future versions of the software will be free for 12 months. For versions after that, upgrades will require additional payment, which will be discounted

So it looka as if I paid for the Lifetime Upgrades, but only received the Lifetime use with 1 year of upgrades.

Could you clarify the licence email?

Thank you
Dec 15 2017 at 9:08am Copy Link
Citadel5 @GC
That is correct. The newest GS-Base versions are 16.0.1 64-bit & 15.8.8 32-bit.
GS-Calc download buttons are greyed out because you purchased GS-Base here, not GS-Calc.
Citadel5 - Dec 15 2017 at 9:16am Copy Link
GC @Citadel5

ah..ok yes you are right - my mistake - sorry!

@Peter Dr

My email confirmation look like yours 1 year (purchased lifetime).
Dec 15 2017 at 9:16am Copy Link
Citadel5 @Peter Dr
I was told that this was a technical limitation in the Bitsdujour ordering system and the text had to be the same for both license variants. I can't do anything about it.
Still the BDJ confirmation e-mail subject contains the correct license type name and - of course - everything is always registered correctly on my side @Citadel5.
Citadel5 - Dec 15 2017 at 9:24am Copy Link
Peter Dr Thank you Citadel5!

I will enjoy it for a lifetime now :)
Dec 15 2017 at 10:37am Copy Link
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Dec 16 2017 at 12:11am Copy Link
martian User I have buyed few month ago. I tried to use email function, but I could not[with different email setup]. I tried to ask on citadel forum, but nobody answer...
Dec 16 2017 at 3:58am Copy Link
Bertie Brummel It's unbelievable, but it seems the folks at BDJ will never learn to
handle things in an appropriate way for PayPal buyers.
Instead of using the customers real ID as provided by PayPal, they
always register the license to the alias the buyer uses for BDJ.

I'll pass future offers if BDJ handles payment.
Dec 16 2017 at 8:53am Copy Link
Citadel5 @martian
There are no unanswered questions on the support forums. Rarely it may take up to a few days before an answer is posted.
You didn't post anything on the forums (re: e-mails). I'm not entirely sure whether it's you, but from what I saw one user sent 5 e-mails @Citeadel5 on 28-30 July, concerning SMTP configuration and date field formats in e-mail forms.
All were answered within a few hours and you're asked to send any further questions if something's not clear (and you didn't).
Will gladly try to help if you e-mail Citadel5 with what (still) needs any clarifications.
Citadel5 - Dec 16 2017 at 9:32am Copy Link
bvssunnydale Hi, does GS-Base allow for thumbnails? (I'm thinking of using it to organize/track videos & music). Thanks.
Aug 24 2018 at 3:58am Copy Link
Citadel5 @ bvssunnydale:
Hi, images can be optionally displayed and printed as thumbnails.
Citadel5 - Aug 24 2018 at 4:54am Copy Link
smgcircle Hi. Is it possible to save searches so that they can be run again? Thanks.
Aug 24 2018 at 5:03am Copy Link
Citadel5 @ smgcircle:
Hi, yes, expressions used as field filters can be saved as named search keys for future use.
Expressions and text strings used in full text searches ("Find&Replace") are saved as "recently used" lists.
Citadel5 - Aug 24 2018 at 5:16am Copy Link
smgcircle Thanks! I've created several search keys. Is there some way to display the names alphabetically?
Aug 24 2018 at 5:31am Copy Link
Citadel5 @ smgcircle:
The list of keys can use just the default display order at the moment. However, it shouldn't be a problem to add that option in the new version.
Citadel5 - Aug 24 2018 at 10:24am Copy Link
Jester Are there any example databases that we could play with while we are learning about GS-Base for those of us that don't have a database background? I know this would be a valuable tool for me, but have not taken the time to research the manual. Just some examples to help jump start the process would be very nice. I have not found any examples by searching with Google. By the way, I have purchase the GS-Base.
Aug 24 2018 at 7:32pm Copy Link
Peter User I am interested in the password security / encryption option in GS-Base. Accoring to the manual for version 16 :

'All encryption parameters are saved in the META-INF/manifest.txt text stream in the database zip file.
If the database zip file is encrypted and you still want to manipulate some its data manually without GS-Base, using Windows Explorer, you must not alter the META-INF/manifest.txt file in any way or you'll risk loosing the data.'

Does this mean that the manifest.txt file contains sufficient information to decrypt the data? I am concerned that a hacker would just need a copy of the zip file to view the data (even if encrypted).

Also what is the MAXIMUM password length - the manual just states the minimum of 6 characters.

Many thanks
Aug 25 2018 at 12:57am Copy Link
Citadel5 @ Peter User
If you do not divulge your password, your data is safe. It's a common practice to include the encryption parameters to enable other programs/tools to access the data safely thanks to the standard encryption key derivation method and the standard data encryption algorithm. So, on the contrary, this can make your data safer.
The password here can contain up to 63 characters. Usually a 6-8 character password with mixed character types is considered safe.
Citadel5 - Aug 25 2018 at 3:35am Copy Link
Citadel5 @Albert Jester:
The included sample database shows using text and numeric data, calculation fields, lookup links between tables and pivot tables. It seems it should be sufficient to start creating your own databases quickly.
Anyway, please feel free to contact the support if something's not clear.
Citadel5 - Aug 25 2018 at 3:55am Copy Link
Alan Just saw this. Don't have time left tonight to review. Hoping offer is extended one more day.
Aug 26 2018 at 6:22pm Copy Link
Peter User Thanks for the reply. I will be buying GS-Base when it is next on offer
Aug 27 2018 at 12:00am Copy Link
Lexadis Hi, Is it possible to write a formula with sumproduct with one or more field with criteria (=, >, <>, left) but on all records?
Aug 30 2018 at 4:16pm Copy Link
Citadel5 @Lexadis
In brief, it's not applicable to the 'sumproduct' function. Only functions from the 'cross-table(…)' group can process all records at once. Nevertheless, with all filtering functions, you can create a calculated 'product' field and a simple one-field pivot table. You'll be able to obtain those sums with a single click for filtered records.
Citadel5 - Aug 31 2018 at 12:48pm Copy Link
Harald Vogel Hi, I'm currently on Version 15.8 and would like to upgrade to lifetime. Do you have also an offer for that today? Thanks.
Jun 20 2019 at 6:41am Copy Link
Citadel5 @Harald Vogel
Hi, yes you can upgrade to the license with free life-time upgrades at any time @50% off. The rebate codes are usually included in the new version notifications. I just sent you an e-mail with that code.
Citadel5 - Jun 20 2019 at 7:22am Copy Link
Stephen Warkentien Is there a demo version? Usually it is posted on this page.

Does it have the capability to import & export CSV or other database formats?
Jun 20 2019 at 3:23pm Copy Link
Citadel5 @Stephen Warkentien
Yes, there are several supported formats (plus options like importing a zip archive with a collection of text files all at once). You can efficiently process e.g. multi GB text or xBase files.
Citadel5 - Jun 20 2019 at 3:52pm Copy Link
Stephen Warkentien I'm looking for a JOIN function. I could not find a reference to one. Does SET RELATION do something similar? Where are the instructions for that tool? I could not find a reference in the help files.

Thank you, Stephen
Jun 20 2019 at 7:17pm Copy Link
Citadel5 @Stephen Warkentien
The "Set Relation" here might be more useful for the 1:n relation. For the 1:1 relation you can also use the =vLookUp_ex() function in calculated fields in the target table. Please see the included "sample" database file and the "orders" table. Other "cross-table" functions include conditional counting, summarizing. Their descriptions and examples are available in the "Field Setup" window.
Citadel5 - Jun 21 2019 at 12:28am Copy Link
No Name @Citadel5 - I'd also like to upgrade to the lifetime as I have a prior version. How would I get that code?
Jun 22 2019 at 8:21am Copy Link
Citadel5 @No Name
If your e-mail address hasn't changed, you can still have the latest update notifications with your rebate code, perhaps in the spam folder. Otherwise, please email Citadel5.
Citadel5 - Jun 22 2019 at 9:28am Copy Link
RichU Can this database capture scanned bar codes to create and populate a database of herbal supplements? Any other ideas?
Jun 22 2019 at 4:23pm Copy Link
Citadel5 @RichU
GS-Base doesn't support scanning bar codes from video streams, if this is what you mean. If you have more detailed questions/suggestions, please feel free to email Citadel5.
Citadel5 - Jun 22 2019 at 6:28pm Copy Link
Kathryn User I bought the full version of this and I am unable to find the download link, any help would be appreciated.
Jan 24 2020 at 3:04am Copy Link
Citadel5 @Kathryn User
To download the full version(s), please go to and log in using the form at the top of the page. Your password is included in your order e-mail notification.
Citadel5 - Jan 24 2020 at 5:42am Copy Link
Kathryn User Brilliant thank you, that worked.
Jan 24 2020 at 8:02am Copy Link
Michel G. Pensis Hi!

There is no password in the advertising email I received from BdJ.
Therefore it is impossible to connect to the site ...

Mar 1 2020 at 2:52am Copy Link
Constantin Florea @Michel G. Pensis, If you purchased the product through BitsDuJour please contact us at with your order information. I couldn't find any GS-Base orders associated to the email address of the BitsDuJour account you used to put your comment above. I also checked your purchases page and I don't see any orders in there for GS-Base.

Perhaps you purchased it using another email address?
BitsDuJour Admin - Mar 1 2020 at 6:31am Copy Link
Lee User Been using this for ages. Absolutely brilliant, bit of a learning curve, but well worth the effort. VERY fast, and small file sizes
May 23 2020 at 6:00am Copy Link
Mitchell User Is this truly a relational database? Is it capable of creating all the standard relations between tables: one to many and many to many and many to one? If so, how? I really want to support this apparently responsive developer, but not at the cost of abandoning table relations.
Jul 9 2020 at 3:17am Copy Link
Citadel5 @Mitchell User
Hi, you can set the 1-n relation between two tables as described in the "Linking fields in two table by the 1-n relation" help topic.
The n-1 or 1-1 relations (possibly for more than 2 tables) can be "simulated" by the use of calculated fields (with the lookup functions performing searching in other tables - please see the included "sample" database and the "ProductName" and "UnitPrice" fields in the "orders" table).
GS-Base is not advertized as a relational database - it just offers the above features "by the way" (for more convenient data analysis).
Citadel5 - Jul 9 2020 at 4:21am Copy Link
Peter User Lifetime upgrades option is not 50% off as advertised. Full price is $36, offer is $21.60, 40% off. Please correct the description.
Jul 9 2020 at 4:59am Copy Link
Constantin Florea @Peter User, During promotions it is possible that we use different discount perecents for different purchase items within the same promotion.

At times, vendors only want to promote only the 1 year license using the 50% discount thinking the 50% discount is to high for the Lifetime license. So in order for us to be able to bring you the Lifetime license at a discount in such cases, we discuss with those vendors about using a different (lower) discount percent.

But it is ultimately up to each vendor to decide which discounts he wants to use for promoting his products (and product licenses) on our site.
BitsDuJour Admin - Jul 9 2020 at 5:32am Copy Link
Peter User I have no issue with the vendor offering a lower discount for lifetime licences, however advertising should be accurate - most people would think the 50% applies to both licence types, which is incorrect. My comment was about the honesty and transparency of the advertisement, not the vendor's commercial decisions.....

BTW - I have purchased the lifetime upgrades option!
Jul 9 2020 at 11:02am Copy Link
Mitchell User I have a question about "nesting" tables or more broadly hierarchical tags. "Rock" is a genre of Music. "Classic Rock" is a subgenre of "Rock" "60's" is a subgenre of "Classic Rock" and "Psychedelic Rock" is a ....I assume that I can create tables for all of these genres and subs, but how can I nest them. I assume that I can create an autoincrementing primary key for each table but then can I use those keys as foreign key fields in a related table?
Jul 10 2020 at 2:44am Copy Link
Citadel5 @Mitchell User
The "nesting" term refers here to the tree structure with folders and tables (the left pane on the sample screen shots). You can use any level of nesting within that structure. I'm not sure whether you mean something else. If this is about records with individual tracks, albums or artists, perhaps you should consider storing them all in one table with the "genre(s)" field as all other fields are the same. Then you can create a separate "genres" table and use the field with genre names to automatically populate the corresponding drop down list (with multiple selections for cross-genre items) in the first table. Finally, created/named search keys will enable you to filter that table with "one" mouse click.
Citadel5 - Jul 10 2020 at 5:08am Copy Link
Peter User I placed an order over 24 hours ago and have not received any registration info. Checked my junk mail and it is not in there.
Jul 10 2020 at 10:36am Copy Link
Citadel5 @Peter User
Thank you for your order. Is this the e-mail address @hotmail? The registration e-mail was sent a few minutes after your last edit/post yesterday. It's sent automatically by the server so it might be treated as spam. I've just re-sent it using an e-mail client this time.
Citadel5 - Jul 10 2020 at 12:11pm Copy Link
Peter User Yes, adress is
Still no email with registration info. Checked spam, not there. I received my BDJ receipt immediately after the purchase, but it said registration info would be sent manually within 24 hours....
Jul 10 2020 at 2:03pm Copy Link
Citadel5 @Peter User
I've re-sent it again using a Google account this time. Yes, like I wrote it was sent immediately, several minutes after you received the BDJ receipt. "Manually" means just that Citadel5 needs to receive a similar e-mail from BDJ first, but the registration message is sent directly by the server/script.
Citadel5 - Jul 10 2020 at 2:55pm Copy Link
Peter User Registration info now received. Thank you.
Jul 10 2020 at 11:49pm Copy Link
Flyfisher Does it have a runtime if you wanted to build and distribute an application?
Sep 23 2020 at 12:34am Copy Link
Citadel5 The nearest update should add a dual COM interface to access the database (non-GUI) functions from other programs. However, there is no separate runtime. Either the full or the trial version will have to be present.
Citadel5 - Sep 23 2020 at 2:32am Copy Link
Flyfisher Do you have a reseller scheme where an application is developed and then sold multiple times?
Sep 23 2020 at 2:50am Copy Link
Citadel5 Just plain reselling options. For details/examples, please contact Citadel5 directly.
Citadel5 - Sep 23 2020 at 4:17am Copy Link
Terry User Can sorts and searches be saved fo later use?
Dec 8 2020 at 1:39pm Copy Link
Citadel5 You can save the current search criteria as a (named) search key. (On the sample screen shots, please see the "Search Keys" drop-down menu on the 1ts toolbar.)
Individual recently used search expressions for both the standard filtering method and full-text searches/replacements are available via the drop-down lists attached to the corresponding edit fields.
Saving compound sort keys is not available though when you save and re-open a database, the last used record set, all search expressions and sort order are restored.
Citadel5 - Dec 8 2020 at 3:17pm Copy Link
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Dec 9 2020 at 12:11am Copy Link
Meindert Jorna Found a question from a few years ago about SQL import - Answer was about possible upcoming feature. On the website I cannot find any update about this option. How can GS base be used to develop or design a database which could me used in a mysql environment or is there an import option (CSV - SQL)? So could this tool in any way be helpfull in maintaining a mysql based database?
Dec 9 2020 at 12:52am Copy Link
soo mi @Citadel5:

Does your licensing cover both the 32-bit version and the installed 64-bit version? I ask this because my laptop runs on Windows 10 Pro (64-bit), but, there are times when I am constrained to using systems provided by my customers (often older 32-bit systems), due to security issues, proprietary knowledge issues, or both, which would require me to run GS-Base from flash drive. Therefore, would you recommend buying the 32- or the 64-bit version? And, what are the performance / capability differences between the 32- and 64-bit versions? What would I lose by purchasing the 32-bit version (v15.8.3) versus what I would gain from the 64-bit version (v16.8)---there was not a comparison table for the two, that I could readily find on your website (your GS-Base Updates forum had a great deal of info, and, a bit too much for me/someone new to your software to compare quickly). As far as your software goes, I plan to make the purchase in the next few minutes (I already own your GS-Calc), but am not sure which version to purchase/download. Regards to your for good work on these apps.
Dec 9 2020 at 4:01am Copy Link
Citadel5 @Meindert Jorna
The SQL import hasn't been added. You would have to rely on the csv/txt data format to import/export whole tables. I'm not sure what you would expect re: "use GS-Base to develop (...) in the mysql env.". Surely you could use GS-Base to easily (and very quickly) pre-process your initial data and/or analyze it statistically, especially if these are very large tables.
Citadel5 - Dec 9 2020 at 5:58am Copy Link
Citadel5 @soo mi
Of course, the license covers both the 32- and 64-version and you can use them interchangeably whenever you need to. Regarding the differences, the point is that due to the dwindling interest in the 32-bit versions the 32-bit GS-Base builds are significantly older than the new 64-bit versions. As you can see it on the website, the latest 32-bit trial version is 15.8.x. The 32-bit versions are limited to 4GB addressing space. For the list of features added up to the ver. 16.8, please see the "GS-Base Updates" forum section.
Citadel5 - Dec 9 2020 at 6:10am Copy Link
Fadi I see the 1 year license have support for 12 months , does the Lifetime license have Lifetime support ?
May 4 2021 at 4:32pm Copy Link
Mitchell User The validation code from the download page does not work in the registration form. It says that I am entering the wrong validation code.

Please disregard. I installed the program with Revo Uninstaller and the validation code was accepted. Trust me: the first attempt I inserted both my email address and the validation code about six times. The second install worked
May 4 2021 at 5:02pm Copy Link
Citadel5 @Fadi
These license variants concern how long you're entitled to download new versions at no costs.
The license itself and the support don't "expire" regardless of the license variant. Questions and suggestions from any users are always welcome.
Citadel5 - May 4 2021 at 5:40pm Copy Link
Steven Aves GS-Base is very good. Support is quick. $10 for a database like this is a steal.
May 5 2021 at 5:23am Copy Link
HJ B I have used and recommend GS-Base. It is capable of handling gigabytes of data, and now can even import SQL files! I do not know of any other inexpensive database program that can do that.

Users would greatly benefit from a detailed user manual and reference of function definitions.

It would also be helpful if there were some videos and working examples of ways that program can be used for typical database functions and data manipulations.

The developer has demonstrated that he actively works to substantially enhance the capability of the program.


Sep 13 2021 at 5:58pm Copy Link
geo User Question for the developer: Is the .sqlite file type supported?
Sep 18 2021 at 5:21pm Copy Link
Citadel5 @geo
Only MySQL dump files are supported at the moment. Some manual (syntax) corrections in sqlite dumps would probably be necessary to make them readable in this version. If you use this format extensively and have some non-trivial, compound dump files (e.g. multi-language, with long text and blobs), please feel free to contact Citadel5 directly in about a month (which doesn't mean the format will be definitely supported in a month).
Citadel5 - Sep 19 2021 at 8:51am Copy Link
bai bai Sql support is good, I hope sqlite and postgresql will be supported one day. The postgresql database is more powerful and truly free.
Sep 21 2021 at 3:23am Copy Link
Mike Murphy Can this be used to create any type of database or only meant for photos, music files, CDs, or icon collections?
Feb 17 2022 at 6:20am Copy Link
Citadel5 Hi, These are just basic examples. You can create any databases with numeric, text, calculated, memo, object (images, files, links), code (syntax coloring for 16 programming languages) fields. It should be also very fast when processing, say, 10GB database files with millions of records and memo/long text fields. The online help describes most of the available functions.
Citadel5 - Feb 17 2022 at 7:08am Copy Link
Steven Aves I use it for sales, commission tracking, reports on suppliers, etc.
Feb 17 2022 at 7:27am Copy Link
Mike Murphy Can you create forms for data entry? I downloaded the demo, but can't see how to do it.
Feb 17 2022 at 8:04am Copy Link
Citadel5 @Mike Murphy
A default entry form is generated automatically for each table, like on the older sample screen here:

Any specific reason why you prefer a form, if I may ask? Using tables will typically be way more effective. You can view/compare/find more information faster and GS-Base functions (like copying, converting contents, inserting/completing series, passwords etc.) update many fields and records at once.
Citadel5 - Feb 17 2022 at 10:26am Copy Link
Mike Murphy i'm old and find it much easier to tab through a form while entering data. Otherwise, it's kind of like a spreadsheet LOL
Feb 17 2022 at 10:51am Copy Link
Michael Crosson I have already purchased this software. I also prefer a form for database entry and would like to see more development in this area. I am "old" also. My favorite databases were Symantec's Q&A and before that Ashton-Tate's Rapidfile back in the DOS days. Both had easy to use form creation functions, but could also be used in table mode.
Feb 17 2022 at 9:58pm Copy Link
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Feb 18 2022 at 12:11am Copy Link
Steven Aves @Mike Murphy and @Michael Crosson, As an FYI, good old (GREAT old) Lotus Approach might work for you. Smartsuite can be found at

But that would be a large installation. GS-Base is just so darn small and fast.
Feb 18 2022 at 8:09am Copy Link
Todd User How long does it typically take to get the registration key? Usually when I order software from BDJ I get a registration within minutes. It's been a few hours now. I emailed the company's support but heard nothing. Are multiple hours normal?
Feb 18 2022 at 8:31am Copy Link
Steven Aves @Todd User It took a few hours to receive mine. The company is in England, so there is a time difference.
Feb 18 2022 at 9:27am Copy Link
Citadel5 @Todd
I didn't receive today any message from your e-mail address (unless you meant BDJ). It's usually from several minutes to a few hours. Of course, this should be automatic and instant and for a long time it has been that way, but 1-2 years ago or so something changed in the BDJ's server/system settings and (AFAIK) some vendors remote scripts can no longer be called to pass the reg. data in real-time.
We couldn't solve this and now some additional manual action is required.
Citadel5 - Feb 18 2022 at 10:40am Copy Link
Michael Crosson @Steven Aves Thanks for the suggestion. I actually already have several old licenses to Lotus Suitesuite and still use Word Pro as a word processor all the time. Still works fine in Windows 10 and is excellent. Approach is already installed on my system, but I never really explored it. It's not a large installation by today's standards. Perhaps I'll check it out.
Feb 28 2022 at 8:55pm Copy Link
Steven Aves @Michael Crosson. If it were not for my need to copy and paste webpage data at times, I would still be using WordPro too. There are features within it that no one has replicated. BTW, I moved to Atlantis Word Processor years ago via a BDJ promo. Highly recommend it.

Approach is surprisingly powerful, quick, and customizable. It is not hard to use, you just need to "dig in" and start using it. Creating a form and fields can feel mundane, but it sure is nice to have the data automatically formatted for you when entered.
Mar 1 2022 at 8:54am Copy Link
RichV Hi. I'm interesting in importing CSV files, and in looking at the documentation I'm assuming it can be imported as a text file with a comma separator; is this correct? (thanks)
May 10 2022 at 4:27am Copy Link
Citadel5 Hi, yes, you can use any separator including a comma to open/save text files (and fixed width fields without separators are available as well).
One of the older screen shots on the home page shows several dialog boxes and the "Open Text File" dialog box:
Citadel5 - May 10 2022 at 4:49am Copy Link
RichV Thanks for that. Can I also export to CSV? (edit) Ideally I'd like access to SQL (not a dealbreaker, though) - if not available, would I able to perform sums, averages, etc. on a file and optionally delete and/or update other files?
As an example, consider a header file and detail file(s). I'd want to summarize (average, etc.) the contents of a detail file and, if the values are below certain thresholds, delete the detail file and remove its record from the header file.
May 10 2022 at 5:09am Copy Link
Eduardo Amado Hi. I am a registered user. Can I buy an update with this same 50% discount, plus the 50% discount of the upgrade itself??
May 10 2022 at 5:25am Copy Link
Citadel5 @RichV
Yes, like I wrote, you can open, edit and save text files and the range of options/parameters is the same. Regarding the SQL support, you can load/edit/save MySQL *.sql files.
Citadel5 - May 10 2022 at 6:22am Copy Link
Citadel5 @Eduardo Amado
Hi, no, the promotion refers to the regular price.
Citadel5 - May 10 2022 at 6:25am Copy Link
Wearsie Jackson Hi, Wonderful software! Is this able to produce standard reports? For example, I'd like to use for invoicing, and would need to create a customer statement report as well as an invoice report. Thanks!

--- Weerz
Nov 9 2022 at 9:51am Copy Link
Citadel5 Thanks. It may depend on the type of business and the data, so I'll quickly list most of the related options below.

You can print serial letters (*.rtf) with embedded database fields values, you can print regular forms for each record with all fields or with some summaries and you can simply copy such forms as field reports.

You can send HTML and text invoices as serial emails with embedded database fields and custom attachment lists unique for each record where the attachments contain either (unique or the same) external files or other database record long text/memo/binary fields.

If you create some HTML forms, you can use them as templates with named table elements to be filled with a given single record fields or with a list of found records.

Re: generating some "total" reports, you can use calculation fields e.g., for counting or summarizing in one table values from other tables for a given field/key value or for more complex filtering expressions.

Basic statistics (min, max, mean, sum, quartiles, breakdown) for a given field and/or record set are generated automatically in the "Field Setup" dialog box and can be copied as text.

After creating pivot tables, you have various options to copy their fields and to generate pivot table reports that you can, for example, send or process further.
Citadel5 - Nov 9 2022 at 11:35am Copy Link
Wearsie Jackson Excellent information! Thanks for the details. This deal is too good to pass up, so I purchased the Lifetime version!

(purchased under a separate bus email, order # ending in 8e23)

Thank you for an amazing, powerful, easy to use database.

-- Weerz
Nov 9 2022 at 11:21pm Copy Link
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Nov 10 2022 at 12:11am Copy Link
Mitchell User One of my tables contains a very large text field which might comprise several paragraphs of text. I want the height of the rows for these records to expand automatically to fit the paragraphs of text. I don't want to guess the row height; I want the program to do it automatically. Can the program do this and if so how
Nov 10 2022 at 4:30am Copy Link
Citadel5 By default, all rows are using automatic heights. If you resized some of them manually or set some fixed heights using the "Row Heights" dialog box, you can choose automatic heights again for the desirable range of records or the entire table using the "Format > Auto Height" command.

New lines in table cells can be entered with the Ctrl+Enter key combinations. If the text doesn't have line breaks, you need to choose the "Format > Alignment > Wrap Text" option to expand the row heights based on the column widths.

When opening csv/text/xbase/html/.sql files the above will be performed automatically if you select the "Settings > Options > General > Auto-fit column widths" and "(...)row heights" options. For the GS-Base file format and the *.xls format, row/column size information is stored/saved in the file.
Citadel5 - Nov 10 2022 at 5:39am Copy Link
Greg User I just want to mention to any fence sitters out there... I've used this software for years, and the customer service is absolutely second to none. Emails are answered quickly, usually the same day. I've even received two separate support emails in a single day. Just look how fast any questions were answered here. Great software, great support, excellent price.

I now return you to your regularly scheduled comments :-)
Nov 10 2022 at 1:38pm Copy Link
Dunking Did sqlite make it into this yet? I would buy it right now if so, but without it would be like using a plasma welder on wood (for me).
Mar 23 2023 at 4:41am Copy Link
Citadel5 The current *.sql dump files use the MySQL syntax ( ). According to the specification, you should be able to load SQLite *.sql files changing (in any text editor) "BEGIN TRANSACTION" with "BEGIN", "AUTOINCREMENT" with AUTO_INCREMENT, TEXT with varchars and " with '. If you (or any users here) are willing to give it a try (especially if you're using BLOB fields) and describe how you would like to process such files in GS-Base (for further improvements), please contact Citadel5 support - there are just too few SQLite users who asked about it.
Citadel5 - Mar 23 2023 at 6:54am Copy Link
Dunking Thanks. I'll have a look :)
Mar 23 2023 at 7:35am Copy Link
Citadel5 You need to create a dump file first: sqlite3 sample.db .dump > sample2.sql.
Citadel5 - Mar 23 2023 at 8:43am Copy Link
Dunking Ah. That could be a problem - not because I don't have standalone sqlite3 (I don't because my data is created in apps that talk sqlite) - it is easily downloadable. But I would want to use GS-Base as an ad-hoc browser/editor rather than as the database application, so converting to and from formats in order to do that wouldn't work for me.
Mar 23 2023 at 9:37am Copy Link
Citadel5 Sqlite3.exe is just a single command line tool freely downloadable from the SQLite home page. Most likely something around 1-2MB.
Citadel5 - Mar 23 2023 at 5:09pm Copy Link
guy t974 Hello ,
I have a question. Is GS-base only for making offline databases, or can I generate a mysql database with it and put it in my web space ? Or ( sorry I'm not an advanced ddatabase user ) can I use phpmyadmin in my webspace to load a whole database made in GS-BASE ?
Thank you.
Jul 20 2023 at 4:47am Copy Link
Citadel5 Hi, yes, GS-Base is a desktop application for standalone computers only. It can't be used on www servers. You can just exchange data e.g. in the MySQL *.sql or SQLite *.db file formats or locally fill with records pre-defined HTML pages/templates for uploading to www servers.
Citadel5 - Jul 20 2023 at 5:36am Copy Link
guy t974 Thank you for your answer. So, if the database is already active on my server,
and I have a gs-base database with the same structure, could I export data from the gs-base into a sql file, and then reimport this data from phpmyadmin into my online database ?
Jul 20 2023 at 10:56am Copy Link
Citadel5 Yes, this will work that way, however, please note that in case of the MySQL *.sql format these are dump files and they already contain commands to create tables and populate them.
If you edit an existing *.sql file, the structure will remain the same after saving, but if you use in GS-Base the "Save Database As" command, it will perform predefined SQL field setups based on GS-Base field types.
Please see:

It's slightly different in GS-Calc (a spreadsheet), where the first row contains field definitions that you can freely modify any way you want:
Citadel5 - Jul 20 2023 at 1:59pm Copy Link

Our virus scan reports this website is 100% Clean View Deal

BitsDuJour is for People who Love Software
Every day we review great Mac & PC apps, and get you discounts up to 100%
Follow Us
© Copyright 2024 BitsDuJour LLC. Code & Design. All Rights Reserved. Privacy Policy