Build a CRUD application with Flask and SQLAlchemy

1

MariaDB

We want to remember our users' input, so we'll want to be able to add items to a database. We'll use the popular SQLite database, which comes bundled with the standard installation of Python. It is a file-based database, so we can store our data in a file on our file system, without needing to install a huge Relational Database Management System (RDBMS). We'll use SQLite through SQLAlchemy, which provides a higher level abstraction. This means that we could easily use a different database, such as PostgreSQL or MariaDB, and we wouldn't need to change our codebase. SQLAlchemy also allows us to do database level operations in a more Pythonic way.

#Databases #Relational Databases #NoSQL Databases 42 social mentions

2

Jinja2

For our application above, we defined the string "My flask app" within our Python code. This was okay, as it was a single line, but as our front-end code grows, it will be cumbersome to define everything in our Python file. Flask allows for separation of concerns though so-called "templates." These are usually .html files, with some Python logic mixed in through the Jinja template engine language. Let's add a template to our application to house all of our front-end code.

#Development #Javascript UI Libraries #Tool 4 social mentions

3

Bootstrap

Make the application more aesthetically pleasing by adding some CSS, either custom CSS or through a framework like Bootstrap.

#Developer Tools #Design Tools #Web Frameworks 362 social mentions