“Introducing GS-Base” is the official introductory manual and onboarding guide for GS-Base, a high-performance portable desktop database and spreadsheet hybrid software developed by Citadel5.
The program fills a specialized niche as an affordable database optimized for spreadsheet users who need to process massive datasets that exceed standard Excel row limits. Core Data Capacities
The software is engineered to efficiently handle extremely heavy data loads on consumer-grade hardware without bogged down performance. According to the Citadel5 Technical Documentation, its primary limits include:
Table Limits: Supports up to 256 million records per single table. Field Limits: Accommodates up to 16,384 fields per record.
File Management: Native editing and filtering of CSV, txt, Excel, SQLite, and MySQL files larger than 4GB directly in RAM.
Processing: Leverages multi-core computing to distribute processes across up to 100 processor cores simultaneously. Key Features Highlighted in the Introduction
The introductory text highlights several standout structural features that separate GS-Base from traditional database environments:
Dual-View & Synchronization: Displays data in an integrated single window that can be divided into up to 100 synchronized panes, showing tables, pivot tables, forms, and memo fields simultaneously.
Versatile Field Types: Stores text, numbers, dates, rich text (RTF) memo fields, and embedded images or binary files.
Code Snippet Field: Includes built-in code fields featuring code syntax highlighting for 16 different programming languages.
Pivot Tables: Generates complex pivot tables supporting up to 256 million rows and 16,384 columns, featuring 25 native data functions.
Calculations: Utilizes around 300 standard built-in calculation formulas for data validation and field computations.
Automation and Scripting: Supports direct COM programming alongside VBScript and JScript scripting to automate massive table splitting, merging, or batch editing. File Format & Portability
GS-Base utilizes a convenient, plain zip file format to package its databases. This structural design allows users to access, view, or modify the underlying records, tables, and embedded images using standard zip utilities even if the GS-Base software is not installed on the system.
Furthermore, the entire application can be installed directly on an external storage drive (such as a USB flash drive) and executed as a portable application without writing to or modifying the Windows registry. It secures data via strong standard password protection and integrated file encryption.
Are you looking to use GS-Base to process a specific type of dataset, or are you comparing its features to Microsoft Excel? Introducing GS-Base – Citadel5