title

text

Yury Zhukovets
Yury Zhukovets ЗАО Дилжитал-Дизайн
10:00 17 March
45 мин

Migrating DocsVision EDMS from MS SQL to Postgres

This talk is about migrating an electronic document management system from MS SQL to PostgreSQL 9.5 or higher as part of the import phaseout initiative. We will touch upon architecture specifics, as well as describe the problems we encountered when migrating T-SQL code to pgsql, and how we resolved them.

Learn more at https://pgconf.ru/news/94168

VIDEO

Материалы к докладу

Слайды

Другие доклады

  • Philip Delgyado
    Philip Delgyado ООО «Лектон»
    22 мин

    Distributed workflow specifics in PostrgeSQL

    When working with a complex business logic, you often have to implement a workflow - a sequence of several processing steps, with each step implementing a separate part of the business logic. This is usually done with specialized queues, but if there are high reliability demands, it makes sense to do everything on PostgreSQL.

    I will describe the tasks that require a workflow implementation, offer a solution, compare it with other options, and tell you about the implementation traps and pitfalls.

  • Dmitry  Lebedev
    Dmitry Lebedev BestPlace
    90 мин

    Researching GIS data with PostGIS and adjacent toolset

    Nowadays one can make a decent urban research based simply on public datasets, making interesting and unexpected insights. In the presentation, I'll show examples of these calculations in PostGIS, the industry standard de-facto.

    But just PostGIS is not enough. You need tools to import, verify and visualize the data. It's critically important to visualize the data live, to debug your calculations and shorten iterations. I'll describe all these steps:

    1. Collecting the data: public API, OpenStreetMap; direct user input.
    2. 3rd party APIs for calculations.
    3. Visualization of GIS and other sorts of data: QGIS, Matplotlib, Zeppelin integrated with PostGIS.
    4. Debugging the calculations: live visualization (Arc, QGIS, NextGIS Web)
    5. Scripting and minimizing the chores: Makefile, Gulp

  • Darafei Praliaskouski
    Darafei Praliaskouski Juno
    45 мин

    PostGIS for moving targets

    PostGIS enables spatial processing in Postgres. Usually PostGIS is used for planar euclidean calculations, but real world adds time, ambiguity and uncertainty. We'll have a look on making a thousand of cars move smoothly in real time on OpenStreetMap base map.

    VIDEO

  • Dmitry Beloborodov
    Dmitry Beloborodov UIS, CoMagic
    45 мин

    Using PostgreSQL in UIS, CoMagic Projects

    Using PostgreSQL since 2003, we went all the way from a database of a couple of GB to a cluster of more than 5TB. At the moment, we have more than 700 tables and about 1500 stored procedures. We are ready to share with you the following: - Problems encountered at different development stages and how we resolved them. - Best practices in database administration. - Our own extension to work with several closely related databases. - Best known methods and tools that enable our several teams to work together without interference. - How we set up test equipment of different types. And, of course, we'll talk about optimization, and how we identify bottlenecks and high-load use cases.

    VIDEO