PostgreSQL vs SQLite

Why do we need a database

All of the important data in a web application must be saved and made available for all processes responding to client requests in the future. This ongoing availability is called data persistence. There are many options for persisting data. The data can be stored in a file or across files, or it can be stored in the memory and saved regularly. If we were to pursue one of these choices, we would soon run into issues with:

• Enforcing data integrity
• Handling multiple concurrent servers accessing the data
• Dealing with sudden outages