| From: | Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr> |
|---|---|
| To: | pgadmin-hackers(at)postgresql(dot)org |
| Subject: | Transform pgSchema into a Multi-database wrapper |
| Date: | 2001-09-23 09:28:13 |
| Message-ID: | 4.2.0.58.20010923110621.00a68f00@pop.freesurf.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
Hello all,
Is it technically possible to transform pgSchema into a multi-database wrapper?
1) Usually database wrappers are built using inheritance.
2) As inheritance does not exist in VB, we need to use other solutions
which are :
- i) duplicate pgSchema, i.e. create a mysqlSchema object,
- ii) add an XML/XSLT description layer to pgSchema.
XML layer + XSLT should help use describe:
- Abstract Schema and Datatype mappings.
- Available objects (i.e MySQL does not have functions, triggers and views),
- SQL queries used to retrieve information.
This would not change the calling API of pgSchema but the internal structure.
Is this a dream (unfortunately, I guess yes)? Any suggestions welcome.
Cheers, Jean-Michel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2001-09-23 14:53:58 | Re: Transform pgSchema into a Multi-database wr |
| Previous Message | Jean-Michel POURE | 2001-09-23 08:45:33 | Encoding holes |