Reply to thread

Message

I understand that MP has been moving towards small footprint databases over the years, and away from the more expensive solutions like SQL Server, especially with MP2. Although SQLite cannot work for a normal data driven business environment, where you have to have an enterprise level database engine to handle multiple users, I think there are some environments, like MP, where SQLite can work.

I believe I've come up with a workable solution for MP for a multi-user setup, but only because MP only writes to the database for a fraction of the time it is in use. SQLite is okay for multiple reads and occasional writes, but I don't think it would be workable if the user time at the front-end and back-end were more equal. I've had to use some pretty unusual techniques to get this to work when a larger footprint database would be much easier to program for.

But SQLite is free and it's small, with virtually no overheads. So I think it was worth the effort. It makes it available to everyone.

<blockquote data-quote="Anthony Vaughan" data-source="post: 1286681" data-attributes="member: 153283">I understand that MP has been moving towards small footprint databases over the years, and away from the more expensive solutions like SQL Server, especially with MP2. Although SQLite cannot work for a normal data driven business environment, where you have to have an enterprise level database engine to handle multiple users, I think there are some environments, like MP, where SQLite can work.I believe I've come up with a workable solution for MP for a multi-user setup, but only because MP only writes to the database for a fraction of the time it is in use. SQLite is okay for multiple reads and occasional writes, but I don't think it would be workable if the user time at the front-end and back-end were more equal. I've had to use some pretty unusual techniques to get this to work when a larger footprint database would be much easier to program for.But SQLite is free and it's small, with virtually no overheads. So I think it was worth the effort. It makes it available to everyone.</blockquote>

[QUOTE="Anthony Vaughan, post: 1286681, member: 153283"] I understand that MP has been moving towards small footprint databases over the years, and away from the more expensive solutions like SQL Server, especially with MP2. Although SQLite cannot work for a normal data driven business environment, where you have to have an enterprise level database engine to handle multiple users, I think there are some environments, like MP, where SQLite can work. I believe I've come up with a workable solution for MP for a multi-user setup, but only because MP only writes to the database for a fraction of the time it is in use. SQLite is okay for multiple reads and occasional writes, but I don't think it would be workable if the user time at the front-end and back-end were more equal. I've had to use some pretty unusual techniques to get this to work when a larger footprint database would be much easier to program for. But SQLite is free and it's small, with virtually no overheads. So I think it was worth the effort. It makes it available to everyone. [/QUOTE]