Re: [elephant-devel] Query performance

2009-02-10 Thread John
On Tue, Feb 10, 2009 at 6:33 PM, Ian Eslick wrote: > For that particular query there is a more efficient way, but it's not > natively supported in any of the high level APIs. We're not (yet) > trying to reproduce all the queries you are accustomed to in SQL > databases. The goal of the query sy

[elephant-devel] Query performance

2009-02-10 Thread John
Hi, I created a database of 85958 persistent objects containing 31 string slots with items such as first, last, middle, etc names, company name, address, etc... Total disk space is about 1.3GB. Now, I wanted to write a small routine to generate CSV files containing the information in this databas

Re: [elephant-devel] Learning about Elephant

2009-02-10 Thread John
I'll take a look and see if I can do anything with it, whether using it or helping with it. However, do let me (us) know when you track down that missing file just in case it's important to the use of it. Regards, John On Tue, Feb 10, 2009 at 1:03 PM, Ian Eslick wrote: >

Re: [elephant-devel] Learning about Elephant

2009-02-10 Thread John
Hi Ian, I've been playing with Elephant and so far so good. I noticed that there is some code in the query folder. However, I'm not sure if this is at all functional in any way. Is it? How could I begin to use some of whatever is done there? Thanks, John On Tue, Jan 27, 2009 at 1:

Re: [elephant-devel] Learning about Elephant

2009-02-10 Thread John
Hi Ian, I've been playing with Elephant and so far so good. I noticed that there is some code in the query folder. However, I'm not sure if this is at all functional in any way. Is it? How could I begin to use some of whatever is done there? Thanks, John- Hide quoted text - On T

Re: [elephant-devel] Lisp-only data store (prototype)

2009-02-06 Thread John
However, for this example you can hack it up with map-inverted-index > > (defun get-min-log-value (type) ;; type = { :min | :max } >(map-inverted-index > (lambda (x) >(return-from get-min-log-value x)) > 'log 'timestamp :from-end (when :max t))) >

Re: [elephant-devel] Advice on multiple deploying multiple applications/repositories

2009-02-06 Thread John
ur apps is that independent, why not just put > one per server and avoid the complexity? > > Ian > > On Feb 6, 2009, at 4:31 PM, John wrote: > > > Since our interest is to use Lisp and Elephant to create web > > applications, I'd like to request some deployment ad

Re: [elephant-devel] Lisp-only data store (prototype)

2009-02-06 Thread John
As we're still learning Elephant, we are not currently using cursors. However, one thing I'm thinking is that we will definitely have the following scenario: We define a class for storing log information, which is timestamped and we create an index on the timestamp. The purpose for this is so that

[elephant-devel] Advice on multiple deploying multiple applications/repositories

2009-02-06 Thread John
Since our interest is to use Lisp and Elephant to create web applications, I'd like to request some deployment advise for Lisp and/or Elephant. Our intention is to have Apache in front of a Lisp image running some web server, where Apache will simply allow us to proxy/load-balance traffic. Maybe w

Re: [elephant-devel] Learning about Elephant

2009-01-28 Thread John
ed, Jan 28, 2009 at 12:32 AM, Ian Eslick wrote: > That would be correct if you added (setf (friends-of person3) person2) > > On Jan 27, 2009, at 5:06 PM, John wrote: > > > Thanks for the clear example. However, maybe the idioms are > > confusing me, but many-to-many tells me

Re: [elephant-devel] Learning about Elephant

2009-01-28 Thread John
On Wed, Jan 28, 2009 at 12:26 AM, Ian Eslick wrote: > > > Hi John, > > Your mileage may vary, but I'm really not concerned about users > causing significant performance degradation by doing lots of null > edits. If that is happening, it's probably a user interface

Re: [elephant-devel] Learning about Elephant

2009-01-27 Thread John
entities so there's > no need for two slots. > > This all seems to work well in the current Alpha 2. > > Ian > > On Jan 27, 2009, at 1:32 PM, Ian Eslick wrote: > > > > > On Jan 27, 2009, at 11:00 AM, John wrote: > >> > >> 1) Every read/write

Re: [elephant-devel] Learning about Elephant

2009-01-27 Thread John
Hi Ian, Thank you for your prompt response. Some comments below On Tue, Jan 27, 2009 at 1:32 PM, Ian Eslick wrote: > > Such a thing would be possible, but you would need to have a local > copy of the value in memory and this could create more problems than > it solves. It's also unclear to me

[elephant-devel] Learning about Elephant

2009-01-27 Thread John
Hi all, I've recently come across Elephant and have been reading the manual (even though it claims to be a bit stale). My approach is to read the manual and then dig into the code to learn more details or discrepancies not documented/updated on manual. In so far, I have a few questions I wonder if

Re: [elephant-devel] Dropping DB connection during writes

2008-11-21 Thread Tayssir John Gabbour
Leslie P. Polzer wrote: > On Fri, Nov 21, 2008 at 11:02:21AM +0100, Tayssir John Gabbour wrote: >> foo-user> (asdf:oos 'asdf:load-op :elephant-tests) >> ... >> foo-user> (ele-tests::do-test-spec 'testthreads) >> NIL > > In fact this shoul

Re: [elephant-devel] Dropping DB connection during writes

2008-11-21 Thread Tayssir John Gabbour
Tayssir John Gabbour wrote: > Leslie P. Polzer wrote: > > On Fri, Nov 21, 2008 at 11:02:21AM +0100, Tayssir John Gabbour wrote: > >> foo-user> (asdf:oos 'asdf:load-op :elephant-tests) > >> ... > >> foo-user> (ele-tests::do-test-spec 'testthr

Re: [elephant-devel] Dropping DB connection during writes

2008-11-21 Thread Tayssir John Gabbour
Alex Mizrahi wrote: > TJG> With Elephant under both Postmodern and CLSQL, I'm consistently losing > TJG> my DB connection. This apparently happens when writing from fairly > TJG> simultaneous threads. (Two threads may write to the same btree key at > TJG> around the same time.) > > weird. could be

Re: [elephant-devel] Dropping DB connection during writes

2008-11-21 Thread Tayssir John Gabbour
ing out *store- > controller*. With sufficient concurrency you are likely to get a race > condition where the if stmt in with-city-store succeeds but the body > fails since you aren't locking access to *store-controller*. > > Ian > > > On Nov 20, 2008, at 11:16 AM,

[elephant-devel] Dropping DB connection during writes

2008-11-20 Thread Tayssir John Gabbour
Hi! With Elephant under both Postmodern and CLSQL, I'm consistently losing my DB connection. This apparently happens when writing from fairly simultaneous threads. (Two threads may write to the same btree key at around the same time.) All I do is add objects to a BTree, keyed by their UUID. (And

[elephant-devel] Btree-index-cursor issues

2008-06-23 Thread Tayssir John Gabbour
Hi! Is there something like WITH-INDEX-CURSOR or WITH-BTREE-INDEX-CURSOR? Also, btree-index-cursors (under Postmodern) can't print, signalling an unbound-slot error: (open-store *my-spec*) (add-to-root :blah (make-indexed-btree)) (add-index (get-from-root :blah) :index-name :ind

Re: [elephant-devel] Berkeley DB error: Invalid argument

2008-03-08 Thread John Leuner
How did you install it? Did you install libdb? John On Sat, 2008-03-08 at 11:01 -0600, Raja Ramachandran wrote: > Hello - > > I keep getting this error when I open an existing store or just when I open a > new store: > > > SVC> (elephant:open-store '(:BDB &quo

Re: [elephant-devel] Re: Automate "create language plpgsql;"

2008-02-25 Thread John DeSoi
On Feb 25, 2008, at 4:00 AM, Alex Mizrahi wrote: [EMAIL PROTECTED]:~$ psql -c "create language plpgsql" elepm ERROR: must be superuser to create procedural language I think this is changed in 8.3 -- you don't have to be superuser to create a trusted language. J

Re: [elephant-devel] Re: BDB vs postmodern

2008-02-21 Thread John DeSoi
or write? Are you using transactions and prepared queries with PostgreSQL? That might help some, but as you say it probably won't scale up very well. John DeSoi, Ph.D. ___ elephant-devel site list elephant-devel@common-lisp.net http://c

Re: [elephant-devel] QDBM Support

2008-02-14 Thread John DeSoi
properly indexed SQL database can't get close to it. If the performance with SQLite is poor, has it been verified to be only a SQLite issue and not something related to CLSQL? John DeSoi, Ph.D. ___ elephant-devel site list elephant-devel@c

Re: [elephant-devel] Schema evolution

2007-11-05 Thread Tayssir John Gabbour
Ian Eslick wrote: > Redefining a class via defclass, thus initiating calls to change- > instance-for-redefined-class is harder because it is lazy in some > (or all) lisps. When a defclass causes a change in a standard class > schema, the instances of that class are updated at latest when an > obj

[elephant-devel] Patch for Postmodern backend, to specify ports

2007-10-24 Thread Tayssir John Gabbour
Hi, Just a little patch, so you can specify :port of your running Postgresql server... MfG, Tayssir New patches: [Postmodern backend: connection spec now accepts :port keyword argument, to specify the port. Similar to Postmodern's connection spec syntax. [EMAIL PROTECTED] { hunk ./src/db-po

Re: [elephant-devel] Request for some sort of response....

2006-05-22 Thread Tayssir John Gabbour
Robert L. Read wrote: > Somebody please respond to this, or, if you prefer, respond to me > personally at the address below. Hi Robert. Sure, I'll help test... writing it down in my calendar for tomorrow. (I didn't read the volunteer email carefully, and assumed it was for people who already had s