New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
FreePascal as an embedded language in Firebird [CORE3571] #3925
Comments
Modified by: JimBeam (jimbeam)description: 0. BackgroundFreePascal (FPC) is an object oriented variant of Pascal that looks very 1. FreePascal as an embedded language in FirebirdFor Firebird, FreePascal could be a good embedded language (for writing stored procedures/functions/triggers) next to e.g. Java. 2. End user considerations2.1 A lot of developers that use Firebird program in Delphi. As 2.2 FreePascal may be easier to learn than Java for some people and 2.3 FreePascal might not run/is not supported for some platforms that 3. Development considerationsI only know enough to make wild guesses... that doesn't stop me from 3.1 Obviously, Firebird must allow running compiled code (as opposed to 3.2 Firebird must be modified to include (a stripped down version of?) 3.3 FreePascal will need to have some way to access, manipulate and 3.4 FreePascal will need to use the Firebird memory manager. Using 3.5 Most importantly: it will probably require a lot of work on both Please see further discussion following from my 27 July 2011 post to the => 0. BackgroundFreePascal (FPC) is an object oriented variant of Pascal that looks very 1. FreePascal as an embedded language in FirebirdFor Firebird, FreePascal could be a good embedded language (for writing stored procedures/functions/triggers) next to e.g. Java. 2. End user considerations2.1 A lot of developers that use Firebird program in Delphi. As 2.2 FreePascal may be easier to learn than Java for some people and 2.3 FreePascal might not run/is not supported for some platforms that 3. Development considerationsI only know enough to make wild guesses... that doesn't stop me from 3.1 Obviously, Firebird must allow running compiled code (as opposed to 3.2 Firebird must be modified to include (a stripped down version of?) 3.3 FreePascal will need to have some way to access, manipulate and 3.4 FreePascal will need to use the Firebird memory manager. Using 3.5 Most importantly: it will probably require a lot of work on both 4. More information/collaborationPlease see further discussion following from my 27 July 2011 post to the Firebird issue/feature/request: CORE3571 |
Submitted by: JimBeam (jimbeam)
Votes: 6
0. Background
FreePascal (FPC) is an object oriented variant of Pascal that looks very
much like Delphi (in fact, there's a Delphi compatibility switch so you
can port your existing code).
Firebird is an open source relational database derived from Interbase.
1. FreePascal as an embedded language in Firebird
For Firebird, FreePascal could be a good embedded language (for writing stored procedures/functions/triggers) next to e.g. Java.
2. End user considerations
2.1 A lot of developers that use Firebird program in Delphi. As
FreePascal syntax is (almost) identical, these developers can easily
port their code between the database and the application.
2.2 FreePascal may be easier to learn than Java for some people and
would make a nice alternative as opposed to e.g. including C or C++
2.3 FreePascal might not run/is not supported for some platforms that
Firebird 3 will be released for. Perhaps HP-UX? Firebird 2.5 runs on
Windows (x86/x64), Linux versions (x86/x64), Solaris (Sparc and Intel),
HP-UX (PA-Risc) and Mac OSX.
3. Development considerations
I only know enough to make wild guesses... that doesn't stop me from
making them, though.
3.1 Obviously, Firebird must allow running compiled code (as opposed to
running code in a Java Virtual Machine), presumably in a form of dynamic
library. This will have obvious security implications; on the Firebird dev
mailing list just trusting the code, sandboxes, restriction of used units,
different levels of trust as implemented in PostgreSQL, code signing
was discussed.
3.2 Firebird must be modified to include (a stripped down version of?)
the FPC compiler (or store the location of the compiler) and call it
whenever the FreePascal source code in a procedure is changed.
This might not be necessary for production servers as long as embedded
Pascal code is compiled on developer machines and the resulting object
code is loaded into the production database.
3.3 FreePascal will need to have some way to access, manipulate and
return the data in the database and call other Firebird stored
procedures, functions, etc. FPC already has good database access,
including Interbase/Firebird support, but some kind of interface unit
for direct access will need to be added.
3.4 FreePascal will need to use the Firebird memory manager. Using
various memory managers is fortunately already possible in FPC.
3.5 Most importantly: it will probably require a lot of work on both
ends to get this done. Fortunately, both Firebird and FPC have an active
developer community with good communication and bug tracker systems, so
this helps.
4. More information/collaboration
Please see further discussion following from my 27 July 2011 post to the
fpc mailing list
http://lists.freepascal.org/lists/fpc-pascal/2011-July/029715.html
and Firebird development list:
https://lists.sourceforge.net/lists/listinfo/firebird-devel
(Mostly on the Firebird list).
Firebird issue/feature/request: CORE3571
FreePascal issue/feature request: http://bugs.freepascal.org/view.php?id=19946
The text was updated successfully, but these errors were encountered: