The PHP library for Turso over HTTP
MIT License
The TursoHTTP
library is a PHP wrapper for Turso HTTP Database API (Only). It simplifies interaction with Turso databases using the Hrana over HTTP protocol. This library provides an object-oriented approach to build and execute SQL queries with same API Interface like PHP Native Extension Turso Client PHP.
You can install the TursoHTTP library using Composer:
composer require darkterminal/turso-client-http
Variable Name | Value | Description |
---|---|---|
DB_URL or TURSO_URL
|
Your Turso database URL | - |
DB_TOKEN or TURSO_TOKEN
|
Your Turso database TOKEN | - |
DB_TIMEZONE or TURSO_TIMEZONE
|
Asia/Jakarta |
See the list of timezones here |
DB_STRICT_QUERY or TURSO_STRICT_QUERY
|
true / default: false
|
Use strict query when using explain method in Query Builder |
DB_LOG_DEBUG or TURSO_LOG_DEBUG
|
true / default: false
|
Set Query logs to save all query activities into a log file |
DB_LOG_NAME or TURSO_LOG_NAME
|
libsql_debug |
Set Query channel name |
DB_LOG_PATH or TURSO_LOG_PATH
|
$HOME/.turso-http/logs/debug.log |
Log file location |
use Darkterminal\TursoHttp\LibSQL;
require_once 'vendor/autoload.php';
$dbname = getenv('DB_URL');
$authToken = getenv('DB_TOKEN');
$db = new LibSQL("dbname=$dbname&authToken=$authToken");
echo $db->version() . PHP_EOL;
$create_table = <<<SQL
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
email TEXT
)
SQL;
$db->execute($create_table);
<?php
use Darkterminal\TursoHttp\core\Enums\DataType;
use Darkterminal\TursoHttp\LibSQL;
use Darkterminal\TursoHttp\core\Builder\LibSQLBlueprint;
use Darkterminal\TursoHttp\core\Builder\LibSQLSchemaBuilder;
require_once 'vendor/autoload.php';
try {
$dbname = getenv('DB_URL');
$authToken = getenv('DB_TOKEN');
$db = new LibSQL("dbname=$dbname&authToken=$authToken");
$schemaBuilder = new LibSQLSchemaBuilder($db);
// Creating table
$schemaBuilder->create('contacts', function(LibSQLBlueprint $table) {
$table->increments('id');
$table->string('name');
$table->unique('email');
$table->string('phone');
$table->timestamps();
})->execute();
echo "Table created successfully.\n";
// Add new column in the table
$schemaBuilder->table('contacts', function(LibSQLBlueprint $table) {
$table->addColumn(DataType::TEXT, 'address');
})->execute();
echo "Column added successfully.\n";
// Drop the table
$schemaBuilder->drop('contacts')->execute();
echo "Table contacts successfully dropped!.\n";
} catch (Exception $e) {
echo "An error occurred: " . $e->getMessage();
}
<?php
use Darkterminal\TursoHttp\LibSQL;
require_once getcwd() . '/vendor/autoload.php';
$dbname = getenv('DB_URL');
$authToken = getenv('DB_TOKEN');
$db = new LibSQL("dbname=$dbname;authToken=$authToken");
$query = <<<SQL
INSERT INTO contacts (name, email, phone, address) VALUES (?, ?, ?, ?)
SQL;
$db->execute($query, [
'Imam Ali Mustofa',
'[email protected]',
'08123456789',
'Punk Univers'
]);
<?php
use Darkterminal\TursoHttp\LibSQL;
use Darkterminal\TursoHttp\core\Builder\LibSQLQueryBuilder;
require_once getcwd() . '/vendor/autoload.php';
$dbname = getenv('DB_URL');
$authToken = getenv('DB_TOKEN');
$db = new LibSQL("dbname=$dbname;authToken=$authToken");
$sql = new LibSQLQueryBuilder($db);
$contacts = $sql->table('contacts')
->where('address', '=', 'Punk Universe')
->get();
var_dump($contacts);
This library is licensed under the MIT License - see the LICENSE file for details.