Make CSVs into APIs (+ More)

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.

Something that I’ve built out …

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.


Author: Jason Lowe

I am passionate about how organisations adopt IT quickly and sustainably to achieve a specific and measurable outcome. This thinking is supported through lean IT practices in operational support and project delivery, and adopting these practices with Oracle technologies by creating sustainable platforms. I'm also interested different perspectives and drivers - from enterprise to start-ups, academia to commercial to public sector, cost-sensitive (risk) to value-driven (reward) - all of which influences decisions that organisations make. I have a passion for community and have been called "a connector" - meeting new people that are trying to solve valuable and hard problems and connecting them with others that can validate and help realise their full potential. I've supported different organisations like TADHack and Hacking Health as a global organiser. I'm is a persistent blogger on and and on LinkedIn - #CommunityMatters #ItTakesAVillage

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: