Re: fleeing sql

Riccardo Cohen wrote:
> About multi threading in a client application, my opinion is similar : 
> you have to lock something for writing. I don't know however the effect 
> of a write operation while another thread is reading... maybe memory 
> mapped file would save you, but I wouldn't bet on it.

sometimes if you ask Google the same question in a different way, you find your 
answer.

http://www.equi4.com/wikis/metakit/13

In other words, multithreading is not really possible or practical just yet. 
the right solution in a multithreaded environment is, assign metakit to a single 
thread and have all of the other threads speak to the single metakit thread.

To tell you the truth, I'm not sure how well that is going to work for me.  I've 
got three or four applications when I need something that behaves like metakit 
and supports the core functionality I can build "test and set" and "update 
before insert" capabilities out of.  I might just need to use a global lock and 
invoke and close metakit on every query.  Ugly as hell but at least it's not 
SQL.  almost as ugly is the single process single thread version you described. 
  I'm sure using psyco can help take some of the ugliness out of it by exporting 
all of the Python interfaces.  But I wonder how bad performance is going to be.

Are there any other non-SQL non-DBM databases out there?  Or is it just 
primarily SQL and metakit? (and no, I'm not interested in becoming a database 
expert.   I have way too much on my plate to even learn about databases let 
alone design them.

---eric
--

-- 
Speech-recognition in use.  It makes mistakes, I correct some.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the "metakit" group.
To post to this group, send email to metakit <at> googlegroups.com
To unsubscribe from this group, send email to metakit-unsubscribe <at> googlegroups.com
For more options, visit this group at http://groups.google.com/group/metakit?hl=en
-~----------~----~----~----~------~----~------~--~---