PostgreSQL Quickstart

DMBS in the modern project has a strong influence on architecture and NFR (non-functional requirements). Many people faced the task of choosing DMBS for the new project, for example, Konstantin has received a huge number of requests to select a DMBS. It's good to have some checklist, knowledge about candidate and idea of the scope of work.

As part of this talk Konstantin will review the current status of PostgreSQL, infrastructure, approaches, and practices:

• he will share the best examples of business logic and PostgreSQL (code versioning, deploy, tests, coverage) development;
• will demonstrate the examples of the implementation of different architectural patterns that his colleagues used in Avito;
• will review the infrastructure and finished tools;
• will look into the maproad and make an overview of future improvements.

Targeted audience are not experts in this topic. The purpose is to explain the variety of features and directions for further use of PostgreSQL.

Konstantin Evteev

DBA Unit Leader at Avito (Avito.ru) Konstantin's career with PostgreSQL (PostgreSQL 7.4) began at the Tula branch office "Research Institute of Reprography" (www.reprograf.ru) in position of Senior Programming Specialist in 2009. In 2013 Konstantin joined the Ingate team in position: The developer of the department of system architecture, Database specialist — to migrate the existing projects from Microsoft SQL Server to PostgreSQL, set up database backup, provide fault tolerance, and as a DBA specialist to maintain projects working on Microsoft SQL Server 2008r2/2012 servers. In 2014 Konstantin comes to Avito, the biggest classified site of Russia, and the second largest classified site in the world (after Craigslist of USA). Konstantin is leading the database development team, is in charge of the development of the architecture in the context of databases and training and consulting for developers to work with PostgreSQL.

Konstantin Evteev PostgreSQL Russia