Why would I use SQL vs. XPath queries?
I think this is pretty much a matter of taste and a matter of the existing expertise in your IT shop. If your developers are familiar with SQL, then I guess it would make more sense to use it. But, we should emphasize the fact that SQL query support is an optional feature of JCR implementations, so when making a decision you should make sure that the JCR implementation you are going to use supports it. Also, if you will need to be able to make your application work with different JCR applications then you may have a future problem when moving to a JCR implementation that does not support SQL querying. Q: How do I do a full-text search with JCR? A: The JSR-170 specification requires support for XPath-like querying. This includes also support for full-text search through XPath extension functions such as jcr:like and jcr:contains. The semantics of these functions are quite complex and I would recommend everybody to read the specification chapters. But, as a quick example let’s see how we
Related Questions
- What are the advantages of using SQL stored procedures instead of adhoc SQL queries in an ASP.NET web application?
- What are the advantages of using SQL stored procedures instead of adhoc SQL queries in an ASP.NET web application?
- How do I specify MySQL SQL queries on the UNIX / Linux command line?
- How do I specify MySQL SQL queries on the UNIX / Linux command line?
- Why would I use SQL vs. XPath queries?
- Explain open SQL vs native SQL?
