On 2014/10/09 19:04, Omprakash Kolluri wrote:
Hi,
I am new to SQLite. I am working on an app that I am developing and plan to
use SQLite as an embedded database. My Question - Does SQLite support
stored procedures similar to those in MS SQL Server etc. Any suggestions OR
pointers to information links woill be greatly appreciated. Thank you
Hi Om,
Not directly since it is at the API level very integrated and integratable with any C or other common compiler languages, so doing
anything procedural is usually an easy task, and as the name implies it is "Lite" which means some
higher-CPU-Cycle-and-Memory-consumption additions are foregone specifically so it could work well on embedded systems, as you seem
to be implementing.
A good read in this regard would be here:
http://www.sqlite.org/whentouse.html
Check out the recent CTE additions which does allow a level of procedural
querying here:
http://www.sqlite.org/lang_with.html#rcex2
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
