{"id":11676,"date":"2022-05-28T15:38:23","date_gmt":"2022-05-28T12:38:23","guid":{"rendered":"https:\/\/flatlogic.com\/blog\/?p=11676"},"modified":"2022-05-31T11:30:32","modified_gmt":"2022-05-31T08:30:32","slug":"ready-made-web-app-scheme-integration-flatlogic-platform-update","status":"publish","type":"post","link":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/","title":{"rendered":"Generate Full-Stack Web Apps Based on Database Schema"},"content":{"rendered":"

Hello! Flatlogic has added one more important feature: ready-made web application scheme integration<\/em>. Check out our release notes to learn more about our latest product enhancements.<\/p>

Previously, Flatlogic AI web app generator<\/a><\/em> allowed you to model a database schema from scratch. We received a lot of requests from our users who had already modelled DB schemas and found it inconvenient to manually remodel the schema in Flatlogic schema editor<\/a>.<\/p>

To eliminate this obstacle and increase our users’ satisfaction, we are introducing a new platform feature: Creating a web app from an SQL dump. The feature supports both Postgres and MySQL dialects and identifies tables and column types, also trying to discover relations based on index, reference and constraint information. “users” table is automatically added to the DB model to preserve web app user management<\/a> functionality. If the “users” table already exists in the imported DB, the column lists of the two tables are merged. SQL import is invoked by simply uploading the SQL dump file, literally in one click. <\/p>

We recommend that you choose “Structure only, no data<\/strong>” mode when dumping the SQL from your database; otherwise the data dump will result in unnecessary volume uploads which sometimes could be huge and even lead to upload failure.<\/p>

After the successful file upload and schema import, the schema editor allows you to review and edit the schema, and correct names and column types in case those were not identified correctly by the SQL dump parser. Also you can add one-to-many (relation one) and many-to-many (relation many) relation types if such were not discovered automatically.<\/p>

\"\"<\/figure>
\"\"<\/figure>
\"\"<\/figure>

Flatlogic schema editor also allows you to extend your existing DB schema while keeping all the data intact by applying our generated migrations feature.<\/p>

Enjoy this new feature and model Admin web apps for your existing database literally in one click!<\/p>

Click here to learn more about upcoming features<\/a>. Here you’ll see some info about Flatlogic plans and some points from the roadmap.<\/p>","protected":false},"excerpt":{"rendered":"

Generate full-stack web applications based on database schema. Read more about Flatlogic new feature inside.<\/p>\n","protected":false},"author":16,"featured_media":11684,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"flatlogic_tldr":"Generate full-stack apps from existing DBs by importing an SQL dump\nPostgres\/MySQL supported; tables, types, and relations auto-detected\n\"users\" table is auto-added; merges columns if it already exists\nEdit schema and relations after import; apply migrations without data loss\nTip: dump 'Structure only, no data' to keep uploads small and reliable","flatlogic_facts":[{"text":"Flatlogic adds a feature to create a web app from an SQL dump.","source":""},{"text":"Supports Postgres and MySQL SQL dialects for schema import.","source":""},{"text":"\"users\" table is auto-added; if it exists, column lists are merged.","source":""},{"text":"SQL import is triggered by uploading the dump file in one click.","source":""},{"text":"Use 'Structure only, no data' dumps to avoid large uploads and failures.","source":""}],"footnotes":""},"categories":[1],"tags":[438,268,123,50],"class_list":["post-11676","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","tag-database-schema-design","tag-flatlogic-generator","tag-product-update","tag-flatlogic-story-amp-awards"],"yoast_head":"\nGenerate Full-Stack Web Apps Based on Database Schema - Flatlogic Blog<\/title>\n<meta name=\"description\" content=\"Build full-stack web applications based on database schema.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Generate Full-Stack Web Apps Based on Database Schema\" \/>\n<meta property=\"og:description\" content=\"Build full-stack web applications based on database schema.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/\" \/>\n<meta property=\"og:site_name\" content=\"Flatlogic Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/flatlogic\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/katarina.harbuzava\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-28T12:38:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-31T08:30:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/05\/update.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Katarina Harbuzava\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/katrinblanchare\" \/>\n<meta name=\"twitter:site\" content=\"@flatlogic\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Katarina Harbuzava\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Generate Full-Stack Web Apps Based on Database Schema - Flatlogic Blog","description":"Build full-stack web applications based on database schema.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/","og_locale":"en_US","og_type":"article","og_title":"Generate Full-Stack Web Apps Based on Database Schema","og_description":"Build full-stack web applications based on database schema.","og_url":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/","og_site_name":"Flatlogic Blog","article_publisher":"https:\/\/www.facebook.com\/flatlogic","article_author":"https:\/\/www.facebook.com\/katarina.harbuzava\/","article_published_time":"2022-05-28T12:38:23+00:00","article_modified_time":"2022-05-31T08:30:32+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/05\/update.jpeg","type":"image\/jpeg"}],"author":"Katarina Harbuzava","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/katrinblanchare","twitter_site":"@flatlogic","twitter_misc":{"Written by":"Katarina Harbuzava","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/#article","isPartOf":{"@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/"},"author":{"name":"Katarina Harbuzava","@id":"https:\/\/flatlogic.com\/blog\/#\/schema\/person\/e0181c5edc04022ba61f5cf9111d37bd"},"headline":"Generate Full-Stack Web Apps Based on Database Schema","datePublished":"2022-05-28T12:38:23+00:00","dateModified":"2022-05-31T08:30:32+00:00","mainEntityOfPage":{"@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/"},"wordCount":336,"publisher":{"@id":"https:\/\/flatlogic.com\/blog\/#organization"},"image":{"@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/#primaryimage"},"thumbnailUrl":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/05\/update.jpeg","keywords":["Database Schema Design","Flatlogic Generator","Flatlogic Generator Updates","Flatlogic Story & Awards"],"articleSection":["News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/","url":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/","name":"Generate Full-Stack Web Apps Based on Database Schema - Flatlogic Blog","isPartOf":{"@id":"https:\/\/flatlogic.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/#primaryimage"},"image":{"@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/#primaryimage"},"thumbnailUrl":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/05\/update.jpeg","datePublished":"2022-05-28T12:38:23+00:00","dateModified":"2022-05-31T08:30:32+00:00","description":"Build full-stack web applications based on database schema.","breadcrumb":{"@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/#primaryimage","url":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/05\/update.jpeg","contentUrl":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2022\/05\/update.jpeg","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/flatlogic.com\/blog\/ready-made-web-app-scheme-integration-flatlogic-platform-update\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/flatlogic.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Generate Full-Stack Web Apps Based on Database Schema"}]},{"@type":"WebSite","@id":"https:\/\/flatlogic.com\/blog\/#website","url":"https:\/\/flatlogic.com\/blog\/","name":"Flatlogic Blog","description":"Vibe-coding, AI Agents, Professional Software Development Services, Case Studies and More","publisher":{"@id":"https:\/\/flatlogic.com\/blog\/#organization"},"alternateName":"Flatlogic Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/flatlogic.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/flatlogic.com\/blog\/#organization","name":"Flatlogic","url":"https:\/\/flatlogic.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/flatlogic.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/62ea6de0b3469aa3d6ebb528-1.png","contentUrl":"https:\/\/flatlogic.com\/blog\/wp-content\/uploads\/2025\/10\/62ea6de0b3469aa3d6ebb528-1.png","width":970,"height":257,"caption":"Flatlogic"},"image":{"@id":"https:\/\/flatlogic.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/flatlogic","https:\/\/x.com\/flatlogic","https:\/\/www.instagram.com\/flatlogiccom\/","https:\/\/www.linkedin.com\/company\/flatlogic\/"]},{"@type":"Person","@id":"https:\/\/flatlogic.com\/blog\/#\/schema\/person\/e0181c5edc04022ba61f5cf9111d37bd","name":"Katarina Harbuzava","sameAs":["https:\/\/www.facebook.com\/katarina.harbuzava\/","https:\/\/www.instagram.com\/katarina.harbuzava\/","https:\/\/www.linkedin.com\/in\/katarina-harbuzava-698a49126\/","https:\/\/x.com\/https:\/\/twitter.com\/katrinblanchare","https:\/\/www.youtube.com\/channel\/UCDbyjsN_OkJfKTmg2qN-D2Q","https:\/\/soundcloud.com\/katarinaharbuzawa","Working in the sphere of digital, Katarina is a passionate author, writer, editor, content manager and chief vibe curator. Previously working in one of the largest east European concert agencies, Katarina is an avid ambassador of culture, esthetic education, and all the creative stuff. She adores music and musical instruments. She holds a university degree in modern linguistics, in the field of teaching English, German and Swedish. She stays on top of all social media trends and recently switched to the theme of web design, delving deeper into Figma and learning the basics of front end development. When Katya is not watching tutorials or live gigs on YouTube, you can see her cuddling large fluffy dogs; or buying a ticket to a new place, because she is just obsessed with new routes and adventures! She stays forever inspired by people, new cities, stations and airports, and is convinced that travelling is the only true way to discover, gain new experiences and make the world an even better place to live in."],"url":"https:\/\/flatlogic.com\/blog\/author\/katarina\/"}]}},"_links":{"self":[{"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/posts\/11676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/comments?post=11676"}],"version-history":[{"count":9,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/posts\/11676\/revisions"}],"predecessor-version":[{"id":11727,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/posts\/11676\/revisions\/11727"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/media\/11684"}],"wp:attachment":[{"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/media?parent=11676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/categories?post=11676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/flatlogic.com\/blog\/wp-json\/wp\/v2\/tags?post=11676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}