streamlit_sql 0.1.6

CRUD interface for sqlalchemy using streamlit

streamlit_sql

Introduction

This package shows a CRUD frontend to a database using sqlalchemy in a streamlit app. With few lines of code, show the data as table and allow the user to read, filter, update, create and delete rows with many useful features.

Demo

See the package in action here.

Features

READ

• Display as a regular st.dataframe
• Add pagination, displaying only a set of rows each time
• Display the string representation of a ForeignKey column (Using str method), instead of its id number
• Select the columns to display to the user
• Add a column to show the rolling sum of a numeric column

FILTER

• Filter the data by some columns before presenting the table. It can use columns from relationship tables too.
• Let users filter the columns by selecting conditions in the sidebar
• Give possible candidates when filtering using existing values for the columns
• Let users select ForeignKey's values using the string representation of the foreign table, instead of its id number

CREATE / UPDATE / DELETE

• Users create new rows with a dialog opened by clicking the create button
• Users update rows with a dialog opened by clicking on desired row
• Text columns offers candidates from existing values
• ForeignKey columns are added by the string representation instead of its id number
• Hide columns to fill by offering default values
• Delete button in the UPDATE field

Requirements

All the requirements you should probably have anyway.

1. streamlit and sqlalchemy
2. Sqlalchemy models needs a str method
3. Id column should be called "id"
4. Relationships should be added for all ForeignKey columns

Basic Usage

Install the package using pip:

pip install streamlit_sql

Define a ModelOpts and add it to the argument of show_sql_ui function:

from streamlit_sql import ModelOpts, show_sql_ui

conn = st.connection("sql", url="<db_url>")

model_opts = ModelOpts(MyModel)
show_sql_ui(conn, model_opts)

Customize

You can configure the CRUD interface by giving optional arguments to the ModelOpts object. See its docstring for more information or at documentation webpage:

Multiple Models

You can set the model_opts argument to a list of ModelOpts objects. In this case, a st.selectbox will let user to select the table to work on.

Only create or update form

You can display just a create or update/delete form without the read interface using functions show_updade, and show_create.