Re: [Neo4j] Where to draw the line between Neo4j and an RDBMS?

2018-09-01 Thread Kim Prince
Thanks Micheal,

That is a really concise summary.  I will post it as an answer on a related
stack exchange question.

Kim

On Sun, Sep 2, 2018 at 10:36 AM 'Michael Hunger' via Neo4j <
neo4j@googlegroups.com> wrote:

> I think from what you describe, you don't need a RDBMS.
>
> That is usually only needed in
>
> 1. existing systems that are already built on an RDBMS that are used from
> multiple applications and reporting systems
> 2. huge amounts of read-only properties, including BLOB/CLOB
> 3. loads of reporting queries that only run aggregations of the data
>
> Michael
>
>
> On Tue, Aug 28, 2018 at 12:15 AM, Kim Prince  wrote:
>
>> I am planning to build an application which relies heavily on a directed
>> graph (similar to a social graph).
>>
>> There is no doubt that Neo4j will be required, but I'm having trouble
>> deciding if I will also require an RDBMS.  Is there an easy way for me to
>> get a feel for this, other than just building the thing with Neo4j, and
>> introducing the RDBMS if/when I reach a choke point?
>>
>> Some details of the planned application are as follows:
>>
>>- Designed for 10's of thousands of users, if not 100's of thousands
>>- Business logic implemented using MVC (Laravel)
>>- Some mobile traffic, some desktop, access via an API
>>- Most DB activity will be reading from the graph
>>- Not a lot of reporting required
>>
>> There will be around 8 types of entities that I will definitely implement
>> as node types.  The primary focus of the application is the relationships
>> between these nodes.  If I incorporate an RDBMS, it will require around 30
>> tables for the remaining entities and their relationships.
>>
>> Any advice?
>>
>> --
>> 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+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Join our new Community Site & Forum 
>
> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Where to draw the line between Neo4j and an RDBMS?

2018-09-01 Thread 'Michael Hunger' via Neo4j
I think from what you describe, you don't need a RDBMS.

That is usually only needed in

1. existing systems that are already built on an RDBMS that are used from
multiple applications and reporting systems
2. huge amounts of read-only properties, including BLOB/CLOB
3. loads of reporting queries that only run aggregations of the data

Michael


On Tue, Aug 28, 2018 at 12:15 AM, Kim Prince  wrote:

> I am planning to build an application which relies heavily on a directed
> graph (similar to a social graph).
>
> There is no doubt that Neo4j will be required, but I'm having trouble
> deciding if I will also require an RDBMS.  Is there an easy way for me to
> get a feel for this, other than just building the thing with Neo4j, and
> introducing the RDBMS if/when I reach a choke point?
>
> Some details of the planned application are as follows:
>
>- Designed for 10's of thousands of users, if not 100's of thousands
>- Business logic implemented using MVC (Laravel)
>- Some mobile traffic, some desktop, access via an API
>- Most DB activity will be reading from the graph
>- Not a lot of reporting required
>
> There will be around 8 types of entities that I will definitely implement
> as node types.  The primary focus of the application is the relationships
> between these nodes.  If I incorporate an RDBMS, it will require around 30
> tables for the remaining entities and their relationships.
>
> Any advice?
>
> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Join our new Community Site & Forum 

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Re: Cannot merge node using null property value error when I load a csv file

2018-09-01 Thread 'Michael Hunger' via Neo4j
Only use the ID and filter out the null names or ids

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:///C:/Users/user/
Documents/NEWDATANEO4J/myfile.csv" AS line
WITH line where not line.ID_Actor is null
MERGE (a:Actor{id:line.ID_Actor})
ON CREATE SET a.name=line.NAME_ACTOR

Please join community.neo4j.com and ask there in the cypher category.

On Mon, Aug 20, 2018 at 3:34 PM, Rhianna Tomlinson  wrote:

> Have you tried removing the blank lines in your CSV?
>
>
> On Sunday, 5 August 2018 16:35:53 UTC+1, Youssef Mourchid wrote:
>>
>> Hi,
>>
>> when I was working in the previous version of neo4j (my actual version is
>> 3.2.5) everything was ok, when I want to load my csv file I use this
>> command:
>>
>> USING PERIODIC COMMIT
>> LOAD CSV WITH HEADERS FROM 
>> "file:///C:/Users/user/Documents/NEWDATANEO4J/myfile.csv"
>> AS line
>> MERGE (a:Actor{id_actor:line.ID_Actor,name_actor:toString(line.
>> NAME_ACTOR)})
>>
>> but now after upgrading my neo4j version, it shows me the error "
>> Neo.ClientError.Statement.SemanticError: Cannot merge node using null
>> property value for id_actor"
>>
>> my csv file is like that:
>>
>>
>> 
>>
>>
>>
>>
>>
>>
>> if anyone can help me with that, I would be very thankful.
>>
> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Allowing Access to Neo4J server from web server

