What is TeeBI?
TeeBI is a simple class to implement in-memory database complex structures for datamining, visualization, multidimensional queries, pivot tables, and big data processing. Built as 100% pure Pascal with no dependencies beyond RTL, TeeBI provides an ultra-fast, column-based data structure where every field is a simple array. This architecture enables processing billions of cells with exceptional performance.Key features
TeeBI delivers comprehensive data processing capabilities:Ultra fast speed
Every column or field is a simple array, enabling exceptional query performance even on large datasets
Big data ready
Supports billions of cells for processing massive datasets in memory
Multi-platform
Works across Windows, macOS, Android, iOS, and Linux with VCL, FireMonkey, and Lazarus
Automatic visualizations
Generate charts, grids, and complex visualizations from your data structures automatically
SQL-like queries
Execute high-speed queries and summaries using SQL-like syntax or code-based expressions
Pivot tables
Multi-dimensional Excel-like pivot tables with drag & drop editor
Import from anywhere
Load data from CSV, databases, JSON, XML, objects (ORM), AI agents, and more in one line of code
Export to formats
Export data to CSV, PDF, HTML, XML, Excel, JSON, and other formats
Use cases
TeeBI excels at scenarios requiring fast data analysis and visualization:- Business intelligence dashboards: Create no-code analytic applications for end-users with ready-to-use dialogs for runtime database connections
- Data analysis: Process and query large datasets with SQL-like syntax including group by, sort, expressions, having, sub-select, and distinct operations
- Geographic data: Leverage the built-in geographic database (countries, states, provinces) to create summary geo queries, world maps, and statistics
- Data import/export: Convert and transform data between multiple formats with minimal code
- Performance-critical applications: Take advantage of ultra-fast speed for time-sensitive data processing
- Multi-platform data apps: Build data-driven applications that run across desktop and mobile platforms
Platform support
TeeBI supports multiple development environments and platforms:Development environments
- Embarcadero RAD Studio: Florence 13.0 and Studio XE4 and up (Delphi and C++)
- Lazarus/FreePascal: Full support for open-source Pascal development
Target platforms
With VCL and FireMonkey frameworks:- Windows (32-bit and 64-bit)
- macOS
- Linux
- Android
- iOS
TeeBI is 100% pure Pascal with no server dependencies - just the RTL (Runtime Library).
Geographic database
TeeBI includes a comprehensive geographic database that enables you to automatically create summary geo queries, TeeChart world maps, and geographic statistics. The database covers countries, states, provinces, and regions worldwide.Remote data access
TeeBI supports optional remote web server access for fast data retrieval using compressed binary streams of raw arrays, enabling efficient client-server data architectures.Next steps
Installation
Learn how to install and configure TeeBI in your development environment
Quickstart
Get started with your first TeeBI application in minutes
