I will not buy ScriptCase again, due to the unreliable buggy SQLite used as it’s data store. SQLite kept blowing my hard won code into oblivion. I started so many project, that were just destroyed by ScriptCase deleting my code. Here is what I suggest for ScriptCase:
-
Focus only on the front end, presentation layer. Let me use my own choice of DB to store all the “mechanics” code in. Stop trying to make an “all in one” package. That’d be nice in some ways, but… very difficult to do, and it cuts you off from many vertical markets.
-
Because of 1 above, disconnect from PHP completely. Instead, pivot to REST API based on Delphi DMVCF (just released version) and Lazarus.(Brook 5, not out yet). Both those technologies require front end. They are super quick, reliable and cave-man simple to use. (based on my intro to Brook 3, and my successful project using DMVCF). Both contain auth-and-auth capability as part of their framework.
Lazarus is a slightly better choice due to it’s cross platform compilability, but, Brook 5 is not available yet. Contacting the maker of Brook for Lazarus may prove fruitful. The ScriptCase team is highly skilled and motivated, but I can never return to ScriptCase if it is locked into PHP and SQLite. It seems as if you are trying to do too much with one technology, and the product is strong in some areas, and really weak in other areas. Partnering with Danielle Teti or the maker of Brook will open up a whole new world, and you will make money.