How to set up a plugin to use Git Updater?

I'm a plugin author, and have some users who want to use Git Updater rather than the w.org repo to update my stuff.

I'm looking for some "here's what you do, plugin author" documentation on this, and I'm coming up short.

Reading between the lines of the Git Updater documentation, it looks to me like installing a plugin with Git Updater copies the entire contents of the Primary branch: whatever header it finds in the main plugin file (or theme style.css).

And updating it compares the Version: 1.2.3 headers in the presently installed plugin and the Github (or Gitlab &c) repo.

It looks like Git Updater, unlike the w.org repo svn setup, doesn't use the Version 1.2.3 header to decide which tagged version to install. And unlike 10up's CI workflows, it looks like Git Updater doesn't honor .distignore, so it pulls unit tests and other build-time assets as well as runtime.

Is there a commonly accepted way of setting up for Git Update? Does anybody have any guidelines for that? Ideally, it would do more-or-less what the w.org repo does with tags. But I'll be happy with any convention that lots of people follow.

Thanks.

reddit.com
u/Aggressive_Ad_5454 — 6 days ago
▲ 4 r/mysql

Creating a new database? Don't neglect timezones

I've seen a few posts recently about things to keep in mind when creating new database applications. So here's my contribution.

Timezones are important in global database applications.

Figure out your timezone situation on your TIMESTAMP and DATETIME columns before you start storing data as your new application comes online. Retrofitting timezone support into existing databases is hard and error-prone.

If you're located in, I dunno, California USA, and you get customers in, I dunno, Perth Australia, and you don't figure out how you'll handle timezones, you'll end up with some unspeakably gnarly code.

Here are some things to think about doing in your database and the software using it.

  1. Make sure the servers running your MariaDB or MySQL instance are set to the UTC (also called Zulu or Greenwich Mean Time) time zone. That doesn't change with daylight time.

  2. Make sure the MariaDb / MySQL time zone tables are loaded. This web page tells you or your operations person how to do that. https://dev.mysql.com/doc/refman/8.4/en/mysql-tzinfo-to-sql.html

  3. When you go global, set up a user-preference setting for time zone. It's a text string like 'America/Los_Angeles' or 'Australia/Perth'. You can store that user preference in a column like this: user_timezone VARCHAR(63) NOT NULL DEFAULT 'America/Los_Angeles' COLLATE 'ascii_general_ci'. (You can give the time zone of your own location, or 'UTC', as the default, of course.)

  4. When you start a database session from your app on behalf of a user, do SET TIMEZONE='America/Los_Angeles' or whatever your user's preference of time zone is.

  5. Use TIMESTAMP columns to store timestamps rather than DATETIME columns. They're automatically translated to the current timezone setting.

reddit.com
u/Aggressive_Ad_5454 — 16 days ago

T-handle hex key tool quality?

Various general market hardware stores offer collections of T-handle hey keys for ~US$30. Park Tool offers a similar collection for ~US$120.

What’s better about the more expensive bike specialty tools? Harder metal? Ball ends? Blue handles?

reddit.com
u/Aggressive_Ad_5454 — 1 month ago

Query from a performance plugin author about database buffer pools

I'm the author of a few free non-monetized database-performance plugins, including Index WP MySQL For Speed. I have a question for site owners and site operations people.

Should I add a Site Health feature that detects misconfigured innodb_buffer_pool_size settings in MariaDB or MySQL database servers?

Often when handling support questions for my performance plugins I find that database configuration to be far too small. That makes sites slow and sometimes unstable. I've analyzed metadata uploaded (anonymously) by my plugin's users and found that fully a third of sites have the default configuration, which is the hilariously small 128MiB. Here's a writeup of my findings.

The plugin already shows this configuration data on the About tab of its dashboard page, but doesn't highlight misconfiguration.

Would the addition of a Site Health feature help site owners improve their performance? Or, would it be just another nuisance alert?

Please help me decide whether to invest the time to develop and test this feature.

u/Aggressive_Ad_5454 — 2 months ago

A cautionary tale about searching for usernames: let's be careful!

Ars Technica ran a story about how an innocent man did 18 months in prison for preying on a child. Somebody missed a double underscore in a social-media username. The miscreant's user name was fus__ro_dah and the innocent man's was fus_ro_dah without the double underscore. The police request for a search didn't include the double underscore, so the social media platform responded with the wrong person's identity.

https://arstechnica.com/tech-policy/2026/07/police-missed-one-underscore-and-sent-the-wrong-man-to-prison/

It's correct, and easy, to blame a dunderheaded police officer for this mistake. But, in my opinion, our database developer colleague at the social media platform could have prevented this heinous miscarriage of justice.

Let's be careful when we develop code that searches for stuff that might contain obfuscatory punctuation or diacritical marks. Let's put stripped-username columns into our Let's try the search with queries like

SELECT 1 AS exact,
       username
  FROM user
 WHERE username = 'search__term'
UNION ALL
SELECT 0 AS exact,
       username
  FROM user
 WHERE stripped_username LIKE '%searchterm%'

Now obviously this is simplistic. But not as simplistic as just username = 'search__term'. My point here isn't how to improve the search for obfuscated data. It's to remind us to be careful.

This kind of thing should reduce the number of life-wrecking mistakes our queries make.

u/Aggressive_Ad_5454 — 3 months ago
▲ 98 r/Maine

Dr. Richardson on the Senate race: she won’t run, and thinks a democrat can win

