![Miroslav Šedivý Miroslav Šedivý](/media//2018/11/21/miroslav_sedivy.jpg.180x180.jpg)
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.
Видео
Другие доклады
-
Aleksander Pavlov Modulbank
How to break your DBMS with arised-from-nothing high loads?
As any ordinary software developers, we just pursued a goal to develop a system robust for high loads, and even succeeded. The system architecture was fine, but the data volume was keeping increased and revealed the painful issues and errors that nobody had expected. We faced very strange queries seemed to be unbelievable. In my short talk I would like to share sad experience of arised-from-nothing high loads in DBMS and solving the challenge.
-
Alexander Fedorov dbeaver.comAndrey Hitrin RedSys
The Ultimate Tool: Xobot IDE
IIn the world of programming, the creation of source code for databases "procedural extensions" is something solitary. Most DBMS offers procedural languages and "stored procedures" to create procedural extensions. In Postgres the number of supported procedural languages has already exceeded a dozen.
Traditionally, stored procedures have many applications: it is difficult to resist the attraction to perform a data operation directly in the storage, especially in the Enterprise development. This approach quickly leads to the spreading of the business logic and dramatically increases the cost of support and development of the system as a whole.
The life cycle of stored procedures makes it difficult to use standard Change Management tools and practices. It is necessary to adapt the operations upon the stored procedures to the standards of Change Management, yet staying within the comfortable development practices.
We'll look at the typical tasks of the procedural extensions development and discuss the solutions we are implementing in the Xobot IDE.
-
Andrey Borodin Яндекс
Backups with WAL-G. What's new in 2019?
This talk will contain 3 parts: 1. Express PITR setup to the Cloud 2. Latest advancements in WAL-G for backups 3. Why you may need or should avoid this new features, depending on your specifications and workload.
-
Darafei Praliaskouski Juno
PostGIS for Disaster Management
PostGIS is spatial extension for PostgreSQL.
This talk will go in depth on using PostGIS for disaster management: which functions can be used and for what.