[Perfparse-devel-int] Re: Implementation a support for Oracle storage

[Ben C. <bcl...@pe...>]

Massimiliano,

Sorry for late reply.

We would all be very interested in looking into a working Oracle storage.

You might look into to the job of conversion of the tables in 'scripts' 
in latest version.  This will give you some idea of the job.  I'll look 
into getting some documentation.

We also have Friedrich Priewasser, (cc on this email), who is working on 
PostgeSQL conversion.  I think you two may keep in touch on this mailing 
group 'perfparse-devel-int' :)

I passed Friedrick the following information as a starting point. 
Please enjoy, and tell us how you get along.  Remember, there are lots 
of us who can give you advise :)

Sorry I cannot give more time now.  If there is anything I can think of, 
I will email in future.

Regards, Ben. :)

--------------------------------------

Email I sent to Friedrich, edit for latest changes:



Priewasser,

I have been talking to my partner Yves and we believe the best way to 
convert the product is as follows:


1.  Convert the database schema:

     scripts/postgresql_create.sql
     scripts/postgresql_delete.sql

Try to keep to ANSI-SQL.  Eg, use BOOL, TRUE and FALSE which MySQL does 
not support.  Rather than copying MySQL including it's short fallings :)

This stage will give you a good idea of the challange to complete the work.


2.  Two bits of work here, storage module and DBMS library.

(i) Copy scripts/storage_mysql.* to scripts/storage_postgresql.*

Edit where required.  Keep the .h the same in all cases.

(ii) Copy directory libpp_mysql to libpp_postgresql.

Edit all parts, starting with dbms.c.  Please keep .h files the same.


3. The non-graph CGI code.

In the CGI code, check the SQL commands and replace where needed using 
syntax similar to:

#ifdef MYSQL
     "SELECT * WHERE boolean_field = 1"
#elseif POSTGRESQL
     "SELECT * WHERE boolean_field = TRUE"
#endif

These definitions do not work yet.  If you continue this work, these 
will be added.


4.  The graph module.

Yves is re-writing this to access many data sources.  At this stage 
probably best to wait until this work is a little more mature.  I will 
be writing a MYSQL module at this point, so we can do this together.



A lot has been said in response to your original email in a short time. 
  I hope we haven't confused you.  We are excited about what your work 
will do for our product!

Please let us know your feelings and what you think of the challange.

Regards,

Ben & Yves.








-- 
Ben Clewett  bcl...@pe...
PerfParse    http://www.perfparse.org
PP FAQ       http://wiki.perfparse.org/tiki-list_faqs.php