Dr. Heather Cox Richardson, the American historian whose husband hauls lobster traps, yesterday posted a video where she said she won’t run for the US Senate seat. https://www.youtube.com/live/nkDRcv1pzT4?is=2b1GqoArll0O8KD5

This video is, IMO, worth the time it takes to watch it.

She makes the case that somebody should be able to take the seat from the incumbent. She makes the case for choosing a pol with Augusta experience.

reddit.com
u/Aggressive_Ad_5454 — 3 months ago

Check your innodb_buffer_pool_size!

I just handled a support topic for one of my plugins where the site owner said their innodb_buffer_pool_size is 512MiB. And was slow.

For a shop with a million orders.

That’s a gross misconfiguration.

Please read this if your site is growing. https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-buffer-pool It applies both to MariaDb and MySql databases. A far too small buffer pool can hammer performance and annoy our audiences.

u/Aggressive_Ad_5454 — 4 months ago
▲ 80 r/Maine

Searsmont Strong!

This banner says " Thanks for your support. Searsmont Strong. Robbins Lumber. " It's at the road to their mill, the one that burned last month.

Rest in peace, firefighters Andrew Cross and Wayne Woodbury. You kept us safe.

u/Aggressive_Ad_5454 — 4 months ago
▲ 16 r/Maine

Concert tonight, Wed June 17, pm, in Camden

There's a choral concert at 7pm at the First Congregational Church in Camden. The church is on Elm Street.

The Pen Bay Singers offer a program of American music, under the direction of Sierra Lary.

Frostiana is a song cycle of Robert Frost poem set to music by Randall Thompson. We'll sing that.

And there'll be music by Copeland, Berlin, Belfast's own Gladys Pitcher, Morton Lauridsen, and more.

Twenty bucks. A good time. Hope to see you.

(Disclosure: I'm a bass in the Pen Bay Singers.)

reddit.com
u/Aggressive_Ad_5454 — 4 months ago
▲ 14 r/Maine

Is there a sub for bicyclists in Maine? Should there be?

Is there a subreddit for bicyclists here in Maine?

Do you think there’s enough of us to make one work?

reddit.com
u/Aggressive_Ad_5454 — 4 months ago
▲ 18 r/Maine

A giant freezer could help get more food to pantries in Aroostook County

This is a well-reported article about the practical challenges of running food pantries. A lot of food-bank-sourced food is shelf stable, and that's obviously good. At the same time, an increasing amount of it -- produce, fish, meat -- comes frozen. If the pantries can keep it frozen until people take it home to use, that's great.

At AIO in Rockland, we're familiar with the words "scramble to get rid of perishable food quickly". We often are given good stuff (produce) that we can't freeze, so we "push" it quickly. The worst part of volunteering is carting perished food to the dumpster.

The thing they have up in the County about Canada-bound long-haul truckers donating excess product they don't need to carry across the border, that's great. It doesn't happen in Midcoast.

themainemonitor.org
u/Aggressive_Ad_5454 — 4 months ago
▲ 1 r/Rouvy

Is the Route Creator queue stuck?

I uploaded a route yesterday 26-May-2026. It said that the estimated processing time is 7 days, then, and again today it says 7 days.

It's about 17 min of video material, comprising about 15km of riding distance.

I uploaded another, longer, route last Friday 22-May-2026, and it finished processing in a reasonable time.

By the way, I love this feature!

reddit.com
u/Aggressive_Ad_5454 — 5 months ago
▲ 15 r/Maine

Gov. Candidate Pingree offers public-option health insurance. Is it realistic?

Gubernatorial candidate Hannah Pingree has offered a [health care plan](https://hannahforgovernor.com/health-care/) that includes public-option health insurance in place of private insurance. She pitches it as a choice, rather than a single-payer scheme.

That’s progress, for sure. But is it realistic? Or a pipe dream? I really want to know. I’m not trolling or slagging the plan, I just want to understand.

Some practical questions:

  1. Does it require a ballot initiative to be legal, or can the legislature make it happen?
  2. Will the legislature make it happen? Or will that be a huge fight?
  3. Will Maine hospitals, docs, and other health care professionals be generally happy with such a plan, or will they fight it tooth and claw? A good plan has to serve both patients and caregivers to work. It’s possible to bankrupt hospitals by paying them too slowly or not enough money. Not a good plan!
  4. Does the state of Maine have access to working business processes to do the day-to-day business of such a plan? That stuff is not simple to operate at scale.

It requires skilled and dedicate people as well as a crapton of expensive software and servers.e

u/Aggressive_Ad_5454 — 5 months ago
▲ 30 r/Maine

Eel tale from the food pantry

We had some fun today at our local food pantry. I was volunteering at the meat counter. As usual, guests came up and asked "what do you have?" And I got to answer

"Today's delicacy is European smoked eel"

I wish I had a collection of photos of the faces people made. Let's say, most people weren't thrilled.

Somebody gave us the smoked eel, of course. I hear it's pretty good. I'm trying to work up my nerve to try it.

We also have plenty of other, less exotic, delicious meat offerings of course.

We gotta keep smiling!

If you need food please call 211 and ask for a food pantry near you. Or look at Good Shepherd Food Bank's web site here.

If you can spare a few dollars to support food pantries around Maine, please donate to Good Shepherd. They supply food pantries around the state. They know their business and can stretch your buck a long way.

u/Aggressive_Ad_5454 — 5 months ago