django-sql-dashboard
dash
django-sql-dashboard | dash | |
---|---|---|
8 | 56 | |
431 | 20,502 | |
- | 0.7% | |
4.4 | 9.6 | |
about 2 months ago | 7 days ago | |
Python | Python | |
Apache License 2.0 | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
django-sql-dashboard
-
Datasette is my data hammer
I have a sister project to Datasette called Django SQL Dashboard which works against PostgreSQL databases: https://django-sql-dashboard.datasette.io
It used Django for the authentication layer but can otherwise work against any PostgreSQL database.
I partly built it to help explore what Datasette could look like if it expanded to work with more databases than SQLite. That's still something I'm considering doing in the future, via a plugin hook, but it's not on my short-term roadmap.
- How do you log all API calls in your application?
- Saving Filtered Querysets for Future Access
-
Do I need to create seperate app for a dashboard?
Reusable apps do exist (I released one myself a few months ago, https://django-sql-dashboard.datasette.io) but in most projects apps are single-use only - at which point they become little more than a code organization tool.
-
Why is uncoupled documentation bad?
I use documentation systems that publish the documentation from the repo to a website. Most of my projects use Sphinx and reStructuredText for this, but I recently tried MyST (Markdown for Sphinx) and I like that a lot.
Some examples:
- https://docs.datasette.io serves documentation from https://github.com/simonw/datasette - which has documentation unit tests here: https://github.com/simonw/datasette
- https://django-sql-dashboard.datasette.io/ serves from markdown in https://github.com/simonw/django-sql-dashboard - I don't have documentation unit tests for that yet
-
Dataflow, a self-hosted Observable Notebook Editor
Weirdly my Django SQL Dashboard project fits the bill a bit here: you can build up a "dashboard" (which is a tiny bit notebook-like if you squint at it the right way) with multiple SQL queries on it, and save that either as a bookmark or as a "saved dashboard" with a URL.
https://django-sql-dashboard.datasette.io/
In my own work I've been using it for the kind of things that I would normally use a Jupyter notebook for - gathering together research on problems I'm trying to solve.
-
Show HN: Django SQL Dashboard
It's hand-written CSS - there's not much of it: https://github.com/simonw/django-sql-dashboard/tree/01bb7e60...
-
Data Analysis with Django
I've been building a tool for this over the past couple of months called Django SQL Dashboard - it currently only works with PostgreSQL and you need to create a read-only database connection, but it then provides an interface for executing any bookmarking SQL queries plus some basic visualizations: https://github.com/simonw/django-sql-dashboard
dash
-
dash VS solara - a user suggested alternative
2 projects | 13 Oct 2023
-
[Python] NiceGUI: Lassen Sie jeden Browser das Frontend für Ihren Python-Code sein
Of course there are valid use cases for splitting frontend and backend technologies. NiceGUI is for those who don’t want to leave the Python ecosystem and like to reap the benefits of having all code in one place. There are other options like Streamlit, Dash, Anvil, JustPy, and Pynecone. But we initially created NiceGUI to easily handle the state of external hardware like LEDs, motors, and cameras. Additionally, we wanted to offer a gentle learning curve while still providing the ability to go all the way down to HTML, CSS, and JavaScript if needed.
- Visualizing parquet in s3 bucket for data analysis?
-
Little guidance of a python newbie
You could use something like Streamlit or Dash. In any case you will be accessing your app through the browser.
-
Launch HN: Pynecone (YC W23) – Web Apps in Pure Python
Useful list. Dash & bokeh as two more in the space
https://github.com/plotly/dash
-
Python projects with best practices on Github?
I also heard of Dash which serves the same purpose I guess, but I think it has more to offer.
-
4 Streamlit Alternatives for Building Python Data Apps
Plotly is a plotting library, and Dash is their open-source framework for building data apps with Python, R or Julia. (Dash also has an Enterprise version, but we'll focus on the open-source library here.)
-
NiceGUI: Let any browser be the frontend for your Python code
Of course there are valid use cases for splitting frontend and backend technologies. NiceGUI is for those who don’t want to leave the Python ecosystem and like to reap the benefits of having all code in one place. There are other options like Streamlit, Dash, Anvil, JustPy, and Pynecone. But we initially created NiceGUI to easily handle the state of external hardware like LEDs, motors, and cameras. Additionally, we wanted to offer a gentle learning curve while still providing the ability to go all the way down to HTML, CSS, and JavaScript if needed.
-
Sharing interactive Plotly graphs
looks like you can get it manually (albeit with a loss of interactivity) https://github.com/plotly/dash/issues/145
-
Containerizing Shiny for Python and Shinylive Applications
Shiny is a framework that makes it easy to build interactive web applications. Shiny was introduced 10 years ago as an R package. In his 10th anniversary keynote speech, Joe Cheng announced Shiny for Python at the 2022 RStudio Conference. Python programmers can now try out Shiny to create interactive data-driven web applications. Shiny comes as an alternative to other frameworks, like Dash, or Streamlit.
What are some alternatives?
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
streamlit - Streamlit — A faster way to build and share data apps.
scripts-to-rule-them-all - Set of boilerplate scripts describing the normalized script pattern that GitHub uses in its projects.
fastapi - FastAPI framework, high performance, easy to learn, fast to code, ready for production
Docusaurus - Easy to maintain open source documentation websites.
panel - Panel: The powerful data exploration & web app framework for Python
django-sql-explorer - Easily share data across your company via SQL queries. From Grove Collab.
uvicorn - An ASGI web server, for Python. 🦄
papermill - 📚 Parameterize, execute, and analyze notebooks
Flask - The Python micro framework for building web applications.
govuk-form-builder - A form builder for Ruby on Rails that’s compatible with the GOV.UK Design System.
nicegui - Create web-based user interfaces with Python. The nice way.