Re: Anyone experienced in using clojure as a database

2010-05-30 Thread Erik Söhnel
Hi Andrzej, I have a question about primary keys. As far as I can see you're currently using the first field of the relation as a primary key. While that's what other databases do (and it is working well), I think it would be better to make _records_ themselves primary keys. Since records

Re: Anyone experienced in using clojure as a database

2010-05-29 Thread Andrzej
Hi Erik, I have a question about primary keys. As far as I can see you're currently using the first field of the relation as a primary key. While that's what other databases do (and it is working well), I think it would be better to make _records_ themselves primary keys. Since records are

Re: Anyone experienced in using clojure as a database

2010-05-28 Thread Erik Söhnel
I haven't had a chance to play with your code yet but at first glance it looks good. Does the above mean that all set operations are automatically supported and the accelerated? Unfortunately not for all operations. For example, clojure.set/join uses its own index function, which builds an

Re: Anyone experienced in using clojure as a database

2010-05-27 Thread Erik Söhnel
On 26 Mai, 15:24, Andrzej ndrwr...@googlemail.com wrote: I'd love to see a persistent table type together with some common primitives (select, join, union) and optimization capabilities. Currently a set of maps does something like that but I have no idea how to, for example, add an index to

Re: Anyone experienced in using clojure as a database

2010-05-27 Thread Andrzej
On Thu, May 27, 2010 at 3:36 PM, Erik Söhnel eriksoeh...@googlemail.com wrote: Got something around, this is my 3rd or 4th attempt to provide a relational datastructure for clojure. I've often found myself in situations, where I needed some kind of table and look up rows by more than one key,

Re: Anyone experienced in using clojure as a database

2010-05-26 Thread Luke VanderHart
Clojure is not a great choice for this. It's oriented as a programming language, not a database. It doesn't have any built-in persistence mechanisms, and while it has many virtues, it's a little bit of a memory hog. That isn't really what you want in an in-memory DB. For anything more than a toy

Anyone experienced in using clojure as a database

2010-05-25 Thread Fabio Kaminski
Folks, i would like advice, cause since im starting something that will be eventually big data intensive, from scratch and i really like the options already built in in clojure like STM, parallelizing data and concurrency logic implemented on it i think its wonderfully tuned to use as database...

Re: Anyone experienced in using clojure as a database

2010-05-25 Thread Sean Devlin
You might want to look at FleetDB http://fleetdb.org/ http://github.com/mmcgrana/fleetdb On May 25, 2:08 pm, Fabio Kaminski fabiokamin...@gmail.com wrote: Folks, i would like advice, cause since im starting something that will be eventually big data intensive, from scratch and i really

Re: Anyone experienced in using clojure as a database

2010-05-25 Thread Savanni D'Gerinel
On 05/25/2010 01:36 PM, Sean Devlin wrote: You might want to look at FleetDB http://fleetdb.org/ http://github.com/mmcgrana/fleetdb I have not found the system to be incredibly well documented, but I have discovered that if you want to embed fleetdb in your app, you will need (use