Good News for SQLite Afficionados

Robert Simpson, an "early adopter" of the SQLite database and the .NET Framework 2.0 platform, has his first release of ADO.NET Provider 2.0 for SQLite up on SourceForge. Not only did it compile for me with BETA 2 right out of the box, he's really outdone himself.

This thing supports user-defined functions, and the ProviderFactory model as well: To Quote:

Features:



  • DbProviderFactory support, just add the XML below at the machine.config and/or app.config level.

  • Full support for ATTACH'ed databases.  Exposed as Catalogs in the
    schema.  When cloning a connection, all attached databases are automatically
    re-attached to the new connection.

  • DbConnection.GetSchema(...) support includes the MetaDataCollections,
    DataSourceInformation    , Columns, Tables, Views, Catalogs
    and Indexes keywords.

  • Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace
    and detailed schema information even for complex queries.

  • Named and unnamed parameters.

  • Full UTF-8 and UTF-16 support.

  • Multiple simultaneous DataReaders (one DataReader per Command however).

  • Full support for user-defined scalar and aggregate functions, encapsulated into
    an
    easy-to-use base class in which only a couple of overrides are necessary to implement
    new SQL functions.

  • Full support for user-defined collating sequences, every bit as simple to implement
    as user-defined functions and uses the same base class.



In order to use the SQLiteFactory and have the SQLite data provider enumerated in
the DbProviderFactories methods, you must add the following segment into either
your application's app.config or the system's machine.config located in the %SystemRoot%\Microsoft.Net\Framework\v2.xxxx\Config
folder:
 


<configuration>
  <system.data>
    <DbProviderFactories>
      <add name="SQLite Data Provider" invariant="System.Data.SQLite" 
         support="3F" description=".Net Framework Data Provider for SQLite" 
           type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
    </DbProviderFactories>
  </system.data>
</configuration>


You can get your hands on these goodies here,
including the 3.21 version of the SQLite C++ sources as of today, May 25.

Thank YOO, Robert! One Swell Dewd!

Comments

Post a Comment

Popular posts from this blog

FIREFOX / IE Word-Wrap, Word-Break, TABLES FIX

One of the most annoying things a developer (who would normally delight in writing code, not futzing with markup) can have is getting rendering issues between different browsers. The two biggest players are of course Internet Exploder and Firefart (as I lovingly like to refer to each). In most cases that's going to take care of 98 percent of your total site traffic. IE has had a proprietary "word-break" style attribute for a long time, and this made it into the CSS 3.0 spec. But that doesn't necessarily help you with Firefox right now. Firefox literally - (and I consider this completely idiotic, since it's been in their bug database for FIVE YEARS) does not have a reliable CSS style element to force table cell content to break in the middle of a word in order to stop the content from expanding your table / div off the page or over other content on the page. Here's a partial fix, which will work for most tables and browsers. The style declaration (I call it m
Read more

Some observations on Script Callbacks, "AJAX", "ATLAS" "AHAB" and where it's all going.

I've taken a more than cursory interest in the whole Remote Scripting (.NET species) vs. AJAX and now ATLAS discussion, mostly because I started using Remote Scripting since Microsoft first released it, and because I continued to refine it after seeing Brent Ashley's excellent work with JSRS, which was one of the first "real" cross-browser solutions back in 2000 (that's the turn of the Century for you history buffs). Now Bertrand Leroy, a Microsoft guy whose work I like , has authored some very interesting ASP.NET 2.0 script callback stuff that he points to on his blog, and he is obviously (at least, to me he is) involved quite heavily in the development of this new ATLAS infrastructure that they'll preview at PDC. Leroy's most recent post brings to the surface what I agree are the major differences between the "AJAX a - la .NET" approach as popularized by Michael Swartz with his AJAX.NET library, and Leroy's RefreshPanel, the ASP.NET 2.0 b
Read more

IE7 - Vista: "Internet Explorer has stopped Working"

Image
This one was a bitch. All of a sudden for no reason at all, out of the blue, I get this dialog "internet Explorer has stopped working". I didn't install any new software, crap- I didn't do anything! So here I am using FIREFART to go on the internet and find out what to do! Damn! Good thing I've got the sucker on the same machine (I'm not "anti-Firefox", i just don't use it that much except to check my page renderings). The Fix The fix (at least for me): 1) Go into Control Panel, and choose "Internet Options". 2) Under the "Advanced" tab, press the "RESET" button at the lower right: Don't ask me why this happens, or why the fix works. That's a BUG, D00D - I don't care how you slice it!
Read more