Portable DB Suggestions?

[Harvey Saayman]

You got it Shog, i intend for this app to be on my flash disk or external HDD

Harvey Saayman - South Africa Junior Developer .Net, C#, SQL you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer) 1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

[Zoltan Balazs]

Embedded Firebird [^]. There are a couple of articles about it on CP, like this one [^]

Work @ Network integrated solutions | Flickr | A practical use of the MVC pattern

[Jorgen Sigvardsson]

Shog9 wrote:

lack of dependencies

To get it running in C++, all you have to do is to download two (maybe three depending on how much you'd like to extend it) files, and add them to your project. Talk about It Just Works!

[Super Lloyd]

http://www.vistadb.com

A train station is where the train stops. A bus station is where the bus stops. On my desk, I have a work station.... _________________________________________________________ My programs never have bugs, they just develop random features.

[Perspx]

Not having used SQLite with C#, unfortunately I can't. I've used it with C++ though and it's pretty speedy :) Regards, --Perspx

"I've got my kids brainwashed: You don't use Google, and you don't use an iPod." - Steve Ballmer
"Some people have told me they don't think a fat penguin really embodies the grace of Linux, which just tells me they have never seen an angry penguin charging at them in excess of 100mph." - Linus Torvalds

[Stuart Dootson]

Nemanja Trifunovic wrote:

That would be a very strange use of the term "portable". It usually means able to port to another compler/OS/hardware.

Not necessarily[^]

[Todd Smith]

u$ dataset reader what types of dataset readers are there?

Todd Smith

[MrPlankton]

u=micro $oft

MrPlankton (bad guy)"Fear is a hammer, and when the people are beaten finally to the conviction that their existence hangs by a frayed thread, they will be led where they need to go." (good guy)"Which is where?" (bad guy)"To a responsible future in a properly managed world." Dean Koontz, The Good Guy

[Stuart Roberts]

I have used the free version of this for a project of my own and it is good, plus their support is pretty speedy. There is a provider that **should** be a drop-in replacement for the SQL Server provider, and they are constantly working on ensuring that their flavour of SQL matches SQL Server, to make upgrade / crossgrade easier.

Stuart R

[si618]

Sounds like a job for db4o.

[cwp42]

Take Access - one file, fast and handy Read http://www.codeproject.com/KB/database/DatabaseAcessWithAdoNet1.aspx[^]for details

cwp42

[Rachel Mant]

If you're so concerned with having the application portable, write your own database format for the application, that way you can keep the dependencies to a minimum and have full control as to how the data is stored. (just my 2cents)

The worst thing about the darkness is the light at the end - DX-MON

[CarlG]

Yes, I too can recommend SQLite. It is simply Great! "Small, Fast, Reliable - choose any 3". :) / Carl

[Rachel Mant]

Access isn't portable though, it's windows only and this guy wants his software to be able to run on all platforms.

The worst thing about the darkness is the light at the end - DX-MON

[KCorax2]

SQLite is horrible with respect to features. There aren't even foreign keys on this thing, transactions and all. If you go with something that small, you could as well do binary serialization to file and then use Linq to object + some data structures to query things. I'd go for SQL Compact for which you can even do Linq to SQL using sqlmetal. It works very well, and it's deployable easily on Windows CE and clickonce applications. If performance doesn't cut it (because both SQLite and SQLCE are very very slow) I'd go with Firebird and hand coded queries. Firebird is actually fantastic when you look at the feature list. A very complete DBMS.

[chaiguy1337]

My impression was that Sqlite was very limited, especially with regards to concurrency. I think it has to lock the entire table at a time rather than just a row, if I recall. If you're not doing anything with concurrent connections it's probably not a big deal, I guess. Also, I've heard[^] good things about VistaDB. It's 100% managed code, no wrappers. In fact they've even got preliminary tests working under Silverlight and it already supports Mono.

“It behooves every man to remember that the work of the critic, is of altogether secondary importance, and that, in the end, progress is accomplished by the man who does things.” –Theodore Roosevelt {o,o}.oO( Check out my blog! ) |)””’)          http://pihole.org/ -”-”-

[Ed K]

You can also use it with Castle.ActiveRecord which makes it even sweeter!

ed ~"Watch your thoughts; they become your words. Watch your words they become your actions. Watch your actions; they become your habits. Watch your habits; they become your character. Watch your character; it becomes your destiny." -Frank Outlaw.

[Jawz X]

I agree. I recently used it for a project and it is great. They are even include LINQ support in the framework for the .NET lib. I'm not sure where they are at with that yet, but SQLite is the way to go. Regards, Frank

[codebozo]

I concur - db4o would be an excellent choice. It is a true OODB, it has a LINQ provider and it's free as long as the project is truly a "personal project".

[Paul Sanders the other one]

Why do you need a database? I wrote just such a utility for myself a year or so back and I just write the whole thing out to a text file whenever a change is made. This takes approximately 0.000 ms on a modern PC. You can download a (free!) copy of Snippets from here: http://www.alpinesoft.co.uk/freebies[^]

Paul Sanders http://www.alpinesoft.co.uk