This repository provides an API interface to access any psql database with real-time CRUD.
The SchemaDB API allows users to interact with a database through a set of defined endpoints. It offers dynamic table creation on-the-fly, updating existing tables, and inserting new data seamlessly.
- Real-time CRUD: Tables are created dynamically as needed based on user requests.
- Real-time Data Manipulation: Perform CRUD (Create, Read, Update, Delete) operations on the database in real-time, enabling instant data changes and updates.
- Schema Information Endpoint: Retrieve schema information for the database, including tables, columns, and data types.
- RESTful API: The API follows REST principles for easy integration and usage.
- Error Handling: Comprehensive error handling to provide informative responses.
To install and use the Realtime Database API, follow these steps:
-
Clone this repository to your local machine:
git clone git@github.com:adith-p/SchemaDB-API.git -
Install the necessary dependencies. Ensure you have Python and pip installed. Then, run:
pip install -r requirements.txt -
Configure the database connection settings in
database.pyfile. -
Run the API server:
uvicorn main:app
Note: pushing code every day