raumi75 wrote:Hello Roberto,
Great to hear from you on this topic. I will try HMGScript real soon.
I am very excited what your solution will look like!
At this moment I already have a very basic working model, but I've not finished the xBase layer yet.
In this first, experimental version, dbUseArea will need a unique parameter: A SQL query.
This query is sent via xmlhttprequest to a php script in the server, that returns the resulting recordset as delimited text.
The text is parsed via the 'split' method and converted in a two dimensional array.
I've already completed a very basic versions of these functions:
I've already created a non-xBase function:
To set connection parameters.
Prior to release the code I must complete the following functions:
When ready, I'll publish it.
Until now, the results are very promising. It performs very fast.
About paradigms, you are right. Basically, the true problem is the recordset size.
This is the reason I've decided to use a query as parameter to dbusearea(). This way the programmer will be responsible for the size of the data transferred from the server to the client.
I'll take a look at 'pear-database' ASAP.