The PHP library for Turso HTTP

Turso over HTTP

When I saw the words Turso Over HTTP on the card in the SDK documentation, I was a little offended because there was a paragraph that said; "Using something else? Learn how to use Turso over HTTP."

Wait a minute, why should I be offended?!

Maybe they thought PHP was a difficult language and it wasn't easy to make a compatible SDK, so they gave up on making it HTTP only.

Wait a minute, why am I so stupid?!

HTTP/PHP/HTTP/Hypertext preprocessor yeah! Thank you my stupid brain! They don't give up on PHP, but they give them the freedom to be creative and innovate. So my decision was very correct! (yes I am! Because I'm too handsome to do this)

I created the TursoHTTP Library for PHP which is equipped with a SadQuery Generator to make it easier to create SQL queries for lazy people who will ask; What is the accompanying ORM? This is Madapunker!

The TursoHTTP library is a PHP wrapper for Turso HTTP Database API. 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, retrieve query results, and access various response details.

<?php

use Darkterminal\DataType;
use Darkterminal\SadQuery;
use Darkterminal\TursoHTTP;

require_once . 'vendor/autoload.php';

$databaseName       = "database-name";
$organizationName   = "organization-name";
$token              = "your-turso-database-token";

$tursoAPI = new TursoHTTP($databaseName, $organizationName, $token);
$query = new SadQuery();

$createTableUsers = $query->createTable('users')
    ->addColumn('userId', DataType::INTEGER, ['PRIMARY KEY', 'AUTOINCREMENT'])
    ->addColumn('name', DataType::TEXT)
    ->addColumn('email', DataType::TEXT)
    ->endCreateTable();

$createNewUser = $query->insert('users', ['name' => 'darkterminal', 'email' => 'darkterminal@duck.com'])->getQuery();

$tableCreated = $tursoAPI
    ->addRequest("execute", $createTableUsers)
    ->addRequest("close")
    ->queryDatabase()
    ->toJSON();
echo $tableCreated . PHP_EOL;

$userCreated = $tursoAPI
    ->addRequest("execute", $createNewUser)
    ->addRequest("close")
    ->queryDatabase()
    ->toJSON();
echo $userCreated . PHP_EOL;

Isn't this interesting!? Very easy and true to reality!

If you are curious about the complete documentation, please visit the GitHub repository.

darkterminal / turso-client-http

The PHP library for Turso over HTTP

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.

Requirements

Intention and Courage
Instinct as a Software Freestyle Engineer
Strong determination!
Turso Account
Don't forget to install PHP on your machine
A cup of coffee and the music you hate the most
Dancing (optional: if you are willing)

Features

libSQL Native Extension like API Interface
Schema Builder
Query Builder
Turso Platform API
Timezone Support

Installation

You can install the TursoHTTP library using Composer:

composer require darkterminal/turso-client-http

Environment Variables

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