{"id":1764,"date":"2023-09-29T15:57:37","date_gmt":"2023-09-29T07:57:37","guid":{"rendered":"https:\/\/five.co\/?p=1764"},"modified":"2024-04-16T21:26:18","modified_gmt":"2024-04-16T13:26:18","slug":"build-apps-on-external-database","status":"publish","type":"post","link":"https:\/\/preview-php85.dzine.org\/five\/blog\/build-apps-on-external-database\/","title":{"rendered":"MySQL, SQL Server, SQLite: Build on Any Database"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Build Bespoke Applications on MySQL, SQL Server, or SQLite<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Earlier this week, we <a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/announcing-five-v-2-5\/\" data-type=\"post\" data-id=\"1649\">announced the release of Five Version 2.5<\/a>. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Version 2.5 is a major new release of our rapid application development environment because of its <strong>ability to connect to almost any data source<\/strong>, including all major relational databases, such as SQL Server, SQLite, and MySQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Five now makes it extremely easy and quick to develop admin panels, dashboards, and utilities on top of data stored in existing relational databases.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"576\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Connect-Five-to-an-External-Database-1024x576.png\" alt=\"\" class=\"wp-image-1766\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Connect-Five-to-an-External-Database-1024x576.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Connect-Five-to-an-External-Database-300x169.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Connect-Five-to-an-External-Database-768x432.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Connect-Five-to-an-External-Database.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><sub>*PostgreSQL will be supported in future releases.<\/sub><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Connect To Any Database<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">As before, Five still gives you a dedicated MySQL database for every application that&#8217;s developed in Five. This built-in MySQL can be created using Five&#8217;s <strong>Table Wizard<\/strong> or its visual <strong>Database Modeler<\/strong>. But what if you already have a database ready and don&#8217;t want to create a new database from scratch?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s where Five&#8217;s ability to connect to existing, external databases comes in.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Five can now treat a relational database (SQL Server, MySQL, or SQLite) as a data source. Once connected to an external database via a connection string (more on how to set up your connection string at the bottom of this post), Five can then be used to build a bespoke application on top of it. These applications can range from simple MySQL CRUD tools to SQL Server admin panels.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Watch our Developer Advocate Pranoy explain the new and improved data interfaces of Five in our webinar here:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How To Build and Deploy a Full Stack Web App in 30 Minutes | Low-Code For Real Developers | Five.Co\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/d3hVwoUWlpM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Query Your Database and Create Forms, Reports, Charts and Dashboards <\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For external, existing databases, Five gives developers access to all its application development features, including forms, charts, dashboards, and PDF reports. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">These UI features can be connected to an external database, or to a query running on top of the database. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here&#8217;s a simple use case: say your business already has a customer database with contact information, addresses, and other customer data. You&#8217;ve been tasked with building a dashboard and weekly report on top of your database that analyses the regional customer growth. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Simply connect Five to your external database, write the query to retrieve the count of customers by region, and connect your query to a chart and PDF report. The whole application can be built in just four steps and a few lines of code:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Connect Five to your external database by providing the connection string.<\/li>\n\n\n\n<li>Write the query.<\/li>\n\n\n\n<li>Build the chart.<\/li>\n\n\n\n<li>Launch the application. Done! <\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Five takes care of all of the boilerplate code that would usually go into the process of building such an app, including an auto-generated GUI and even deployment. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On top of building forms, charts, dashboards, and reports, you can also create a GUI that lets business users create, read, update, or delete data stored in your database through forms or data grids. By creating user roles that govern access to your data in Five, the tedious job of doing this in SQL becomes much easier.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Build on Multiple External Data Sources<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Another great feature is that you&#8217;re not limited to developing applications on only one data source. Applications built with Five can have multiple data sources, such as an external SQL Server database, Five&#8217;s built-in MySQL database, and a REST API. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Five doesn&#8217;t care where your data comes from or how many data sources you have. Connect your Azure-hosted Microsoft SQL Server database, add a REST API, and use Five&#8217;s built-in MySQL database all in one application &#8211; any data source that provides access to data can be used in the development process.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">How to Get Started<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To connect Five to an existing external database, a paid subscription to Five is required. However, developers can explore Five&#8217;s features at <strong>no cost<\/strong> by signing up for a free download and using Five&#8217;s built-in MySQL database as a test database. Building applications Five on an external database is no different from using Five&#8217;s built-in MySQL database.<\/p>\n\n\n\n<div style=\"background-color: #001524;\"><hr style=\"height: 5px;\">\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 For a Free Download<\/strong>\n<span style=\"font-size: 14pt;\">Download Five Today and Start Developing<\/span><\/span><\/pre>\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>Free Sign Up<\/strong><\/button><br><\/a><\/p>\n<hr style=\"height: 5px;\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">How to Specify Your Connection String<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Once you are ready to subscribe to Five, here&#8217;s how to format your connection string to an external database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Remember, the connection string needs to be provided to establish the database connection. It represents a set of parameters in the form of key = value pairs separated by semicolons.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Key<\/strong><\/td><td><strong>Value<\/strong><\/td><\/tr><tr><td>Driver<\/td><td>The database driver allows you to interact with your chosen DBMS through Five\u2019s interface.<\/td><\/tr><tr><td>URL<\/td><td>A database connection URL provides a way of identifying a database so that the selected driver recognizes it and connects to it.<\/td><\/tr><tr><td>Username<\/td><td>Your username.<\/td><\/tr><tr><td>Password<\/td><td>Your password.<\/td><\/tr><tr><td>Name<\/td><td>The name of your database<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Here&#8217;s an example: driver=mssql; url=five-test-server.database.windows.net:1433; username=user; password=password; name=exampleDB<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Build Bespoke Applications on MySQL, SQL Server, or SQLite Earlier this week, we announced the release of Five Version 2.5. Version 2.5 is a major new release of our rapid application development environment because of its ability to connect to almost any data source, including all major relational databases, such as SQL Server, SQLite, and [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":1765,"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-1764","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\/09\/Five.Co-Build-Web-Apps-on-External-Data-Sources.png",1280,720,false],"thumbnail":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Build-Web-Apps-on-External-Data-Sources-150x150.png",150,150,true],"medium":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Build-Web-Apps-on-External-Data-Sources-300x169.png",300,169,true],"medium_large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Build-Web-Apps-on-External-Data-Sources-768x432.png",768,432,true],"large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Build-Web-Apps-on-External-Data-Sources-1024x576.png",1024,576,true],"1536x1536":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Build-Web-Apps-on-External-Data-Sources.png",1280,720,false],"2048x2048":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2023\/09\/Five.Co-Build-Web-Apps-on-External-Data-Sources.png",1280,720,false]},"uagb_author_info":{"display_name":"Dominik Keller","author_link":"https:\/\/preview-php85.dzine.org\/five\/author\/f1v5_ed3_my\/"},"uagb_comment_info":0,"uagb_excerpt":"Build Bespoke Applications on MySQL, SQL Server, or SQLite Earlier this week, we announced the release of Five Version 2.5. Version 2.5 is a major new release of our rapid application development environment because of its ability to connect to almost any data source, including all major relational databases, such as SQL Server, SQLite, and&hellip;","_links":{"self":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/1764","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/comments?post=1764"}],"version-history":[{"count":0,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/1764\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media\/1765"}],"wp:attachment":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media?parent=1764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/categories?post=1764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/tags?post=1764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}