The Heap™ – Consultancy ©®

« first day (3340 days earlier) ← previous day next day → last day (1511 days later) »

Tom V - try topanswers.xyz

6:26 AM

@Philᵀᴹ Nice. I was always more into techno than house but I've always wanted to see Lucy Fur live

Tom V - try topanswers.xyz

6:57 AM

I'll put some of those names in a mixcloud search though

John aka hot2use

7:14 AM

Morning

McNets

7:29 AM

Morning

Vérace

7:45 AM

Morning all!

@McNets Worse than ships on fire off the shoulder of Orion, a table with 35,000 (yes, 35k - that's not a typo) fields!

McNets

@Vérace ouch

Andriy M

Morning

Master Database

8:19 AM

Q: Possibility to use typesetting on Database Administrator site

Though not daily, from time to time it would be really good to be able to use typesetting (like MathML, Latex, etc) to be able to express formulas etc for theoretical stuff. In the long run, I think the site would benefit from it since it would encourage more detailed explanations in question/an...

Philᵀᴹ

8:38 AM

@TomV-trytopanswers.xyz my other half is a techno producer

Vérace

8:55 AM

@MasterDatabase One of the objections is performance - but aren't we constantly being told (well, if you look it up anyway) how efficient SE is and how the whole site is practically running on the spare CPU cycles of Joel Spolsky's mother's washing machine?

Paul White 9

Following up on the answer in a comment on meta with a message in chat?

I guess that's one way to avoid down votes

LOL

btw I haven't closed it as a dupe because I don't mind us revisiting this after 4 years

I don't remember it all that well, but I think the performance objections were more about client rendering speed than the impact on the servers.

You'd also have to think about the impact of TeX-specific bugs appearing on dba, or breaking existing posts in some way...and so on. I don't think it's necessarily as simple as just turning it on and enjoying the benefits.

This other meta Q & A is a great place to explore performance (especially scrolling speed):

2932

Q: MathJax basic tutorial and quick reference

(Deutsch: MathJax: LaTeX Basic Tutorial und Referenz) To see how any formula was written in any question or answer, including this one, right-click on the expression it and choose "Show Math As > TeX Commands". (When you do this, the '$' will not display. Make sure you add these. See the next p...

support faq mathjax reference

Peter Vandivier

10:01 AM

Q: Planned maintenance scheduled for Saturday, March 7, 2020 at 14:00 UTC (9AM US/Eastern)

tl;dr; Planned service interruption that will impact all Stack Overflow/Stack Exchange sites, Jobs, Chat, and Teams. All sites will be read-only for up to an hour on Saturday, March 7, 2020. Enterprise cloud-hosted instances will not be impacted. Short Version: There will be a service degradati...

discussion featured announcements maintenance

Paul White 9

10:32 AM

What could go wrong

Peter Vandivier

supervolcano

Andriy M

For a short time I was confused by "Intermediate Version of What's Taking Place?", because I read it at first as "[Intermediate Version of What]'s Taking Place?" rather than as "Intermediate Version of [What's Taking Place?]"

Taryn

11:06 AM

@PaulWhite9 everything

Tom V - try topanswers.xyz

11:45 AM

@Taryn Don't make plans for Sunday :)

4 hours later…

Paul White 9

3:25 PM

@Taryn Is Score in Comments nullable because the column was added to the table later and NULL was just a fast way of adding it? There seem to be no nulls in that column, and it's not obvious what null would mean.

Taryn

3:53 PM

@PaulWhite9 I'm trying to get the answer to this.

@PaulWhite9 it was added far later - there wasn't voting on comments when they were originally added

ypercubeᵀᴹ

4:06 PM

@Taryn what would happen if you manually edited the score to a negative value? Would it appear?

Taryn

@ypercubeᵀᴹ not sure, I'd have to dig into the code.

billinkc

4:32 PM

Just update one comment in a random, low viewed post and see how long it takes until it shows up on Meta as how did this get -1?

ypercubeᵀᴹ

4:59 PM

Yeah, do it. This Saturday. We'll blame the leap year.

Taryn

5:10 PM

we almost scheduled the SQL upgrade for this Saturday

McNets

6:07 PM

Q: How do I prevent PostGIS's "ST_MakeEnvelope" function from returning more than four "corners"?

This is weird. I haven't made any changes to my SQL or application code in quite some time, yet in the last few days, it's suddenly started throwing tons of errors. It seems to be related to how PostGIS's function "ST_MakeEnvelope" has started outputting more than four "corners" or "coordinates",...

postgresql postgis

^^^ Should it be closed as tip of the iceberg or Too localized?

Have a look at comments

billinkc

I think it was an error ;)

1 hour later…

James

7:24 PM

goddamn I really wish sql server had an 'everything else' like * is for all

Peter Vandivier

7:56 PM

wat?

Max Vernon

@James look at EXCEPT

MikeTheLiar

I think he means in a select statement

select * not including SomeColumn, OtherColumn from....

John aka hot2use

SQL Assistant - Softtreetech (<== Advertisement; no Ref Code)

MikeTheLiar

> SQL Assistant will boost your database development productivity by 300%

Great, I can do nothing faster!

John aka hot2use

Andriy M

8:02 PM

300%, hmm, that won't make me a 10xer

John aka hot2use

Yeah. Sux.

Andriy M

If I use SQL Assistant on top of SQL Assistant, will that make me as productive as (x+300%)²?

MikeTheLiar

On an unrelated topic - how come my newly created postgres roles can't log in? Everything except the postgres user gets an "password authentication failed for user" error. None of the Google results appear to be related so I have to assume I'm creating the role incorrectly somehow.

This is my first semi-serious foray into postgres so it's safe to assume that the dumbest possible answer to my question is probably correct.

John aka hot2use

You might want to aim for a too localized on the main site.

James

@MikeTheLiar did you start your scripts with "By the power of GraySkull"?

John aka hot2use

8:08 PM

Did you modify the pg_hba.conf file to allow your host to connect?

That might be the dumbest answer

MikeTheLiar

@James of course. I'm assuming the database reads my comments

@Johnakahot2use not intentionally

But if I use the postgres mega-database-admin account, it works

John aka hot2use

local connection or remote?

MikeTheLiar

local

drop role if exists TestUser;
create role TestUser with
login
inherit
password 'Correct-Horse-Battery-Staple'
valid until '2200-01-01';

John aka hot2use

My Password Generator Excel Sheet spits out this:

CREATE ROLE "TestUser" INHERIT LOGIN CONNECTION LIMIT -1 PASSWORD 'Correct-Horse-Battery-Staple' VALID UNTIL 'infinity' ;

Looks similar.

Without quotes " the TestUser probably gets lower-cased to testuser.

That might be the second dumbest answer

select * from pg_roles;

@MikeTheLiar yup

MikeTheLiar

8:24 PM

Interestingly, when I try to connect via CLI testuser does not exist

John aka hot2use

your login command in my PostgreSQL -----^

My command ------^

And it would have to be:

DROP ROLE "TestUser";

;-)

