Rails - Oct 2005 - using sqlite for development

Are there any hidden pitfalls in developing on sqlite and migrating to
postgresql some time down the line? Right now I''m finding it extremely
convenient to have everything in one directory.

martin

On Oct 12, 2005, at 1:15 PM, Martin DeMello wrote:
> Are there any hidden pitfalls in developing on sqlite and migrating to
> postgresql some time down the line? Right now I''m finding it
extremely
> convenient to have everything in one directory.
This is what I''m doing with BudgetWise, and it works great. The one  
thing to keep in mind is making sure your SQL is portable, if you use  
find_by_sql or similar. If it can''t be, you''ll need to come up
with a
way to use the right SQL with the right adapter.

The schema dumper in edge rails makes moving between DB''s a snap,  
otherwise.

- Jamis

Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org> writes:
> The schema dumper in edge rails makes moving between DB''s a snap,
> otherwise.
This is good to hear.  Might make it easier to experiment with other
databases if there was a good way to dump schema from one to another.
-- 
Doug Alcorn - http://lathi.net/RubyOnRailsDeveloper
doug-jGAhs73c5XxeoWH0uzbU5w@public.gmane.org

On 10/13/05, Jamis Buck <jamis-uHoyYlH2B+GakBO8gow8eQ@public.gmane.org>
wrote:
>
> The schema dumper in edge rails makes moving between DB''s a snap,
> otherwise.
Nice - didn''t know about that.

martin