ZTeraDB Client Driver

Welcome!
This documentation will walk you through ZTeraDB step-by-step, using simple language and practical PHP examples.

📘 What Is ZTeraDB?

ZTeraDB helps you connect to your existing databases (PostgreSQL, MySQL, MSSQL, etc.) through a single unified platform.
You write one query language (ZQL) instead of switching between SQL dialects.

🧠 Architecture (Simple Explanation)

Your App → ZTeraDB PHP Client → ZTeraDB Server → Your Databases

You never connect to the database directly.
ZTeraDB handles all connections, routing, and execution securely behind the scenes.

⭐ Features

🚀 Unified Query Language (ZQL)
🔌 Easy integration with any PHP application
⚙️ Auto-managed connections & retries
🔐 Secure authentication using client keys
🎯 Clean query builder (insert, select, update, delete)
🔍 Advanced logical & mathematical filters
🧵 Streamed results for large datasets
📦 Composer-based installation
🧩 Works with frameworks like Laravel, Symfony, CodeIgniter

🛠 Requirements

PHP 5.6.40+ Click here to download and install php
Composer Click here to doanload and install composer
ZTeraDB account (clientKey, accessKey, secretKey)
Basic knowledge of PHP arrays & objects

📦 Install

Install via Composer:

composer require zteradb/zteradb-php

Install from the ZTeraDB github repository. Create a composor.json file with following content.

{
  "repositories": [
    {
      "type": "vcs",
      "url": "https://github.com/zteradb/zteradb-php"
    }
  ],
  "require": {
    "zteradb/zteradb-php": "<latest version>"
  }
}

🚀 Quick Start (Hello World)

<?php

require_once "vendor/autoload.php";

use ZTeraDB\Config\ZTeraDBConfig;
use ZTeraDB\Connection\ZTeraDBConnection;
use ZTeraDB\Query\ZTeraDBQuery;
use ZTeraDB\Config\ResponseDataTypes;
use ZTeraDB\Config\ENVS;

$config = new ZTeraDBConfig([
  'client_key' => getenv('CLIENT_KEY'),
  'access_key' => getenv('ACCESS_KEY'),
  'secret_key' => getenv('SECRET_KEY'),
  'database_id' => getenv('DATABASE_ID'),
  'env' => ENVS::dev,
  'response_data_type' => ResponseDataTypes::json,
]);

$db = new ZTeraDBConnection(
  getenv("ZTERADB_HOST"),
  getenv("ZTERADB_PORT"),
  $config
);

$query = (new ZTeraDBQuery("user"))->select();

foreach ($db->run($query) as $row) {
  print_r($row);
}

$db->close();