These are chat archives for frictionlessdata/chat

1st
Jan 2018
Slythfox
@slythfox
Jan 01 2018 00:43
@Stephen-Gates My interest is in data liberation and longevity. So my application uses tabular data package as a kind of intermediary format for importing and exporting data stored in its relational database. With CoreData, I have implemented a custom persistent store for working with tabular data packages and CSV. I've also found it to be useful for seeding a database during development.
Stephen Gates
@Stephen-Gates
Jan 01 2018 06:28
data liberation and longevity :+1:
On a different topic… In a table schema, what would be a reasonable maximum number of values to place in an enum constraint before it made more sense to create a foreign key relationship to a reference table? For context, I’m planning to implement features to create a constraint from column and create reference table from column.
Rufus Pollock
@rufuspollock
Jan 01 2018 10:54

Hi! I'm new here. I've been working independently on a Swift implementation of data package, tabular data package, and table schema. I presently have a draft implementation which is now in use in a shipping product. I would like to contribute (or collaborate with) this code if deemed suitable when I've reached a critical milestone. I had hoped I would reach that milestone by the end of the year but there's still much to do. Indeed, the present state of Swift creates some challenges for bonafide libraries. So, here’s to the gregorian new year!

@slythfox this is great. Would you be up for opening an issue about your implementation work so far here https://github.com/frictionlessdata/implementations/issues so we can keep track of it.

It is also really really interesting to hear of the work you've been doing with the core datasets. There primary home how is https://datahub.io/core and https://datahub.io/docs/core-data

@Stephen-Gates

On a different topic… In a table schema, what would be a reasonable maximum number of values to place in an enum constraint before it made more sense to create a foreign key relationship to a reference table? For context, I’m planning to implement features to create a constraint from column and create reference table from column.

Good question. I'm not sure there is any obvious answer to that. Can i suggest opening a question on discuss.okfn.org on this as it seems kind of FAQ like and worth a more permanent response.