I have a project I'm thinking of doing in F#, but I'm still very new to the language. I'll need a simple database, hopefully something easy to use. Would sqlite work well for an F# project? Other suggestions?
views:
158answers:
4SqlLite is a very popular lightweight database engine that supports a .Net binding layer which is accessible from F#. It probably the best option for your scenario.
This CodeProject article details how to use C# to bind to SqlLite and is easily transferable to an F# scenario
Another option would be SQL Server 2008 Compact Edition. I don't have any experience with it myself, but my understanding is that it is just a dll
that can be easily distributed with your project.
The programming API is standard ADO.NET (which can be easily used from F#). It also supports LINQ, so if you wanted, you could also call it with F# LINQ (FLINQ) from CodePlex.
Firebird embedded can be a good choice too
The embedded version is an amazing variation of the server. It is a fully featured Firebird server packed in just a few files. It is very easy to deploy, since there is no need to install the server. It is ideal for CDROM catalogs, demos or standalone desktop applications.
Check out db4o, it's just an object store, so it's pretty simple.