brightonpgsql

An evening with Psycopg2

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:

News from the outer ring

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.

Meetup wrap up

This second meetup went very well. The audience was interested and we had fun time thanks to the beer and pizzas offered alongside with the venue by our sponsor brandwatch. Here a couple of pictures from the meetup. The recording worked much better than the previous time, here’s the presentation’s video. We’ll meet again shortly for a nice beer. Next technical talk will be probably in January.

Streaming replication at the brighton postgresql meetup

November 27th at 19.00 GMT I’ll talk at theBrighton PostgreSQL meetup. This time the group chosen the streaming replication as topic. The talk will cover the PostgreSQL write ahead logging and the crash recovery process. The audience will learn how to setup a standby server using the streaming replication and how to troubleshoot it. Please RSVP here.

The next meetup - PostgreSQL query planning

Like previously said, the next Brighton PostgreSQL meetup will be September 25th at 7 pm BST. The topic chosen by the member is the query planning and execution in PostgreSQL. I will do the presentation exploring the various steps a query passes through from the client to the execution. I’ll also explain how to read the execution plan and why sometimes the executor seems to ignore the indices put in place for speeding up the operations.

The sea elephants

Friday 14th August we kicked off the Brighton PostgreSQL Meetup. We had a nice evening with cool people all togheter discussing about PostgreSQL and how we can run effectively the meetup. We decided to have a regular monthly meetup hosted around Brighton, possibly, by companies or any suitable venue. The next meetup will be the 25th of September and this time there will be some PostgreSQL talks. The general interest favours the standby servers and the streaming replication.

Meet Marvin

There is just one day left and we’ll start the Brighton PostgreSQL Meetup. I invested some resources in this project like and I truly believe it can be a success. I still can’t believe that in just one month 25 people already have shown the interest on being part of the Brighton PostgreSQL Group. And today another nice suprise. I received the new shiny mascot for our group. He’s Marvin, the sea elephant.

Brighton PostgreSQL Meetup

After a while I finally started a PostgreSQL Meetup in Brighton. I reckon there are several people interested in PostgreSQL in the UK and I’ve met many of them in the Sussex area. I’m quite new to the Meetup platform so I still need to learn how to use it correctly. However, anybody is absolutely welcome to help to organise a PostgreSQL community in the area. The link is here. http://www.