*** 366,368 ****
--- 366,379 ----
What about Apache Derby? It uses the Apache 2.0 license and is easy to embed in Java applications
(http://db.apache.org/derby/). -- See SqliteVersusDerby
+
+ ----
+ Tcl related
+ ----
+
+ *: Tcl variable bindings for list types? i.e.:
+
+ set values [list a b c]
+ db eval { SELECT * FROM table WHERE x IN ($values) }
+
+ SQLite does its own variable interpolation which avoids the (messy) need to do value quoting/escaping (to protect against SQL injection attacks, etc.) but in the case where it's an "IN ($variable)" clause, it treats $variable as a single value instead of a Tcl list of values. Or, maybe I'm doing something wrong. If I am, please let me know: dossy@panoptic.com.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|