sqlfluff
streamlit
sqlfluff | streamlit | |
---|---|---|
35 | 262 | |
7,307 | 32,516 | |
0.8% | 2.5% | |
9.6 | 9.8 | |
1 day ago | 1 day ago | |
Python | Python | |
MIT License | Apache License 2.0 |
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.
sqlfluff
-
🐍🐍 23 issues to grow yourself as an exceptional open-source Python expert 🧑💻 🥇
Repo : https://github.com/sqlfluff/sqlfluff
-
SQL Reserved Words – The Empirical List
I'm surprised sqlfluff hasn't been mentioned yet. Perhaps not a comprehensive list, but it's worked for everything I've thrown at it. There's an ANSI keyword list [0], and then dialect-specific lists for everything from DB2 [1] to Snowflake [2].
[0]: https://github.com/sqlfluff/sqlfluff/blob/main/src/sqlfluff/...
-
Show HN: Postgres Language Server
It has tons of annoying quirks, but I couldn't imagine running a DBT project without it: https://github.com/sqlfluff/sqlfluff
-
Front page news headline scraping data engineering project
Move SQL queries to sql files and read from files (Use sqlfluff to lint the code https://github.com/sqlfluff/sqlfluff)
- Anything like SQLFluff written in Rust?
-
Code autoformatter for SQL in VSCode that plays nicely with dbt
SQLFluff is a good CLI tool for this and includes support for jinja and dbt. I don't think there's a VSCode plugin for it yet.
-
Ask HN: How do you test SQL?
This linter can really enforce some best practices https://github.com/sqlfluff/sqlfluff
A list of best practices:
-
What is something you would learn at college but not a bootcamp (hard skills)
BigQuery SQL and SQLFluff
-
Is the knowledge on how Compilers work applicable to the role of a Data Engineer?
There's a SQL parser/linter called SQLFluff that my team uses for our CI/CD. I've made a few pull requests to fix the parser for the particular SQL dialect we used, and my college compiler classes definitely helped.
-
sqlfluff VS ANTLR - a user suggested alternative
2 projects | 12 Dec 2022
streamlit
-
Developing a Generic Streamlit UI to Test Amazon Bedrock Agents
I decided to use Streamlit to build the UI as it is a popular and fitting choice. Streamlit is an open-source Python library used for building interactive web applications specially for AI and data applications. Since the application code is written only in Python, it is easy to learn and build with.
-
Creando Subtítulos Automáticos para Vídeos con Python, Faster-Whisper, FFmpeg, Streamlit, Pillow
Streamlit (https://streamlit.io/)
-
PySheets – Spreadsheet UI for Python
Does it need to be live (i.e when database or underlying spreadsheet updates does it need to be reflected in real time on the dashboard) or are you ok with static display.
Live updating data is a pain I've messed around using javascript to force refresh html iframes on a timer. But I was never really satisfied with this. I've heard you can do things with websockets but that is starting to get too complicated for me (I'm not a programmer).
For static stuff one of the data scientists in my org pointed me to Streamlit (https://streamlit.io/) it's a python package I found very easy to use. Can easily combine SQL with CSV imports and display them all on one dashboard. Can use forms toggle butotns etc to control the display.
-
Building an Email Assistant Application with Burr
Note that there are many tools that make this easier/simpler to prototype, including chainlit, streamlit, etc… The backend API we built is amenable to interacting with them as well.
-
Creating a Sales Analysis Application with Streamlit: A Practical Approach to Business Intelligence
2.-Go to https://streamlit.io, log in, and create a new app from your GitHub repository.
-
🦙 Llama-2-GGML-CSV-Chatbot 🤖
Developed using Langchain and Streamlit technologies for enhanced performance.
-
Python dev considering Electron vs. Kivy for desktop app UI
Hello,
Have you ever seen the https://streamlit.io/ ? I think this is what you are looking for.
-
Show HN: Buefy Web Components for Streamlit
While building dashboards in Streamlit, I found myself really missing Buefy's (Bulma) modern web components.
Specially due to the inability to add new values to Streamlit's multiselect [1], some missing controls like a polished image carousel [2] or a highly customizable data table.
Long story short, we put together streamfy (Streamlit + Buefy) as an MIT licensed project in GitHub to bring Buefy to Streamlit.
Demo: https://streamfy.streamlit.app
All the form components are implemented, missing half of other non-form UX components. There is plenty of room for PRs, testing, feedback, documentation, example, etc.
Please send issues and contributions to GitHub project [3] and general feedback to X / Twitter [4]
Thanks!
[1] https://github.com/streamlit/streamlit/issues/5348
-
Simplify Web App Development: Code Lite, Create Big!
Here's your savior, let's welcome Streamlit.
-
Show HN: Hyperdiv – Reactive, immediate-mode web UI framework for Python
Looks cool. How do you see this differing from streamlit? https://streamlit.io/
What are some alternatives?
vscode-sqlfluff - An extension to use the sqlfluff linter in vscode.
PyWebIO - Write interactive web app in script way.
sqlparse - A non-validating SQL parser module for Python
gradio - Build and share delightful machine learning apps, all in Python. 🌟 Star to support our work!
dbt-utils - Utility functions for dbt projects.
nicegui - Create web-based user interfaces with Python. The nice way.
ale - Check syntax in Vim/Neovim asynchronously and fix files, with Language Server Protocol (LSP) support
superset - Apache Superset is a Data Visualization and Data Exploration Platform
soda-sql - Data profiling, testing, and monitoring for SQL accessible data.
reflex - 🕸️ Web apps in pure Python 🐍
Metabase - The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
PySimpleGUI - Python GUIs for Humans! PySimpleGUI is the top-rated Python application development environment. Launched in 2018 and actively developed, maintained, and supported in 2024. Transforms tkinter, Qt, WxPython, and Remi into a simple, intuitive, and fun experience for both hobbyists and expert users.