{"id":2010,"date":"2023-11-01T13:57:52","date_gmt":"2023-11-01T05:57:52","guid":{"rendered":"https:\/\/five.co\/?p=2010"},"modified":"2026-04-02T10:24:26","modified_gmt":"2026-04-02T02:24:26","slug":"data-sources-in-five-building-dynamic-applications","status":"publish","type":"post","link":"https:\/\/preview-php85.dzine.org\/five\/blog\/data-sources-in-five-building-dynamic-applications\/","title":{"rendered":"Data Sources in Five: Building Dynamic Applications"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"576\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications-1024x576.png\" alt=\"Data Sources in Five: Building Dynamic Applications\" class=\"wp-image-2036\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications-1024x576.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications-300x169.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications-768x432.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">With the introduction of Version 2.5, Five has expanded its capabilities to integrate with a variety of data sources. Within Five, you can now:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Utilize the built-in MySQL database provided with every application.<\/li>\n\n\n\n<li>connect to external databases.<\/li>\n\n\n\n<li>Integrate with external systems using REST APIs.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Each of these can serve as data sources within Five. Let&#8217;s delve deeper into their capabilities.<\/p>\n\n\n\n<div style=\"background-color: #001524;\"><hr style=\"height: 5px;\">\n<blockquote>\n<pre style=\"text-align: center; overflow: hidden; white-space: pre-line;\"><span style=\"color: #f1ebda; background-color: #4588d8; font-size: calc(18px + 0.390625vw);\"><strong>Sign Up Free | Five Low-Code IDE<\/strong> <br><span style=\"font-size: 14pt;\">Rapidly Build &amp; Deploy Bespoke Business Software<\/span><\/span><\/pre>\n<\/blockquote>\n<p style=\"text-align: center;\"><a href=\"https:\/\/preview-php85.dzine.org\/five\/get-started\/\" target=\"_blank\" rel=\"noopener\"><button style=\"background-color: #f8b92b; border: none; color: black; padding: 20px; text-align: center; text-decoration: none; display: inline-block; font-size: 18px; cursor: pointer; margin: 4px 2px; border-radius: 5px;\"><strong>Sign Up<\/strong><\/button><br><\/a><\/p>\n<hr style=\"height: 5px;\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Databases<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Five&#8217;s built-in MySQL database<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Five is tailored for developers aiming to quickly build and deploy online database applications. it provides a <strong>MySQL <\/strong>database with every application which allows developers to create and edit our database right inside Five.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Apart from Table Wizards which allows you to create tables with just a couple of clicks Five also offers developers a graphical interface, allowing them to establish tables, define fields, designate data and display types, and even introduce new fields to pre-existing tables.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"548\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/10\/Frame-41-1024x548.png\" alt=\"\" class=\"wp-image-2030\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/10\/Frame-41-1024x548.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/10\/Frame-41-300x160.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/10\/Frame-41-768x411.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/10\/Frame-41-1536x821.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/10\/Frame-41-2048x1095.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Beyond these functionalities, developers have the capability to set create-read-update-delete (CRUD) permissions, ensuring controlled access to the application. They can also script functions using JavaScript or TypeScript to embed specific logic. Data retrieval or filtering is made effortless with queries, which can either be scripted in standard SQL or visually constructed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">External Databases<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Apart from your internal MySQL database, Five also has the ability to connect to external databases on top of that, this means you are not limited to only one approach and can instead offer a truly dynamic development environment. (<strong>Note: <\/strong><em>External Databases are a paid feature and are not available in the free version<\/em><strong>)<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To set up our connection, first launch Five and sign in with an admin account. After creating an application, navigate to the development environment. From there, select &#8216;<strong>Data<\/strong>&#8216; followed by &#8216;<strong>Database<\/strong>&#8216;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once we are inside the menu start by clicking on the yellow plus button to get started. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"548\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-42-1024x548.png\" alt=\"\" class=\"wp-image-2031\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-42-1024x548.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-42-300x160.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-42-768x411.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-42-1536x821.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-42-2048x1095.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">From here, choose the desired database type from the dropdown menu and then simply input the connection string for your database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Connection Wizard: Your Gateway to REST APIs<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Apart from Databases, Five also allows developers to use REST APIs as a data source through the Connection Wizard. We can start by clicking on&nbsp;<strong>Data<\/strong>&nbsp;and then navigating to&nbsp;<strong>Connection Wizard<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"190\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1024x190.png\" alt=\"\" class=\"wp-image-2032\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1024x190.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-300x56.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-768x143.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1536x285.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After clicking on the Wizard, you\u2019ll be presented with an interface that has some similarities to Postman. Start by selecting \u2018New\u2019 from the WebService lookup, then assign it a WebService ID and Name.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After that simply pass in your endpoints for your API and click on save to store your connection. <a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/using-webservices-to-connect-to-rest-apis\/\" data-type=\"URL\" data-id=\"https:\/\/preview-php85.dzine.org\/five\/blog\/using-webservices-to-connect-to-rest-apis\/\">For a more in-depth guide on Connection Wizard click here<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"547\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1-1024x547.png\" alt=\"\" class=\"wp-image-2033\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1-1024x547.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1-300x160.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1-768x410.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1-1536x821.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/image-1.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Using Data Sources<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Now that we&#8217;ve taken a quick look at the different data source methods in Five, let&#8217;s dive into how we can use them. These data sources now can be used inside any component that requires some data like <strong>Charts<\/strong>, <strong>Reports, <\/strong>and even <strong>Forms<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let us take Reports as an example here. Start by clicking on <strong>&#8216;Visuals&#8217; <\/strong>and Then <strong>&#8216;Reports&#8217;<\/strong>. This is where you can generate, adjust, customize, and manage all your MySQL reports. Five lets you create reports on&nbsp;<em>any&nbsp;<\/em>data source, including its built-in MySQL database (as described here), any query, any external database, and even a REST API.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Inside Reports Click on<strong> Data Sources<\/strong>, you will see a lookup that shows all your available data sources <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"548\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-43-1024x548.png\" alt=\"\" class=\"wp-image-2034\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-43-1024x548.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-43-300x160.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-43-768x411.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-43-1536x821.png 1536w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Frame-43-2048x1095.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now you can go back to the <strong>General<\/strong> Tab and click on&nbsp;<strong>Click to add&nbsp;<\/strong>in the&nbsp;<strong>Template<\/strong>&nbsp;field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You\u2019re now inside a rich text editor that allows you to design PDF reports the way you would design a usual Word document. On top of the text and document design features, the report generator also lets you select any data field from your data source. For a more in-depth guide on <a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/generate-mysql-report\/\" data-type=\"URL\" data-id=\"https:\/\/preview-php85.dzine.org\/five\/blog\/generate-mysql-report\/\">how to write reports with data sources click here<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Five understands the significance of data in application development. By offering diverse data source integration options, it ensures that developers have all the tools they need to build dynamic, data-rich applications. Whether you&#8217;re a seasoned developer or just starting out,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Version 2.5 of Five has further enhanced its capabilities, providing developers with a range of options for data source integration. Whether it&#8217;s making use of the built-in MySQL database, connecting to external databases, or tapping into REST APIs, Five offers a straightforward approach. The platform&#8217;s tools, from the Table Wizards to the Connection Wizard, are tailored to streamline the development process.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/preview-php85.dzine.org\/five\/get-started\/\">Sign up<\/a>\u00a0now\u00a0and start building application on\u00a0our low-code development environment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With the introduction of Version 2.5, Five has expanded its capabilities to integrate with a variety of data sources. Within Five, you can now: Each of these can serve as data sources within Five. Let&#8217;s delve deeper into their capabilities. Sign Up Free | Five Low-Code IDE Rapidly Build &amp; Deploy Bespoke Business Software Sign [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":2036,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[21],"tags":[],"class_list":["post-2010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"uagb_featured_image_src":{"full":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications.png",1280,720,false],"thumbnail":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications-150x150.png",150,150,true],"medium":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications-300x169.png",300,169,true],"medium_large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications-768x432.png",768,432,true],"large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications-1024x576.png",1024,576,true],"1536x1536":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications.png",1280,720,false],"2048x2048":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/11\/Five.Co-Data-Sources-in-Five-Building-Dynamic-Applications.png",1280,720,false]},"uagb_author_info":{"display_name":"Pranoy Sarkar","author_link":"https:\/\/preview-php85.dzine.org\/five\/author\/f1v5_ed8_au\/"},"uagb_comment_info":0,"uagb_excerpt":"With the introduction of Version 2.5, Five has expanded its capabilities to integrate with a variety of data sources. Within Five, you can now: Each of these can serve as data sources within Five. Let&#8217;s delve deeper into their capabilities. Sign Up Free | Five Low-Code IDE Rapidly Build &amp; Deploy Bespoke Business Software Sign&hellip;","_links":{"self":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/2010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/comments?post=2010"}],"version-history":[{"count":1,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/2010\/revisions"}],"predecessor-version":[{"id":17436,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/2010\/revisions\/17436"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media\/2036"}],"wp:attachment":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media?parent=2010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/categories?post=2010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/tags?post=2010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}