It's PGDay UK tomorrow, and I'll be speaking on connecting to PostgreSQL with Python. See you there if you're going!
read more-
-
ODFIO
-
Mobile Usability Issue On MtrHub II
This is just a follow-up to a previous post: Mobile Usability Issue On MtrHub. It seems that Google Webmaster tools doesn't like the fact that on a mobile browser the table on the front page was too wide. Webmaster tools was quite right, so I've reduced it by a couple …
read more -
Mobile Usability Issue On MtrHub
Well, here I am at the Meanbee Hack Night, and I'm planning on working on MtrHub. Google Webmaster Tools flagged up a 'mobile usability issue', so that's what I've got to fix. First thing is to get everything working on my laptop...
Btw, since upgrading to Ubuntu 15.04, git …
read more -
SQLAlchemy tests hang with pg8000 1.10.2
Before doing a new release of pg8000 I generally run the full suite of SQLAlchemy tests (as well as pg8000's own test suite). This time with pg8000 1.10.2 I found that the tests hung at:
test/dialect/test_oracle.py::CompatFlagsTest::test_ora8_flags PASSED
doing CTRL-C let the tests carry …
read more -
Timeout with socket.makefile()
The question was asked, 'without a socket timeout in pg8000, how can we tell if there's been a network failure or similar problem?'.
The reason the socket timeout was removed was this sentence in the docs for socket.makefile():
read moreThe socket must be in blocking mode (it can not have …
-
pg8000: database name encoding
-
Markup
I wrote a tutorial on propositional logic a couple of weeks ago. I wrote it out on paper, and now comes the task of putting it online. I wanted to write one document and from that produce a website and an EPUB book. My first thought was LaTeX, and I …
read more -
The Wheel Format
Actually, the False Lead kind of led to something in the end. When pg8000 established a connection, messages end in either a READY_FOR_QUERY or a ERROR_RESPONSE, whereas in the query phase, messages only ever end with a READY_FOR_QUERY. So I've separated out the two bits of code, and each is …
read more -
A False Lead
There are a couple of bugs with pg8000 that I've been unable to reproduce, after trying quite hard for some time. The other day I had a flash of inspiration that it could be caused by not closing the connection when there's a timeout on reading a response from the …
read more