{"id":13328,"date":"2010-08-31T19:23:10","date_gmt":"2010-08-31T17:23:10","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=13328"},"modified":"2010-08-31T19:23:10","modified_gmt":"2010-08-31T17:23:10","slug":"orm-designer","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2010\/08\/31\/orm-designer\/","title":{"rendered":"ORM Designer"},"content":{"rendered":"<!-- google_ad_section_start -->\n<p>Here is a tool that might help you with your MVC framework, like CakePHP, Symfony, and others &#8211; <a href=\"http:\/\/www.orm-designer.com\/\">ORM Designer<\/a>. \u00a0In\u00a0essence, it is a graphical user interface for drawing a visual representation of your project (such as an Entity Relationship Diagram (ERD)) and than converting it into the code. \u00a0You can specify which framework and which\u00a0\u00a0ORM you want to use and it will generate the appropriate bits and pieces. \u00a0What&#8217;s even more interesting is that it has import functionality, which means that you can start using it with an existing project. \u00a0Here is <a href=\"http:\/\/www.youtube.com\/watch?v=FNlmU6zX5Ug\">the video<\/a> that shows and explains more.<\/p>\n<p style=\"text-align: center;\"><div class=\"jetpack-video-wrapper\"><span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"660\" height=\"372\" src=\"https:\/\/www.youtube.com\/embed\/FNlmU6zX5Ug?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/div><\/p>\n<p>Of course, I got excited about it, downloaded and installed. \u00a0 Two things that disappointed me were:<\/p>\n<ol>\n<li>It&#8217;s a native Windows application, which runs on Linux through the wine emulator. \u00a0While it works fine, I&#8217;d much prefer a native application that I could integrate with the rest of my development environment.<\/li>\n<li>CakePHP import is not supported at this time.<\/li>\n<\/ol>\n<p>Other than that though, it looks very promising. \u00a0I&#8217;ve seen quite a few applications that help with database design, and ORM Designer stands well in that row. \u00a0You can create entities, define fields, specify indexes, and associate entities with each other using relationships. \u00a0Many-to-many relationships are supported, as are entity inheritance. \u00a0While inheritance does make it for a bit more complicated structure of the project (with <em>app\/models\/base\/<\/em> folder for CakePHP), it&#8217;s very nice to have such support for bigger, more complex projects.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/08\/orm_designer.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"13330\" data-permalink=\"https:\/\/mamchenkov.net\/wordpress\/2010\/08\/31\/orm-designer\/orm_designer\/\" data-orig-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/08\/orm_designer.png?fit=716%2C384&amp;ssl=1\" data-orig-size=\"716,384\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"ORM Designer\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/08\/orm_designer.png?fit=660%2C354&amp;ssl=1\" class=\"aligncenter size-medium wp-image-13330\" title=\"ORM Designer\" src=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/08\/orm_designer-500x268.png?resize=500%2C268&#038;ssl=1\" alt=\"\" width=\"500\" height=\"268\" srcset=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/08\/orm_designer.png?resize=500%2C268&amp;ssl=1 500w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/08\/orm_designer.png?resize=160%2C85&amp;ssl=1 160w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/08\/orm_designer.png?resize=75%2C40&amp;ssl=1 75w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2010\/08\/orm_designer.png?w=716&amp;ssl=1 716w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>The project is commercial, with a 14 days evaluation version available for download. If you like it enough to buy, the price is very reasonable &#8211; 99 EUR per license.<\/p>\n<p>Try and see if you like it, and <a href=\"http:\/\/www.orm-designer.com\/contact-us\">provide some feedback<\/a> to the guys who are developing it. \u00a0ORM Designer has all the chances of becoming an extremely useful tool and since it is still in its early development, your feedback would be of the most value.<\/p>\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<!-- google_ad_section_start -->\n<p>Here is a tool that might help you with your MVC framework, like CakePHP, Symfony, and others &#8211; ORM Designer. \u00a0In\u00a0essence, it is a graphical user interface for drawing a visual representation of your project (such as an Entity Relationship Diagram (ERD)) and than converting it into the code. \u00a0You can specify which framework and &hellip; <a href=\"https:\/\/mamchenkov.net\/wordpress\/2010\/08\/31\/orm-designer\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">ORM Designer<\/span><\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,18,62],"tags":[1537,1559,38,19],"keyring_services":[],"class_list":["post-13328","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-technology","tag-cakephp","tag-databases","tag-php","tag-tools"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":28534,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/04\/28\/orm-active-record-vs-data-mapper\/","url_meta":{"origin":13328,"position":0},"title":"ORM: Active Record vs. Data Mapper","author":"Leonid Mamchenkov","date":"April 28, 2018","format":false,"excerpt":"Everybody building a web application with a modern framework, is already probably using an ORM (Object-Relational Mapping).\u00a0 Most frameworks include one out of the box.\u00a0 But digging deeper into the subject, ORMs do vary from each other, and some cases, very significantly. Most variations are coming from two main approaches:\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24147,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/05\/20\/cakephp-3-orm\/","url_meta":{"origin":13328,"position":1},"title":"CakePHP 3 ORM","author":"Leonid Mamchenkov","date":"May 20, 2015","format":"status","excerpt":"https:\/\/twitter.com\/cakephp\/status\/600970761004851200","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22103,"url":"https:\/\/mamchenkov.net\/wordpress\/2014\/07\/01\/cakephp-3-here-we-go-again\/","url_meta":{"origin":13328,"position":2},"title":"CakePHP 3, here we go again.","author":"Leonid Mamchenkov","date":"July 1, 2014","format":false,"excerpt":"As some of you might know, I'm a big fan of CakePHP framework. \u00a0I've used it on numerous projects since the beginning of times. \u00a0I've built projects small and large, migrated existing native PHP codebases to CakePHP and even survived a few major CakePHP upgrades - 1.2 to 2.0 comes\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28627,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/06\/12\/inflected-a-port-of-activesupports-inflector-to-node-js-and-the-browser\/","url_meta":{"origin":13328,"position":3},"title":"Inflected &#8211; a port of ActiveSupport&#8217;s inflector to Node.js and the browser","author":"Leonid Mamchenkov","date":"June 12, 2018","format":false,"excerpt":"For the last few years I have been heavily involved in building web applications with the CakePHP framework.\u00a0 Apart from all the usual MVC, ORM, and so on, and so forth, features, I am a big fan of the CakePHP utilities.\u00a0 And among all of them, my long time favorite\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28478,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/04\/17\/cakephp-3-6-0-release\/","url_meta":{"origin":13328,"position":4},"title":"CakePHP 3.6.0 release","author":"Leonid Mamchenkov","date":"April 17, 2018","format":false,"excerpt":"My all time favorite PHP framework - CakePHP has recently announced the availability of the long awaited version 3.6.0.\u00a0 What's so special about this particular version? - those of you not very familiar with CakePHP might ask.\u00a0 And I'll tell you. CakePHP is a well established framework, with long history\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22485,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/04\/20\/cakefest-2014-a-look-back\/","url_meta":{"origin":13328,"position":5},"title":"CakeFest 2014 : a look back","author":"Leonid Mamchenkov","date":"April 20, 2015","format":false,"excerpt":"Disclaimer: \u00a0I've written this post a few days after I came back from CakeFest 2014. \u00a0Unfortunately, it is unfinished, and by now I have completely lost hope of ever finishing it. \u00a0My main excuse is that the first day after CakeFest was my first working day at my new job,\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"CakeFest2014","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2014\/09\/CakeFest2014-500x500.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/13328","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=13328"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/13328\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=13328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=13328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=13328"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=13328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}