Re: ubh 3.0b1 beta test

Hi all,

I tested a ubh 3.0beta a little bit, here are some random taughts:

At 00:44 +0000 31/12/02, gerardlanois <[email protected]> wrote:
>3. cd into the install subdirectory, and edit the 2_servers.sql
>    and 3_newsgroups.sql files to contain your server(s) and
>    groups.

This part is not really easy to do. I had to dig my old SQL book to 
complete it. Maibe a perl wizzard could help set this up.

>7. Run ubhasm

I'm amased at how fast this works compared to version 2.x. Is there 
some kind of trick?

>10. Let me know what you think.

In install/1_install.sql:
CREATE TABLE servers (
   server_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
   address   CHAR(128) NOT NULL,
   shortname CHAR(20) NOT NULL,
[...]
The address and shortname are of variable length, so I think it'd be 
better if you used varchar instead of char, from the MySQL manual 
(http://www.mysql.com/doc/en/CHAR.html):
-----
The length of a CHAR column is fixed to the length that you declare 
when you create the table. The length can be any value between 1 and 
255. (As of MySQL Version 3.23, the length of CHAR may be 0 to 255.) 
When CHAR values are stored, they are right-padded with spaces to the 
specified length. When CHAR values are retrieved, trailing spaces are 
removed.

Values in VARCHAR columns are variable-length strings. You can 
declare a VARCHAR column to be any length between 1 and 255, just as 
for CHAR columns. However, in contrast to CHAR, VARCHAR values are 
stored using only as many characters as are needed, plus one byte to 
record the length.
-----
So it may same some space to use varchar instead of char, especially 
for the msgid.

I'll continue to play with it,
GFK's
-- 
Guillaume Filion
Logidac Tech., Beaumont, Québec, Canada - http://logidac.com/
PGP Key and more: http://guillaume.filion.org/      (this will redirect)

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Flexible Keyboard is the ideal accessory for PDA users that are on the move.
http://us.click.yahoo.com/dCBVZC/WnCFAA/xGHJAA/IHFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[email protected]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/