[jifty-devel] create database with SQL

Thomas Sibley trs at bestpractical.com
Fri Oct 1 15:18:28 EDT 2010


On 01 Oct 2010 15:00, Matt Zagrabelny wrote:
>> Well, I think the DB can optimize things by adding certain constraints
>> such as foreign keys, uniques, etc. It doesn't look like Jifty uses
>> those things. Also, I would like to have the DB be the final sanity
>> check for data going in, just in case I need to bypass the application
>> front-end (AKA Jifty.)

You are free to add indexes, unique constraints, etc at the DB level
yourself after Jifty's created everything.  Foreign keys may end up
confusing Jifty.  Give it a try and see.

In the end, Jifty still expects to own your database schema (or at least
most of it).  This lets it provide things like schema versioning and
upgrades.

Thomas


More information about the jifty-devel mailing list