Re: [Neo4j] Cypher question...

2015-09-01 Thread Wes Freeman
just take out host and make it WHERE NOT ()-[:nicowner]->(nic) On Tue, Sep 1, 2015 at 10:53 AM, Alan Robertson wrote: > I tried the old syntax, and it said that host was undefined. > > > On 09/01/2015 08:45 AM, Michael Hunger wrote: > > Hi Alan > > can you try this: > > START ip=node:IPaddrNode

Re: [Neo4j] Questions about profiling and optimizing queries in Neo4j 2.2

2015-04-08 Thread Wes Freeman
I get it, sorry. Your confusion is justified--it probably shouldn't do that. It must have decided an AllNodeScan would be easier than scanning the shorter list of c nodes, which is definitely a bad plan. Does it act the same without DISTINCT? Wes On Wed, Apr 8, 2015 at 8:48 PM, wrote: > For q2,

Re: [Neo4j] Questions about profiling and optimizing queries in Neo4j 2.2

2015-04-08 Thread Wes Freeman
I'm guessing q3 is something like len(all nodes) * (len(PHONE) + len(ADDRESS) + len(TAG) + len(INVITE)) * len(all nodes) -- since you have no labels on the end nodes of the pattern, it's hard to estimate. Wes On Wed, Apr 8, 2015 at 8:29 PM, Wes Freeman wrote: > If the query you

Re: [Neo4j] Questions about profiling and optimizing queries in Neo4j 2.2

2015-04-08 Thread Wes Freeman
If the query you put in q2 is your whole query, you should really start with a MATCH for any OPTIONAL MATCH, even if it's not a big pattern... like: MATCH (c:Contacts) OPTIONAL MATCH (c)-[:PHONE|ADDRESS|TAG|INVITE]->(x) RETURN c, COLLECT(DISTINCT x) AS xs, r -- You received this message because

Re: [Neo4j] Cypher Feature Suggestion: bind new identifiers in predicates

2014-10-29 Thread Wes Freeman
e only 2 nodes are involved. > > What about the situation where 4 or 5 nodes on the path? with a coupe of > OR's? > > It's a bit late for me right now. But I will try come up with a more > concrete example tomorrow. > > Cheers, > Kai > > On Tue, Oct 2

Re: [Neo4j] Cypher Feature Suggestion: bind new identifiers in predicates

2014-10-28 Thread Wes Freeman
How about this? Defer predicates until you match more than you need, then double check what you need to confirm in WHERE. MATCH (c:circle) OPTIONAL MATCH (c)-->(s:square) WITH c, s WHERE c.id = 4 OR ((c)-->(s) AND s.id < 4) RETURN c,s Wes On Wed, Oct 29, 2014 at 1:13 AM, S. Kai Chen wrote:

Re: [Neo4j] LOAD CSV creates odd relationships with incrementing number

2014-10-16 Thread Wes Freeman
Those numbers are just the internal ids of the relationships. There aren't any properties, so the {} is empty. It's just the display format in the shell. Was that the only thing that looked wrong? Wes On Fri, Oct 17, 2014 at 12:06 AM, Rodger wrote: > > | :AGG_EMAILS[193]{} | > | :AGG_EMAILS[194

Re: [Neo4j] Wildcard character in CYPHER

2014-08-12 Thread Wes Freeman
No. Schema/label indexes are only exact lookups yet. Wes On Tue, Aug 12, 2014 at 4:34 PM, Alan Robertson wrote: > Would it speed up (via indexes) if you added *'n.name <http://n.name> >= > "Michael"'* ? > > > > On 08/12/2014 01:13 PM, Wes

Re: [Neo4j] Wildcard character in CYPHER

2014-08-12 Thread Wes Freeman
The way you need to do this (currently) is with the regex syntax: MATCH (n) where n.name =~ "Michael.*" RETURN n http://docs.neo4j.org/chunked/milestone/query-where.html#_regular_expressions Wes -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To uns

Re: [Neo4j] Re: Using Neo4j 2.1.2 database with Neo4j 2.1.3 fails to start

2014-08-07 Thread Wes Freeman
That shouldn't be necessary from 2.1.2 to 2.1.3, though, should it? Wes On Thu, Aug 7, 2014 at 2:21 PM, david fauth wrote: > Bill, > > You should be able to upgrade to 2.1.3 by uncommenting the following line > in your neo4j.properties file: > > #allow_store_upgrade=true > > More info is in the

Re: [Neo4j] True streaming enabled in latest Perl driver - REST::Neo4p v0.3003

2014-07-17 Thread Wes Freeman
Nice. All clients/drivers should strive for this functionality--definite boost to overall performance and responsiveness. :) Wes On Thu, Jul 17, 2014 at 11:59 AM, Mark Jensen wrote: > All, > > For Perlers using Neo4j, I want to announce that REST::Neo4p >

