kapper has asked for the wisdom of the Perl Monks concerning the following question:
Hi there fellow monks... here comes a little bag of questions I have acumulated over the last few weeks. I have been able to find answers for most of the questions, but would like your comments in the context of the system I am about to implement.
I am about to start a larger project in Perl on very unfamiliar grounds. We are about to write a cross platform enterprise component framework. Initially we where going to implement it in PhP with PostgreSQL under GNU/Linux and in vb script with COM objects and MS SQL7 under Windows. However... I'm so fed up with PhP that I no longer wish to undertake any projects much larger than "hello world" in it....
...then it hit me, why not write it in Perl? that should be ok performance wise under both Windows and GNU/Linux? (any comments and that assumption would be greatly valued)
Sooo.. my main question, since I have basicly no experience with database connection handling under Perl, I have no idea about what database to choose under either Windows or GNU/Linux. Since we have chosen to use the same language on both platforms, it would be nice to use a database connection module which would work seamlessly on both platforms, and thereby completely remove the double development. Which DBMS would you recommend for each platform? It should be a full functioning DBMS with subqueries and transaction support (in other words no MySQL). A free DBMS would be preferable for at least one of the platforms.
Ok, next question... in the system, we will need to implement a small OO language. We where going to write the runtime environment as a native C++ library, but since we are now using Perl, it would be so much nicer to implement it directly in Perl. However, this would mean having a vm in a vm.. not exactly a high performance solution. Although performance is not the only factor (our system supports clustering), it is important. Do any of you know of any vm projects in Perl, which have some benchmarks, wich gives an idea about what kind of performance one could expect.
Anyways, thanks for your time, I know these where not excactly Perl programming specific questions, but I really needed some input from experienced Perl programmers on the questions in the context of an enterprise component framework. Any other comments on the subject would also be greatly valued..