Re: Databases for Local apps

[Joseph Cooney]

My vote would be for sqlite. Iirr it supports EF, is quite fast and rock solid.

On 27/03/2011, at 12:20 PM, Stephen Price  wrote:

> Hey all,
>  
> Was thinking about a small app and it's not big enough to need an SQL 
> database. I want it to be a single user deal and i'm just thinking ahead 
> should it become commercial. I don't want a consumer (ie consumer targetted 
> app, not enterprise) to have to have SQL or SQL Express installed to use it.
>  
> I've heard of SQLite but not sure if there are other alternatives. I'd like 
> .Net support and Linq and single file based if possible. What have other 
> people used for such an app?
>  
> cheers,
> Stephen
>  
>  

RE: Databases for Local apps

[Greg Keogh]

I've been waiting for someone to use -

http://simonwillison.net/static/2010/redis-tutorial/

Let us know how it goes.

 

I can't see any managed code library to use Redis. It says it's scalable,
but then it says it stores everything in memory. It claims to be basically a
key-value store (I use Managed Esent PersistentDictionary class for that)).
I would also be curious to hear if anyone has used it and thinks it has
anything to offer over the other more famous and popular non-big-name DBs
like Raven, SQLLite, etc.

 

Greg (K)

Re: Databases for Local apps

[Greg Wood]

I've been waiting for someone to use -

http://simonwillison.net/static/2010/redis-tutorial/

Let us know how it goes.



Greg Wood
g...@woodgreg.com
0417044439



On Mon, Mar 28, 2011 at 11:16 AM, Greg Keogh  wrote:
> ESENT looks... interesting. Sounds similar to Isolated storage. (the key'd
> value part of it anyhow)
>
> No, quite different. Isolated Storage is just a piece of the file system.
> ESENT is a complete ISAM database. The C API is quite low-level and fiddly.
> The ManagedEsent project puts a managed wrapper around the API.
>
> Greg

RE: Databases for Local apps

[Greg Keogh]

ESENT looks... interesting. Sounds similar to Isolated storage. (the key'd
value part of it anyhow)

No, quite different. Isolated Storage is just a piece of the file system.
ESENT   is a
complete ISAM database. The C API is quite low-level and fiddly. The
ManagedEsent
  project puts a managed wrapper around the API.

Greg

Re: Databases for Local apps

[Stephen Price]

Yeah I remember you talking about it. If you are still using it then it must
be good. I don't recall any frustrated ranting from you about it so it must
be pretty good. (still talking to me now?)

Oh, and I second your vote to change it to "Documentation" award.
Alternatively we could assign you "beta tester" status for the list. (how
bout now? still talking to me? ;)

ESENT looks... interesting. Sounds similar to Isolated storage. (the key'd
value part of it anyhow)
More to look at and research. Seems to be the way, the more research you do
into a topic the more you find to learn about.

thanks,
Stephen

On Sun, Mar 27, 2011 at 4:40 PM, Greg Keogh  wrote:

> Stephen (I’m still talking to you)
>
>
>
> Remember my posts on this in the last year? I am quite happy with SQL CE as
> it’s got the complete familiar feel of the full SQL (without sprocs and
> stuff), but you have to live with a 3MB install footprint for the
> prerequisite. You can probably make the app installer “demand” the SQL CE be
> a prerequisite and give the dumb user a nice experience, but I haven’t
> explored that.
>
>
>
> I tried SQL Lite and was quite impressed, as it has zero install footprint
> and you get a complete ADO.NET provider. I just got hung up on some
> technical quandaries about DateTime columns and decided to return to it
> later, which I’m sure I will.
>
>
>
> The dark horse is of course ESENT ,
> which I’ve raved about before as a hidden gem inside Windows. I’m using it
> in two production apps now, but I wrote a wrapper library around the
> low-level managed API translation. The downside of this is the learning
> curve to get the hang of how it works. It’s quite simple, but has a peculiar
> style that you have to get your head around.
>
>
>
> Greg
>

Re: Databases for Local apps

[Stephen Price]

Exchange is a dark horse? Or a hidden gem?

On Sun, Mar 27, 2011 at 5:25 PM, David Connors  wrote:

> On Sun, Mar 27, 2011 at 6:40 PM, Greg Keogh  wrote:
>
>> The dark horse is of course ESENT ,
>> which I’ve raved about before as a hidden gem inside Windows.
>>
>
> I take it you have never owned/managed an Exchange server.
>
> --
> *David Connors* | da...@codify.com | www.codify.com
> Software Engineer
> Codify Pty Ltd
> Phone: +61 (7) 3210 6268 | Facsimile: +61 (7) 3210 6269 | Mobile: +61 417
> 189 363
> V-Card: https://www.codify.com/cards/davidconnors
> Address Info: https://www.codify.com/contact
>
>

Re: Databases for Local apps

[David Connors]

On Sun, Mar 27, 2011 at 6:40 PM, Greg Keogh  wrote:

> The dark horse is of course ESENT ,
> which I’ve raved about before as a hidden gem inside Windows.
>

I take it you have never owned/managed an Exchange server.

-- 
*David Connors* | da...@codify.com | www.codify.com
Software Engineer
Codify Pty Ltd
Phone: +61 (7) 3210 6268 | Facsimile: +61 (7) 3210 6269 | Mobile: +61 417
189 363
V-Card: https://www.codify.com/cards/davidconnors
Address Info: https://www.codify.com/contact

