Temporary Tables - Sqlite in Memory

2010-01-19 Thread Karl
I am thinking of using a temporary table, most likely sqlite in memory table. If I attempt to use the ActiveRecord methods to create a new db connection and create the temporary table, will Heroku intercept these and create the temp table in Postgres? -- You received this message because you are

Re: Temporary Tables - Sqlite in Memory

2010-01-19 Thread Oren Teich
Should work fine. The only magic we do is to dynamically rewrite the database.yml file itself. We don't monkeypatch anything. Oren On Tue, Jan 19, 2010 at 7:24 AM, Karl threadh...@gmail.com wrote: I am thinking of using a temporary table, most likely sqlite in memory table. If I attempt to

Re: Temporary Tables - Sqlite in Memory

2010-01-19 Thread Adam Wiggins
On Tue, Jan 19, 2010 at 7:24 AM, Karl threadh...@gmail.com wrote: I am thinking of using a temporary table, most likely sqlite in memory table. This will work, but take note it will only work for a single dyno, and the contents of the table will disappear periodically when the dyno is cycled.

Re: Temporary Tables - Sqlite in Memory

2010-01-19 Thread Karl
On Jan 19, 2:04 pm, Adam Wiggins a...@heroku.com wrote: This will work, but take note it will only work for a single dyno, and the contents of the table will disappear periodically when the dyno is cycled.  If you add a worker or a second dyno, now you'll have two in-memory tables which don't