TbsSQL 3.0-beta-2010-07-08

[Skrol29]

Hello,

A new beta version of TbsSQL is available here:
https://sourceforge.net/projects/tinybutstrong/files/

What's new since the last beta version ?
- property CacheSpecialTimout is renamed in TempCacheTimeout
- property Version returns something more detailed
- the trace mode can also support a console option (add
TBSSQL_CONSOLE)
- the trace mode can also support a data grid option (add TBSSQL_GRID)
example: $Db->Mode = TBSSQL_TRACE + TBSSQL_CONSOLE + TBSSQL_GRID;
- you can now choose to retrieve rows as array or as object
examples:
$Db->DefaultRowType = TBSSQL_ARRAY; // rows are associative PHP
arrays
$Db->DefaultRowType = TBSSQL_OBJECT; // rows are new instances of the
stdClass
$Db->DefaultRowType = 'myCustomClass'; // rows are new instances of
this class
$Db->DefaultRowType =$myObject; // rows are customized clones of this
object
but also:
$x = $Db->GetRow($rowtype, $sql); // see property DefaultRowType for
available values of argument $rowtype
$x= $Db->GetRows($rowtype, $sql);

Thank you very much to TomH for its help about many of those changes.
Do not hesitate to send comments, critics and questions.

Have nice day,
Skrol29

[TomH]

Hello Skrol29,

A very nice surprise to receive this latest TbsSQL beta release this morning,
thank you!

Your technique of 'stacking' the new Mode options is nice.

The simplicity of displaying the console is v.v.good -- with nothing at all
required in the template code -- I love it!

The pop-up window and the table are very nicely proportioned and display nicely.

Also, the way you have it working, by appending new results to the current
'TbsSqlConsole' window is best in my way of thinking, as I like to be able to
see prior results as new queries progress.

((In my hack I did find a way to make the console window scroll to the bottom
(newest) of the results - but it did not work quite the same way with your
console when I tested it. Hmmm??? But my JS is so very bad. ))

Just a note... $Db->TempCacheTimeout is displaying a null/empty value when I do
"get_object_vars($Db)" -- seemed odd, so I felt I would mention it.

Sorry, I have not yet done any work with using the results as object feature in
my applications but will try to get to that soon.

Thanks a lot for the great improvements to TbsSQL - first, the caching and now
the trace/console have made a huge addition. It is true I like to try to make
improvements to everything, as that is the best way I learn. But, I will not use
any of my hacks in any customer/production work that I do, customers deserve to
be able the rely upon production released software by the original authors - so
I am very grateful that the console is now a part of TbsSQL.

I must once again say, thanks for TBS every day,

TomH

[Skrol29]

Hi,

I'm back from holidays,

Thanks for your comments. Most of the things are inspired from the
solution that you've worked on.

They are other features that are interesting in your solution, like
recalling the current options in the console, we could also give the
number of lines, and the sql execution time. But that can be done a
further version.

I'll wait a bit for more feed backs, and then I could release the new
version.

Have a nice day,

---------------------
Skrol29
---------------------

Le 08/07/2010 15:34, TomH a �crit :

[TomH]

Hello Skrol29,

Now that I have been using TbsSQL CONSOLE heavily while debugging some
new applications, I find that the page rendering becomes very, very
slow (after a lot of page reloads) as the page waits for the js
console popup to be rendered before the main page displays.

This may not have a simple solution, but a possible workaround might
be to add a switch to the CONSOLE output so that it can be set to show
ONLY the most recent page run - not the cumulative page runs as it is
now configured - as an alternative.

I hope that's clear?

Honestly I looked at the class trying to do this myself so I wouldn't
have to bother you, but I got completely lost.

Sincerely, thanks for TBS and now for TbsSQL every day,
TomH

[Skrol29]

Hi TomH,

If you want the console to display only one result, why do not simply change
the Mode before and after the query?

By the way, I take the opportunity to point out that I've not forgotten your
$Db->TempCacheTimeout = 0 problem.

Regards,
Skrol29

-----Message d'origine-----
De : tbs-...@googlegroups.com [mailto:tbs-...@googlegroups.com] De la part
de TomH
Envoyé : mardi 14 septembre 2010 00:27
À : TinyButStrong Next Version
Objet : [tbs-next] Re: TbsSQL 3.0-beta-2010-07-08

Hello Skrol29,

--
You received this message because you are subscribed to "TinyButStrong next
version".
Post to this group: send email to tbs-...@googlegroups.com
Subscribe: send email to tbs-next+...@googlegroups.com
Unsubscribe: send email to tbs-next+u...@googlegroups.com
More options: http://groups.google.com/group/tbs-next

[TomH]

It seems I was totally unclear in my description, let me try a different way...

The issue is not to "clear the console window" of "one query among many" the
issue to "clear the CONSOLE" after "each page load (of multiple queries) for
many successive page loads".

If that's not clear, try this...set the Mode property on a TBS page that has
multiple queries (or repeat/copy a multi-row query 6 times for testing this)
$Db->Mode = TBSSQL_TRACE + TBSSQL_GRID + TBSSQL_CONSOLE;

Then, reload the page 10 or more times (or resubmit the form to get a reload).
Notice that in the js CONSOLE window, the trace & grid results are continuously
concatenated (for each page load) in the console window.

As the length of the window page gets longer the time to load the original page
increases as the page display must wait for the js console window to render
first -- at least that's what happens on my local windows box and my unix server
boxes.

I hope that's clearer description.

TomH

Skrol29 wrote:
> Hi TomH,
>
> If you want the console to display only one result, why do not simply change
> the Mode before and after the query?
>
> By the way, I take the opportunity to point out that I've not forgotten your
> $Db->TempCacheTimeout = 0 problem.
>
> Regards,
> Skrol29
>
> -----Message d'origine-----
> De : tbs-...@googlegroups.com [mailto:tbs-...@googlegroups.com] De la part
> de TomH

> Envoy� : mardi 14 septembre 2010 00:27
> � : TinyButStrong Next Version

[Skrol29]

Ok, I'll fix that

Thank you very much TomH !

Regards,
Skrol29

-----Message d'origine-----
De : tbs-...@googlegroups.com [mailto:tbs-...@googlegroups.com] De la part
de TomH

Envoyé : mardi 14 septembre 2010 13:21
À : tbs-...@googlegroups.com
Objet : Re: [tbs-next] Re: TbsSQL 3.0-beta-2010-07-08

TomH

> la part de TomH Envoyé : mardi 14 septembre 2010 00:27 À :