« first day (4485 days earlier)      last day (542 days later) » 

Peter Vandivier
Peter Vandivier
12:13 AM
Challenge accepted
- How I met your mother. Season 6 episode 24
2
 
7 hours later…
John K. N.
John K. N.
6:54 AM
Wordle 666 3/6

⬛🟨🟩⬛⬛
🟨⬛🟩⬛🟨
🟩🟩🟩🟩🟩
Paul White
Paul White
3
A: There is no index in the referenced table where the referenced columns appear as the first column

ypercubeᵀᴹYou need an index on the referencing table on ice_product_manuals (product_id). See: dbfiddle-1 The composite index you have cannot be used for the FK constraint for a peculiar reason. Normally, two (or more) column indexes can be used for FK constraints if the constraint is on the first column(s...

Interesting
Wordle 666 4/6*

⬛⬛⬛⬛🟨
⬛⬛⬛🟨🟨
🟩🟨⬛🟩🟩
🟩🟩🟩🟩🟩
👿
Zikato
Zikato
7:24 AM
Morning
WHARF
CHIEF
THIEF
HEIST
THIEF
Paul White
Paul White
@Zikato Correct!
Zikato
Zikato
Wordle 666 2/6*

🟩🟨⬛⬛🟨
🟩🟩🟩🟩🟩
Paul White
Paul White
Oh v good
But the ideal score today is 6/6
Zikato
Zikato
heh
I think yours might be fun to reverse Wordle
 
2 hours later…
ypercubeᵀᴹ
ypercubeᵀᴹ
9:33 AM
@PaulWhite yeah. I thought hashes would be involved from the first reading - and they were - but the details were interesting. It was not exactly what I expected.
 
4 hours later…
J.D.
J.D.
1:05 PM
@Zikato bet you can't guess my starting word for that one. 😀
@PaulWhite or 3/6
John K. N.
John K. N.
1:22 PM
@Zikato correct
Hannah Vernon
Hannah Vernon
1:40 PM
Wordle 666 6/6*

🟨⬛⬛⬛🟨
🟨⬛⬛⬛🟩
🟨🟨⬛⬛🟩
⬛⬛🟨🟨🟩
⬛🟨🟩⬛🟩
🟩🟩🟩🟩🟩
2
what kind of word is that.
Paul White
Paul White
1:52 PM
A very sixy one, apparently
Hannah Vernon
Hannah Vernon
Yes, the number Wordl of the Beast
Erik Darling
Erik Darling
2:42 PM
user image
that translates well
Paul White
Paul White
sounds like a markdown problem
p sure @Zikato could fix it with some powershell
Erik Darling
Erik Darling
@Zikato is talented with powershell
these days @Zikato is synonymous with powershell
Paul White
Paul White
I usually just say @Zikato instead of 'powershell'
Erik Darling
Erik Darling
@Zikato has a much nicer ring to it
Paul White
Paul White
3:32 PM
> Msg 12135, Level 16, State 1
The Metadata needed for Optimized Locking is not populated yet. Please retry the operation.
Msg 5069, Level 16, State 1
ALTER DATABASE statement failed.
Getting closer
Zikato
Zikato
I'm a powershell beginner. @PeterVandivier is the source of powershell knowledge
 
1 hour later…
Erik Darling
Erik Darling
4:50 PM
@PaulWhite CU3?
Paul White
Paul White
@ErikDarling CU2
Erik Darling
Erik Darling
5:28 PM
Hrm.
Awfully outdated for a man living in the future
Paul White
Paul White
Oh I hadn't noticed 2022 CU3 was out
Erik Darling
Erik Darling
You liked my announcement Tweet
How dare you sir
How very dare you
Paul White
Paul White
I forgot!
Not a very big update is it
UDF inlining of course
Ginger
Ginger
6:21 PM
hey yall, it's me
just wanted to let you know that the PLDI site proposal has officially reached 200 committers!
our thanks to those of you who committed or proposed questions
Erik Darling
Erik Darling
7:16 PM
More fake ginger propaganda
Zikato
Zikato
8:14 PM
@J.D. alien
J.D.
J.D.
8:37 PM
@Zikato Nopers.
Zikato
Zikato
Well, I've guessed it. You didn't specify that you want a correct guess
Charlieface
Charlieface
Just found an absolute gem in the MySQL docs:
> MySQL parses but ignores “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification. MySQL accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification.
Mar 12 at 11:36, by Charlieface
MySQL really is a toy database
Let's not disallow it in the syntax, just completely ignore it. Who thinks up these brainwaves?
J.D.
J.D.
8:55 PM
@Zikato Fair. Willing to Venmo you $5 if you can correctly figure it out in 5 guesses. 🙂
@Charlieface same people who prefer Java to C# 👀
Sorry any peoples who do. 🙃
Charlieface
Charlieface
@J.D. ?? Not very familiar with Java
J.D.
J.D.
Eh it's probably another spaces vs tabs debate. But I learned Java before I got into C#. After I got into C# I remember when Java 8? (maybe 7?) dropped, and 7 of the 10 highlighted features were already in C# for multiple years at that point.
I never felt a need to go back to Java since. But obviously it's still has it's fair use, and community backing, even in mobile dev these days.
So I'm just dropping my opinion. Take it with a grain of salt.
Charlieface
Charlieface
@J.D. No that would be more of a SQL Server vs Postgres comparison: almost peers but one always seems to be ahead. This is more of a QBasic vs VB comparison: it's just a toy DB, there is no way anyone should be using it for serious work.
> * Scalar UDF returns results in different date and time formats when the Scalar UDF Inlining feature is enabled (added in SQL Server 2022 CU3 and SQL Server 2019 CU20)
I'd love to see the repro, that sounds hilarious.
J.D.
J.D.
@Charlieface Fair. Didn't MySQL originate from some ex-Oracle Devs though?...kinda why I thought mentioning Java was topically relevant too.
Charlieface
Charlieface
@J.D. Yeah, have a laugh from one of the devs
Oct 3, 2022 at 15:33, by ypercubeᵀᴹ
@Charlieface https://web.archive.org/web/20211206184838/https://blog.sesse.net/blog/tech
Also this
5
Q: MySQL is giving weird result

SagarPPanchalI don't have this kind of ID in my table, still MySQL is giving me a result. This same result is giving when i place in my php code.

mysql
J.D.
J.D.
9:16 PM
@Charlieface heh I have read that before.
Charlieface
Charlieface
@J.D. Here's another:
7
Q: MySQL: Swap ID between two rows

SahasrarWe have existing table: | id | name | color | calories | ------------------------------------------ | 1 | apple | red | 20 | | 2 | orange | orange | 10 | | 3 | grapes | green | 5 | | 4 | bananas | yellow | 15 | | 5 | plum ...

mysql update
J.D.
J.D.
@Charlieface hah I think I've seen that too actually. Good stuff...
Charlieface
Charlieface
So have I, but every time I see them again it makes me fall about laughing. This is basic bugs and mis-features all over the place.
J.D.
J.D.
In contrast, PostgreSQL actually seems like a pretty solid open source database system. And I don't particularly like to give complements to open source software lol.
2
Charlieface
Charlieface
Also interesting that the Venn of PHP and MySQL users very closely correlates: guess they suit the same type of coders.
J.D.
J.D.
9:19 PM
@Charlieface Lol true
I remember when I used PHP...back when I was 11.
Sorry any PHP devs in here...
Also, WordPress is just a mess too, speaking of PHP...
 
1 hour later…
ypercubeᵀᴹ
ypercubeᵀᴹ
10:26 PM
@J.D. not really
MySQL was bought by Sun, then Sun by Oracle.
J.D.
J.D.
10:56 PM
Worddd

« first day (4485 days earlier)      last day (542 days later) »