search

uliwitness / Stacksmith

An intuitive software erector kit targeted at people new to programming, but with enough potential to stay useful once they've learned, inspired by HyperCard.
http://stacksmith.org
128 stars 13 forks source link

SQLite database commands #49

Open uliwitness opened 9 years ago

uliwitness commented 9 years ago

Queries should ideally be specified as something between LINQ and the search command's syntax. Make it so users don't have to escape query values etc., not unlike prepared statements in SQL. Maybe even throw in SQL support while we're at it.

uliwitness commented 7 years ago

This seems like a starter bug at first, but to do this right, we don't want to expose the user to SQL syntax. So there'd need to be parser support for parsing an expression and then generating some sort of format string from it (same thing we'd need for the "sort" command). Alternately, one could fake it like in the "download" command and generate a function with a name impossible for the user to type based on the expression, and then call that function to generate the query string. Might involve some CNodeTransformation subclasses to wrap up the query parameters without the user having to do it manually.