First post might as well be my pinned post! A link to my web projects and a blog, which is mostly about webdev and gaming.

https://scott.itsasite.uk

I discovered Mastodon though editing my profile on Itch.io lol. Now I can fill in that field, yay xD.

I have a super specific requirement in a MySQL query I want to write and wondered if there are any #mysql experts in #fediverse I could ask please? #askfedi

That feels very wrong. #MySQL

#Perl DBD::mysql and the corresponding #RHEL package have always been #MariaDB compatible, i.e., you could install MariaDB and DBD::mysql RPMs together.
But the new DBD::mysql package in #CentOS stream can no longer be installed with MariaDB.
I filed a bug (https://issues.redhat.com/browse/RHEL-88746) and #RedHat said it's not supposed to work. Except it always has.
What do you think?
(Note if it doesn't work then all Perl scripts on the host that use DBD::mysql must be modified to use DBD::MariaDB instead.)
#mysql

Nicht so für die Zielgruppe meiner Website aber trotzdem dort, weil ich nicht wusste, wohin sonst damit...

Danke an @dbrgn für die Mithilfe!

WordPress und phpMyAdmin lokal installieren mit Docker - mit genug Upload-Size, um die DB zu importieren.

Quasi auch "Note to self"

https://samsteiner.net/wordpress-phpmyadmin-docker/ #docker #wordpress #mysql #phpmyadmin

Open Source Linux MySQL Tools!

Was ist MySQL?

MySQL ist ein weit verbreitetes, relationales Datenbankmanagementsystem (RDBMS), das auf der Structured Query Language (SQL) basiert. Es wird häufig für die Speicherung, Verwaltung und Abfrage von Daten in verschiedenen Anwendungen eingesetzt, von kleinen Websites bis hin zu großen Unternehmensanwendungen.

https://www.linuxlinks.com/mysqltools/

I am throwing a fit trying to get the python mysql-connector installed.

pip gives me an error:
error: externally-managed-environment

× This environment is externally managed

How do I get this thing installed? So many of my programs use this.

Migrating your #OpenProject installation?

From Docker to packages, older setups to the latest version, or even switching databases — it’s important to understand your options.

Our latest blog article outlines best practices and recommended paths to guide you through:
https://www.openproject.org/blog/migration-installation-guide/

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.

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

Okay all you #PHP / #MySQL coders out there. Here is a problem. The corporations control everything.

#TidyBot (#TidySearch) is a full blown search engine. The best part is that it's decentralized. No one server has control of the system. No corporations have control of the system. YOU have control. No JavaScript, no AI. You get what your looking for.

Your here on the #Fediverse so you apparently like the idea of #TakeTheInternetBack from the corporations.

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).