Re: [sqlite] PLSQL
Thanks for the comments. JS Ken wrote: John, I've used PL/SQL on Oracle. I think it was derived from another language, maybe PL/1. I think its an excellent language, my main usage was geared at PL/SQL for DBA usage that managed internal oracle objects. Pros: Packages / Procedures/ Functions have a really nice hierarchy. Exception handling was excellent. cursor handing internaly was good. Record handling was good. Cons: Permission sheme was a pain. Ofter requiring direct ownership of objects rather than through grants. Array handling was poor. Var arrays helped but seemed rather cumbersome to utilize. Triggers are implemented via PL/SQL. John Stanton <[EMAIL PROTECTED]> wrote: I am looking for advice experienced DBMS users please. I am currently implementing an application server using Sqlite as an embedded RDBMS and have a need for expanded function capability. My server provides support for AJAX style WWW applications. I have not used PLSQL to any significant degree and would be interested to hear pros and cons from users. I am attracted to have a function language compatible with Oracle and PostgreSQL but wonder if PLSQL is actually a good language to create SQL functions which realise business rules and whether users find it easy to grasp so that they can maintain the PLSQL functions. Does anyone have a better idea? My plan is to compile the function language into a byte code and embed a virtual machine to execute it. The application server already has a virtual machine which executes a simple language which integrates SQL, HTML and Javascript along with some rudimentary control structures to define workflow. The function language would be used to define business rules and be part of a remote procedure call process used by the AJAX applications. I should very much appreciate some wise counsel. BTW, I shall make the server available if it turns out to work as planned. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] PLSQL
I've used both PL/SQL and PL/1. They are not related at all. P(rogramming) L(anguage) could be used for anything. PL/1 was IBM language for mainframes, similar to COBOL for developing application software and PL/SQL is Oracle procedural extension of their SQL. Dusan Gibarac -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Friday, March 30, 2007 3:33 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] PLSQL John, I've used PL/SQL on Oracle. I think it was derived from another language, maybe PL/1. I think its an excellent language, my main usage was geared at PL/SQL for DBA usage that managed internal oracle objects. Pros: Packages / Procedures/ Functions have a really nice hierarchy. Exception handling was excellent. cursor handing internaly was good. Record handling was good. Cons: Permission sheme was a pain. Ofter requiring direct ownership of objects rather than through grants. Array handling was poor. Var arrays helped but seemed rather cumbersome to utilize. Triggers are implemented via PL/SQL. John Stanton <[EMAIL PROTECTED]> wrote: I am looking for advice experienced DBMS users please. I am currently implementing an application server using Sqlite as an embedded RDBMS and have a need for expanded function capability. My server provides support for AJAX style WWW applications. I have not used PLSQL to any significant degree and would be interested to hear pros and cons from users. I am attracted to have a function language compatible with Oracle and PostgreSQL but wonder if PLSQL is actually a good language to create SQL functions which realise business rules and whether users find it easy to grasp so that they can maintain the PLSQL functions. Does anyone have a better idea? My plan is to compile the function language into a byte code and embed a virtual machine to execute it. The application server already has a virtual machine which executes a simple language which integrates SQL, HTML and Javascript along with some rudimentary control structures to define workflow. The function language would be used to define business rules and be part of a remote procedure call process used by the AJAX applications. I should very much appreciate some wise counsel. BTW, I shall make the server available if it turns out to work as planned. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] PLSQL
John, I've used PL/SQL on Oracle. I think it was derived from another language, maybe PL/1. I think its an excellent language, my main usage was geared at PL/SQL for DBA usage that managed internal oracle objects. Pros: Packages / Procedures/ Functions have a really nice hierarchy. Exception handling was excellent. cursor handing internaly was good. Record handling was good. Cons: Permission sheme was a pain. Ofter requiring direct ownership of objects rather than through grants. Array handling was poor. Var arrays helped but seemed rather cumbersome to utilize. Triggers are implemented via PL/SQL. John Stanton <[EMAIL PROTECTED]> wrote: I am looking for advice experienced DBMS users please. I am currently implementing an application server using Sqlite as an embedded RDBMS and have a need for expanded function capability. My server provides support for AJAX style WWW applications. I have not used PLSQL to any significant degree and would be interested to hear pros and cons from users. I am attracted to have a function language compatible with Oracle and PostgreSQL but wonder if PLSQL is actually a good language to create SQL functions which realise business rules and whether users find it easy to grasp so that they can maintain the PLSQL functions. Does anyone have a better idea? My plan is to compile the function language into a byte code and embed a virtual machine to execute it. The application server already has a virtual machine which executes a simple language which integrates SQL, HTML and Javascript along with some rudimentary control structures to define workflow. The function language would be used to define business rules and be part of a remote procedure call process used by the AJAX applications. I should very much appreciate some wise counsel. BTW, I shall make the server available if it turns out to work as planned. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] PLSQL
I am looking for advice experienced DBMS users please. I am currently implementing an application server using Sqlite as an embedded RDBMS and have a need for expanded function capability. My server provides support for AJAX style WWW applications. I have not used PLSQL to any significant degree and would be interested to hear pros and cons from users. I am attracted to have a function language compatible with Oracle and PostgreSQL but wonder if PLSQL is actually a good language to create SQL functions which realise business rules and whether users find it easy to grasp so that they can maintain the PLSQL functions. Does anyone have a better idea? My plan is to compile the function language into a byte code and embed a virtual machine to execute it. The application server already has a virtual machine which executes a simple language which integrates SQL, HTML and Javascript along with some rudimentary control structures to define workflow. The function language would be used to define business rules and be part of a remote procedure call process used by the AJAX applications. I should very much appreciate some wise counsel. BTW, I shall make the server available if it turns out to work as planned. - To unsubscribe, send email to [EMAIL PROTECTED] -
