[Ohiodig] Software as a service database systems

[Collier, Sarah K.]

Hi Susan, have to looked at Airtable?
Not sure if it’ll fit all you are looking for, but it is a relatively easy tool to learn and acts as a database. OSU is currently looking into it as a project management information solution.
Sarah

[The Ohio State University]
Sarah Collier, CAPM, PMI-DASM
Digitization & Conservation Project Manager
University Libraries
1165 Kinnear Road, Libraries Tech Center Room 138A, Columbus, OH 43212-1153
614-514-5851 Office
collier.330 at osu.edu<mailto:collier.330 at osu.edu>
OSUL Staff Advisory Council 2021-23

“To bear trials with a calm mind robs misfortune of its strength and burden.”
-Seneca

From: Ohiodig <ohiodig-bounces at lists.library.ohio.gov> On Behalf Of Susan Hernandez via Ohiodig
Sent: Monday, December 19, 2022 11:01 AM
To: ohiodig at lists.library.ohio.gov
Subject: [Ohiodig] Software as a service database systems

Dear collective wisdom, I’m in search of recommendations for software that can host and share databases online. Requirements: Easy to use—no one has time for any significant development Allows uploading data in bulk via CSV or a similar method

Dear collective wisdom,

I’m in search of recommendations for software that can host and share databases online.

Requirements:

  *   Easy to use—no one has time for any significant development
  *   Allows uploading data in bulk via CSV or a similar method
  *   Has searching and filtering capabilities
  *   The database must be sharable with the public (no sign in required)
Backstory: The library and archives (my department) currently has a website that is separate from the museum’s main website. As part of a major website overhaul, our two sites are going to be combined. However, the new website will not have the capability to host one of our databases, which is currently in Drupal, and our digital/technology team will not have time to build us a new system prior to the launch of the new website. I’m doing my due diligence to see if there is anything acceptable on the market that we could purchase and get up and running relatively quickly. If I can’t find a suitable product, I will need to advocate to have the current Drupal database maintained, which would be a heavy lift for a variety of reasons.

The database is essentially three tables and isn’t super complicated, but it is largeish, there are over 46,000 lines in one of the tables. In case anyone wants to check it out, here it is in its current form: https://library.clevelandart.org/may-show<https://urldefense.com/v3/__https:/library.clevelandart.org/may-show__;!!KGKeukY!xNsy4cL4JnCh1IwXe0TylZolP1UrsmQWQ0g64bf9R5hGZSK2FYgUl5-WYnJB9mxGQlky0BEMQ_7hQxw1YJgrYIGPaOUgy7oi$>. It isn’t fabulous, but it mostly works 😊

I’d be grateful for any thoughts you all have!

Susan Hernandez
Digital Archivist and Systems Librarian
The Cleveland Museum of Art
11150 East Boulevard
Cleveland, Ohio 44106-1797
Pronouns: She/Her/Hers

T 216-707-2660

[https://www.clevelandart.org/images/eNews/signatures/banner.png]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.library.ohio.gov/pipermail/ohiodig/attachments/20221219/5f3fc70a/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3605 bytes
Desc: image001.png
URL: <https://lists.library.ohio.gov/pipermail/ohiodig/attachments/20221219/5f3fc70a/attachment-0001.png>