From: Priewasser, F. <Fri...@fa...> - 2004-12-22 12:51:18
|
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?=20 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=20 --=20 Friedrich Priewasser Software Engineer Fabalabs Software GmbH Honauerstra=DFe 4 A-4020 Linz Telefon: +43 732 2468 5091 e-mail: mailto:fri...@fa... http://www.fabalabs.org |
From: Ben C. <bcl...@pe...> - 2004-12-22 13:34:54
|
Priewasser, There has been a lot of discussion about other DBMS's. Oracle, PostgreSQL and others. For what ever reason this seemed to come to nothing. I can speak for all developers when I say we would be extremely excited and interested in a PostgreSQL port. Please take a look and expect as much support as possible from my self, Yves, Flo and other interested parties. At the moment our ideas are very simple: #ifdef MYSQL #elseif POSTGRESQL #endif (Or similar variable supplied by a configuration option programmed by Yves.) I see the work in a few short parts: (Yves will probably clarify a few points.) - Create new create/delete scripts in 'contrib'. - Create a new lib libpp_psql as a copy of libpp_mysql. - Edit dbms.c as above. Try to leave dbms.h as is. Edit other code in lib to adjust where needed. - Examine the code for all SQL queries, and adjust where needed for PostgreSQL, again as above. This is actually less than it seems. If you want to have a look at that, please do. Let us know how you get on, and please let us know if you need more _or_ less support! You may also use our mailing list perfparse-devel-int for a more free-flowing relaxed discussion, if you want to involve developers in a public conversation. Kind regards, Ben Clewett. 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 |
From: Yves <yme...@pe...> - 2004-12-22 13:38:17
|
> Hello, > > We aim to use PostgreeSQL for some database purposes. We are using perf= parse 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? Today, there has only been mails of people asking if it is is out plans t= o do it or not. So if you can do it, it would be wonderful for the project, for all who w= ould like postgresql instead of mysql like you :) Some tips ? Well, for the parser, this should be easy : - have a look on modules/storage_print.h (useless in production, but a go= od example), on modules/storage_mysql.h, and in fact, on all the files in the directory m= odules/ - Take one of those files, hack it, and make your own storage module for = postgresql. For the db tools, no work has be done, and neither Ben or me will do it i= n the short future, just because we have other projects on perfparse before this :) For the CGIs, may I ask you to wait a little ? My next project is to work= on perfchart in order to put a modular system to load plugins to read from mysql and d= irectly from perfparsed. When this system is ready, you will be able to hack one of th= e 2 plugins and make yours for postgresql. Then, the missing CGIs are perfparse.cgi and perfgant.cgi. I hope it will= not be too hard to let them use the plugins of perfchart. So if you finised the postgresql storage module for perfparsed and are st= ill waiting for me for perfchart, you will be able to do something on the db tools (insta= ll, upgrade and clean the database). Merry Christmas :) Yves --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://perfparse.sf.net/ - |
From: Ben C. <bcl...@pe...> - 2004-12-22 14:56:40
|
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 |