Storm is an object-relational mapper (ORM) for Python ()

Dushyant Bansal | 29 Jun 2011 21:11

Using List property with SQLite

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)

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

Thanks,
Dushyant

<div><p>Hi all,<br>I have been trying to use List property with SQLite databse. I receive this error:<br><br>"sqlite3.InterfaceError: Error binding parameter 0 - probably unsupported type."<br><br>On reading storm manual page, it seems that List property is supported for SQLite.<br>

(<a href="https://storm.canonical.com/Manual?action=fullsearch&amp;context=180&amp;value=sort&amp;titlesearch=Titles#Table%20of%20properties%20vs.%20python%20vs.%20database%20types" target="_blank">https://storm.canonical.com/Manual?action=fullsearch&amp;context=180&amp;value=sort&amp;titlesearch=Titles#Table%20of%20properties%20vs.%20python%20vs.%20database%20types</a>)<br><br>But, in an old message on storm archives, it says that List property is only supported for PostgreSQL.<br><a href="https://lists.ubuntu.com/archives/storm/2007-July/000165.html" target="_blank">https://lists.ubuntu.com/archives/storm/2007-July/000165.html</a><br><br><br>Thanks,<br>Dushyant
</p></div>

headers

James Henstridge | 30 Jun 2011 05:19

Re: Using List property with SQLite

On Thu, Jun 30, 2011 at 3:11 AM, Dushyant Bansal
<dushyant37@...> 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.