Does SQLite support procedures

Question

I am evaluating a SQLite database for my requirements. Does SQLIte support warehouse procedures? If so, what are the limitations? Does SLIte support range? thanks Saurabh

Answer 1

No, it is not. See Appropriate Use for SQLite on the Main Site.

Answer 2

If you really want to store SQL code in the database (for example, when you want to develop cross-platform applications), you can create a specific table that will store the raw SQL commands that do this thing, and then in the client you get the SQL command ( for example, var myString = db.CreateCommand ("select SqlColumn from tablewithsqlcommands, where Procname = theprocedureIwant"). ExecuteScalar (); ), and then execute it in the second step ( var myResult = db.CreateCommand (myString) .whatever_exoumentneme )

Answer 3

The key reason for storing procs in the database is that you execute the SP code in the same process as the SQL engine. This makes sense for database engines designed to act as a network-connected service, but the imperative of SQLite is much less. Given that it works as a DLL in your current process, it makes sense to implement SP in the client language.

However, you can extend SQLite with your own custom host language functions (PHP, Python, Perl, C #, Javascript , Ruby , etc.). I did this in C # using DevArt SQLite to implement password hashing.