Re: [Neo4j] Neo4j RPM / yum repository?

2014-07-14 Thread Wes Freeman
n, Jul 14, 2014 at 6:07 PM, Alan Robertson wrote: > It says it's not suitable for production work. Is that still true? > > > > On 07/14/2014 02:29 PM, Wes Freeman wrote: > > This one: > http://yum.neo4j.org/ > > On Mon, Jul 14, 2014 at 4:25 PM, Alan Robertson w

Re: [Neo4j] Neo4j RPM / yum repository?

2014-07-14 Thread Wes Freeman
This one: http://yum.neo4j.org/ On Mon, Jul 14, 2014 at 4:25 PM, Alan Robertson wrote: > You've had .deb packages of Neo4j for a long time. > > Do you have a YUM (RPM) repository for Neo4j? > > -- > Alan Robertson - @OSSAlanR > > "Openness is the foundation and preservative of friendship...

Re: [Neo4j] Interesting observation and question

2014-06-19 Thread Wes Freeman
It doesn't conflict. If you want to order by the internal id, you can do: ORDER BY id(n) -- it's different than ORDER BY n.id On Thu, Jun 19, 2014 at 8:32 PM, Richard L. Burton III wrote: > I created a property on the Node called 'id'. At the time of doing this, I > didn't think about the exist

Re: [Neo4j] Using Cypher CSV import tool where data has commas

2014-06-12 Thread Wes Freeman
Most decent CSV libraries allow you to automatically quote their output, btw, so quotes are escaped properly, etc. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j

Re: [Neo4j] Using Cypher CSV import tool where data has commas

2014-06-12 Thread Wes Freeman
a, text: > line.text }) > > Viola! > > > On Thursday, June 12, 2014 2:26:49 PM UTC-6, Wes Freeman wrote: > >> You want to "quote" your CSV. From wikipedia: >> >>- Fields containing a line-break, double-quote, and/or commas *should* be >&g

Re: [Neo4j] Using Cypher CSV import tool where data has commas

2014-06-12 Thread Wes Freeman
You want to "quote" your CSV. From wikipedia: - Fields containing a line-break, double-quote, and/or commas *should* be quoted. (If they are not, the file will likely be impossible to process correctly). id,another_data,text "1234","data","This can have commas, so this part never gets i

Re: [Neo4j] Help me understand how multiple MATCH clauses work

2014-06-11 Thread Wes Freeman
Pipe is the right analogy, but also imagine that you're pulling data through the pipe as you iterate through the results. Notice that the pipes are the MATCH/WHERE together. MATCH n WHERE n.visible = true // gives 10 results, let's say OPTIONAL MATCH n-[r]->m WHERE m.visible = true // for each n

Re: [Neo4j] Improving the performance of read queries over HTTP. Full domain info included!

2014-06-05 Thread Wes Freeman
Good recommendations all around. Be sure to spice up your results with rand() on the top section to avoid too strong of a feedback loop. :) Wes -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails f

Re: [Neo4j] economical, large-memory systems for Neo4j?

2014-06-01 Thread Wes Freeman
After the ~64GB RAM mark, you have to start considering server-oriented boards and builds (supermicro motherboards, etc.). If you're looking at buying, I had a nice server built by AVADirect a couple of years ago that I've been quite happy with. The midrange server builds they offer support 256-512

Re: [Neo4j] Re: get first match

2014-05-29 Thread Wes Freeman
Whoops, the :City on the second match isn't necessary, and actually might not be allowed later. On Thu, May 29, 2014 at 10:55 AM, Wes Freeman wrote: > MATCH (c:City) > WITH c > LIMIT 1 > MATCH (p:Person)--(c:City) > RETURN * > > > On Thu, May 29, 2014 at

Re: [Neo4j] Re: get first match

