Installing without PostgreSQL

[kanedo]

Hi,
I'm wondering wether I can use Stringer without PostgreSQL and MySQL instead since my hoster doesn't have PostgreSQL installed.
I changed the adapter in database.yml but it still breaks because of pg sais:

Your PostgreSQL is too old. Either install an older version of this gem or upgrade your database.

Is there any chance to fix this?

[christianschmidt]

If you don't use PostgreSQL you should try removing the PG-related gems from the Gemfile.

[davebradford]

Just a quick comment on this, I'm actually using sqlite3 in production, depending on how many feeds you have you'll probably find it perfectly usable. Plus a lot easier to setup if your host has limitations.

[swanson]

Just be aware that sqlite does not handle concurrent connections well - and since we use a 10-thread pool for fetching feeds you will likely run into SQLite3::BusyException.

[kanedo]

Hi,
I now use sqlite but now I have the problem, that I run into a redirection-loop. It redirects me to /setup/password which is, I think, intended but it doesn't stop. Did I forgot something? Here is a part of what it prints out:

11:25:26 web.1     | 89.0.40.224, 89.0.40.224 - - [09/Jun/2013 11:25:26] "GET / HTTP/1.1" 302 - 0.0033
11:25:26 web.1     | D, [2013-06-09T11:25:26.371316 #17383] DEBUG -- :    (0.1ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | D, [2013-06-09T11:25:26.371847 #17383] DEBUG -- :    (0.1ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | 89.0.40.224, 89.0.40.224 - - [09/Jun/2013 11:25:26] "GET / HTTP/1.1" 302 - 0.0032
11:25:26 web.1     | D, [2013-06-09T11:25:26.441669 #17383] DEBUG -- :    (0.1ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | D, [2013-06-09T11:25:26.442323 #17383] DEBUG -- :    (0.2ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | 89.0.40.224, 89.0.40.224 - - [09/Jun/2013 11:25:26] "GET / HTTP/1.1" 302 - 0.0032
11:25:26 web.1     | D, [2013-06-09T11:25:26.513565 #17383] DEBUG -- :    (0.2ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | D, [2013-06-09T11:25:26.514497 #17383] DEBUG -- :    (0.2ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | 89.0.40.224, 89.0.40.224 - - [09/Jun/2013 11:25:26] "GET / HTTP/1.1" 302 - 0.0049
11:25:26 web.1     | D, [2013-06-09T11:25:26.585877 #17383] DEBUG -- :    (0.1ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | D, [2013-06-09T11:25:26.586533 #17383] DEBUG -- :    (0.1ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | 89.0.40.224, 89.0.40.224 - - [09/Jun/2013 11:25:26] "GET / HTTP/1.1" 302 - 0.0036
11:25:26 web.1     | D, [2013-06-09T11:25:26.818104 #17407] DEBUG -- :    (26.1ms)  SELECT COUNT(*) FROM "users" 
11:25:26 web.1     | D, [2013-06-09T11:25:26.819271 #17407] DEBUG -- :    (0.1ms)  SELECT COUNT(*) FROM "users" 

[swanson]

Closing since Stringer now uses PG in all environments.