Skip to main content

App

Dropbase is an internal app-building platform for developers to create full-stack apps with SQL and Python.

You can build apps by choosing UI components from a list and linking (binding) functions to them, without the need for Node, React/JS, or other frontend libraries/code.

Dropbase lets you to access, modify, and control UI components via functions, which interact with State and Context objects. The combination of pre-built UI components, backend functions, and manipulation of state/context let you to build full-stack internal apps to perform actions on your data and automate ops workflows, with just Python.

Key features

  • Python-Centric Development: Develop full-stack applications entirely using Python, without the need for expertise in Node, React, Javascript, or other frontend libraries/code.
  • Reuse existing scripts: Import your existing Python scripts and libraries, eliminating the need to rewrite your tools to fit our framework.
  • State and Context Interaction: Utilize State and Context objects to access, modify, and control UI components through your functions, enabling dynamic interaction with your application.
  • UI Component-Based Development: Build applications by selecting UI components from a predefined list and seamlessly link (bind) functions to them.
  • Data Manipulation: Create apps for data management and automate operations workflows, making it easier to work with your data.

Structure of Dropbase Apps

  • Apps
    • Page
      1. Tables
      2. Widget
        • UI Components
      3. Functions (data fetching functions or scripts)

App structure

Page​

A Page is a set of Tables, Widgets, and Functions.

Tables​

Tables are used to display any data you need to perform actions. Data is queried into tables using Data Fetcher Functions. See Tables to learn more.

Widgets​

A Widget is a set of UI Components that let you peform desired actions on your data. See Widgets to learn more.

UI Components​

UI Components are form elements that allow users to display text, input data, select options, or trigger Functions. See UI Components to learn more

Functions​

Functions let you fetch data or perform actions. There are two types of functions: Data Fetchers and Scripts. All Functions can access user input via State. They can also access and modify Widget and UI Component properties via Context. See State & Context to learn more.

See Functions to learn more.

Data Fetchers​

There are two types of Data Fetchers: A SQL Data Fetcher and a Python Data Fetcher.

  1. SQL Data Fetchers. SQL Data Fetchers let you query data from a SQL database.

  2. Python Data Fetcher Python Data Fetchers lets you write any Python code to fetch data from anywhere.

Scripts​

Scripts let you write custom Python code to transform data, perform actions, interact with external data sources.