Design question: How to convert a given data structure to sql and the opposite.

From: "Hanan Hotmail" <h_harush(at)hotmail(dot)com>
To: "pgsql" <pgsql-sql(at)postgresql(dot)org>
Subject: Design question: How to convert a given data structure to sql and the opposite.
Date: 2003-02-08 16:23:57
Message-ID: DAV49XuGPETXd4Fm5Oe00001ab5@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Configuration:
I'm using postgresql 7.3 on Linux box ( RH 7.3) from Perl DBI module.

The problem:
I'm implementing a very interesting system where i need to enable via user
interface (WEB GUI ) to build/update and execute SQL queries on my DB
scheme.

1. I need to translate a given data structure to SQL query .
2. I need to load SQL query to memory.

Generaly i need to convert from a given data structure to sql and the
opposite which means i want to represent a generic SQL in terms and i want
to be able to
load saved query and execute it.

Just to make things clear i will detail to scenarios:

1 . A User => Creates a query using GUI => he/she can execute the query
2. A query is stored somehow => The user update the query according to his
needs => the user save the query and then execute it.

Any idea/direction will be welcome ?

Hanan

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2003-02-08 16:38:55 Re: query help/sugestions
Previous Message John Cavacas 2003-02-08 07:33:58 Re: query help/sugestions