Having to support a dedicated language for stored-preocedures sounds to me like an overkill, PL/SQL or not. IMHO having the ability to store complex queries in the standard TSQL syntax already supported today for queries, plus basic extra stuff only like loops, and have their compiled version executed, would be just enough (since as someone else has mentioned before most reasons to use SPs are irrelevant with most SQLite uses). If that's already an existing feature (afaik it isn't), then I have nothing else to ask for in this subject.
Itamar. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Alexey Pechnikov Sent: Sunday, September 20, 2009 7:34 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Most wanted features of SQLite ? Hello! On Sunday 20 September 2009 18:16:19 sub sk79 wrote: > PL/SQL has a very wide user-base and a huge repository of existing > code-base in the world. Using StepSqlite PL/SQL compiler this huge > base can use SQLite by reusing their code as well as reusing their > skills - no learning curve for this set of users. But I write stored procedures and triggers for PostgreSQL on Tcl. You can write it on perl, java, etc. PL/pgSQL or PL/SQL is not the best solution to all. IMHO is more interesting any open source lang than proprietary PL/SQL. Oracle has a lot of a non-standart extensions which are not exists in SQLite. And Oracle ideology is very different. You may not replace Oracle to SQLite with the same application architecture. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
