3 ms·
That just seems like a limitation of your mapping layer. I don’t know ActiveRecord, but in SQLAlchemy you can map, say a 2DPoint (virtual) column named ‘positio
by deno 13y ago
That just seems like a limitation of your mapping layer. I don’t know ActiveRecord, but in SQLAlchemy you can map, say a 2DPoint (virtual) column named ‘position,’ to either native PostgreSQL Point type, 2‐element array, or for databases that support neither to two entirely separate columns quite seamlessly.
You can then use table.position as you normally would (table.position == [2,5]) and it will get mapped to the desired operation (e.g. table._x = 2 AND table._y = 5).
Though don’t use arrays for tags, see my other post.