Re: Databases for Local apps

2011-03-28 Thread 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 > s

RE: Databases for Local apps

2011-03-28 Thread 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 us

Re: Databases for Local apps

2011-03-28 Thread 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 >

RE: Databases for Local apps

2011-03-27 Thread 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 an

Re: Databases for Local apps

2011-03-27 Thread 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 "b

Re: Databases for Local apps

2011-03-27 Thread 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. >> >

Re: Databases for Local apps

2011-03-27 Thread 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.c

RE: Databases for Local apps

2011-03-27 Thread 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 in

Re: Databases for Local apps

2011-03-26 Thread 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

Re: Databases for Local apps

2011-03-26 Thread 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. Trie

Re: Databases for Local apps

2011-03-26 Thread 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 thinki

Databases for Local apps

2011-03-26 Thread 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 u