Datatools

Overview:

This product analysis is about two different API implementations: one using FastAPI + SQLAlchemy + pydantic and the other using Flask + Protobuf.

The first implementation is a minimalistic FastAPI HTTP REST service that returns serialized stock time-series data from a SQLite database. It uses SQLAlchemy as the ORM and pydantic for serialization and validation. The project contains a basic synchronous HTTP server using FastAPI, and demonstrates how to use SQLAlchemy to model and query data, as well as how to create data schemas using pydantic.

The second implementation is a minimalistic Flask HTTP REST service that returns serialized stock time-series data from a local parquet file. It uses Protobuf for serialization/deserialization of messages over HTTP. The project contains a basic HTTP server using Flask Restful and demonstrates how to use Dask on the backend to read/manipulate data from the parquet file and serialize using Protobuf.

Features:

• FastAPI + SQLAlchemy + pydantic implementation:
  • Minimalistic FastAPI HTTP REST service
  • Returns serialized stock time-series data from a SQLite database
  • Uses SQLAlchemy as the ORM
  • Uses pydantic for serialization and validation
  • Contains a basic synchronous HTTP server using FastAPI
  • Demonstrates how to use SQLAlchemy to model and query data
  • Demonstrates how to create data schemas using pydantic
• Flask + Protobuf implementation:
  • Minimalistic Flask HTTP REST service
  • Returns serialized stock time-series data from a local parquet file
  • Uses Protobuf for serialization/deserialization of messages over HTTP
  • Contains a basic HTTP server using Flask Restful
  • Demonstrates how to use Dask on the backend to read/manipulate data from the parquet file and serialize using Protobuf

Summary:

This product analysis discussed two different implementations of APIs. The first one used FastAPI, SQLAlchemy, and pydantic, while the second one used Flask and Protobuf. The FastAPI implementation demonstrated how to build a minimalistic HTTP REST service that retrieves serialized stock time-series data from a SQLite database. It utilized SQLAlchemy for the ORM and pydantic for validation and serialization. On the other hand, the Flask implementation focused on building a minimalistic HTTP REST service that retrieves serialized stock time-series data from a local parquet file. It employed Protobuf for message serialization and Flask Restful for handling HTTP requests. The implementation also showcased the use of Dask to read and manipulate data from the parquet file. Both implementations provided a basic HTTP server to serve the API endpoints and included instructions for installation and usage.