We will be running Assisi locally on my PC in order to get the best performance. You said that we can run this in SQL...will SQL Server Express suffice or is that too limited in its functionality to give us the benefits we're trying to get?
Discussion
Wanted to give a quick update on Assisi Cruiser, our upcoming data collector. Our prototype in PowerApps is working OK, but PowerApps has too many restrictions like meant to be online and can only share apps with members of the same computer domain. So now I am also prototyping in Xamarin: the cross platform (iOS, Android & Windows) tool of choice for most serious developers. It's going well and I should have something for others to test soon. Send me a note if you are interested in beta testing! Rich
Hi Paul,
SQL Server Express is fine. It’s has mostly a full SQL Server feature set, but with database size limited to 10 GB. My bet is your database will have a maximum of 1 GB with a fully compiled and expanded inventory. If you start simulating long term plans, then it could get into the multiple GBs. SQL Express is pretty much perfect for single users wanting a more robust database than MS Access.
For your PC, the most important thing is CPU and SSD speed. If you partition the SSD into System and Data partitions, then I’d make System 128 GB and the rest Data.
Good luck with the new PC. It’s always exciting to get an upgrade!
Rich