Functional language implementations of Production Grade data stores

views:

449

answers:

+6 Q:

Functional language implementations of Production Grade data stores

There are many datastores written in Erlang, for example Riak, Dynomite, CouchDb, Scalaris, have I missed any?

I know that Java and C/C++ have also been used to write datastores (Cassandra, Hypertable, etc), but have any Datastores been written in any other functional languages such as F#, Scala, Haskell, Clojure, etc? The reason I am asking this (and many other functional programming and Erlang type questions) is to assess the feasibility of functional programming languages for real world projects.

As a side note it has been pointed out to me that I mean the actual implementation language of the datastore itself, and not the client language to access the datastore (ie: via ODBC).

+3 A:

Your question puzzles me a little. You ask about datastores written in a variety of languages. Generally, when I program I look for a library or API to get and put data from and to the datastore in my chosen language. What the underlying datastore is written in (if it's written in anything, some datastores are no more than file layouts) I do not care.

And on that basis a little Googling will turn up Haskell-to-ODBC libraries, and I imagine the other languages will have similar facilities. I have no knowledge of these, so won't comment on their suitability for projects.

Regards

Mark

High Performance Mark 2010-02-05 08:36:03

Yes, you are right, I did not explain it so clearly. I did mean the "underlying" data store as you pointed out.

Zubair 2010-02-05 09:22:45

Also, interesting point you made, which datastores are just file layouts, as I would like to evaluate them?

Zubair 2010-02-05 09:42:10

Really? Are you sure, that application data storage which doesn't copy data between processes of application and db doesn't have some benefits? Performance? In this case data store in specific language have big sense. Ordinal embedded db is not solution here because necessity of boiler plate. For example It is why mnesia in Erlang have big sense in some cases especially with native "stored procedures" and transactions (distribution involved).

Hynek -Pichi- Vychodil 2010-02-05 10:09:40

Well, I guess when I think of a datastore I think of something persistent, something on disk, in which case yes, accessing data storag has to transfer data between disk and memory. And yes, there are cases where it is advantageous to have a very close fit between your programming language and your data store. But it is not necessary that the datastore be written in the same language as your programs. And, if you work in multi-language environments, as many of us do, which language do you choose ?

High Performance Mark 2010-02-05 11:50:31

@Zubair: have a look at HDF5 or netCDF for data formats which are suitable for large datastores but are really just file layouts. Then, invent your own file format which contains all the information you need, translate it into a binary form, and there you have your own datastore which is language independent.

High Performance Mark 2010-02-05 11:51:44

+6 A:

Data.Tcache is a transactional cache with configurable persistence for Haskell.
Elephant is a persistent object database for Common Lisp with full transaction semantics.
CLSQL - a SQL database for Common Lisp interface.
AllegroCache is a high-performance, dynamic object caching database system for Allegro Common Lisp.
Spark-Scheme comes with a built-in database and ODBC support.

Vijay Mathew 2010-02-05 09:47:27

Brilliant, I will look into these. Thanks

Zubair 2010-02-05 09:50:47

I had a brief look at these. Spark seems the nicest, but has the worst website :) Do any of them work in clustered settings?

Zubair 2010-02-05 09:54:48

@Zubair Thanks for the favorable comment on Spark. That is my personal Lisp! About the website, do not have enough resources (all of time, money and personal) to create a better one.

Vijay Mathew 2010-02-05 10:08:26

HALFS

ja 2010-02-05 10:27:17

Production grade data store in Version 0.1 (and exists only this one) with webpage full of broken links. LOL

Hynek -Pichi- Vychodil 2010-02-05 11:58:38

+3 A:

In one sense you have already answered your own question. The systems you mention, and others from the comments, ARE written in functional langauges and ARE definitely real world projects, so the answer is yes.

rvirding 2010-02-05 10:43:23

+2 A:

FleetDB is schema-free database in Clojure.

Flamefork 2010-02-05 12:42:19

ansaurus

tags:

views:

answers:

Functional language implementations of Production Grade data stores

related questions