Portable Python Projects

Database CRUD

While we could use a basic approach of storing the list of article titles and their unique web link identifiers to a plain-text file, we would then need to be responsible for the code to parse and update that file. As the file grew larger with more entries, the parsing would become slower due to more data to iterate through. And if we need to delete any data from the list, we would also need to maintain the integrity of the rest of the list via a lot of error-checking code.

Fortunately for our project, Python includes built-in support for a rather basic yet powerful and extremely popular database engine called SQLite.^[57] While not nearly as feature-packed as other open source database engines like PostgreSQL,^[58] SQLite is ideal ...