pspg
sqlfluff
pspg | sqlfluff | |
---|---|---|
13 | 35 | |
2,375 | 7,219 | |
- | 1.2% | |
7.8 | 9.6 | |
12 days ago | 7 days ago | |
C | Python | |
BSD 2-clause "Simplified" License | 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.
pspg
-
Harlequin: SQL IDE for Your Terminal
pspg is a pager intended to be used with SQL command line clients. It was originally created for Postgres (hence the name), but also works with MySQL and others
https://github.com/okbob/pspg
- Pspg: Unix pager designed for work with tables
-
Show HN: Postgres Language Server
> I am regularly surprised how bad the tooling is for SQL/databases.
This. I'd really like to have a working SQL pretty printer/formatter. Psql is great, but lacks autocompletion in several places.
That said, a big shoutout to pspg (https://github.com/okbob/pspg) - an excellent pager for psql (also for general csvs).
- Pspg – Postgres Pager[video]
- PostgreSQL and Tabular Data Pager
- Show HN: Ov – feature rich terminal pager
-
pspg VS ov - a user suggested alternative
2 projects | 25 Jun 2022
-
Charm 0.1: a data-oriented scripting language
Possibly the best pager for tabular data out there is https://github.com/okbob/pspg ; it accepts generic inputs so results can be piped via shell command.
-
how to use pspg
I am trying to use: https://github.com/okbob/pspg
- Pspg – Postgres Pager
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
What are some alternatives?
pgquarrel - pgquarrel compares PostgreSQL database schemas (DDL)
vscode-sqlfluff - An extension to use the sqlfluff linter in vscode.
mandown - man-page inspired Markdown viewer
sqlparse - A non-validating SQL parser module for Python
postgres_lsp - A Language Server for Postgres
dbt-utils - Utility functions for dbt projects.
mdviewer - Rendered display of markdown on terminal
ale - Check syntax in Vim/Neovim asynchronously and fix files, with Language Server Protocol (LSP) support
ncda - Ncurses disk usage analyzer
soda-sql - Data profiling, testing, and monitoring for SQL accessible data.
moar - Moar is a pager. It's designed to just do the right thing without any configuration.
Metabase - The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum: