Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 22aab38d66
Fetching contributors…

Cannot retrieve contributors at this time

109 lines (68 sloc) 2.786 kb
The Database README
===================
By default Chicago Boss uses an in-memory database, which is useful for
development and testing but not much else.
Using PostgreSQL/MySQL
----------------------
Open up boss.config and set db_adapter to `pgsql` or `mysql`. You should also set:
- db_host
- db_port
- db_username
- db_password
- db_database
Models
- - -
To use Chicago Boss with a SQL database, you need to create a table for each of
your model files. The table name should be the plural of the model name. Field
names should be the underscored versions of the model attribute names. Use
whatever data types make sense for your application.
ID fields
- - - - -
The "id" field should be a serial integer. (However, the generated
BossRecord ID exposed to your application will still have the form "model_name-1".)
Here are useful starting points for MySQL and PostgreSQL respectively:
CREATE TABLE models (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
...
PRIMARY KEY (id)
);
CREATE TABLE models (
id SERIAL PRIMARY KEY,
...
);
Counters
- - - -
To use the counter features, you need a table called "counters" with a "name"
and "value" column, like these:
CREATE TABLE counters (
name VARCHAR(255) PRIMARY KEY,
value INTEGER DEFAULT 0
);
Using Tokyo Tyrant
------------------
Tokyo Tyrant is a non-relational database developed by FAL Labs.
1. Download and install Tokyo Tyrant from <http://fallabs.com/tokyotyrant/>
2. Run Tyrant with a table database. Other database types are not supported.
3. Open up boss.config and set db_adapter to tyrant
Using Mnesia
------------
Notes:
1. The erlang VM needs a name and cookie to run Mnesia. You can set them with
the 'vm_name' and 'vm_cookie' options in boss.config.
2. Create a table for each model as well a table called '_ids_' with attributes
for [type, id, count]. For more details see
https://github.com/evanmiller/ChicagoBoss/wiki/Automatic-schema-initialization-for-mnesia
3. Open up boss.config and set db_adapter to mnesia
Using Riak (EXPERIMENTAL)
-------------------------
Riak is a NoSQL database developed by Basho Technologies.
1. Install Riak as described at http://wiki.basho.com/Installation-and-Setup.html
2. Start a Riak node with `sudo riak start`
3. Open up boss.config and set db_adapter to riak.
For query operations to work, you first need to ensure that search is enabled
in your Riak configuration:
{riak_search, [{enabled, true}]}
Then run the following command in your Riak installation for each model:
bin/search-cmd install <plural model name>
E.g. if you have a "greeting" model the command should be
bin/search-cmd install greetings
Jump to Line
Something went wrong with that request. Please try again.