The Heap™ – Consultancy ©®

A: What are the effective communication channels for effecting change to SE?

Morning

Andriy M

Morning

McNets

6:56 AM

Morning

4 hours later…

Paul White

11:21 AM

Meta isn't scaling well for any of the goals that it was originally designed to meet. I don't want to get lost in discussing all of the ways that it's just not working; I'd rather just say that our structure when it comes to development evolved considerably and meta simply didn't. I don't have ...

2 hours later…

12:57 PM

Thanks for the honesty, it's really appreciated. But I'm sad that Stack Overflow is changing into just another internet company that wants to make money. It's no longer "by programmers, for programmers, with the ultimate intent of collectively increasing the sum total of good programming knowledge in the world." — Stijn 17 hours ago

1:26 PM

I wonder what the inappropriate content was that showed up

I don't look at the HNQL a lot, so I missed it.

@hot2use I do sometimes....there are some interesting questions out there

1:45 PM

Yeah I look at them too

I actually liked some of the IPS questions, it's weird what people feel the need to ask online sometimes

@TomV I have some fun reading workplace....some people are really obsessed with how work should be....

strong cultural differences

some posters (mainly from the US) see work as kinda the law of everything, it's weird

2:20 PM

@Lamak yeah often my reaction is "get up and talk to each other" but the consensus in the answers is often "talk to manager, involve HR, get things in writing"...

@TomV document, search for another job, they can fire you for whatever reason they want….

Jack Douglas

3:03 PM

Why are you asking this here and not on twitter? — fontgeologist Oct 19 at 11:45

@JackDouglas do you have a link to the tweet that they are talking about?

A: Revisiting the "Hot Network Questions" feature, what are our shared goals for having it?

4:00 PM

@ypercubeᵀᴹ it's so freaking weird

281

First and foremost, I don't understand Tim Post's reticence to say which SE post or posts were "responsible" for the Twitter spat. Which, if I understand correctly, lasted a relatively short time. The tweet that started the controversy was this stack exchange: the #1 site for your questions...

Jack Douglas

I couldn't find a link to the actual Tweet :(

maybe it's been deleted. Duck Duck Go seems to think it was this user: twitter.com/fvrmvn

@JackDouglas that answer has a screenshot though

Jack Douglas

Yes and some helpful search text. But still can't find the Tweet.

4:23 PM

Are those titles really that offensive? Glossy magazines are full of such stuff

feedback.azure.com/forums/908035-sql-server/suggestions/…

Dbinary or string data would be truncated => error message enhancments

Fixed

2 hours later…

A: Composite key as foreign key (sql)

6:41 PM

Hi every one

Can I relate a compound primary key to related fields as compound foreign key on another table in MySQL/MariaDB?

I have already reviewed the following:

Per the mySQL documentation you should be able to set up a foreign key mapping to composites, which will require you to create the multiple columns. Add the columns and put this in your group table FOREIGN KEY (`beggingTime`,`day`,`tutorId`) REFERENCES tutorial(`beggingTime`,`day`,`tutorId...

@MRS1367 ok...and it has a good answer (as far as I can tell)

few regulars here are savvy about mysql

@Lamak But I will encounter the following error:

Can't create table database1.#sql-1898_f (errno: 150 "Foreign key constraint is incorrectly formed")

I've two columns in every table

and their attributes are the same

Andriy M

@MRS1367 The attributes must be exactly the same. That error usually indicates they are not. Therefore, the usual question in such cases is, are you sure?

@AndriyM Yes

Primary keys are as follows:

In table1:
PRIMARY KEY (resId, number, floor)

INT(11), INT(3), INT(3)

In table2:
resId, number, floor
INT(11), INT(3), INT(3)
NOT NULL

It's just an example

and I want to know how can I do that

Andriy M

7:08 PM

@MRS1367 A demo using your example: dbfiddle.uk/…

7:19 PM

@AndriyM Thank you

8:10 PM

@Lamak Good? The syntactic part, OK.

@ypercubeᵀᴹ I admit I didn't really read them ;)

But where it says that SQL was built for single column PKs and FKs, I disagree

@ypercubeᵀᴹ I admit that I didn't read that part

@MRS1367 those (11) and (3) are only decoration, by the way. They make no difference at all to the column type or allowed values.

They are all INT.

@ypercubeᵀᴹ but they look good

8:22 PM

Yeah, they are like the numbers in footballers shirts ;)