{"id":10595,"date":"2024-03-08T08:20:42","date_gmt":"2024-03-08T08:20:42","guid":{"rendered":"https:\/\/davelevy.info\/wiki\/?p=10595"},"modified":"2024-03-14T12:49:08","modified_gmt":"2024-03-14T12:49:08","slug":"database-generators","status":"publish","type":"post","link":"https:\/\/davelevy.info\/wiki\/database-generators\/","title":{"rendered":"Database Generators"},"content":{"rendered":"\n

It’s project time again. I need to build an application. It needs a database, and writing the procedural code in SQL is easier for me. So step one is to find an ERD\/generator. Here are my notes …<\/p>\n\n\n\n\n\n\n\n

Some ERD modelling tool reviews, <\/p>\n\n\n\n

    \n
  1. Top 5 free database diagram design tools<\/a> from holistics i\/o who state that QuickDBD, ERD Plus, DrawSQL can generate SQL and are free at the scale I need. <\/li>\n\n\n\n
  2. Top 7 entity relationship diagram tools<\/a> from trevor i\/o, who adds, Lucidchart, DB Diagram. <\/li>\n<\/ol>\n\n\n\n

    From Trevor I\/O, <\/p>\n\n\n\n

    If you’re modelling an existing database, want to get it done fast<\/strong>, and have it stay up to date<\/strong>, try Trevor.io.<\/p>\n\n\n\n

    If you’re creating something new and prefer code over a GUI, <\/strong>try QuickDBB or DBDiagram.<\/p>\n\n\n\n

    If you require more flexibility and have a bit more time to spend creating and maintaining your diagram,<\/strong> try LucidChart.<\/p>\n","protected":false},"excerpt":{"rendered":"

    It’s project time again. I need to build an application. It needs a database, and writing the procedural code in SQL is easier for me. So step one is to find an ERD\/generator. Here are my notes …<\/p>\n","protected":false},"author":1,"featured_media":10596,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_share_on_mastodon":"0"},"categories":[3],"tags":[2050,1177,1121,496,2049,618,911],"class_list":["post-10595","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-campaignlab","tag-data-dictionary","tag-data-modelling","tag-database","tag-erd","tag-rdbms","tag-technology"],"share_on_mastodon":{"url":"https:\/\/mastodon.social\/@davelevy_eu\/112059091780325294","error":""},"jetpack_featured_media_url":"https:\/\/davelevy.info\/wiki\/wp-content\/uploads\/2024\/03\/database-jandirasonnendeck-unsplash-w1080.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/10595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/comments?post=10595"}],"version-history":[{"count":1,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/10595\/revisions"}],"predecessor-version":[{"id":10597,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/posts\/10595\/revisions\/10597"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media\/10596"}],"wp:attachment":[{"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/media?parent=10595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/categories?post=10595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davelevy.info\/wiki\/wp-json\/wp\/v2\/tags?post=10595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}