Some thoughts on my preliminary investigation of #Omeka ( https://omeka.org/classic/docs/Installation/Installing/ ).

Built on pretty standard #LAMP stack.
No official docker image that I could find, so of course I built my own.
Which reminded me why I HATE php.

Anyway.

Some light testing (running locally).
Pretty simple to use (good).
No fancy ideas about creating "presentation" versions of items, and keeping the original upload "pristine". I am of two minds on this - for now, not a problem for me, but I can see how large archives might be problematic.

For example, a MOV file needs to be presented as a MP4 for widest audience. And you probably don't want to lose the original.
With Omeka that means some manual work on the admin side.

It support plugins and themes - I'm of two minds here also. Good way
to extend functionality and allow for customization, but my experience with such things are not good ito longterm stabililty and maintenance.

I'm also not super keen on #MySQL as the db, due to recent corruptions issues with my #Nextcloud instance (moved that to #PostgreSQL ).
BUT, this will be read heavy, so maybe not an issue - hard-ish to corrupt a db by reading from it.

The useage of #DublinCore at least means (I think) in theory, if I really want, I should be able to migrate to another Dublin Core compatible system if needed. So...good.

My verdict - I'm going to play with it some more.
Install some plugins etc, see what happens.
I'm also building up a test set of assets, in case I want to eval something else.

Hi, #Today I decided to try to #getfedihired — I've got many years of experience with web development, programming and production (#HTML, #CSS, #Javascript), I can make myself useful in anything on the open-source side of back end, i.e. the #Perl, #Python, #PHP, #MySQL, #Linux kind of area.

I live in #Sydney Australia and would be happy to work in-office, remote or hybrid.

Let me know of any opportunities, or pass this on to anyone else who might know of something? Thanks.

And the next one is about & Meetup in Bratislava ! #MySQL #Python

Years ago I created a #php #mysql #comics #database
https://sourceforge.net/projects/madcollector/

DM me If you'd be interested in reviving it.

Why TLS for MySQL is difficult https://databaseblog.myname.nl/2025/02/why-tls-for-mysql-is-difficult.html #mysql

Question:

#mysql and #ZFS snapshots... Do I need to stop the MySQL jail or service before I take the ZFS snapshot? Or do I need to lock all tables? Or will it just take a proper snapshot of MySQL at that moment in time without issues?

I got MariaDB installed on Debian which is a better replacement for MySQL, right?

I do remember using MariaDB many years ago... for what I need it should work just fine I assume.

(Some simple web site databases, WordPress, etc.)

#Development #Launches
SQL Noir · A game to learn SQL by solving crimes https://ilo.im/162ciw

_____
#OpenSource #Game #Database #SQL #MySQL #SQLite #PostgreSQL #Npm #WebDev #Backend

Harness is hiring Staff Software Engineer - Software Engineering Insights

#java #aws #azure #cicd #docker #elasticsearch #gcp #mysql #postgresql #sql
Mountain View, California
Full-time
Harness

Job details https://jobsfordevelopers.com/jobs/staff-software-engineer-software-engineering-insights-at-harness-io-oct-15-2024-18620e?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Public disclosure of security vulnerability in @writefreely (https://github.com/writefreely/writefreely):

I reported this privately to the project maintainers back in October. There has been no further movement from them since I made my initial report, so I have decided to make this public so that #writefreely admins can properly secure their instances.

Affects: Any Writefreely instance backed by a #mysql database running on any #linux-based platform (other platforms may be affected as well, I have not tested).

Can someone recommend a #privacy friendly #app, running on #grapheneos and not from the google play store, which I can use to connect to my #mysql database?

Help me answer another question for the students. Have you professionally worked with an Oracle DB in the last several years or something else?

Should URI::mysql Switch to DBD::MariaDB?

https://justatheory.com/2025/01/uri-mysql-mariadb/

Need help... MariaDB is giving me Warning and Error messages in the log about InnoDB corruption in my Nextcloud table. Tried backups but no joy. Seems I need to rebuild... Before I get stuck into new territory for me, anyone an expert in MariaDB/Mysql and the InnoDB tables?
Poor, but just about legible when zoomed, screenshot. This seems the only error, repeated over. #mariadb #mysql #innodb #database #NextCloud #askfedi

The #s390x open source software team at IBM confirms the latest versions of various software packages run well on #Linux on #IBMZ & #LinuxONE

In November 2024 validation was maintained for over 35 projects, including #MySQL, #PHP, & #RabbitMQ

We also saw community CI added for SuperNOVAs, and CI with binaries for PolyNode & PocketBase

Full report + how to apply for your own s390x VM for your project: https://community.ibm.com/community/user/ibmz-and-linuxone/blogs/elizabeth-k-joseph1/2024/12/23/linuxone-open-source-report-november-2024

Happy birthday, #Finland!

There were many challenges along the way threatening the country’s independence, and new threats have recently manifested, but somehow the people pushed through and here we still are.

Finland has defined and created many of the things that drive our world today (#Linux, #MySQL, #GSM, #IRC, #SMS etc etc). Hats off to such an indomitable nation.

"Outerbase Studio" is an #opensource lightweight #database GUI in your browser. It supports connecting to #Postgres, #MySQL, and #SQLite.

https://github.com/outerbase/studio

Am I thinking about #Postgres backups in my #homelab wrong?

I run a lot of apps in containers. Each one gets its own Postgres DB instance. Restoring one of these apps (e.g., mattermost, mastodon, authentik) requires restoring the container's volumes and restoring the database back to a sane state.

I have snapshots of the VM and NFS backups of the VM snapshots via Xen Orchestra backup. If I had to restore, those are not gonna give me consistent restores of a postgres db, which might be in the middle of a disk write or something when the VM snapshot is taken.

So it seems to me that I either (a) add some job inside each container that runs pg_dump to an NFS volume,
(b) run docker exec on the container host to run pg_dump inside each container and pull the dump file out, or (c) enable postgres network connectivity to some backup node that runs pg_dump via remote, and then archives and manages the resulting files.

Having done this, I also want to gradually expire backups over time and so on. I don't think I need to write this all from scratch. Anybody know an OSS tool?

It's like 3 #MySQL DBs and 5 Postgres DBs. Most are tiny (100Mb or less). One of them is 6Gb, but I have that backed up differently already. It doesn't have to be big to be important.

Thoughts?