Migrate db to Sqlite

[smgt]

Migrate db to sqlite on development and use postgres on heroku. Use the gem sequel.

Schema:

Sessions:
id - session id
day - start time date YYYY-MM-DD
start - unix timestamp with start time
stop - unix timestamp with stop time
comment - session comment

Day:
day - day id YYYY-MM-DD
work - seconds worked

Settings:
key - id
value - key value

[smgt]

What do you think @qzio? Couch? Mongo?

[qzio]

sqlite is small and easy.

couch, mongo and redis doesn't only require a gem, it also require another daemon to run on the system eating the precious RAM.

but hmm... heruko is nice, they doesn't support files, right? mongo would be easy and nice maybe, does it cost extra? how much? :)

[smgt]

Then sqlite it is!

On 25 okt 2011, at 20:23, joel hansson wrote:

sqlite is small and easy.

couch, mongo and redis doesn't only require a gem, it also require another daemon to run on the system eating the precious RAM.

Reply to this email directly or view it on GitHub:
#10 (comment)

[smgt]

Checked up on heroku. We can use sqlite in development. But when you push to heroku you can use postgres instead. It's automagic.