(Simpe) Database options supporting Rest API and JSON output?

[Shaun_Dark_Lord]

Hi All

 

I need somewhere secure to host a few MB of data - Mostly email addresses. These will then feed into our helpdesk so users can select valid addresses rather than just making a guess.......

 

Our helpdesk system supports pulling data in JSON format via REST, and supports basic auth or API keys. (No Oauth yet )

 

I've not yet found a suitable cloud based host that I'm happy with, so want to look at hosting something myself.

 

Any recommendations? Ideally, I'd need;

 

• A fairly basic structure where I can just dump a few lists of email addresses.
  
• API access so I can keep the data updated automatically.
  
• Each data set to be output as JSON.
  
• User/API Key level restricted access to individual data sets to limit what the helpdesk has access to.
  

 

Thanks!

[webman]

I know you mentioned about hosting yourself after not finding suitable cloud hosts, but, can I recommend looking into Baserow or Airtable as potential options, if you haven't seen those yet?

 

They both have JSON APIs and meet your list of requirements. Out of both, I'd go for Baserow.

[dhicks]

Our helpdesk system supports pulling data in JSON format via REST

 

Does it support retriving data in CSV format? If so, what you describe is pretty much just a file access - a web-accesible CSV file might be all you need.

[lyness97]

A really good way to get data stored lightweight that is secure, easy to use and has great support is via Supabase. The DB is Postgres and has its own NPM package that can be used to easily fetch your data from the frontend returning JSON.

 

Other options that have free allocation are Planetscale (MySQL), or Railway. If you're looking for an easily way to fetch data from the DB you can also use Prisma or Drizzle accompany them.

 

If you have any questions I'll be more than happy to assist