• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Neo4J vs SQL

 
Ranch Hand
Posts: 507
Netbeans IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 507
Netbeans IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks a lot for the reply. I really appreciate it
 
Saloon Keeper
Posts: 27763
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 15304
6
Mac OS X IntelliJ IDE Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

MS SQL is leading, even in Java.



I've been working in the Java space for 10 years and I worked with MSSQL once.
 
Yohan Weerasinghe
Ranch Hand
Posts: 507
Netbeans IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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???
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.)
 
Bartender
Posts: 612
7
Mac OS X Python
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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
 
They worship nothing. They say it's because nothing lasts forever. Like this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic