I am new to RoR and had a question that I did not see specifically address here or anywhere else…
My current job uses many databases that someone created years ago from MS Access. Some of these databases simply store/track data, some contain templates to fill in info on a form that prints off a PDF, but the one we use most often is to send requests to support staff in other offices or working remotely (fill out a form, often sent with very large PDFs attached). These MS Access databases are very slow and often get corrupted out of nowhere and/or require maintenance. Sometimes there are issues that pop up that require everyone to get out of the database before they can be fixed, but inevitably someone leaves their computer with the database open, which causes more delays.
I know that I can create an app w/RoR that store/tracks data and that has forms/templates that a user can fill out. I believe that RoR could fix these other issues (speed/maintenance while others continue to use the app/etc.) but I am not 100% sure about the following:
- Can RoR apps be used privately on a server? Not exactly sure how our current databases work, but you can only access them when on company network/server. Are RoR apps only for webpages accessed through internet?
- Can you send large documents interoffice quickly/efficiently w/an RoR app?
- Do RoR apps ever get corrupted like MS Access databases?
- Do updates/fixing bugs/maintenance/etc. require everyone to exit the app like on Access?
I just want to know that RoR can be as big of an upgrade that I think it can be, before I continue down this road of attempting to recreate these databases. I’d like to also talk to my boss about it before I put in the time to make sure they are open to switching, should I be able to create something better. I’ve been doing pragmatic studios courses, which have been awesome but I think I need to actually do something like this in order to continue learning. Thanks in advance for your help, and if anyone has any additional tips/etc. I would greatly appreciate it.