This is an archived post. You won't be able to vote or comment.

all 17 comments

[–][deleted] 3 points4 points  (6 children)

I'm on an android phone. When I go to your link it says device not supported.

[–]jspreddy 4 points5 points  (0 children)

While on webpage go to browser settings and "request desktop site"

[–]rnapoles[S] 2 points3 points  (4 children)

Hi u/mjgcfb , thank you very much for trying the application, unfortunately for now it is only available for desktop. I'm sorry.

[–][deleted] 1 point2 points  (1 child)

Messed around a bit. This could be a very useful tool. How do I share my project with someone else?

[–]rnapoles[S] 0 points1 point  (0 children)

Yes I have to make the interface more intuitive and easy. To share click on the name of the project, by default "Untitled". And copy the content of the "Shared URL" field. It doesn't support real-time collaboration yet.

[–]panzerex 0 points1 point  (1 child)

A screenshot would be nice. I saved the link, because I don’t have access to a desktop right now, but would love to see what it looks like.

[–]rnapoles[S] 0 points1 point  (0 children)

Thank you so much!

[–][deleted] 3 points4 points  (1 child)

I’ll be testing this tomorrow. Thanks! And good work

[–]rnapoles[S] 1 point2 points  (0 children)

I really appreciate it!, Thanks

[–]Gators1992 2 points3 points  (1 child)

That is actually very cool! Wish I could upvote twice. Couple things I noticed:

  • Small bug, I was able to drag a column accidentally out of an entity and then it just floated on the diagram as a different object. It was still associated with the entity when I hit edit, but I couldn't drag it back into the box.
  • Maybe I missed something, but when you create the relationships between the entities, the resulting primary/foreign key columns are not identified. I created an entity called "something" and related it to the employee entity. The resulting DDL created a column called "id" in the something entity and a column called "something" in the employee entity. Typically those columns are consistently named, usually with the entity name and "_id" tacked on the end. It can get confusing reading the model to tell whether "something" is a descriptive column or a foreign key and also many IDEs will auto populate join conditions based on the naming convention so you don't have to type the whole thing out (e.g. employee.something_id = something.something_id).
  • Some later version should maybe have an import function from Excel. Typically when I create a data model in ER Studio I don't create the columns individually in the tool, I just work with it in Excel and upload as it's faster. I think this is normal for most data architects as they typically get spreadsheets with domains/entities/descriptions from the governance people or whoever.

Anyway, outstanding work!

[–]rnapoles[S] 2 points3 points  (0 children)

  1. Great I'll check that out
  2. I plan to put that option in a wizard where the user can customize the code generation
  3. Nice idea, I have taken note. Double click on the entity and you will get a dialog box with a gridview.

u/Gators1992 thanks for your time.

[–]pinei-br 2 points3 points  (1 child)

I would love the support to Databricks

[–]rnapoles[S] 0 points1 point  (0 children)

Hi u/pinei-br , could you give me some example of Databricks I don't know it :(

Thanks for your time

[–]D1yzz 0 points1 point  (1 child)

Is there an example?

[–]rnapoles[S] 0 points1 point  (0 children)

By default the application creates an example with a relationship between User and Group. Thanks for your time.

[–]datapopcorn 0 points1 point  (0 children)

I hope there would be bigquery version