DEV Community

Cover image for What is your perspective on this "Data API Framework"?
Chih-Yu Yeh
Chih-Yu Yeh

Posted on

What is your perspective on this "Data API Framework"?

Hey, friends

If there is a Data API Framework with these functionalities listed below, what do you think about this tool(or what would you do with this tool)?

  1. You only need to write SQL + Jinja(a template language)and the framework generates APIs and API documentation(based on Open API)for you.
  2. It has API catalog that helps non-tech user to explore your APIs and some simple guides to help him/her connect with other applications, such as Google Spreadsheet, Retool, etc.
  3. It supports several databases such as PostgreSQL, DuckDB, ClickHouse, BigQuery and Snowflake. You can also write your own connector.
  4. It has some API best practices built-in such as authorization, authentication, error handling, rate-limiting, CORS, pagination, etc.
  5. It utilizes DuckDB as a caching layer to improve query performance.
  6. It has data privacy mechanisms such as data masking, row/column level security, etc.
  7. It supports several deployment mechanisms such as node.js and Docker, etc.

Disclaimer: I am one of the members of the open source project VulcanSQL

Top comments (0)