Programming language origins?

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
The weekly ponderable!

I've often thought, how are programming languages made? Why does VBA know that For i = 1 to 10 means it has to use the variable i = 1, then i = 2, then i = 3, etc... How does it even know what a variable is!? How does it know what each character is meant to do?

We type all of these words into a programming editor, but have you ever wondered how really simple it is all made, even when it seems incredibly complex? Would it be just a bajillion 1's and 0's?
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
The weekly ponderable!

I've often thought, how are programming languages made? Why does VBA know that For i = 1 to 10 means it has to use the variable i = 1, then i = 2, then i = 3, etc... How does it even know what a variable is!? How does it know what each character is meant to do?

We type all of these words into a programming editor, but have you ever wondered how really simple it is all made, even when it seems incredibly complex? Would it be just a bajillion 1's and 0's?

A good read would be:

Brookshear, J. G. (1985). Computer science: An overview. Benjamin/Cummings.
 
the languages we use are just an interface to the real language that the cpu uses. you are correct in saying that its just a bunch of 1s and 0s. way back in the olden days, i used to program at assembler level which is one step above binary. cpus only understand binary, and it is the luxury of speed and memory that allows us to use text based editors, and then visual environments.

the vbe is an 'interpriter' firstly which interprits the english code and parses it for correctness (syntax) and when we choose Run, it 'compiles' the code so that the cpu can understand what is required.

the cpu can only do a small number of processes such as compare, add, AND, OR etc. and the clever people at Intel hard code an instruction set onto the cpu that teaches it how to perform more complex tasks. it takes literally hundreds of cpu instructions to perform even a simple task like loading an emply window.
 
Some years ago I read a story about how computers originally were very hard to use. And a woman in the US Navy came up with the first programming language. Just recently I tried to find info on her and was not able to find anything about her.

If I remember right, she took the 1's and 0's language and changed it into something usable where commands could be given for computers to understand. It was a very interesting article but don't remember where I read it.

We men tend to be very task oriented and can categorize problems and solve them one at a time. Where women supposedly are more spaggetti oriented where their thoughts wander more to include the unrelated and perhaps irrelevant (according to us men anyway).

So that was why I found it interesting that it was a woman who was acknowledged as the first one to develop a computer language. I think she came up with the idea and implemented it to be an actual working reality. 1940's 1950's something like that. Maybe while the men were perfecting the 1's and 0's processing, she spaggettied out the process to include a more practical interface we men had not highly considered yet?

Would like to re-read things about that development if it can be found.

I often talk over my programming pursuits with my wife. And she goes off into what seems to be the irrelevant sometimes. But sometimes she brings things into the process that I have completely overlooked while I have been working away on perfecting a task, and am missing other important relavancies. It is a good balance sometimes.

Chuck
 
The weekly ponderable!

I've often thought, how are programming languages made? Why does VBA know that For i = 1 to 10 means it has to use the variable i = 1, then i = 2, then i = 3, etc... How does it even know what a variable is!? How does it know what each character is meant to do?

We type all of these words into a programming editor, but have you ever wondered how really simple it is all made, even when it seems incredibly complex? Would it be just a bajillion 1's and 0's?
I've often contemplated this:

If you need to know a computer language to create a new computer language then how did they create the very first computer language?
 
Yes - She tended to push the envelope on things a it. Went against the grain a bit so to speak. Sometimes that is what it takes to discover or develop something. Not simply accept things as they are, but ask why, and pursue the what if's. Develop that type of pattern of looking into things. Not do things a certaion way just because that is how they are always done. But pursue perhaps what is possible or what really are the facts.

I remember now where I read about her before. It was her obituary in "Investor Business Daily" in the section they had on Successful People. I don't get IBD anymore but I used to clip out their articles on Successful People or what ever it was called. And would reread them occassionally. And give them to my nephews when they were growing up.

As I wanted to understand better how many of them thought and how they went about things. There are patterns they had in common. And I found it very interesting and then try to apply those things when certain situations call for such.

Applies in programming too when one tries to do things perhaps not of the status quo so to speak. Or wants to develop something useful or needed.
 
I've often contemplated this:

If you need to know a computer language to create a new computer language then how did they create the very first computer language?

the first 'language' i used was 6502 but every step was manual. as in i had a circuit board with a 0 - F keypad on it, a 6502 and some support chips, some 7-segment displays like an old calculator and about 512 bytes of memory.

one hand wrote the instructions in 'pseudocode'
eg Call subroutine MySub

would have been

JFN MySub which meant JumpFunction MySub

then one hand converted that to hexidecimal...

20 0F 10 (20 - the hex for JFN) (0F 10 the memory location where MySub starts)

then when the whole program was done one keyed it in on the hex keypad.
IF it worked then you got it right, but invariable it took several goes to make it behave.


the first languages evolved from this by putting instruction groups together and saving them in a ROM and allowing the user to use a more 'english like' environment to access the code snippits.


Ah them was the days :biggrin:
 
Keywords instead of a long answer:

- logical design of switching systems
- turing machine programme
- compilation

...long, though not necessarily good, answer available if you want one.
 

Forum statistics

Threads
1,223,761
Messages
6,174,343
Members
452,556
Latest member
Chrisolowolafe

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top