[CODE4LIB] Putting several small databases online.

2012-06-26 Thread Paul Butler (pbutler3)
Hi All, In the last week the library has been approached by two different departments across campus that have small databases, one FileMaker Pro and one MS Access, that they would like to make available online. The interfaces would be nothing fancy, with a backend that allows for adding/updating

Re: [CODE4LIB] Putting several small databases online.

2012-06-26 Thread Cary Gordon
Drupal is our tool of choice for building CRUD apps. Depending on the data, you can either do an import, or you can connect directly to the data in an external database. Filemaker will likely need to be converted. Modern Access might be able to connect directly through PDO, although I would avoid t

Re: [CODE4LIB] Putting several small databases online.

2012-06-26 Thread Kaile Zhu
I guess you made the simple thing complicated. If you have LAMP, which is easy to implement, you would have a decent DBMS, that is MySQL. Then, you probably need mysqladmin or workbench utilities to manage your server. Everything is free. Kelly Zhu -Original Message- From: Code for

Re: [CODE4LIB] Putting several small databases online.

2012-06-26 Thread Kevin Hawkins
If these are working databases used by just a handful of people, not things you're trying to preserve for the long run, then for the FileMaker one I would consider using FileMaker Pro's built-in "instant web publishing" feature. More on this and other options are at: http://help.filemaker.com

Re: [CODE4LIB] Putting several small databases online.

2012-06-26 Thread Clinton Boyda
There are other methods of putting data online, like Google's spreadsheet etc. I just wanted to point out, the "simplicity" of putting a small database online can require a professional skill set. Security permissions need to be set correctly, and a database is very rarely store on the same ser