The next meetup at Brighton will be Friday 14th October at 19.30.
Daniele Varrazzo will kindly talk about the most popular PostgreSQL driver in the python universe.
Psycopg is the most used PostgreSQL driver for the Python programming language.
As a driver it stays at a relatively low level, allowing to use all the features offered by the database. Behind the scenes, it does its best to convert the rich Python data model into the likewise rich PostgreSQL data model:
Back in the 2013 I started playing with sqlalchemy to create a simple extractor from heterogeneous systems to be pushed in postgresql.
I decided to give the project a name which recalled the transformation and I called pg_chameleon.
To be honest I didn’t like sqlalchemy. Like any other ORM adds an interface to the data layer with a mental approach to the data itself. I lost the interest to developing a migrator very soon, and after all there are thousands of similar tools thousands of times better than mine (e.
After the summer break the Brighton PostgreSQL meetup restarts with the monthly technical talks.
This time is my round again. I’ll speak on how to scale the backup and recovery on large postgres installations.
Actually this is the talk I’ve submitted to the european pgconf.
I made the talk in a storytelling form in order to avoid to bore the audience to the death. The talk should be quite entertaining with explanation of the issues solved by the DBA over the years.
Thanks to the Ferrara’s University, departement of Engineering I’ll attend to another evening with PostgreSQL.
This time the event will be a seminary with all talks made by me.
The first talk will cover our beloved elephant’s history.
The second talk will look to the engine with particular attention to the MVCC and the memory manager.
The final talk will cover thebackup and recovery with pgdump and the streaming replication.
I’ve been busy recently and I failed to update on the last meetup news.
I apologise for that.
We had a very interesting meetup in January.
Alexey Bashtanov explained how the grouping works in postgres and how to improve or even re implement in C the grouping functions.
On the meetup page there are the pictures from the meeting.
The presentation’s recording is available thereand the slides are free to download on slideshare there.
