SawitDB (PHP Version)

SawitDB is a unique database solution stored in .sawit binary files.

The system features a custom Paged Heap File architecture similar to SQLite, using fixed-size 4KB pages to ensure efficient memory usage. What differentiates SawitDB is its unique Agricultural Query Language (AQL), which replaces standard SQL keywords with Indonesian farming terminology.

Now availability on Packagist!

🚨 Emergency: Aceh Flood Relief Please support our brothers and sisters in Aceh.

Organized by Human Initiative Aceh

Features

• Paged Architecture: Data is stored in 4096-byte binary pages.
• Object Caching (New): Implements Page-Level Object Caching for high-speed reads (bypassing JSON parse for hot pages).
• Hash Joins (New): Optimized JOIN operations (O(M+N)) for massive performance gains on relations.
• Persistent Indexes (New): Indexes are now automatically persisted in _indexes system table and restored on load.
• Query Cache (New): LRU Cache for parsed queries to reduce CPU overhead.
• Zero Bureaucracy: Built with standard PHP. No massive vendor dependencies.
• Network Support: Client-Server architecture using PHP Streams.

Philosophy

Filosofi (ID)

SawitDB dibangun dengan semangat "Kemandirian Data". Kami percaya database yang handal tidak butuh Infrastruktur Langit yang harganya triliunan tapi sering down. Berbeda dengan proyek negara yang mahal di budget tapi murah di kualitas, SawitDB menggunakan arsitektur Single File (.sawit) yang hemat biaya. Backup cukup copy-paste, tidak perlu sewa vendor konsultan asing. Fitur fsync kami menjamin data tertulis di disk, karena bagi kami, integritas data adalah harga mati.

Philosophy (EN)

SawitDB is built with the spirit of "Data Sovereignty". We believe a reliable database doesn't need "Sky Infrastructure" that costs trillions yet goes down often. Unlike state projects that are expensive in budget but cheap in quality, SawitDB uses a cost-effective Single File (.sawit) architecture. Backup is just copy-paste.

Installation

Install via Composer:

composer require wowoengine/sawitdb-php

Framework Support

Vanilla PHP & CodeIgniter 4

SawitDB acts as a standard PSR-4 library. You can use the WowoEngine directly or connect via the Client.

use SawitDB\Engine\WowoEngine;
$db = new WowoEngine(__DIR__ . '/plantation.sawit');

Laravel Integration

SawitDB includes a ServiceProvider and Facade for seamless Laravel integration.

1. Install via Composer: composer require wowoengine/sawitdb-php
2. Configuration: Publish the config or add to config/database.php.

// config/database.php
'connections' => [
    'sawit' => [
        'database' => env('SAWIT_DB_DATABASE', database_path('plantation.sawit')),
    ],
],

3. Usage:

use SawitDB;

// In Controller
public function index() {
    SawitDB::query("LAHAN users");
    SawitDB::query("TANAM KE users (name) BIBIT ('Budi')");
    return SawitDB::query("PANEN * DARI users");
}

Quick Start (Network Edition)

1. Start the Server

php bin/sawit-server.php

The server will start on 0.0.0.0:7878 by default.

2. Connect with Client (CLI)

php cli/remote.php sawitdb://localhost:7878/my_plantation

---

Usage (Embedded)

You can use the WowoEngine directly in your PHP applications.

use SawitDB\Engine\WowoEngine;

$db = new WowoEngine(__DIR__ . '/plantation.sawit');

// Generic SQL
$db->query("CREATE TABLE users");
$db->query("INSERT INTO users (id, name) VALUES (1, 'Budi')");

// AQL
$db->query("LAHAN trees");
$db->query("TANAM KE trees (id, type) BIBIT (1, 'Dura')");

// Join
$rows = $db->query("SELECT * FROM trees JOIN users ON trees.id = users.id");
print_r($rows);

Architecture Details

• Modular Codebase: Engine logic separated into src/ components.
• Page 0 (Master Page): Contains header and Table Directory.
• Data & Indexes: Stored in 4KB atomic pages.
• WowoEngine: Core engine orchestrating Pager, Index, and Query Parser.

Full Feature Comparison

Feature	Tani Edition (AQL)	Generic SQL (Standard)	Notes
Create DB	BUKA WILAYAH [db]	CREATE DATABASE [db]	Creates .sawit in data/
Use DB	MASUK WILAYAH [db]	USE [db]	Switch context
Show DBs	LIHAT WILAYAH	SHOW DATABASES	Lists available DBs
Drop DB	BAKAR WILAYAH [db]	DROP DATABASE [db]	Irreversible!
Create Table	LAHAN [table]	CREATE TABLE [table]	Schema-less creation
Show Tables	LIHAT LAHAN	SHOW TABLES	Lists tables in DB
Drop Table	BAKAR LAHAN [table]	DROP TABLE [table]	Deletes table & data
Insert	TANAM KE [table] ... BIBIT (...)	INSERT INTO [table] (...) VALUES (...)	Auto-ID if omitted
Select	PANEN ... DARI [table] DIMANA ...	SELECT ... FROM [table] WHERE ...	Supports Projection
Join	... GABUNG [tbl] PADA ...	... JOIN [tbl] ON ...	Hash/Nested Loop
Update	PUPUK [table] DENGAN ... DIMANA ...	UPDATE [table] SET ... WHERE ...	Atomic update
Delete	GUSUR DARI [table] DIMANA ...	DELETE FROM [table] WHERE ...	Row-level deletion
Index	INDEKS [table] PADA [field]	CREATE INDEX ON [table] (field)	B-Tree Indexing
Count	HITUNG COUNT(*) DARI [table]	SELECT COUNT(*) FROM [table] (via HITUNG)	Aggregation

Supported Operators Table

Operator	Syntax Example	Description
Comparison	=, !=, >, <, >=, <=	Standard value comparison
Logical	AND, OR	Combine multiple conditions (AND > OR)
In List	IN ('coffee', 'tea')	Matches any value in the list
Not In	NOT IN ('water')	Matches values NOT in list
Pattern	LIKE 'Jwa%'	Standard SQL wildcard matching
Range	BETWEEN 1000 AND 5000	Inclusive range check
Null	IS NULL	Check if field is empty/null
Not Null	IS NOT NULL	Check if field has value
Limit	LIMIT 10	Restrict number of rows
Offset	OFFSET 5	Skip first N rows (Pagination)
Order	ORDER BY price DESC	Sort by field (ASC/DESC)

License

MIT License