This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I am currently using Lightspeed with SQL Server. I have a need to run my app on a disconnected laptop, and then sync once the laptop has network access. I could use SQL Server Express, but that requires a full install of SQL, and consumes a lot of resources. My first thought was Firebird embedded, which would be a great choice, but you have deprecated your support. My second choice would be VistaDB, which seems to back from the dead and working well, but you have deprecated your support for that too. The only thought I have left is SQLite, but I found it to be too slow doing the complex queries my application executes. Do you have a recommendation on what to use that will be supported now, and in the future. My entire app is written using LightSpeed, so at this point I am not in control of my own destiny. While I am pleased with the product, I am worried, as I have not seen any new releases in several years now (pay my support every year though) and I see support for databases like firebird and vistadb being abandoned. I hope I have not invested man-years of work into a dead-end product. |
|
|
|
|
I can't comment on the LightSpeed roadmap (I share your concerns). Could use Microsoft LocalDB? |
|
|
|
|
Microsoft LocalDB would be a good choice as we wont be deprecating support for SQL Server anytime soon. We dropped support for Firebird many versions ago as noted here: http://www.mindscapehq.com/documentation/lightspeed/Working-with-Database-Providers/Firebird We were planning on adding support for VistaDB 5 however there was too much variance between versions 4 and 5 meaning a whole new provider would have to be developed to support it so we had to drop this. We still have support for VistaDB 4 for customers still using that version.
|
|
|
|
