antoniop in OpenACS

Reduce divergence between postgres and oracle codebase

Reduce divergency between oracle and postgres codebase, fix query

    • -0
    • +10
    /openacs-4/packages/acs-lang/www/admin/test/test.xql
Fix current_time, should have been current_timestamp

Reduce divergency between oracle and postgres codebase

    • -0
    • +11
    /openacs-4/packages/acs-lang/www/admin/test/timezone.xql
Reduce divergence between oracle and postgres codebase

Reduce divergency between postgres and oracle codebase

Make forum::use_ReadingInfo_p more robust when UseReadingInfo parameter in forums is not set

    • -2
    • +2
    /openacs-4/packages/forums/tcl/forums-procs.tcl
    • -2
    • +2
    /openacs-4/packages/forums/www/message-view.tcl
Reduce divergency between oracle and postgres codebase

Reduce divergency between oracle and postgres codebase

Add missing new xql file

Reduce divergence between postgres and oracle codebase

Reduce divergence between oracle and postgres codebase

Reduce divergence between postgres and oracle codebase

Ehm... reintroduce dual for oracle compliance

Use dual for oracle compliance

    • -2
    • +2
    /openacs-4/packages/news/www/index.xql
Add dual for oracle compliance

Reduce divergency between oracle and postgres codebase

    • -0
    • +17
    /openacs-4/packages/news/www/admin/process-2.xql
Reduce divergency between oracle and postgres codebase

Use tcl to do date calculations instead of db, reduce postgres/oracle divergencies

Reduce divergence between oracle and postgres codebase, optimize queries

    • -48
    • +0
    /openacs-4/packages/news/www/index-oracle.xql
    • -3
    • +3
    /openacs-4/packages/news/www/index.tcl
    • -1
    • +41
    /openacs-4/packages/news/www/index.xql
Do date calculations in tcl rather than in db, reduce oracle and postgres divergency

    • -2
    • +4
    /openacs-4/packages/news/www/item-create.tcl
Reduce divergence between oracle and postgres code

    • -4
    • +2
    /openacs-4/packages/news/lib/latest-news.tcl
    • -0
    • +10
    /openacs-4/packages/news/lib/latest-news.xql
Reduce oracle/postgres divergence

Uniform sql codebase

Use cached api instead of query to retrieve node id from community and community_type

Remove unused query from xql (no usage was found upstream and on Learn@WU)

Get rid of dual idiom

Oracle doesn't support limit :-|

Streamline and optimize idiom

Declare explicitly the only column we need in a way that DBMS can create a better query plan