sqlfluff
streamlit
Our great sponsors
sqlfluff | streamlit | |
---|---|---|
35 | 254 | |
7,199 | 31,506 | |
2.1% | 3.6% | |
9.6 | 9.8 | |
5 days ago | 5 days 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
-
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/
-
Revolutionizing Real-Time Alerts with AI, NATs and Streamlit
Imagine you have an AI-powered personal alerting chat assistant that interacts using up-to-date data. Whether it's a big move in the stock market that affects your investments, any significant change on your shared SharePoint documents, or discounts on Amazon you were waiting for, the application is designed to keep you informed and alert you about any significant changes based on the criteria you set in advance using your natural language. In this post, we will learn how to build a full-stack event-driven weather alert chat application in Python using pretty cool tools: Streamlit, NATS, and OpenAI. The app can collect real-time weather information, understand your criteria for alerts using AI, and deliver these alerts to the user interface.
-
Using LangServe to build REST APIs for LangChain Applications
In this tutorial, you'll construct a fully functional Streamlit application from the ground up. Streamlit lets you turn simple data scripts into web applications without traditional front-end tools. This application will be capable of downloading audio from any YouTube video, transcribing it using Deepgram, and then summarizing the content with the assistance of Mistral 7B, all streamlined through the capabilities of Langchain.
- Ask HN: Can I create a mobile and Web App using Python/Python Framework?
-
Creating Videos with Stable Video Diffusion
Install the Stable Diffusion tools and checkpoints, and run it all with Streamlit.
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.