PGCon2014 - Final Release
PGCon 2014
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Alexander Korotkov |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - Fri May 23 - 2014-05-23 |
| Room | Morisset 221 |
| Start time | 11:00 |
| Duration | 00:45 |
| Info | |
| ID | 700 |
| Event type | Lecture |
| Track | Case Studies |
| Language used for presentation | English |
PostgreSQL experience in Russian Parliament
Success story of PostgreSQL in Russian State Duma
In 2010 Russian State Duma (lower chamber of parliament) renewed its web site. That was the first step in modernization towards open data and e-goverment in further years. PostgreSQL took a central place in data integration between intranet systems and open web services. During recent years many new open data systems were launched powered by PostgreSQL.
This talk covers the issues of PostgreSQL integration into State Duma intranet systems, which were mostly running Oracle Database as well as implementation of many open data systems. Data between intranet systems and PostgreSQL databases are mostly synchronized using ora2pg. Full synchronization was used for small databases as well as incremental synchronization for large databases. Open data systems implemented on PostgreSQL including:
- Law and draft law search systems
- Open vote system
- Verbatim system
Using PostgreSQL database allows to save license const as well as achieve great performance and features.