4 ms·

Here are a couple of examples in React: https://github.com/projectstorm/react-diagrams https://github.com/projectstorm/react-diagrams (diagram library) https:

by RNCTX 6y ago

Here are a couple of examples in React: https://github.com/projectstorm/react-diagrams https://github.com/projectstorm/react-diagrams (diagram library) https://www.npmjs.com/package/react-database-diagram https://www.npmjs.com/package/react-database-diagram (an example using the above library) There is a Node migration library that seems well received but as I hinted above I have always trusted Django's migration system and still use it to bang out schemas if I know the schema will change, so I can't vouch for this lib personally... https://www.npmjs.com/package/db-migrate https://www.npmjs.com/package/db-migrate

kiwicopple 6y ago
> projectstorm/react-diagrams woah. This looks powerful. Thanks for the libraries - i'll research more and loop back here if we end up using them.
- RNCTX 6y ago
  If this is worth pitching in a meeting, I'd point out that the creator of GraphQL is also the creator of Airtable, which seems to be a thriving startup. The whole business model there is to give people visual tools to get into a database and out of a spreadsheet. The story in all of this is that the only thing keeping Joe Q. Public from using a database instead of a spreadsheet is the very first step: designing a schema. Database design isn't really an impossible task for a non-developer to learn, if it can be visualized. If you start out at a command line and try to explain many-to-many relationships to them in code, you just lost them. People are visual creatures. Since we're talking about giving people an API that takes care of CRUD and basic view logic at the database itself, and returns the data and the success/fail/delay messaging in a way that is standardized on the UI via javascript objects and async browser functions, the only hurdle that's left is that first one... ...designing a schema. edit: on your topic of branching into test environments, I am in the process of evaluating low-code platforms for non-profits with limited development money but complex data needs at the moment, so I think we're thinking about the same things. Everyone and their brother is working on a low-code platform at the moment. A big part of whether those platforms succeed or not is how they handle "last mile" complex logic. By last mile I mean, you can feasibly deliver basic CRUD and data analysis visualizations with drag and drop and query binding in generic javascript UI components. But there's still going to be the 10% complex business logic cases that don't fall within the 90% of an application that the generic components and boilerplate don't cover. Off the top of my head, you could guide a user through some form logic that picks the first hundred or fifty or whatever rows from their existing tables that match a certain subset of shared keys, and tells them to flag columns which have sensitive data. Once the columns are flagged the tool could jumble the data in those columns and spit out a sandbox without any identifiable sensitive data that they could then safely hand to a contractor or freelancer to work on for custom development.
  - yen223 6y ago
    > I'd point out that the creator of GraphQL is also the creator of Airtable, which seems to be a thriving startup. This is news to me. Any sources for this?
    - RNCTX 6y ago
      I saw it in a conference talk, looking... edit: https://medium.com/@calebmer https://medium.com/@calebmer, https://github.com/calebmer https://github.com/calebmer, https://calebmer.com/ https://calebmer.com/ I misspoke, not a founder of the company but an engineering hire there after he left Facebook, and the creator of PostGraphile. The gist of what I was getting at is there is a lot of activity swirling around putting business logic back on databases, it seems. We might look back at these days as the high water mark of "peak javascript."

by RNCTX 6y ago

kiwicopple 6y ago

> projectstorm/react-diagrams woah. This looks powerful. Thanks for the libraries - i'll research more and loop back here if we end up using them.

RNCTX 6y ago
If this is worth pitching in a meeting, I'd point out that the creator of GraphQL is also the creator of Airtable, which seems to be a thriving startup. The whole business model there is to give people visual tools to get into a database and out of a spreadsheet. The story in all of this is that the only thing keeping Joe Q. Public from using a database instead of a spreadsheet is the very first step: designing a schema. Database design isn't really an impossible task for a non-developer to learn, if it can be visualized. If you start out at a command line and try to explain many-to-many relationships to them in code, you just lost them. People are visual creatures. Since we're talking about giving people an API that takes care of CRUD and basic view logic at the database itself, and returns the data and the success/fail/delay messaging in a way that is standardized on the UI via javascript objects and async browser functions, the only hurdle that's left is that first one... ...designing a schema. edit: on your topic of branching into test environments, I am in the process of evaluating low-code platforms for non-profits with limited development money but complex data needs at the moment, so I think we're thinking about the same things. Everyone and their brother is working on a low-code platform at the moment. A big part of whether those platforms succeed or not is how they handle "last mile" complex logic. By last mile I mean, you can feasibly deliver basic CRUD and data analysis visualizations with drag and drop and query binding in generic javascript UI components. But there's still going to be the 10% complex business logic cases that don't fall within the 90% of an application that the generic components and boilerplate don't cover. Off the top of my head, you could guide a user through some form logic that picks the first hundred or fifty or whatever rows from their existing tables that match a certain subset of shared keys, and tells them to flag columns which have sensitive data. Once the columns are flagged the tool could jumble the data in those columns and spit out a sandbox without any identifiable sensitive data that they could then safely hand to a contractor or freelancer to work on for custom development.
- yen223 6y ago
  > I'd point out that the creator of GraphQL is also the creator of Airtable, which seems to be a thriving startup. This is news to me. Any sources for this?
  - RNCTX 6y ago
    I saw it in a conference talk, looking... edit: https://medium.com/@calebmer https://medium.com/@calebmer, https://github.com/calebmer https://github.com/calebmer, https://calebmer.com/ https://calebmer.com/ I misspoke, not a founder of the company but an engineering hire there after he left Facebook, and the creator of PostGraphile. The gist of what I was getting at is there is a lot of activity swirling around putting business logic back on databases, it seems. We might look back at these days as the high water mark of "peak javascript."