Hi Paul,
I created https://github.com/skopaliks/Firebird-SQL-Lib
but I have some stupid questions:
1. What kind of license will be best for this project?
I chose LGPL3, is it ok?
2. What prefix do you prefer for this?
I prefer LIB$, like LIB$CheckTriggerUniquePostion.
Any other idea?
3. The best will be, if each SP (or function or ...) will be in separate
file and there will be one file that will cover (INPUT) all of them.
But isql is not friendly because if you are using relative path, this
path is from current isql directory not to file with INPUT command.
Is there any work around for this?
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-----------------------------------------------------------------
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---------------------------------------------------------------
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz
On 1.8.2017 13:13, Paul Reeves wrote:
On Tue, 1 Aug 2017 11:49:42 +0200 Slavomir Skopalik wrote
Hi,
will be possible to extend firebird installation by SQL stored
procedures that will solve common problems?
It will be like UDF (let say in directory SQL), and every one can
include/use this SQL like fbudf.
It is a great idea. I'm sure I'm not the only one to have developed a
few SPs over the years that might be useful. However, it needs
someone to organise it, curate the contents and create QA tests to
verify that the stored procedures work correctly with each new release.
It is not too much work, but it does require commitment if the
intention is that these procedures should ship with Firebird. Bit rot
can set in very quickly if no-one is around to maintain code.
Perhaps the first step would be to create a github project to allow
people to contribute.
Paul
------------------------------------------------------------------------------
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
