Download the PHP package wowoengine/sawitdb-php without Composer
On this page you can find all versions of the php package wowoengine/sawitdb-php. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download wowoengine/sawitdb-php
More information about wowoengine/sawitdb-php
Files in wowoengine/sawitdb-php
Package sawitdb-php
Short Description PHP Port of SawitDB Node.JS Version - A single-file NoSQL database for PHP.
License MIT
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package sawitdb-php
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
JOINoperations (O(M+N)) for massive performance gains on relations. - Persistent Indexes (New): Indexes are now automatically persisted in
_indexessystem 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:
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.
Laravel Integration
SawitDB includes a ServiceProvider and Facade for seamless Laravel integration.
- Install via Composer:
composer require wowoengine/sawitdb-php -
Configuration: Publish the config or add to
config/database.php. - Usage:
Quick Start (Network Edition)
1. Start the Server
The server will start on 0.0.0.0:7878 by default.
2. Connect with Client (CLI)
Usage (Embedded)
You can use the WowoEngine directly in your PHP applications.
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
All versions of sawitdb-php with dependencies
ext-json Version *