Arrays in Sequelize with Postgres

[Joao Barbosa]

Hi,

sorry if this doubts were already asked but i didn't found anything about it.

How can i insert arrays to a column that is an array in a postgres db throught sequelize?

How can i make querys to arrays?

Performance wise, arrays are viable or is better to use a string field instead?

Thank you

[Joao Barbosa]

The first question i have already found out.

A new question come to mind, which is, how it works the manipulation of an array foreign key (add and update)?

Thank you

[Joao Barbosa]

Anyone?

[Joao Barbosa]

Sure =)

Project = Sequelize.define("Project",{...});

Users = Sequelize.define("Users",{project: Sequelize.ARRAY(Sequelize.STRING)});

Project.hasMany(Users,{foreignKey: project);

objUser = Users.create(...);

From some tests of mine, if you do Project.addUsers(objUser) it will ask you for an array. How can i do this?

The performance is good if you work with arrays as foreign keys? Are there methods for arrays as foreign keys?

Thank you

[Daniel Durante]

Ah sorry dude, I didn't understand your second question correctly, as of right now Sequelize has no way of supporting multiple foreign keys, this is something that we'll be tackling sooner rather than later though.

[Joao Barbosa]

Is the performance of Sequelize operations good if you are working with arrays as foreign keys?

Anyway seems like it is something that needs work, so for now i will find another solution.

Have another question if you don't mind...How can i delete a reference of an association table?

Thank you

[Joao Barbosa]

Anyone can help?

[Daniel Durante]

model.remove<AssociationName>()

For more details/examples:

http://sequelizejs.com/documentation#associations-associating-objects

I can't really be explicit without knowing your model names ad how they're associated.

[Joao Barbosa]

Thank you for the help. Don't know why but it didn't worked before.