Re: [Perfparse-devel] PostgreSQL Storage

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

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:

	contrib/postgresql_create.sql
	contrib/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 modules/storage_mysql.* to modules/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.








Priewasser, Friedrich wrote:

> Hello,
> 
> We aim to use PostgreeSQL for some database purposes. We are using perfparse and we'd like to use a PostgreSQL storage intead of the MySQL storage for it.
> My question is: Is there any focus on creating a PostgreSQL storage at the moment?
> If yes, how far you got till now? 
> If no, we want to create such a storage. If we do so, should we use the MySQL storage as base for our development and are ther any other tips?
> 
> Regards,
> Friedrich 
> 


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