James Pierce is a professor of design and interactive media at Belmont University in Nashville, TN. He is also a co-founder of Venture360, a Software-as-a-Service platform for private equity investment.
Most potential users will want to try out the software or service before committing any time and money. Often this is where the age-old demo account comes into play. However, anyone who has ever implemented a demo account can attest to the problems associated. In this article, James Pierce brings you a solution: SQLite. It’s commonly known that SQLite does not handle multiple threads since the entire database is locked during a write command, which is one of the reasons why you should not use it in a normal production environment. However, in his solution, a separate SQLite file is used for each user demoing the software.
Read more…
