You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Chris Collins <ch...@gmail.com> on 2008/03/27 17:26:47 UTC

Newbie question

Sorry if people ask this frequently, didnt find a reference to anything like
this.

Within some other database platforms one is capable of adding virtual tables
that could be backed by ones own non persisted data.  An example usage can
be reviewed in the following book:

http://nostarch.com/frameset.php?startat=appliance

Here the postgres engine is used as the central place for controlling an
appliance.  Using this as a communication conduit to other appliance
services.

Anyway, is there a way to add ones own table that ultimately provides the
appropriate callbacks to ones own code?
This would be similar to the SYS* tables.

Thanks in advance

Chris

Re: Newbie question

Posted by Dy...@Sun.COM.
Dyre.Tjeldvoll@Sun.COM writes:

> Chris Collins <ch...@gmail.com> writes:
>
>> Select is a good start, procedures would probably work to some extent,
>> though one can imagine that some of the power is lost if for say I wanted to
>> perform an insert into that pseudo table.
>>
>> I am syncing 10.4 source tree as I write this email.
>
> There is a beta out at
>
> http://people.apache.org/~dyre/derby-10.4.1.0-beta/
>
> if you don't want to build from source...

Be adviced, however, that this is NOT formally an Apache Beta Release as it
has not been voted on by the Derby community. 

-- 
dt

Re: Newbie question

Posted by Dy...@Sun.COM.
Chris Collins <ch...@gmail.com> writes:

> Select is a good start, procedures would probably work to some extent,
> though one can imagine that some of the power is lost if for say I wanted to
> perform an insert into that pseudo table.
>
> I am syncing 10.4 source tree as I write this email.

There is a beta out at

http://people.apache.org/~dyre/derby-10.4.1.0-beta/

if you don't want to build from source...

-- 
dt

Re: Newbie question

Posted by Chris Collins <ch...@gmail.com>.
Select is a good start, procedures would probably work to some extent,
though one can imagine that some of the power is lost if for say I wanted to
perform an insert into that pseudo table.

I am syncing 10.4 source tree as I write this email.

Thanks so much for peoples fast, detailed and on the topic responses.

Chris

On Thu, Mar 27, 2008 at 9:51 AM, Rick Hillegas <Ri...@sun.com>
wrote:

> Hi Chris,
>
> I may be misunderstanding your question so please bear with me. The
> upcoming 10.4 release of Derby will provide a feature called Table
> Functions. This will let you make your external data look like a table
> to Derby so that you can issue SELECTs against it. The feature is
> described by the functional spec attached to this JIRA: DERBY-716. User
> documentation for this feature can be found in the alpha Developer's
> Guide in a section titled "Programming Derby-style table functions":
> http://db.apache.org/derby/docs/dev/devguide/
>
> This only covers SELECT functionality, however. This will not handle
> INSERT, UPDATE, or DELETE on your external data. I think you are asking
> whether Derby provides a plugin facility so that you can use Derby to
> perform all of these operations against your external data. If your
> INSERT/UPDATE/DELETE needs are simple, then you could write database
> procedures to handle these operations against your external data.
>
> Hope this helps,
> -Rick
>
> Chris Collins wrote:
> > Sorry if people ask this frequently, didnt find a reference to
> > anything like this.
> >
> > Within some other database platforms one is capable of adding virtual
> > tables that could be backed by ones own non persisted data.  An
> > example usage can be reviewed in the following book:
> >
> > http://nostarch.com/frameset.php?startat=appliance
> >
> > Here the postgres engine is used as the central place for controlling
> > an appliance.  Using this as a communication conduit to other
> > appliance services.
> >
> > Anyway, is there a way to add ones own table that ultimately provides
> > the appropriate callbacks to ones own code?
> > This would be similar to the SYS* tables.
> >
> > Thanks in advance
> >
> > Chris
>
>

Re: Newbie question

Posted by Rick Hillegas <Ri...@Sun.COM>.
Hi Chris,

I may be misunderstanding your question so please bear with me. The 
upcoming 10.4 release of Derby will provide a feature called Table 
Functions. This will let you make your external data look like a table 
to Derby so that you can issue SELECTs against it. The feature is 
described by the functional spec attached to this JIRA: DERBY-716. User 
documentation for this feature can be found in the alpha Developer's 
Guide in a section titled "Programming Derby-style table functions": 
http://db.apache.org/derby/docs/dev/devguide/

This only covers SELECT functionality, however. This will not handle 
INSERT, UPDATE, or DELETE on your external data. I think you are asking 
whether Derby provides a plugin facility so that you can use Derby to 
perform all of these operations against your external data. If your 
INSERT/UPDATE/DELETE needs are simple, then you could write database 
procedures to handle these operations against your external data.

Hope this helps,
-Rick

Chris Collins wrote:
> Sorry if people ask this frequently, didnt find a reference to 
> anything like this.
>
> Within some other database platforms one is capable of adding virtual 
> tables that could be backed by ones own non persisted data.  An 
> example usage can be reviewed in the following book:
>
> http://nostarch.com/frameset.php?startat=appliance
>
> Here the postgres engine is used as the central place for controlling 
> an appliance.  Using this as a communication conduit to other 
> appliance services.
>
> Anyway, is there a way to add ones own table that ultimately provides 
> the appropriate callbacks to ones own code? 
> This would be similar to the SYS* tables.
>
> Thanks in advance
>
> Chris


Re: Newbie question

Posted by Chris Collins <ch...@gmail.com>.
Bryan this sounds EXACTLY like what I was looking for.  Thanks, I will
checkout 10.4.

Chris

On Thu, Mar 27, 2008 at 9:36 AM, Bryan Pendleton <bp...@amberpoint.com>
wrote:

> > Anyway, is there a way to add ones own table that ultimately provides
> > the appropriate callbacks to ones own code?
>
> If I understand your question correctly, in Derby we call these
> "Table Functions", and they have been added to Derby recently:
> https://issues.apache.org/jira/browse/DERBY-716
>
> This feature will be part of Derby 10.4, which progress you can
> follow here: http://wiki.apache.org/db-derby/DerbyTenFourRelease
>
> We'd love to have some feedback about how well this feature works
> for you, so please give it a try and let us know!
>
> thanks,
>
> bryan
>
>

Re: Newbie question

Posted by Bryan Pendleton <bp...@amberpoint.com>.
> Anyway, is there a way to add ones own table that ultimately provides 
> the appropriate callbacks to ones own code? 

If I understand your question correctly, in Derby we call these
"Table Functions", and they have been added to Derby recently:
https://issues.apache.org/jira/browse/DERBY-716

This feature will be part of Derby 10.4, which progress you can
follow here: http://wiki.apache.org/db-derby/DerbyTenFourRelease

We'd love to have some feedback about how well this feature works
for you, so please give it a try and let us know!

thanks,

bryan