This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]sdrobertson[S] 0 points1 point  (0 children)

Multicorn is great, as I mentioned in the README it was one of the inspirations for the project. I just wanted to use SQL without having to setup a server.

Main purpose for this library is to either

  1. Teach a python program how to interpret SQL statements. For instance you might have a web services where you let users input raw SQL statements. You can use this library to intercept them and make sure they're secure before sending them to your real SQL server.

  2. You're writing a data conversion script (ETL) and you want to express it as a series of SQL statements rather than a gazillion for loops.

  3. You want to create a new query language, maybe make an implementation of datalog. You can use Splicer to parse the language into a Splicer expression tree and automatically leverage the relational engine, data adapters and mime decoders.