I've looked for a function to execute a shell command in a SQLite query, e.g., a function exec() that would execute the given command.
Is there such function in SQLite?
-
For the complete function list in SQLITE refer This LiNK and for exec() refer this LINK. I hope this might solve your problem.Anant666– Anant6662017-04-03 13:55:44 +00:00Commented Apr 3, 2017 at 13:55
-
But this is a C-interface? Could I not execute the shell command from plain SQL?Shuzheng– Shuzheng2017-04-03 14:01:06 +00:00Commented Apr 3, 2017 at 14:01
Add a comment
|
2 Answers
When you are inside SQLite shell, you can execute any shell command using the ".shell" command without exiting out of the SQLite shell. For example:
.shell echo "Hi there!"
prints the greeting (using OS's echo command) and continues to stay inside the SQLite shell.
Comments
SQLite is designed for small embedded systems, which might not even have a shell.
So there is no exec() among the built-in functions.
However, it would be easy to create your own user-defined function to wrap the system() C function.
4 Comments
Shuzheng
So, I cannot have the SQLite execute commands like nslookup like it is possible for MS SQL Server through use of EXECUTE()?
TheRealChx101
Is there a function then that allows writing to a file? I'd like to create a trigger that will "push" new rows to a pipe with a process listening on the other side. Sort f like messaging queue. This would awesome
CL.
@TheRealChx101 There is no built-in function for that. (Again, the shell has a user-defined function.)
FrankL
@TheRealChx101: I use this extention: sqlite.org/src/file/ext/misc/fileio.c. This works like a charme, If you remove the SQLITE_DIRECTONLY flag in the call of sqlite3_create_function (in fileio.c) which creates the writfile() function you can use it even in triggers.
