{"id":1681,"date":"2009-08-06T10:46:50","date_gmt":"2009-08-06T09:46:50","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/1681-c-sqlite-now-published.html"},"modified":"2009-08-06T10:46:50","modified_gmt":"2009-08-06T09:46:50","slug":"c-sqlite-now-published","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/1681-c-sqlite-now-published.html","title":{"rendered":"C#-SQLite now published"},"content":{"rendered":"

Noah Hart has published<\/a> his port of SQLite<\/a> to C#. The project is called C#-SQLite. The main SQLite author, D Richard Hipp, originally said that the project should not include SQLite anywhere in its name, but has now relented<\/a>:<\/p>\n

\n

I think I would be comfortable with a name like C#-SQLite. The prefix makes it clear that it is a reimplementation, not the original. People notice prefixes much more readily than suffixes. There is also precedent for changing a prefix for a reimplementation. Lucene, for example, was ported to C-Lucene. I’m sure there are others. <\/p>\n

The whole point of this exercise it to avoid confusing people. Folks who use C#-SQLite need to be fully aware that what they are using is distinct and separate from the original SQLite. As long as that one condition is met, I am happy.<\/p>\n<\/blockquote>\n

I downloaded the code, compiled in Visual Studio 2008 (requires project conversion), ran the shell and tried a couple of commands. It works!<\/p>\n

<\/p>\n

Of course there are already a million ways to use SQLite from .NET, but they all require platform invoke to native code, which is not allowed in some scenarios for security and\/or cross platform reasons \u2013 Silverlight being a prime example.<\/p>\n

Next question: how hard will it be to get this working in a Silverlight project?<\/p>\n

See also SQLite C# port raises hopes for a Silverlight local database manager<\/a> which has some early performance results.<\/p>\n

Technorati Tags: sqlite<\/a>,c#<\/a>,c#-sqlite<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

Noah Hart has published his port of SQLite to C#. The project is called C#-SQLite. The main SQLite author, D Richard Hipp, originally said that the project should not include SQLite anywhere in its name, but has now relented: I think I would be comfortable with a name like C#-SQLite. The prefix makes it clear … Continue reading C#-SQLite now published<\/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":[2,77,80,94],"tags":[],"class_list":["post-1681","post","type-post","status-publish","format-standard","hentry","category-net","category-silverlight","category-software-development","category-visual-studio"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/1681","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=1681"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/1681\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=1681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=1681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=1681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}