[storm] Using List property with SQLite

[James Henstridge]

On Thu, Jun 30, 2011 at 3:11 AM, Dushyant Bansal <dushyant37 at gmail.com> wrote:
> Hi all,
> I have been trying to use List property with SQLite databse. I receive this
> error:
>
> "sqlite3.InterfaceError: Error binding parameter 0 - probably unsupported
> type."
>
> On reading storm manual page, it seems that List property is supported for
> SQLite.
> (https://storm.canonical.com/Manual?action=fullsearch&context=180&value=sort&titlesearch=Titles#Table%20of%20properties%20vs.%20python%20vs.%20database%20types)

This looks like it is in error.  SQLite does not support array values,
and our sqlite backend does not include any code to perform the
serialisation/deserialisation.

> But, in an old message on storm archives, it says that List property is only
> supported for PostgreSQL.
> https://lists.ubuntu.com/archives/storm/2007-July/000165.html

Unfortunately that is still the current state of support.

James.