pg8000

pg8000 [1] is a Postgres library implemented in pure Python. I've spent enough time trying to get psycopg installed on MacOS and Docker that I appreciate just being able to pip install it at any time. [1] https://github.com/tlocke/pg8000

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 (though also often at the expense of performance and maybe correctness) 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]. I don't mean that the author should or shouldn't do whatever they want. I just wouldn't use the term "pure" here or even say this is an engine written in Python since a large chunk of it is not written in Python. That doesn't mean this is not a cool project. It's a cool project! [0] https://github.com/tlocke/pg8000 [1] https://www.reddit.com/r/learnpython/comments/nktut1/eli5_th...

Hello, maintainer of the pg8000 driver for PostgreSQL here. I'm keen to know of any problems you had if you used pg8000. Thanks! https://github.com/tlocke/pg8000

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.

This is true. I'm the maintainer of pg8000, a Python driver for PostgreSQL. Here are the docs for how you'd do this using pg8000: https://github.com/tlocke/pg8000#copy-from-and-to-a-file The standard API for database access in Python is DB-API 2 and it doesn't include support for COPY , so each driver may implement it differently. There's another aspect to this, and that's the format of the file to be ingested as it can be 'text', 'CSV' or 'binary'. If you're generating the file yourself then you have a choice, but whether 'binary' is faster than 'CSV' I just don't know.

> Seriously. What's the point of open source if companies just steal it, build billion dollar industries on top, and then lock everything down? I work on pg8000 https://github.com/tlocke/pg8000 which is used by Amazon, Google etc. I'd argue that pg8000 and any Open Source software doesn't give them a competitive advantage, because in order to have a competitive advantage you have to have something that your competitors don't have. It's more that they'd be at a competitive disadvantage if they didn't use Open Source software. That's not to say there aren't problems with the big tech companies, but I'd say that Open Source isn't where the problems lie. In my view the problems stem from the nature of the web, in that it is a centralized architecture that inevitably concentrates power. Something like IPFS https://ipfs.io would help liberate t