Michael Van Canneyt wrote:
>
> On Sat, 27 Aug 2005, Alexander Todorov wrote:
>
>
>>Hi all,
>>I have to build a database application which connects to a database hosted on
>>web server. The hosting company doesn't allow remote access so I
>>decided to do something like this :
>>- write a perl / php script that runs on the web server and executes
>>sql states. For
>> SELECT states it returns all data as a XML document.
>>- find/write/hack some TDataSet, TQuery compatible component which
>>will communicate with the server script and data aware controls on the
>>user side.
>>- the connection between these two has to work over http/https and proxy.
>>
>>Is there something that might be helpful, or can be hacked around ?
>>If I have to write my own component where do I start ?
>>What is the lowest level for base class ? TDataSet ??
>
>
> TDataset is the base class.
> However, I think it is best you take one of the existing TDataset classes,
> and write/use a TXMLExport class which simply converts any TDataset to XML.
> There are plenty such components on Torry, they should compile easily with
> FPC.
>
> As for the communication, the ICS or Indy components can be compiled with
> FPC,
> that should give you your communication layer.
>
> Michael.
I will have very similiar problem in near future.Solution I expect to
be good is to use CGI on https server and Synapse library on the client
side.For database on client side I'd like to use sqlite and create
classes to import/export from XML to database and back directly.tDataset
would be used to browse already imported data and maybe to create simple
reports.On the server side I will probably use CGI with TinyWeb SSL
server (sources in Delphi but only for HTTP not HTTPS) because data will
pass not directly to database but to ERP application working under
Windows server.
I considered PHP,but due to fact that this ERP works under Windows I
don't like to run such complicated server as Apache on the same computer
(and preparing a new host for only https server is currently not an option)
CGI will be created with FPC or Delphi. (I want FPC due to integrated
heap and stack tracer)
TinyWeb is very small and easy Web server. so it would be a great idea
for PSP team to prepare TinyWeb+PSP integrated (into sources or as CGI
module) for learning purposes. Is this possible ?
Best Regards
Boguslaw Brandys
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
