DAL array field handling

[Lucas]

hello one and all,

I'm considering using PostgreSQL (psql) array field types as the backend of a py4web app.  does py4web allow for that in db.define_table?  how would one insert, update, and query that field?  does py4web simply handle it as a python list?

also but a bit separate from py4web, would psql allow for indexing on that array field?

thank you in advance, Lucas

[Massimo DiPierro]

It is not a very efficient field. You can efficiently search and index it. As far as python is concerned it is just an array stored as a string

--
You received this message because you are subscribed to the Google Groups "py4web" group.
To unsubscribe from this group and stop receiving emails from it, send an email to py4web+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/py4web/4e3d0844-b404-45f0-bc9e-585a8c9e1044n%40googlegroups.com.

[Lucas]

alright, Massimo, I stay old school master-detail on this then.