Re: [Firebird-devel] Firebird v3.0.x support for External Functions plug-in
> Since nobody really cared to do any help, there is no "Building" readme. > > But it's really no difficult for a people that ever built a C++ and Java > application to figure it out, as code base is small and has intuitively named > scripts. > > Anyway, you should start telling what has been tried and what didn't work, > instead of "tried without success". We managed to get a plugin to compile. We will be creating a series of functions (potentially triggers) which will see high volume usage within our application. So, the new questions are: - Does anyone have plug-in based functions/triggers working in production? - How reliable (well tested) is the Firebird infrastructure around the Plug-ins? - Do we need to create a high-load test app to check the infrastructure? - Did the Selectable SP known issue in v3.0.0 get fixed in later updates? - Are there any "gotchas" that we need to consider? Sean -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5818) Extend INSERT INTO to support csv
Extend INSERT INTO to support csv
-
Key: CORE-5818
URL: http://tracker.firebirdsql.org/browse/CORE-5818
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Affects Versions: 3.0.4
Reporter: Karol Bieniaszewski
I know that someone can think that this is tool feature like isql or something
like this.
But it can not have same performance like engine itself have.
It should be as fast as it is for external tables now - but as we know external
tables can work only with fixed width data.
Extending external tables to csv data i suppose is not simple task at all.
now we can e.g.:
---
INSERT INTO TEST_TABLE(ID, NAME)
SELECT ID, NAME FROM EXT_TABLE
---
please consider extended syntax for INSERT INTO to:
by index:
INSERT INTO TEST_TABLE(ID, NAME) FROM FILE 'XXX.scv' DELIMITED BY '\t'
HEADER=True COLUMNS(1,3);
by header column names:
INSERT INTO TEST_TABLE(ID, NAME) FROM FILE 'XXX.scv' DELIMITED BY '\t'
COLUMNS('SOL_ID', 'CONT_SUFFIX'); <- here header can not be false because we
use names
It will be really usefull for importing data into Firebird database
>From security reason location of csv should be restricted to e.g. external
>table locations specified already in Firebird.conf
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird v3.0.x support for External Functions plug-in
On 07/05/2018 19:18, Leyne, Sean wrote:
>
> The Firebird v3.0.x release notes outlines that plug-ins support has
> been added, and mentions that it will be extended to supporting SP,
> Functions and Triggers.
>
> Was this ever implemented/completed?
First version, since 2009.
>
> {The Prague 2014 Firebird Conference had a "What's new in Firebird 3"
> presentation that listed "External functions, procedures and triggers
> on C\C++\Pascal\Java etc." as a Procedural SQL change}
>
> We have tried to compile the Java Plug-in without success.
>
>
Since nobody really cared to do any help, there is no "Building" readme.
But it's really no difficult for a people that ever built a C++ and Java
application to figure it out, as code base is small and has intuitively
named scripts.
Anyway, you should start telling what has been tried and what didn't
work, instead of "tried without success".
Adriano
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird v3.0.x support for External Functions plug-in
On 05/08/18 01:18, Leyne, Sean wrote:
The Firebird v3.0.x release notes outlines that plug-ins support has
been added, and mentions that it will be extended to supporting SP,
Functions and Triggers.
Was this ever implemented/completed?
Ardiano (specially about Java) will answer better - I just can confirm
that plugin UDR (user defined roiutines) for C++ SP, Functions and
Triggers works.
Moreover - in FB4 UDFs will be deprecated with recommendations to be
replaced with UDR due to security reasons.
{The Prague 2014 Firebird Conference had a "What's new in Firebird 3"
presentation that listed "External functions, procedures and triggers
on C\C++\Pascal\Java etc." as a Procedural SQL change}
We have tried to compile the Java Plug-in without success.
Here you definitely need Adriano...
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
