|
Grex > Agora > #59: Recommendations for Database Engine/backend | |
|
| Author |
Message |
gelinas
|
|
Recommendations for Database Engine/backend
| 
Oct 10 11:18 UTC 2020 |
It's been a long time since I've wandered the halls of grex, so I don't know
of a better place to put this question.
Every now and again, I get the idea that I should create a database. Libre
Office includes a database front end, but its back end required JDK, which
I don't want to install. So, what's a good database backend? I've heard of
maria and postgresql. Are there others I should look at?
The database engine will be running on MacOS 10.14, Mojave. I don't plan to
make it available over the web.
Thanks.
|
| 21 responses total. |
walkman
|
|
response 1 of 21:
|
Oct 10 12:10 UTC 2020 |
I use mariaDB on my server hosting wordpress. Never lets me down; runs
without a fuss for years now.
I'm running it on a mac mini which has Ubuntu Server as the OS.
So far I haven't used Libre Office to maintain a database though I did
find an article that addresses the issue of mariaDB and LO.
https://ask.libreoffice.org/en/question/79010/how-do-i-set-up-a-jdbc-
connector-for-mariadb-or-mysql-in-base/
Skip to the part "STEP BY STEP" if you are interested.
|
tod
|
|
response 2 of 21:
|
Oct 10 22:04 UTC 2020 |
Database on MacOS?
It depends what you're planning to do with it?
Please provide some details on its intended use.
|
gelinas
|
|
response 3 of 21:
|
Oct 10 23:27 UTC 2020 |
The usual ideas are: a catalog of my library: books, CDs, BluRay/DVD, and a
catalog of my (potential) wine cellar. Right now, my (small) model train
collection is tabulated in a spreadsheet. Why not convert it to a database?
I'm sure other uses will present themselves.
If it were just the library, I might go with a special-purpose app. But I'm
really looking for a general solution.
I'm currently running Mojave on a Mac mini (2018, 3 GHz i5 with 16GB ram).
I'm putting off the upgrade to Catalina because some of my software does not
have the Apple imprimatur. Jumping through Catalina's hoops to make it work
seems more trouble than it's worth. However, I'll eventually have to make the
jump to a new version; it'd be nice that the databases could survive.
|
tod
|
|
response 4 of 21:
|
Oct 11 14:58 UTC 2020 |
I like POSTGres but if you can get MariaDB like walkman suggests then
its great.
|
kentn
|
|
response 5 of 21:
|
Oct 11 19:57 UTC 2020 |
I'd say, like tod, whatever works for you is good. Personally, I use
PostgreSQL on FreeBSD and it's been solid.
|
walkman
|
|
response 6 of 21:
|
Oct 11 21:30 UTC 2020 |
#3 You can use free-online solutions to catalog some of your
collections. For music I use both rateyourmusic.com and discogs.com.
Both allow you to catalog your music. Discogs even has an app with a
bar- code scanner! You can catalog down to the model number, which
corresponds to year, pressing, label, etc.
|
gelinas
|
|
response 7 of 21:
|
Oct 12 04:31 UTC 2020 |
I'm too paranoid to trust my library catalog to the cloud. I would appreciate
the convenience of scanning the UPC to get all the catalog information, but I
don't want just anyone knowing what's in my collection. Cloud storage gets
breached now and again.
I've ordered a copy of _PostGreSQL: Up and Running_. Once I've read it, I'll
proceed with the installation.
It'll be interesting to see how many books we own.
|
tod
|
|
response 8 of 21:
|
Oct 12 19:09 UTC 2020 |
re #6
There's a Jack Chick comic strip waiting to happen
|
walkman
|
|
response 9 of 21:
|
Oct 13 02:11 UTC 2020 |
#8
It seemed harmless at the time but when the bar keep turned his face, I
saw the devil's profile. Jesus shows us the path, away from the sins of
cloud storage.
|