2018-09-01 Thread 'Michael Hunger' via Neo4j
Did you configure the neo4j server to listen at the public IP? in
neo4j.conf uncomment the line with listen_address=0.0.0.0

Please join community.neo4j.com there is
https://community.neo4j.com/c/neo4j-graph-platform/operations for such
topics.

On Thu, Aug 23, 2018 at 4:15 PM, Mike Lawford  wrote:

> Hi All.
>
> I have installed Neo4J Enterprise and configured this on our test server
> (where web server and neo4j server exist on the same server) successfully.
>
> I then moved to our production environment where the web server and Neo4j
> servers are separated.  Our web server doesn't have access to write to the
> neo4J server via local IP though.  I guess I need to add something to the
> neo4j.conf file to allow this server access, but where and in what format?
>
> Thanks,
> Mike
>
> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] query responding blank data.

2018-09-01 Thread 'Michael Hunger' via Neo4j
If the data is already in the db then it will do nothing.

Please note that create unique is deprecated and should be replaced by
MERGE too.

There are some more issues, you should actually split it into multiple
statements.

Please post this in
https://community.neo4j.com/c/neo4j-graph-platform/import-export

On Tue, Aug 21, 2018 at 11:31 AM,  wrote:

> Hi,
>
> In my local am trying to excute below cypher queries to load data from
> azure and merger/create queries. It executed first time successfully then I
> deleted and re ran, but now queries are running successfully but doing
> nothing. Responding back *(no changes, no records).*
>
> LOAD CSV WITH HEADERS FROM "azure url of csv file" AS line
> MERGE(tsnvlocation:GeographyCity{Name:line.GeographyCity})
> MERGE(tsnvcontact:TSnVContact{Name:line.TSnVContact})
> MERGE(Need:Editedneed{Need:line.Editedneed,Priority:line.
> Priority,TimeFrame:line.TimeFrame})
> MERGE(LeadCompany:LeadCompany{LeadCompany:line.LeadCompany})
> MERGE(Companycontact:LeadCompanyContact{LeadContact:line.
> LeadCompanyContact})
> MERGE(CompanyTechnology:LeadcompanyTechnology{TechnologyName:line.
> LeadcompanyTechnology})
> CREATE UNIQUE (tsnvlocation)<-[:Location]-(tsnvcontact)
> CREATE UNIQUE (tsnvcontact)-[:Need]->(Need)
> CREATE UNIQUE (Need)-[:Lead_Company]->(LeadCompany)
> CREATE UNIQUE (LeadCompany)-[:Lead_Contact]->(Companycontact)
> CREATE UNIQUE (LeadCompany)-[:Lead_Technology]->(CompanyTechnology)
>
> Is there any kind of session which needs to be closed after first run.
> please help me on this.
>
> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Py2Neo - AttributeError: 'Graph' object has no attribute 'find_one'

2018-09-01 Thread 'Michael Hunger' via Neo4j
If you haven't would you mind asking in
https://community.neo4j.com/c/drivers-stacks/python ?

Thank you :)



On Tue, Aug 28, 2018 at 12:22 PM, Lukas Ott  wrote:

> I tried to rebuild https://nicolewhite.github.io/neo4j-flask/pages/
> register-a-user.html in Python 3 and Py2Neo V4 (current one).
>
> Flask is running and Neo4J is running on Ubuntu 18.04.
>
>
> When I want to register a new User I'll get " AttributeError: 'Graph'
> object has no attribute 'find_one' "
>
> In the documentation by Nicole White:
>  -> The User.find() method uses py2neo’s Graph.find_one()
>  method to
> find a node in the database with label :User and the given username,
> returning a py2neo.Node 
> object.
>
> So my question is with what function the find_one() method has been
> replaced in the current Py2Neo V4 Version?
>
> In the docuementation https://py2neo.org/v4/database.html I found: 
>
> match_one(*nodes=None*, *r_type=None*)[source]
> 
> 
>
> Match and return one relationship with specific criteria.
>
>
> Anyone has an idea on how to update?
>
> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[Neo4j] Where to draw the line between Neo4j and an RDBMS?

2018-09-01 Thread Kim Prince
I am planning to build an application which relies heavily on a directed 
graph (similar to a social graph).  

