SQLite Forum

Request: stored functions/procedures
Login
> which language do you get up in the morning for, with that song in your heart?

Usually the one I've learned most recently. :)

To say more gets us into a pointless advocacy argument, so instead, let us consider languages which:

* many programmers enjoy using
* are embeddable into a C/C++ host program
* are small enough to add to a host that otherwise has no use for it (i.e. not Node.js!)
* have an "eval" facility, so we can compile and run SQLite TEXT data at runtime
* have a SQLite binding

There's a fairly small set of plausible candidates for the system I suggest in my first post above:

* [Python](https://docs.python.org/3/extending/embedding.html)
* [Lua](https://www.lua.org/manual/5.3/manual.html#4)
* [Tcl](https://wiki.tcl-lang.org/page/How+to+embed+Tcl+in+C+applications) / [Jim](http://jim.tcl.tk/) / [TH1](https://www.fossil-scm.org/index.html/doc/trunk/www/th1.md)
* [Perl](https://perldoc.perl.org/perlembed.html)
* [Ruby](https://silverhammermba.github.io/emberb/embed/)

There are doubtless others. Members of the Church of Lambda the Unchained could pick Guile or Racket or whatever. You could probably do this with Erlang, too. And so on.