>> 1. Generate a loadable SQLite extension and distribute it with DB. > > We can write C extension without any wrapper. Why we need to learn > your extension for getting the same result and possible new bugs?
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. For those who do need to learn PL/SQL, it is still worthwhile to utilize StepSqlite because: PL/SQL is specially designed for and very suitable for handling database operations, while other general purpose languages like TCL, lua, C , C++ etc are very suitable indeed for application programming. StepSqlite enables combining the respective power of these two sets of languages in writing apps with SQLite back-ends by using the concept of Stored Procedures/Functions and Packages. All big databases operate this way as well: for ex, Oracle lets apps written in C++ to call stored procedures written in PL/SQL. StepSqlite is committed to bringing this power and convenience from the big database world to the small database world while preserving the small, fast and reliable. More benefits of StepSqlite described here: http://www.metatranz.com/stepsqlite/benefits.html http://www.metatranz.com/stepsqlite regards, -sk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
