3 ms·
In the data side of the world, "structs of arrays" translate to column based indexes i.e. Snowflake and OLAP. "Arrays of structs" translate to relational datab
by rawgabbit 3y ago
In the data side of the world, "structs of arrays" translate to column based indexes i.e. Snowflake and OLAP. "Arrays of structs" translate to relational databases with its page/row based indexes.
FWIW, I am a big fan of Snowflake and think it will eat everyone else's lunch. I also find it amusing that Snowflake "supports" foreign keys but don't enforce it. In other words, Snowflake is as "nosql" as I care to go.
- nerdponx 3y agoOr an in-memory "data frame" like in R, Python's Pandas, and Polars.
- OJFord 3y ago> "supports" foreign keys but don't enforce it As in, you can have a sort of 'link' to another table, that not only mignt be null, but might be a value which doesn't exist over there? What does the 'support' add over just having a column in which you tell yourself (but not your DBMS) you're storing values which correspond to keys in another table? (You can take it further - s/keys/values in a column/ - many to one relationships without an intermediary table! Amazing! ...more 'NoSQL' than I care to go I think, for almost anything.)
- rawgabbit 3y agohttps://docs.snowflake.com/en/sql-reference/constraints-overview https://docs.snowflake.com/en/sql-reference/constraints-over... Note Snowflake supports defining and maintaining constraints, but does not enforce them, except for NOT NULL constraints, which are always enforced.
- deleted 3y ago[deleted]
- OJFord 3y agoI don't understand what it means (and that page doesn't explain) for a 'constraint' not to be enforced? Do you somehow get some sort of warning, but not an error, i.e. the insert/update is allowed to work, everything proceeds as normal, but it's there to check on and correct if you want?