Help with : auto complete, cross platform issues, directory access and database migration in Rails

Hi Everyone,

I have four problems which I haven’t been able to solve for a while,
and would appreciate any help:

  1. Autocomplete question:
    I moved an application I started in Rails 1.0 (rriki.sf.net) to Rails
    2.0 by looking at all the deprecated warnings. I no longer have the
    deprecated warnings, but auto complete no longer works. I installed
    the plugin, but it still does not work. ANY pointer as to how to get
    it working will be helpful.

  2. Cross-platform question
    I generated the scaffold on a windows machine. I was really happy to
    see that the same exact code worked on Mac OS X without any
    alteration, right off the bat. Go Ruby!

However as I was fiddling with autocomplete installation I realized
that the scripts had been coded to invoke ruby the windows way (e.g. c:
\Programs\ruby) rather than the linux way (/usr/bin/env ruby) which
was an easy fix:

Is there a way to convert a windows generated project so it will work
in linux?

  1. Directory access question
    Is there a way for the application to serve up files that exist out
    side the folder tree of the app?
    I use the app to access papers in pdf format and right now I have
    stored the pdfs inside the source tree, making it inelegant: my
    research papers are mixed in with the source code of my reference
    manager (rriki) and I find that not so good.

  2. Database migration
    I started off using MySQL. I think however, I would like to use
    sqlite-3 and store the database outside the source tree, along with my
    research documents.

Does any one know of a proper way to move all the data in a MySQL
database into a sqlite-3 database?

Many, many thanks to anyone who can help be a little bit with these
things.
-Kaushik