Re: [CODE4LIB] Good Database Software for a Digital Project?

On Sat, Apr 16, 2016 at 7:15 AM, Matt Sherman wrote: > Thanks for all the advice folks, this gives me a lot to look into. You all > have certainly made me table MySQL, so now to look into PostgreSQL, Solr, > XTF, and some of these other technologies to see what would

Re: [CODE4LIB] Good Database Software for a Digital Project?

Since you mention the requirement to publish and maintain it on the web, another (NoSQL) option for your data storage would be a SPARQL graph store (such as Apache Fuseki). Loading the data would involve transforming each citation into an RDF graph and storing it as a named graph with an HTTP PUT,

Re: [CODE4LIB] Good Database Software for a Digital Project?

Thanks for all the advice folks, this gives me a lot to look into. You all have certainly made me table MySQL, so now to look into PostgreSQL, Solr, XTF, and some of these other technologies to see what would be the best fit. It is always so helpful pinging this group as you all have so many

Re: [CODE4LIB] Good Database Software for a Digital Project?

Hi Matt, You may wish to give a try to J-ISIS https://kenai.com/projects/j-isis/downloads With J-ISIS, you can create a searchable database with a couple of clicks. It uses Berkeley Database as persistence manager and Lucene for indexing and searching. The user can concentrate on the domain and

Re: [CODE4LIB] Good Database Software for a Digital Project?

Well, we've got one volume done, with about 1,250 bibliographies, but there are 3 other volumes to convert. So at the end of the day probably about 5,000 entries. Though the how is to make it intractable via the web and hopefully letting scholars in the field continue to add to the database once

Re: [CODE4LIB] Good Database Software for a Digital Project?

On Fri, Apr 15, 2016 at 11:53 AM, Roy Tennant wrote: > In my experience, for a number of use cases, including possibly this one, > a database is overkill. Often, flat files in a directory system indexed by > something like Solr is plenty and you avoid the inevitable

Re: [CODE4LIB] Good Database Software for a Digital Project?

We use MySQL and now mostly Maria. While I agree that PostgeSQL might be technically advantageous in some ways, its ubiquity and the easy availability of many free and paid support options make it a great choice. That said, I think you should examine and explore the possibilities offered by Solr

Re: [CODE4LIB] Good Database Software for a Digital Project?

What technologies are you comfortable with for CRUD? That may help inform your choice of data source. Do you want full text searching? Will this project live on a web page when completed? As well- are there existing databases program available for you to add yours to? How many records are

Re: [CODE4LIB] Good Database Software for a Digital Project?

On 15 April 2016, Roy Tennant wrote: In my experience, for a number of use cases, including possibly this one, a database is overkill. Often, flat files in a directory system indexed by something like Solr is plenty and you avoid the inevitable headaches of being a database administrator.

Re: [CODE4LIB] Good Database Software for a Digital Project?

3 PM > To: CODE4LIB@LISTSERV.ND.EDU > Subject: Re: [CODE4LIB] Good Database Software for a Digital Project? > > I would suggest looking at postgresql <http://www.postgresql.org/>. It > may not be as widely used as mysql, but it is used a lot, and it's a > high-quality piece

Re: [CODE4LIB] Good Database Software for a Digital Project?

Hi Matt, It's very hard to provide a responsible recommendation without further details, so this is just going to be a quick overview of *relational database* options. It might be that some of the other recommendations fit your needs better. For example, if your users aren't at ease with SQL,

Re: [CODE4LIB] Good Database Software for a Digital Project?

It is OCRed text that we've forced in the a delimited text file format. So there are a lot of ways we can spin it. I am just not as familiar with the storage/query systems we could put it in. On Fri, Apr 15, 2016 at 2:44 PM, Gregory Murray wrote: > Matt, > > If the

Re: [CODE4LIB] Good Database Software for a Digital Project?

Matt, If the annotated bibliography is already in XML form, or if the data it is suited to a hierarchical structure, you may want to consider using a native XML database (the most common open-source ones are eXist and BaseX) and querying it with XQuery. Greg On 4/15/16, 2:18 PM, "Code for

Re: [CODE4LIB] Good Database Software for a Digital Project?

Have a look at http://grimoire.ca/mysql/choose-something-else: "Considering MySQL? Use something else. Already on MySQL? Migrate. For every successful project built on MySQL, you could uncover a history of time wasted mitigating MySQL's inadequacies, masked by a hard-won, but

Re: [CODE4LIB] Good Database Software for a Digital Project?

[CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Ben Cail [benjamin_c...@brown.edu] Sent: Friday, April 15, 2016 2:23 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Good Database Software for a Digital Project? I would suggest looking at postgresql <http://www.postgresql.org/>.

Re: [CODE4LIB] Good Database Software for a Digital Project?

Well, this is a side project with just 2 of us working on it, and I have the tech skills so it is more of what I need to learn to make it work. On Fri, Apr 15, 2016 at 2:22 PM, Ethan Gruber wrote: > There are countless ways to approach the problem, but I suggest beginning >

Re: [CODE4LIB] Good Database Software for a Digital Project?

It might be worth checking out some existing solutions to the problem. Zotero is a pretty good tool for collecting, organizing, and sharing citation data - open source, works through a browser plug-in, collaboration capabilities (though the server code is a bit harder to get one's hands on).

Re: [CODE4LIB] Good Database Software for a Digital Project?

I would suggest looking at postgresql . It may not be as widely used as mysql, but it is used a lot, and it's a high-quality piece of database software. It's also free. -Ben On 04/15/2016 02:18 PM, Matt Sherman wrote: Hi all, I am looking to pick the group brain

Re: [CODE4LIB] Good Database Software for a Digital Project?

There are countless ways to approach the problem, but I suggest beginning with tools that are within the area of expertise of your staff. Mapping disparate structured formats into a single Solr instance for fast search and retrieval is one possibility. On Fri, Apr 15, 2016 at 2:18 PM, Matt

[CODE4LIB] Good Database Software for a Digital Project?

Hi all, I am looking to pick the group brain as to what might be the most useful database software for a digital project I am collaborating on. We are working on converting an annotated bibliography to a searchable database. While I have the data in a few structured formats, we need to figure