Git Product home page Git Product logo

drewsov's Projects

evanbyrne-go icon evanbyrne-go

Go CMS for the latest iteration of my personal website.

java-open-pl-sql-access icon java-open-pl-sql-access

Oracle® PL/SQL™ applications written for the web cannot interact with web servers directly. Special web server modules, commonly known as gateways, are used to execute the PL/SQL code processing web requests and to fetch and return the response. These gateways initially receive HTTP requests, preprocess them, determine which PL/SQL subprograms are called and which parameters are passed, connect to an Oracle server, execute requested subprograms, fetch results of their execution and return them back to the requesting client. Oracle Corp. supplies its own PL/SQL gateway module for its HTTP server (Oracle HTTP Server powered by Apache, OHS), called mod_plsql. This module is written to Apache module specifications in C and is loaded by the web server as shared library. Module routines are called whenever PL/SQL application is invoked and are responsible for connecting to the Oracle server, executing requested code, retrieving execution results and returning them to the client. During the evolution of this module, it received many attractive features PL/SQL web developers asked for, but it still lacks certain functionality. Most important missing feature is full control over the HTTP output, including HTTP headers, which prevents application developers from creating advanced applications adhering to the latest Internet standards. mod_plsql also does not provide support for WebDAV protocol in any form. mod_plsql is also known for its multiple security vulnerabilities discovered during the year of 2002, which also demonstrated how complex it is to maintain the module installations – Oracle had released multiple patches for multiple supported platforms and different OHS versions released on those platforms, and finding correct patches and applying them in correct order is not trivial. And last, but not the least, mod_plsql is written specifically for OHS and cannot be used with other web servers, whether or not they are based on Apache HTTPD code base.

jolt icon jolt

JSON to JSON transformation library written in Java.

pljson icon pljson

PL/JSON is a generic JSON object written in PL/SQL. Using PL/SQL object syntax, users instantiate a JSON object and then add members, arrays and additional JSON objects. This object type can store JSON data, in Oracle, persistently.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.