The Heap™ – Consultancy ©®

Morning

Q: Can we burniate the [truncation] tag?

8:18 AM

m

Colin 't Hart

9:14 AM

Morning

Long time no see

0

truncation has 13 questions today. Some are about rounding numbers. Others about truncating strings. There are questions about log truncation. And of course the one most obvious to me, about table truncation, SQL-style. Can we burniate this tag? But even truncate has questions about both table ...

discussion

9:39 AM

TRUNCATE truncation ;

McNets

9:52 AM

Morning

Trunkation

10:08 AM

→ 1 message moved to Trash

John aka hot2use

10:41 AM

@Colin'tHart Yes, please. After going through the suggested edits queue (and some).

12:10 PM

We have altogether too many tags

I'm all for deleting both tags

The SE system makes them easy to create and hard to delete

You'd think moderators would be able to delete tags, but no

How great is string

@PaulWhiteReinstateMonica I'm relieved there are 0 watchers

You'd think at least one person would have been strung along

I'm sure there are people who love watching strings

Q: In sadness, it is time for me to go

12:23 PM

String theory

In physics, string theory is a theoretical framework in which the point-like particles of particle physics are replaced by one-dimensional objects called strings. It describes how these strings propagate through space and interact with each other. On distance scales larger than the string scale, a string looks just like an ordinary particle, with its mass, charge, and other properties determined by the vibrational state of the string. In string theory, one of the many vibrational states of the string corresponds to the graviton, a quantum mechanical particle that carries gravitational force. Thus...

44

Friends, we've built an amazing place together. Our Worldbuilding community is awesome! It makes what I'm about to say bittersweet. Though it pains me deeply to leave my communities, I have decided I must leave the Stack Exchange network. I write this post with tears literally in my eyes. I ...

discussion featured

John aka hot2use

@TomV-trytopanswers.xyz Possibly

12:59 PM

9?

Shog

Ah

Where?

@TomV-trytopanswers.xyz My user name

Oh

Rebel

1:09 PM

What can I say

I'll probably get impeached

Don't worry, we own the senate

Neat

I was a bit worried about associating with that Ukranian

@AndriyM is v. sketchy 0.0

true

As long as your opponent's son didn't accept any bribes

1:13 PM

cough

Taryn

