Forum: Ruby on Rails Newbie : Access - Rail , Sqlite combo

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
F81e98fee5032b2161cf62a585b8d365?d=identicon&s=25 nexneo (Guest)
on 2005-12-02 07:58
(Received via mailing list)
We have our company database in access and also front end in access-vba.
now I'm planning to move that database to sqlite and want to create
front
end in rails+ajax
(main cause for this move is freedom from OS dependence for end user )

pls advice on following
1) how to export data from access file to sqlite db file.
2) In rails how easy is to export some data to excel and report to pdf
file
3) my idea of moving from desktop application to web based application
is
going to work or not.

Regards
Niket
3fdda7e032a5619199486d05b506ced4?d=identicon&s=25 Brad Daily (bdaily)
on 2005-12-02 08:21
We are doing something very similar right now. We have a MS SQL server
with an Access VBA front-end that we are transitioning to a Rails/MySQL
setup. It is working very well so far...

> 1) how to export data from access file to sqlite db file.

Not exactly sure here, but can relate our experiences with SQL. We are
using the data transformation services to export to unicode CSV files
that we then import into MySQL. This makes sense for us because we are
tweaking the naming of our tables and columns to line up with rails
conventions.

I would take a hard look at MySQL or PostgreSQL instead of SQLite in
your situation. Sounds like you need a full featured DB...

> 2) In rails how easy is to export some data to excel and report to pdf
> file

Others will have to weigh in here, but I know both are possible.

> 3) my idea of moving from desktop application to web based application
> is
> going to work or not.

It's working great for us, no more need for every computer to have
Access, better user authentication, remote access, not to mention a lot
more control over our development process...
5b1c58ca5016a810cc7e54db31bf90ce?d=identicon&s=25 niket (Guest)
on 2005-12-02 09:00
(Received via mailing list)
thanks for quick answer.. rails already has gr8 community.


>
> > 1) how to export data from access file to sqlite db file.
>
> Not exactly sure here, but can relate our experiences with SQL. We are
> using the data transformation services to export to unicode CSV files
> that we then import into MySQL. This makes sense for us because we are
> tweaking the naming of our tables and columns to line up with rails
> conventions.

exporting to CSV is done. now how to import data in sqlite??

>
> I would take a hard look at MySQL or PostgreSQL instead of SQLite in
> your situation. Sounds like you need a full featured DB...

I had a look at mysql(also done importing of my data and build a
sample application with use of mysql)  but as per our situation sqlite
will work fine. and I'm very new to sqlite.

>
> > 2) In rails how easy is to export some data to excel and report to pdf
> > file
>
> Others will have to weigh in here, but I know both are possible.

ok

>
> > 3) my idea of moving from desktop application to web based application
> > is
> > going to work or not.
>
> It's working great for us, no more need for every computer to have
> Access, better user authentication, remote access, not to mention a lot
> more control over our development process...

noted. and I will work hard to achive the better usability than access
project.
pls add more views.

Regds
Niket
This topic is locked and can not be replied to.