firebird-docs — chat stuff about documentation

RE: [Firebird-docs] LockRequireSpins ??????

[Dmitry Y. <di...@us...>]

Helen,

> Would someone please confirm or deny that the parameter
> lock_acquire_spins
> has changed its name to LockREQUIRESpins????
>
> According to firebird.conf, it has...if so, why?

I've just answered in fb-devel. It's just a misspelling and will be fixed
ASAP.

> And more on the same entry in firebird.conf:
>
> # In Classic, only one client process may access the lock table at any
> # time. Access to the lock table is governed by a mutex. The mutex can
> # be requested conditionally -a wait is a failure and the request must
> # be retried - or unconditionally - the request will wait until it is
> # satisfied. This parameter establishes the ------> number of
> attempts
> <--------that
> # will be made conditionally. Relevant only on SMP machines.
> #
> # Type: boolean
> <-----------------------------------------------------------------
> #
> #LockRequireSpins = 0
>
> "This does not compute"

Yes, it should be integer instead. Will be fixed as well.


Dmitry

RE: [Firebird-docs] Environment variables

[Helen B. <he...@tp...>]

At 10:37 AM 19/06/2003 +0400, you wrote:
>Helen,
>
> > That's what I'm asking you.  :-)  The variables according to
> > 1.0, that I thought might have changed, were
>
> > INTERBASE, INTERBASE_LOCK, INTERBASE_MSG,
>
>Now named:
>FIREBIRD, FIREBIRD_LOCK, FIREBIRD_MSG
>
>My memory is starting to work ;-)

Oh, then I'll have two of whatever you're drinking, please.
;-)
H.

[Firebird-docs] Old config parameters

[Helen B. <he...@tp...>]

Dmitry,
A couple of the Windows parameters in the old ibconfig file don't have equivalents in firebird.conf.  

server_working_size_max 
Versions prior to Firebird 1.5 
Threshold above which the OS is requested to swap out all memory. Relevant on Windows NT/2000/XP only. Default is system-determined.

server_working_size_min 
Versions prior to Firebird 1.5 
Threshold below which the OS is requested not to swap out memory. Relevant on Windows NT/2000/XP only. Default is system-determined.

Will these still work if used in firebird.conf?  

As a general statement, if someone includes any parameter using its old name, will it be recognised?  If yes, would it work the way it did before or would it work the way the renamed parameter works?

thks
Helen

RE: [Firebird-docs] UdfAccess config parameter - possible problems

[Helen B. <he...@tp...>]

At 10:22 AM 19/06/2003 +0400, Dmitry Yemanov wrote:

>80 characters per line is no longer a restriction. AFAIU, any config line is
>[practically] unlimited in length. Probably, we should ask Alex to be 100%
>sure.

Probably.  :-))  Or test it with a line longer than 80?  If I can get my 
crazy machine to behave itself, I'll challenge the 80-char rule.

>Yes, relative paths are allowed, but they're resolved using the server's
>root directory (not the current directory of the running process), so I
>consider it quite safe.

OK.  You're da boss.  :-))

cheers,
Helen

RE: [Firebird-docs] Environment variables

[Dmitry Y. <di...@us...>]

Helen,

> That's what I'm asking you.  :-)  The variables according to 
> 1.0, that I thought might have changed, were

> INTERBASE, INTERBASE_LOCK, INTERBASE_MSG, 

Now named:
FIREBIRD, FIREBIRD_LOCK, FIREBIRD_MSG

My memory is starting to work ;-)

> INTERBASE_TMP

Not changed yet, although both Claudio and me think that it should be.

> ISC_USER, ISC_PASSWORD

Not changed.


Dmitry

[Firebird-docs] LockRequireSpins ??????

[Helen B. <he...@tp...>]

Hello Dmitry,

Originally I posted this in devel and got no answer.  It needs urgent 
attention, I think.


Would someone please confirm or deny that the parameter lock_acquire_spins 
has changed its name to LockREQUIRESpins????

According to firebird.conf, it has...if so, why?

And more on the same entry in firebird.conf:

# In Classic, only one client process may access the lock table at any
# time. Access to the lock table is governed by a mutex. The mutex can
# be requested conditionally -a wait is a failure and the request must
# be retried - or unconditionally - the request will wait until it is
# satisfied. This parameter establishes the ------> number of attempts 
<--------that
# will be made conditionally. Relevant only on SMP machines.
#
# Type: boolean 
<-----------------------------------------------------------------
#
#LockRequireSpins = 0

"This does not compute"


thks,
Helen 

RE: [Firebird-docs] More on UdfAccess

[Dmitry Y. <di...@us...>]

Helen,

