Category Archives: geek stuff

database update

the database is fixed. 😌

what happened? that’s complex.

recently, i had my web site redesigned. the new design uses the “Enfold” theme, which uses a lot of what they call “transients” to maintain the look and feel of the site, regardless of the platform on which it’s being viewed. “transients” are sort of like cookies, except that you can’t opt out of them, and they don’t contain any personally identifying information. some of these “transients” expire immediately when a person leaves the web site, and others persist, for a few minutes to several days. they persist on your computer AND on my server… in the one of the tables in the database…

the “Enfold” theme has automatic caching and garbage collection routines that are supposed to handle these expired “transients”, but, because it’s a wordpress theme, it doesn’t do all the jobs very well… or, sometimes, at all… which is why i also use a caching plugin that actually, you know, works ALL the time, and not only some of the time… 😒

except that, for some reason, prior to my site upgrade, “someone” (and i have yet to identify who, but it was either my web designer or my host provider) recommended that i disable the caching plugin, because of some issue with the new version of wordpress… or something like that… as i said, i don’t remember. i distinctly remember disabling the plugin on someone’s recommendation, i just don’t remember exactly who, when or why. 😖

one way or the other, my caching plugin was disabled, which meant that, when i installed the new theme, it was relying on the not-working-the-way-it-should, internal cache… which, basically, didn’t work, causing the table in the database to expand beyond my disk space allocation. 🤯

it didn’t show up in my cPanel because i wasn’t looking at the SQL disk space, which is “below the fold” of my browser, and i just didn’t scroll down far enough to see it. 😕 during the nightly automatic backup, it was overwhelming the server for everybody, not just me. i had to pay my web designer for two days of poking through piles of arcane SQL code and deleting bits and pieces of it. it was not fun.

the solution was to enable the caching plugin(!), and to install a “transient manager” plugin, so that i can delete the expired transients from the wordpress dashboard, and not from the SQL database,… which requires A LOT more “knowing what to look for” and “knowing how to delete stuff without damaging other stuff” than i have on board, personally.

databases

my first direct experience with databases was in the late 1980s or early 1990s, when i got a “job”, “working” for this… guy…

i don’t remember his name — possibly “henry” — but i remember his attitudes: he was always right, nothing he thought of had ever been thought of before, he was the richest, smartest, trendiest, most “on-top-of-it” dude that ever hit the face of the planet, and GAWD HELP YOU if you EVER got in his way.

needless to say, the “job” didn’t last long. it started with him demonstrating how generous he was, by buying me a disk caddy, so that i would have somewhere to keep all of the disks i was going to accumulate working for him. then he started asking me about computers. at the time, i was NOT a “computer geek”, nor did i want to be one (my father was one of the original “computer geeks” and i DID NOT want to be like my father), but i knew about computers because i had been working as a typesetter for a few years. he asked me what i didn’t know about computers, and one of the first things out of my mouth was “databases”, so he signed me up for a week of training with “FileMaker”…

what i learned was a bunch of recycled stuff from my already ample knowledge of microslut word and excel, with a bunch of “hypercard-like” stuff which i sort of vaguely understood (but nobody i knew used hypercard for anything, so i never really knew what i had missed until years later), and, at the same time i was doing this training, i was helping this… guy… clean out his house, because he was going through a divorce, or some awful shit like that, and he, basically, had to move EVERYTHING that was “his”, out of one house and into another, that was a few houses down the street…

which is where i learned that his “rich” persona was heavily financed by several HUNDRED overdrawn credit cards — he had been using one credit card to pay off another credit card, and when he ran out of credit cards, he would just start up a new one, and use it to pay off the previous ones… FOR YEARS… — at which point i decided that working for this guy might not be such a good idea, if i wanted to get paid.

quite apart from the fact that working for him was REALLY annoying…

so, ultimately, i spent a week learning really complex software that i never got to use for anything, and that was it, until i got my job at software.com, testing email servers, in 2001.

and, for all of my work with databases at software.com/openwave, i still don’t have a really solid grasp of what they are… where they “live”, what they do, how they work… anything… all i know is that, under the right set of circumstances, you can give “commands” to a database, and it will perform certain functions with a variety of different “objects”, the outcomes of which can be used in a multitude of different ways, depending on what is contained in your database.

i get the impression that databases are a lot like the world wide web, in that they both have a lot of objects (web sites) that are linked together in a somewhat-haphazard, but definitely organised way.