2014-05-29 Thread Wes Freeman
MATCH (c:City) WITH c LIMIT 1 MATCH (p:Person)--(c:City) RETURN * On Thu, May 29, 2014 at 10:53 AM, Alex Frieden wrote: > More particularly, I want all people, just the first city. > > > On Thursday, May 29, 2014 10:52:40 AM UTC-4, Alex Frieden wrote: >> >> Hi I have the query: >> MATCH (p:Pers

Re: [Neo4j] Re: jexp batch importer

2014-05-29 Thread Wes Freeman
You could put something near here: https://github.com/jexp/batch-import/blob/2.1/src/main/java/org/neo4j/batchimport/Importer.java#L196 Wes On Thu, May 29, 2014 at 7:43 AM, [:Koen] wrote: > any ideas ? > > this is the command used to import the data: > > java -server -Dfile.encoding=UTF-8

Re: [Neo4j] Using Neo4j embedded in Java applications

2014-05-27 Thread Wes Freeman
6.5M should have no trouble. Sample code? Wes On Tue, May 27, 2014 at 10:36 AM, Qaroui Oussama wrote: > Hello! I'm using neo4j to store more than 6.500.000 nodes, with no > relationships. > When I try to get a specific node using findNodesByLabelAndProperty or by > executing a cypher query in my

Re: [Neo4j] ORDER BY and indexes

2014-05-23 Thread Wes Freeman
, 2014 at 1:01 AM, Wes Freeman wrote: > Lucene can handle range lookups and sorted results, but the schema index > API currently only supports exact lookups. The limitation is not with > lucene. > > > https://github.com/neo4j/neo4j/blob/master/community/kernel/src/main/java/org/neo4

Re: [Neo4j] ORDER BY and indexes

2014-05-23 Thread Wes Freeman
Lucene can handle range lookups and sorted results, but the schema index API currently only supports exact lookups. The limitation is not with lucene. https://github.com/neo4j/neo4j/blob/master/community/kernel/src/main/java/org/neo4j/kernel/api/index/IndexReader.java#L33 For the record--even rel

Re: [Neo4j] find common path Cipher

2014-05-22 Thread Wes Freeman
< navrattan.craterz...@gmail.com> wrote: > yes query is what i am looking . But issue is each relationship has > different name : it created dynamically with time stamp. > so may be i need to change DB structure. > > > On Thu, May 22, 2014 at 7:40 PM, Wes Freeman wrote: > >> Did y

Re: [Neo4j] find common path Cipher

2014-05-22 Thread Wes Freeman
e : path traversed by 3 users. > > CP1->CP2->CP3 > > CP1->CP4->CP3 > > CP1->CP2->CP3 > > CP1->CP5->C6->CP3 > > so most visited path is : CP1->CP2->CP3 > > > Now i am found out Most visited path b/ 2 CP node. > > &g

Re: [Neo4j] find common path Cipher

2014-05-22 Thread Wes Freeman
Maybe something like this: MATCH p=(s:Checkpoint)-[:PATH*]->(e:Checkpoint) WHERE // filter the s and e checkpoints here, otherwise leave WHERE out RETURN nodes(p) as path, count(*) as c ORDER BY c DESC LIMIT 1 If you give more details maybe we can refine the query... On Thu, May 22, 2014 at 9:35

Re: [Neo4j] Re: [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Wes Freeman
uld the 2.1 RELEASE emerge ? > I searched on the Net but in vain. > > Thanks a lot, > > Michael > > > On Thursday, May 22, 2014 1:14:21 AM UTC+2, Wes Freeman wrote: > >> It looks like it's fixed in 2.1-rc1. >> >> Wes >> >> On Wed

Re: [Neo4j] Re: [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Wes Freeman
It looks like it's fixed in 2.1-rc1. Wes On Wed, May 21, 2014 at 5:48 PM, Michael Azerhad wrote: > Thanks to this law: http://en.wikipedia.org/wiki/De_Morgan%27s_laws > > I transform the part: > WHERE NOT(c.name = "Ferrari" AND 1=1) > > to > > WHERE NOT(c.name = "Ferrari") OR NOT(1=1) > > It wou

Re: [Neo4j] CREATE INDEX and deadlock.

2014-04-08 Thread Wes Freeman
I create several indexes/constraints in the same transaction all the time. Can you provide code examples to reproduce this issue? I have a feeling you may be creating conflicting indexes (indexes on the same label/property), or something. If not, maybe it's just that they're running in separate tra

Re: [Neo4j] neo4j rest API merge with properties

2014-03-29 Thread Wes Freeman
You've got an extra array bracket around your props. Try: POST http://localhost:7474/db/data/cypher {"query":"MERGE (n:Person {name:{props}.name}) RETURN n","params": {"props":{"name":"john"},{"name":"Jane"}}} On Sat, Mar 29, 2014 at 12:42 PM, Alex Frieden wrote: > Tried: > POST http://localhos

Re: [Neo4j] findNodesByLabelAndProperty from specific node

2014-03-28 Thread Wes Freeman
You should create an index for your label/property combo. Something like: try ( Transaction tx = graphdb.beginTx() ) { graphdb.schema() .indexFor( DynamicLabel.label( "MyLabel" ) ) .on( "myProperty" ) .create(); tx.success(); } Wes On Fri, Mar 28, 201

Re: [Neo4j] putting lots of cypher queries into one post request

2014-03-28 Thread Wes Freeman
A few examples located at: http://docs.neo4j.org/chunked/milestone/rest-api-transactional.html I recommend sending 100 at a time to start, and play with less or more--depending on latency and query structure you can get better results either way. Wes On Fri, Mar 28, 2014 at 3:56 PM, Alex Frieden

[Neo4j] Re: Cypher "in" operator weirdness...

2014-03-27 Thread Wes Freeman
The WHERE following the OPTIONAL MATCH is executed along with it, so if it doesn't ever return true, it only affects the OPTIONAL piece, and you'll get all of the service nodes continuing on to the next part of the query. You probably need to split it up with WITH to get the behavior you want: STA

Re: [Neo4j] cypher traversal to same node

2014-03-27 Thread Wes Freeman
ne".j Wes On Thu, Mar 27, 2014 at 10:28 AM, Alex Frieden wrote: > give that a shot > http://console.neo4j.org/r/3wgnza > > > On Thu, Mar 27, 2014 at 10:13 AM, Wes Freeman wrote: > >> What's (d) supposed to be? >> >> Can you set up an example graph

Re: [Neo4j] cypher traversal to same node

2014-03-27 Thread Wes Freeman
What's (d) supposed to be? Can you set up an example graph in console.neo4j.org, or a graphgist so we can run queries against it. Wes On Thu, Mar 27, 2014 at 9:50 AM, Alex Frieden wrote: > So I have a person ndoe and I want to know who is a friend of a friend > from a city > > So what this loo

Re: [Neo4j] Re: Cypher: conditional expressions

2014-03-03 Thread Wes Freeman
Now there is CASE/WHEN syntax in Neo4j 2.0. Wes On Mon, Mar 3, 2014 at 11:56 AM, José F. Morales wrote: > Any thing come of this? > > Jose > > > On Thursday, October 4, 2012 10:22:57 PM UTC-4, Wes Freeman wrote: >> >> I've opened a feature reque

Re: [Neo4j] Insert relationship using params

2014-03-01 Thread Wes Freeman
t;> >> ReferenceError: keys is not defined >> >> - Shekar >> >> >> >> On Saturday, 1 March 2014 06:55:51 UTC-8, Wes Freeman wrote: >>> >>> https://gist.github.com/wfreeman/e620aa8e3c3fba4c936c >>> >>> Are yo

Re: [Neo4j] Insert relationship using params

2014-03-01 Thread Wes Freeman
https://gist.github.com/wfreeman/e620aa8e3c3fba4c936c Are you planning to use the other properties you're passing in? Also, it seems like it would make sense to match people on something more unique than their names. Wes On Sat, Mar 1, 2014 at 9:49 AM, Shekar Tippur wrote: > Hello - > > In or

Re: [Neo4j] Bad performance with concurrent writes to Blueprints Neo4j

2014-02-20 Thread Wes Freeman
> > On Wednesday, February 19, 2014 6:12:19 PM UTC-8, David Erickson wrote: >> >> Thanks for the response Max, unfortunately our expectation is that 1600 >> vertices/s of writing capability is a few orders of magnitude below what we >> expect/need. Probably your benchmark also has a lot of overhea

Re: [Neo4j] Possible Bug in 2.0.0? Unknown Identifier with '=' and LOWER() in WHERE Clause

2014-02-19 Thread Wes Freeman
Fixed in 2.0.1. Wes On Wed, Feb 19, 2014 at 7:03 PM, Ryan Sommers wrote: > I came across the following and not sure if it's a bug or not. > > match (h:Hostname) where h.Hostname <> LOWER(h.Hostname) return > h.Hostname, LOWER(h.Hostname) limit 10; (Success) > match (h:Hostname) where h.Hostname

Re: [Neo4j] string with single and double quotes

2014-02-19 Thread Wes Freeman
Use parameters instead of string concatenation/interpolation. Wes On Wed, Feb 19, 2014 at 11:35 AM, Alex Frieden wrote: > One of the web interfaces I have has a free text field where users once in > a while input single and double quotes. This breaks a number of cypher > queries. Anyone have

Re: [Neo4j] Neo4j performance (and neo4django)

2014-02-07 Thread Wes Freeman
If I don't batch, I usually hit a limit of somewhere in the vicinity of ~500 statements/second on a single threaded client using the Cypher HTTP endpoint. With batching on the transactional Cypher endpoint it's way faster, and should handily beat your 8 second time. So, no, it's not generally slow.

Re: [Neo4j] neo4j 2.0.1 GA ?

2014-01-31 Thread Wes Freeman
Would love to hear official word, too. :) It's got a few nice improvements. On Fri, Jan 31, 2014 at 11:16 AM, Debajyoti Roy wrote: > Thanks Wes, I have a lot riding on this one !! > > > On Friday, January 31, 2014 11:14:08 AM UTC-5, Wes Freeman wrote: > >> They just u

Re: [Neo4j] neo4j 2.0.1 GA ?

2014-01-31 Thread Wes Freeman
They just updated the changelogs so I think that's a good sign that it will be soon. :) https://github.com/neo4j/neo4j/pull/1887 Wes On Fri, Jan 31, 2014 at 10:48 AM, Debajyoti Roy wrote: > I don't want any specific dates, however neo4j 2.0.1 GA is anticipated for > Q1 of 2014 or even later? >

Re: [Neo4j] Need help with user referral graph

2014-01-26 Thread Wes Freeman
1) Direction doesn't matter, pick one and stick with it. I usually go with the subject pointing to the object with the verb as a relationship (in the case where the relationship type is a verb). 2) I think you're missing the direction on your relationship (here I'm assuming your direction is this w

Re: [Neo4j] Re: Optimising thy cypher queries

2014-01-24 Thread Wes Freeman
Thanks. :) Merge for nodes will be a lot faster in 2.0.1 (thanks to Alistair, Mark, et al. for coming up with a better happy path solution that's much quicker). I guess I missed your specific issue, if you want to link to it. Were you using unique constraints or plain indexes? On Fri, Jan 24, 2014

Re: [Neo4j] Re: Optimising thy cypher queries

2014-01-23 Thread Wes Freeman
I haven't tested performance of UNION much. It's hard to do any sort of aggregation over the whole query which makes it a bit harder to use than WITH in some situations. Hope they add some syntax for that sort of aggregation at some point--seems like UNION could be parallelized more easily. Wes O

Re: [Neo4j] Re: Optimising thy cypher queries

2014-01-23 Thread Wes Freeman
Yeah, it's effectively WITH * Wes On Thu, Jan 23, 2014 at 2:26 PM, Javad Karabi wrote: > is using multiple MATCH clauses, one after the other, equivalent to MATCH > followed by a WITH, with WITH bringing every bound node into the next MATCH? > > -- You received this message because you are su

Re: [Neo4j] Cypher query to collect data from three nodes

2014-01-22 Thread Wes Freeman
Seems to work for me: http://console.neo4j.org/r/7vtvsw On Thu, Jan 23, 2014 at 12:05 AM, mesteruh mesteruh wrote: > Lvl1data >> Lvl1data >> Lvl2data >> Lvl2data >> Lvl1data >> Lvl2data >> >> > This console return me. I want that this query return this data > > Lvl1data > Lvl1data > Lvl

Re: [Neo4j] Cypher query to collect data from three nodes

2014-01-22 Thread Wes Freeman
Can you post sample data on console? Looks like that query should work. On Wed, Jan 22, 2014 at 11:50 PM, mesteruh mesteruh wrote: > > I have 3 nodes. Lvl1,Lvl2 and Lvl3. I want collect data in one array to > add it to treeview. > > MATCH (root:Lvl1)-[:HAVE_

Re: [Neo4j] Suggestion:Adding functionality to Execution engine to give cypher query

2014-01-22 Thread Wes Freeman
Maybe he's looking for a way to dump what the query would be if the parameters were literals? Wes On Wed, Jan 22, 2014 at 1:06 PM, Michael Hunger < michael.hun...@neopersistence.com> wrote: > Sorry Atul > > I don't understand what you mean > > There is no place where a query gets concatenated >

Re: [Neo4j] cypher query with optional match

2014-01-21 Thread Wes Freeman
Probably the easiest way is to use the *0.. variable length path notation (0 or more); also, it's a good idea to put arrows in your queries: MATCH (n:Variant { name:'variant2' })<-[:UPDATED_VARIANT*0..]-(v)--(a:Allele) RETURN n,v,a In cases where no :UPDATED_VARIANT relationship exists, n and v w

Re: [Neo4j] [CYPHER] About Using Index clause

2014-01-20 Thread Wes Freeman
The USING INDEX is for specifying which index(es) you want to use, when there is more than one choice. You can specify more than one, but you have to have a WHERE clause with an equality comparison on a property in the label index. There is also a USING SCAN :Person syntax, which specifies to scan

Re: [Neo4j] Dynamic labelling in Cypher.

2014-01-16 Thread Wes Freeman
I think maybe you should consider just linking the campaign nodes directly to the product nodes, rather than using labels for this. Wes On Thu, Jan 16, 2014 at 10:00 PM, Dominic Fox wrote: > Suppose we have a graph which represents a containment hierarchy: > > Campaign -> Bundle -> Offer -> Pr

Re: [Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Wes Freeman
results are 118 MB/sec which isn't horrible, but it seems like >>> disk latency is the only thing that matters. I guess I'll try going back >>> to the stock settings and moving it over to an SSD and see what happens. >>> >>> On Thursday, January 16, 2014

Re: [Neo4j] Re: Slow create performance running Neo4j 2.0.0 inside a VM

2014-01-16 Thread Wes Freeman
My macbook's virtualbox (running centos) got good results too (99% <20ms, 50% <7ms). Was hoping for some weirdness. It is running on an ssd (vintage 2011 macbook pro 13"), hdparm 250MB/sec, so not a great comparison. Only has 800MB allocated for the VM RAM, using Neo4j stock settings. Wes On Thu,

Re: [Neo4j] cache_type in neo4j 2.0

2014-01-07 Thread Wes Freeman
It goes in neo4j.properties http://docs.neo4j.org/chunked/milestone/kernel-configuration.html Wes On Tue, Jan 7, 2014 at 10:59 AM, Alex Frieden wrote: > Hi all, I want to experiment with some changing in cache_type. However I > can't find it in any of the config files. Is it intentionally le

Re: [Neo4j] embedded API unique node creation using schema index

2014-01-03 Thread Wes Freeman
an executionengine when you want to return > say a node object? > > > On Thu, Jan 2, 2014 at 9:52 AM, Wes Freeman wrote: > >> The top example is using 2.0 indexes with constraints: >> >> http://docs.neo4j.org/chunked/snapshot/tutorials-java-embedded-unique-nodes.html#

Re: [Neo4j] embedded API unique node creation using schema index

2014-01-02 Thread Wes Freeman
The top example is using 2.0 indexes with constraints: http://docs.neo4j.org/chunked/snapshot/tutorials-java-embedded-unique-nodes.html#tutorials-java-embedded-unique-get-or-create On Thu, Jan 2, 2014 at 9:36 AM, Alex Frieden wrote: > Hi all, > I saw this: > http://docs.neo4j.org/chunked/snapsh

Re: [Neo4j] get all nodes and edges in a graph

2013-12-31 Thread Wes Freeman
Check out: http://api.neo4j.org/current/org/neo4j/tooling/GlobalGraphOperations.html Wes On Tue, Dec 31, 2013 at 10:06 PM, Puneet Arora wrote: > Hi, > I am trying to get all nodes and edges of the graph. > Though for the nodes I found a method getAllnodes() on > GraphDatabaseService, it is depre

Re: [Neo4j] Re: (neo4j-shell)-[:connect_to]->(graphene)

2013-12-31 Thread Wes Freeman
Yeah, very slick Nige. Wes On Tue, Dec 31, 2013 at 1:26 PM, Javad Karabi wrote: > nigel, thank you! this is great! > > > On Tuesday, December 31, 2013 12:17:58 PM UTC-6, Nigel Small wrote: > >> Hi Javad >> >> I have made some adjustments to neotool (http://book.py2neo.org/en/ >> latest/neotool/

Re: [Neo4j] sharing our experience so far in terms of challenges with neo4j 2.0

2013-12-31 Thread Wes Freeman
The lack of OR or IN index lookups are a pain for me as well. Looking forward to that one--hope it comes in a 2.0.x release rather than a 2.1 release. :) Happy new year! Wes On Tue, Dec 31, 2013 at 9:41 AM, Debajyoti Roy wrote: > We are our upgrading our current production system from neo4j 1.

Re: [Neo4j] fastest way to get back nodes

2013-12-30 Thread Wes Freeman
Can you explain what your filters are doing? Can you use an index? Wes On Mon, Dec 30, 2013 at 8:38 AM, Alex Frieden wrote: > Hi y'all, > > I am trying to filter through nodes to connect to the right node. > Currently I am doing this: > > ResourceIterable runNodes = > GlobalGraphOperations.at(

Re: [Neo4j] dark queries

2013-12-26 Thread Wes Freeman
Sounds like a SciFi movie. I've not heard of dark queries--is this something general or specific to Neo? You can configure the cache and set options depending on your use case. If you have enough RAM to fit everything, try a strong cache setting: http://docs.neo4j.org/chunked/milestone/configurati

Re: [Neo4j] Cypher Query to return all nodes and relationships under a tree

2013-12-23 Thread Wes Freeman
How do you want them to be returned. Is this good enough? MATCH (root:Customer)-[r*]->(child) WHERE root.id = {custId} AND NOT type(r) IN ["exception1", "exception2", "exception3"] RETURN * Wes On Mon, Dec 23, 2013 at 1:40 PM, Christopher Hydak wrote: > My graph is constructed with separate

Re: [Neo4j] Is GraphGist down?

2013-12-23 Thread Wes Freeman
It is working now. Wes On Mon, Dec 23, 2013 at 11:55 AM, Peter Neubauer < peter.neuba...@neotechnology.com> wrote: > Yeah, > Michael transferred it to Graphenedb and we need to restart. He will do it > ASAP. > > /peter > > (snt)-[:frm]->(phn) > On Dec 23, 2013 5:46 PM, "Karol Brejna" wrote: >

Re: [Neo4j] How to copy database from 1 server to another?

2013-12-22 Thread Wes Freeman
Shut down the database, tar up the files in data/graph.db/, and copy them to the other server. Wes On Mon, Dec 23, 2013 at 2:05 AM, Sukaant Chaudhary < sukaant.chaudh...@gmail.com> wrote: > Hi, > Please suggest me how to copy database from 1 server to another. > > -Sukaant Chaudhary > > -- > You

Re: [Neo4j] possible threading issue

2013-12-22 Thread Wes Freeman
Yes, it implies an index. And yes, you do need to drop it to add a unique constraint. Wes On Sun, Dec 22, 2013 at 10:17 PM, Javad Karabi wrote: > looks like i need to drop the index first? > > just to be clear, if a constraint is added, does this imply an index? > so, i dont need to worry about

Re: [Neo4j] error suddenly appeared

2013-12-22 Thread Wes Freeman
member > > and the same, but for other attributes, such as birthday, etc > essentially i use a combo of MERGE then CREATE UNIQUE to create > relationships, so yes, lots of relationships created. > > do you think this may have been the result of corrupted data? > > On Sunday,

Re: [Neo4j] error suddenly appeared

2013-12-22 Thread Wes Freeman
Oh, whoops, that's the relstore. What's your cypher query doing? Creating relationships? Can you share it? Wes On Sun, Dec 22, 2013 at 4:45 AM, Wes Freeman wrote: > Did your cypher query ask for a node id 918772, outside the normal range > of node ids you have? > > We

Re: [Neo4j] error suddenly appeared

2013-12-22 Thread Wes Freeman
Did your cypher query ask for a node id 918772, outside the normal range of node ids you have? Wes On Sun, Dec 22, 2013 at 4:40 AM, Javad Karabi wrote: > hello > > an error has suddenly appeared, seemingly out of the blue, when i try to > post a cypher query to my neo4j server. > > any idea wha

Re: [Neo4j] Update Python Embedded Binding for Neo4j 2.0

2013-12-20 Thread Wes Freeman
To elaborate: typically my best performance has been with "exec" batches of 100-200 statements, and "transactions" of 1000-1 statements total, but it depends on latency and bandwidth. Wes On Fri, Dec 20, 2013 at 4:34 PM, Wes Freeman wrote: > I've been able to

Re: [Neo4j] Update Python Embedded Binding for Neo4j 2.0

2013-12-20 Thread Wes Freeman
I've been able to get 20-30k/second sustained CREATE cypher statements with a single client over the transactional http endpoint. Wes On Fri, Dec 20, 2013 at 4:16 PM, Nigel Small wrote: > Hi Patrick > > There are a few ways of getting better performance over REST. Could you > elaborate on the "

Re: [Neo4j] Is GraphGist down?

2013-12-19 Thread Wes Freeman
Works on my windows 7 box. 31.0.1650.57 m Wes On Thu, Dec 19, 2013 at 11:00 PM, Luanne Coutinho wrote: > I checked on Chrome 31.0.1650.63 m on Windows 7 Professional (SP1) and > there are no Javascript errors, just the following warnings + log (and the > page loads perfectly): > > event.returnV

Re: [Neo4j] Sample monitoring code for neo4j and a question about REST output

2013-12-18 Thread Wes Freeman
an issue on this? > > > > On 12/18/2013 11:47 AM, Wes Freeman wrote: > > > And yeah you're right, ::1 doesn't work in the config file (which is odd), > but if you bind to :: you can connect to ::1. Just tested with my go driver > using the following connection s

Re: [Neo4j] Sample monitoring code for neo4j and a question about REST output

2013-12-18 Thread Wes Freeman
X is any number continues to work. If you change the type of X, it will fail. All other node-hitting queries failed, even if cached. Interesting experiment. Wes On Wed, Dec 18, 2013 at 1:47 PM, Wes Freeman wrote: > True, but it's possible for other queries to not touch the datast

Re: [Neo4j] Sample monitoring code for neo4j and a question about REST output

2013-12-18 Thread Wes Freeman
fail of the data store was hung or broken... > > I would assume your suggested query would not touch the data store. > > Is that a correct understanding? > > > > > On 12/18/2013 11:13 AM, Wes Freeman wrote: > > You can make it listen on :: if you set it in neo4j-server.

Re: [Neo4j] Is GraphGist down?

2013-12-18 Thread Wes Freeman
+1 on chrome working fine. I've never used anything else on graphgists. Wes On Wed, Dec 18, 2013 at 10:58 AM, Peter Neubauer < peter.neuba...@neotechnology.com> wrote: > Cool, > I am using Chrome with no problems. Do report back, and let us know any > input you have! > > /peter > > (snt)-[:frm]-

Re: [Neo4j] Sample monitoring code for neo4j and a question about REST output

2013-12-18 Thread Wes Freeman
You can make it listen on :: if you set it in neo4j-server.properties: # Let the webserver only listen on the specified IP. Default is localhost (only # accept local connections). Uncomment to allow any connection. Please see the # security section in the neo4j manual before modifying this. org.neo

Re: [Neo4j] Sample monitoring code for neo4j and a question about REST output

2013-12-17 Thread Wes Freeman
So, you have two options. You can change it to return type(r), or you can tell the transactional endpoint you want a more verbose output. http://docs.neo4j.org/chunked/milestone/rest-api-transactional.html#rest-api-execute-statements-in-an-open-transaction-in-rest-format-for-the-return 1) https:/

Re: [Neo4j] USE INDEX doesn't work when WHERE has IN

2013-12-17 Thread Wes Freeman
Same with OR. Please vote or post a new issue specific to IN: https://github.com/neo4j/neo4j/issues/861 Wes -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsu

Re: [Neo4j] Re: Math operation ( aggregation function result / 60 / 60 ) causes "SyntaxException: Unknown identifier"

2013-12-17 Thread Wes Freeman
For a workaround, you can get the aggregation first and then do the calculation: START n=node(0) WITH count(n) as count RETURN count/60/60 Wes On Tue, Dec 17, 2013 at 1:06 PM, Wes Freeman wrote: > This is definitely a bug, you should report on github issues. > > Wes > > > On

Re: [Neo4j] Re: Math operation ( aggregation function result / 60 / 60 ) causes "SyntaxException: Unknown identifier"

2013-12-17 Thread Wes Freeman
This is definitely a bug, you should report on github issues. Wes On Tue, Dec 17, 2013 at 12:58 PM, JDS wrote: > Sorry, doesn't have to be 60/60, it can be any number divided by the same > number which should of course just equal 1. > > > On Tuesday, December 17, 2013 5:57:33 PM UTC, JDS wrote: