Solara for data manipulation application?
Hi, I am a python newbie, and want to build a python application on a postgres database. Is Solara suited for a data manipulation application? Or is it more data science dashboards and visualizations?
My application will basically be screens with a lot of information, and when you click on a piece of information you can update this in a pop-up. I would also like to add new projects in a wizard style series of forms. Plus I would like a tree navigation item based on a database view. Is all this possible in Solara?
My second question is: as I try to figure out my stack I stumble across Django a lot. It seems that Django can provide a nice layer for the postgres tables. Can Solara do that as well? Do I need Django at all?
Thanx for your time!
Thanx for your time!
4 Replies
I think all of this is possible with Solara, if Solara doesn't provide the components you need, you can always fall back to the underlying library (ipyvuetify, which are bindings to vuetify) to make what you need.
We don't do any layering of postgres, I would recommend to take a look at sqlalchemy.
Thanx! Will take a look at it. So no need for Django? How does Django compare to Solara?
django is more a backend only framework, like fastapi and flask. Solara runs on top of that, and also provides a frontend. Note that we don't support running on top of django yet
Hi,
How is your project going? I am interested in doing something similar (reading database information, displaying it, and allowing users to write it through input components).
As a newbie, I have ChatGPT supporting me. It suggested the following logic: functions with pre-written queries that are formatted after the user inputs something. The functions are called on value change/button click. It works well for reading tables and displaying them in dataframes (and using a search bar as a filter) as well as writing new lines in a table. However, modifying existing data is more challenging.