use Postgres.py under the hood

[kennethreitz]

use Postgres.py under the hood

[chadwhitacre]

(Twitter context)

[kennethreitz]

Honestly, my immediate reaction is "I'm not sure", leaning towards "no".

1. Little/No Benefit: Records, as it stands, is a very thin layer on top of psycopg2, which, for the feature set that Records currently provides, is a perfect fit. In other words, I don't think moving to something else would provide any benefit at this time.

2. Other Databases: Also, there has been some consideration for adding support for other database backends. If we were to do this, it would likely be in the form of using SQLAlchemy as a database driver. So, relying on another Postgres library would take a step away towards that (currently non–) goal.

3. Too Early: That being said, at the moment, I'm deciding to stick with Postgres-only support (mostly because of very subtle differences in the way querys can be expressed in SQLAlchemy). I'm reconsidering it constantly, though, so this is further reason to not make any big dependency commitments at this time.

[kennethreitz]

Just pushed the release built on top of SQLAlchemy :D

[chadwhitacre]

Alright. Good luck! :-)

[kennethreitz]

@whit537 😭

[chadwhitacre]

No worries. I think you just made DB-API 3.0, and I like it. :-)

[chadwhitacre]

P.S. I would be remiss not to note that @3kwa ported the basic API from Postgres.py for other databases in https://github.com/3kwa/sql.

[3kwa]

@kennethreitz must be a better brand in the Python sphere. Thought of you @whit537 when I saw records pop all over the place.

[chadwhitacre]

:-)

[kennethreitz]

I'm the Kanye West of Python.

(That's my Kanye impersonation)

[kennethreitz]

Well, we're much less in competition now that Records is powered by SQLAlchemy. So, the sky's the limit!

[chadwhitacre]

Well, we're much less in competition now that Records is powered by SQLAlchemy.

Mmmm ... over here it feels like we're much less in competition because Records has already nuked Postgres.py and sql out of the water in terms of open-source mindshare.

I'm not gonna say that doesn't burn a little bit, but branding and community matter at least as much as code, and you're purty good at all three. 😸 At the end of the day what really matters is that the Python community is finally getting a sane SQL API. 🍻

[kennethreitz]

^L

[3kwa]

Wow does that mean sql is 1st in watch, star and fork 💃

[chadwhitacre]

Wow does that mean sql is 1st in watch, star and fork 💃

Hah! You're the best around! 💃

^L

Yeah, I finally ate crow on Aspen recently as well. Over there I never got the code to the level of polish I wanted, but I was actually really proud of Postgres.py. It was well-designed, well-documented, well-tested, ported to Python 3 ... tight!

[chadwhitacre]

Hey! Here's another one called Queries from @gmr. I found it on http://awesome-python.com/ after googling for "postgres python for humans."

Queries is inspired by Kenneth Reitz's awesome work on requests.

Looks like it's older than Postgres.py (initial commit on Queries is August 24, 2012, based on prior work; initial commit on Postgres.py is from Aug 7, 2013, based on internal Gittipay code going back to at least June 1, 2012).

@gmr Looks like you came in second! Or third, depending on how we're counting it. ;-)

[chadwhitacre]

vinta/awesome-python#567 ← Postgres.py
vinta/awesome-python#568 ← sql
vinta/awesome-python#569 ← Records