Horton

Thread

  1. Favorite Linux Editor for PostgreSQL Scripts?

    steve_miller@sil.org — 2003-02-06T15:24:51Z

    I'm still new to the Linux world, and do not have a bias for editor choice.
I have one colleague that uses Emacs, but another is worried it leads to
RSI and carpel tunnel syndrome, because the hands are on the keyboard all
the time.

So what are the favorites for PostgreSQL scripts? I need to start learning
one.

Steve Miller
SIL International

  2. Re: Favorite Linux Editor for PostgreSQL Scripts?

    Thomas Adam <thomas_adam16@yahoo.com> — 2003-02-06T15:39:33Z

    It depends....

I use vi, and specify the environment variable
"PSQL_EDITOR" in "/etc/profile.local", thus:

export PSQL_EDITOR="/usr/bin/vi"

then when I want to edit a file, from within psql,
type:

\e /path/tp/file.sql

:-) easy.

-- Thomas Adam

 --- Steve_Miller@sil.org wrote: > I'm still new to
the Linux world, and do not have a
> bias for editor choice.
> I have one colleague that uses Emacs, but another is
> worried it leads to
> RSI and carpel tunnel syndrome, because the hands
> are on the keyboard all
> the time.
> 
> So what are the favorites for PostgreSQL scripts? I
> need to start learning
> one.
> 
> Steve Miller
> SIL International
> 
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org) 

=====
Thomas Adam

"The Linux Weekend Mechanic" -- www.linuxgazette.com

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

  3. Re: Favorite Linux Editor for PostgreSQL Scripts?

    Chris Thompson <thompson@ednet.co.uk> — 2003-02-06T15:48:55Z

    Not so sure that the problem is the keyboard, more how you use it. 
Get a decent keyboard and learn to type, you should be fine. 

On the linux side, skip emacs, use vim, tis a lovely editor :)
Besides that, you could use some of the development IDE's such as 
KDevelop. 

Cheers

On Thu, 6 Feb 2003, Steve_Miller@sil.org wrote:

> I'm still new to the Linux world, and do not have a bias for editor choice.
> I have one colleague that uses Emacs, but another is worried it leads to
> RSI and carpel tunnel syndrome, because the hands are on the keyboard all
> the time.
> 
> So what are the favorites for PostgreSQL scripts? I need to start learning
> one.
> 
> Steve Miller
> SIL International
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> -- 
> Virus scanned by edNET.
> 

-- 

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. Any
offers or quotation of service are subject to formal specification.
Errors and omissions excepted.  Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of edNET or lightershade ltd. Finally, the
recipient should check this email and any attachments for the presence of
viruses.  edNET and lightershade ltd accepts no liability for any damage
caused by any virus transmitted by this email.

-- 
-- 
Virus scanned by edNET.

  4. Re: Favorite Linux Editor for PostgreSQL Scripts?

    Aarni Ruuhimäki <aarni.ruuhimaki@kymi.com> — 2003-02-06T16:12:02Z

    Hi Steve !

On command line I use joe.

On KDE, joe via terminal and Kedit. With VNC you can Kedit or Gedit or 
whatever 'locally'. Even from a windows-box.

BR,

aarni

On Thursday 06 February 2003 05:24 pm, you wrote:
> I'm still new to the Linux world, and do not have a bias for editor choice.
> I have one colleague that uses Emacs, but another is worried it leads to
> RSI and carpel tunnel syndrome, because the hands are on the keyboard all
> the time.
>
> So what are the favorites for PostgreSQL scripts? I need to start learning
> one.
>
> Steve Miller
> SIL International
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

  5. Re: Favorite Linux Editor for PostgreSQL Scripts?

    ghaverla@freenet.edmonton.ab.ca — 2003-02-06T16:24:25Z

    On Thu, 6 Feb 2003 Steve_Miller@sil.org wrote:

> I'm still new to the Linux world, and do not have a bias for editor choice.
> I have one colleague that uses Emacs, but another is worried it leads to
> RSI and carpel tunnel syndrome, because the hands are on the keyboard all
> the time.

I lean towards emacs.  But, ....  There is some evidence to
suggest that RSI (including carpal tunnel syndrome) is in part
"socially acceptable", and that has something to do with its
prevalence.  The statistics are wishy-washy, like a lot of things
biological, but it seems that if you live in a culture where
RSI is socially acceptable, you stand a larger chance of catching
(or getting) it, for the same exposure to some environment.  This
isn't to say that the pain is imagined, they can instrument
people, and they can see that pain signals are being transmitted,
so something of it is real.  I think the jury is still out on
just what is necessary and sufficient conditions to get it.

I've always believed that if I do a couple of things, I will lower
my chance to get it.
 1) Every 20-40 minutes, get away from the computer for a few
    minutes.  Let the eyes focus on some distance other than 18
    inches (or whatever).  Stretch the wrist in the 4
    (predominant) directions of movement: flexion, extention,
    rotation clockwise, rotation counter-clockwise.  I've never
    looked into the side to side motions (or done anything).
    Drinking caffienated beverages is good, it forces you to
    go to the bathroom if nothing else (getting away from the
    computer).
 2) Keep your wrists (heck, your whole body) strong.  Get to the
    gym once in a while.  Do exercises which require stronger
    muscles/tendons/ligaments in the area of the wrist.
