After a long beta period where just a selected number of developers could try out my newest open source development efforts, it’s now time to release it into the wildlife! But what is Oracle APEX Essentials? It is the essential tool collection for your daily Oracle Application Express (APEX) development! It currently consists of two tools.
The Advisor is responsible for checking the integrity and quality of your Oracle APEX application.
Oracle APEX applications are interpreted, that’s why most of the errors are only showing up when the application is executed and not already when you are doing the development.
But there are also errors which even do not show up during execution, for example if you reference a non existing page item with the substitution- (&P999_TEST.) or bind variable syntax (:P999_TEST). Oracle APEX will just ignore it and return NULL instead. But there are not just the obvious errors in an APEX application. SQL injections, performance issues and best practices are other examples.
That’s where the Advisor comes into the game. It’s like a compiler/LINT for your Oracle APEX applications, it will check the integrity of your application based on the meta data of your application. It does not only check the above cases, there are currently a total of 22 checks which are performed! But that’s not all, you can even add your own QA checks! More about that in one of my next postings.
Power Search is a Google like search to find text in your Oracle APEX application. It’s the newest child in the essentials tool collection which I have implemented a few weeks back during a long train ride to my sister. I should still do some refactoring to share more much more code with the Advisor, but that’s internal stuff which shouldn’t stop you to use this tool. Just don’t look at the code!
Try it out and download it!
Got interested? Check out the project homepage to get more details about Oracle APEX Essentials.
Ideas and feedback
You like it, you have found a bug or have an idea for a new feature? Any feedback is very appreciated. The necessary links can also be found on the homepage.
I hope you like it, have fun with it and can spend more of your time for other things than just for hunting for bugs in your code.