Danny Kwok

There’s no box

Website

  • APEX Debug 101

    Today, I finally figured out how to work the APEX debug. It was not straightforward due to a little fine print that we need to do get it working. This is a pretty good reference that I used to get started. However, I only manage to make it work after a few hours of tweaking… Continue reading

  • APEX Interactive Grid and REST

    Oracle Apex Interactive Grid is a cool feature. You can quickly deploy CRUD (Create Read Update Delete) in a matter of minutes. Unfortunately, it does not work well using out of box REST data source. We realise this after a week of troubleshooting as to why our REST endpoints keep failing. Continue reading

  • PUT to REST

    The standard REST methods in ORDS (Oracle REST Data Services) are GET, POST, PUT and DELETE. We usually started testing REST with GET because it is usually the easiest for SELECT statement. POST will be next for INSERT for new creation. The complex PUT will be the last for any UPDATE process. DELETE is seldom… Continue reading

  • You are not Learning with Dashboard

    3 years ago, I embarked on a mission to design and deploy dashboard. The overarching vision is to utilise dashboard as a tool to enable business analytics and to learn on how to improve business operations. From a moment of self reflection as of today, it is interesting to realise a key lesson from my… Continue reading

    ,

  • Troubleshooting APEX REST Synchronisation

    Oracle Apex REST can be a pain if it is not working as expected. Today was the day we delved deeper to REST to why data source is not synchronised to the target table. It was another day of hair pulling and lots of testing to figure out how synchronisation should be working for APEX. Continue reading

    ,

  • REST in Peace

    Recently, we are exploring a lot of REST API. Although REST is quick and simple, there are challenges to take note while using it. This is because we are used to field types such as date. There are also things to take note while handling the different REST methods like GET or POST. Continue reading

  • Why PM is Outdated

    In the world of Agile, there is no PM (Project Manager) role. I have questioned on the relevance of PM in Agile project. With Agile gaining grounds, it is time to determine that PM role is outdated. These are reasons why you can run your Agile project without PM. To be specific, it is time… Continue reading

    , , ,

  • OTM Upgrading Risks

    OTM (Oracle Transportation Management) upgrading has its own challenges and risks. Thus, a major upgrade or major version increase will typically take more than six months or so. You should have standard risk mitigation action plans. The major risks from upgrades comes from both internal and external factors. These are some common ones that you… Continue reading

  • REST and Dates Type

    Database field types like numbers or dates are no longer relevant for REST services. This is because REST transmission are often in text format. Thus, you will need to consider your database design while handling REST. Should you choose a date type or retain string format for REST? Continue reading

  • Real Time System is Costly

    You will find many instance where users ask for real time in the requirements. Such requirements must always be check carefully for many reasons. This is because real time design is costly. How do you determine the need of real time? These are some standard queries you can ask before you embark on real time… Continue reading