Other integrations possible?

[nick.ge...@c4i.com]

Hello,

My name is Nick Georghiou. I am a software engineering contractor currently working at C4i tasked with reviewing and possibly re-engineering the C4i product database backend.

I have been playing with a few different tools that will allow management and easier maintenance of the schema, as well as to be able to generate source code. However please note that the C4i product is not a web product. Although your product seems geared to web development domain it is exactly the concept I am looking for - except there is one small problem; the development language is C++ (unmanaged), and the database is PostgreSQL. The best I have found for C++ is a product called Objectivity, but I still prefer your product.

I expect that C++ and PostgreSQL are not very high on your priorities as integrations? If you don't think you want to go down this path do you instead support the possibility of providing an API or interfaces (even .NET is ok) for us to develop the integrations ourselves to generate the code? I would be interested to do this integration either in my capacity as an employee for C4i, or otherwise as a private development which you could then have to expand your product.

Please let me know what you think?

Kind regards,
Nick Georghiou

C4i: nick.ge...@c4i.com
Private: ni...@georghiou.com.au

[Joar]

Hello Nick,
Thank you very much for showing interest in our products and for the
compliments on RISE.

Of course, your questions are highly relevant and concerns highly
prioritized aspects. However; since your questions are to a high
degree business oriented rather than just technically product oriented
I will reply to most by e-mail to you directly.

Just a short note on your comment on web products and web development
domain:
I assume the generation of web services is what gives the impression.

Actually, they are SOAP components for communicating between different
parts of a solution. A communication that can be but by no means has
to be over the Internet. E.g. in most of our own implementations they
are used between Windows clients and their back ends.

Best regards,
Joar

[nick_georghiou]

Hi Joar,

Thanks for your support thus far. Just wanted to make people aware
that it is possible to generate postgreSQL from mysql using a very
handy perl script I found on the pgfoundry.org website:

http://pgfoundry.org/frs/?group_id=1000198

Note: This does not work with the script created by Rise when you
perform "Tools->Generate Code to File" since Rise simply creates an
sql procedure. Instead, you must have mysql installed, generate
directly to a database, dump the schema and then use the conversion
script. Here is the procedure I followed to make this work:

1. Installed latest version of mysql and then created an empty mysql
database called "mysqltestdb".

2. Used the Rise "Tools->Generate Code to Database" menu and connect
to the empty mysql database. Generated and updated the database.

3. Used mysqldump to generate an sql script of the mysql database
i.e.
$ mysqldump -d -uroot -ppwd mysqltestdb > mysql_schema.sql

4. Used pgfoundry script to generate postgreSQL version of the sql
script i.e.
$ perl mysql2pgsql.perl mysql_schema.sql postgres_schema.sql

5. Executed the postgres schema script on an empty postgreSQL database
e.g.
$ psql -d myPostgresDb -U postgres -f postgres_schema.sql

Although this might seem like a lot of work this is a viable
workaround for the time being for people that use postgreSQL to also
enjoy the benefits of modeling using Rise.

Hope this is useful for the Rise community.
Regards,
Nick