Ember Crooks · @ember
74 followers · 59 posts · Server hachyderm.io
Ember Crooks · @ember
71 followers · 52 posts · Server hachyderm.io
Ember Crooks · @ember
69 followers · 51 posts · Server hachyderm.io
Ember Crooks · @ember
65 followers · 48 posts · Server hachyderm.io
Ember Crooks · @ember
64 followers · 47 posts · Server hachyderm.io

A year of switching RDBMS platforms from Db2 to MySQL

datageek.blog/en/2023/04/18/th

'sDataScienceJourney

#featured #Db2 #ember #mysql

Last updated 1 year ago

Ember Crooks · @ember
62 followers · 46 posts · Server hachyderm.io
Ember Crooks · @ember
60 followers · 42 posts · Server hachyderm.io
Ember Crooks · @ember
58 followers · 34 posts · Server hachyderm.io
Andri :iterm2_logo: · @andrioid
362 followers · 110 posts · Server hachyderm.io

Is there a relational database feature that aborts the query, if it fails to use indexes?

I'd much rather get an error, than to do a full table scan.

Is that possible?

#postgres #mysql #oracle #Db2 #mssql

Last updated 2 years ago

Ember Crooks · @ember
47 followers · 29 posts · Server hachyderm.io
Ember Crooks · @ember
42 followers · 27 posts · Server hachyderm.io

Interesting how much I'm learning about by learning another RDBMS () in-depth. So many things I just "knew" are now more explicit, and I understand more about them. So many times I encounter something surprising in MySQL and then dig into what I really know about the same topic in Db2.

#Db2 #mysql

Last updated 2 years ago

Ember Crooks · @ember
39 followers · 23 posts · Server hachyderm.io
Ember Crooks · @ember
39 followers · 23 posts · Server hachyderm.io

@skibish -1 actually makes more sense to me than 0. I immediately suspect it means the maximum possible size. 0, I had to look up what it even does, and I'm still not sure I like it at all. In , any VARCHAR below 5 should probably just be a CHAR due to the overhead around VARCHAR.

#Db2

Last updated 2 years ago

Ember Crooks · @ember
20 followers · 4 posts · Server hachyderm.io

Accidentally created a column in with data type VARCHAR(0) today, and it blew my mind that it even works. It fails in . Here I thought VARCHAR(1) was bad.

#mysql #Db2

Last updated 2 years ago

Ember Crooks · @ember
20 followers · 5 posts · Server hachyderm.io