RE: Databases for Local apps

[Greg Keogh]

Stephen (I'm still talking to you)

 

Remember my posts on this in the last year? I am quite happy with SQL CE as
it's got the complete familiar feel of the full SQL (without sprocs and
stuff), but you have to live with a 3MB install footprint for the
prerequisite. You can probably make the app installer "demand" the SQL CE be
a prerequisite and give the dumb user a nice experience, but I haven't
explored that.

 

I tried SQL Lite and was quite impressed, as it has zero install footprint
and you get a complete ADO.NET provider. I just got hung up on some
technical quandaries about DateTime columns and decided to return to it
later, which I'm sure I will.

 

The dark horse is of course ESENT  ,
which I've raved about before as a hidden gem inside Windows. I'm using it
in two production apps now, but I wrote a wrapper library around the
low-level managed API translation. The downside of this is the learning
curve to get the hang of how it works. It's quite simple, but has a peculiar
style that you have to get your head around.

 

Greg

Re: Databases for Local apps

[David Loo]

I have used Embedded MySQL which means that you don't have to connect to 
a remote server. You can download the .NET Connector for free from 
MySQL.com.


On 27/03/11 10:20, Stephen Price wrote:

Hey all,
Was thinking about a small app and it's not big enough to need an SQL 
database. I want it to be a single user deal and i'm just thinking 
ahead should it become commercial. I don't want a consumer (ie 
consumer targetted app, not enterprise) to have to have SQL or SQL 
Express installed to use it.
I've heard of SQLite but not sure if there are other alternatives. I'd 
like .Net support and Linq and single file based if possible. What 
have other people used for such an app?

cheers,
Stephen

Re: Databases for Local apps

[Stephen Price]

Damn, I keep hitting reply and replying just to the sender, not the list. It
never used to do that. reply used to send to the list.

Anyway, dragging and dropping a datasource table from the Data Sources pane
onto the Xaml designer does nothing. No errors. No output in the output
window. Nada. Tried it on my laptop, and my desktop. Used a simple database
with a single table and field in it. WPF app.

*confused*

I'm either doing something wrong or its broke. maybe Sp1 thing? Anyone got a
spare 5 mins to try this and see if it works?

cheers,
Stephen
On Sun, Mar 27, 2011 at 12:12 PM, Stephen Price wrote:

> Cool, will check it out.
>
> In the meantime I thought I'd walkthrough a simple EF walkthrough...
> http://msdn.microsoft.com/en-us/library/dd465159(VS.100).aspx
>
> The step where you drag and drop the datasource to the designer to generate
> the datasource (step 5 - From the *Data Sources* window, drag the *
> Customers* node to the area under the buttons.) just plain does not work.
> I drag and drop and nothing happens. No errors, nothing.
> Going to try on another machine and see what happens.
> If I knew what it was trying to creat I might be able to add it manually
> but they kind of leave that out of the walkthrough.
>
> cheers,
> Stephen
> On Sun, Mar 27, 2011 at 10:54 AM, Michael Minutillo <
> michael.minuti...@gmail.com> wrote:
>
>> SQL CE 4 works with EF Code first and is a great solution for a small app
>>
>>
>> http://weblogs.asp.net/scottgu/archive/2010/07/16/code-first-development-with-entity-framework-4.aspx
>>  for
>> a good walkthrough of how to use it
>>
>>
>> On Sun, Mar 27, 2011 at 10:20 AM, Stephen Price > > wrote:
>>
>>> Hey all,
>>>
>>> Was thinking about a small app and it's not big enough to need an SQL
>>> database. I want it to be a single user deal and i'm just thinking ahead
>>> should it become commercial. I don't want a consumer (ie consumer targetted
>>> app, not enterprise) to have to have SQL or SQL Express installed to use it.
>>>
>>>
>>> I've heard of SQLite but not sure if there are other alternatives. I'd
>>> like .Net support and Linq and single file based if possible. What have
>>> other people used for such an app?
>>>
>>>  cheers,
>>> Stephen
>>>
>>>
>>>
>>
>>
>

Re: Databases for Local apps

[Michael Minutillo]

SQL CE 4 works with EF Code first and is a great solution for a small app

http://weblogs.asp.net/scottgu/archive/2010/07/16/code-first-development-with-entity-framework-4.aspx
for
a good walkthrough of how to use it

On Sun, Mar 27, 2011 at 10:20 AM, Stephen Price wrote:

> Hey all,
>
> Was thinking about a small app and it's not big enough to need an SQL
> database. I want it to be a single user deal and i'm just thinking ahead
> should it become commercial. I don't want a consumer (ie consumer targetted
> app, not enterprise) to have to have SQL or SQL Express installed to use it.
>
>
> I've heard of SQLite but not sure if there are other alternatives. I'd
> like .Net support and Linq and single file based if possible. What have
> other people used for such an app?
>
> cheers,
> Stephen
>
>
>

Databases for Local apps

[Stephen Price]

Hey all,

Was thinking about a small app and it's not big enough to need an SQL
database. I want it to be a single user deal and i'm just thinking ahead
should it become commercial. I don't want a consumer (ie consumer targetted
app, not enterprise) to have to have SQL or SQL Express installed to use it.


I've heard of SQLite but not sure if there are other alternatives. I'd
like .Net support and Linq and single file based if possible. What have
other people used for such an app?

cheers,
Stephen