MikeTheLiar

This is weird but I'm willing to chalk it up to "stuff I don't understand and use the quotes" but:

With "TestUser" my app can connect to the database at least. It fails immediately for an unrelated reason but it connects, so I'm calling that a win

"Second Dumbest Answer" FTW

wait a second

I can read, I promise

That first error message is the database "testuser" does not exist

John aka hot2use

:-)

psql -h HOSTNAME -p 5432 -U TestUser -W DATABASENAME

MikeTheLiar

8:45 PM

This is back to the TestUser without quotes:

But I'm willing to let this be confined to the dustbin of the ages

If I had to understand every weird error I encountered, I'd never get anything done

John aka hot2use

Mine works as designed with double-quotes:

Andriy M

Q: PostgreSQL error: OperationalError: FATAL: role "username" does not exist

I got this error When I'm trying to run the Code. I searched the site like this problem But It couldn't solve my problem. When I'm trying to create superuser with my username (which is TCOYUKSEL) , It create another one with "tcoyuksel" ozgur.py Line 9 db = psycopg2.connect("dbname=news"...

postgresql

John aka hot2use

I mis-typed the Correct-Horse-Battery-Staple password first time round.

cu. Off back home.

MikeTheLiar

@Johnakahot2use The definite conclusion here is either user double quotes or snake_case_all_the_things

Andriy M

My guess is snake case is the preferred style with Postgres

MikeTheLiar

8:52 PM

A reasonable_guess

Andriy M

Curiously, the SQL Server system catalogs prefer snake case while the famous demo database AdventureWorks uses camel case. For some reason I find this rather minor issue very puzzling

billinkc

9:28 PM

But what about pubs?

It's my understanding that Microsoft has been known to outsource things like the creation of demo databases

Paul White 9

9:49 PM

@Taryn Thank you!

« first day (3340 days earlier) ← previous day next day → last day (1511 days later) »

all rooms