SQLA Flask Demo: Planets database Displaying data in a Gridjs Data Table

Published: 21 November 2023
on channel: Thomas Blum

This video is the third in a series. It uses Python, SQLAlchemy (SQLA) and Flask to create and populate a single-table database with a table with data about planets. Flask passes the data resulting from querying the data over to a web page (route). The first route using Jinja to display the data (a list of dictionaries) in an HTML table. The second route adds links to jQuery and datatable CDN's to add pagination, searching and sorting functionality. The new route, the third, uses the more modern JavaScript library gridjs to provide the data-table functionality. Rather like React or Vue, gridjs has JavaScript do most of the work. The HTML is mostly a container for what gridjs "renders". Gridjs wanted two things: 1) columns a list of table headers/columns/fields, and 2) data a list of lists with the corresponding values for all of the records.

Watch video SQLA Flask Demo: Planets database Displaying data in a Gridjs Data Table online without registration, duration hours minute second in high quality. This video was added by user Thomas Blum 21 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 95 once and liked it 1 people.

215