Re: Extensible Storage Engine

[Michael Minutillo]

Hi Greg,

I know Ayende has used Esent in a few projects and he uses this
implementation http://github.com/ayende/managed-esent which initially came
from here http://managedesent.codeplex.com/

You can see it in use in

A persistent hash-table http://github.com/ayende/rhino-pht
A distributed hash-table http://github.com/ayende/rhino-dht
An Async Queuing system http://github.com/ayende/rhino-queues


Michael M. Minutillo
Indiscriminate Information Sponge
Blog: http://wolfbyte-net.blogspot.com


On Sat, Aug 7, 2010 at 2:55 PM, Greg Keogh  wrote:

>  Folks, a couple of years ago I asked in here for recommendations about
> what lightweight “in-process” database I could use easily from .NET apps. I
> eventually settled upon SQL Server Compact Edition due to familiarity with
> its big brother and the footprint was quite small, just a single MSI install
> of a few MB of runtime files. There is another contender that no one
> mentioned back then...
>
>
>
> Only days ago I pinned down the existence of the Extensible Storage 
> Engine(
> MSDN ). I
> knew something like this was out there for Exchange Server storage, but I
> was misled by comments that it was the JET engine. The article link
> clarifies what “JET” means.
>
>
>
> It turns out that ESE is implemented in a single ESENT.DLL with a
> documented API, and it’s an ISAM file of all things (memories of COBOL come
> flooding back!).
>
>
>
> It would be fabulous to be able to use ESE from .NET projects, but sadly,
> there is no managed wrapper around ESE, and one look at the huge C API
> scared me off any hobby attempts to make one. Yesterday on CodeProject I saw
> that someone is planning to release a managed wrapper, but it’s still so
> early that nothing is available for download. I also saw that someone has
> implemented collections using ESE as the backing storage, which seems a bit
> pointless.
>
>
>
> Anyway, just a heads up -- Greg
>
>
>

Re: Extensible Storage Engine

[Craig van Nieuwkerk]

Have you tried this?

http://managedesent.codeplex.com/

Craig

On Sat, Aug 7, 2010 at 4:55 PM, Greg Keogh  wrote:
> Folks, a couple of years ago I asked in here for recommendations about what
> lightweight “in-process” database I could use easily from .NET apps. I
> eventually settled upon SQL Server Compact Edition due to familiarity with
> its big brother and the footprint was quite small, just a single MSI install
> of a few MB of runtime files. There is another contender that no one
> mentioned back then...
>
>
>
> Only days ago I pinned down the existence of the Extensible Storage Engine
> (MSDN). I knew something like this was out there for Exchange Server
> storage, but I was misled by comments that it was the JET engine. The
> article link clarifies what “JET” means.
>
>
>
> It turns out that ESE is implemented in a single ESENT.DLL with a documented
> API, and it’s an ISAM file of all things (memories of COBOL come flooding
> back!).
>
>
>
> It would be fabulous to be able to use ESE from .NET projects, but sadly,
> there is no managed wrapper around ESE, and one look at the huge C API
> scared me off any hobby attempts to make one. Yesterday on CodeProject I saw
> that someone is planning to release a managed wrapper, but it’s still so
> early that nothing is available for download. I also saw that someone has
> implemented collections using ESE as the backing storage, which seems a bit
> pointless.
>
>
>
> Anyway, just a heads up -- Greg
>
>

RE: Extensible Storage Engine

[Ian Thomas]

The ESENT seems to have some very convenient features - like the long value
columns. I'm glad you raised the topic / re-discovered it. 

 

  _  

Ian Thomas
Victoria Park, Western Australia

  _  

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Saturday, 7 August 2010 2:55 PM
To: 'ozDotNet'
Subject: Extensible Storage Engine

 

Folks, a couple of years ago I asked in here for recommendations about what
lightweight "in-process" database I could use easily from .NET apps. I
eventually settled upon SQL Server Compact Edition due to familiarity with
its big brother and the footprint was quite small, just a single MSI install
of a few MB of runtime files. There is another contender that no one
mentioned back then...

 

Only days ago I pinned down the existence of the Extensible
  Storage Engine
(MSDN  ). I
knew something like this was out there for Exchange Server storage, but I
was misled by comments that it was the JET engine. The article link
clarifies what "JET" means.

 

It turns out that ESE is implemented in a single ESENT.DLL with a documented
API, and it's an ISAM file of all things (memories of COBOL come flooding
back!).

 

It would be fabulous to be able to use ESE from .NET projects, but sadly,
there is no managed wrapper around ESE, and one look at the huge C API
scared me off any hobby attempts to make one. Yesterday on CodeProject I saw
that someone is planning to release a managed wrapper, but it's still so
early that nothing is available for download. I also saw that someone has
implemented collections using ESE as the backing storage, which seems a bit
pointless.

 

Anyway, just a heads up -- Greg

 

RE: Extensible Storage Engine

[Greg Keogh]

Aha! I just went back to the page again ... I was tricked yesterday when I
quickly read the ManagedEsent   page. I
downloaded the DLL of interop and I see it has a sample console app which
seems to perform some quite complex work.

 

It looks like they've implemented a fair bit of the C API, and I can see
some samples and documentation. I hope it's easy to use, as I regularly have
a need for this sort of really lightweight database with little to no
footprint. I'm going to send these guys an email of congratulations.

 

Greg

Re: Extensible Storage Engine

[Joseph Cooney]

I wanted to do a tech.ed talk on ESE but it was rejectedah, what might
have been.

On Sat, Aug 7, 2010 at 4:55 PM, Greg Keogh  wrote:

>  Folks, a couple of years ago I asked in here for recommendations about
> what lightweight “in-process” database I could use easily from .NET apps. I
> eventually settled upon SQL Server Compact Edition due to familiarity with
> its big brother and the footprint was quite small, just a single MSI install
> of a few MB of runtime files. There is another contender that no one
> mentioned back then...
>
>
>
> Only days ago I pinned down the existence of the Extensible Storage 
> Engine(
> MSDN ).
> I knew something like this was out there for Exchange Server storage, but I
> was misled by comments that it was the JET engine. The article link
> clarifies what “JET” means.
>
>
>
> It turns out that ESE is implemented in a single ESENT.DLL with a
> documented API, and it’s an ISAM file of all things (memories of COBOL come
> flooding back!).
>
>
>
> It would be fabulous to be able to use ESE from .NET projects, but sadly,
> there is no managed wrapper around ESE, and one look at the huge C API
> scared me off any hobby attempts to make one. Yesterday on CodeProject I saw
> that someone is planning to release a managed wrapper, but it’s still so
> early that nothing is available for download. I also saw that someone has
> implemented collections using ESE as the backing storage, which seems a bit
> pointless.
>
>
>
> Anyway, just a heads up -- Greg
>
>
>



-- 
Joseph Cooney

http://jcooney.net

Re: Extensible Storage Engine

[silky]

On Sun, Aug 8, 2010 at 11:38 AM, Joseph Cooney  wrote:
> I wanted to do a tech.ed talk on ESE but it was rejectedah, what might
> have been.

I'd've attended that!


> --
> Joseph Cooney
>
> http://jcooney.net

-- 
silky

http://dnoondt.wordpress.com/

"Every morning when I wake up, I experience an exquisite joy — the joy
of being this signature."