Обсуждение: Help
Hi, My name is MOHAMMED BOUZIANE ILYES, i am an postgraduate student at the National high school of computing (ESI) algeirs- Algeria. my master thesis is "database replication based on snapshot isolation" I encounter somme difficulties to implement a middleware baesd replication with Libpq and c language, for that, I need somme hints to achieve this work, more precisely, how to capture the SQL statement text with libpq at the middleware layer. best regards. -- Mohammed-Bouziane ilyes ingénieur d'état en informatique ORACLE DABASE 10g ADMINISTRATOR CERTIFIED PROFESSIONAL (OCP) Étudiant en deuxième année école doctorale (ESI) option IRM Tel :0664614266
On Wed, 9 Apr 2014 14:41:46 +0100 MOHAMMED-BOUZIANE Ilyes <i_mohammed_bouziane@esi.dz> wrote: > my master thesis is "database replication based on snapshot isolation" > I encounter somme difficulties to implement a middleware baesd > replication with Libpq and c language, for that, I need somme hints to > achieve this work, more precisely, how to capture the SQL statement > text with libpq at the middleware layer. Hi, Mohammed I think you could take a look at the code in SQLRelay [1], a middleware which knows how to intercept SQL queries, and uses libpq for talking to PostgreSQL. [1] http://sourceforge.net/projects/sqlrelay/ -- Alberto Cabello Sánchez <alberto@unex.es>