postgresql plugin for ssb robert vežnaver it/sdc 25 th april 2014
TRANSCRIPT
IT-SDC : Support for Distributed Computing
PostgreSQL plugin for SSB
Robert VežnaverIT/SDC
25th April 2014
2IT-SDC
architecture
25th April 2014PostgreSQL plugin for SSB
siteview
Oracle Context
cx_Oracle
3IT-SDC
ideal solution
25th April 2014PostgreSQL plugin for SSB
siteview
PostgreSQL Context
psycopg2
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”
5IT-SDC
PL/SQL procedures
25th April 2014PostgreSQL plugin for SSB
psycopg2
Oracle SQL PL/SQL
PL/pgSQLtranslator
callproc()
6IT-SDC
Bypassing context
25th April 2014PostgreSQL plugin for SSB
psycopg2
Oracle SQL PL/SQL
PL/pgSQLtranslator
cursor()callproc()
7IT-SDC
Code consistency
25th April 2014PostgreSQL plugin for SSB
psycopg2
Oracle SQL PL/SQL
PL/pgSQLtranslator
cursor()callproc()
http/siteview
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
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