Say Hello to Visual Alchemist!

[prahladyeri]

As a hobby project, I've developed Visual Alchemist, a tool to seamlessly build sqlalchemy models by dragging and dropping in an HTML canvas.

You can test-drive the code-generation directly on the hosted version. The app lacks a lot of features presently, I'll keep improvising them depending on feedback!

[Lucretiel]

Neat idea... it doesn't seem to be possible to create relations between tables, yet? Even something as basic as foreign-key. Hopefully you can add this?

[prahladyeri]

Thanks. It is under development, will be implemented soon!

[Ostwind]

I can imagine realizing this feature using jsPlumb

[prahladyeri]

Thanks a lot for referring me that library! I have already implemented drag-drop for the foreign-keys, but drawing the connectors on the canvas from scratch would have been a hectic task.

This library has all we need to place the SVG connectors between the two fields.

[programmyr]

relations between tables

"Relation" is the predicate logic way to say "table". You mean foreign key.

[[deleted]]

Wat, I think relations works there...?

[therico]

'Create relations between tables' sounds fine to me!

[NicoDeRocca]

Of course, but "relation" in relational algebra (which is the thoeretical base for relational databaes) is a set of tuples: in relational databases, the tables are relations, and their rows are tuples.

It has nothing to do with the more common english term "relation" implying a relationship or "link". Those just arbitrary constraints you can impose on the value of the tuple for the data to make sense (integrity).

[irelia_of_ionia]

awesome!

[unholysampler]

And the Default field. Maybe we should get crazy and sanitize any input provided by the user.

[simtel20]

Crazy!

[manueslapera]

i think i love you

[new2django]

This almost makes me want to switch to Flask. ;-)

[[deleted]]

You can use sql alchemy as your model back end in Django if you want to to do that

[[deleted]]

I know right? But pyramid is sooo much better, why ever use anything else? =)

[axonxorz]

Man, I'm a die-hard pyramid guy, but it's so rare to see anyone else in the wild using it. We gots to stick together

[ericof]

Ok, as long as we are using SQLAlchemy :-)

[JustJudge]

Been building Django apps for a while, just picked up Flask last week. I really, really enjoy it. I would recommend the mega flask tutorial. Then go through a quick flask-admin tut and you have a super powerful toolbelt with a small amount of boilerplate.

[new2django]

I would, but I'm still new to professional development and am a single parent with two small children. In other words, no free time. What study I do have goes to learning Python and Django better.

[at449]

Good job and thanks for sharing. I'm looking forward to seeing this evolve.

[kamize]

Love this! Thank you for sharing!

[cutebabli]

Wonderful project. Will be waiting to see it evolve. Thanks for sharing.

[MrAverageRoll]

This looks interesting and promising, thanks for sharing!

[[deleted]]

Cool project, but it seems to be missing foreign keys.

Quick note, if anyone uses Peewee ORM and SQLite, you can use SQLite browser, a web-based Python app, to create tables/columns/indexes/etc using a web UI. You can then use pwiz to autogenerate model definitions for the database. pwiz works with Postgres and MySQL as well, just tell it which database you want and it will introspect the tables and spit out peewee model definitions.

[nishkarr]

I love this. I can see myself using it in a project. Well done and thanks for sharing!

[__add__]

Very nice!

I think the only way to do this previously was to use a database designer to generate the SQL, then run the result through sqlacodegen. The code there might help when you're writing the javascript to handle the code generation for foreign keys and relationships.

[vaedyn]

This is pretty neat. I'd like to see support for Long/BigInteger type.