> To quote the doc in firebird.conf:
>
> "UdfAccess may be None, Full or Restrict. If you choose
> Restrict, provide ';'-separated trees list, where UDF libraries
> are stored. Relative paths are treated relative to RootDirectory entry
> (see above). Default value 'Restrict UDF' provides the same
> restrictions
> as in FB 1.0. To specify access to specific trees, enum all required
> paths (for Win32 this may be something like 'C:\ExternalFunctions',
> for unix - '/db/extern;/mnt/extern')."
>
> Now -
> Does None mean that UDFs are to be disallowed on the server
> altogether?

Yes. The same rule applies to e.g. ExternalFileAccess.

> Default value 'Restrict UDF' or 'Restrict'?

"Restrict UDF", because FB1 has ./UDF directory as a default for the
libraries.

> And, if it's "as in FB 1.0" does this mean the same as
> "Full"?  AFAIK, the
> external_function_dir locations had no restrictions...so
> could you explain
> what is meant by Restrict and Full?

None:
  - no UDF library can be used at all
Full:
  - every UDF library may be used
Restrict <list>:
  - only UDF libraries located in <list> may be used
  - if no path is specified, the lookup is done in the <list>

I.e. the 'Restrict' option combines both security and search order.


Dmitry

RE: [Firebird-docs] UdfAccess config parameter - possible problems

[Dmitry Y. <di...@us...>]

Helen,

> In working through firebird.conf, I have come across 2
> possible problems with the syntax for UdfAccess.
>
> First, existing documentation insists that the width of a
> config file entry
> may not exceed 80 characters per line, including whitespace.
> I think MOST
> UdfAccess entries would exceed 80, perhaps quite considerably.
>
> Previously, we had external_file_directory parameter entry
> per line, and
> even that was pushing the 80-character limit in some cases.
> The new syntax
> requires a colon-separated list in addition to other pieces
> of syntax, + spaces...

80 characters per line is no longer a restriction. AFAIU, any config line is
[practically] unlimited in length. Probably, we should ask Alex to be 100%
sure.

> Second, I see in the file that relative paths are allowed.  I
> am quite sure
> it was agreed by most people that relative paths were not a
> safe idea and
> that all path addressing would be absolute.

Yes, relative paths are allowed, but they're resolved using the server's
root directory (not the current directory of the running process), so I
consider it quite safe.


Dmitry

RE: [Firebird-docs] Environment variables

[Helen B. <he...@tp...>]

Hi Dmitry - welcome back! :-)

At 09:56 AM 19/06/2003 +0400, Dmitry Yemanov wrote:
>Helen,
>
> > Dmitry, et al.,
>
>Sorry for a late reply, I was offline these days.
>
> > Where can I find documentation of the new and changed environment
> > variables, please?
>
>Hmmm, have we really changed any environment variables? I cannot recall at
>the moment that something was added or changed.

That's what I'm asking you.  :-)  The variables according to 1.0, that I 
thought might have changed, were INTERBASE, INTERBASE_LOCK, INTERBASE_MSG, 
INTERBASE_TMP, ISC_USER, ISC_PASSWORD.

cheers,
Helen

RE: [Firebird-docs] Environment variables

[Dmitry Y. <di...@us...>]

Helen,

> Dmitry, et al.,

Sorry for a late reply, I was offline these days.

> Where can I find documentation of the new and changed environment
> variables, please?

Hmmm, have we really changed any environment variables? I cannot recall at
the moment that something was added or changed.


Dmitry

[Firebird-docs] More on UdfAccess

[Helen B. <he...@tp...>]

Dmitry,
To quote the doc in firebird.conf:

"UdfAccess may be None, Full or Restrict. If you choose
Restrict, provide ';'-separated trees list, where UDF libraries
are stored. Relative paths are treated relative to RootDirectory entry
(see above). Default value 'Restrict UDF' provides the same restrictions
as in FB 1.0. To specify access to specific trees, enum all required
paths (for Win32 this may be something like 'C:\ExternalFunctions',
for unix - '/db/extern;/mnt/extern')."

Now -
Does None mean that UDFs are to be disallowed on the server altogether?

Default value 'Restrict UDF' or 'Restrict'?

And, if it's "as in FB 1.0" does this mean the same as "Full"?  AFAIK, the 
external_function_dir locations had no restrictions...so could you explain 
what is meant by Restrict and Full?

Thks,
Helen

[Firebird-docs] UdfAccess config parameter - possible problems

[Helen B. <he...@tp...>]

Dmitry,

In working through firebird.conf, I have come across 2 possible problems 
with the syntax for UdfAccess.

First, existing documentation insists that the width of a config file entry 
may not exceed 80 characters per line, including whitespace.  I think MOST 
UdfAccess entries would exceed 80, perhaps quite considerably.

