<div dir="ltr"><div><div><div><div><div><div>It seems I am getting a wee bit ambitious with this project as I am facing some difficulty pulling in Gremlin with SQL to pull into Java.<br><br></div>I am wondering how postgresql is pulled into my Java project. Is it something that I reference separately, or is it something that is pulled in through maven. If it is pulled in through maven, how do I configure it?<br><br></div>There is also a thing called commons.configuration that exposes the configuration object for postgres for the program to use.<br><br><a href="http://commons.apache.org/proper/commons-configuration/userguide/quick_start.html">http://commons.apache.org/proper/commons-configuration/userguide/quick_start.html</a><br><br></div>I asked around and I could do something like:<br><br>BaseConfiguration conf = new BaseConfiguration(); <br>conf.setProperty("jdbc.url", "jdbc:postgresql://localhost:5432/yourdb"); <br>Graph g = <a href="http://SqlgGraph.open">http://SqlgGraph.open</a> (conf);<br><br></div>but this only remotely seems to work if I do something like:<br><br>Configurations configs = new Configurations();<br> <br> try<br> {<br> PropertiesConfiguration config = configs.properties(new File("config.properties"));<br> // System.out.println(config.getProperty("jdbc.url"));<br> <br> } catch(ConfigurationException cex) {<br> <br> }<br><br></div>I will try to get some code up for review. In the meantime I have gremlin working in Java, but it operates on a loaded file in a graph format, and not a SQL database. I think SQL would be of more interest here, because I would hazard to guess most people wouldn't load a turtle file.<br><br></div>Then this meets my goal of achieving a functional way of writing a SQL query within Java. Ultimately, I am hoping for this too: <a href="http://sql2gremlin.com/">http://sql2gremlin.com/</a> .<br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature">-Brent Shambaugh<br><br>GitHub: <a href="https://github.com/bshambaugh" target="_blank">https://github.com/bshambaugh</a><br>Website: <a href="http://bshambaugh.org/" target="_blank">http://bshambaugh.org/</a><br>LinkedIN: <a href="https://www.linkedin.com/in/brent-shambaugh-9b91259" target="_blank">https://www.linkedin.com/in/brent-shambaugh-9b91259</a><br>Skype: brent.shambaugh<br>Twitter: <a href="https://twitter.com/Brent_Shambaugh" target="_blank">https://twitter.com/Brent_Shambaugh</a><br>WebID: <a href="http://bshambaugh.org/foaf.rdf#me" target="_blank">http://bshambaugh.org/foaf.rdf#me</a></div></div>
<br><div class="gmail_quote">On Fri, Mar 30, 2018 at 3:46 PM, Brent Shambaugh <span dir="ltr"><<a href="mailto:brent.shambaugh@gmail.com" target="_blank">brent.shambaugh@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Jason, here you go:<br><div><div><div><br>Topic: Gremlin - Using Graph Database Thinking to Make Database Queries Functional<br><br>How to use Gremlin, and how to write a Gremlin query within a Java program.<br><br>About the Speaker: <br><br>Brent grew up in Oklahoma and recently completed a stint in Vienna where he encountered the Gremlin.<br><br><br><br></div><div>Please let me know if you require any additional information.<br></div><div><br></div></div></div></div><div class="gmail_extra"><span class=""><br clear="all"><div><div class="m_991380329325599598gmail_signature" data-smartmail="gmail_signature">-Brent Shambaugh<br><br>GitHub: <a href="https://github.com/bshambaugh" target="_blank">https://github.com/bshambaugh</a><br>Website: <a href="http://bshambaugh.org/" target="_blank">http://bshambaugh.org/</a><br>LinkedIN: <a href="https://www.linkedin.com/in/brent-shambaugh-9b91259" target="_blank">https://www.linkedin.com/in/<wbr>brent-shambaugh-9b91259</a><br>Skype: brent.shambaugh<br>Twitter: <a href="https://twitter.com/Brent_Shambaugh" target="_blank">https://twitter.com/Brent_<wbr>Shambaugh</a><br>WebID: <a href="http://bshambaugh.org/foaf.rdf#me" target="_blank">http://bshambaugh.org/foaf.<wbr>rdf#me</a></div></div>
<br></span><div><div class="h5"><div class="gmail_quote">On Thu, Mar 29, 2018 at 3:10 PM, Jason Lee <span dir="ltr"><<a href="mailto:jason@steeplesoft.com" target="_blank">jason@steeplesoft.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>Hi, Brent. Would you happen to have an abstract ready? I'd like
to get everything scheduled and published pretty soon.</p>
<p>Thanks!</p><div><div class="m_991380329325599598h5">
<br>
<div class="m_991380329325599598m_-6557233829474448548moz-cite-prefix">On 3/20/2018 3:01 PM, Brent Shambaugh
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>Yes. It was the goal at the place that I worked to
explore the use of Gremlin for graph pattern traversal.
Gremlin seeks to do things in a highly functional way, and
I found it also has a means to for programmers to write
queries in their own native language without having to
embed the query syntax in their code (SQL for example).<br>
<br>
</div>
In order to prepare to understand Gremlin, I am finding that
I need to understand more about functional programming with
Java. <br>
<br>
</div>
I do not have a formal abstract yet, but I am working on notes
and I have worked with Gremlin through a REPL. <br>
<br>
</div>
Here is some stuff that I have written down so far:<br>
<div><br>
Graph use Cases: Internet of Things, Social Networks,
Communication Networks, Genomics, Epidemiology, Web, Semantic
Web, Data Integration, Recommendation, Asset Management,
Customer 360. <br>
[Source: Traversing Graphs with Gremlin (Artem Chebotko,
Solutions Architect at DataStax)], <a href="http://www.youtube.com/watch?v=mZmVnEzsDnY" target="_blank">http://www.youtube.com/watch?v<wbr>=mZmVnEzsDnY</a>
(mapping from functional programming to Gremlin [19m33s])<br>
<br>
Graphs are used by Google, Netflix, Facebook...<br>
<br>
Gremlin is a Path Traversal Language. (<a href="http://tinkerpop.apache.org/" target="_blank">http://tinkerpop.apache.org/</a>)
<br>
SPARQL is for Graph Pattern Matching.<br>
Compare with GraphQL...(differences from Gremlin)<br>
<br>
As an example, Gremlin provides a functional way to write SQL:<br>
<a href="http://sql2gremlin.com/" target="_blank">http://sql2gremlin.com/</a><br>
<br>
Gremlin avoids the use of lambda expressions.<br>
<br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="m_991380329325599598m_-6557233829474448548gmail_signature" data-smartmail="gmail_signature">-Brent
Shambaugh<br>
<br>
GitHub: <a href="https://github.com/bshambaugh" target="_blank">https://github.com/bshambaugh</a><br>
Website: <a href="http://bshambaugh.org/" target="_blank">http://bshambaugh.org/</a><br>
LinkedIN: <a href="https://www.linkedin.com/in/brent-shambaugh-9b91259" target="_blank">https://www.linkedin.com/in/br<wbr>ent-shambaugh-9b91259</a><br>
Skype: brent.shambaugh<br>
Twitter: <a href="https://twitter.com/Brent_Shambaugh" target="_blank">https://twitter.com/Brent_Sham<wbr>baugh</a><br>
WebID: <a href="http://bshambaugh.org/foaf.rdf#me" target="_blank">http://bshambaugh.org/foaf.rdf<wbr>#me</a></div>
</div>
<br>
<div class="gmail_quote">On Tue, Mar 20, 2018 at 12:49 PM, Mitch
Blevins <span dir="ltr"><<a href="mailto:mitchblevins@gmail.com" target="_blank">mitchblevins@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="auto">Two-phase commit</div>
<br>
<div class="gmail_quote">
<div>
<div class="m_991380329325599598m_-6557233829474448548h5">
<div dir="ltr">On Tue, Mar 20, 2018, 12:48 PM Jason
Lee <<a href="mailto:jason@steeplesoft.com" target="_blank">jason@steeplesoft.com</a>>
wrote:<br>
</div>
</div>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div class="m_991380329325599598m_-6557233829474448548h5">Am I right in reading that as "Yes, I
would love to present on this<br>
topic at the April JUG"? :)<br>
<br>
<br>
On 3/20/2018 7:22 AM, Brent Shambaugh wrote:<br>
> This sounds good to me too. Thanks. :)<br>
<br>
--<br>
Jason Lee<br>
<a href="http://jasondl.ee" rel="noreferrer
noreferrer" target="_blank">http://jasondl.ee</a><br>
<a href="http://jasondl.ee/twitter" rel="noreferrer
noreferrer" target="_blank">http://jasondl.ee/twitter</a><br>
<a href="http://jasondl.ee/in" rel="noreferrer
noreferrer" target="_blank">http://jasondl.ee/in</a><br>
<a href="http://jasondl.ee/+" rel="noreferrer
noreferrer" target="_blank">http://jasondl.ee/+</a><br>
<br>
</div>
</div>
<span>
______________________________<wbr>_________________<br>
Jug mailing list<br>
<a href="mailto:Jug@lists.okcjug.org" rel="noreferrer" target="_blank">Jug@lists.okcjug.org</a><br>
<a href="http://lists.okcjug.org/listinfo.cgi/jug-okcjug.org" rel="noreferrer noreferrer" target="_blank">http://lists.okcjug.org/listin<wbr>fo.cgi/jug-okcjug.org</a><br>
</span></blockquote>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="m_991380329325599598m_-6557233829474448548mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>_________________
Jug mailing list
<a class="m_991380329325599598m_-6557233829474448548moz-txt-link-abbreviated" href="mailto:Jug@lists.okcjug.org" target="_blank">Jug@lists.okcjug.org</a>
<a class="m_991380329325599598m_-6557233829474448548moz-txt-link-freetext" href="http://lists.okcjug.org/listinfo.cgi/jug-okcjug.org" target="_blank">http://lists.okcjug.org/listin<wbr>fo.cgi/jug-okcjug.org</a>
</pre>
</blockquote>
<br>
<pre class="m_991380329325599598m_-6557233829474448548moz-signature" cols="72">--
Jason Lee
<a class="m_991380329325599598m_-6557233829474448548moz-txt-link-freetext" href="http://jasondl.ee" target="_blank">http://jasondl.ee</a>
<a class="m_991380329325599598m_-6557233829474448548moz-txt-link-freetext" href="http://jasondl.ee/twitter" target="_blank">http://jasondl.ee/twitter</a>
<a class="m_991380329325599598m_-6557233829474448548moz-txt-link-freetext" href="http://jasondl.ee/in" target="_blank">http://jasondl.ee/in</a>
<a class="m_991380329325599598m_-6557233829474448548moz-txt-link-freetext" href="http://jasondl.ee/+" target="_blank">http://jasondl.ee/+</a></pre>
</div></div></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>