There is no doubt that Neo4j will be required, but I'm having trouble 
deciding if I will also require an RDBMS.  Is there an easy way for me to 
get a feel for this, other than just building the thing with Neo4j, and 
introducing the RDBMS if/when I reach a choke point?

Some details of the planned application are as follows:

   - Designed for 10's of thousands of users, if not 100's of thousands
   - Business logic implemented using MVC (Laravel)
   - Some mobile traffic, some desktop, access via an API
   - Most DB activity will be reading from the graph
   - Not a lot of reporting required

There will be around 8 types of entities that I will definitely implement 
as node types.  The primary focus of the application is the relationships 
between these nodes.  If I incorporate an RDBMS, it will require around 30 
tables for the remaining entities and their relationships.

Any advice?

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[Neo4j] Allowing Access to Neo4J server from web server

2018-09-01 Thread Mike Lawford
Hi All.

I have installed Neo4J Enterprise and configured this on our test server 
(where web server and neo4j server exist on the same server) successfully.

I then moved to our production environment where the web server and Neo4j 
servers are separated.  Our web server doesn't have access to write to the 
neo4J server via local IP though.  I guess I need to add something to the 
neo4j.conf file to allow this server access, but where and in what format?

Thanks,
Mike

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[Neo4j] Py2Neo - AttributeError: 'Graph' object has no attribute 'find_one'

2018-09-01 Thread Lukas Ott
I tried to rebuild 
https://nicolewhite.github.io/neo4j-flask/pages/register-a-user.html in 
Python 3 and Py2Neo V4 (current one).

Flask is running and Neo4J is running on Ubuntu 18.04.


When I want to register a new User I'll get " AttributeError: 'Graph' 
object has no attribute 'find_one' "

In the documentation by Nicole White:
 -> The User.find() method uses py2neo’s Graph.find_one() 
 method to 
find a node in the database with label :User and the given username, 
returning a py2neo.Node  
object. 

So my question is with what function the find_one() method has been 
replaced in the current Py2Neo V4 Version? 

In the docuementation https://py2neo.org/v4/database.html I found: 

match_one(*nodes=None*, *r_type=None*)[source] 
 

 

Match and return one relationship with specific criteria.


Anyone has an idea on how to update?

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
atomicwrites==1.2.0
attrs==18.1.0
backcall==0.1.0
bcrypt==3.1.4
certifi==2018.8.24
cffi==1.11.5
click==6.7
colorama==0.3.9
decorator==4.3.0
Flask==1.0.2
ipykernel==4.8.2
ipython==6.5.0
ipython-genutils==0.2.0
itsdangerous==0.24
jedi==0.12.1
Jinja2==2.10
jupyter-client==5.2.3
jupyter-console==5.2.0
jupyter-core==4.4.0
MarkupSafe==1.0
more-itertools==4.3.0
neo4j-driver==1.6.1
neotime==1.0.0
parso==0.3.1
passlib==1.7.1
pexpect==4.6.0
pickleshare==0.7.4
pkg-resources==0.0.0
pluggy==0.7.1
prompt-toolkit==1.0.15
ptyprocess==0.6.0
py==1.6.0
py2neo==4.1.0
pycparser==2.18
Pygments==2.2.0
pytest==3.7.3
python-dateutil==2.7.3
pytz==2018.5
pyzmq==17.1.2
simplegeneric==0.8.1
six==1.11.0
tornado==5.1
traitlets==4.3.2
urllib3==1.22
wcwidth==0.1.7
Werkzeug==0.14.1

[Neo4j] Re: Cannot merge node using null property value error when I load a csv file

2018-09-01 Thread Rhianna Tomlinson
Have you tried removing the blank lines in your CSV?

On Sunday, 5 August 2018 16:35:53 UTC+1, Youssef Mourchid wrote:
>
> Hi,
>
> when I was working in the previous version of neo4j (my actual version is 
> 3.2.5) everything was ok, when I want to load my csv file I use this 
> command:
>
> USING PERIODIC COMMIT
> LOAD CSV WITH HEADERS FROM 
> "file:///C:/Users/user/Documents/NEWDATANEO4J/myfile.csv" AS line
> MERGE 
> (a:Actor{id_actor:line.ID_Actor,name_actor:toString(line.NAME_ACTOR)})
>
> but now after upgrading my neo4j version, it shows me the error 
> "Neo.ClientError.Statement.SemanticError: 
> Cannot merge node using null property value for id_actor" 
>
> my csv file is like that:
>
>
> 
>
>
>
>
>
>
> if anyone can help me with that, I would be very thankful.
>

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Re: Another Native-Java-DSL for the Cypher Language