Previously, we had external_file_directory parameter entry per line, and 
even that was pushing the 80-character limit in some cases.  The new syntax 
requires a colon-separated list in addition to other pieces of syntax, + 
spaces...

Second, I see in the file that relative paths are allowed.  I am quite sure 
it was agreed by most people that relative paths were not a safe idea and 
that all path addressing would be absolute.

Comments please.

Thks
Helen

Re: [Firebird-docs] V.1.5 Release notes

[Tilo M. <tm...@al...>]

Hi,

> Is this in CVS somewhere? I know that there was in the CVS the beginnings
of
> something based on interbase documentation, but I thought it was abandoned
> due to uncertainty over copyright issues. Is this something different? I'd
> love to proof read, and even document stuff if I can help. It's why I am
> subscribed to the -docs list.

We have tried more than one time to get a response from Borland regarding
copyright issues of the Beta docs. After no response after all we decided to
continue converting the docs as a first starter for the Fb docs.
So expect commits real soon. They will include some fully converted IB 6
Beta docs and a updated building process which is now compatible with the
latest JDK. From that point on we can then revise and complete the docs.

Regards,
Tilo

[Firebird-docs] Environment variables

[Helen B. <he...@tp...>]

Dmitry, et al.,
Where can I find documentation of the new and changed environment 
variables, please?

Thanx
Helen

RE: [Firebird-docs] V.1.5 Release notes

[Robert J. M. <rj...@ar...>]

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of Paul
> Vinkenoog
> Sent: 06 June 2003 16:04
> To: fir...@li...
> Subject: Re: [Firebird-docs] V.1.5 Release notes
>
>
> Hello Karl,
>
> > Well, i never heard that there was a firebird documentation team. Is
> > it possible to join that team. I'm a native German, who reads
> > English quite well. Perhaps i can make some tranlations to german.
>
> At the moment, two people (Tilo Muetze and I) are working on a
> documentation set for Firebird (in XML, so it can be easily converted
> to other formats like PDF and HTML).

Is this in CVS somewhere? I know that there was in the CVS the beginnings of
something based on interbase documentation, but I thought it was abandoned
due to uncertainty over copyright issues. Is this something different? I'd
love to proof read, and even document stuff if I can help. It's why I am
subscribed to the -docs list.

Thanks,

Robert Munro
--
http://www.musicbrainz.org/ - A free community database of music. With
software tools to automatically recognise and lookup CDs and audio files.
http://www.ukfilmtalk.co.uk/ - An online community for film makers and film
lovers in the UK

Re: [Firebird-docs] V.1.5 Release notes

[Karl S. <web...@st...>]

Well, at the moment, right now, I'm going in holidays. But when i come back,
i will email to one of you.

Have 2 nice weeks

KS


"Paul Vinkenoog" <pa...@vi...> schrieb im Newsbeitrag
news:Pin...@s4......
> Hello Karl,
>
> > Well, i never heard that there was a firebird documentation team. Is
> > it possible to join that team. I'm a native German, who reads
> > English quite well. Perhaps i can make some tranlations to german.
>
> At the moment, two people (Tilo Muetze and I) are working on a
> documentation set for Firebird (in XML, so it can be easily converted
> to other formats like PDF and HTML).
>
> This is taking a LOT of time. If you want to do something, please
> contact either one of us - or both.
>
> If you're looking for already existing documentation to translate,
> have a look at www.ibphoenix.com (they have both free and $$$ docs).
>
> email:
> Tilo Muetze is tmuetze at web dot de
> I am paul at vinkenoog dot nl
>
> (replace at -> @, dot -> .)
>
>
> Greetings,
> Paul Vinkenoog
>
>
> P.S.: Tilo ist Deutscher wie du, mir kannst du auch auf deutsch mailen.
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Firebird-docs mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-docs
>

Re: [Firebird-docs] V.1.5 Release notes

[Paul V. <pa...@vi...>]

Hello Karl,

> Well, i never heard that there was a firebird documentation team. Is
> it possible to join that team. I'm a native German, who reads
> English quite well. Perhaps i can make some tranlations to german.

At the moment, two people (Tilo Muetze and I) are working on a
documentation set for Firebird (in XML, so it can be easily converted
to other formats like PDF and HTML).

This is taking a LOT of time. If you want to do something, please
contact either one of us - or both.

If you're looking for already existing documentation to translate,
have a look at www.ibphoenix.com (they have both free and $$$ docs).

email:
Tilo Muetze is tmuetze at web dot de
I am paul at vinkenoog dot nl

(replace at -> @, dot -> .)


Greetings,
Paul Vinkenoog


P.S.: Tilo ist Deutscher wie du, mir kannst du auch auf deutsch mailen.

