Best way to set up and query a simple database on Mac

There a many ways to achieve that.

In my case, I am working on a project currently to use Devonthink as a database and automate uploading its data to Google Sheets, then using Siteoly from there.

My goal is thus to use Devonthink as the basis for a database-driven website.

I can let you know when the project is completed if you are interested.