2018-09-01 Thread Analista de Sistemas Web/Mobile
tanks..

On Sat, Sep 1, 2018 at 5:40 AM Wolfgang Schuetzelhofer <
wschuetzelho...@gmail.com> wrote:

> Hi everybody,
>
> *JCypher* *4.0.1 *has been released.
>
> This is a bugfix release. What is fixed (changed):
>
>- minHops(0) now works correctly. Previously it was translated to
>cypher *..  or * respectively for specifying a link's min cardinality to be
>zero. However in practice this returns a min cardinality of one. Now
>minHops(0) is translated to cypher *0.. which works correctly. This also
>changes the behaviour of Domain Query expression DISTANCE(min, max) with a
>min of 0. This works correctly now but has changed it's behaviour, so you
>might need to adopt some of your queries.
>
> For what's new in JCypher,
> you may also want to have a look at the *release notes
> .*
> If you are interested about what will be in the next release(s), please
> have a look at *Outlook (Roadmap)*
> 
> .
> For a complete overview please start at JCypher's *Project Home Page
> .*
>
> best regards,
> Wolfgang Schuetzelhofer
>
> --
> 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+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
-- 
JOSÉ RIBAMAR FERREIRA JUNIOR
  ANALISTA DE SISTEMAS
Joinville - SC
   (47) 9844-23634
   (47) 3436-4774

web2a...@gmail.com
web2a...@hotmail.com

https://www.linkedin.com/in/josé-r-f-junior-b72b6b1a/

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[Neo4j] (Goodbye Google Groups)-[:WELCOME]->(Neo4j Community Site & Forum)

2018-09-01 Thread 'Michael Hunger' via Neo4j
Hello everyone,

We are very excited to announce our brand-new Neo4j Community Site and
Forum at community.neo4j.com based on Discourse. It's a place to ask
questions and to help others, but also to share things you've worked on and
to collaborate locally.

Thank you!

We want to thank you all for contributing to the growth, friendliness and
helpfulness of our Neo4j Community. Especially to everyone who patiently
answered questions.

Why are we moving?

As our user Slack grew to 8,750 members, it became more and more difficult
to answer questions properly, and many discussions descended into private
messages. :( Also, the 10,000 message limit made it impossible to find out
if a question was already answered, and required the helpful folks to
repeat themselves time and again. Others that encountered the same issues
, came to the
same conclusion

and moved to a dedicated forum, several of those also to Discourse as we
are doing.


The *Google Group* was also reduced to a trickle of messages over the last
years, only about 1-2 per day, so it is not worth keeping yet another
channel you need to watch.


*What will happen with the Google Group?*

We will stop using the Google Group, not sure if we'll close it down. At
least there will be no active monitoring or answering of questions anymore.


Please create an account with your social logins and introduce yourself.



To learn more you can watch the video .




If you ask questions please post in the correct category, but also search
first to see if your question has already been answered. It is also helpful
if you add additional tags. Please make sure to share all the details you
have for others to understand and reproduce your issue. Each category also
an introductory message, with a number of helpful links.

Join us and Win! 5x5x50

For the first 5 weeks we will be selecting 5 random users that have signed
up and introduced themselves to win a $50 USD coupon for the Neo4j Graph
Gear Store .

Looking forward to see you at GraphConnect NYC Sept 20-22
!

Or at least at the new Community Site :)

If you have any questions about the new site, please *reply* or ask in
the Feedback
category .

Cheers, Michael

for the Neo4j Developer Relations Team

* *

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[Neo4j] Re: Another Native-Java-DSL for the Cypher Language

2018-09-01 Thread Wolfgang Schuetzelhofer
Hi everybody,

*JCypher* *4.0.1 *has been released.

This is a bugfix release. What is fixed (changed):

   - minHops(0) now works correctly. Previously it was translated to cypher 
   *..  or * respectively for specifying a link's min cardinality to be zero. 
   However in practice this returns a min cardinality of one. Now minHops(0) 
   is translated to cypher *0.. which works correctly. This also changes the 
   behaviour of Domain Query expression DISTANCE(min, max) with a min of 0. 
   This works correctly now but has changed it's behaviour, so you might need 
   to adopt some of your queries.

For what's new in JCypher,
you may also want to have a look at the *release notes 
.*
If you are interested about what will be in the next release(s), please 
have a look at *Outlook (Roadmap)* 
.
For a complete overview please start at JCypher's *Project Home Page 
.*

best regards,
Wolfgang Schuetzelhofer

-- 
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.