tldr; you can do jobs, queues, real time change feeds, time series, object store, document store, full text search with PostgreSQL. How to, pros/cons, rough performance and complexity levels are all discussed. Many sources and relevant documentation is linked to.
Your database is first. But can PostgreSQL be second?
Web/app projects these days often have many distributed parts. It's not uncommon for groups to use the right tool for the job. The right tools are often something like the choice below. Redis for queuing, and caching.Elastic Search for searching, and log stash.Influxdb or RRD for timeseries.S3 for an object store.PostgreSQL for relational data with constraints, and validation via schemas.Celery for job queues.Kafka for a buffer of queues or stream processing.Exception logging with PostgreSQL (perhaps using Sentry)KDB for low latency analytics on your column oriented data.Mongo/ZODB for storing documents JSON (or mangodb for /dev/null replacement) SQLite for embedded. Ne…
So, it's been about 9 days since I had "a fun day working on pygame stuff". That morning I woke up, and just started working on pygame things. This is a pattern with me between big freelance contracts. Last year I spent some months on pygame stuff, and also the year before that some months.
It was such a fun day... I just kept going. And here we are 9 days later with a web log of some of the things that happened.
New pygame.org website changes.
a new version of the pygame website out. It took a couple of days, but I
fixed a number of issues, and improved a few things. In the process I
found a lot more issues on the website than I fixed. So there are now more issues listed than when I started. Feels like progress.
to me... it's already usable. That is pygame (same one that runs on
cpython), works on pypy through its C extension API. pypy has good
support for the CPython API (through a recompile) now. PyPy is the python language with a fast JIT, so your code can approach C speeds. And in some cases it can be faster than C.
an issue with events stopping keyboard/mouse/etc from working. Lots of
details in this issue describing the changes needed, so I hope other
extensions encountering this will find it useful. https://github.com/pygame/pygame/issues/419
But now that's fixed, every pygame app I tried on it has worked.
Why is this exciting?
This is exciting to me because: pure python code being fast on pypy(after warmup), also mixed with the fast bits in C/asm.cpyext is getting faster in pypy. There is already work and discussion toward…