RedCrowbar

14 ms·

151.
by RedCrowbar 10y ago
SQLAlchemy ORM is not async, so there is no way currently to use any async dialect for it. However, it is possible to write an SQLAlchemy Core adapter for asyncpg.
152.
by RedCrowbar 10y ago
> would be cool to also make jmh tests against jdbc and async pg on java. Pull requests to https://github.com/MagicStack/pgbench are welcome :-)
153.
by RedCrowbar 10y ago
We intentionally benchmarked simple queries to measure the overhead of the driver implementation. So, the 2x speedup really means 50% reduction in overhead.
154.
by RedCrowbar 10y ago
Yes, query arguments are converted automatically. Results are converted into Python types as expected (including arrays and composite types).
155.
by RedCrowbar 10y ago
> vacuuming is easier with InnoDB ... PostgreSQL needs to scan the whole table There's been quite a few improvements to VACUUM in 9.6 [1], including avoiding full-table scans. [1] https://www.postgresql.org/docs&#x2
156.
by RedCrowbar 10y ago
> This isn't a fair comparison. the "HTTP server" presented isn't doing any checks / validation that a typical web server does. How so? It uses a binding to http-parser, just like nodejs.
157.
by RedCrowbar 11y ago
> I recently noticed that I want something like a graph database for an application that screams for an SQL database, a strict schema and strict constraints. You may be interested in (soon to be released) EdgeDB: http://edgedb
158.
by RedCrowbar 11y ago
That lithium is rare is a common misconception. It is actually one of the more abundant elements on Earth, especially in seawater [1]. [1] https://en.wikipedia.org/wiki/Lithium#Terrestrial