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