Stack: Python, PyInstaller, Sqlite, Alembic
This short post shows how to perform an application database upgrade with new version of the application. It covers also the problem of the application packaging.
Database migration are performed with Alembic library. The database is checked and upgrRead full text >>>
The article describes a proposal for solving a problem of evolution the complex algorithms, that operate directly on a database, when we have no unit tests, but we have got access to the real data, on which algorithms operate. Of course, most of the properly written algorithm, should not accessRead full text >>>
Client-server architecture is a popular answer for multi-user, remote applications. Comparing with single-user programs working on the local machine, this architecture always has worse responsiveness. Today's world of multiuser, remote application is dominated by web technology. When starting aRead full text >>>