Neo4j

Hi there, Turns out I've got 2x community accounts, both "elena" and "elena1" are me. It makes perfect sense in that I use many different email addresses. elena Elena I'm a long time python user and elected member of the django software foundation who's quite engaged with the community. Generally I work on many small practical projects, though am currently wrapped up in running a medium-sized b… Joined September 6, 2018 elena1 Please merge me with "elena" Joined September 16, 2020 Personally I'd rather be canonical than enumerated and it would make life better if I were merged. Please let me know if this is possible and if so what I need to do. Kindest, Elena (and elena1) Discourse Meta – 1 Mar 18 Rake task for merging users As of Discourse 2.5.0.beta3, site admins can merge non-staff users without needing to access the console. For security, staff users will still need to be merged via the console. Visit the user admin page, and select “Transfer & Delete” at the... Reading time: 12 mins 🕑 Likes: 257 ❤ ... View more

Hi, I was searching for this but cannot find; is there any function among APOC functions to calculate trend (series of numbers)? Just one value (to know it goes up, down or not moving) not any 'regression line' or else. Would be nice to have such function ready to use. Regards ... View more

Brower 4.2.4 does not allow sorting or rearranging of favorites. I thought earlier version allowed this. ... View more

Just upgraded to Browser 4.2.4 on Windows 10 and noticed that the node and relationship properties scroll off the bottom of the screen when in full screen mode and subpanel editing uses multiple lines. As you keep adding lines in the subpanel more of the bottom of the window scroll out of sight but the scrollbar will not let you scroll to see that information. Add enough lines and the zoom buttons will disappear. ... View more

