[jira] Created: (SOLR-373) Build a JDBC driver to access Solr

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (SOLR-373) Build a JDBC driver to access Solr

Soren Daugaard (Jira)
Build a JDBC driver to access Solr
----------------------------------

                 Key: SOLR-373
                 URL: https://issues.apache.org/jira/browse/SOLR-373
             Project: Solr
          Issue Type: New Feature
          Components: search, update
            Reporter: Thomas Peuss
            Priority: Minor


Hello!

Would it be a good thing to have a JDBC driver to access Solr? This would help people only knowing SQL syntax. And you can use things like Hibernate on top of that. Maybe this is a good alternative to Solrj. In the first run I would not allow any joins.

I think of a SQL syntax like

SELECT * FROM SOLR WHERE name='Albert' OR name='Einstein'

which gets translated to a Solr query like

q=name:Albert OR name:Einstein&fl=*

What do you think?

CU
Thomas

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (SOLR-373) Build a JDBC driver to access Solr

Soren Daugaard (Jira)

    [ https://issues.apache.org/jira/browse/SOLR-373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12532478 ]

Yousef Ourabi commented on SOLR-373:
------------------------------------

Thomas,
[ I'm not a solr-dev, these are just my thoughts / opinions ]

I think that's a really horrible idea. That would promote the idea that solr is a relational database, and not a search index (inverted index).  Here are my

>> This would help people only knowing SQL syntax
I think the query syntax is actually simpler than sql, anyone can pick it up in an hour or so of playing around with the documentation.

>> In the first run I would not allow any joins.
That's the entire point of a relational database, see first paragraph, solr/lucene is not a relational database.

-Yousef

> Build a JDBC driver to access Solr
> ----------------------------------
>
>                 Key: SOLR-373
>                 URL: https://issues.apache.org/jira/browse/SOLR-373
>             Project: Solr
>          Issue Type: New Feature
>          Components: search, update
>            Reporter: Thomas Peuss
>            Priority: Minor
>
> Hello!
> Would it be a good thing to have a JDBC driver to access Solr? This would help people only knowing SQL syntax. And you can use things like Hibernate on top of that. Maybe this is a good alternative to Solrj. In the first run I would not allow any joins.
> I think of a SQL syntax like
> SELECT * FROM SOLR WHERE name='Albert' OR name='Einstein'
> which gets translated to a Solr query like
> q=name:Albert OR name:Einstein&fl=*
> What do you think?
> CU
> Thomas

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (SOLR-373) Build a JDBC driver to access Solr

Soren Daugaard (Jira)
In reply to this post by Soren Daugaard (Jira)

    [ https://issues.apache.org/jira/browse/SOLR-373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543408 ]

Ryan McKinley commented on SOLR-373:
------------------------------------

What do you see as the value for a JDBC driver?  Are there good examples of packages that would "just work" if solr had a JDBC driver?

Beyond a toy examples, stuffing a solr response into rows/columns will get very limiting very fast.  

> Build a JDBC driver to access Solr
> ----------------------------------
>
>                 Key: SOLR-373
>                 URL: https://issues.apache.org/jira/browse/SOLR-373
>             Project: Solr
>          Issue Type: New Feature
>          Components: search, update
>            Reporter: Thomas Peuss
>            Priority: Minor
>
> Hello!
> Would it be a good thing to have a JDBC driver to access Solr? This would help people only knowing SQL syntax. And you can use things like Hibernate on top of that. Maybe this is a good alternative to Solrj. In the first run I would not allow any joins.
> I think of a SQL syntax like
> SELECT * FROM SOLR WHERE name='Albert' OR name='Einstein'
> which gets translated to a Solr query like
> q=name:Albert OR name:Einstein&fl=*
> What do you think?
> CU
> Thomas

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Resolved: (SOLR-373) Build a JDBC driver to access Solr

Soren Daugaard (Jira)
In reply to this post by Soren Daugaard (Jira)

     [ https://issues.apache.org/jira/browse/SOLR-373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ryan McKinley resolved SOLR-373.
--------------------------------

    Resolution: Later

I'll close the issue now...  feel free to re-open it if you have a patch.

In the future, it may be a good idea to pass ideas through the user groups to get some initial feedback.

> Build a JDBC driver to access Solr
> ----------------------------------
>
>                 Key: SOLR-373
>                 URL: https://issues.apache.org/jira/browse/SOLR-373
>             Project: Solr
>          Issue Type: New Feature
>          Components: search, update
>            Reporter: Thomas Peuss
>            Priority: Minor
>
> Hello!
> Would it be a good thing to have a JDBC driver to access Solr? This would help people only knowing SQL syntax. And you can use things like Hibernate on top of that. Maybe this is a good alternative to Solrj. In the first run I would not allow any joins.
> I think of a SQL syntax like
> SELECT * FROM SOLR WHERE name='Albert' OR name='Einstein'
> which gets translated to a Solr query like
> q=name:Albert OR name:Einstein&fl=*
> What do you think?
> CU
> Thomas

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (SOLR-373) Build a JDBC driver to access Solr

Soren Daugaard (Jira)
In reply to this post by Soren Daugaard (Jira)

    [ https://issues.apache.org/jira/browse/SOLR-373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12554927 ]

Otis Gospodnetic commented on SOLR-373:
---------------------------------------

Actually, a fun exercise around this might be interesting and might be more suitable for Lucene, a SQL SELECT to Lucene Query converter.  I'm not sure if there is a real need for this, but it might be interesting to do this, and new ideas may come up during the development.

> Build a JDBC driver to access Solr
> ----------------------------------
>
>                 Key: SOLR-373
>                 URL: https://issues.apache.org/jira/browse/SOLR-373
>             Project: Solr
>          Issue Type: New Feature
>          Components: search, update
>            Reporter: Thomas Peuss
>            Priority: Minor
>
> Hello!
> Would it be a good thing to have a JDBC driver to access Solr? This would help people only knowing SQL syntax. And you can use things like Hibernate on top of that. Maybe this is a good alternative to Solrj. In the first run I would not allow any joins.
> I think of a SQL syntax like
> SELECT * FROM SOLR WHERE name='Albert' OR name='Einstein'
> which gets translated to a Solr query like
> q=name:Albert OR name:Einstein&fl=*
> What do you think?
> CU
> Thomas

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (SOLR-373) Build a JDBC driver to access Solr

Soren Daugaard (Jira)
In reply to this post by Soren Daugaard (Jira)

    [ https://issues.apache.org/jira/browse/SOLR-373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12571293#action_12571293 ]

Ian Holsman commented on SOLR-373:
----------------------------------

another alternative would be to use something like sphinx (http://www.sphinxsearch.com/).
While it isn't lucene, it might be better for your needs.

> Build a JDBC driver to access Solr
> ----------------------------------
>
>                 Key: SOLR-373
>                 URL: https://issues.apache.org/jira/browse/SOLR-373
>             Project: Solr
>          Issue Type: New Feature
>          Components: search, update
>            Reporter: Thomas Peuss
>            Priority: Minor
>
> Hello!
> Would it be a good thing to have a JDBC driver to access Solr? This would help people only knowing SQL syntax. And you can use things like Hibernate on top of that. Maybe this is a good alternative to Solrj. In the first run I would not allow any joins.
> I think of a SQL syntax like
> SELECT * FROM SOLR WHERE name='Albert' OR name='Einstein'
> which gets translated to a Solr query like
> q=name:Albert OR name:Einstein&fl=*
> What do you think?
> CU
> Thomas

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.