I don't think the above works as far as rehab goes, if you already
have symptoms, I think you need to get your doctor involved.  But
as a prophylactic, I think the above works.  Or, at least it seems
to for me.

Gord
-- 
Matter Realisations     http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng. President
101  9504 182 St. NW    Edmonton, AB, CA  T5T 3A7
780/481-8019            ghaverla @ freenet.edmonton.ab.ca
780/993-1274 (alt.)

  6. Re: Favorite Linux Editor for PostgreSQL Scripts?

    brew@themode.com — 2003-02-06T17:05:09Z

    > So what are the favorites for PostgreSQL scripts? I need to start learning
> one.

I use a vi clone, vim, mainly because I tend to like to be in text mode
rather than run a gui.  I use a laptop and my eyes aren't so good anymore.
I also use pico for quick fixes, but vim allows me to switch back and
forth between multiple files and copy and paste code into the other
window.

All text editors with no mouse involved, so it doesn't really answere your
question!  OK, gang, should I too consider a gui editor, maybe even vim in
X?

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
     Check out my Musician's Online Database Exchange (The MODE Pages)
                        http://www.TheMode.com
 ==========================================================================

  7. Re: Favorite Linux Editor for PostgreSQL Scripts?

    Jason Earl <jason.earl@simplot.com> — 2003-02-06T17:46:52Z

    Steve_Miller@sil.org writes:

> I'm still new to the Linux world, and do not have a bias for editor
> choice.  I have one colleague that uses Emacs, but another is
> worried it leads to RSI and carpel tunnel syndrome, because the
> hands are on the keyboard all the time.

Emacs has a lot going for it as a programmer's editor, especially for
working with PostgreSQL (it has several modes that allow you to do
most of your PostgreSQL work directly in an Emacs buffer).  If you are
concerned about the wacky keystrokes giving you RSI then you might
want to consider running Emacs in Viper mode.  Viper is a vi-emulation
package that runs on top of Emacs.  This allows you to use vi's more
typist friendly keystrokes with Emacs' wide range of powerful
extensions.

> So what are the favorites for PostgreSQL scripts? I need to start
> learning one.

Good Luck,

Jason

  8. Re: Favorite Linux Editor for PostgreSQL Scripts?

    Steve Crawford <scrawford@pinpointresearch.com> — 2003-02-06T18:59:08Z

    You have lots of editors to choose from but probably the most widely used (at 
least by professionals) and biggest cause of religious editor wars are emacs 
and vi (actually vim, that is "vi improved", is the most common version of vi 
on Linux distros).

I chose to learn vim because:
-it is reasonably small and fast
-there are versions for unix/linux/dos/windows/X-windows/etc. (one editor to 
rule them all...)
-it is the one editor that you find on basically all *nix platforms so you 
need to know it anyway.

BTW, learning vi (or emacs, I guess) is frustrating but once you get it you 
will not want to go back.

HTH,
Steve

On Thursday 06 February 2003 7:24 am, Steve_Miller@sil.org wrote:
> I'm still new to the Linux world, and do not have a bias for editor choice.
> I have one colleague that uses Emacs, but another is worried it leads to
> RSI and carpel tunnel syndrome, because the hands are on the keyboard all
> the time.
>
> So what are the favorites for PostgreSQL scripts? I need to start learning
> one.
>
> Steve Miller
> SIL International
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

  9. Re: Favorite Linux Editor for PostgreSQL Scripts?

    simran <simran.list@leonardchristian.com> — 2003-02-06T23:53:54Z

    vim is the best :-) (well, i like it anyway :-) 

Try out some of the scripts at:

http://vim.sourceforge.net/script_search.php?keywords=database&script_type=&order_by=rating&direction=descending&search=search

if you want extra macros/colours/extentions etc.. 

On Fri, 2003-02-07 at 05:59, Steve Crawford wrote:
> You have lots of editors to choose from but probably the most widely used (at 
> least by professionals) and biggest cause of religious editor wars are emacs 
> and vi (actually vim, that is "vi improved", is the most common version of vi 
> on Linux distros).
> 
> I chose to learn vim because:
> -it is reasonably small and fast
> -there are versions for unix/linux/dos/windows/X-windows/etc. (one editor to 
> rule them all...)
> -it is the one editor that you find on basically all *nix platforms so you 
> need to know it anyway.
> 
> BTW, learning vi (or emacs, I guess) is frustrating but once you get it you 
> will not want to go back.
> 
> HTH,
> Steve
> 
> On Thursday 06 February 2003 7:24 am, Steve_Miller@sil.org wrote:
> > I'm still new to the Linux world, and do not have a bias for editor choice.
> > I have one colleague that uses Emacs, but another is worried it leads to
> > RSI and carpel tunnel syndrome, because the hands are on the keyboard all
> > the time.
> >
> > So what are the favorites for PostgreSQL scripts? I need to start learning
> > one.
> >
> > Steve Miller
> > SIL International
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html