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.
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.
Database on MacOS? It depends what you're planning to do with it? Please provide some details on its intended use.
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.
I like POSTGres but if you can get MariaDB like walkman suggests then its great.
I'd say, like tod, whatever works for you is good. Personally, I use PostgreSQL on FreeBSD and it's been solid.
#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.
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.
re #6 There's a Jack Chick comic strip waiting to happen
#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.
resp:9 Amen!
re #9 The name of the bar was Zebra. You deciphered the bar code! As it was revealed in John 2
Q said it first
TheGrinchWhoStoleDuringProtests
To close the loop, I've decided against trying to write my own database application to catalog my library. I found Delicious Library, version 3, by Delicious Monster (delicious-monster.com) that will do what I want. It's not free, but $38.99 isn't bad.
PostgreSQL is good, but for the sorts of things you're talking about, it seems like SQLite would be just fine.
I have a question about apache2 redirects. I have a wordpress install which is in: /usr/share/wordpress My apache2 redirect (/var/www/html/.htaccess) looks like this: Redirect / http://domain.com/blog This effectively redirects the apache2 to the /usr/share/wordpress directory. However, I also have Nextcloud installed in /var/www/html/nextcloud. Is there a way to have (2) redirects? One for domain.com/blog (the wordpress install /usr/share/wordpress) and One for domain.com/nextcloud (the nextcloud install /var/www/html/nextcloud) If this is possible, what would the .htaccess file look like and are there other steps? Thanks in advance!
Create a file for each site in /etc/apache2/sites-available by copying 000-default.conf modify those then activate the new conf files (This assumes you're using different domain names for each one?) to activate the new conf files use the a2ensite command then restart apache2
the problem is this:
the root domain has an alias "/blog"
I think this is messing up the nextcloud alias.
So the server does this after i enable the nextcloud.conf, enable it and
restart apache2:
type in the address in the web browser:
https://domain.com/nextcloud
this is what it does:
https://domain.com/blogblogblogblogblogblogblogblogblogblognextcloud/
The page isn t redirecting properly
An error occurred during a connection to domain.com
------
and if i enter this:
https://domain.com/blog/nextcloud
I get an internal server error.
------
Alias /nextcloud "/var/www/html/nextcloud/"
<Directory /var/www/html/nextcloud/>
Options +FollowSymlinks
AllowOverride All
<IfModule mod_dav.c>
Dav off
</IfModule>
SetEnv HOME /usr/share/wordpress/nextcloud
SetEnv HTTP_HOME /usr/share/wordpress/nextcloud
</Directory>
---------------
I think the only way to fix this is to move the wordpress to
/var/www/html and not have a "/blog" alias.
I agree - put webserver root under html
I appreciate your help on this!
I just did it - it works now. Not sure why the install of wordpress would go into /usr/share/wordpress to begin with but it seems to be working fine. There's no executable component to wordpress - just plain text files. Easy to back up... I didn't like the idea of using an alias anyway.
You have several choices: