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 g...@mira.net wrote: ESENT looks... interesting. Sounds similar to Isolated storage.

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

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 step...@littlevoices.com 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

Re: Databases for Local apps

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

Re: Databases for Local apps

2011-03-27 Thread David Connors
On Sun, Mar 27, 2011 at 6:40 PM, Greg Keogh g...@mira.net wrote: The dark horse is of course ESENT http://managedesent.codeplex.com/, 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* |

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 da...@codify.com wrote: On Sun, Mar 27, 2011 at 6:40 PM, Greg Keogh g...@mira.net wrote: The dark horse is of course ESENT http://managedesent.codeplex.com/, which I’ve raved about before as a hidden

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

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 http://en.wikipedia.org/wiki/Extensible_Storage_Engine is a complete ISAM database. The C API is quite low-level and

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

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 step...@littlevoices.comwrote:

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.