[SqueakDBX] Problems at first go on SqueakDBX

[Mariano Martinez Peck]

>
> BTW in
> http://www.linuxnetworks.de/doc/index.php/OpenDBX/Comparison
> under Environment we see OpenDBX also used this configuration.
>
>
You are right. I have just see it.  MMP> is that possible ? or you also
migrate your database to a 5.0 ?


> MMP> which DNU here ? the one of the sql_mode ?
> no. In my case result is a DBXResultSet (because I sent select from)
> and rowsAffected is implemented in DBXResult. In the wiki result is
> returned by a delete sql statement which maybe returns a DBXResult.
>
>
If it is a select, it would return a DBXResultSet, other cases like updates,
deletes, inserts, create, drop, etc, will return DBXResult



> All is stated correctly on the wiki but I just skimmed the text and
> only read the example. My bad.
>
>
perhaps you can do:   aResultSet rows size

However, be aware that you are retrieving all the rows in that way. So, you
should do something like this:

| rows size |
rows := aResultSet rows.
size: rows size.

because if not, you loose the rows and you will then have to query again :)

do you understand ?


> It just felt naturally to ask how big my result set would be before
> loading it into Squeak with rows. But it is explained nicely in
> DBXResultSet>>nextRow.
>
> BTW after I first noticed few class comments I am now very pleased by
> the many detailed method comments! They will help a lot.
>
>
Yes. We have all of the important methods very well explained. Not only for
the final user like you, but for us :)

However, we don't have a single class comment :(    Of course, if once you
get a idea of the class you want to commit comments or whatever, just do it
and we will be glad :)
But, this is in our too-long to do list ;)



> MMP> result columnDescriptions explore gives DBXTypeNotSupported (see png)
> MMP> for timestamp and text  (see mysqlcc.png).
>
> MMP> No, sorry :(   You cannot use timestamp. You have to use DATETIME :(
> MMP> I am sorry but that's OpenDBX. Read:
> MMP>
> http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes#Temporal_types
> MMP> I hope this not to be a big problem for you.
> I think it's not a problem because the returned values are correct.
> SqueakDBX lives happily in the same image as the native driver so I
> can compare results from both drivers. Maybe I get problems when I
> change records but as you have noticed by now the databases are kind
> of holy cows and I will not touch them.
>
> MMP>
> MMP> BTW there was a typo on the Wiki the last "s" in columnDescriptions
> MMP> was missing.
>
> MMP> Sorry. I couldn't find it. Where is it ?
> I had already corrected it.
>
>
Thanks!!! But there is something I didn't tell you hahaha.
We don't like swiki. It is nice for the 80s but we wanted a new website. So,
we did our own website with Seaside and Pier. We didn't the official ANN
because we were waiting for the squeakdbx.org domain. The link right now is:
http://squeakdbx.smallworks.com.ar/
The swiki will be deprectaded. So, I would really love if you can fix that
again but now in that website. And from now to the future, any correction,
change or whatever you do, please do it in that website.
I will send you in private the user and password.



>
> MMP> I will investigate the "unknown system variable".
> Thanks.
>
>
This seems to be related to the MySQL version and the client library we are
using to connect.
I will also ask Norbert as he used MySQL 4 (as you saw in the benchmarks).

What happens if you execute this with a mysql client (not squeakdbx):

SHOW VARIABLES LIKE 'sql_mode'

?


> MMP> Are you referring to " In both cases, you must have
> MMP> installed your database client library first. " ??
> MMP>
> Yes
>
>
Done: http://squeakdbx.smallworks.com.ar/Compiling and installing OpenDBX
Feel free to change it if you want.


> MMP> Ok. However I already edited the wiki with your comments:
>
> MMP>
> http://squeakdbx.smallworks.com.ar/Compiling%20and%20installing%20OpenDBX
> Hey, somehow I completely missed this because you put so much on the
> Squeak swiki. I always referred to the swiki when I wrote wiki.
>

Yep. Sorry. Forget about http://wiki.squeak.org/squeak/6052. This is
deprecated. Now see http://squeakdbx.smallworks.com.ar/

See you.

Mariano


>
> Ok now bedtime, 1 hour past midnight here.
>
> Cheers,
>
> Herbert                            mailto:herbertkoenig at gmx.net
>
> _______________________________________________
> SqueakDBX mailing list
> SqueakDBX at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20090926/99cf85e5/attachment.htm