aspose file tools*
The moose likes Neo4j and the fly likes Neo4J vs SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Neo4j
Bookmark "Neo4J vs SQL" Watch "Neo4J vs SQL" New topic
Author

Neo4J vs SQL

Yohan Weerasinghe
Ranch Hand

Joined: Oct 07, 2010
Posts: 499

Glad to be the first poster here. I am in Coderanch history now

1. I went through the Neo4J opensource project. Is there any possibility this thing get into the field than SQL? For now, MS SQL is leading, even in Java. The only good competitor is Oracle database. Do you think that Neo4J will beat SQL, and companies will ask for Neo4J as a requrement when hiring people, instead of SQL?

2. Next question, imagine I am gonna learn this. Can I use the simple JDBC for this? Like,


?

Thats the JDBC we normally use with SQL. Is this is valid with this?

3. How is the Java support?


Are you better than me? Then please show me my mistakes..
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18657
    
    8

1. SQL isn't going away. There are millions of SQL databases out there. What is happening is that non-SQL databases are becoming more popular. Whether they start to become items on the laundry lists which hiring companies use is anybody's guess.

2. A quick look through the tutorial should answer that question. (Actually the short answer is "No" but you might want a bit more detail than that.)

3. It's got API documentation. It's got a Google Groups mailing list.

I'm finding all those answers (except #1) on the Neo4j home page. Have a look there yourself and see what else you can find out.
Yohan Weerasinghe
Ranch Hand

Joined: Oct 07, 2010
Posts: 499

Thanks a lot for the reply. I really appreciate it
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16142
    
  21

At the moment, I don't have MS SQL Server running at my location at all. I did a little Oracle in the cloud, but last week was spent doing very large data operations on MySQL, I also have an extensive amount of PostgreSQL, and both run and support IBM DB2 for one of my biggest clients. Then there's SQLite, which is the DBMS bundled with Android and also used by the "Gourmet Recipe Manager" open-source product that keeps my cooking files. SQLite is also used by the YUM package manager in the Linux OS, I think.

So I don't think SQL is going away very quickly.

On the other hand, I have a very small project that I want to publish open-source that's well-suited for Neo4J and I've got it set up using the Spring Data Neo4j support classes as a Maven project.

It works pretty well as far as the data part goes. The only reason it isn't complete is that I'm in a long bitter struggle with a certain GUI framework.


Customer surveys are for companies who didn't pay proper attention to begin with.
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

MS SQL is leading, even in Java.


I've been working in the Java space for 10 years and I worked with MSSQL once.


GenRocket - Experts at Building Test Data
Yohan Weerasinghe
Ranch Hand

Joined: Oct 07, 2010
Posts: 499

Gregg Bolinger wrote:
MS SQL is leading, even in Java.


I've been working in the Java space for 10 years and I worked with MSSQL once.


Really???
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61426
    
  67

Really. I've had exactly one, one, client using MS SQL. And that was only because he was migrating out of the Microsoft/Windows world into Java/Linux. Eventually, that will be replaced with MySQL or PostgreSQL.

Every other job I've worked, or client I've done work for, has used something other than MS SQL.

Just because your own experience may be heavy with MS ware, doesn't mean that's true everywhere.

(I remember a rather heated discussion -- not sure if it was here or not -- where someone insisted that MS Access was "the big one" in use everywhere, and all other databases were doomed. Turns out that that was all they used at his school, which he took to be the whole world.)


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Steve Fahlbusch
Bartender

Joined: Sep 18, 2000
Posts: 570
    
    7

MS SQL is leading, even in Java.


Umm sorry, i really beg to differ - please cite your sources as client side imbedded databases (mostly non SQL, but some) dwarf the server back end db's.

But back to the subject - and more generic.....

MS SQL is a 'fine' database engine but once again we are forced to map our data to a relational model. This is a 'good' model for general data processing, but they mostly s**k for specialized applications. Sorry, just the way it is.

What NoSQL DBs provide us is a way to map to a custom database (where we can change the definition on the fly) that matches our needs and has horizontal scaling.

Now you in your career may never, ever need to have ability. But i for one really like having this in my took kit.

Think about this. You are working for (or have) a company that is servicing N customers. You are successful and need to expand. On a NoSQL database, just add another virtual server in your cluster or (for a price) in the cloud - and you are good. Now think of what you had do to if you were tied to a MS SQL backend (license issues).

-steve
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17257
    
    6

Tim Holloway wrote:At the moment, I don't have MS SQL Server running at my location at all. I did a little Oracle in the cloud, but last week was spent doing very large data operations on MySQL, I also have an extensive amount of PostgreSQL, and both run and support IBM DB2 for one of my biggest clients. Then there's SQLite, which is the DBMS bundled with Android and also used by the "Gourmet Recipe Manager" open-source product that keeps my cooking files. SQLite is also used by the YUM package manager in the Linux OS, I think.

So I don't think SQL is going away very quickly.

On the other hand, I have a very small project that I want to publish open-source that's well-suited for Neo4J and I've got it set up using the Spring Data Neo4j support classes as a Maven project.

It works pretty well as far as the data part goes. The only reason it isn't complete is that I'm in a long bitter struggle with a certain GUI framework.


I am also using Spring Data Neo4j. And I love it. And my app also has an SQL database for Spring Batch. So it is never going to be a NoSQL vs SQL issue. It is about looking at all your data and using multiple types of databases for parts of your data. So some data in your app might be perfect for a Graph NoSQL database, some in a Key-Value pair database, and the rest in SQL. It just gives you more choices to get the best and fastest database for that part of your data.

And in my 20 years of a developer on many companies and projects, I have never used MS SQL.

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Neo4J vs SQL