so, you can imagine that it was something of a surprise when, the other morning, i woke up, checked my email, and discovered two somewhat alarming notices. the first was warning me that i had used up 90% of my disk space on my server, and the other was warning me that a “table” on my main database was malfunctioning… or something… and collecting 251 GB worth of data… which, somehow, was NOT showing up in my cPanel, which says “Disk Usage 18.43 GB / 292.97 GB”…

and, of course, it happened on a sunday, when nobody’s in the office, and on mothers day, when even fewer people are in the office, and during a PANDEMIC… 😒

so, first thing this morning, after waking up to a broken heat pump, and a wife who wrenched her back, i wrote to my web designer, who said, oh yeah, we’ve seen this kind of thing before, it’ll cost between $200 and $500 to fix it…

and I DON’T EVEN KNOW WHAT’S WRONG… 😖

you’re probably wondering why i posted this…

मनोबुद्ध्यहङ्कारचित्तानि नाहं
न च श्रोत्रजिह्वे न च घ्राणनेत्रे ।
न च व्योमभूमिः न तेजो न वायुः
चिदानन्दरूपः शिवोऽहं शिवोऽहम् ॥ १॥

The processors
Manas, buddhi, ahaṅkāra and chitta are the qualitative differentiation within the mind. They are used interchangeably based on context, and yet they are different.

Manas is the faculty of perception, the instrument by which the objects of senses affect the Atman. It is the faculty of thought, desire, imagination. Buddhi is the intellect, by which one discerns, comprehends. Ahaṅkāra is the sense of identity, that which creates ‘I-ness’, ego. Chittam is the one that observes, is aware. All these are the faculties that process what comes from outside.

I am none of these processors.

The instruments
Shrotra is the ear, the organ of hearing. Jihvā is tongue, the organ of tasting. Ghrāṅa is nose, the sense of smelling. And netra is eye, the sense of seeing.

I am none of these instruments.

The building blocks of matter
Vyoma is the space, the gap between the matter. It is the space between planetary bodies as well as the space around Earth, and even the space inside anything. It is also one of the five basic elements.

Bhūmi is the Earth, or the solid matter.

Tejas is the heat or light (both interconnected) like the fire or the Sun.

Vāyu is the wind, the circulating forces, not just on Earth but also inside our bodies, responsible for circulating whether nutrition or blood etc.

I am none of these building blocks of which the material world is made.

The faculties get the information using the senses about the outside world.

I am none of them.

I am pure bliss form of consciousness.
I am Shiva, I am Shiva.

— Practical Sanskrit

—–

it is Adi Shankara‘s birthday, and, if i can be said to “follow” a “religion”, it would probably be the one espoused by adi shankara.

the reason for this is that adi shankara spoke of a “god” which exists beyond what we experience as “good” or “evil”. this “god” is neither (or, possibly, both) “good” and/or “evil”… which is, pretty much, EXACTLY the kind of “god” i feel, which “operates” this plane of existence. this “god” both “exists” and “does not exist”, at the same time, creating no contradictions. this “god” is both “illogical” and “logical” at the same time, creating no contradictions…

and if you don’t understand this, you probably think i’m crazy.

so be it.

this sanskrit shloka, part of Nirvanashatkam is, pretty much, exactly what i believe about myself: i may have all these things holding me back; depression, anhedonia, a brain injury, etc., but those are relics of 60 years of living in this plane of existence. in spite of how “real” these things are, in spite of how “real” these things seem to be TO ME, they are NOT “who i am”, in the “real” sense of the word. i am beyond all this: i “really” exist in a realm where “good” and “evil” are two sides of the same coin… and that “coin” is worth less than a penny.

new regex stuff!

logical operators! thanks ian! 😉

+ () [] - |

(stuff that remains the same)+(stuff that changes) – otherwise known as “capture groups”

[89] = 8 or 9

[0-4] = 0, 1, 2, 3, or 4

| = logical OR

so…

\D(85\.157\.47\.)+(12[89]|1[3-9][0-9]|2[0-4][0-9]|25[0-5])\D

means “capture everything in 85.157.47.128/25”

which, up until now, has meant “make a separate rule for every IP address between 85.157.47.128 and 85.157.47.255” — 128 SEPARATE RULES, which takes A LONG time, and slows down processing speed.

this is a BIG step forward!

WOO!!! 😎👍

ETA 200205: even more WOO!!! because ian directed me to a RegEx Numeric Range Generator, which means that i don’t have to figure them all out myself! WOO!!! 😎👍

🤬🤬🤬🤬🤬‼

ever since he was born, i have been afraid that i will be forced into the situation where i have to apologise to my son for bringing him into a world that, through no fault of his own, is going to end, for all intents and purposes, before his life will end. to me, it seems a large amount of irresponsible, to have brought a being into the world, who is faced with his own death, before his time, especially since i seem to be charmed when it comes to the potential of my life ending before my time.

and it’s even harder for me, because i have been fighting my entire adult life to change the things that i can, that would lead to my not having to offer that apology.

ezra, i’m sorry that the world is such a fucked up place. i’m sorry i brought you into this world, with no way to change it. i’m sorry you have to share this world with people who don’t care that it will end before your lifetime is complete.

A Grim New Definition of Generation X
by Ted Rall – 191231

People born in the 1960s may be the last human beings who will get to live out their full actuarial life expectancies. “Climate change now represents a near- to mid-term existential threat” to humanity, warns a recent policy paper by an Australian think tank. Civilization, scientists say, could collapse by 2050. Some people may survive. Not many.

Some dismiss such purveyors of apocalyptic prognoses as hysterics. To the contrary, they’re Pollyannas. Every previous “worst-case scenario” prediction for the climate has turned out to have understated the gravity of the situation. “Paleoclimatologists have shown that past warming episodes show that there are mechanisms which magnify its effects, not represented in current climate models from the Intergovernmental Panel on Climate Change to the Paris Accords,” reports The Independent. It’s probably too optimistic to assume that we’ll make it to 2050.

Gives new meaning to Generation X.

Millennials and the children we call Generation Z face the horrifying prospect that they will get stuck with the tab for humanity’s centuries-long rape of planet earth, the mass desecration of which radically accelerated after 1950. There is an intolerably high chance that today’s young people will starve to death, die of thirst, be killed by a superstorm, succumb to a new disease, boil to death, asphyxiate from air pollution, be murdered in a riot or shot or blown up in a war sparked by environmentally-related political instability long before they survive to old age.

Long threatened, never taken seriously, not even now that it’s staring us right in the face, human extinction is coming for the children and grandchildren we claim to love but won’t lift a finger to save.

Shelves sag under the weight of books that have been written arguing that we still have a chance to save ourselves. I wish I could believe that. Human population has tripled since the 1950s. More than a million species have gone extinct. Ninety percent of the fish in the ocean have vanished, replaced by one billion tons of plastic. Two-thirds of the trees have been cut down. The polar ice cap is gone; it’s never coming back.

We can’t stop global warming. An increase of four degrees Celsius over the baseline set at the beginning of the Industrial Revolution means game over. We’re well on our way there. It doesn’t make sense to think that we can avoid extinction.

What if we woke up and demanded action from our political leaders? Radical problems require radical solutions; only the most radical of solutions could resolve the most radical problem of ruining our planet’s ability to sustain us: revolution. We would have to rise up and abolish — immediately — consumer capitalism in all the major greenhouse gas-producing nations, prioritize cleaning the environment as the human race’s top concern, and pivot to an economic mindset in which we extract the bare minimum from the ecosystem that we need in order to survive and nothing more.

Voting might achieve some incremental reforms but reform falls far short of what we require. Saving our young people (and their children, should they be foolish enough to have any) would require global revolution, the violent overthrow of the ruling elites and replacing them with people who understand what must be done. It would need to happen today. Fifty years ago would be better. Got a time machine?

None of this is going to happen. We are going to sleepwalk to our doom in a haze of social media and corporate entertainment distraction.

So it’s time for people who are younger than I am to start thinking about how they want to spend the rest of their likely-to-be-truncated lives, and how they plan to face mass premature death.

Pending human extinction destroys the answers provided by religion and philosophy. Knowing that there won’t be anyone to know that we were ever here raises the question: why bother to do anything? This column, this year’s “important” presidential election, love, hate, everything will lose its meaning when the last member of our species draws her last breath. Earth is unlikely to be visited by an alien archaeologist, much less uncover everything we’ve made and created (assuming any of it survives), much less figure out what any of it meant, before the sun expands into a red giant and ends it all.

Much is to be said for hedonism: eat, drink, have sex, and don’t bother to sort your recycling, for tomorrow we die. Stoicism has its advantages too; go out with dignity rather than weeping and gnashing your teeth and making your fellow survivors miserable.

Nihilism is about to become the best worst possible life strategy. Life is meaningless. That will soon become obvious. Moral principles, relics of a time with a future, will blow away like the irradiated dust we leave behind.

None of this will have mattered.