http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660If your test database is small, you can try usng TempDB in local SQL Server and config TempDB fully in memory. Just a thought. Kevin http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment18http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment18Tue, 27 Feb 2007 09:09:23 GMTHmmmm, I may have to recant. I could have sworn that while troubleshooting an issue with Firebird and ActiveRecord that I saw a connection string for using an in-memory database instead of disk based. However, for the life of me I can't find it now. I'll keep looking for it and if I see anything I'll be sure to let you know. Sorry. http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment17http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment17Tue, 27 Feb 2007 06:55:25 GMTTom, I have been unable to find the documentation regard it, can you supply a link to it? http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment16http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment16Tue, 27 Feb 2007 06:04:28 GMTAyende, yes, according to the docs you can run FirebirdSQL in memory. I haven't done so though. http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment15http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment15Tue, 27 Feb 2007 00:52:34 GMTVistaDB? It costs though http://www.vistadb.net/default.asp http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment14http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment14Mon, 26 Feb 2007 21:31:44 GMTI just checked, and it looks like a bug in the dialect. Please file a JIRA about it. At the meantime, you can disable aggressive release mode http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment13http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment13Mon, 26 Feb 2007 19:49:54 GMTAyende, have you got sql ce to work with the aggressive connection release mode in NHibernate? I keep getting errors on inserts using the identity Id generator. I think the problem is that the identity is attempted to be selected on a different connection than the conncetion that issued the insert. http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment12http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment12Mon, 26 Feb 2007 18:35:34 GMTYou can place embedded DB to virtual disk in memory. http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment11http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment11Mon, 26 Feb 2007 15:47:16 GMTHow about a ramdisk? http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment10http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment10Mon, 26 Feb 2007 11:58:43 GMTMaybe Bamboo.Prevalence is what you're searching. http://sourceforge.net/projects/bbooprevalence/ CodeProject article: http://www.codeproject.com/dotnet/ObjectPrevalenceWithBambo.asp?df=100&forumid=24434&exp=0&select=1617384&fr=26 XSD->Bamboo Migration Kit: http://www.users.bigpond.net.au/meyn/bamboo/ http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment9http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment9Mon, 26 Feb 2007 08:22:46 GMTBil, SQL CE is an embedded DB, which means that it writes to a file and runs in-process. To my knowledge, there is no way to run a database entirely in memory. If there was such a way, that would be the perfect DB. http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment8http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment8Mon, 26 Feb 2007 06:09:22 GMTJosh, I'll try to do that. The basic idea is that I really need to have some way to ask: "Give me all the records within a specified range from this date" and "Give me all the records where the child record is 3 days more recent than that parent record." http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment7http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment7Mon, 26 Feb 2007 06:07:47 GMT@Tom, Can I run firebird in memory?? http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment6http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment6Mon, 26 Feb 2007 06:01:55 GMT@Srdjan, The last SharpHSQL release that I can find is 2004, on gotdotnet, that is not encouraging when choosing a database. http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment5http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment5Mon, 26 Feb 2007 06:00:59 GMTNot sure if your SQLite is referring to what I'm talking about here but SQL Server 2005 Compact Edition is pretty nice for in-memory databases and just needs a couple of dlls to include for release. You can check it out here: http://www.microsoft.com/sql/editions/compact/default.mspx http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment4http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment4Sun, 25 Feb 2007 22:12:11 GMTWhat about setting up a unit test for the date based operations that fail in SQLLite - then everyone can run them in their favourite embedded DB and see who supports what. It would also document the basic functionality that you consider necessary. http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment3http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment3Sun, 25 Feb 2007 21:39:05 GMTMaybe try Firebird SQL? I've been playing with it for the last little while, seems to work for me. http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment2http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment2Sun, 25 Feb 2007 20:29:21 GMTdid you try SharpHSQL? It can be set to run in memory... I use it that way. Not without issues but could serve your needs... http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment1http://ayende.com/2144/unit-testing-database-embedded-vs-in-memory#comment1Sun, 25 Feb 2007 17:27:23 GMT