World: r4wp

You're both right here. Usually, I avoid duplicate names on the SQL 
side already, frequently mapping sql result column names with "as 
<columnname>" to the words I want to use in Rebol.


SELECT Customer.ID AS CustomerId, Article.ID AS ArticleId, Order.Copies 
* Article.Price AS TotalPrice ...   --->  [customer-id article-id 
total-price]

Doc, those column names are meant for binding to the result set, 
but it is not necessary to access the result set that way. You usually 
just do the positional access. If you want to use the column names, 
you have to make sure the column names are unique and that all columns 
have names, same as you have to do with all SQL.

Very cool Kaj.

Thanks

Robert, Great. Documentation is really inportant to use your product.

Very nice updates Robert. Thanks for your effort.

Where is published r3-view.exe ?

http://development.saphirion.com/resources/r3-view.exe

Robert, does the android port currently have GUI support?

No, console online at the moment.

Network will be next.

What version of Android is needed for R3droid.apk ?

Cyphre can tell, but IMO it should work on pretty most of them.

Connected with WiFi on Android 4.0 on Motorola Electrify 2, trying 
to run the test script, I get the following:

>> do http://development.saphirion.com/experimental/oneliner-prime-numbers.r

** Access error: cannot open: tcp://development.saphirion.com:80 
reason: -12
** Where: open open unless sync-op either read
** Near: open conn port

But it is super exciting, anyway!

I got a slightly different message when I tried it with 3G instead 
of WiFi, for some reason:


>> do http://development.saphirion.com/experimental/oneliner-prime-numbers.r

** Access error: cannot open: tcp://development.saphirion.com:80 
reason: -12

** Where: open open unless sync-op either read either read-decode 
case load -apply-do
** Near: open conn port

(Just more detail in the "where" field on the second error)

Bo, you have to download the script and than run it. Network support 
is not yet running. That's next.

yes, networking is not done yet.

You just download a *.r script (or copy on your sdcard in the phone). 
Then you can just clik on the script file and file association requester 
should popup so you can run *.r scripts just by clicking on them 
instead of execution from console.

regarding version: this .apk should be compatible and run on Adroid 
v2.2.x (FROYO) and up

(I've tested it on Android 2.3 (GINGERBREAD) phone and it works well.)

BTW It would be interesting to see how R3 performs on multiple devices. 
The easier way is just open the R3 console and execute: SPEED?

(with /NO-IO refinement)

So here is my result:

Samsung Galaxy Mini
CPU: Qualcomm MSM7227 600 MHz ARMv6

>>speed?/no-io
== [302 193 6 0]

galaxy S3: 961 495 20 0

Speed function crashed on my Huawei M865C:

Access error: cannot open %tmp-junk.txt   reason: -3
Where:  write unless do foreach speed? 

Near:  write file: %tmp-junk.txt  "" tmp: make string! 32000 * 5 
ins...

I'm gettting the same reason: -3 error for any simple file write.

Maybe permissions aren't set properly by the apk?

Oops - didn't see that it should be run with /no-io.  My results:

[368 218 5 0]

That device has a slow 600 MHz processor

So, along with files and network support, at least support for 'ask 
for interactive input, would make this fully useful.

[475 177 9 0] [332 182 9 0] [461 187 9 0] diferents runs on Motorola 
Milestone 1 CPU 600Mhz. FROYO 2.2.1

HTC Sensation: [739 475 15 0]

As said, files and GUI will be next.

Motorola Electrify 2 - 1.2GHz dual-core - Android 4.0 Ice Cream Sandwich

[1161 524 16 0] [1160 528 16 0] [1158 525 16 0] (three runs)

cool, the results seems to be consistent

It seems the file write access is not possible at the moment. I need 
to investigate the reason why.

htc desire Z [747 510 16 0]

Nexus 7: [1255 540 26 0]

Poser

Well, it's not a phone :)

Daughter has a HP touchpad running Android.  Should work?

I imagine anything running Android should work.  I don't know if 
the architecture of the processor matters, but I think it must not 
because I don't see different compilations of Angry Birds for different 
Android processor architectures.

Only if it's compiled for the lowest end processor

Robert and Cyphre : As already stated under the Android group I have 
succeessfully tested the new console based R3 for Android under my 
Samsung Galaxy Tab 10.1 tablet - running Android 3.2. works well 
- thanks again a lot for this achievement - I wil shortly follow 
with some donation - simply waiting for my next salary deposit ...

Thx.

Thanks Gerard, glad it works for you!

Graham, it should work on anything that has at least Android 2.2 
and an arm cpu. Moreover the APK contains additional build  of the 
R3 interpreter for arm cpus that have hardware floating point operations. 
I haven't made any benchamrks so I don't know if this is really performance 
advantage (in case of Rebol code) for Devices with such better and 
newer hardware.

I'm proud to say I have the second fastest Android phone tested so 
far. ;-)  I am SO excited for the future, especially for the Android 
network and file access and the graphics port.  Cyphre, how do we 
make donations again?