Ember Crooks (@ember_crooks) header
Ember Crooks (@ember_crooks) profile picture

Passionate data blogger (https://teapawt.org/t.co/IIiPXElvIC). Mastodon: https://teapawt.org/t.co/O7206ipLam Opinions are my own. she/her/hers

Denver, Co
Joined November 2008
Photo by Ember Crooks (@ember_crooks)Photo by Ember Crooks (@ember_crooks)Photo by Ember Crooks (@ember_crooks)Photo by Ember Crooks (@ember_crooks)Photo by Ember Crooks (@ember_crooks)Photo by Ember Crooks (@ember_crooks)Photo by Ember Crooks (@ember_crooks)Photo by Ember Crooks (@ember_crooks)Photo by Ember Crooks (@ember_crooks)
SQL's booleans are TRUE, FALSE, or a secret third thing
7
8
127
Daylight Saving Time is increasingly hard to notice when my digital are devices are like, "What? Nothing happened. We know what time it is." And my stove is left blinking and screaming, "IT HAPPENED! TIME SHIFTED UNNATURALLY! THEY'RE ALL LYING! ONLY I KNOW! ONLY I REMEMBER!"
331
13,166
573
89,949
Ember Crooks retweeted
Generated columns are a barely known but surprisingly well-supported SQL feature. Their main use is to put constraints (and indexes) on values derived from other values of the same table row. modern-sql.com/caniuse/gener…
9
2
38
Ember Crooks retweeted
Have #Db2 in a #k8s managed environment? Did you notice the #rhel Kernel parameters are not persistent? May need to make code adjustments for the optional ones not managed by DBM to make sure they load on reboot. tinyurl.com/mr2v992u
2
4
Replying to @elonmusk
False dichotomy. Should be: . Freedom of speech w/ no accountability . Responsible freedom of speech
59
19
5
344
Comparing Db2 and MySQL: NULL in Indexes datageek.blog/en/2022/11/03/…
1
5
Ember Crooks retweeted
Learn from my fail. Archiving #Db2 logs directly to #aws S3? Watch your archive log directory after restore to another server or into another DB. Could be writing logs where you don't want to.
1
6
The thing I miss most about #Db2 while working with #MySQL : the Db2 optimizer and Db2's explain. This is not a surprise - it was what I expected with switching platforms.
8
It sure feels like Twitter is about to become a toxic cesspool, particularly for women. Where are people going instead for technical community content and connection? Already on Reddit, LinkedIn, and the #Db2 discord. Not about to use Facebook for non-personal stuff.
1
4
Ember Crooks retweeted
Is there some cognitive-science reason why if you finish a talk and immediately ask "any questions?" nobody will have any but if *one* person asks a question you will immediately get five more?
40
5
2
251
Comparing MySQL and Db2: Table and Index Structure datageek.blog/en/2022/10/27/…
1
7
Differences between #Db2 and #MySQL: in Db2, index names must be unique within the DB (or tenant). In this context, a Db2 DB is roughly equivalent to a MySQL server instance. In MySQL, index names only need be unique for that table.
1
6
Differences between #Db2 and #MySQL: using `CREATE TABLE X LIKE Y` in MySQL includes creating the indexes on Y. In Db2, the indexes are not created on Y.
1
8
One of the things that amazes me about learning #MySQL is that I'm learning more about #Db2 in the process. So many "I wonder how Db2 does that?" and "Db2 doesn't do that, does it?"
1
10
Ember Crooks retweeted
22
370
38
2,950
Ember Crooks retweeted
Lots of folks hack on compilers and interpreters but learning database internals feels even more practical to most devs' jobs And every database *contains* at least one programming language There should be way more database hackers :)
I’ve thought databases and compilers are the two fundamental computer programs: everything is either a compiler or a database.
4
6
1
88