![Yury Zhukovets Yury Zhukovets](/media//2017/01/30/YuriyZhukovets_120pro2.png.180x180.jpg)
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
Слайды
Другие доклады
-
Alvaro Hernandez 8Kdata
PostgreSQL & Java Tutorial
Java is one of the most used languages when programming with PostgreSQL databases. Join this tutorial to learn or review the techniques to connect to postgres, best programming practices with JDBC, and to explore jOOQ, a mapper software that allows you to use the full power of SQL and postgres advanced query features while avoiding all the boilerplate code.
This tutorial is very practical: most of the time will be dedicated to iterate through code samples. It will cover:
- Introduction to Java and PostgreSQL
- Ways of connecting to PostgreSQL from Java (not only JDBC!)
- Introduction to JDBC. JDBC types. PostgreSQL JDBC
- Code demo: JDBC with PostgreSQL. From Java 1.4 to Java 8, best practices and code samples
- Code demo: jOOQ, a great mapper for PostgreSQL
- Java inside PostgreSQL
- The future of Java and PostgreSQL
About two-thirds of the tutorial will be dedicated to iterate over code samples and demos. All the code would be available from public open-source repositories and built with maven, so that any attendee may download it and build easily to play with it during the tutorial (although not required).
VIDEO
Part 1
Part 2
Part 3
Part 4
-
Andrei Nikolayenko Скала-РБорис Нейман MellanoxAlexander Korotkov Postgres Professional
-
Dmitry Beloborodov UIS, CoMagic
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
-
Roland Sonnenschein Hesotech GmbH
Optimized use of PostgreSQL in real world production
Often it is enforced by the customer or even by law, to document the circumstances of the production of parts or lots. This talk is about the automated generation and storage of the corresponding administrative data and their correlation to measurements. Administrative data are entities like suppliers batch, article, serial number or production date. They are often to be exchanged with ERP systems.