[books] Pre-release of Chapter 5 of Rebol - A programmer's guide

The pre-release of Rebol for pros, Chapter 5 of Rebol - A programmer's guide is now available at http://www.lulu.com/content/2845102 It covers calling other programs and shared libraries, using MySQL from Rebol CGI scripts and how to manage source code with the free version of the Rebol pre-processor. All of these can be used from the latest free versions of Rebol. The chapter also includes a really enthusiastic introduction to IOS and details of the data encryption features in Rebol/Command. Regards Peter Wood

On Tuesday 01 July 2008, Peter W A Wood wrote:

> The pre-release of Rebol for pros, Chapter 5 of Rebol - A programmer's > guide is now available at http://www.lulu.com/content/2845102 > Regards > Peter Wood

Tim I'd say about 30% of the chapter relates to /Command, another 40% to IOS and the remainder to /Core and /View. The main topics relevant to the free versions are using MySQL from CGi with Doc Kimbel's excellent MySQL scheme and using Prebol Version 1.0 (the free version). The introductions to 'call and 'load/library are very brief. Regards Peter On 2 Jul 2008, at 01:46, Tim Johnson wrote:

On Tuesday 01 July 2008, Peter W A Wood wrote:

> Tim

> I'd say about 30% of the chapter relates to /Command, another 40% to > IOS and the remainder to /Core and /View.

> The main topics relevant to the free versions are using MySQL from CGi > with Doc Kimbel's excellent MySQL scheme and

Tim

> I've been using mysql-protocol (Mysql Scheme) and cgi for many years > now. I > mysql scheme > protocol.

Tim Immediately after sending this note, I saw a relevant comment from Gabriele on the AltME Rebol 3. I'm including his comment here as it has already been published on the web: about escaping, Nenad's driver has such functions already, so i don't see that as an advantage for the native driver. Qtask has a native driver too (for speed reason with large record sets), but remember that when you use the mysql c library either your app has to be GPL or you need a license from MySQL (Qtask has a license). I think the functions referred to by Gabriele are those mentioned in 13.2 of the Doc's mysql driver docs. Regards Peter On 3 Jul 2008, at 18:11, Peter W A Wood wrote:

Tim Johnson napsal(a):

> On Tuesday 01 July 2008, Peter W A Wood wrote: >> Tim > function handles the escaping _appropriate_ to the version, and > queries are similarly unescaped.

On Wednesday 02 July 2008, Petr Krenzelok wrote: pekr:

> I doubt that you would gain any speed linking to C. C is a trade-off. > Doc's scheme was proven to be even faster, than native one of Command.

> /library component is now being free.

> However - sending the query to DB > is hardly the main botleneck, isn't it?

Tim:

> Could you explain further. Do I take this to mean that /core > has access to shared libraries? Or are you referring to rebol3?

> Release /library Component for Free > The /library component is now included > in the free distribution of REBOL.

Tim Johnson napsal(a):

> On Wednesday 02 July 2008, Petr Krenzelok wrote: > pekr: > >> /library component is now being free. >> > Could you explain further. Do I take this to mean that /core > has access to shared libraries? Or are you referring to rebol3? >

On Thursday 03 July 2008, Petr Krenzelok wrote:

> Tim Johnson napsal(a): > > On Wednesday 02 July 2008, Petr Krenzelok wrote: > library component for free, and he agreed. So - just download latest > REBOL and you've got /library wrapper available! Good news, isn't it? :-)

On Thursday 03 July 2008, Sunanda wrote:

> Tim: > > Could you explain further. Do I take this to mean that /core > > has access to shared libraries? Or are you referring to rebol3? > > I think he;s referring to Core 2.7.6, released in March: > <http://www.rebol.net/upnews/0026.html>

>> res: load/library %/usr/lib/libmysqlclient.so.15

>> probe res

>>

The main docs: http://rebol.com/docs/library.html And probably too simple for your needs Tim, but for others looking for a very basic introduction to using shared libraries (intended for Windows users): http://musiclessonz.com/rebol_tutorial.html#section-25 Quoting Tim Johnson <tim-johnsons-web.com>:

