Full SQL frontend
Use common SQL patterns including joins, CTEs, scalar subqueries, GROUP BY, HAVING, DISTINCT, arithmetic expressions, prepared statements, and cursor-first result handling.
TigerDB Database Server is a secure, resilient SQL platform designed for real workloads: full SQL, encrypted and plain deployment, Router-based scaling, native JSON, recovery-first storage, and cloud-ready operations.
Run plain or encrypted, recover from failures, stream large queries, and choose the storage style that fits the workload.
TigerDB combines the approachable feel of SQL with the operational features needed for encrypted deployments, automated recovery, distributed routing, and application development.
Use common SQL patterns including joins, CTEs, scalar subqueries, GROUP BY, HAVING, DISTINCT, arithmetic expressions, prepared statements, and cursor-first result handling.
Run plain binaries for private networks or encrypted builds with TLS and AES-256-GCM encryption-at-rest for protected production deployments.
WAL durability, checkpoint safety, manifest validation, crash recovery, backup verification, and maintenance tooling are built into the product flow.
Use Router for one entry point, shard-aware SQL planning, distributed SELECTs, backend failover logic, and distributed cursors for large multi-shard reads.
Store relational rows and JSON data together with JSON path queries, flexible document attributes, and developer-friendly driver responses.
Designed for automated deployment with generated configuration, certificates, service scripts, and operational settings ready for modern environments.
Select the storage engine once per TigerDB instance using STORAGE_ENGINE. Existing data directories are protected by engine identity metadata.
The original TigerDB WAL, segment, checkpoint, manifest, and recovery engine.
A PostgreSQL-style heap-page and MVCC storage model for snapshot-oriented workloads.
A MariaDB/InnoDB-style clustered primary-key engine for point and range lookup patterns.
TigerDB keeps client APIs stable while the server handles SQL, security, routing, transactions, and the selected storage engine internally.
TigerDB Router provides a single entry point for clients while handling backend connectivity, shard-aware planning, distributed SELECT routing, response limits, TLS, and distributed cursors.
Use SQL for everyday development, analytics, administration, security, and operational workflows.
WITH active AS (
SELECT symbol, ltp, volume
FROM live_feed
WHERE symbol = 'NIFTY'
)
SELECT symbol,
ltp * volume AS total_value,
(SELECT AVG(ltp) FROM live_feed) AS market_avg
FROM active
GROUP BY symbol
HAVING COUNT(*) > 0
ORDER BY total_value DESC
LIMIT 10;
AutoConfig generates certificates, environment files, server and Router configs, storage-engine settings, startup control, and operational defaults for the current folder.
# Generate encrypted deployment with storage engine
./bin/tigerdb_autoconfig --mode encrypted --license-key "$TIGERDB_LICENSE_KEY" --storage-engine tiger_native --databases default,market_data
# Verify and start
./tigerdbctl doctor
./tigerdbctl start encrypted all
./tigerdbctl status both
Place tigerdb.tar.gz in the same document root as this page. Users can download the package directly or request a test license by email.