Skip to main content

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

Build docs developers (and LLMs) love