{"id":11077,"date":"2018-08-15T07:34:13","date_gmt":"2018-08-15T07:34:13","guid":{"rendered":"https:\/\/www.itwriting.com\/blog\/?p=11077"},"modified":"2018-08-15T07:34:13","modified_gmt":"2018-08-15T07:34:13","slug":"sqlite-adds-support-for-net-core-2-0-and-net-standard-2-0","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/11077-sqlite-adds-support-for-net-core-2-0-and-net-standard-2-0.html","title":{"rendered":"SQLite adds support for .NET Core 2.0 and .NET Standard 2.0"},"content":{"rendered":"

\"image\"<\/a><\/p>\n

The open source SQLite database engine<\/a> goes from strength to strength, largely by not changing that much: it remains small, fast, reliable, cross-platform, and completely free. The engine is written in C but there are many wrappers for different languages, a recent addition being .NET Core 2.0 and .NET Standard 2.0:<\/p>\n

\n

1.0.109.0: Add preliminary support for .NET Core 2.0 and the .NET Standard 2.0. Pursuant to [5c89cecd1b]<\/a>.<\/p>\n<\/blockquote>\n

.NET developers using SQLite are fortunate in that System.Data.SQLite, the .NET provider, is supported by the SQLite team and has its own sub-site<\/a> on sqlite.org. \u201cThe SQLite team is committed to supporting System.Data.SQLite long-term,\u201d states the home page.<\/p>\n

The addition of .NET Core 2.0 support is valuable, in part because .NET Core is where Microsoft\u2019s energy is now focused, and will make it easier to write cross-platform code. There is a snag though: there is no official cross-platform GUI for .NET Core, which would be useful for SQLite given that it is a local database engine. However, Microsoft\u2019s Xamarin framework, which is cross-platform, does support .NET Standard 2.0 so this should work though I have not tried it.<\/p>\n

The truth is that almost any framework can be made to work with SQLite. I did some work myself on a wrapper for Delphi<\/a> (Object Pascal) which still has some users today.<\/p>\n

Back in 2007 I interviewed<\/a> SQLite\u2019s creator, Dr Richard Hipp, for Guardian Technology. Worth a read if you are wondering why SQLite, unlike most open source projects, has no licence: it is simply public domain:<\/p>\n

\n

“I looked at all of the licences,” Hipp says, “and I thought, why not just put it in the public domain? Why have these restrictions on it? I never expected to make one penny. I just wanted to make it available to other people to solve their problem.”<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

The open source SQLite database engine goes from strength to strength, largely by not changing that much: it remains small, fast, reliable, cross-platform, and completely free. The engine is written in C but there are many wrappers for different languages, a recent addition being .NET Core 2.0 and .NET Standard 2.0: 1.0.109.0: Add preliminary support … Continue reading SQLite adds support for .NET Core 2.0 and .NET Standard 2.0<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,80,1519],"tags":[105,310,861],"class_list":["post-11077","post","type-post","status-publish","format-standard","hentry","category-database","category-software-development","category-tech","tag-net-core","tag-database","tag-sqlite"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/11077","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=11077"}],"version-history":[{"count":1,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/11077\/revisions"}],"predecessor-version":[{"id":11078,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/11077\/revisions\/11078"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=11077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=11077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=11077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}