Can anyone recommend a simple relational database software (not Access!)?
Hi,
I am posting to ask for suggestions for a freeware, easy to use multi-relational database program I can use in association with Zotero and generally in my research.
I am a newbie with a background in social science and history. I am trying to adapt Zotero to how historians and social scientists take notes and organize their research.
I plan to create a relational database to store my Zotero tags and probably a few other references I will be inputting into Zotero.
I have a copy of MS Access, but do not like it. I think it is more for writing programs to routinely manage complex database like inventories. I want an on-the-fly database software program. I find Access very cumbersome for one-off queries. I also do not want to adapt the Excel database function to my needs.
I fondly remember Database IV for Windows. Unfortunately, I threw my copy out years ago and prefer to use freeware when I can. Something like it would probably be ideal
So, if you could recommend a free, intuitive, simple, drop & drag, WYSIWYG database software for simple table linking and SQL queries I would be very grateful.
I have done some Googling for possible candidates, but there are quite a few. It would take quite a while to install and test them to find the best one.
Here are the links to possible candidates for those who might also be looking for easy to use database software:
https://alternativeto.net/browse/search/?q=dbase&license=free&platform=windows
https://www.tpsort.com/similar-to/35105-top-15-winsql-alternative-and-similar-softwares
https://alternative.tips/winsql-alternatives-2620
https://alternativeto.net/software/open-office---base/
https://alternativeto.net/software/tellico/
https://alternativeto.net/software/kexi/
https://www.makeuseof.com/tag/5-easy-use-free-alternatives-microsoft-access/
https://www.ssuiteoffice.com/categories/database.htm
My thanks in advance for you comments, advice and suggestions.
I am posting to ask for suggestions for a freeware, easy to use multi-relational database program I can use in association with Zotero and generally in my research.
I am a newbie with a background in social science and history. I am trying to adapt Zotero to how historians and social scientists take notes and organize their research.
I plan to create a relational database to store my Zotero tags and probably a few other references I will be inputting into Zotero.
I have a copy of MS Access, but do not like it. I think it is more for writing programs to routinely manage complex database like inventories. I want an on-the-fly database software program. I find Access very cumbersome for one-off queries. I also do not want to adapt the Excel database function to my needs.
I fondly remember Database IV for Windows. Unfortunately, I threw my copy out years ago and prefer to use freeware when I can. Something like it would probably be ideal
So, if you could recommend a free, intuitive, simple, drop & drag, WYSIWYG database software for simple table linking and SQL queries I would be very grateful.
I have done some Googling for possible candidates, but there are quite a few. It would take quite a while to install and test them to find the best one.
Here are the links to possible candidates for those who might also be looking for easy to use database software:
https://alternativeto.net/browse/search/?q=dbase&license=free&platform=windows
https://www.tpsort.com/similar-to/35105-top-15-winsql-alternative-and-similar-softwares
https://alternative.tips/winsql-alternatives-2620
https://alternativeto.net/software/open-office---base/
https://alternativeto.net/software/tellico/
https://alternativeto.net/software/kexi/
https://www.makeuseof.com/tag/5-easy-use-free-alternatives-microsoft-access/
https://www.ssuiteoffice.com/categories/database.htm
My thanks in advance for you comments, advice and suggestions.
If you are on a Mac you might also want to look at Devonthink. Technically not a relational database but it is quite powerful and might work.
https://github.com/retorquere/zotero-seektable-export
This works well to export data to a CSV table which can then be imported to Seektable:
http://www.seektable.com
From there you can do pivot tables and other searches surrounding your tags and other fields.
If you are looking to do something more advanced, as a private project Emiliano also wrote a sync utility to output an entire Zotero library to Postgres SQL. I can share further details if you are interested.
I am planning to soon release a beta version of a website which will incorporate Zotero, MySQL, Postgre SQL, and other software to organize the literatue of medicine. If you are interested in participating to extend that to the humanities, contact me (my login name is my email) and I would be glad to discuss this further.
Even though my first reflex is usually to seek out open source solutions, I would not recommend LibreOffice base. I find it to be less usable than even MS Access (and that's saying something), and you're either stuck using the internal HBase (written in Java, if you want to interact with it, you're looking at Java programming), or an as of yet very unstable implementation of Firebase support (an otherwise very capable database).
Regarding the web-based database software, I should have stated that I do not like to use the cloud or web-based software for security reasons. I prefer to keep everything on my desktop. That goes for the database software I am looking for as well.
I am looking for a desktop database program to keep track of my Zotero database. I am still thinking how I should structure my Zotero database. I will need, for example, to keep track of the tags I create and whatever data I record in the related field.
I am presently grappling with two major issues. Firstly, how to structure my Zotero database by note items rather than by citations. My impression is that Zotero is oriented more towards recording citations that have notes rather than notes that have bibliographical references. Perhaps I am conceptually unable to make the leap from index cards to digital databases.
For a fuller explanation of what I mean, see the addendum to this response.
Secondly, if I should structure my Zotero database with tags or with sub collections or some combination thereof. My impression is that they are something of
alternatives with the possibility that sub collections could quickly become very unwieldy.
I have extensively Googled these issues without too much success. The notes versus citation issue was extensively discussed over a decade ago in the Zotero forum. I imagine that since then the ability of Zotero to handle notes has greatly improved.
I do not want to reinvent the wheel, so I am thinking of putting a post on the forum asking how members have structured their Zotero databases around notes rather than citations.
As to my description of MS Access as for "writing programs to routinely manage complex database". I was trying to say that Access seems oriented towards writing programs in visual basic to manage and analyze databases. I found it cumbersome and time consuming compared to Dbase IV for a one-off analysis of a database.
Thanks again for your suggestions and comments. I very much appreciate them, as I will anything you might have to say in response to my reply.
NOTES vs. CITATIONS
I am, for example, planning to write various pieces on the voluminous works of Karl Marx. One article will be on his view of post capitalist society. Another will address his various accounts of class. Still another will explain that his belief that capitalists exploited proletarians did not rest on his theory of value.
I do not think it makes sense to structure my Zotero database by the various books that Marx wrote (Capital, Grundrisse, Civil Wars in France, etc.). Instead, I want to structure my Marx data by either subject (‘class’, ‘value’, ‘surplus value’, ‘landlord class’, ‘servant class’, “creative labor”, “Milton” etc.) or, perhaps the articles I intend to write (thought I am skeptical of this approach).
Fortunately, a historian long ago suggested how to structure Zotero by subject rather than citation. (See: https://www.chronicle.com/blogs/profhacker/taking-better-notes-in-zotero/36561).
My understanding of his suggestion is to rely exclusively on notes and have only one citation collection. All the individual item notes from a book or article would be related to the item citation through the ‘related’ field of both the item note and the item citation.
More concretely, I would have a single bibliography as a collection (named ‘bibliography’). The entry that would appear in the related field in both the item citations in the bibliography collection and the note item would use the ‘short title’ form of referencing a source e.g. Jones [1975], Jones, A [1975] (if there are two articles/books etc. by authors names Jones in 1975). (See: https://www.kcl.ac.uk/artshums/depts/french/pdf/style.pdf).
I would, for example, have a citation item for Capital, Volume I, Karl Marx, 1859 etc. In the related field of this citation item would be, Marx, Capital [1859]. In a collection labelled 'Marx' I would have item notes with first lines reading, say, Surplus Value p. 85, Capitalists qua capitalists do not work pp. 44-45, Value equals price (for purposes of exposition) p. 98. In the related fields of each of these item notes would be Marx, Capital [1859].
I have yet to fully explore the possibilities of the Zotero ‘related’ field to see how feasible this is.
https://www.devontechnologies.com/apps/devonthink
Thanks for your help and advice. I very much appreciate it.
I've started using Apache Open Office Base. So far it seems to be dong the trick.
As for my plan to structure my Zotero database solely with notes (outlined) above), I've moved away from that. I'm now thinking of a combination of collections, sub collections and item notes, mostly relying on citations within collections, with these collections being organized by the articles I plan to write.
What I am wrestling with is a) not getting too many sub collections b) the tag hierarchy problem which has been much discussed on this forum
Thanks again for your suggestions and comments
https://github.com/giowck/symphytum#symphytum
I first tried Apache Open Office and then switched to LibreOffice Base when I learned that Apache Open Office had suspended further development. Unfortunately, Base did not seem to have all the menu features that I needed that MS Access did. I don't want to write scripts.
I've looked at quite a few other database products including Symphytum which got a poor review here: https://www.macworld.com/article/2060829/symphytum-1-1-review-bento-like-database-app-a-work-in-progress.html.
I ended up where I didn't want to: back to MS Access. The worst thing was it kept crashing on me. I had to reinstall MS Office and then do a Windows 10 reinstall that left my programs/apps and files unaffected. Even after that, Access kept crashing when I invoked certain wizards. After searching through the Windows event viewer and running scan now Dism etc. I finally seem to have Access working. Wish me luck!
I now have a database to keep track of my tags.
The last thing I need is a software program that will display my collections and sub collections (I'm still having trouble conceptualizing/visualizing this) as tree diagrams.
Genealogy/family tree software might be adaptable. MS PowerPoint allows for tree-like organization structures, but they are limited to the size of a slide. I could probably customize something in MS Excel. A purpose built software would still be preferable.
I'd be interested to know how other Zotero users keep a balance between sub folders and tags. I can see it would be very easy to run wild with sub collections and soon find yourself with a collection that is ten deep and twenty wide at its deepest.
I've perused quite a few discussions of the collections/sub collections vs tags issue (e.g. https://forums.zotero.org/discussion/79/hierarchical-tags/, https://www.reddit.com/r/AskAcademia/comments/8mhdc9/how_to_organise_my_zotero_collections_or/). The problem with deep tree structures seems to be writing the searches to generate the Various Zotero outputs. The advantage of deep tree structures is they are easy to organize and visualize. Tags on the other hand seem to rely a lot more on memory.
Anyway, any thoughts or advice on this issue would be welcome.
Thanks again for your thoughts and suggestions.
Final comment: yes it is probably a very good idea not to edit your Zotero database in another database program and then import it back into Zotero. After forty years of using computers I know one thing: computers are very 'picky'.
1) So can I use an MS Access to populate a Zotero interface? OR
2) Allow collaborators to alter Zotero Bibliographic data and link it with other tables like the publisher contact, location fields, and status of the title?
Thank you
2) Also not with any existing tools. There are workarounds and again, probably scriptable solutions, but nothing that would be easy to use.
HOWEVER, I also found I did not actually need a relational database as I really only needed to capture the data and the underlying reference .pdf add a few fields for my personal notes and compositions and VOILA. I discovered that I could do everything I need to do (Import my entire Zotero collection, via export to .csv, import from .csv, with Symphytum which is a simplistic desktop database (not relational at all) and I had everyting I needed upon initial import with one exception. The underlying file (.pdf) is listed as a file address and the Field Type is 'file attachment' I created a new field for the file under Field Type 'file list' and then as I entered or imported additional records I wold copy the file address (can be more than one) from the 'file attachment' field and paste it into the 'file list' field.
The benefit of doing this is that from within the record, where you might be entering notes or compositions you can double click the 'file list':file name and it will open onscreen with acrobat reader (or whatever pdf reader you use) This allows you to stay in the record wile brining up the original document. One notable difference between using FileMaker vs Symphytum for a simple (non-relational) database is that Symphytum works on Windows, Apple and Linux. FileMaker only works on Apple and Windows. For Linus users Symphytum is in the software repository for most distributions
I've checked the documentation for both and if you are still running Windows then it is fully supported, as of course is Mac, Linux and Android.
* https://mariadb.com/kb/en/
* https://www.sqlite.org/index.html
* https://www.sqlite.org/about.html