Re: [Firebird-docs] V.1.5 Release notes

[Karl S. <web...@st...>]

Well,  i never heard that there was a firebird documentation team. Is it
possible to join that team. I'm a native German, who reads English quite
well. Perhaps i can make some tranlations to german.

KS

> I'd also welcome any inputs any of our Docs folk would like to make to the
> r/notes - sample code snippets using the new language features would be
> very acceptable;  any tried-and-true HowTo stuff about fbembed;  et al.
>
> best,
> Helen

[Firebird-docs] V.1.5 Release notes

[Helen B. <he...@tp...>]

Hi Tilo and others,

Do you mind if I hijack this list for a couple of weeks, whilst I assemble 
and verify the stuff for the v.1.5 release notes?  I can see it's already 
starting to annoy Dmitry, that I'm posting r/notes things in fb-devel...

I'd also welcome any inputs any of our Docs folk would like to make to the 
r/notes - sample code snippets using the new language features would be 
very acceptable;  any tried-and-true HowTo stuff about fbembed;  et al.

best,
Helen

Re: [Firebird-docs] Documenting a project from beginning to end

[Helen B. <he...@tp...>]

Sorry, Claire, I just picked this one up on return from the Fulda conference...

At 06:03 AM 23/05/2003 +0100, Claire Q'vant wrote:
>I've been involved in some discussions over at
>FreeBSDforums regarding FirebirdSQL, and it's adoption
>for PHP developers.
>
>I'm wondering if the following would help bolster it's
>uptake:
>  come up with a project requiring a powerful DB
>  design the DB, pushing logic and calcs into SP's and
>Triggs, rather then PHP/Layers on to
>  Document the setting up of server infrastructure,
>testing, capacity planning.
>   Document the creation of the database schema,
>maintenance procedures, etc
>   Document the UI code for the top
>
>A completely transparent project, with timelines,
>milestones, and all focussing on FirebirdSQL.
>
>If people didn't have to look any further for
>information, would this be a good thing?

Can a swim duck?  <g>

Is this a project you are planning?

regards,
Helen

[Firebird-docs] Documenting a project from beginning to end

[<cla...@ya...>]

I've been involved in some discussions over at
FreeBSDforums regarding FirebirdSQL, and it's adoption
for PHP developers.

I'm wondering if the following would help bolster it's
uptake:
 come up with a project requiring a powerful DB
 design the DB, pushing logic and calcs into SP's and
Triggs, rather then PHP/Layers on to
 Document the setting up of server infrastructure,
testing, capacity planning.
  Document the creation of the database schema,
maintenance procedures, etc
  Document the UI code for the top

A completely transparent project, with timelines,
milestones, and all focussing on FirebirdSQL.

If people didn't have to look any further for
information, would this be a good thing?

Claire.

p.s.
Discussion URL:
http://www.freebsdforums.org/forums/showthread.php?s=&threadid=7225

__________________________________________________
It's Samaritans' Week. Help Samaritans help others. 
Call 08709 000032 to give or donate online now at http://www.samaritans.org/support/donations.shtm

Re: [Firebird-docs] IIF and CASE use

[Helen B. <he...@tp...>]

At 04:26 PM 17/05/2003 +0200, Mihai Nicolae Teognoste wrote:
>Good day!
>
>I would like to know if (and how) I can use CASE or IIF in  a SELECT
>construction.
>My situation is: I have to build up the value of a field in an "insert into
>from select" based on it's value.
>
>Thanks,
>Mihai

This is the wrong place to ask support questions.  Subscribe to the 
ib-support list http://www.yahoogroups.com/community/ib-support

Helen

Re: [Firebird-docs] IIF and CASE use

[Aage J. <aag...@of...>]

On Sat, 17 May 2003 13:25:17 +0000 (UTC), Mihai Nicolae Teognoste wrote:

> I would like to know if (and how) I can use CASE or IIF in  a SELECT
> construction.
> My situation is: I have to build up the value of a field in an "insert 
> into from select" based on it's value.


1.  This is not the proper NG (try ib-support)
2.  You can (I think) do this with Fb/1.5 (it has been discussed just 
recently)
3.  Please post in 'plain text'

-- 
Aage J.

[Firebird-docs] IIF and CASE use

[Mihai N. T. <mih...@vi...>]

Good day!

I would like to know if (and how) I can use CASE or IIF in  a SELECT
construction.
My situation is: I have to build up the value of a field in an "insert =
into
from select" based on it's value.

Thanks,
Mihai

[Firebird-docs] ODBC and Embedded Server

[Christof <roj...@ya...>]

Hello,

Can the ODBC driver connect to the embedded server?

Thanks,
Chris.