4 ms·

Wow, this is the best explanation of db relationship types I've seen. https://capture.dropbox.com/A3a1aybKNDy1ttEx https://capture.dropbox.com/A3a1aybKNDy1ttEx

• nickreese 4y ago
  Tried tossing in some of the datasets found here: https://data.cms.gov/provider-data/archived-data/nursing-homes https://data.cms.gov/provider-data/archived-data/nursing-hom... and none of the file uploads worked. Either way, really stoked for this.
  • mathemancer 4y ago
    I think some of those data sets are likely too big for our poor demo server. It's had a stressful day. I did try with some of the smaller sets, though, and they seem to work. An advantage of Mathesar is that you can always self-host, and provision enough resources for whatever data size you have!
  • pavish 4y ago
    We tested importing the files from the link and right on, some of the imported tables do not seem to work as expected. You've just helped us discover a bug. Here's the issue that tracks it: https://github.com/centerofci/mathesar/issues/2634 https://github.com/centerofci/mathesar/issues/2634 Thanks!
• kgodey 4y ago
  Thank you very much! We found that a lot of similar "relational database" tools ended up not actually using foreign keys for relationships because they are difficult to explain to non-technical users. We took that as a UX challenge. :). The power of relational databases comes from the relationships, so we want to help users understand and use them.