@PaulWhite9 :(

@Taryn yeah

1:29 PM

There was no quid pro quo, we were just talking

3

heh

Evan Carroll

1:44 PM

6 more days until monday!

happy tuesday

Q: my invoice BDT but this currency save USD in database

0

my invoice BDT but this currency save USD in database. just i have gave invoice USD to BDT currency.but after one month USD TO BDT currency not same.so that i feel problem invoice curr approve.and i dont add another product for before currency rate what can i do ? when i have save BDT TO BDT or ...

concurrency

finally asked the question in the right place

a hard problem

the mind boggles

I love the tag

2

HAHA

To be fair, multi-currency accounting can be hard

1:51 PM

multi-concurrency even harder

heh heh heh

I'll take a guess that it's the only tag that shows up if you start typing "currency".

yes exactly

Max Vernon

2:38 PM

wow, I can't imagine wanting to contribute to the SO blog. I can't imagine they get very much positive feedback

although, maybe that's why they want someone else to write for it.

what's the over/under on how long before the first subversive post where the first letter of every paragraph spells MONICA or something?

6

6 months?

@PeterVandivier Depends on what's in the contract you have to sign first

> If we decide to go ahead with your article, we’ll share a contract with you.

Max Vernon

2:54 PM

@TomV-trytopanswers.xyz wow, I wonder if that contract says you can't sue SO for defaming you.

Who in their right mind would want to deal with lawyers before publishing a blog post

Who in their right mind would want to deal with lawyers

voluntarily

okay... so... i'm thoroughly head-desked

i can't tell if i've found a bug in pg_ctl, an interoperability thing with python, or i'm just having a psychotic episode

Could it be all three?

3:05 PM

something about os.popen('pg_ctl stop') fails pretty nearly 50% of the time with "pg_ctl: directory "/my/db" is not a database cluster directory"

@mustaccio 3rd almost certainly, trying to pin down 1,2, and phantom reasons 4-100

thing is, that error message only cares about one thing

like... rigorously

but it bails hard when you hit it

like... i haven't been able to handle it with try: ... except: ... or anything

* pg_ctl error msg only cars about pg_version - fun demos to repro this assertion available

* problem line - already refactored locally to confirm it's not a scoping / shadow variable issue

i'm checking with os.path.exists(os.path.join(data_base,'PG_VERSION')) and print(os.listdir(data_base)) copiously

have you tried subprocess instead? os.popen* are kinda deprecated

can't hurt, i'll give it a try now

still breaking, but it looks like i have to capture stderr separately?

owait

it hit the except block, but it continued gracefully and finished the startup

Do you actually need the output, or just the RC? If output is not needed, I'd use check_call

don't really need either, i'm stopping the service for the purpose of nuking the data directory

but i know what you mean

ty!

Looks like you may be nuking the directory before postgres finishes its shutdown

3:20 PM

i mean... listdir() is showing pg_version there both before and after shutdown on error runs

the idea that it might be parallelising secretly had occurred to me, but i sort of stopped trying to investigate that b/c i didn't really know how to falsify it

3:37 PM

care to share the script?

3:47 PM

37 mins ago, by Peter Vandivier

* problem line - already refactored locally to confirm it's not a scoping / shadow variable issue

somehow i've now created a situation where i can't use subprocess at all

today is not a good day

Am i allowed to ask questions in here ? ^^

@genaray almost always, sadly i won't be helping you since i'm busy beating my head against a wall. good luck though

@genaray you already have ;)

@ypercubeᵀᴹ so meta

Not in here ^^ but down there ⬇︎⬇︎

3

3:59 PM

Alright :) Well... we are stuck with a little exercise, this time... normalizing a table into the second form. Could Some one tell us if this table is already in its 2. NF ?

We havent found any composite primary keys in here... so it should be in its second form right ?

what keys did you find / have?

Well... there was no text or explanation. But we think ID is a primary key...

homework?

ah yea, "little exercise" - sry, missed that

Thats just an exercise... our main problem here is, we dont really understand when a table is in its second form... All attributes need to depend on the whole composite key and not just a part of it... But what happens if theres no composite key ?

4:16 PM

@TomV-trytopanswers.xyz @mustaccio super brain scrambled atm, but it looks like appending .read() to os.popen(...) (yea, back on that...) forces an await

if only i could figure out how to await restart without attaching to the process

4:41 PM

@genaray if there is no composite key, you are fine. But there are usually are more than 1 keys, often some of them composite

@ypercubeᵀᴹ Thanks, you are my today's hero :) We spend hours of looking for a solution but only found simple examples with composite keys... this made us curious... thanks a lot !

with an example of only 4 rows, any guess is good.

You either need to be given the functional dependencies or have a big enough sample

or use "meaning" of the column/attribute names to arrive in decisions.

First+Last name looks like a candidate key in the example but who knows.

With "meaning" I mean: is it an Orders table? a Customers table? something else?

Thats where the fun begins... our prof gave us this example without any explanation... so we just thought "ID" is a Primary key... we dont even know what kind of table this is... but our first guess was, that its some kind of order table ^^

5:01 PM

you are not guaranteed to have tidy data

ID is almost always a surrogate key

and you may have been give data that happens to be unique across the superkey, but only because you're lucky enough to no have had a crap record show up yet

but that's probably not the answer your prof wants

in a professional scenario, given that spreadsheet i'd very politely tell the giver to GTFO

in an academic situation, prob need to take context based on what you've been working on in the course

Cade Roux

5:15 PM

You would have to have a candidate keys for the driver and the meal in order to normalize to 2nd form since they do not depend on the order but on some unstated part of it. Hard to infer with the customer and their address since there is no duplication there.