support for mysql, or even sqlite? about showterm.io HOT 7 CLOSED

It's postgres because I currently host it on Heroku (which has the best postgres support). Feel free to send a patch that uses MySQL in a different Gemfile group with some kind of config option (it shouldn't be too hard to make it work, as we're not using any big features of the DB).

Maybe we should just use Mongo ;).

from showterm.io.

mongo IS a good attribute/value key store db. I am a terrible developer but I will certainly take a look.

from showterm.io.

sqlite can be used by replacing

gem 'pg'

with

gem 'sqlite3'

in the Gemfile and construct a config/database.yml to match, ala

development:
  adapter: sqlite3
  database: db/development.sqlite3
  pool: 5
  timeout: 5000

test:
  adapter: sqlite3
  database: db/test.sqlite3
  pool: 5
  timeout: 5000

production:
  adapter: sqlite3
  database: db/production.sqlite3
  pool: 5
  timeout: 5000

I'm using this without issue thus far.

from showterm.io.

Awesome. Thank you.

from showterm.io.

Work fine with MySQL too

Replace

gem 'pg'

with

gem 'mysql2'

And adapt config/database.yml like this

production:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: showterm
  pool: 10
  username: ******
  password: "************"
development:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: showterm_development
  pool: 5
  username: ******
  password: "************"
test:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: showterm_test
  pool: 5
  username: ******
  password: "************"

from showterm.io.

Great! Could you please send a pull request to add docs to the bottom of the README?

from showterm.io.

done.

from showterm.io.