search

kvesteri / postgresql-audit

Audit trigger for PostgreSQL
BSD 2-Clause "Simplified" License
126 stars 28 forks source link

Oracle support? #15

Open piotr-dobrogost opened 8 years ago

piotr-dobrogost commented 8 years ago

Would Oracle support be in scope of this project? Has any work been already done in this direction?

kvesteri commented 8 years ago

Yes definitely, technically it should be possible to implement this if Oracle has a JSON datatype.

piotr-dobrogost commented 8 years ago

From _Did You Say "JSON Support" in Oracle 12.1.0.2?_

So for these reasons (and maybe a few more) Oracle Database 12c supports JSON natively with relational database features, including transactions, indexing, declarative querying, and views.

Details are in JSON in Oracle Database chapter in Oracle's documentation.

There are some extensions adding support for JSON for earlier versions of Oracle. To know if they would work one needs to know specific requirements – what is required specifically with regard to JSON support for this project to work?

kvesteri commented 8 years ago

You can browse through the SQL templates to see what needs to supported by Oracle as well: https://github.com/kvesteri/postgresql-audit/tree/master/postgresql_audit/templates

Basically we would need Oracle equivalents for those SQL templates.