Today’s video is a demonstration of the JSON_EQUAL condition introduced in Oracle 18c.
If videos aren’t your thing, you can read about it here.
The star of today’s video is Patrick Hurley, being a little over-dramatic. 🙂
Another year has gone by, and somehow I’m still doing this. 🙂
As I’ve mentioned numerous times, last year was tough year for me. So far this year is going better. That’s partly because I’ve reduced the amount of travelling I’m planning to do, which has freed me to do more fun stuff, like writing and doing the odd video.
As usual I’ll mention some of the other anniversaries that will happen throughout this year.
I thought it would be fun to do a little time travel and look at the website over the years. There were a few really bizarre things I tried out in the early days, including a Gothic horror theme, but I don’t have a record of them and the Way Back Machine only goes back to 2001. You know you are old when the Way Back Machine can’t got that far back! 🙂
So skipping the first year of existence and starting in 2001 the site looked like this.
This was still using the old name before I switched to the current name and URL.
Later in 2001 I started putting the latest articles on the front page and the menu includes link to my Oracle 9i articles. Bleeding edge! 🙂
Things stayed pretty similar looking until 2006, where a new column was added to the front page. I put a rating system in place for the articles, but didn’t know how to stop the search engine spiders from clicking them, so pretty much everything got something like a 2.5 star rating. I quickly removed that and salvaged what little pride I had left.
In 2010 I tried to clean up the look of the site a lot. I removed the left had menu bar and used tabs and quick links instead. I think this was the beginning of the site looking a little more like it does today.
In 2011 I got a bit sick of the washed out colours and increased the contrast. The basic layout is the same though.
Things stayed pretty much the same until 2015, when I switched the site over to use Bootstrap 3. Prior to this I was forever tweaking things for browser compatibility, and having a responsive design was way beyond my meagre web skills. Bootstrap solved loads of problems for me.
The upgrade to Bootstrap 4 a few days ago made some slight changes, but I’m guessing hardly anyone would notice.
This time next year, the site will look … exactly the same. 🙂
It wasn’t exactly a surprise as the APEX 19.1 Early Adopter site was shutdown and there was a maintenance window on apex.oracle.com, which is running APEX 19.1.
I downloaded the 19.1 software and plugged though my Vagrant and Docker stuff bringing it up to date. If you are into that stuff you can find it on my GitHub.
I guess this means I can start the process of upgrading everything at work on Monday. 🙂
Hopefully you won’t have noticed, but there have been a few changes to the website over the last week.
I started the process of moving to Bootstrap 4 and FontAwesome 5 when they were released, but kind-of lost momentum. This stuff is a “necessary evil”, rather than something I’m actively interested in. A couple of early trials proved it wasn’t just a case of using the new versions. I had got about 90% of the way there, but couldn’t force myself to complete the last bit.
Recently I had some advice from a couple of people at work who know more about this sort of thing than me. They quickly pointed out some glaringly obvious flaws in what I was doing, which focused me somewhat. I finally bit the bullet over the weekend and flipped to the new versions. There were a few “interesting” things along the way, including me forgetting to style CODE and PRE tags, which are kind-of important for a website that is almost entirely about code samples. 🙂
I’m sure there will be tweaks over the coming weeks, but I think it’s sorted now. I’m guessing if I hadn’t mentioned it, most people wouldn’t know it had happened. 🙂
Much as this stuff is “not my thing”, but it is good to keep an eye on how things change over time. I now know enough to know I don’t know enough though… 🙂
Just a quick post to mention OUG Ireland 2019, which is just around the corner. The event is on the 4th-5th of April at the Gresham Hotel, Dublin.
I’ve got one session this year, which is called, “Multitenant : What’s new in Oracle Database 18c & 12c Release 2” on Thursday 4th at 15:10. Bits of 19c are starting to creep into this presentation now too. 🙂
Last year I started with no presentations and ended up with two. This year I’m starting with one, so let’s see what I end up with. 🙂
See you there!
Today’s video is a dash through some of the Approximate Query Processing functionality introduced in Oracle database 12.2.
If watching videos scares you, don’t worry, you can get all the information and more from these articles.
The star turn in today’s video is provided by Franck Pachot. 🙂
During a discussion about Artificial Intelligence (AI) a colleague said he was listening to someone on the radio speaking about AI research, and their comments could be summed up by the classic Jurassic Park quote.
“Your scientists were so preoccupied with whether or not they could, they didn’t stop to think if they should.”
We could easily have a similar discussion about the developers of software products aimed at DBAs and developers. I’m guessing the developers of feature X in the database aren’t DBAs or database developers in the sense that we usually use the term. Sounds kind-of obvious, but I think it’s important. When those developers are working on the new whizz-bang feature, are they really thinking about the knock-on effect of that? I don’t mean that in a bad way. I’m just saying the focus of those developers may be very different to that of the DBAs and developers the resulting product is being used by.
I’ve said it a bunch of times, but Oracle Cloud means Oracle has becoming the single biggest consumer of their own products. That continues to have a profound impact on the products. Call it, “eating your own dog food”, or “drinking your own champagne”, the result is the same. I’m hoping the feedback loop is more efficient and “louder” now than it was. 🙂
I look after the infrastructure of a bunch of systems I know nothing about. I build them, deploy software to them, and in some cases I can log into them, but there are very few I actually know how to use. I sometimes get calls about things and I’m super honest about what I can and can’t do. I say things like, “I can turn it off and on, but I don’t have a clue how to use the application!” I think that’s quite common. Once a product grows above a certain size, there’s no way someone will be able to understand all of it. If you are managing multiple products, there is no way you can understand them all.
So when the next version of product X is released and you say to yourself, “Why the heck have they done that?”, the answer may be the team thought it was a good idea, even though you as the user of their product think it’s pointless… 🙂
Today’s video is a demonstration of some of the enhancements to the JSON_OBJECT function in Oracle Database 19c.
If videos aren’t your thing, you can get the same information, and more, from this article.
The star of today’s video is Patrick Jolliffe. 🙂
Today’s video is a quick run through some of the SQL/JSON functionality introduced in Oracle database 12.2.
For those people that want a lot more information, including copy/paste examples, check out the article it’s based upon, and all the other JSON stuff I’ve written here.
The star of today’s video is Roel Hartman of APEX fame!