|over 5 years ago||18 days ago|
|-||BSD 3-clause "New" or "Revised" 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.
We haven't tracked posts mentioning Pygments yet.
Tracking mentions began in Dec 2020.
Open Source SQL Parsers
17 projects | dev.to | 8 Oct 2021
Regular expressions is a popular approach to extract information from SQL statements. However, regular expressions quickly become too complex to handle common features like WITH, sub-queries, windows clauses, aliases and quotes. sqlparse is a popular python package that uses regular expressions to parse SQL.
Automated SQL formatting checks
2 projects | reddit.com/r/dataengineering | 27 Sep 2021
This one is not bad: https://github.com/andialbrecht/sqlparse.
Let's write a compiler, part 5: A code generator
14 projects | news.ycombinator.com | 19 Aug 2021
1 project | reddit.com/r/bigquery | 7 May 2021
We used this repo for this: https://github.com/andialbrecht/sqlparse. I may have miscommunicated. We didn't write the parser from scratch, we created a way for the parser to detect downstream and upstream dependencies of the resource.
What are some alternatives?
pyparsing - Python library for creating PEG parsers [Moved to: https://github.com/pyparsing/pyparsing]
PLY - Python Lex-Yacc
Lark - Lark is a parsing toolkit for Python, built with a focus on ergonomics, performance and modularity.
pydantic - Data parsing and validation using Python type hints
kotlin-latex-listing - A syntax highlighting template for the Kotlin language in LaTeX listings.
jellyfish - 🎐 a python library for doing approximate and phonetic matching of strings.
Rouge - A pure Ruby code highlighter that is compatible with Pygments
python-user-agents - A Python library that provides an easy way to identify devices like mobile phones, tablets and their capabilities by parsing (browser) user agent strings.