AltME groups: search

I've questioned this a few times over the years now.. 

If we have a CGI script that uses the mysql protocol, is it necessary 
to load this protocol with every cgi request?  Wouldn't that add 
some burden to the server?

But if you want to access a mysql server, the cgi script loads each 
time, right?

loads the mysql protocol, that is.

Ok, doing some timing tests.. using 10000 loops... 


Firstly, the mysql is choking around the 9800 -9850 mark by denying 
access at that point...

Actually, i was counting down, and mySQL is choking after 150 calls 
or so.

Forced to reduce the number of iterations to 100 for mysql sake.. 
and even then it would choke 50% of the time.. results.. 


Reading the DB used mysql-protocol.r with join mysql://.. localhost 
{select email from table where name='name' }
Reading the file used a: load %file.txt, b: select a 'email
mysql - 1.35 seconds (using time/now/precise

file - 0 seconds (timestart - 18:35:25.531, timefinish - 18:35:25.531)


Conclusion.. no contest.. loading and selecting from file wins hands 
down.

Graham, if i need to wait for a response, then i would need to add 
that time to the total for mysql.

and then later on if you need to copy the 1million files from the 
filing system, or copy the mysql database .. which is faster?

not only that, MySQL via the protocol couldn't handle the 'rapid 
fire' query rate.

well, I use MySQL.. pretty much standard these days

I am just starting to use mysql a little bit and it is a great step 
up from plain old flatfiles it is constantly improving  a cinch to 
administer, but limited for complex relations

many functions are also only available through extensions, such as 
mysql_xyz() functions.

mysql> create table test (dolars float(2));
Query OK, 0 rows affected (0.22 sec)
mysql> insert into test values(777777);
Query OK, 1 row affected (0.03 sec)
mysql> select dolars,(dolars / 9220) as rupias from test;
+--------+-----------------+
| dolars | rupias          |
+--------+-----------------+
| 777777 | 84.357592190889 |
+--------+-----------------+
1 row in set (0.01 sec)

Right now I'm simply using a rebol object database. It would be very 
difficult to change this particular script. But if I ever do something 
like this again I may consider using mysql.

Hi, syntax question: 

i want to insert a row into a mysql db:

string-block: [ "value1" "value2"
insert db [  "insert into table values (?,?)" string-block ]


this fails (string-block is not evaluated i guess), but i dont know 
how to generate the following

insert db [  "insert into table values (?,?)" "value1" "value2" ]

(which works) using rejoin, remold, join, .. whatever.

("hidden feature" of pairs, used by nenad in is mysql protocol handler 
:)

Gregg, well in the back of my mind since I started programming with 
BASIC, C and Assembler (which, without wanting to start an Altme-war, 
I refer to as 'procedural' as opposed to OO), I was just wondering 
if there was another "object-oriented" way. You know, like "find" 
but with special parameters that tell it to do what my "foreach" 
actually does. I don't know, it just seemed kind of "Dorky." : )

I'm writing an app that will produce php code to help me administer 
mysql db's. I'm at the point where it can read the table and field 
data and create objects with that info. Now I'm at the part where 
it goes back and pulls that data out. So, I've assigned each table 
an index # then in the "columns" object, it refers back to that index. 
Since I have a block of those column objects I was just looking for 
a spiffy way of finding which ones, for example, of finding all of 
the objects that are part of table index #3.

I've always used the "foreach " method but you know, I'm always looking 
for a way to improve my code. Thanks Gregg for your input.

Thanks, Pekr, DocKimbel would be indeed the person to ask because 
of his work on the mySQL drivers. After all, a directory (on which 
LDAP focuses)  is nothing but a specialized database. I'm not sure 
what my needs are because I just started playing with it. Maybe Rebol 
can assist in the conversion of external sources (CSV for example) 
to ldif format and possibly populating the directory automatically.

What is the right way to check  is port (ODBC, mySQL) open?
Is it a-port/port-id ?

Janeks, Dockimbel recently put some code in the MySql group regarding 
how to check for Mysql port being opened.

Having a bock of blocks that I want to look more readable how do 
I get each block to start on a new line...


I've tried to append 'newline to end of each block but it does not 
seem to work.


Now I'm having a similar problem using Paul's tretbase. I've been 
using MySQL to store formatted text that when I load it I can run 
my parse function on. When I sttore the same text in tretbase and 
load it my parse function fails. 
When I probe the text from each tehy look different:

MySQL preserves the carriage returns: 
[5 "FFP-LADDERS" "1-PORTABLE LADDERS" "2.1.2" {
\table
Straight Weight^-Ladders
20'^-55 lbs.
20'(Hook)^-60 lbs.
12'(Hook)^-35 lbs.
/table
} "" "2008-07-22 00:12:24"]


Tretbase seems to store the carriage return's character code but 
displays 'flat':

[5 "FFP-LADDERS" "1-PORTABLE LADDERS" "2.1.2" { \table Straight Weight^-Ladders 
20'^-55 lbs. 20'(Hook)^-60 lbs. 12'(Hook)^-35 lbs. /table } "" 20-Sep-2008/3:07:19-4:00]

What Might I be doing wrong?

to generate IDs, I do a nasty infalable trick on mysql.  i insert 
directly, in a uid table.

but there are no race-conditions, since insert is atomic in mysql.

bummer:
** Access Error: Cannot open /C/rebol/local/bens2000as/c$/mysql/

what is the fastest way to count the occurence of each numbers
within a block containing 5000+ numbers?  

e.g [1 3 6 2 4 9 33 6 67 2 12 23 34 12 2 4 56 2 ...]

calculating the max and min with a simple loop and counter is 
very time consuming for thousends of these blocks. 
inserting into mysql and doing a 'group by' also. 
any ideas for a faster solution?

I'll be serving time from the same server hosting the MYSQL DB..so 
if timeserver is down its irrelevant as they will not be reaching 
hte DB either...

what about R3 status ? make uptodate  R2 is very fine but i would 
prefer a R3 version with GUI and ODBC or MYSQL ..................;

... as for request-dir - today I saw another native one dialog. Dunno 
programmers do have to produce one themselves or not. It was with 
mySQL installation procedure. I looked like typical Windows request-file 
requestor, but it had set filter to "directory". Could anyone check 
on that, please? I really do not like that inconsistency in rebol 
...

I put a VID screen on some mySQL data (using the Doc's protocol) 
and allowed paging through it using the left and right arrows. Worked 
fine for a small database; very fast refresh of the page. 

When I used the same approach on a larger DB with some TEXT fields, 
it started to hang at the same record when going '"right".   


After much trial and error and guessing, I think it is because the 
database is not quite fast enough to refresh the screen to keep up 
with holding the key down.   


I put it sub-second wait in before the screen reshows its values 
and the problem went away.   	ie wait 00:00:00.005   


I don't think it is a database problem because it could happen with 
slower devices such as files. 


Is this consistent with what others have seen or am I 'fixing' the 
wrong problem?

Now on cursors - of course, old x-base aproach is possible with SQL 
too, it is called "live cursor" or something like that. But with 
larger systems, adming don't allow or don't like to see it, as it 
consumes additional resources. Some of databases even don't have 
it. IIRC mySQL will introduce it from version 5.0, or maybe I am 
wrong ....

Not using a cursor. Right key action  increments current-record-key. 
Retrieves single row for current-record-key, Displays page with data 
for row retrieved.  The database is local and only has (so far) 120 
rows but I have another with three hundred shorter records (no BLOBs) 
on it and it works well without any wait.  i.e. I can hold down the 
right key and it will flash each page by.  MySQL protocol has always 
seemed very fast to me.  Is it possible that View is stacking up 
the key actions and hanging after it gets too many?  p.s. I don't 
want to read the whole database content into memory because then 
I have to worry about locking when I allow HTML updates to it by 
others.  Single row updates with the last update 'winning' in the 
unlikely event of a collision works well for what I need to do.

MikeL, I think the problem is as you suspect. Whenever you WAIT for 
something (in your case MySQL), you are also waiting for view events. 
Your view events are arriving faster than the results are in the 
mysql port. Put a simple lock in your code:

 button "next" [if not working? [ working?: yes  next-page  working?: 
 no ]  ; where next-page sends and waits for my-sql port.

A bit more about my guesses about VID and mySQL. I wasn't sure it 
was not the number of rows that was causing the lockup so I loaded 
100,000 rows into the MySQL table and VID seems to be able to page 
through them based on right arrow (meaning get the next, display 
it, repeat until last row) i.e. hold it down and the row information 
will flash on the screen and eventually catch up.   The hanging seems 
to be a combination of stacked UI events and hitting a mySQL row 
that has a large BLOB in it.   Small text values in the BLOB are 
handled.   I can page past a large BLOB provided that there is not 
an accumulation of UI events.  If there is not a large BLOB in the 
rows being read, then it does not hang when VID is asked to page 
through at a rate it can not quite keep up with.

Well, I just saw list-view get updated with the mysql data. How cool.

I just saw list-view get updated with the mysql data
? Is there some mysql interface now in list-view?

it supports object lists now. mysql views, I think he means that 
output from mysql-protocol.r fits in list-view.

I've been using list-view with mysql-protocol for a while but the 
method I use to move data back and forth between mysql data and the 
list-view is not very elegant. Are there any examples of how object 
lists..mysql views work with list-view?

object lists are not suited for mysql results. just use plain blocks 
in blocks, returned from the database. that works fine.

Btw, why are you using ODBC to connect to a MySQL server ?

Quite old story, I had command version and not yet knowledge about 
Softinov mySql driver, and I used it to access also MsSql

/Command has a MySQL driver built-in, as you're using ODBC, I'm just 
guessing that the MySQL built-in driver didn't fit your needs.

While you're there Dockimbel, I've always wanted to know how one 
checks for the mysql port being open. Occasionally my apps meet with 
a closed port and die.

answer in MySQL channel

Janeks, you may have missed it, but /Command also has a native MySQL 
driver (so you don't need ODBC for MySQL). (That's what Doc was trying 
to say :)

Yes - I was wrong in my sitation description - I actualy used native 
MySql driver. I just messed it with MsSQL ODBC.

I'll also be storing on a server using mySQL.

I want to display it during an "insert"  using mysql-protocol....I 
guess its not happening

the mysql protocol is sync, and not async asfaik, so you can't out 
of the box.  if view could display animated gifs then you could but 
it can't

I'm using mysql for the online component but I need a local storage 
method too for offline use

Streamed parsing with backtracking : sure, it's possible, I'm doing 
that in postgresql driver since 2001 and more recently in the experimental 
async mysql driver release last year. (It's not done in a easily 
reusable way, thought).

postgresql or mysql also pretty much required

This release focuses on making the system usable for running a number 
of standard servers, and several innovative REBOL servers.


The development files of the system, program headers, static libraries 
and development documentation, were moved to a separate area in /system/development/ 
and are now shipped in a separate package. If you want to compile 
software on Syllable Server, you need to install and register this 
package. The development files need to match the system: you can't 
use a package of any other Syllable version. (You will also need 
to install the Developer's Delight package collection and possibly 
other packages.)


User directories were moved from /home/ to /users/. Resource packages 
are in the process of moving from /usr/ to /resources/. /resources/ 
is currently a symbolic link to /usr/ so that resource packages will 
work from both places during the migration.


Many fixes were made, including more fixes for the CUPS print server 
and GhostScript. Creation of extra user accounts is possible now.


Many packages were updated, including the Linux kernel, IPTables, 
the GCC libraries, OpenSSH, SDL and QEmu. DirectFB was not upgraded 
due to incompatibility with Links2.


CDRTools were included for burning CDs, and the NetCat networking 
tool and the Transmission BitTorrent client were added.


In addition to the Syllable-specific early initialisation scripts 
(in the early-init subdirectory of packages), the late initialisation 
scripts (in the init subdirectory of packages) are now also executed. 
Several more initialisation scripts from Linux From Scratch were 
also added. Some servers can be started with the LFS scripts, others 
with the Syllable scripts (this will be unified in later releases).


The OpenSSH server was configured and now runs by default. At the 
first system start, security keys are generated that identify the 
server.


A collection of well-known root certificates from Certification Authorities 
was added to allow OpenSSL-based programs (such as OpenSSH) to establish 
the identity of destination points for network connections.


A MIME-types database was added in /etc/mime.types that is used by 
many programs, such as web servers, to identify the MIME types of 
files based on their file name extensions.

Several REBOL software stacks were added:

- The REBOL/Services Service Oriented Architecture.

- The UniServe network server framework.
- The Cheyenne Apache-class web server.
- A CAPTCHA library.
- A MySQL network protocol.

- The QuarterMaster web programming framework, based on a Model-View-Controller 
architecture. By default, it's configured to run on Cheyenne.


- The TINY library for parsing text, abstracting data access and 
building templates of generic text formats (including HTML). This 
library is an original creation and targets both ORCA and REBOL.


Configurations, including initialisation scripts, were added for 
the OpenSSH remote access server, the CUPS print server, the BIND 
domain name server, the Apache web server, the RSync file synchronisation 
server, the SaMBa Windows-compatible file server, the INetUtils FTP 
server and the VSFTP FTP server. Several of these are not included 
in the system, but need to be installed separately (the system is 
prepared for them). The sshd, cupsd and initd servers are started 
by default.


S3Cmd/S3Sync was included, a tool for accessing the Amazon Simple 
Storage Service (S3) and synchronising files with it.


As a demo, the Genode operating system framework, its Nitpicker windowing 
server (built on SDL) and its demonstration programs were included.

Can Syllable run things like vbulletin ?  Needs php and mysql

It contains REBOL/View 2.7.7, Boron, ORCA, AltME, the development 
version of Cheyenne with WebSockets, QuarterMaster, REBOL/Services 
and some smaller things such as Doc's MySQL driver, all preconfigured

To run syllable server, I personally need

1. ghostscript
2. hylaFAX
3. oracle or mysql
4. jira
5. pmwiki
6. apache
7. cheyenne

They run Linux of-course. Could you see Windows 95 with remote swap 
file? Maybe so, but I never tried that :-) They use them as production 
line terminals - various stages of production, recording info, storing 
into mySQL. The app was initially simple, now it is not simple anymore 
:-) I always said my friend is crazy. I suggested python, perl, etc. 
to him, to be more safe, but he did like REBOL, its size, just-on-file 
aspect, and now the system might be rolled to UK based facility :-)

now to figure how to backup the mysql files and transfer them to 
a backup of the vm

the most common packages, I have in root of my app, or system/ subdir 
... so e.g. cyphre-styles, reddb, mysql, rebgui .... or how guys 
you simply pack or distribute your app then? doing with cache aproach 
is imo oncorrect, especially if you don't distinguis version of rebgui 
in the path. What if I don't have time to adapt all my apps to new 
version? above aproach shares rebgui dir for all apps ... wrong imo 
....

I want to use RebGUI with MySQL using Doc Kimmel's protocol. Doc's 
protocol provides a block of blocks of data but RebGUI's table widget 
I believe is looking for a single block for the data. What is the 
best way to handle the sql blocks. Having each row in a block is 
handy for  manipulation.

This seems to work in lInux.  In display.r, change

							find [f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12] event/key
to 

       find [ console listen tcp udp icmp dns local odbc oracle mysql crypt 
       compress ] event/key

and redefine on-fkey in rebgui-ctx.r

	on-fkey: make object! [

   console: listen: tcp: udp: icmp: dns: local: odbc: oracle: mysql: 
   crypt: compress: none
	]

Hello. One of my friends, not even a probrammer, jut Perl user, was 
asked to prepare solution for their production line. They will need 
to cover more than 100 Terminals with touch screens. He is a friend 
of Bobik and mine, so Perl, Python, and REBOL alternatives were possible. 
I have the pleasure to aanoucne, that REBOL + RebGUI was choosen.


While app is rather primitive - few fields on the left, numeric + 
few alphabetic keys on the right, connecting to mySQL, the environment 
is also very restrictive - Terminals (don't remember the model) are 
older ones, 24MB of RAM, no hardisk, P300 performance. The solution 
boots Linux from network and RebGUI app is loaded ... only 1MB or 
RAM is left, so the solution is so so ...


I would like to ask, if RAM consumption could be improved with encapping 
app with rebface for e.g.?

take the example of MySQL ... redHat, SuSe and others...

Well, I can give him some other options, like telling him, that he 
could use sqlite, mysql, postgress, as we have drivers for them. 
Not sure about the hash and its speed, etc.

makes you wonder if mysql is next ...

Gabriele, any plans to improve the library interface for R3, or even 
make it free so that more people use it (I don't think this affects 
RT sales b/c most companies buy solutions, e.g. FCGI or MySQL api, 
... )

Gabriele - what will happen to ports? Carl mentioned e.g. mySQL will 
move away from kernel - will there be any other "component" (call 
it whatever) interface to "plug-in" functionality to rebol?

maybe the easier porting will be because there will be nothing like 
mysql driver inside etc.

I am not sure I am confusing anything. If it is not there, then it 
is not there. I can give an example - Bobik - he left rebol, because 
of our often claims, that we can do anything. But he is looking for 
the end user tool. He does not want to code mySQL driver himself, 
he wants to use one. So, if you will have website with rebol features, 
what will be your answer to following bullet:

certificates support: 


Yes, or no? Am I able to easily send rebol email, signed, which displays 
in Thunderbird or Outlook, as signed? Am I able to choose from centrally 
installed certificates in Windows certificate container? That is 
my point. So - if it is only 3 lines of code, just take a note, and 
when RT will be thinking of security/privacy issues, please count 
such things in?

In fact both. I worked on a multi-user contact management application 
that connects to a SQL database (mysql and sql-server). There are 
some main areas I want to investigate into : DB access (Trebase could 
be a sexy alternative to other db engine), GUI and business logic 
processing. In the last area, I think that rewrite some code in R3 
can produce more elegant and more efficient program. I'm one of the 
guy who used hash! datatype ;-)

Karim, then I think it is a bit preliminary to consider porting:


- mysql, postgress - while those schemes are built upon raw TCP R2 
stack as a schemes, someone would have to port them to async R3 networking 
kernel

- sqlite - requires mostly DLL access. There is no DLL access in 
R3 and maybe there will not be one like we know it in R2. Carl is 
not decided yet, if we go via DLL layer like in R2, or via standardised 
plug-in interface, which is not ready though, as it needs modules, 
which are not ready either

- GUI - Gabriele was working on new VID. It is now called VID 3.3 
(third prototype). It is still not complete. But - Carl is trying 
to follow slightly different obectives, so he decided to rewrite 
it and bring us VID 3.4 prototype (probably called GIDI)

- View, unless Cyphre fixes some harsh bugs in its kernel, is pretty 
much buggy and makes VID3.3 crash in few secs to minutes.

I've stopped working on the products built with REBOL I was planning 
to release. The future of REBOL as a standalone programming language, 
has become too uncertain for me. I'm working only on Cheyenne and 
MySQL driver, because I use them daily, but I don't think that I 
will invest more time and energy than that on REBOL. I've already 
started searching for alternative solutions, including resume working 
on a clone or a derivated of REBOL. In the past, I've stopped working 
on a clone because, the release of the plugin interface for REBOL 
was supposed to be imminent. That was 3 years ago.

sql:// have been opened by  mysql-protocol so the limitation to access 
odbc:// was not working neither

BT: BDB is incompatible across versions, so that whenever you install 
something that uses it it needs to install its own version; it is 
bigger than things like sqlite which are much more powerful; and 
if you need a real thing just use postgres or mysql. BDB is just 
infinite bloat...

i wonder if some great guys who help carl thought about Database 
access ? odbc? rebol native lib for mysql db2 oracle mssql etc....

Steeve? DB scheme? Come on, guys, you must live in wonderland, no? 
So supporting sqlite, mysql, postgress, and others via ODBC is not 
enough?

kib2 : nothing was really missing in factor ... I live from my coding 
so I have to choose the tools where I think I will fasters with least 
problems and best solve what I need... this was a web-app that needed 
to run on desktop to (so all apache+ XX + mysql) fell of and it gave 
me a reason to make it with factor.

It is not problem of ODBC you can have it today in Rebol 2, even 
better use SQLite or MySQL layer you have at hand, but SQL is not 
the only solution

We've got server side cookie handling, session support, db  ( mysql, 
postgresql ) and web server

'do-sql is using a trick to determine if the scheme is using a native 
driver (RT's) or a user-defined one. It's testing db-port/handler 
: none means native driver, other value means user-defined. This 
was working ok with the native MySQL driver, could you tell me if 
this test is also ok for a odbc:// driver ? (just open an odbc connection 
in console mode and tell me the value of db-port/handler)

just in case if you want to have macports php5 support mysql 5.1.x,
install this before php5 and php5 will recognise and use it:
sudo port install mysql5-devel +server

My memcache is slective, it only caches the queries declared by user, 
not all queries. The MySQL backend that I use already does a good 
job at general query caching.

do you query mysql with mysql-protocol.r at the same time ?

I don't use mysql.... it's all flat files

we can easily apt-get mysql

Does the mysql access support in Cheyenne call stored procedures 
yet?

Not yet, because that mysql driver version has not been officially 
released yet (still some bugs pending to fix).

Sure, more tester would be nice, you'll find the last driver beta 
download URL in the MySQL AltME channel.

Technically MySQL stored procs require support for multiple results 
sets.

Updates made no difference...Having trouble with getting MySQL running 
properly too....Even XAMP is not wroking right. Must be something 
wacked on my computer or stuff running on WServer that I'm not aware 
of conflicting with this stuff.

New Cheyenne 0.9.19 beta version available for testing at : http://cheyenne-server.org/tmp/cheyenne-r0919.zip


Tested only on Windows  (my Linux image network has currently some 
issues).

ChangeLog (diff-ed from last test version) :


 o RSP: an HTTP redirection in 'on-page-start won't evaluate the page 
 script anymore.
	

 o CGI: mezz function READ-CGI now patched to be compatible with Cheyenne. 
 That's
	  the right way of reading POST data in REBOL CGI scripts.
	  
	o RSP: fixed a bug in session/add when setting a block! value.
	

 o Task-handler: fixed a network error on first packet read (high 
 load + fast hardware).
	

 o Task-handler: TCP keepalive mode activated (test workaround half-closed 
 connections).
	
	o Task-master: 
			o 'no-delay mode removed and replaced by 'keep-alive mode

   o now forks a new process as soon as one dies (not waiting for a 
   new request)

   o fix a long standing bug in queued job module name mismatching (can 
   happen under extreme load)
			o minor code cleanup
	

 o Uniserve: 'no-delay TCP network mode now switched off for all connections. 
 Fixes a

   stability issue on Vista and probably on UNIX with very high load.


 o RSP: fix a bug in 'decode-multipart when there's no file received.
	

 o UniServe: new logger service. Now all info or error logs, and debug 
 messages from

   CGI/RSP scripts are written in %trace.log. Additionnaly, you can 
   now log messages
	  using :
	  
	  		- debug/print msg 	; msg [string!]
	  		- debug/probe value 	; any mold-able value
	  		- ?? word		; works like REBOL's '?? function
	  		- ? msg		; alias for debug/print
	  

 o RSP: in debug mode, page generation time and SQL queries stats 
 now added at bottom
	  of pages.
	  
	o RSP: error in events from %app-init.r now logged.
	

 o RSP: fix a rare RSP freezing issue when an error occurs in %RSP.r 
 (for example, by
	  a user script that breaks RSP sandbox).
	  

 o RSP: sanboxing now protects from Exit/Return/Break calls made outside 
 of a
	  function context.
	  
	o RSP: %misc/rsp-init.r file removed.
	

 o RSP/CGI: New config keyword added in global sections : 'worker-libs. 
 It lists the

   librairies to load when a worker process is started. An optional 
   'on-quit section can

   be added to call cleanup code when the process quits. Examples :
	  
	  		worker-libs [
				%libs/mysql-protocols.r
				...
			]
		or	
			worker-libs [
				%libs/mysql-protocols.r
				...
				on-quit [
					%/libs/free-resources.r
				]
			]
	

 o Task-master: now you can reset all worker processes without stopping 
 Cheyenne. This

   is usefull when you need to force non-RSP/CGI files reload (helper 
   scripts, 3rd party
	  librairies,...). 
	  
	  	Usage:
	
			Windows : tray icon -> Reset Workers
		

   UNIX : kill -s USR1 <pid>	(<pid> is Cheyenne's main process ID)
	 
	 

  o Added a -w command line option to set the worker processes number. 
	 
	   	Usage:
	   
	  		$ cheyenne -w <n>		(n [integer!] : CGI/RSP process number)
	   

    Use -w 0 to help debug CGI/RSP code by resetting worker processes 
    after each request.
	   (it's like calling "Reset workers" after each request).

I have one question... after working in various other languages + 
mysql/sqlite I am using normal files with rebol structures and LOAD 
for my first projects here. Now I have a little more serrious project 
up so I started thinking if by using just files I can corrupt data 
somehow. I am not that good on low level details, but I imagine that 
I don't have to worry too much. Because cheyenne is single process 
I imagine only single write to file can happen to some file at any 
given time. Am I correct or wrong?

that is the same if you have a simpler mysql based webapp.. one person 
starts editing text, another person starts editing , first saves, 
second saves.. first person looses the changes.. that is basically 
problem on application level and is the same here as if using RDBMS

Robert - thanks for explanation.. I should of known these things 
but I have been in mysql world too long :)

Hello everybody!

I''m new with Rebol, I hav a small server (VIA M-EPIA) and 512Mb 
of RAM and linux;
Is better Apache or Cheyen? 

I need only PHP, MySQL and linux script (image magick and ffmpeg), 
what are your opinions?

Re MaxV: If you plan to use *only* PHP and MySQL, I think that Apache 
is a more logical choice. Cheyenne is built mainly for web application 
programming in REBOL. Support for PHP is here only to avoid installing 
another web server if you already use Cheyenne (for REBOL apps).

I'm going to increase the post-mem-limit for now, but it would really 
help if I had the external file so I could have MySQL read it.

So could I, if I wasn't also running Cheyenne, MySQL, and my whole 
development platform.

What are the requirements to get a connection to a mysql database?

I have a %httpd.cfg as below   


--------------------------httpd.cfg --------------------------------

globals [  ...  worker-libs [  ...  %path/to/mysql-driver/mysql-protocol.r 
  ...  ]  ...  ]

my.virtual.host [   ....    databases [ db-name   mysql://root:[lpass-:-127-:-0-:-0-:-1]/table]	 
....   ]

----------------------------------------------------------------------


As far as I can see from the documentation and sample files, I should 
now be able to use SEND-SQL a alike on DB-NAME, but that gives nothing 
but script errors

	** Script Error : db-name has no value 
	** Where: rsp-script 
	** Near:  [print mold db-name  


I've already spent hours on this without getting a clue on what to 
do.

Of course I can connect to the database directly thru mysql-protocol, 
I just don't get it up and running with cheyenne.

I've found I can use Cheyenne's own DO-SQL instead of mysql-driver's 
SEND-SQL.