What is PgConf.Russia 2019?
PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 500 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. The 3-day program includes training workshops presented by leading PostgreSQL experts, more than 40 talks, panel discussions and a lightning talk session.
- PostgreSQL DBAs
- PostgreSQL core and extension developers
- Application developers
- System architects
- Database migration engineers and managers.
- PostgreSQL at the cutting edge of technology: big data, internet of things, blockchain
- New features in PostgreSQL and around: PostgreSQL ecosystem development
- PostgreSQL in business software applications: system architecture, migration issues and operating experience
- Integration of PostgreSQL to 1C, GIS and other software application systems.
minutes of networking
Python and PostgreSQL Using psycopg2
Python may not be the fastest programming language on the CPU, but its fast and easy development saves a lot of costs between the keyboard and the chair. In this workshop we'll explore the most popular library for the access to the PostgreSQL server named "psycopg2" and write a short application using some of its useful features.
Bitemporality: Tracking Reproducible Revisions in PostgreSQL Using RANGE Types
So you finally have your database model for your application and you fill it in with current data. How do you keep it up to date? While INSERT may still be transparent, UPDATE and DELETE will overwrite your previous data, so you won't be able to reproduce them. Cloning the whole huge content for each minor update is not an option. For rich and complex data about hundreds of thousands of power generators in Germany and worldwide, I built a model using range data types in recent PostgreSQL which allows me to insert, update and delete data while granting the full access to the whole state of the database at any historical moment. I'll present a very simplified version of the database so the audience will be immediately able to apply it for their cases. I'll also show a few tricks in Python and Psycopg2 that will allow a whole team to prepare, review, and deploy all revisions to this database without merge conflicts. And I'll give a few ideas on how to retrieve this data efficiently.
Program All talks
Faculty of Economics, Moscow, Russia, 1-46 Leninskiye Gory
Get our latest news!
Subscribe to our news
Conferences like this give people a personal feeling for the software. You can understand why people are passioned about it. They get confidence in using it and confidence that the software is gonna be around for a long time. The conference has people who is responsible for and designing Postgres. And I really think it excites to continue using Postgres.
This is a very technically oriented conference. There is a lot of knowledge sharing happening. A lot of really talented people. And it is also for us a great opportunity to tap into the Russian market, a very interesting market for Postgres.