Download - PostgreSQL plugin for SSB
![Page 1: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/1.jpg)
IT-SDC : Support for Distributed Computing
PostgreSQL plugin for SSB
Robert VežnaverIT/SDC
25th April 2014
![Page 2: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/2.jpg)
2IT-SDC
architecture
25th April 2014PostgreSQL plugin for SSB
siteview
Oracle Context
cx_Oracle
![Page 3: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/3.jpg)
3IT-SDC
ideal solution
25th April 2014PostgreSQL plugin for SSB
siteview
PostgreSQL Context
psycopg2
![Page 4: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/4.jpg)
4IT-SDC
Oracle SQL
25th April 2014PostgreSQL plugin for SSB
psycopg2
Oracle SQL
translator
DECODENVLROWNUMSET TIME_ZONESYS_EXTRACT_*SYSDATE
variable binding:var %(var)s
“false friends”
![Page 5: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/5.jpg)
5IT-SDC
PL/SQL procedures
25th April 2014PostgreSQL plugin for SSB
psycopg2
Oracle SQL PL/SQL
PL/pgSQLtranslator
callproc()
![Page 6: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/6.jpg)
6IT-SDC
Bypassing context
25th April 2014PostgreSQL plugin for SSB
psycopg2
Oracle SQL PL/SQL
PL/pgSQLtranslator
cursor()callproc()
![Page 7: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/7.jpg)
7IT-SDC
Code consistency
25th April 2014PostgreSQL plugin for SSB
psycopg2
Oracle SQL PL/SQL
PL/pgSQLtranslator
cursor()callproc()
http/siteview
![Page 8: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/8.jpg)
Monitoring of Grid Operations - S. Roiser 8IT-SDC
Case sensitivity
Oracle returns UPPERCASE,PgSQL returns lowercase
Most columns in Oracle are CamelCase, but not all!
Reserved SQL words used as names! Other modules get key/value list
directly, therefore JavaScript code depends on case!
21 May 2013
![Page 9: PostgreSQL plugin for SSB](https://reader035.vdocuments.us/reader035/viewer/2022062310/56816269550346895dd2d933/html5/thumbnails/9.jpg)
Monitoring of Grid Operations - S. Roiser 9IT-SDC
Proposed solution
21 May 2013
Create style guidelines document Rewrite SQL to ANSI Remove PL/SQL procedures Case sensitivity
use PostgreSQL with “CamelCase”, modify cursor for uppercase
make everything go through context mapper