3 ms·

Jeff Knupp's sandman2 (https://github.com/jeffknupp/sandman2 https://github.com/jeffknupp/sandman2) has long been my go-to project for when i need to do this.

Jeff Knupp's sandman2 (https://github.com/jeffknupp/sandman2 https://github.com/jeffknupp/sandman2) has long been my go-to project for when i need to do this. I don't have to very often, but it is _very_ handy when I do! Semi-related (kind of the inverse) tool is simon w's datasette (https://github.com/simonw/datasette https://github.com/simonw/datasette) which gives you a readonly view into a sqlite database, conveniently exposed as a website. I've fired that up in meetings before to general shock and acclaim...

ahje 7y ago
> simon w's datasette That's awesome. Thanks for the tip!
networked 7y ago
There are many other projects like this, too. I have a list at https://github.com/dbohdan/automatic-api/ https://github.com/dbohdan/automatic-api/. Added: This type of software lacks a standard name and an established "format" (like HTTP servers or word processors have a "format"), so it is hard to discover other projects even when you are aware of a few. I've taken to calling them "automatic API servers" and promoted the term a bit. Some projects have adopted the GitHub topic "automatic-api" (https://github.com/topics/automatic-api https://github.com/topics/automatic-api) as a result. My hope is that a name and a search tag will help with discovery and make it more of a distinct type of product.
- mooreds 7y ago
  Thanks for that list. There is so much data locked up in databases that could benefit from being turned into an API. To say nothing of CSVs and PDFs.
BerislavLopac 7y ago
There is also Presto: https://prestodb.github.io/ https://prestodb.github.io/ If you ever saw AWS Athena, that's what it is based on.
- bdcravens 7y ago
  Perhaps I'm missing something, but I don't see how Presto fits in with these other projects.
  - BerislavLopac 7y ago
    It was in response to the comment mentioning Datasette, which takes data from a source and puts it into a database. Presto allows you to access data from various sources using SQL syntax.
    - snthpy 7y ago
      I think you were thinking of dataset (https://dataset.readthedocs.io/en/latest/ https://dataset.readthedocs.io/en/latest/) rather than datasette mentioned in the parent. Still quite different to Presto which looks more like Ibis.

ahje 7y ago

> simon w's datasette That's awesome. Thanks for the tip!

networked 7y ago

There are many other projects like this, too. I have a list at https://github.com/dbohdan/automatic-api/ https://github.com/dbohdan/automatic-api/. Added: This type of software lacks a standard name and an established "format" (like HTTP servers or word processors have a "format"), so it is hard to discover other projects even when you are aware of a few. I've taken to calling them "automatic API servers" and promoted the term a bit. Some projects have adopted the GitHub topic "automatic-api" (https://github.com/topics/automatic-api https://github.com/topics/automatic-api) as a result. My hope is that a name and a search tag will help with discovery and make it more of a distinct type of product.

mooreds 7y ago
Thanks for that list. There is so much data locked up in databases that could benefit from being turned into an API. To say nothing of CSVs and PDFs.

BerislavLopac 7y ago

There is also Presto: https://prestodb.github.io/ https://prestodb.github.io/ If you ever saw AWS Athena, that's what it is based on.

bdcravens 7y ago
Perhaps I'm missing something, but I don't see how Presto fits in with these other projects.
- BerislavLopac 7y ago
  It was in response to the comment mentioning Datasette, which takes data from a source and puts it into a database. Presto allows you to access data from various sources using SQL syntax.
  - snthpy 7y ago
    I think you were thinking of dataset (https://dataset.readthedocs.io/en/latest/ https://dataset.readthedocs.io/en/latest/) rather than datasette mentioned in the parent. Still quite different to Presto which looks more like Ibis.