{"id":1674,"date":"2009-08-03T08:53:54","date_gmt":"2009-08-03T07:53:54","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/1674-sqlite-c-port-raises-hopes-for-a-silverlight-local-database-manager.html"},"modified":"2009-08-03T08:53:54","modified_gmt":"2009-08-03T07:53:54","slug":"sqlite-c-port-raises-hopes-for-a-silverlight-local-database-manager","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/1674-sqlite-c-port-raises-hopes-for-a-silverlight-local-database-manager.html","title":{"rendered":"SQLite C# port raises hopes for a Silverlight local database manager"},"content":{"rendered":"

Yesterday programmer Noah Hart announced<\/a> a port of SQLite<\/a> to C#:<\/p>\n

\n

I am pleased to announce that the C# port is done to the point where others can look at it.<\/p>\n<\/blockquote>\n

Unfortunately the code was taken offline almost immediately afterwards, thanks to the intervention of the author of SQLite, D Richard Hipp:<\/p>\n

\n

Noah, you are welcomed, even encouraged, to take the source code to SQLite and translate it in any way you want and do whatever you want with it. But you need to make it abundantly clear to everyone on your site and in the comments of your source code that your code is not<\/strong> the original SQLite … SQLite is a registered trade mark. If I don’t defend the trademark, then I could lose it. So, I really do need to insist that you not use the name "SQLite" for your product. <\/p>\n<\/blockquote>\n

The reason given is that Dr Hipp does not want to receive support requests for the port, though the intervention is a little surprising since there are other 3rd party adaptions out there that do use the SQLite name, though these generally modify or wrap the original code rather than porting it completely. <\/p>\n

Still, Hart has taken it in his stride and it looks as if the code may be back soon under the name sqlsharp \u2013 a Google code project<\/a> with that name has been created. I hope this is the name since I suggested it<\/a>, though it is rather an obvious one and I might not have been the first.<\/p>\n

Why the interest? First, it\u2019s always interesting to compare languages. Currently, Hart says his executable compiles to 528kb vs 506kb for the native version, and performs 3-5 times more slowly<\/a> (results in rows per second):<\/p>\n\n\n\n\n\n\n\n
Test<\/td>\nSQLite3 C#<\/td>\nSQLite3<\/td>\n<\/tr>\n
Inserts<\/td>\n300K<\/td>\n1300K<\/td>\n<\/tr>\n
Selects<\/td>\n1500K<\/td>\n8450K<\/td>\n<\/tr>\n
Updates<\/td>\n60K<\/td>\n300K<\/td>\n<\/tr>\n
Deletes<\/td>\n250K<\/td>\n700K<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Although that may seem disappointing, SQLite is remarkably fast so even 5 times slower is still acceptable in many contexts; and there are no doubt many possibilities for optimisation.<\/p>\n

What\u2019s the point? Hart says it was a C# learning exercise, which is fair enough. Others are hopeful for a local database manager for Microsoft Silverlight, writing to isolated storage. Competitor Adobe AIR<\/a> includes SQLite in the runtime, as does Google Gears<\/a>.<\/p>\n

Silverlight may a stretch for Hart\u2019s port. Silverlight does not allow platform invoke or code marked as unsafe; and while there are apparently only a few p\/invoke calls I\u2019m guessing there may be many unsafe sections since the original SQLite makes heavy use of pointers.*<\/p>\n

Although Silverlight is an implementation of the .NET Framework, it does not include the System.Data namespace. It does include System.Linq.<\/p>\n

There are a few other efforts at creating a local database manager for Silverlight, including McObject\u2019s Perst<\/a>, db4o (work in progress<\/a>), and Silverlight Database<\/a> which works by persisting XML.<\/p>\n

*Update<\/strong>: the project has now been published as csharp-sqlite<\/a>, which is an excellent name; it looks as if Hipp relented to some extent. Now that I\u2019ve seen the code I find I\u2019m wrong about unsafe sections. In fact, I added C#-Sqlite to a Silverlight project and it failed to compile with a mere 53 errors, many of them related to file locking \u2013 possibly less necessary in isolated storage? A Silverlight port looks feasible. <\/p>\n

Technorati Tags: silverlight<\/a>,sqlite<\/a>,sqlsharp<\/a>,database<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

Yesterday programmer Noah Hart announced a port of SQLite to C#: I am pleased to announce that the C# port is done to the point where others can look at it. Unfortunately the code was taken offline almost immediately afterwards, thanks to the intervention of the author of SQLite, D Richard Hipp: Noah, you are … Continue reading SQLite C# port raises hopes for a Silverlight local database manager<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,55,77,80,94],"tags":[],"class_list":["post-1674","post","type-post","status-publish","format-standard","hentry","category-database","category-microsoft","category-silverlight","category-software-development","category-visual-studio"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/1674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=1674"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/1674\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=1674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=1674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=1674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}