ZozaniDB is by far the easiest way to use databases in Matlab. You can use a database without knowing or having to construct SQL statements. ZozaniDB also creates all tables and columns on the fly!
Features
- Support for multiple database systems.
Out of the box support for SQLite and MySQL. Support for other databases is in progress. You do not need the Matlab Database Toolbox for Zozanidb to work.
- No-SQL access.
Insert, update, delete without having to write any SQL statements.
- On-the-fly database schema generation.
The database schema is automatically adjusted, including column types and column lengths. You don't have to worry about whether a text column will accommodate a new entry you are inserting.
- Object-oriented use.
You can load table rows as objects and make changes directly on these objects. Your changes are saved automatically into the database.
- Relational Mapping.
ZozaniDB automatically discovers relationships between entities and allows you to join information from multiple tables with little effort.
- Zero-configuration but customizable.
Although ZozaniDB tries to automate many of the tasks, it also gives you the opportunity to manually define data types and entity relationships using human-readable YAML files.
Code Example
>> d=zdb('temp.sqlite' ,'hot',true,'dbg',true);
>> d.table('fruit').insert(struct('name','apple' ,'calories',53));
--- NOTICE: created table "fruit"
INSERT INTO "fruit"("name","calories") VALUES ('apple',53)
>> e=d.fruit.findby(struct('name','apple'))
SELECT * FROM "fruit" WHERE name='apple'
e =
id: 1
name: apple
calories: 53
>> e.name='honeycrisp apple';
>> e.calories=55;
>> e.save
UPDATE "fruit" SET "name"='honeycrisp apple',"calories"=55 WHERE id=1
Installation
- Download ZozaniDB and unpack to any folder. Change into the lib sub-directory in Matlab, and you are ready to go.
- See the documentation for some example uses.
News
- 2015-02-17: First public release.
- 2009-10-01: First internal version.