A properly designed database allows us to organize our data in the most efficient manner. We will also have the luxury to access up-to-date and well-curated data. Because a solid design is essential to achieving our goals when working with a database, it is essential that we invest the time to learn good design principles. Designing a database schema is a task that’s easier said than done—but by observing a few tips, principles, and best practices, we’ll be much better positioned for success. This article reviews the concept of Joined Table Inheritance from SQLAlchemy.

PostgreSQL is a feature-rich application, offering advanced features such as materialized views, triggers, and stored procedures. It can handle a very high workload, including data warehouses or highly-scaled web applications, and is noted for its stability.

It is common for web applications to run background tasks. The applications could need to clear unnecessary files or cache, import third-party data, or even periodically send out email newsletters. Thankfully, all Unix-based have a scheduling utility that makes it possible to automate certain tasks.

PDF documents are not editable by nature. They are the sole read-only file format that can’t be altered without leaving a footprint. This allows the effective tracking of changes in respective documents. Encryption can be enabled in the document to protect it wherever it goes, independent of storage or transport. As complex as this entire document creation and encryption process seems to be, Flask allows for the integration of this feature in an application.

As an administrator of an online application, have you been worried about the quality of comments that appear on your site? Comment moderation is an attempt to promote healthy conversations on your platform.

Typically, a user may register and jump into the comments section to experience the application's community. To ensure that warm engagements are maintained throughout, moderators will have first access to all user comments before allowing them into the community.

Rich text is a more exciting way of writing text, where you have the option to add common formatting features such as bold, italics, links, and more, commonly found in 'what you see is what you get' text editors. Additionally, you can have a preview of the text you are writing so as to know what the output will look like eventually.

You probably are already familiar with how to update a table in your flask database, for example, you know how to add a new user who has just registered for an account in your application. This user may want to update their profile image, or simply attach a file needed in a submission. How can you handle this need in your flask application?

Tags are a simple classification system that can be used in a blog post. A tag can be applied to multiple blog posts and, similarly, multiple blog posts can be related to one another outside their category. For example, a blog may have a tag called "Flask". People interested in reading posts related to "Flask" only can click on this link and they will find relevant posts.

The search feature can dramatically improve a user's experience while interacting with an application. A simple form can be added to a web page or the navigation bar to allow a user to quickly retrieve desired results. In this article, you will learn how to implement a very generic approach to building a search functionality such that you can easily switch from one search engine to another.