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.

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

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

Setting Up WSL 2: My Development Environment Scripts

https://www.jocheojeda.com/2025/02/24/setting-up-wsl-2-my-development-environment-scripts/

Reference Collection: Simplifying Coding Resources
https://referencecollection.com/

"Offering practical and optimal guidance through evolving community-driven references to simplify your learning journey."

#programming #reference #java #javascript #python
#mysql #postgresql #rust #haskell #vimscript #go #zig #git #docker

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

If, for any reason, you have to pass as a _GET parameter a #MySQL query like
«SELECT * FROM art WHERE style LIKE '%dada%'»
don't forget to replace the % with a %25, or you'll get a dadaist result¹.

Tested in #PHP but I think it's the same in any other language.

Clue for this #hack here:
https://stackoverflow.com/questions/17342671/pass-a-percent-sign-in-a-url-and-get-exact-value-of-it-using-php

~~

¹ https://en.wikipedia.org/wiki/Cadavre_exquis

To the #devops out there, how do you keep backups of you databases? Do you use the specific tool for each database, like pg_dump, mysqldump, etc? Do you have a tool that can do different databases at once? I'm getting to a point that I have many databases at my homelab and I want a solution where I can have it all centralized and that works with different databases. Anything out there? #mysql #postgresql

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.

Huge discount on database developments tool for #SQLServer, #MySQL, #MariaDB, #SQLite, #Oracle, #Firebird, #InterBase, #PostgreSQL and #NexusDB. Get it now at
https://www.upscene.com/

oi, mytop is not my first tool for watching a #mysql db server anymore...
Welcome #dolphie !!!
https://terminaltrove.com/dolphie/

Kennt sich jemand prima mit mysql, bzw. MariaDB bei WordPress-Blogs aus und könnte sich ein paar Zeilen Log anschauen, nachdem der Datenbankserver abgestürzt ist?
#wordpress #mysql #mariadb

hey #php & #mysql buddies
quick question

Our databases are running on VMWare Virtual Hosts
We have "standard" database replication in place between one main instance and three secondary databases

Now... I encounter more and more often issues with this replication
and it always happens at the moment a Veeam backup is scheduled

I do not really find any related information in the server's logs... So wondering if anyone already encountered something like this...
+100 if there is a known solution

#mysql #procedure / #loop for #generating #unique alphanumerical #codes

During the #SharkBytes session at #SharkFest conference I had an opportunity to present a lightning talk about my pet project called IDS Lab.
It is a lab infrastructure deployable as docker containers, which simulates the small company network.

The IDS Lab consists of web webserver with #Wordpress, #MySQL database, #Linux desktop with RDP, the #WireGuard VPN for "remote" workers and for connecting another virtual or physical machines into the lab network.
This part of infrastructure can be used for attack simulations.

There are additional components for playing with logs and detections, too: #Fluentbit, #Suricata and #OpenObserve as lightweight SIEM.

In the #SIEM we already have preconfgured dashboards for alerts, netflows, web logs and logs from windows machines, if present.

Using the provided setup script, the whole lab can be up and running in up to 5 minutes. For more info, please check my GitHub repository with the IDS Lab:

https://github.com/SecurityDungeon/ids-lab/

#sf24eu #wireshark @wireshark

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?

I spent ages writing a detailed blog about migrating my #selfhosted mail server from a #MySQL user store to an #LDAP based one. The particular package I use is iRedMail and many years ago I chose to use SQL as my user store. These days, I'd rather use LDAP because I can integrate it pretty easily with single-sign-on with Authentik.

This is long, and probably really niche. Like how many people were in the same position as me? But, there may be some nuggets in there for anyone migrating to LDAP. My blog is #FreeBSD focused, but wouldn't need much translation for Linux.

SQL cheat sheet #sql #mysql #craftcms #laravel

Yelp switched from #PostgreSQL to #MySQL.

While I understand the rationale why they did that, it's surprising to see how many workarounds they had to implement in order to catch up with features which are native in PG.

https://engineeringblog.yelp.com/amp/2024/10/migrating-from-postgres-to-mysql.html