Python PG Extras VS sqllex

Compare Python PG Extras vs sqllex and see what are their differences.

Python PG Extras

Python PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more. (by pawurb)

sqllex

The most pythonic ORM (for SQLite and PostgreSQL). Seriously, try it out! (by v1a0)
Our great sponsors
  • Onboard AI - Learn any GitHub repo in 59 seconds
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • SaaSHub - Software Alternatives and Reviews
Python PG Extras sqllex
0 16
32 85
- -
0.0 0.0
over 1 year ago over 1 year ago
Python Python
MIT License GNU General Public License v3.0 only
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

Python PG Extras

Posts with mentions or reviews of Python PG Extras. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning Python PG Extras yet.
Tracking mentions began in Dec 2020.

sqllex

Posts with mentions or reviews of sqllex. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-03-13.
  • ORM for beginners | SQLite + sqllex
    2 projects | /r/Python | 13 Mar 2022
    P.S.:Here is few useful links: — Sqllex ORM (github page) — Sqllex docs — Project showcase — Another example #0 — Another example #1
  • Any alternatives to SQLAlchemy Core for a "query builder" library?
    2 projects | /r/Python | 19 Dec 2021
    FYI: If you're looking for something with more than one user, take a look at sqllex, which is a great query builder along the same lines. I made HissDB because sqllex didn't parameterize its queries, but I believe they've fixed that issue since then.
  • Sunday Daily Thread: What's everyone working on this week?
    2 projects | /r/Python | 22 May 2021
    Whole this week I working on my biggest project SQLLEX - it's python package for more comfortable interacting with databases. It got 7 new releases on this week (v0.1.8.5-0.1.5.12), 5 of which were about bug fixes. But two other were about major updates of code structure, adding new fetches and syntax sugar. Now you can just take your table as specific object or got column of table just by _getitem_ method:
  • SQLLEX | Better than sqlite3
    2 projects | /r/Python | 13 May 2021
    Github repo: https://github.com/v1a0/sqllex

What are some alternatives?

When comparing Python PG Extras and sqllex you can also consider the following projects:

psycopg2 - PostgreSQL database adapter for the Python programming language

queries - PostgreSQL database access simplified

txpostgres - Twisted wrapper for asynchronous PostgreSQL connections

asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio.

awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources

PyPika - PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

django-pgtrigger - Write Postgres triggers for your Django models

aiosqlite - asyncio bridge to the standard sqlite3 module

jaydebeapi - JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.

rgpocode - A Python script of a sqlite3 based reverse geocoder using postal codes

pangres - SQL upsert using pandas DataFrames for PostgreSQL, SQlite and MySQL with extra features

FrameRecorder - Imagine you are drawing pictures or writing a program on your computer. Wouldn't you like to shoot small clips of your work while doing this? That's when Frame Recorder comes to your aid. It will save it for you! See hours of process in just a few minutes!