pg8000
sqlparser-rs
pg8000 | sqlparser-rs | |
---|---|---|
5 | 12 | |
467 | 2,443 | |
- | 2.4% | |
7.4 | 9.3 | |
7 days ago | 3 days ago | |
Python | Rust | |
BSD 3-clause "New" or "Revised" 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.
pg8000
-
How to run psycogp2 in Aws lambda?
As others have said you can use a custom compiled version of the lib, lambda layer or use lambda images, however, if you're not committed to psycogp2 I've found pg8000 a much easier library to work with in Lambda. You can just install it as any other library without any problems.
-
Pure Python Distributed SQL Engine
When people say "pure X", to me, it normally means they didn't involve an FFI or external compiler. This is an often beneficial thing since it simplifies your build process.
For example, here [0] is a "pure Python postgres driver" and the implication is that it doesn't use libpg.
Or see also this discussion [1].
[0] https://github.com/tlocke/pg8000
[1] https://www.reddit.com/r/learnpython/comments/nktut1/eli5_th...
-
FAQs: Why we don’t have them (2013)
I agree that information shouldn't be duplicated, but in one of my projects I've taken the opposite approach and made the FAQ the only place that certain information is presented. It's for the library https://github.com/tlocke/pg8000 and I've called them 'Examples' rather than a FAQ, but each time I get a question that isn't covered by the examples I add in a new example. I'd be interested to hear what people think of this approach.
- Pg8000 – Pure-Python PostgreSQL driver
sqlparser-rs
-
Introducing SQLPage : write websites entirely in SQL
sqlparser to parse SQL queries and detect variable bindings
-
Understanding the SQL AST and what can be done with it
So to start with this, I looked into SQL parsing and found this library https://github.com/sqlparser-rs/sqlparser-rs
-
Supabase Logs: open source logging server
We switched to an open source alternative, the rust-based sqlparser-rs library, contributing a few updates for the BigQuery dialect.
- Parsing SQL with Rust
-
Writing a SQL LS in Rust - Looking for Coding Companions.
I have experience with sqlparser-rs (for my sqlpage project), but it does not track the source code location of the parsed data structures (yet).
-
Pure Python Distributed SQL Engine
It uses https://github.com/sqlparser-rs/sqlparser-rs as the parser and lexer. The binder, planner, optimizer and executor are in Python. The optimizer stage only works on the logical plan and the rules are heuristic only.
-
Parsing / Recursive Descent Parser
That code could be copied directly from some real-world examples - sqlparser-rs code looks pretty much exactly the same.
https://github.com/sqlparser-rs/sqlparser-rs
-
RisingLight is an OLAP database system for educational purpose
Also neat to find the SQL parser library they use.
- We Went All in on Sqlc/Pgx for Postgres and Go
- “Swift is the only language I could find with over 100 keywords”
What are some alternatives?
Django - The Web framework for perfectionists with deadlines.
sled - the champagne of beta embedded databases
sqlglot - Python SQL Parser and Transpiler
goyesql - Parse SQL files with multiple named queries and automatically prepare and scan them into structs.
opteryx - 🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.
sqlite
TheAlgorithms - All Algorithms implemented in Python
kube - Rust Kubernetes client and controller runtime
quokka - Making data lake work for time series
prettytable-rs - A rust library to print aligned and formatted tables
system-design-primer - Learn how to design large-scale systems. Prep for the system design interview. Includes Anki flashcards.
go - The Go programming language