Tim Johnson napsal(a):

> On Thursday 03 July 2008, Sunanda wrote: >> Tim: > ELF > == ELF

On Thursday 03 July 2008, Petr Krenzelok wrote:

> You have to look at docs, find your C API for your particular library > and create routine wrappers ....

Tim Johnson napsal(a):

> On Thursday 03 July 2008, Petr Krenzelok wrote: >> You have to look at docs, find your C API for your particular library > thanks > tim

On Friday 04 July 2008, Petr Krenzelok wrote:

> Tim Johnson napsal(a): > > On Thursday 03 July 2008, Petr Krenzelok wrote: > > tim > huh? http://www.rebol.com/docs/library.html

Hmmm, I thought I posted that link several messages back... Anyway, here's how to wrap functions from a library (from the other link in that earlier message): ; to open the library: lib: load/library %TheNameOfYour.library ; to wrap a function in the library: your-rebol-function-name: make routine! [ return-value: [data-type!] first-parameter [data-type!] another-parameter [data-type!] more-parameters [and-their-data-types!] ... ] lib "TheFunctionNameInsideThelibrary" ; to run the wrapped function in Rebol with your parameters: your-rebol-function-name parameter1 parameter2 ... ; to free the library when done: free lib I'm not at all familiar with the MySQL api, but here's a quick example of the mysql_real_connect function wrapped for Rebol. You'll need to fix the datatypes (for example, I'm not sure what type mysql_init returns for use as the first parameter "conn"), but this outline should give you an idea of how to get started: lib: load/library %/usr/lib/libmysqlclient.so.15 mysql-connect: make routine! [ return: [integer!] parameter1 [int!] ; not sure of this type parameter2 [string!] parameter2 [string!] parameter2 [string!] parameter2 [string!] parameter2 [int!] parameter2 [string!] parameter2 [int!] ; not sure of this type ] lib "mysql_real_connect" ; the "conn" variable below is gotten by running mysql_init mysql-connect conn, "localhost" "root" "PASSWORD" "mysql" 0, "", 0 Quoting Tim Johnson <tim-johnsons-web.com>:

Oops, in copying and pasting from the C example, I included a bunch of typos in that last post. Forgot to take out the commas here: mysql-connect conn, "localhost" "root" "PASSWORD" "mysql" 0, "", 0 Should be more like: mysql-connect conn "localhost" "root" "PASSWORD" "mysql" 0 "" 0 Also, the parameter names in the routine definition should be different, and it should be integer! instead of int!: mysql-connect: make routine! [ return: [integer!] parameter1 [integer!] ; not sure of this type parameter2 [string!] parameter3 [string!] parameter4 [string!] parameter5 [string!] parameter6 [integer!] parameter7 [string!] parameter8 [integer!] ] lib "mysql_real_connect" Hehe, probably obvious typos, but just in case ... :) Quoting Nick Antonaccio <nick-guitarz.org>:

On Friday 04 July 2008, Nick Antonaccio wrote:

> Hmmm, I thought I posted that link several messages back... Anyway, > here's how to wrap functions from a library (from the other link in > ; the "conn" variable below is gotten by running mysql_init > mysql-connect conn, "localhost" "root" "PASSWORD" "mysql" 0, "", 0

Hi Tim, My driver escapes special characters when using prepared statements (as described here : http://softinnov.org/rebol/mysql-usage.html#sect6.2.). This is the recommended way to create queries. But if you're forming the sql queries by appending data to SQL strings, it's up to you to correctly encode/escape data. I should maybe expose the internal SQL encoding function, so it would be available in global context for such use cases. I'll consider that for the next version of the driver. -- DocKimbel Tim Johnson wrote : [...]

On Monday 07 July 2008, DocKimbel wrote:

> Hi Tim,

> But if you're forming the sql queries by appending data to SQL strings, > it's up to you to correctly encode/escape data.