docker # .github
This is the development site for API Logic Server. This is used by the development team; the first link below is intended for users.
| Site | For | Notes |
|---|---|---|
| User Documentation | Users | Creating projects |
| Tutorial | Users | No-install eval, using Codespaces |
| demo | Users | Review a Sample Project (try Shift + ".") |
| MySQL creation and deployment | Users | Creating and deploying MySQL example with docker and docker-compose |
| Postgres deployment | Users | Deploying existing Postgres example with docker and docker-compose |
| SQLAlchemy | All | ORM |
| SAFRS | All | API |
| Flask | All | Server |
| API Logic Server Source | Developers | Dev Install - source and docs |
| Docs Source | Developers | Uses mkdocs |
API Logic Server is an open source Python project to make it faster and easier to create database web applications. It provides a CLI to create customizable projects with a single command, that you can then run / customize / debug in your IDE.
Created projects provide an API, an Admin Web App, and spreadsheet-like business rules to enforce database integrity. They can be containerized to simplify deployment.
Additional background is provided in the next section, below. Extensive documentation is available here - checkout the FAQs.
You can use this page in several ways:
-
Tutorial: Click here to open codespaces to see a created project, explore it, and learn how to create it
-
Learning Center: Click here to use an API Fiddle to learn key concepts of JSON:API, Flask and SQLAlchemy
We saw shortfalls in current approaches for building database systems:
-
Frameworks: too slow - multi-endpoint APIs and multi-page apps would require weeks in frameworks such as Flask or Django, since it's all code -- no automation
-
Low Code Tools: no backend automation, proprietary IDEs - good UI automation, but none for backend business logic (nearly half the effort), and often do not leverage existing IDEs (VSCode, PyCharm, etc).
So, we created API Logic Server: with a single command, create executable / customizable database projects, providing an Admin App, an API, and spreadsheet-like rules for business logic.
API Logic Server is an open source Python project: a CLI for project creation, and a set of execution runtimes. Install with a standard Python (pip) install or Docker.
ApiLogicServer create --project_name=ApiLogicProject --db_url=
API Logic Server reads your schema, and creates an executable project:
-
API - an endpoint for each table, with filtering, sorting, pagination and related data access
-
Admin UI - multi-page / multi-table apps, with page navigations and automatic joins
Customize projects in your IDE (VSCode, PyCharm, etc.) for edit, debug and code management.
Declare business logic with spreadsheet-like rules (40x more concise than code), extensible with Python.