[TIP] (announcing) pg13, an in-process SQL database for mocking
Abe Winter
awinter.public at gmail.com
Thu Apr 2 18:32:04 PDT 2015
Hi,
I'm presenting pg13, a new python library for SQL mocking. It's fast
enough to create a new pure-python, in-memory DB for each test. It's
not complete or mature but supports enough of the basics to get good
coverage on a simple app.
Performance is around ~200 tests per second on my hardware. This is vs
1 test per second if you're creating a postgres DB per test;
in-process also parallelizes more easily. Sqlite on :memory: can be
quick but sqlite is not feature-compatible other SQL engines and is
hard to modify (90k lines of C). pg13's whole SQL engine is under 1000
lines, pure python, and easy to extend.
More here:
https://github.com/abe-winter/pg13-py
Thanks,
Abe Winter
More information about the testing-in-python
mailing list