urbanists.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
We're a server for people who like bikes, transit, and walkable cities. Let's get to know each other!

Server stats:

578
active users

#mysql

4 posts4 participants0 posts today

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.

Some thoughts on my preliminary investigation of #Omeka ( omeka.org/classic/docs/Install ).

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.

omeka.orgInstallation - Omeka Classic User Manual

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.

for those of you who know about web dev . . .

I’m a 90% stack dev (amateur, in my spare time!)

currently I’m building a new web site (OK, four new web sites to be precise)

the HTML works

the PHP works

the mySQL works

I even have some images (with a bit of help and a bit of anguish from an AI image generator)

2 weeks so far

now for the CSS bit

CSS is not my favourite bit

this may take me another 2 weeks!

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?