This is going to be quick. This is not a “war and peace”. Over the next few days, there will be converging on the #SmartCities hosted by Hackmakers- Friday, June 4 – Tuesday June 8 (07:30 EST | 17:00 IST | 19:30 SGT | 21:30 AEST). You can find more details (here). There was an ask at the previous hackathon which was which instigated this piece of work:
How might I create an API from a CSV dataset?
This in itself can be relatively simple in terms of putting it somewhere and building out an API around it. Especially when you are discovering what datasets to use, then having the ability to be efficient for managing datasets seems a good idea. And not everyone wants to build code so it needs to be simple to execute. And because we don’t know exactly how the dataset will be used, then having something that could present and model data to cater for multiple purposes. And lastly, something that didn’t need a large amount of infrastructure or services to make happy. All of this drove me to take this approach.
Using Oracle Cloud Infrastructure and specifically Autonomous Database, it can store the data, expose as APIs, enabling much of the already available capabilities – machine learning, spatial, graph, low-code with APEX. The bit is to make the load and creation (as well as dropping datasets easy).
To get started with this:
- The code is available on github (here).
- An Oracle Cloud Infrastructure tenancy.
- Creating an Autonomous Database instance in that tenancy.
- A few free downloads and setting up the environment.
Here is a video demonstrating how to get this infrastructure up and going. The video is less than 10mins to watch and the end-to-end process was less than 30mins (though I had python already installed).
Hopefully, this will help teams to speed up their execution using Oracle Cloud Infrastructure and keep the myriad of possibilities as wide as possible whilst being able to focus on execution and delivering on the outcomes.