roapi
Create full-fledged APIs for slowly moving datasets without writing a single line of code.
What is roapi?
Create full-fledged APIs for slowly moving datasets without writing a single line of code.
Overview of roapi
What it is
ROAPI automatically spins up read-only APIs for static datasets without requiring you to write a single line of code. It builds on top of Apache Arrow and Datafusion. The core design includes query frontends that translate SQL, FlightSQL, GraphQL and REST API queries into Datafusion plans, Datafusion for query plan execution, a data layer to load datasets from various sources and formats with automatic schema inference, and a response encoding layer to serialize intermediate Arrow record batches into various formats requested by the client.
Key features
- Query layer: REST API GET, GraphQL, SQL, join between tables, access to array elements by index, access to nested struct fields by key, Postgres protocol, FlightSQL, key value lookup - Response serialization: JSON (
application/json), Arrow (application/vnd.apache.arrow.stream), Parquet (application/vnd.apache.parquet) - Data layer: filesystem, HTTP/HTTPS, S3, GCS, Azure Storage, Google spreadsheet, MySQL, SQLite, Postgres - Data formats: CSV, JSON, NDJSON, parquet, xls, xlsx, xlsb, ods, DeltaLake - Config file support (YAML or Toml) for advanced table options - Dynamic table registration via API
Use cases
ROAPI is designed for slowly moving datasets where you need to expose data through multiple query interfaces (SQL, GraphQL, REST) without writing backend code. It is suitable for analytics, data exploration, and building lightweight APIs over static or infrequently updated data sources.
Getting started
Install via Homebrew or pip: bash brew install roapi # or pip install roapi Quick start with example data: bash roapi --table 'uk_cities=test_data/uk_cities_with_headers.csv' --table 'test_data/spacex_launches.json' Or using Docker: bash docker run -t --rm -p 8080:8080 ghcr.io/roapi/roapi:latest --addr-http 0.0.0.0:8080 --table 'uk_cities=test_data/uk_cities_with_headers.csv' --table 'test_data/spacex_launches.json' Query data via SQL, GraphQL, or REST: bash curl -X POST -d 'SELECT city, lat, lng FROM uk_cities LIMIT 2' localhost:8080/api/sql curl -X POST -d 'query { uk_cities(limit: 2) {city, lat, lng} }' localhost:8080/api/graphql curl 'localhost:8080/api/tables/uk_cities?columns=city,lat,lng&limit=2'
License and pricing
Licensed under Apache-2.0. Open source.
Based on the project's public README and repository metadata.