World: r3wp

Robert - thanks...that's what I eventually did.


Manu - thank you for making clear what the /direct refinement does...I 
had read about that in the SQLite Driver Guide, didn't understand 
it since REBOL is still new to me, and forgot about it.  Works perfectly! 
 So much to learn....

Is there a problem with:

http://www.dobeash.com/

seems like domain is up for sale ??

Probably hasn't paid renewal fees!

It is back online again.

Does REBOL SQLite support SQLLite3 ?

yes, it does ...

Is it possible to use the sqlite driver for a file that resides on 
the internet?

As long as you can access it via a normal file-path, yes. Can be 
slow but should work.

stupid me, I only now realized sqlite driver supports prepared statements 
too and I was concatenating strings all along.

I seem to recall a note about locking issues over a network path, 
so ymmv.

Does following mean, we could have trouble to propelry sort (using 
collations) because of UTF-8?


http://stackoverflow.com/questions/181037/case-insensitive-utf-8-string-collation-for-sqlite-c-c

The sorting problem with collations applies to Unicode, not just 
UTF-whatever, so it is a problem. Mostly a problem of size: The actual 
colation sorting code is small, but the collation data is large. 
Add more than one or two and REBOL gets huge.

A solution would be to move the sorting out into the host code, where 
it can be made to use any system-specific sorting code, which should 
work for platforms with good Unicode support like Windows, OS X and 
some Linux distros. The problem with that is that the data would 
probably need to be migrated to the host format before the host routines 
could be used; string! is not UTF-8 or UTF-16 internally, it is UCS-8 
(in theory), UCS-16 or UCS-32 (in theory), all fixed-length encodings. 
That would add a lot of overhead to sorting.

ICU seems to have such library with nice license... Unfortunately 
the Binary-only package for one platform is like 10Megabytes..
http://icu-project.org/download/4.2.html#ICU4C

This unifoce srting seems to be a mess.. Well, technically they do 
have some standards, but trying to even think any decent size implementation 
of that.. 
http://www.unicode.org/reports/tr10/

Is there a method to "dump" the contents of a sqlite db for back-up 
purposes using the the driver?

why not just copy the file?

Robert, Well, that's what I do do now but I was wondering if there 
was also a command.

James, if you have the sqlite command available, you can do:

sqlite /path/to/file.db .dump >/path/to/dumpfile.sql

Thanks Gabriele. I was looking for a programatic way but I think 
I'll stick to just copying the file.

well, that is programmatic. .dump is a command for the sqlite utility. 
if you want to do it from REBOL, you have to code it yourself, as 
it's not a SQL command.

Is this an accepted method of populating the fields of a view form 
or is there a more precise method?

btn-next: func[][
   if (counter  < (length? db)) [
    counter: counter + 1
    lname/text: db/:counter/2
    fname/text: db/:counter/3
    spouse/text: db/:counter/4
    email/text: db/:counter/5
    hphone/text: db/:counter/6
    cphone/text: db/:counter/7
    addr/text: db/:counter/8
    city/text: db/:counter/9
    state/text: db/:counter/10
    zip/text: db/:counter/11
    
    show window
    ]
]

you can wrap the fields in a panel and use:

set-face my-panel [db/:counter/2 db/:counter/3 ...]

And, I have abstracted this idea in that a function walks over the 
set-words of an object and use these as columnnames.

in the VID extension kit you can say:

set-face my-panel object

object: get-face my-panel

hmm... actually not really. forget that. I'm distracted. :-)

Henrik, What's the latest versionof Ext kit?

003. Unfortunately, it's moving too slow. I won't have any time to 
do updates for a while.

There is no standard I know of for mapping data to faces. A number 
of us have rolled our own systems over time, each with our own critieria 
and design aesthetic.


As a simple starting point, consider setting up declarative mappings 
and driving a data-exchange loop. e.g.

face-field-map: [
    lname 2 fname 3 spouse 4 
    email 5 hphone 6 cphone 7 
    addr 8 city 9 state 10 zip 11
]

foreach [face-name field-index] face-field-map [
    set-face get face-name  pick db/:counter field-index
]

Thanks Gregg, as a newbie I was just trying to get an idea as to 
how others are handling this.  I was thinking that there had to be 
a more concise method than the one I was using.

--

You can use rebsqlite with core on windows (it allows dll inclusion) 
but how can you use it on linux? It seems linux rebol doesn't allow 
.so . I used rebpro which does this but now I also need to send an 
email from it and it gives me some strange message "Set-Net not provided."?


Maybe I am doing something wrong/using the wrong tools... how can 
you use rebol with sqlite on linux??

(I have bought SDK btw .. but I don't know for what reason I bought 
it for windows(?!?!!), where I really don't need it so it doesn't 
help me at all in this situation)

hm.. is license transferable between linux/windows or some discount 
for another if you bought the first one?

I am not sure license is transferrable, but license is just one file 
- try to copy it to linux machine. If it is legally OK, I don't know. 
But - I would probably ask Carl ...

IIRC, the latest SDK purchase gives you a license for every platform. 
 might be worth upgrading (50$ is like not going to restaurant once... 
your wife/girlfriend will get over it  ;-).

I don't see it mentioned anywhere that this license / upgrade is 
multiplatform. The select box is the same as before where you choose 
the platform. I have no problem giving $50, but I am running on fumes 
here and $350 shows on my account, especially if I am don't need 
it really, because rebol core/view on windows work with rebol sqlite 
and I haven't seen anywhere that linux version has different logic.

yeah the website seems to indicate that we still need to buy each 
license separately.

(I will gladly buy all rebol versions in existence when I can afford 
it)

hm .. maybe access to dll/so is available only to view and not core. 
and because I use core (cmdline) on linux server it doesn't work

rebpro is the one with dll.

Yeah, for now /Core doesn't have /Library. /Pro does, and can be 
encapped to resemble /Core with /Library; that is the only difference 
between /Pro and /Base.

/View (free) also supports dll-s for very long time now

I really wish Carl would release the various reb*** builds outside 
of the SDK.

they are very usefull as-is, even when not encapping scripts.

Yes, /View/Pro is now free and called /View.

I actually bought /View/Pro back before it was free.

Maxim, the SDK is useful as-is too. That's why people pay for it. 
Don't knock the business model :)

aha, I tried is. it's not that windows supports dll-s and linux not 
but the view does and core doesn't. I guess I am gonna have to buy 
the linux sdk also.

Brian, do you know what's the trick with "Set-Net not provided." 
in rebpro?

I would guess that you have to include %prot-setnet.r in your script 
to use it.