[Info-Ingres] Ingres Wikipedia entry
Martin Bowes
Hi All,
Roy shamed me into editing the Wiki entry for Ingres…For which I duly apologise.
I suck at presentation. I generally have the look of someone who's just been dragged backwards through a hedge…and this extends to most things I engage in. You can take the boy out of Wangaratta, you just can't take the Wangaratta out of the boy!
So please all of you highly polished individuals get on to http://en.wikipedia.org/wiki/Ingres_(database) and start sprinkling the Pizazz onto it.
Martin Bowes
Roy Hann
> Roy shamed me into editing the Wiki entry for Ingres...For which I duly
> apologise.
You are too modest. You clearly spent a fair bit of time on that; more
than I did.
> I suck at presentation. I generally have the look of someone who's just
> been dragged backwards through a hedge...and this extends to most things
> I engage in. You can take the boy out of Wangaratta, you just can't take
> the Wangaratta out of the boy!
Not even if you put him in a Victorian nut-house...
> So please all of you highly polished individuals get on to
> http://en.wikipedia.org/wiki/Ingres_(database) and start sprinkling the
> Pizazz onto it.
For some reason that link didn't render properly in my newsreader (XPN),
so just in case it isn't an XPN bug, here it is again:
http://en.wikipedia.org/wiki/Ingres_(database).
--
Roy
UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.
Roy Hann
> For some reason that link didn't render properly in my newsreader (XPN),
> so just in case it isn't an XPN bug, here it is again:
> http://en.wikipedia.org/wiki/Ingres_(database).
OK, it's an XPN bug. :-(
On Web
news:R4idnTbimpzYNDLU...@pipex.net...
> Roy Hann wrote:
>
>> For some reason that link didn't render properly in my newsreader (XPN),
>> so just in case it isn't an XPN bug, here it is again:
>> http://en.wikipedia.org/wiki/Ingres_(database).
>
> OK, it's an XPN bug. :-(
The link should be http://en.wikipedia.org/wiki/Ingres_database
On Web
news:%YNrl.48132$PT2....@newsfe11.ams2...
> "Roy Hann" <spec...@processed.almost.meat> wrote in message
> news:R4idnTbimpzYNDLU...@pipex.net...
>> Roy Hann wrote:
>>
>>> For some reason that link didn't render properly in my newsreader (XPN),
>>> so just in case it isn't an XPN bug, here it is again:
>>> http://en.wikipedia.org/wiki/Ingres_(database).
>>
>> OK, it's an XPN bug. :-(
>
> The link should be http://en.wikipedia.org/wiki/Ingres_database
LOL, or even http://en.wikipedia.org/wiki/Ingres_(database)
Richard Tyler-Jones
This gets appropriately redirected
http://en.wikipedia.org/wiki/INGRES
Cheers
Richard
> _______________________________________________
> Info-Ingres mailing list
> Info-...@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>
Paul White
Is there a protocol for updating this page? I was able to make changes
without signing in.
Do I need to crack open a stubby before starting?
I fixed a couple of typos and learned something new.
"Indexes may be queried directly. In most respects they behave just like
tables."
It seems like it could be useful but I'm not sure how yet.
CREATE INDEX idx_customer_name ON customer (lastname) WITH STORAGE =
BTREE\g
SELECT lastname FROM idx_customer_name \g
Paul
Roy Hann
> Hey Marty, Roy
>
> Is there a protocol for updating this page? I was able to make changes
> without signing in.
You shouldn't be able to do that. Perhaps you were already signed in?
> Do I need to crack open a stubby before starting?
My daughter insists that I must wear my "Wikipedia editing shirt".
But she thinks most of my clothes are for editing wikipedia. She can be
very hurtful.
> I fixed a couple of typos and learned something new.
>
> "Indexes may be queried directly. In most respects they behave just like
> tables."
>
> It seems like it could be useful but I'm not sure how yet.
It's true, but it is highly inadvisable to hard-code something like
that. Ingres is perfectly capable of recognizing when it is useful, and
will re-write your query accordingly. But more to the point, it is
capable of recognizing when it is not useful, and if you've hard-coded
it you are stuck with it. Indexes are not as helpful as is
often assumed.
Roy Hann
> Paul White wrote:
>
>> Hey Marty, Roy
>>
>> Is there a protocol for updating this page? I was able to make changes
>> without signing in.
>
> You shouldn't be able to do that. Perhaps you were already signed in?
It seems I too can edit without logging in. Maybe you are supposed to
be able to do that. I just assumed.
Martin Bowes
There is a difference in contactability...IIRC if you don't sign in your
more visible to the outside world and more likely to be spammed off the
planet.
Marty
Roy Hann wrote:
--
Roy
Martin Bowes
I'm glad this has started something!
I don't think we need worry about protocols other than what Wiki
provides. I'd only suggest we keep the contents reasonably brief and not
rewrite all the manuals. I'd like to see it more as a teaser rather than
a full on 'How-To' guide.
What we probably need is someone with an eye for presentation to add
some pretty pictures and change a few minor things ... the words come to
mind...
> Do I need to crack open a stubby before starting?
I did, which could explian a lot.
> I fixed a couple of typos and learned something new.
Spelling is for wimps...although I'd suggest you don't drop the G in
'Angus Beef Burgers'.
> "Indexes may be queried directly. In most respects they behave just
like
> tables."
I wouldn't normally query an index directly...Although it sorta looks
useful, like providing an optimizer hint. But as Roy says...the
importance of Indexes can be over-rated. I'd say well chosen and
maintained indexes are vital, but just don't go slapping them on
everything without thinking.
What we really need is a monitor statistic that says how often the index
has been used since server startup.
Marty
Paul White
> But she thinks most of my clothes are for editing wikipedia. She can be
very hurtful.
I recently discovered working from home is kinda fun, I also discovered
working clothes are optional.
Roy Hann
> I wouldn't normally query an index directly...Although it sorta looks
> useful, like providing an optimizer hint.
Optimizer hints were recently mooted for Ingres and even made it onto
the development roadmap. Personally I hate the idea of optimizer hints
for a whole lot of reasons. (Ditto REPEATED queries in embedded SQL.)
Happily that particular detour into La-La Land has been cancelled.
Lest anyone get the wrong idea, my objection to hints and REPEATED is
that programmers shouldn't have to know that much about the insides of
the server in order to use it effectively and correctly. Ingres should
figure it out for itself and if it doesn't that should be treated as a
bug and fixed like a bug.
Relying on those kinds of hacks to achieve acceptable performance is
ultimately counter-productive. For years Ingres got away with using
REPEATED queries as a crutch, then found itself unable to cope with
storms of near-identical queries coming from ODBC and JDBC clients.
Happily the problem has now been addressed properly, without using
goofy non-standard syntax. (I first heard about it from Doug Inkster,
so I am going to assume it was his work. Thanks Doug! :-)
Explicitly referring to an index in a query is a handy lifeline when you
get a botched release, but that is all.
Martin Bowes
> Explicitly referring to an index in a query is a handy lifeline when
you
> get a botched release, but that is all.
I'm 100% in agreement with that.
Marty
PS. I've made some more additions to the Wiki entry.
Paul White
So does that mean that the REPEATED in front of every single SQL statement
in our OpenROAD programs is now having no effect? Ooohh nooooooo!
I will have to go back to manually optimizing instructions to fall on a 256
byte boundary to help simplify the rotational delay calculations to
interleave my magnetic drum core memory.
Oh well
:%s/repeated //g
Onto the bourbon now.
Betty & Karl Schendel
On Mar 6, 2009, at 3:52 AM, Paul White wrote:
> Roy writes
>> But she thinks most of my clothes are for editing wikipedia. She
>> can be
> very hurtful.
>
> I recently discovered working from home is kinda fun, I also
> discovered
> working clothes are optional.
I made those pleasant discoveries some years ago... :-)
I don't plan to discuss the scoping of the word "optional".
Karl
Betty & Karl Schendel
On Mar 6, 2009, at 7:06 AM, Paul White wrote:
>>> Happily that particular detour into La-La Land has been cancelled.
>
> So does that mean that the REPEATED in front of every single SQL
> statement
> in our OpenROAD programs is now having no effect? Ooohh nooooooo!
no, no, it was optimizer hints that was cancelled. Your REPEATEDs still
have all the unfortunate effects that they did before.
>
> I will have to go back to manually optimizing instructions to fall
> on a 256
> byte boundary to help simplify the rotational delay calculations to
> interleave my magnetic drum core memory.
Even Jon Jensen isn't THAT old. :-)
Karl
Paul White
like a complete ingres newbie I performed this test..
* create index idx_customer_firstname on customer (first_name) with
structure = heap ;\g
Executing . . .
E_US14C1 CREATE INDEX: Bad storage structure 'heap'. The valid storage
structure names are [c]btree, [c]isam, [c]hash.
ummmm
What does the [c] mean?
Roy Hann
>>> Happily that particular detour into La-La Land has been cancelled.
>
> So does that mean that the REPEATED in front of every single SQL statement
> in our OpenROAD programs is now having no effect? Ooohh nooooooo!
If they are in front of every single SQL statement then you are misusing
them , which would brilliantly illustrate why I think hints are a bad
idea.
(Of course if you meant to say "Does that mean every single REPEATED in
front of an SQL statement..." then I take that back.)
> I will have to go back to manually optimizing instructions to fall on a 256
> byte boundary to help simplify the rotational delay calculations to
> interleave my magnetic drum core memory.
I have seen drum memory in use, but I was a child. I do remember being
deeply impressed by the idea of arranging data to ensure it would spin
into position at the ideal time. But then again, compound steam engines
also impressed me. :-)
> Oh well
> :%s/repeated //g
>
> Onto the bourbon now.
A breakfast drink.
Roy Hann
Compressed. It's a QUEL-ism. (Or at maybe more accurately, the
separate COMPRESSED keyword was introduced at about the same time as
SQL was added as a supported language.) It is retained for backward
compatibility.
Martin Bowes
and data compression or not for the given structure.
Marty
-----Original Message-----
From: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of Paul
White
Sent: 06 March 2009 12:27
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Index storage structures
Before asking a potentially really dumb question and risk of a sounding
like a complete ingres newbie I performed this test..
* create index idx_customer_firstname on customer (first_name) with
structure = heap ;\g
Executing . . .
E_US14C1 CREATE INDEX: Bad storage structure 'heap'. The valid storage
structure names are [c]btree, [c]isam, [c]hash.
ummmm
What does the [c] mean?
_______________________________________________
Jürgen Cappel
AFAIK that means (C)ompressed, trailing white space removed.
Jürgen
-------- Original-Nachricht --------
Betreff: [Info-Ingres] Index storage structures
Datum: Fri, 6 Mar 2009 23:27:00 +1100
Von: Paul White <pwh...@peercore.com.au>
Antwort an: Ingres and related product discussion forum
<info-...@kettleriverconsulting.com>
An: Ingres and related product discussion forum
<info-...@kettleriverconsulting.com>
Referenzen:
<mailman.606.1236247...@kettleriverconsulting.com><fNydnX399K3LNTLU...@pipex.net><R4idnTbimpzYNDLU...@pipex.net><%YNrl.48132$PT2....@newsfe11.ams2><t_Nrl.48133$PT2....@newsfe11.ams2><Pine.GSO.4.64.09...@granby.ccc.nottingham.ac.uk><E83CAA680E7A584E9EC...@peercoresbs2003.peercore.local><mailman.610.1236329...@kettleriverconsulting.com><pM2dncx0DJYSbi3U...@pipex.net>
<E7321E45EFCFAD4C995A...@exch-p202.ctsu.ox.ac.uk>
Andrew
OK... Sorry... I thought for a second Paul said "clothes are optional"...
Anyway, the boss in the office has asked me to investigate converting
some of our report writer printouts into PDF.
Thing is, we use PCL coding in most of our reports and so I need to ask
for help.
Can anyone please give me some advice or examples on PCL to PDF
conversion on a linux server? Or should I change the rw code to maybe
generate html code and then convert that to pdf? Is it possible to
generate pdf files from rw code?
Any help would be greatly appreciated.
Regards,
Andrew.
Paul White wrote:
> Roy writes
>
>> But she thinks most of my clothes are for editing wikipedia. She can be
>>
> very hurtful.
>
> I recently discovered working from home is kinda fun, I also discovered
> working clothes are optional.
>
>
Roy Hann
> Whoa...
>
> OK... Sorry... I thought for a second Paul said "clothes are optional"...
>
>
> Anyway, the boss in the office has asked me to investigate converting
> some of our report writer printouts into PDF.
>
> Thing is, we use PCL coding in most of our reports and so I need to ask
> for help.
>
> Can anyone please give me some advice or examples on PCL to PDF
> conversion on a linux server? Or should I change the rw code to maybe
> generate html code and then convert that to pdf? Is it possible to
> generate pdf files from rw code?
>
> Any help would be greatly appreciated.
Your simplest solution might be to look for a PDF pseudo-printer driver.
I'm sure such things exist for Linux, but the one I use extensively on
Windows is CutePDF. You print as usual, except instead of being sent to
a real printer the output gets sent to a PDF file. It is endlessly
useful.
Anthony Simpson
of pcl to pdf using ghostpcl with a google search.
pdf is just a subset of postscript. Both can be generated from code as
postscript is a very simple stack based language. Pdf is slightly harder
to generate as you need to include additional comments describing page
format to be compliant.
Cheers,
Tony
-----Original Message-----
From: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of
Andrew
Sent: 06 March 2009 14:12
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Report Writer - PCL to PDF
Whoa...
OK... Sorry... I thought for a second Paul said "clothes are
optional"...
Anyway, the boss in the office has asked me to investigate converting
some of our report writer printouts into PDF.
Thing is, we use PCL coding in most of our reports and so I need to ask
for help.
Can anyone please give me some advice or examples on PCL to PDF
conversion on a linux server? Or should I change the rw code to maybe
generate html code and then convert that to pdf? Is it possible to
generate pdf files from rw code?
Any help would be greatly appreciated.
Regards,
Teresa
questions aren't prepared the dynamic query caching feature has no
effect.
Teresa
On Mar 6, 4:10 am, Betty & Karl Schendel <schen...@kbcomputer.com>
wrote:
Robert Allely
linux.
enscript - convert text files to PostScript
ps2pdf - ps2pdf - Convert PostScript to PDF using ghostscript
ps2pdf12 - Convert PostScript to PDF 1.2 (Acrobat 3-and-
later compatible) using ghostscript
ps2pdf13 - Convert PostScript to PDF 1.3 (Acrobat 4-and-
later compatible) using ghostscript
enscript -v -B $land -M A4 --download-font=letgothl.pfb \
--margins=0:0:0:0 --font=LetterGothicLine$fsiz -o $pfile $ifile
ps2pdf $pfile $ofile
rm -f $pfile
--Robert
-----Original Message-----
From: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of
Andrew
Sent: Saturday, 7 March 2009 3:12 a.m.
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Report Writer - PCL to PDF
Whoa...
OK... Sorry... I thought for a second Paul said "clothes are
optional"...
Anyway, the boss in the office has asked me to investigate converting
some of our report writer printouts into PDF.
Thing is, we use PCL coding in most of our reports and so I need to ask
for help.
Can anyone please give me some advice or examples on PCL to PDF
conversion on a linux server? Or should I change the rw code to maybe
generate html code and then convert that to pdf? Is it possible to
generate pdf files from rw code?
Any help would be greatly appreciated.
Regards,
Andrew.
Paul White wrote:
> Roy writes
>
>> But she thinks most of my clothes are for editing wikipedia. She can
>> be
>>
> very hurtful.
>
> I recently discovered working from home is kinda fun, I also
> discovered working clothes are optional.
>
>
> _______________________________________________
> Info-Ingres mailing list
> Info-...@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>
_______________________________________________
Info-Ingres mailing list
Info-...@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
Confidentiality/Privilege Notice:
This communication is confidential and may be legally privileged. If you are not the intended recipient please delete the message and notify the sender at Ports of Auckland Limited. Any use, disclosure, copying, distribution or retention of this communication is strictly prohibited.
Roy Hann
> The new dynamic query cache only works with prepared statements. If
> questions aren't prepared the dynamic query caching feature has no
> effect.
That is a fairly significant nuance I had overlooked. :-(
Martin Bowes
I've added some more changes to the wiki entry. Specifically tarted up
the Database Rules section and added headings for events and sequences.
Thanks to whoever added the bullet points to the 'Tables Section', looks
a lot neater.
Marty
Jeremy peel
jo
Marty
_______________________________________________
Info-Ingres mailing list
Info-...@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
--
Jeremy Peel
Martin Bowes
Hi Jeremy,
I noticed the DBP stuff this morning, looks good too!
Well done. There are planty of other sections you might like to do. I've scattered some topic headings in the area, but feel free to fill them in or add more.
Marty
From: info-ingr...@kettleriverconsulting.com [mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of Jeremy peel
Sent: 10 March 2009 10:25
To: Ingres and related product discussion forum
Cc: Roy Hann (E-mail)
Subject: Re: [Info-Ingres] Ingres Wikipedia entry
Ok, I'll come clean: I added
the bullet points. I have now gone on to populate the DBP section. Hope you
don't mind.
jo
On Mon, Mar 9, 2009 at 12:45 PM, Martin Bowes <martin...@ctsu.ox.ac.uk> wrote:
Hi All,
I've added some more changes to the wiki entry. Specifically tarted up
the Database Rules section and added headings for events and sequences.
Thanks to whoever added the bullet points to the 'Tables Section', looks
a lot neater.
Marty
_______________________________________________
Info-Ingres mailing list
Info-...@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
--
Jeremy Peel