I noticed that the the APOC reverse function has been deprecated: Neo4j Graph Database Platform apoc.coll.reverse - APOC Documentation This section contains reference documentation for the apoc.coll.reverse function. I presume there will be an Ascending/Descending option for the various APOC functions? This doesn't seem to be explained in the APOC documentation. Also, there is an error in the documentation in: Neo4j Graph Database Platform apoc.coll.sortNodes - APOC Documentation This section contains reference documentation for the apoc.coll.sortNodes function. The example purportedly shows how to return sorted Nodes in name ascending order, but the doc forgot to mention that you need to insert ^ before the name property: so this apoc.coll.sortNodes(people, 'name') should be: apoc.coll.sortNodes(people, '^name') I tried editing using github page for apoc.coll.sortNodes but I'm not sure how to get to the actual github page with the example text to edit it. (Also, the example out of the box doesn't work with the Movie DB.) ... View more

Hi, I have done some PoC projects and playing around a bit with the Neo4j over the last 3-4 years and now starting a bit more serious project and considering using Neo4j for this project but things have changed a bit since I last used it on the licensing model. I will be ok with the community edition to start with but if things kick off I hopefully will need a lot of the enterprise functionality but the fact there is no indication of costs at neo4j.com, I am a bit reluctant to choose neo4j with the too many unknowns. I do understand pricing might be complex for very large projects but a price example for reference installation I believe would be good. And thanks for a great product! Best Regards, Stefan ... View more

In one of the examples, there's an example of Martin Sheen and Charlie Sheen related by the FATHER relationship. This is great, except these actors aren't in the Example DB and there are no FATHER relationships. (Marriage relationships too.) It would be nice to add that data to the sample Movie DB. Example page where the Sheens are used: Neo4j Graph Database Platform Maps - Neo4j Cypher Manual This section describes how to use maps in Cyphers. In addition, it would be also interesting to add these queries: Actors who are related to Martin Sheen but don't share the last name : Emilio Estevez Actors who share the last name of Sheen but aren't related: Michael Sheen. Another interesting property that could be added, would be the birth name of an actor. Another suggestion that I made elsewhere is including box office revenue and cost of making a film. Then one can make interesting queries about who was in movies that made the most money (in absolute terms and ROI.). Also nice would be showing how to format money amounts for display (e.g. $ and commas between 000). Also.... another issue I have with the URL above, is it uses some notation that's not really used in Neo4J: {nrOfMovies -> 2, name -> "Martin Sheen"} instead of {nrOfMovies : 2, name : "Martin Sheen"} ... View more

When you type (plural params) :help params you get info for :param instead of :params . These two have very different syntax! :param actorName => "Tom Hanks" :params { actorName : "Tom Hanks", movieTitle: 'The Matrix'} In addition, after entering either command, you get in the browser: See :help param for usage for the :param command. Whereas you probably should show both: See :help param for usage for the :param command (setting one parameter) See :help params for usage for the :params command (setting multiple parameters) The info for :help params is in the screen shot. (I would have done a copy and paste but copy from the Result cell in the Browser stops working after using the Browser after a while, which is driving me crazy! Browser 4.2.2, Server 4.2.2., Mac OS 10.15.7) It shows the info for param not :params ... View more

The line below say everything, it means being able to manipulate CONSTRAINTS commands as we do with PRIVILEGES. SHOW CONSTRAINT AS [DROP] COMMANDS Thank you for this amazing tool is Neo4j ... View more

Hi there, searching for "last_committed_tx_id" I got only 3 hits from an old documentation and the links lead to non existing pages (like https://neo4j.com/docs/java-reference/current/javadocs/org/neo4j/management/HighAvailability.html) Not dramatic though, I was able to find the correct page (Metrics reference - Operations Manual) using google... Best, Vincent. ... View more

When I’m looking at community posts, I can’t read content of posts because the font is light gray against white. I can see the titles, navigate, and the post I’m writing. Firefox and Edge also have this problem. This is on my iPhone 6S, iOS 14.2, Chrome and Safari. (Not sure how to get their versions.) More clues. This only happens after I login into my Neo4J account. When I'm not logged in, the background is dark, so the light text is visible. Also... no problems on Mac OSX with Chrome. ... View more

On this page: https://neo4j.com/docs/graph-data-science/1.5-preview/alpha-algorithms/pearson/ In section Section: 9.5.3.5. Specifying source and target ids Has a code section that has a variable name that's a bit jarring but doesn't affect the correctness of the example. (I assume that the example was changed from Cuisines to Movies) The variable personCuisines should be changed to personMovies in this code: MATCH (p:Person), (m:Movie) OPTIONAL MATCH (p)-[rated:RATED]->(m) WITH {item:id(p), name: p.name, weights: collect(coalesce(rated.score, gds.util.NaN()))} AS userData WITH collect(userData) AS personCuisines WITH personCuisines, [value in personCuisines WHERE value.name IN ["Praveena", "Arya"] | value.item ] AS sourceIds CALL gds.alpha.similarity.pearson.stream({ data: personCuisines, sourceIds: sourceIds, topK: 1 }) YIELD item1, item2, similarity WITH gds.util.asNode(item1) AS from, gds.util.asNode(item2) AS to, similarity RETURN from.name AS from, to.name AS to, similarity ORDER BY similarity DESC Also... to be consistent with the other Movie DB, the Move Property should be Move.title instead of Movie.name . ... View more

I'm going through the materials here: Neo4j Graph Database Platform Setup and Cypher Refresher - Applied Graph Algorithms with Neo4j 3.5 which refers to the step-by-step instructions here: https://guides.neo4j.com/applied_graph_algorithms/02_category_hierarchy.html It appears that the function algo.similarity.overlap() has already been run on the Yelp DB. I see there are already relationships [:NARROWER_THAN] prior to me running the function on the sandbox (as part of the exercise.) Also... The sandbox is running version Neo4J 3.5.17 which doesn't seem to be mentioned. This is important as the new version seems to have a different function call: CALL algo.similarity.overlap() // takes a write parameter vs. CALL gds.alpha.similarity.overlap() // actually, a separate write function https://neo4j.com/docs/graph-data-science/1.5-preview/alpha-algorithms/overlap/ Also... It appears that this has also been run on the YELP DB that's gets loaded into the SandBox. MATCH (g1:Category)-[:NARROWER_THAN*2..]->(g3:Category), (g1)-[d:NARROWER_THAN]->(g3) DELETE d The Browser reports that no changes were made. Also... Running the last query before running the other overlap queries returns nodes, which definitely means the Yelp DB already has the overlap relationships precreated: MATCH path = (category:Category)-[:NARROWER_THAN*]->(superCategory:Category) RETURN path LIMIT 10 ... View more

In URL: https://neo4j.com/docs/graph-data-science/current/alpha-algorithms/overlap/ [edit] after re-reading this a bunch of times, I now realize what's confusing is the intro sentence needs to be more expansive. Now, I'm not sure how it should be worded...[end-edit] There is this sentence which I found a confusing because it hints at stuff not yet described. It's vague in terms of names and numbers: The library contains both procedures and functions to calculate similarity between sets of data. The function is best used when calculating the similarity between small numbers of sets. The procedures parallelize the computation, and are therefore more appropriate for computing similarities on bigger datasets. I suggest that this intro sentence needs to summarize that there are read functions to calculate similarity, and there are write calculations that can write out the inter-relationships as well as a serial version and a parallel for large data sets. Or something.... I'm still a tad confused. Sorry. [I might edit this again, when I better understand what's going on...] [added] The Fantasy-SciFi category overlap example confuses me... Fantasy is not a subset of SciFi and vice versa. E.g. "The Once and Future King" is clearly (to me) a Fantasy genre. I can imagine (but can't think of one) where there is a very hard core SciFi that is nearly non-fiction and therefore it doesn't contain elements of Fantasy. In any case, it can be true that you have two categories that intersect and aren't proper subsets: e.g. Classics and SciFi. What is not mentioned in this doc, is how the procedure decides which to make the "From" and which to make "To" and what if there is a tie (in counts of the two set sizes)? The doc should note that with stream, that count1 <= count2 . This "section includes" needs to be broken out to include the write section. Also not clear from the documentation is that the function gds.alpha.similarity.overlap can take ONLY two lists. Whereas the function gds.alpha.similarity.overlap.stream can take 2 or more. (For me, the extra stream component in the function name doesn't hint at that difference enough, so the documentation needs to help with this gap.) Also... the documentation hints that the procedures can run parallel but it doesn't specify which ones. I wonder if the write procedure is indeed parallel as there could be race conditions if the underlying library isn't careful programmed. This is obvious, but there are a lot of newbies trying out Neo4J, so IMHO it's worth mentioning that 0<= similarity <= 1.0 Also not mentioned is that the values Y IELD 'ed item1 and item2 are Neo4j id 's and that function gds.util.asNode() is used to convert the id to a Node . (I had to look up gds.util.asNode ). [added]. I see that item1 and item2 are described at the bottom of the page. I think it would be clearer if what item1 and item2 are described when they are first used. Another point for clarification (I believe) is values for max and p95 in the gds.alpha.similarity.overlap.write example are 1.0000038146972656 . I presume this is due to a floating point math issues and it should be 1.0 . (Perhaps the code needs to enforce a maximum of 1.0 ?) Also... gds.alpha.similarity.overlap.stats example doesn't show the output. ... View more

I have a couple of suggestions to improve the documentation. Add some interesting numeric fields to the Movie DB, such as Cost and BoxOffice. I figured out an interesting example using SubQuery. Cost of a movie is many digits and varies a lot, so it's a bit hard to look at without formatting. But if you format the Cost as a string, then it won't sort numerically. With Subqueries, you can do a sort of the Cost as Numeric and in the subsequent query, drop the Numeric column (which is ugly but accurate.) CALL{ MATCH (m:Movie) WITH m.title AS Title, m.cost AS CostNumber, // cost as numeric so we can sort apoc.number.format(m.cost, '$#,###') AS Cost // as a formatted string RETURN title, Cost, CostNumber ORDER BY CostNumber DESC // ordered by Numeric } RETURN Title, Cost limit 100 // CostNumber is dropped ... View more

Full text indexing (Indexes for full-text search - Neo4j Cypher Manual ) works well for me except the default analyzer strips hyphens from indexing. Consider that the search for "Emergency" should not return "Non-Emergency". Product codes often have dashes in them too. This is actually a lucene question/issue. I did find this: stackoverflow.com Lucene Index problems with "-" character java, lucene, indexing, escaping asked by Zteve on 07:05AM - 17 Apr 12 UTC So this works: CALL db.index.fulltext.createNodeIndex("IndexName",["Label"],["property"], { analyzer: "classic"}) // does not throw out hyphens, e.g. Non-Emergency is one word This doesn't seem to be documented in the Neo4J documentation. ... View more

In SQL you can use variables previously defined with AS in subsequent clause, but Cypher doesn't seem to support that. in this (contrived) example, this doesn't work. The substr() won't accept fullname . WITH p.name AS fullname, substr(fullname, 0, 5) AS nickname The work around is to use two WITH statements (which is a bit uglier): WITH p.name AS fullname WITH fullname, substr(fullname, 0, 5) AS nickname It would be nice if Cypher could support this. ... View more

I just discovered yesterday, the use of WHERE with LOAD . This is really great as you can do controlled imports instead of blundering your way with the data. WHERE with LOAD is shown in an example, but not discussed here: Importing CSV Data into Neo4j - Developer Guides http://guides.neo4j.com/listings/file/import.html //skip null values LOAD CSV WITH HEADERS FROM 'file:///companies.csv' AS row WITH row WHERE row.Id IS NOT NULL MERGE (c:Company {companyId: row.Id}); In these URLs, LOAD with WHERE is not described at all, but would be useful: LOAD CSV - Neo4j Cypher Manual How-To: Import CSV Data with Neo4j Desktop - Developer Guides graphgist - Neo4j Graph Database Platform Using LOAD CSV for Import - Introduction to Neo4j 4.x Series Finally, as a feature request, it would be useful to add an argument for conditions for importing into the APOC: Neo4j Graph Database Platform Import CSV - APOC Documentation This section describes procedures that can be used to import data from CSV files that comply with the Neo4j import tool’s header format. ... View more

It seems after cloning a DB, subsequent queries take a very long time (perhaps infinite?) I did (with the Movie DB) MATCH (p:Person) RETURN p for which the browser shows "Started streaming 132 seconds after 7 ms and completed after 92 ms" I then went to the Desktop, clicked on the three dots and choose the menu item "Clone". After waiting for the clone to finish, then I reran the query which still hasn't finished. The problem seems to go away after you quit Neo4J app and start again. Neo4J 4.2.1. Mac OS 10.15.7 ... View more