adds indexes and remove an attribute
changes to use in-memory sqlite in tests
refactors a gulpfile