DB in Non-Standard Place

I’ll be doing a deployment soon and looking ahead to the future, I was
wondering what people do with regarding putting a SQLite db in a non
standard place.

The simplest solution to get it out of the app is to move it to another
directory and have rails find it at server startup. Where can I put ruby
code to prepend an absolute path to the :database entry in
config/database.yml.? The absolute path to the database will be
different
from the machine where the application is being developed.

Has anyone played with putting a SQLite DB on cloud? I was thinking of
putting it on UbuntuOne so that the user (my sister) would have access
to
the DB from her local machine should the host hosting the rails app ever
go
down.

The reason for my question is simple, when deploying upgrades, I deploy
the
whole application and not incremental changes.

CIA

-Ants

On Mar 16, 10:15 am, Anthony G. [email protected]
wrote:

I’ll be doing a deployment soon and looking ahead to the future, I was
wondering what people do with regarding putting a SQLite db in a non
standard place.

The simplest solution to get it out of the app is to move it to another
directory and have rails find it at server startup. Where can I put ruby
code to prepend an absolute path to the :database entry in
config/database.yml.? The absolute path to the database will be different
from the machine where the application is being developed.

Add a symlink to the db file upon deploy?

Fred

On 16 March 2010 10:15, Anthony G. [email protected]
wrote:

I’ll be doing a deployment soon and looking ahead to the future, I was
wondering what people do with regarding putting a SQLite db in a non
standard place.

I believe that sqlite is not recommended for production.

Colin

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs