The Heap™ – Consultancy ©®

1:13 AM

ISO supports timezones all right. I think Vérace will also support timezones if given some vanitycoin, chat markup, and an opportunity to stretch his vocabulary.

I will also support timezones if they run in the upcoming elections; they are way better than the current "government".

Vérace

6:23 AM

A chairde - Morning all!

Paul White

Morning

Vérace

And hello to you too, No. 4!

John K. N.

7:39 AM

Morning

ypercubeᵀᴹ

@Colin'tHart you are not alone

LQOTY

John K. N.

10:38 AM

So now we only have canned answers for the first questions review queue and first answers review queue. Hmmmm

BNP?

Paul White

11:20 AM

@JohnK.N. What does BNP stand for?

John K. N.

@PaulWhite Be nice policy

Paul White

Oh right.

John K. N.

I guess this will fix it:

53

Q: Resolving Community user and "share feedback" issues in review queues

On our announcement for our updates to review queue workflows, we got a ton of feedback on the Community user being the one posting comments for users. Here's a quick summary of some of the major points: It's not clear to many users that Community is a bot that they can't reply to Mods cannot d...

Break first, fix later.

Paul White

It's the modern way.

John K. N.

Agile as <preferred expletive>

Paul White

11:30 AM

DevOops

Vérace

@ypercubeᵀᴹ What is LQOTY?

Paul White

22 hours ago, by Colin 't Hart

Is it just me or am I alone in thinking this deserves the Lame Question of the Month Award?

So LQOTY => Lame Question of the Year

It's an understandable question, but I doubt we want one of that type for each release of each database platform we host Q & A about.

John K. N.

@PaulWhite must be fuming about the Mods cannot delete comments from the Community user, and other users can't flag those comments, so they're just ... stuck there bit?

Paul White

@JohnK.N. Yeah that was an outrage

Just something else some random dev thought was a good idea without asking anyone

John K. N.

Can we turn the FQ and FA queues off for the time being?

Paul White

11:34 AM

Only by ignoring them

John K. N.

Said, Done

Vérace

@PaulWhite You'd want to watch that - you're dicing with death, expressing a strong opinion without resorting to expletives - that sort of behaviour will get you a warning!

Paul White

@Vérace Only on main meta.

Vérace

When's the next DolphinDB release due? Can I have a LQOTC badge please?

And vanity points. Very important are vanity points! Don't forget those!

Paul White

All those dolphin questions are being asked by people associated with the company as far as I can tell.

Vérace

11:38 AM

Oh... so my tag creation is just clickbait which I fell for? Boo for me...

Paul White

We get people astroturfing their thing from time to time. A tag is sometimes created. It often doesn't last long.

I wouldn't mind so much if the Q & A they generate was half-useful but generally it's lazy low-quality stuff just aimed at making the product look more popular than it is.

I'll keep an eye on it as usual. If it becomes clear it will never add value I'll just nuke it all.

Occasionally people turn to adding useful content, with proper disclosure, in which case xkcd.com/810

Vérace

"Astroturfing" was a new one on me - and it's not even spell-checked! > The Koch brothers started a public advocacy group to prevent the development of wind turbines offshore in Massachusetts. The Kennedy family was also involved.... Hee, hee... basically, it's a form of corporate sock-puppeting!

Paul White

astroturfing

Noun: astroturfing (uncountable)

(US politics) The disguising of an orchestrated campaign as a "grass-roots" event – i.e., a spontaneous upwelling of public opinion.

thanks, bot

Vérace

Corporate of institutional ("institutiion" broadly defined, c.f. Kenndey's). The wiki is where I obtained the quote!

Paul White

I wonder if the wiki: prefix still works

Astroturfing

Astroturfing is the practice of masking the sponsors of a message or organization (e.g., political, advertising, religious or public relations) to make it appear as though it originates from and is supported by grassroots participants. It is a practice intended to give the statements or organizations credibility by withholding information about the source's financial connection. The term astroturfing is derived from AstroTurf, a brand of synthetic carpeting designed to resemble natural grass, as a play on the word "grassroots". The implication behind the use of the term is that instead of a "true...

Yep

I was too lazy to do a web search myself

I had never heard of astroturfing until I started modding here

Anyway it's basically spamming

Vérace

11:46 AM

My first flag was for that!

<sniffle...>

I hasten to add that it was not I who was flagged, I was the flagger and not the flagee - I never get flagged! :-)

Paul White

@Vérace Your first flag was on dba.stackexchange.com/questions/9689/…

John K. N.

Does being flagged show up in ones profile?

Paul White

@JohnK.N. To moderators? Yes.

@Vérace It looks like you have 13!

Vérace

13 negative flags? What on earth for? I'm a model of propriety and helpfulness on this site!

Paul White

You've even flagged yourself 😀

Vérace

11:51 AM

Ah, yes, the curse of Onan... self-flagging!

Paul White

Anyway, there are a range of flags, some more negative than others. The total includes all of them, accepted, disputed, and declined. It's not a very useful number really, except when it's very large and one still needs to go investigate.

Flagging is mostly a way of asking for a moderator's opinion anyway. Perfectly normal a lot of the time.

Oh and it only counts flagged posts --- not comments.

Vérace

OMG - he's asked a question!

0

Q: How can I change the master password of pgAdmin 4 without resetting it?

pgAdmin 4 has a master password which is required to secure and later unlock the saved server passwords. This is applicable only for desktop mode users. I know my current master password, however, I want to change it without resetting it, as Resetting the master password will also remove all ...

password pgadmin-4

