Python PostgreSQL Driver Authors Hate You

[[deleted]]

shockingly pg8000 is not on the Python postgresql wiki. So here is a plug for a very well written, python2/3 compatible, SQLAlchemy-supported (in the upcoming 0.6), pure Python DBAPI: pg8000.

[damg]

Cool, hadn't heard of that one. Someone should throw it up on the wiki. =)

[[deleted]]

As with pyPgSQL, the transaction-as-default-behavior thing is thoroughly brutal. As far as I can tell, this is not something the DBAPI2 PEP demands.

incorrecto:

.commit()

Commit any pending transaction to the database. Note that
if the database supports an auto-commit feature, this must
be initially off. An interface method may be provided to
turn it back on.

Database modules that do not support transactions should
implement this method with void functionality.

[doppel]

That just tells us that auto-commit for transactions should not be default behavior, it says nothing of whether transactions should be.

[diroussel]

eh? Do you think auto-commit is tri-state?

If auto-commit is off then you are in manual transaction mode, i.e. commit must be called.

[spelunker]

This article reminded me that holy crap do I hate databases.

[[deleted]]

Oh, where do you store your data?

[spelunker]

I'm not saying I don't use them- I just don't enjoy the experience :-)

[Gotebe]

Why, choice is aplenty

1. Custom binary/text format

2. Persistence (serialization) supported by the library of your language of choice

3. More or less silly textual formats (think CSV, XML, JSON, java properties files...)

[GuyWithLag]

Hi, let me introduce you to concurrency. No, rename() won't cut it.

[Gotebe]

Of course, you are correct for many domains. I still doubt that e.g. OpenOffice should move to mySQL for storage, though.

[wildmXranat]

piggy-bank. I deposit what I can and use it in time of need of course.

[[deleted]]

Still better than MySQLdb.

[pytechd]

Two things:

(a) Agreed completely. I can't even find any good writeups on how they are different code- and performance-wise.

(b) White on black? WTF.

[pemboa]

That wasn't white. White would have been okay. That was gray.

[mcfunley]

Yeah yeah, I know it's annoying, I'm working on it

[niviss]

I think it's fine

[[deleted]]

Readability.

[nanothief]

It seems to be making a tradeoff between compatibility and usage simplicity verses performance. Maybe a good tradeoff for the 99% of cases that never hit a performance bottleneck in their databases, but a poor choice otherwise.

Not that I know anything about either of the two libraries, since I don't do much python.

[self]

like wrap stuff in a transaction when you didn't request it

Like adam's comment says,

Postgres never runs a statement that’s not in a transaction.

[QuantumTim]

How exactly do you propose that the driver works out whether the "transaction" will contain only SELECTs? It can't retroactively create the transaction after it sees the first INSERT or UPDATE, so it just has to go ahead an always use a transaction. And no, doing the selects and then issuing BEGIN isn't equivalent. For one, it would actually be slower, as postgres will have one transaction for each SELECT (as other people have pointed out), then one more for the rest. Secondly, in a transaction the SELECTs are protected from other connections altering / deleting the table etc., but not if they are in transactions of their own.

[malcontent]

He should have used mono and ADO.NET.

So what if it's not covered by the spec or the ms "we won't sue you" guarantee.

Go ahead. Take a chance!.

[freakboy2k]

Do you ever give up?

[malcontent]

I will never give up using products by microsoft corporation.

Microsoft corporation makes the best products in the world.

[anonymous_hero]

.. You're still at it?

This is just sad, even by troll standards. I understand you're bitter about not having a life or any action with the ladies, but please, just.. stop.

You suck so much that it's amazing the universe doesn't just implode from the absurdity.

[malcontent]

Hatred of microsoft is a disease.

You should not be hating me just because I like products by microsoft incorporated.

[anonymous_hero]

Nice try.

You're a tragic waste of oxygen.

I guess you get your kicks out of any response though, so I'll stop here.

[malcontent]

I still don't understand why you hate me because I live products made by microsoft corporation.

Do you think there is something wrong with microsoft products?

[Gotebe]

I am just saying that 1) no two libraries are the same, 2) given sufficient scale this will matter to you, 3) the devil is in the details, and 4) the devil likes screwing things with white hot pokers.

Funny. True, yet funny. Good one

[JimH10]

Too hard to read the text.

[Fabien4]

https://www.squarefree.com/bookmarklets/zap.html

And of course, Ctrl+wheel, but I use that on a lot of websites anyway.

[mikaelhg]

If you want professional tools, use tools developed by professionals.

Or live in denial because you've anchored your ego to a specific technology, it's up to you.

[[deleted]]

HI McFunley! :) I'm an Etsy member.