ScrewTurn Wiki 4.0 CTP 1
August 18th, 2011 by Dario Solera | Filed under Development.Today we’re releasing a CTP refresh for our brand-new 4.0 line. This new version completely replaces the old flat file-based default storage engine with a new one, built with SQL Server CE 4.0. From the outside, everything will work the same.
The rationale behind this decision is very simple: it became too cumbersome for us to maintain two main data storage providers. Using SQL Server CE allows us to use almost the same code for both SQL Server CE and the larger editions of SQL Server. This became particularly important if you consider that we now also have a storage provider for Azure.
You can download the compiled application as well as the source code right from our v4 CTP page. If you’re a dev, don’t forget we have a Mercurial repository at BitBucket.
To build the source code you’ll need to have SQL Server CE installed on your machine (we can’t redistribute the binaries with the source code), but to run the application, you will not need it as it’s set to CopyLocal.
Next up: new search engine based on Lucene.NET.
New Posts
Using SQL Server CE looks reasonable. Do you have any upgrade plans to let people migrate their file-based storage toward SQL Server CE?
Sure, the idea is to implement JSON import-export and backport export to v3.
Dario, Congrats on the CTP. Very smart moving to SQL/Azure, but in looking through the SQLDataProviders .sql files I see that v4.0 SQL objects still have no ScrewTurn-specific prefixes. This would seem to assume that ScrewTurn would have exclusive use of the database and have no other non-wiki objects. Almost every ASPNET app I use implements SQL object prefixes to distinguish it from other SQL objects. Any plans on prefixes? Or any thinking on easily adding prefixes in the source? Doing so in v3.0 is simply not feasible.
Thanks for your input on this.
-Dave
I think it’s the right time to do it
WOOOOOT!!!! That’s exactly what I was thinking. If you were going to do it, it might as well be part of the move away from File Storage to dedicated SQL or some other database-oriented storage. That news really made my day. Have a good one.
Keep up the good work!