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/jackrabbit/oak/plugins/document/rdb/RDBDocumentStore.html > [2] > http://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jackrabbit/oak/plugins/document/rdb/RDBBlobStore.html > [3] > https://sling.apache.org/documentation/bundles/nosql-resource-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 >