Currently stuck with "No support for ALTER of constraints in SQLite dialect")
NotImplementedError: No support for ALTER of constraints in SQLite dialect error with SQLite in SQLAlchemy. Discussing plans to switch over to either SQL or NoSQL.
http://stackoverflow.com/a/2581859
http://stackoverflow.com/questions/2559411/sql-mysql-vs-nosql-couchdb
Current schema is
CREATE TABLE roles
(
id INT,
name VARCHAR (64) UNIQUE,
defaultpermission BOOLEAN DEFAULT False,
permissions INT,
PRIMARY KEY (id)
);
CREATE TABLE reviewers
(
id INT,
email VARCHAR(64) UNIQUE,
username VARCHAR(64) UNIQUE,
password_hash VARCHAR(128),
role_id INT,
confirmed BOOLEAN,
agreement FLOAT,
reputation FLOAT,
PRIMARY KEY (id),
FOREIGN KEY (role_id) REFERENCES roles(id)
);