ytake/laravel-voltdb

VoltDB providers for Laravel

Laravel.VoltDB

VoltDB providers for Laravel
, _(*1)

, _(*2)

for laravel5

Laravel4 Laravel.VoltDB, _(*3)

Install

required ext-voltdb, ext-curl
Add the package to your composer.json and run composer update., _(*4)

"require": {
    "php": ">=5.4.0",
    "ytake/laravel-voltdb": "1.*"
},

Add the service provider in app/config/app.php:, _(*5)

'providers' => [
    'Ytake\LaravelVoltDB\VoltDBServiceProvider',
];

Add the aliases in app/config/app.php:, _(*6)

'aliases' => [
    'VoltDBApi' => 'Ytake\LaravelVoltDB\VoltDBFacade',
];

The service provider will register a voltdb database extension
not supported Eloquent, QueryBuilder
(VoltDB supports PHP client application development using VoltDB PHP client library.), _(*7)

Configure

Add database connection, _(*8)

'voltdb' => [
    'driver' => 'voltdb',
    'host' => 'localhost',
    'username' => '',
    'password' => '',
    'port' => 21212
],

by default .env, _(*9)

DB_HOST=localhost
DB_DATABASE=voltdb
DB_USERNAME=username
DB_PASSWORD=secret

CACHE_DRIVER=voltdb
SESSION_DRIVER=voltdb

publish, _(*10)

$ php artisan vendor:publish 

Database Extension

@AdHoc query

$sql = "INSERT INTO users (user_id, username, password, remember_token, created_at)"
    ." VALUES (" . rand() . ", 'voltdb', '" . $pass . "', null, '" . date("Y-m-d H:i:s") . "')";
\DB::connection('voltdb')->exec($sql);
$sql = "SELECT * FROM users";
\DB::connection('voltdb')->select($sql);

not supported prepared statement
Recommended stored procedure, _(*11)

stored procedure

\DB::connection('voltdb')->procedure('Auth_findUser', [1]);

Auth

include voltdb auth driver
in config/auth.php:, _(*12)

 'driver' => 'voltdb',

or .env, _(*13)

Cache

include voltdb cache driver
in config/cache.php:, _(*14)

'driver' => 'voltdb',
'voltdb' => [
  'driver' => 'voltdb',
],

Session

include voltdb session driver
in app/config/session.php:, _(*15)

 'driver' => 'voltdb',

Auth, Cache, Session use Stored Procedure(see schema/ddl.sql), _(*16)

publish for auth, cache, session ddl.sql

$ php artisan ytake:voltdb-schema-publish

Options:
--publish (-p) Publish to a specific directory
default storage/schema/ddl.sql, _(*17)

DDL

default ddl, _(*18)

CREATE TABLE users (
   user_id INTEGER UNIQUE NOT NULL,
   username VARCHAR(40) NOT NULL,
   password VARCHAR(64) NOT NULL,
   remember_token VARCHAR(128) DEFAULT NULL,
   created_at TIMESTAMP NOT NULL,
   PRIMARY KEY(user_id)
);
CREATE INDEX UsersIndex ON users (username, password, remember_token);
CREATE TABLE caches (
  key VARCHAR(255) UNIQUE NOT NULL,
  value VARCHAR(262144),
  expiration INTEGER DEFAULT 0 NOT NULL,
  CONSTRAINT PK_cache PRIMARY KEY (key)
);
CREATE INDEX IX_cache_expires ON cache (expiration);
CREATE TABLE sessions (
  id VARCHAR(255) UNIQUE NOT NULL,
  payload VARCHAR(65535),
  last_activity INTEGER DEFAULT 0 NOT NULL
);
CREATE INDEX IX_session_id ON sessions (id);
CREATE INDEX IX_activity ON sessions (last_activity);

Facades

supported for json interface API, _(*19)

// call stored procedure @SystemInformation
\VoltDBApi::request()->info()->getResult();

// basic
\VoltDBApi::request()->post([
    'Procedure' => 'addUser',
    'Parameters' => [1, "voltdb"]
])->getResult();

Async Stored Procedure

see VoltDB.PHPClientWrapper, _(*20)

Console

ytake:voltdb-schema-publish publish DDL for auth, cache driver
ytake:voltdb-info information about ytake/laravel-voltdb
ytake:voltdb-system-catalog renderer system catalog, _(*21)

voltdb-system-catalog

Options:
--component (-c) returns information about the schema of the VoltDB database, depending upon the component keyword you specify. , _(*22)

example
Such as MySQL SHOW COLUMNS, _(*23)

$ php artisan ytake:voltdb-system-catalog -c COLUMNS

, _(*24)