http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660If only *someone* would combine ESE with Firefox sqlite, shake and not crash http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment15http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment15Tue, 30 Dec 2008 16:45:06 GMTCool, Json.NET. Let me know how you get on with it http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment14http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment14Tue, 23 Dec 2008 22:14:04 GMTInteresting, I would be more prone to use Sqlite since it's relational and deals with the same programming constructs that I am familiar with. http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment13http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment13Tue, 23 Dec 2008 18:51:52 GMTNot really. It doesn't have SQL. And it doesn't have joins. It is literally structured storage. You get indexes, and the over experience is very similar to the one you get from BDB. http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment12http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment12Tue, 23 Dec 2008 17:24:20 GMTThanks for the heads up. What we need now is LINQ to Esent. See [oakleafblog.blogspot.com/.../...linq-to-esent.html](http://oakleafblog.blogspot.com/2008/12/whos-ready-to-develop-linq-to-esent.html). --rj http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment11http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment11Tue, 23 Dec 2008 16:55:20 GMTSounds like an embedded MultiValue database, like D3 or OpenQM http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment10http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment10Tue, 23 Dec 2008 16:29:36 GMTIf the database can contain tables, what's stopping you from using it as a not-really-that-good database? Even Excel can be used as a relational database, can't it? http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment9http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment9Tue, 23 Dec 2008 16:26:58 GMTChris, No, it is not the same API nor is it the same engine. Different implementation that happen to share the same prefix, I am afraid. http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment8http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment8Tue, 23 Dec 2008 15:58:44 GMTWow, the second I saw the word Jet I remembered this beast. I wonder if it is still using the same original MS Access engine it was using before. I'm curious to see how far you take it, but I remember many long nights trying to repair corrupt jet databases several years ago. http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment7http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment7Tue, 23 Dec 2008 15:55:22 GMTNot really, this is a non relational store. http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment6http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment6Tue, 23 Dec 2008 15:50:14 GMTIt is not registry, it is stored in a file, which you control http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment5http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment5Tue, 23 Dec 2008 15:40:43 GMTMark, This is not a relational DB, NH assumes RDBMS. http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment4http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment4Tue, 23 Dec 2008 15:23:21 GMTWow, that's interesting. Can this be used as a normal relational database? http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment3http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment3Tue, 23 Dec 2008 15:07:24 GMTHow is this not just a relational registry? Is there some sort of isolation mechanism to separate processes from accessing each other's data? http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment2http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment2Tue, 23 Dec 2008 14:29:50 GMTI'm curious ... what do you think how complex is the task to create a ESENT backend for NHibernate? Is it even possible? http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment1http://ayende.com/3769/hidden-windows-gems-extensible-storage-engine#comment1Tue, 23 Dec 2008 12:36:04 GMT