Welcome! and rules
Joel on Software
storing data locally for an app
I'm interested in writing an app and am looking for a solution to store data. I like using databases, but expecting others to have SQL Server, or at least MSDE loaded is a bit much for my app.
how about an access db? unless you're doing very complex stuff, it's usually up to it, the jet db engine is well proven and tested/documented, and it's relatively low cost. it's also very simple writing oledb code to work with it.
I'm looking for a free solution too. Though, Access would be fine. Citydesk uses it, right?
Yep, Access is the go for sure, and yep, citydesk using it.
I tend to go with the Jet (Access) option. If you go that way make it the latest version. (There are a few odd problems with some earlier versions.)
Ok, I found this article (http://www.manning.com/dotnetbooks/csharpprimer/sql_to_access.html) that talks about creating a blank jet DB from scratch and accessing it through c#. Is this the right track?
Though it's still in it's beginning stages, ObjectSpaces from MS provides an interesting solution to this. Although it's typically used to perist objects to a relational database (SQL Server), it can also be used to disk via XML.
As an Access developer (don't laugh), I still have a soft spot in my heart for the Access 97 MDB format. Access 2k introduced Unicode compatibility, thereby doubling the disk space consumed by text fields in tables for no real benefit (to me, that is; I tend to work with text-intensive data). Just something to keep in mind if file size is an issue.
Well, the Access 2000 libraries are working fine for my use I suppose. Though, the amount of data at the time is so small, I can just as easily use XML...
Jet is redistributable. You'll find the latest bits in Jet 4.0 SP3 - see http://www.microsoft.com/data/download.htm
If open source distribution is important, perhaps a look at Berkeley DB from Sleepycat Software might be useful.
Try prevalence engine. You can check out the .Net implemenation at http://bbooprevalence.sourceforge.net/
I've written a code generator that takes in an XML description of your tables and generates wrapper objects for each. It only works for fairly simple storage requirements, but it can save you a fair bit of typing if your data does fit in nicely.
Fog Creek Home