I thought he was just an editor-bot!

Kinda mythical creature, spotted in the wild from time to time but believed to be a chimera of the imagination...

Paul White

@Vérace You know he's a moderator on 6 or 7 sites?

Talking of breaking things:

15

A: Adding HTML tags or HTML-tag-like to a title, breaks rendering

The vulnerability has been closed (was related to turning off smarty-encoding for titles), permanent fix incoming to allow us to turn off smarty-encoding again with out running into this issue. The vulnerability was on the network for 44 minutes (from the time that smarty-encoding was pushed to p...

Vérace

Yes... we discussed this before, speculating about how anyone could possibly have a life and do that?

Paul White

@Vérace Automation 😉

Vérace

12:02 PM

@PaulWhite Interesting - a new feature was disabled in 44 minutes... but in ~ at least a week, they haven't been able to fix the FP, FA, FQ fiasco!

Paul White

@Vérace Well apparently this was quite a big security hole

Vérace

* First Post, First Answer/First Question...

John K. N.

12:24 PM

@Vérace vtc as toti

Paul White

@mustaccio What do you think should happen to dba.stackexchange.com/a/298883?

I can convert it to a comment on the question, or your answer, or leave it be as somewhat of an answer to the question.

Vérace

@JohnK.N. Too Old To... Interject?...

Paul White

@Vérace Tip of the Iceberg

Vérace

@JohnK.N. Why? It seems like a perfectly reasonable question to me...

Paul White

Same

I expect one of our Postgres experts will be able to answer

If not, Evan might have a go

John K. N.

12:46 PM

> The server passwords which are saved in the SQLite DB file are encrypted and decrypted using the master password.

But no mention of where the master password is stored.

Hence vtc as toti

@PaulWhite -------^------- @Vérace

Paul White

@JohnK.N. Where is that quote from and what does it have to do with pgAdmin 4?

Oh I see it's from the link in the question

Anyway the question has a credible answer now

John K. N.

pgadmin.org/docs/pgadmin4/development/master_password.html#

The application resides on the client and has nothing to do with PostgreSQL itself other than it provides a GUI to navigate a PostgreSQL instance.

So the developers of pgAdmin 4 decided to use SQLite to store the passwords of the PostgreSQL instances and logins locally on the client.

Vérace

1:30 PM

@JohnK.N. Sounds like a canonical use for SQLite to me - D. Richard Hipp would approve! I'm sure that he'd also approve of there not (apparently) being any back doors around the encryption process...

OMG - sometimes hand-holding reaches limits that cause me to grit my teeth... that's 25 minutes of my life I'll never get back!!

mustaccio

@PaulWhite It's a comment at best, in my view. basically, "yeah, what you say might be true, we'll take a look".

John K. N.

Ah well. Better than discussing checkmk.

Paul White

1:50 PM

@mustaccio Thanks

Vérace

2:05 PM

Well, that'll teach me to gripe... I got vanity ponits... Yaay!

That's my unicorn - I'm calling her Ponits! And here's something I didn't know about unicorns... The word unicorn has a specific slang meaning...

Paul White

@Vérace I felt sorry for you

Vérace

In what way did you feel sorry?

Paul White

Lots of effort, no vanity points

Vérace

As I said, I'm here to learn. I'm working my .... off on a simulation for a question that's been answered and accepted (not my answer) and I likely won't get nada and I don't care. The day I stop learning stuff is the day I leave dba.se! Points are nice (warm fuzzyiness...) but not the be all and the end all!

Paul White

Fine I'll downvote you in future

😛

Hannah Vernon

6:19 PM

-25

Q: We’ve shipped some changes to the user profile navigation

The changes discussed and demoed in Additional profile refinements are now getting rolled out. We’re changing some layout before enabling responsiveness on user profiles. However, we can’t enable responsiveness fully on these pages until the entirety of the page stretches and wraps appropriately....

discussion design profile-page mobile-web announcements

also,

58

Q: Resolving Community user and "share feedback" issues in review queues

On our announcement for our updates to review queue workflows, we got a ton of feedback on the Community user being the one posting comments for users. Here's a quick summary of some of the major points: It's not clear to many users that Community is a bot that they can't reply to Mods cannot d...

discussion review community-user announcements automatic-comments

Hannah Vernon

7:59 PM

from the "this is fun" department:

DROP TABLE IF EXISTS dbo.[];

CREATE TABLE dbo.[]
(
   [] nvarchar(10) not null
        CONSTRAINT [check] CHECK ([] <> N'')
);

INSERT INTO dbo.[] ([])
VALUES (N'');

SELECT *
FROM dbo.[] t
WHERE t.[] = N'';

(1 row affected)

(0 rows affected)

Completion time: 2021-09-01T14:59:12.5743286-05:00

ypercubeᵀᴹ

that should be?:

SELECT [].*
FROM dbo.[]
WHERE [].[] = N'';

Hannah Vernon

yes that too

the table that shall not be named

ypercubeᵀᴹ

I suppose a schema named [] would make it even more fun ;)

Hannah Vernon

lol and why not go for a database named that too

ypercubeᵀᴹ

I like the check constraint that should fail - but doesn't

Hannah Vernon

8:18 PM

yah that part is so weird looking. It sure looks like that check constraint should work.

I wonder what adding a zero-width-space looks like in a PR at code review

like for instance you have an existing innocuously named column like [Column1], and while changing other things in the code, you silently add a zero-width-space into the column name so it becomes [Column1]

I suppose it wouldn't compile, but still, that would be so hard to track down

Transcript for

The Heap™ – Consultancy ©®