I've been down the path BTW Jason, fun may not be the best description ;-) Granted this was about 4 years ago now so who knows what has changed. The biggest problem I had, by far, was that the proprietary API I needed to use was based on the assumption that it was dealing with JCR backed resources.
On Wed, May 2, 2018 at 8:33 AM, Jason E Bailey <j...@apache.org> wrote: > Thought that would be the answer. I'll check out the prototype, thanks. > > It'll be fun to write a ResourceProvider for this but it's going to have > to go to the bottom of my current list of things to get done in > Sling. > > - Jason > > On Wed, May 2, 2018, at 6:08 AM, Stefan Seifert wrote: > > hello jason. > > > > if you are using oak you might try the RDBDocumentStore [1] and > > RDBBlobStore [2] implementation (i've never used them myself). > > > > for using a lightweight approach accessing a RDBMS directly from a > > resource provider the is no support currently afaik. > > if you are looking for a generic storage of resource data in RDBMS the > > generic nosql support [3] might be a good starting point (although that > > is a bit outdated as well and I assume not much used in practice). if > > you want to write a specific resource provider for a "real data model" > > stored in RDBMS i did a very rough prototype some years ago, but never > > used it in real life [4]. > > > > stefan > > > > [1] > > http://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jac > krabbit/oak/plugins/document/rdb/RDBDocumentStore.html > > [2] > > http://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jac > krabbit/oak/plugins/document/rdb/RDBBlobStore.html > > [3] > > https://sling.apache.org/documentation/bundles/nosql-resourc > e-providers.html > > [4] https://adapt.to/2012/en/schedule/apache-sling-rdbms-mapping.html > > > > > > >-----Original Message----- > > >From: Jason E Bailey [mailto:j...@apache.org] > > >Sent: Tuesday, May 1, 2018 9:48 PM > > >To: users@sling.apache.org > > >Subject: SQL Resource Provider? > > > > > >Has anyone ever used a SQL resource provider or know where I can find > such > > >a thing? > > > > > >- Jason > > >