Connor McDonald on Database and SQL
@connormcd.bsky.social
Hi I'm Connor McDonald!
🔥keen on tech esp. SQL/database
🔥keen on fitness
🔥keen on coffee
🔥keen on gin
🔥keen on sarcasm
I speak for me not my employer
🔥keen on tech esp. SQL/database
🔥keen on fitness
🔥keen on coffee
🔥keen on gin
🔥keen on sarcasm
I speak for me not my employer
Pretty sure @kelseyhightower.com isn't talking about databases here 😁, but the same rules apply. Take advantage of your declarative constraints
Creating with constraints exposes craftsmanship.
February 12, 2026 at 12:21 PM
Pretty sure @kelseyhightower.com isn't talking about databases here 😁, but the same rules apply. Take advantage of your declarative constraints
Blast from the past. The art of describing a problem. https://connor-mcdonald.com/2015/12/14/the-art-of-describing-a-problem
February 10, 2026 at 6:08 PM
Blast from the past. The art of describing a problem. https://connor-mcdonald.com/2015/12/14/the-art-of-describing-a-problem
Buzzing in AI world Mumbai 🔥
February 10, 2026 at 6:44 AM
Buzzing in AI world Mumbai 🔥
Reposted by Connor McDonald on Database and SQL
What I lost in Twitter, I found in Bluesky.
February 10, 2026 at 3:14 AM
What I lost in Twitter, I found in Bluesky.
Blast from the past. Free In-memory in Oracle Database 19c. https://connor-mcdonald.com/2020/05/01/in-memory-opportunities-abound/
February 9, 2026 at 6:08 PM
Blast from the past. Free In-memory in Oracle Database 19c. https://connor-mcdonald.com/2020/05/01/in-memory-opportunities-abound/
What a wild day with the students in Bengaluru 🔥🔥🔥
February 9, 2026 at 2:27 PM
What a wild day with the students in Bengaluru 🔥🔥🔥
Reposted by Connor McDonald on Database and SQL
What has happened to the 19.29 and 19.30 RUs?
Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don't…
Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don't…
What has happened to the 19.29 and 19.30 RUs?
Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don't have OJVM configured but install the OJVM bundle. So, what has happened to the 19.29 and 19.30 RUs??
mikedietrichde.com
February 9, 2026 at 10:22 AM
What has happened to the 19.29 and 19.30 RUs?
Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don't…
Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don't…
Blast from the past. DDL gets my goat. https://connor-mcdonald.com/2020/07/22/ddl-gets-my-goat/
February 8, 2026 at 6:08 PM
Blast from the past. DDL gets my goat. https://connor-mcdonald.com/2020/07/22/ddl-gets-my-goat/
There is a difference between
"Hi Connor, I tagged you on my linkedin post"
and
"Hi Connor, I tagged you on my linkedin post. You HAVE to comment on it. I am going to follow you around just to make sure that you do it"
Yeah, that ain't the way bro.
"Hi Connor, I tagged you on my linkedin post"
and
"Hi Connor, I tagged you on my linkedin post. You HAVE to comment on it. I am going to follow you around just to make sure that you do it"
Yeah, that ain't the way bro.
February 8, 2026 at 9:55 AM
There is a difference between
"Hi Connor, I tagged you on my linkedin post"
and
"Hi Connor, I tagged you on my linkedin post. You HAVE to comment on it. I am going to follow you around just to make sure that you do it"
Yeah, that ain't the way bro.
"Hi Connor, I tagged you on my linkedin post"
and
"Hi Connor, I tagged you on my linkedin post. You HAVE to comment on it. I am going to follow you around just to make sure that you do it"
Yeah, that ain't the way bro.
Just a typical Sunday in Bengaluru... #oracle #community
February 8, 2026 at 3:05 AM
Just a typical Sunday in Bengaluru... #oracle #community
Previously on the blog. Larger number of Exadata storage indexes. https://connor-mcdonald.com/2019/11/19/exadata-storage-indexes/
February 7, 2026 at 6:08 PM
Previously on the blog. Larger number of Exadata storage indexes. https://connor-mcdonald.com/2019/11/19/exadata-storage-indexes/
AIOUG multi cloud AI conference is to in Hyderabad! Full house on weekend!
February 7, 2026 at 4:42 AM
AIOUG multi cloud AI conference is to in Hyderabad! Full house on weekend!
Blog greatest hits :-) . Nulls are not stored in indexes most of the time. https://connor-mcdonald.com/2020/03/04/nulls-are-not-stored-in-indexes-most-of-the-time/
February 6, 2026 at 6:08 PM
Blog greatest hits :-) . Nulls are not stored in indexes most of the time. https://connor-mcdonald.com/2020/03/04/nulls-are-not-stored-in-indexes-most-of-the-time/
When an athlete says they are just "working out the final few wrinkles" 😂
Reports that Olympic ski jumpers are injecting their penises with hyaluronic acid to improve performance on jumps have aroused controversy
These Olympic Athletes Are Reportedly Doing WHAT To Their Penises For A Competitive Edge?
The Olympics haven't officially begun, but a report that ski jumpers may be using penis injections before competition is already arousing controversy.
www.huffpost.com
February 6, 2026 at 1:39 PM
When an athlete says they are just "working out the final few wrinkles" 😂
Retro blog post. Upgrade with no effort. https://connor-mcdonald.com/2017/09/04/upgrade-with-no-effort/
February 5, 2026 at 6:08 PM
Retro blog post. Upgrade with no effort. https://connor-mcdonald.com/2017/09/04/upgrade-with-no-effort/
Blast from the past. Take care with regular expressions. https://connor-mcdonald.com/2018/08/22/take-care-with-regular-expressions/
February 4, 2026 at 6:08 PM
Blast from the past. Take care with regular expressions. https://connor-mcdonald.com/2018/08/22/take-care-with-regular-expressions/
Retro blog post. EXPORT not GATHER with DBMS_STATS. https://connor-mcdonald.com/2019/01/16/export-not-gather-with-dbms_stats
February 3, 2026 at 6:08 PM
Retro blog post. EXPORT not GATHER with DBMS_STATS. https://connor-mcdonald.com/2019/01/16/export-not-gather-with-dbms_stats
Thrilled to be heading back to the Indian Oracle community...but not all family members are happy about it 🥲
February 3, 2026 at 8:13 AM
Thrilled to be heading back to the Indian Oracle community...but not all family members are happy about it 🥲
As the saying (almost) goes: "64K should be enough for anybody" :-)
youtu.be/lo1OJCv8_dM
youtu.be/lo1OJCv8_dM
IN-LIST changes in 26ai - My Girlfriend Dumped Me
YouTube video by SQL and Database explained!
youtu.be
February 3, 2026 at 8:07 AM
As the saying (almost) goes: "64K should be enough for anybody" :-)
youtu.be/lo1OJCv8_dM
youtu.be/lo1OJCv8_dM
Blog greatest hits :-) . Code enhancements without changing code. https://connor-mcdonald.com/2016/11/01/code-enhancements-without-changing-code
February 2, 2026 at 6:08 PM
Blog greatest hits :-) . Code enhancements without changing code. https://connor-mcdonald.com/2016/11/01/code-enhancements-without-changing-code
Be careful when talking about 26ai IN-LIST processing. My girlfriend wasn't happy :-)
Full video on youtube youtu.be/lo1OJCv8_dM
Full video on youtube youtu.be/lo1OJCv8_dM
February 2, 2026 at 5:40 AM
Be careful when talking about 26ai IN-LIST processing. My girlfriend wasn't happy :-)
Full video on youtube youtu.be/lo1OJCv8_dM
Full video on youtube youtu.be/lo1OJCv8_dM
Previously on the blog. Histograms on data (not the optimizer). https://connor-mcdonald.com/2016/01/27/histograms-on-data-not-the-optimizer
February 1, 2026 at 6:08 PM
Previously on the blog. Histograms on data (not the optimizer). https://connor-mcdonald.com/2016/01/27/histograms-on-data-not-the-optimizer
Blast from the past. Why you might add columns to external tables. https://connor-mcdonald.com/2020/04/30/adding-columns-to-external-tables-idiocy/
January 31, 2026 at 6:08 PM
Blast from the past. Why you might add columns to external tables. https://connor-mcdonald.com/2020/04/30/adding-columns-to-external-tables-idiocy/
Previously on the blog. Multiple partitions. https://connor-mcdonald.com/2016/01/18/multiple-partitions
January 30, 2026 at 6:08 PM
Previously on the blog. Multiple partitions. https://connor-mcdonald.com/2016/01/18/multiple-partitions
Vectorised my entire photo library on the home NAS with a model that supports images and text, and now I can find pics much easier with SQL :-)
With probably throw a little APEX app on top.
#26ai
With probably throw a little APEX app on top.
#26ai
January 30, 2026 at 9:27 AM
Vectorised my entire photo library on the home NAS with a model that supports images and text, and now I can find pics much easier with SQL :-)
With probably throw a little APEX app on top.
#26ai
With probably throw a little APEX app on top.
#26ai