Skip to main content

Documentation Index

Fetch the complete documentation index at: https://darkstation.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

For database operation usage, everything have same interface like usual when you using Doctrine DBAL before. But remember, this is LibSQL they have sync() method that can be used when you connect with Remote Replica Connection (Embedded Replica), you can use sync() method with getNativeConnection()->sync(). 
use Doctrine\DBAL\DriverManager;

require_once __DIR__ . '/vendor/autoload.php';

$params = [
    "url"               => ":memory:",
    'driverClass'       => \Darkterminal\LibSQL\DBAL\Driver::class,
];

$db = DriverManager::getConnection($params);

$createTable = "CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT,
    age INTEGER
)";
$db->executeStatement($createTable);

$insertUsers = <<<SQL
INSERT INTO users (name, age) VALUES ('Budi Dalton', 49);
INSERT INTO users (name, age) VALUES ('Sujiwo Tedjo', 50);
SQL;

$db->getNativeConnection()->executeBatch($insertUsers);

$result = $db->executeQuery("SELECT * FROM users")->fetchAllAssociative();
var_dump($result);
$db->close();
That’s it! really easy…