[Neo4j] Neo4j Spatial, Cypher and index on Layer

2014-01-30 Thread Pattabi
Hi, I am using geoserver with neo4j plugin. I have a requirement to show heat map in geoserver. I got this working by exporting a cypher query result into Postgres, imported shapefile to postgis and used SQL view of Geoserver to join the imported data with the shapefile neo4j version is 1.9.5 w

Re: [Neo4j] Enhancement request: database triggers

2014-01-30 Thread Jacob Hansson
Brian, this is very much a reasonable request, and would be a great feature to add. We will take it into consideration. I think something like this is not so much a question of if but of when and getting feedback helps decide what to prioritize. That said, there are a lot of great things we want

[Neo4j] Enhancement request: database triggers

2014-01-30 Thread brian
When we moved our code to Neo4j 2.0, we ran into a problem caused by a change in behavior to the TransactionEventHandler and the way in which Cypher query results are returned in the REST API. (See this issue https://github.com/neo4j/neo4j/issues/1884). We were using a TransactionEventHandler i

Re: [Neo4j] How do you assign properties to a relationship between two nodes, taking the properties of a variable "props"?

2014-01-30 Thread Michael Hunger
ouch !! You should never string format properties that are none. the only thing that you need to insert into the string is the rel-type all others, please pass in as parameters. > var props : any = { "fromNodeId":1000, "toNodeId":1002 ,"props" : { > "position" : "Developer", "name" : "Michael",

[Neo4j] Re: How do you assign properties to a relationship between two nodes, taking the properties of a variable "props"?

2014-01-30 Thread Alessandro Severa
sorry, the code I have on this program is this: (which is what does not work) var relType: string = "EXERCISES"; var props : any = { "props" : { "position" : "Developer", "name" : "Michael", "awesome" : "true" }}; var statement = util.format("START a=node({fromNodeId}), b=node({toNodeId}) CREAT

Re: [Neo4j] Re: I deleted root=node(0) by accident, now what?

2014-01-30 Thread Michael Hunger
Sean, the reference node was removed in Neo4j 2.0 so it shouldn't be a problem. Otherwise just shut down your db, so that id's will be reused and after startup the next created node will get id 0. Michael Am 30.01.2014 um 14:58 schrieb Sean Sill : > Any updates on this particular problem? >

Re: [Neo4j] Re: I deleted root=node(0) by accident, now what?

2014-01-30 Thread Sean Sill
Fantastic! Thanks! On Thu, Jan 30, 2014 at 9:33 AM, Michael Hunger < michael.hun...@neopersistence.com> wrote: > Sean, > > the reference node was removed in Neo4j 2.0 so it shouldn't be a problem. > > Otherwise just shut down your db, so that id's will be reused and after > startup the next cre

Re: [Neo4j] Re: ignore case search Neo4j

2014-01-30 Thread Michael Hunger
Yes true. This will only work well if you have only a few nodes with that label in your db. Otherwise it will fully scan all nodes and load their properties and then do the check with a regexp all of which is expensive. Michael Am 30.01.2014 um 14:30 schrieb Tom Zeppenfeldt : > Case insensit

Re: [Neo4j] Re: I deleted root=node(0) by accident, now what?

2014-01-30 Thread Sean Sill
Any updates on this particular problem? On Sunday, June 10, 2012 4:24:21 AM UTC-4, Peter Neubauer wrote: > > Mat, > Could you please raise a feature request for this? > > Send from mobile. > On Jun 8, 2012 8:35 PM, "Mat Tyndall" > > wrote: > >> So the solution I wound up going with was to just

[Neo4j] Re: ignore case search Neo4j

2014-01-30 Thread Tom Zeppenfeldt
Case insensitive searches can be done with regular expressions, e.g. match (n:Person) where n.name=~'(?i).*a.*' return n.name which would also return results including Andre, andre, Michael On Thursday, 30 January 2014 14:17:53 UTC+1, Navrattan Yadav wrote: > > hi. i am using Neo4j 2.0. I wan

Re: [Neo4j] ignore case search Neo4j

2014-01-30 Thread Michael Hunger
That's possible with a legacy fulltext index which also does case insensitive matches. Michael Am 30.01.2014 um 14:49 schrieb Navrattan Yadav : > currently properties is not indexed with a legacy lucene index. > > also i want to seach by a single word either properties has multi word : > > l

Re: [Neo4j] Query at Console and Java code are behaving differently

2014-01-30 Thread Michael Hunger
Sorry, no idea. Could you share a runnable unit test that shows that behavior? Michael Am 30.01.2014 um 15:18 schrieb Sukaant Chaudhary : > Hi Michael, > Please help what I'm doing wrong here. > > -Sukaant Chaudhary > > > On Thu, Jan 30, 2014 at 4:30 PM, Michael Hunger > wrote: > Are you 10

[Neo4j] How do you assign properties to a relationship between two nodes, taking the properties of a variable "props"?

2014-01-30 Thread Alessandro Severa
Hi, the problem I have is the following. using nodejs (javascript) I'm trying to create a relationship between two nodes of the database Neo4j and this report I'm going to have to create assign the properties. This property is written in a variable "props", I am writing under the lines of code

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

2014-01-30 Thread Chris Leishman
The `USING INDEX` sub-clause is only for giving Neo4j a hint as to the index to use. Normally it will work that out for itself, and you shouldn't need to use it. In your case, you have two indexes: one on :Person(name) and the other :Person(job). To use either of those indexes in a query, the C

Re: [Neo4j] Query at Console and Java code are behaving differently

2014-01-30 Thread Sukaant Chaudhary
Hi Michael, Please help what I'm doing wrong here. -Sukaant Chaudhary On Thu, Jan 30, 2014 at 4:30 PM, Michael Hunger < michael.hun...@neopersistence.com> wrote: > Are you 100% sure you have the same data initially? If one of the start > nodes is not matched it doesn't do anything. > > Can you

Re: [Neo4j] ignore case search Neo4j

2014-01-30 Thread Navrattan Yadav
currently properties is not indexed with a legacy lucene index. also i want to seach by a single word either properties has multi word : like node has name : Peter Neubauer then it can be search by : Peter as well as by : Neubauer On Thu, Jan 30, 2014 at 6:56 PM, Michael Hunger < michael.hun.

Re: [Neo4j] ignore case search Neo4j

2014-01-30 Thread Michael Hunger
if you have indexed the property with a legacy lucene index (fulltext index for ignoring case) you can do: > START n = node:Name("Name:john") > return n; for multi words I think you have do it like this > START n = node:Name("Name:john michle") > return n; Am 30.01.2014 um 14:17 schrieb N

[Neo4j] ignore case search Neo4j

2014-01-30 Thread Navrattan Yadav
hi. i am using Neo4j 2.0. I want to search by a properties value with ignore case and also with like operator. eg. Node has properties > Name : John Michle then want to search by : john, John,john Michle etc. i try : START n = node:Name("Name=*john*") return n; but not get result. -- Yo

Re: [Neo4j] Performance in Neo4j

2014-01-30 Thread Michael Hunger
But isn't that code rather doing: > MATCH (n:Equipment)<-[IS_INSIDE|CONNECTED_TO*]-(m:Cable) where n.name = > "name" RETURN m Also shouldn't you also check visited for both loops ? Otherwise you keep adding the same nodes time and again? Can you add some counters in the 3 loops to see how ofte

Re: [Neo4j] Performance in Neo4j

2014-01-30 Thread Alina Arm
private static void findParh(Node endNode) throws InterruptedException{ Stack stack = new Stack(); stack.push(endNode); RelationshipType is_inside_type = DynamicRelationshipType.withName("IS_INSIDE"); RelationshipType connected_to_type = DynamicRelationshipType.withName("CONNECTED_TO"); while(

Re: [Neo4j] Query at Console and Java code are behaving differently

2014-01-30 Thread Sukaant Chaudhary
Hi Michael, I'm testing this with the same database, and same query and parameters I've passed in both the case. I only change the node no i.e. 2 or 4 in both the cases (means used 2 and 4 in both the cases). I've copied those queries only which I've used. Here What I'm facing in my Java code is F

Re: [Neo4j] Performance in Neo4j

2014-01-30 Thread Michael Hunger
Can you share your java code? Do you run the bidirectional pattern matcher? How much RAM do you have in total? What kind of disk and OS ? How many :Cable nodes do you have? And how many :Equipment nodes? How many paths are returned from that query? Have you considered limiting the max depth?

Re: [Neo4j] Can neo4j be run in memory only?

2014-01-30 Thread Michael Hunger
What do you want to do? Michael Am 29.01.2014 um 02:06 schrieb Tu Nguyen : > Hi all, > > Is it possible to run Neo4J in memory only without any persistent > database/file storage? > > I found the answer in the following thread, but it's 3 years ago: > http://lists.neo4j.org/pipermail/user/20

Re: [Neo4j] Query at Console and Java code are behaving differently

2014-01-30 Thread Michael Hunger
Are you 100% sure you have the same data initially? If one of the start nodes is not matched it doesn't do anything. Can you also do a diff for the 2 queries and confirm that they only differ in the params? Thanks Michael Am 30.01.2014 um 11:10 schrieb Sukaant Chaudhary : > Hi, > If I'm usin

[Neo4j] Performance in Neo4j

2014-01-30 Thread Alina Arm
I have a database with 2.217.731 nodes and 3.127.475 relationships, where nodes are different equipment and relationships between them are like "CONNECTED_TO", "IS_INSIDE", etc. I am trying to traverse the graph to find specific nodes. In Cypher it would look like MATCH (n:Equipment)<

[Neo4j] Can neo4j be run in memory only?

2014-01-30 Thread Tu Nguyen
Hi all, Is it possible to run Neo4J in memory only without any persistent database/file storage? I found the answer in the following thread, but it's 3 years ago: http://lists.neo4j.org/pipermail/user/2010-February/002719.html If Neo4J does not support, please can you suggest any frameworks th

[Neo4j] Query at Console and Java code are behaving differently

2014-01-30 Thread Sukaant Chaudhary
Hi, If I'm using the following query from the console then it is working fine: But when I'm using it at my Java Code then at the first time it is creating relation without deleting but when I pass the same data again then it works. Please help me what is the issue at Java Query. Here I'm using n=n