http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Alex, I have no range queries, so K/V store is perfect. There is no size limitation for the value http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment15http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment15Thu, 31 Dec 2009 06:45:10 GMTBtw, if simple custom storage is really enough, it's definitely better to use this option - at least, because of flexibility. E.g. if range queries are actually needed, but they can be emulated with sequential key processing (e.g. if key is minute number or something like this), key-value store seems a good option. http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment14http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment14Wed, 30 Dec 2009 22:17:27 GMTIt's probable you'll come to the solution we work on (full-featured integrated database): - Key-value store = no range queries. But in your case there is at least one obvious range query kind: time range queries. - Sessions can be very long in case with other ORMs, so it's possible that it won't be enough to store session data as value part. Just FYI: our original problem was looking very similar. I thought it would be nice to have a simple key-value pair storage for our local databases. http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment13http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment13Wed, 30 Dec 2009 22:13:04 GMTI'm with Jenser and Patrik, you ought to give DB4O a shot. http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment12http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment12Tue, 29 Dec 2009 23:43:33 GMTIsn't the regular SQLite fast enought ? BTW, it would be nice to have a pure managed SQLite version... http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment11http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment11Tue, 29 Dec 2009 10:21:15 GMTI was about to ask the same question as Jenser, have you looked at Db4o? It would be interesting to see if it would cut it. I've never tried it myself but I'd like to get around to it some day. http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment10http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment10Mon, 28 Dec 2009 20:49:17 GMTprotobuf? http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment9http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment9Mon, 28 Dec 2009 18:34:16 GMTScott, That would make me lose something extremely valuable, the xcopy experience, and it would SERIOUSLY complicate my life. http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment8http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment8Mon, 28 Dec 2009 17:16:45 GMTwhat if you redesign it to be an NT service so that you can disconnect the UI from the base functionality. Then you could put a website, silverlight or whatever in front of the database that the service is actually using. http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment7http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment7Mon, 28 Dec 2009 16:15:38 GMTsiagodb looks very promising [ [http://siaqodb.com](http://siaqodb.com)] http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment6http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment6Mon, 28 Dec 2009 14:04:10 GMTThinking outside the box now, but why not build the ability to persist all information to a database with a session tag? Such a database could be handled by NHibernate and it would give some interesting features. Storing the information to a specified database would give the whole team analyzing capabilities. Another 'feature' would be collecting the profiling data during (automated) unit- and regression tests and dynamically assign a session tag (version + date comes into mind). Later a team member could 'open' that session and compare it with a earlier run. Were talking about an ORM profiling tool, so specifying a database server (mssql, oracle, mysql, etc) shouldn't be a problem for most users. Even when profiling an application with an embedded database it's still posible to store the profiling data into a remote database. Visual Studio comes by default with a mssql express installation. I'm sure if I give it some more though I can come up with some more usages. http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment5http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment5Mon, 28 Dec 2009 13:18:36 GMTHave you tried [http://www.db4o.com/DownloadNow.aspx](http://www.db4o.com/DownloadNow.aspx)http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment4http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment4Mon, 28 Dec 2009 12:53:56 GMTIt would appear, that hosting a full-fledged database engine in Silverlight is near to impossible right now (don't know about 4.0 though). Some nice folks at VistaDB craved that idea for a long time now ( [www.vistadb.net/.../...-and-CLR-functionality.aspx](http://www.vistadb.net/blog/post/2007/06/10/Silverlight-and-CLR-functionality.aspx)) http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment3http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment3Mon, 28 Dec 2009 11:31:44 GMTDave, I tried it a while ago, yes. It had numerous problems that made me give it up. http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment2http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment2Mon, 28 Dec 2009 11:31:27 GMTHave you looked at FirebirdSQL yet? It's designed as an embedded database. FirebirdSql also provides a service/daemon for client/server access. The DotnetFirebird project (a subproject from FirebirdSql, much like mysql connector project) comes with both a Windows and a Mono 1.1.x. It also supports the compact framework so you should be able to use it with Silverlight or on a Windows Mobile phone. [http://www.firebirdsql.org/](http://www.firebirdsql.org/) [www.firebirdsql.org/dotnetfirebird/index.html](http://www.firebirdsql.org/dotnetfirebird/index.html) http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment1http://ayende.com/4342/a-persistence-problem-irony-your-name-is#comment1Mon, 28 Dec 2009 11:23:25 GMT