Re: Any tips for switching between programming languages

It's tricky.

I've had days that start with ANSI SQL and python, followed by Oracle SQL and PL/SQL with Javascript/JQuery and ended with C# and LUA.

It's inevitable that you'll use a single where you should use a double quote or end up with a semicolon to terminate a python line.

What I found to help is to take a conscious break - say take a 5 minute walk - and imagine yourself switching jobs during that. Eventually you'll get used to it.

If you have friends that speak different languages you can also practise this. It felt very similar to me when me and the wife had dinner with two couples - one spoke French, the other English and Thai with the wife. The act of switching is actually similar to switching programming languages on the fly, and particularly if you don't use a certain language that often (like me with French) - it also helps to try and flick an actual switch in your mind to trick yourself into adapting to it better.

But mostly - don't sweat it. I just very recently realized that my muscle memory seems to be stronger than my conscious mind. After 20 years of Oracle, the string data type that my fingers want to type is varchar2. It doesn't matter that I am totally and completely aware of the fact that postgres doesn't use varchar2 but varchar - I will each and every single time find myself typing varchar2 and deleting the "2". And yes, as I typed that sentence, I had to delete a few "2"s.

Stefan

On Tue, 22 Sep 2020, 01:15 kunwar singh, <krishsingh.111_at_gmail.com> wrote:

> Hi Listers,
> How do you guys manage to switch between many languages?
>
> When I program in bash I get a feeling that python is foreign to me.
> Any tips that you can suggest? I would really appreciate it.
> I am DBA and not a full-time developer :)
>
> --
> Cheers,
> Kunwar
>

--
http://www.freelists.org/webpage/oracle-l