Instant DB Web Apps

Instant DB Web Apps

Create a multi-page, multi-table web app in 10 minutes. DZone > Database Zone > Instant DB Web Apps Instant DB Web Apps by Val Huber · Aug. 25, 20 · Database Zone · Tutorial Like (2) Comment (0) Save Tweet Here's how to create a basic web app for your database in 10 minutes. Let's explore the created app, and then the creation proces

Here's how to create a basic web app for your database in 10 minutes. Let's explore the created app, and then the creation process.

Created Web App

As shown below, the apps are

  1. Multi-page: apps include 1 page per table. The screen show below shows a List Customer screen (with query), a Show (one) Customer page, and a Show Order page. Navigation controls enable you to transition between these pages.
  2. Multi-table: pages include related_views for each related child table, and join in parent data
  3. Favorite field first: first-displayed field is "name", or contains "name" (configurable)
  4. Predictive joins: favorite field of each parent is shown (product name - not the foreign key product_id_)
  5. Ids last: such boring fields are not shown on lists, and at the end on other pages

The Challenge: Conventional Approaches Not Agile

Conventional approaches where you create pages a field at a time with a screen painter, or use Wizards to create pages, will not create such an app in 10 minutes. These also often require not only complicated coding, but also installing and configuring an IDE, frameworks, Web Servers, etc. Not agile.

Instead, we need an agile approach that introspects the data model, and creates not only all the pages, but also the transitions.

Creation Process

Let's see how to create this app.

Background

As shown below, Flask AppBuilder (FAB) is a Python-based open source tool that uses sqlalchemy (an ORM for database access), and Flask (a micro web framework):

To drive FAB, you need to provide 2 model files:

  1. models.py: describes your database tables
  2. views.py: describes your pages

open source database python agile approach web app database access flask sqlalchemy orm framework

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Python Flask Tutorial - Database with Flask-SQLAlchemy

Hello! Welcome to the Python Flask Tutorial series. In this series, we'll learn about Flask, a micro framework built using Python, with the help of a project...

Python Flask for Beginners: Build a CRUD Web App with Python and Flask

In this Python Flask tutorial, you'll learn to build CRUD web applications using Python and Flask. Python and Flask can make building a CRUD app super easy.

How long does it take to develop/build an app?

This article covers A-Z about the mobile and web app development process and answers your question on how long does it take to develop/build an app.

What is Flask - Python Web Framework

What is Flask ? Flask is a web framework. This means flask provides you with tools, libraries and technologies that allow you to build a web application.

Best Web App Ideas To Make Money In 2021 - Application Startup Guide

14 Cool Web App Ideas for application business to make money. Coming up with more profitable Startup Web App Ideas in 2021.