Introduction
Over the last 6 years I dedicated most of my professional time launching softwares and analyzing how technology could improve company performances. Coming from a law education, far from the engineering universe I dragged my way up to the industry of the so called “Digital Transformation” with people from diverse backgrounds.
Many people in our industry (that has been in high demand in the last 10 years and will probably continue to be so in the 10 coming years) are self-learners with no prior technical degree, this observation leads us to two interesting consequences:
- The Y & Z generation has access to challenging jobs with good prospects requiring no dedicated degree (there are no specific degree for most of the digital jobs) but only with a proven willingness to work in digital, self learning and 1-3 years of work experience. Those can be acquired in many affordable ways; I will elaborate more on this in a separate article.
- Most of the people with no technical background tend to look dagger at each other, not knowing they should know one or the other technical term such as “SQL”, “API call”, “Instance”, etc or some people want to impress their peers with some terminology they just learned knowing they will be the only one to understand it. No convention or knowledge base has never been established about what a person active in the digital transformation should know about software development – this is what this article intends to tackle.
DISCLAIMER I: The concepts covered in this article have been selected by me as to be what I believe the basic concepts. You may believe I could have gone deeper, but a selection had to be made. I shall therefore limit the geeky acronyms to the minimum in this article.
DISCLAIMER II: I am on a continuous learning path, should something be wrong or unclear I hereby apologize in advance. I am open to any constructive feedback should some section be improved.
DISCLAIMER III: This article is short for the power of knowledge it covers. I encourage all digital project managers to read more about specific subjects or concepts they may find useful or interesting.
How the internet works: a waiter attending a client
There is no better analogy to explain how the internet works than by comparing it with someone ordering at a McDonalds’ drive-in. Let me further illustrate this:
A server is a centralized program that communicates over a network (such as the Internet) to serve clients. You have several types of servers but let us focus on web applications where two predominate: a web server and a database server. In our McDonalds analogy, the employee taking your order at the drive-in would be the web server and the other employee collecting your BigMac from the oven’s kitchen would be the database server.
A client is a program (like a web browser such as Chrome or Firefox) that can request data from a server – in other words, when you browse the web you are requesting a website (server) for its information. In our McDonalds’ case, this would be you (the client) ordering a menu at the drive-in.
The client can make several requests the same way you can ask the McDonalds’ employee questions about the menu, order products, modify an order, etc.
When you go to a web page, your browser (the client) makes a request to the server— this involves the web server making a further call to another server (data server) which will return the data you want to see for that page.
e.g.: looking up the history of Napoleon on Wikipedia technically means you are searching for all data on the Wikipedia server related to the keyword “Napoleon”.
Another important concept you should understand is that there is no absolute definition of a client and a server but a relative one. In the McDonalds example, there is a chain relationship: client – web server – data server, since the web server will make a request to the data server, the web server is the client in the web server-data server relationship. The server can thus become the client of another server depending on who is making the request and who is serving the request.
DataBases: where your store your product
Introduction
The main reason why we browse the web is to access information, content and eventually some specific features (that are also “per se” direct or indirect information). The database is for a website what a kitchen is to McDonalds, in other word it is where a website stores its data and where McDonalds store the food they sell (see below in red).
When we talk about databases we often rely on the term SQL relational databases, meaning because they:
1) can use data across tables (relational); and
2) use the standard SQL language that clients and developers will use to make requests to databases.
Join tables
You first need to understand that SQL relational databases are structured into tables (corresponding to a data model). Every table has many objects that have a unique ID automatically incremented every time a new object is created into the table.
Let’s forget the physical example of McDonalds for now and see how another restaurant “Acme Restaurant” could structure its database.
Looking at the tables of this restaurant database (see image on the left) you could infer that the restaurant sells two menus (Monster Menu and Healthy Menu) costing respectively 7$ and 5$ USD and that there are 3 meals available (Fish & Ships, Cesar Salad and Sushi). In this example there is a relation between the two tables (Menus and Meals) since a Menu record is made of different entries including a Meal ID coming from another table.
SQL queries
SQL is the standard language for servers when they perform a database action and communicate with other servers or clients. In the illustration above you could imagine browsing into Acme Restaurant website and clicking on the “menu button” – this would cause the web server to perform the following SQL query to the data server:
SELECT * MENU in AcmeRestaurant
The data server will return: “Monster Menu, Healthy Menu” to the web server that will return this same information to the client.
The database schema
Another key concept a project manager should understand is the concept of database schema.
In the example of Acme Restaurant above, the database schema is poor and restricting. Acme Restaurant could widen the options to their customers by:
- Sell meals apart from the menu’s: this is currently not possible since only menus have a price (as opposed to meals that do not have a price in their model).
- Having several dessert options for one menu (e.g.: order a “Healthy Menu” with a “Chocolate Mousse”), this is currently not possible since every menu is associated with one specific dessert name.
Creating a “Dessert” table would have been more flexible allowing to use data from a new table, namely “Dessert” into the “Menu” table. Consequently, this would broaden the dessert’s menu’s choices.
You may argue that a database schema is simple enough to be foretasted for and in addition that you can change a database schema. Though it is important to keep in mind that complex web applications may have hundreds of tables with millions of information changing your database schema putting your entire project at risk. In conclusion, I recommend making sure you have from the beginning a discussion with your team to allow enough flexibility for your business objectives.
Having a bad database schema is common as project evolve in their requirements and follow different strategy. A bad database schema is a good example of “technical debt“. As a project manager you will often refer to the term technical debt as something from the past that prevents you from moving forward or that affects your development velocity.
I will end this section with some market awareness: the major SQL relational databases’ providers used in software development are PostgreSQL and MySQL (now owned by Oracle).
Cloud servers: pay-as-you-go servers
What is a server made of?
Servers are basically made of two things: CPU on one hand and storage on the other hand.
1) CPU or Central Processing Units are used to compute math or execute codes and make up for what a computer program is; I prefer to call it computer power. Anything executing any sort of computer program has a CPU consumption (depending on the program complexity). As an example: a modern Texas Instrument® calculator consumes more CPU than Apollo XI which landed on the moon in 1969.
2) Storage: available space to store data. The byte is the unit we use to measure the available storage on a given place. We nowadays talk often of GB (Gigabyte) or TB (Terabyte). We will use storage to host our website database and its data.
Good to know! We execute programs and store data on our computer (desktop and laptop) on a daily basis. Now from a technical perspective the word “computer” refers too much to server components and this is why we now prefer to call our working computer our “machine”.
A short history of cloud computing
Computers (laptop or desktops) as we know them can be used as servers and were historically used as first servers hosting website on the internet.
Years later, in the 80-90’s, engineers designed specific hardwares to host websites – those were the first dedicated servers now called “on premise servers“. Most S&P 500 companies would have warehouses full of these physical servers to host their websites or other programs such as their ERPs, production softwares, etc.
The word “cloud server” was first used in 1996 but only became common in the last decades after Amazon launched its Elastic Cloud Compute product. Cloud servers (or “on demand servers”) are in fact on premise servers put at the disposal of companies and individuals by tech giants such as Google Cloud, AWS (Amazon) and Azure Microsoft. Those servers are available on demand in large quantities and in different regions on a pay-as-you-go basis.
Why is cloud computing often better for my digital projects?
Let’s start by pointing out the challenges and benefits you have with on premise servers:
1.On premise servers require setup and technical configurations that often take time
2.On premise servers need to be setup and maintained by qualified staff
3.On premise servers have a fixed amount of storage and CPU.
This means that if your project scales you will have to buy a new hardware which will include migration, setup, and maintenance. The fixed CPU and storage may also mean that you will find yourselves using 20% of your server capacity.
4.On premise servers centralize all your project in one place and are therefore centralizing your risk (technical issues, or physical damages incurred by the warehouse in which your hardware is held).
5.Budgets spent in on premise servers will often be considered as CAPEX or investments in your project (this may be a good/ bad thing depending on the company’s financial strategy).
6. Hardware servers may be cheaper than on demand servers.
Let’s now compare this list to on demand servers:
1.On demand servers can be set up in minutes. Although for complex and large projects this may require the intervention of one or several development engineers.
2.On demand servers require little or no maintenance compared to on premise servers, although some large projects may require the intervention of development engineers on cloud servers.
3.On demand servers allow for vertical scalability: you may increase/decrease your CPU or storage at any time without having to purchase a new hardware. CPU and storages are often powerful in an on demand servers.
4.On demand servers allow for horizontal scalability: you may use a large number of servers for one project, decreasing your risk in case one of them does not work. You may also consider using different servers in different geographical regions to serve different type of users.
5.Budget spent in on demand servers will often be considered as OPEX (the same way you pay a rent or a monthly service for your company). This may or may not suit your company’s financial strategy.
6. On demand server are expensive and invoiced per second. However, this can be offset by the fact that providers will often give important discounts if you can guarantee that you will use their server on a large period.
In conclusion, though the price may be higher at first, on demand servers will often provide your project with a better quality of service and project agility into the medium and longer term.
API’s: a broker granting access to your server
Concept
The API is the middleman in-between a client and a server. The sole objective of the API is to allow anyone to become a server’s client and to communicate with the given server. I do not see a better way to illustrate the API concept than by the inter-phone in our McDonald’s example (see in red).
In our daily life we use large platforms that give us access to their API to communicate and receive a service from their server. Some examples are Facebook for logins and profile information, Stripe for payment gateway, Google maps for geolocation purposes, etc. – if tomorrow you need their services, you will be able to make your website call their API to request something from their server.
Documentation
An API must be well documented (preferably with concrete examples) for the developers to know with relative ease how to make requests to the target server without errors. Examples of errors we often come across browsing the web are 404 errors (URL not found), 503 errors (unavailable), 401 (unavailable) or 403 (forbidden).
Here is an example of Stripe API documentation. Stripe is a payment provider that allows websites to accept online payment via Visa, MasterCard®, etc. Stripe’s service is fully online and your website (client) can directly use (call) their API, without any human intervention, to request Stripe (server) to check whether a payment is valid or not.
API calls
A client (browser, website server, etc.) can make a call (synonym for request) to an API. The API will then relay the request to the server.
There are 4 types of calls you can make to an API and subsequently to a server:
1.A PUT (and POST) request is made to send new information to the server and create a new record into a database.
E.g.: when you sign-up to a new website, you will fill in a form with information that will allow a new user to be created on the website’s database.
2.A GET request enables you to read something from the server database. GET requests are in fact made every time we browse a website and type and URL in our browser.
E.g.: you have no logins and go to Google.com and make a search, the results of your search are the response to your GET request.
3.PATCH request is to update a piece of information on the server database.
E.g.: you just edit your profile on a website and saved your changed information.
4.DELETE requests are made to remove something from the server database.
E.g.: you wish to delete your profile from a website.
Those 4 requests are commonly known as CRUD (Create Read Update Delete) operations in computer science and constitute the basics of back-end development.
API permissions
API’s are developed with safety in mind as they open the doors to servers. Creating an API is opening a door to your server and you want to make sure that not everyone can do everything on your server. There may be information you want to conceal from the whole wild web or an operation you want to prevent such as the deletion of key files.
Therefore, each call may contain a permission attached to it. POST, DELETE, UPDATE requests will often require a permission (e.g.: you need to be logged-in to delete your own profile on Facebook) whilst some GET requests (e.g.: display of a homepage) may not need any permission at all.
Permissions are packaged into a token that will be attached to the request. Tokens are encrypted and they tell the server who you are and consequently the permission you have when you perform a request.
You often see token in your browser URLs when they contain the “?token” parameter, for example:
http://www.example.com/foo/bar.htmltoken=1441307151_4492f25946a2e8e1414a8bb53dab8a6ba1cf4615
As you can imagine, tokens and permissions play a significant role in the authentication process: when you log in, your credentials are verified by a third party service that confirms who you are – this third-party server will then send a token to the original server containing all actions (permissions) the user is entitled to perform on the database.
WebHooks & Callbacks
As mentioned above, as a project manager you will often be required to use third-party services (payment gateway, authentication services, etc.) that have a well-documented API to be able to communicate with your web app.
Those services/servers are external to your web app and you consequently have limited permissions to check how they perform actions, manage their algorithm and verification processes. To solve this problem, we use web-hooks and callbacks.
Let’s say you are sending one of your web app users to Stripe® to verify a payment on your website. The callback allows your server to know that Stripe® has verified this user’s payment (without elaborating on Stripe’s security, how they verify payments, etc.) by making a request to your server with the details of what Stripe® has processed. In the case of a payment gateway, the callback will typically contain the name of the customer for whom the payment was verified, the product, the price, … so that your web app knows what the user’s next actions should be.
API as a reference for data transfer
As a project manager you are often asked to enable different systems to communicate with each other. A good example would be to ask a CRM (Sales and invoice management) to transfer an invoice to an Accounting Software (Financial dashboard and payment collection).
There are two key ways to transfer information from one system to another:
1.File exchanges: the old-fashioned way, often done by FTP.
This means that a routine from one of the systems will be executed every X time to import the data sent on/to? a particular storage. The downside to this method is that the transfer will not be in real time but every time the routine is executed.
2.APIs: API are the best way to transfer data from a server to another in real time. It means every time there is an update in server A, the identical update will be sent to server B.
When you are required to transfer data from one system to another, you know that API calls will be involved. Beware! API development often means more time consumption (data mapping between the systems) and higher costs (developments).
API and servers coding languages
All the programming related to servers and API is often called back-end development. Back-end programming languages are namely Python, PHP, .Net, Node JS.
Front-End development
The front-end of a web app is everything related to what a user can see on his browser and how he interacts with the user interface on his browser. Taking back our McDonalds example; it is the design of the inter-phone’s interface and how easily it will be for the user to instantly communicate with the waiter inside the restaurant .
Front-end programming languages are HTML, CSS, and JavaScript. A project front-end development includes three different areas:
a.Converting designs into HTML and CSS:
It is is about how well you can replicate on a browser the work of your design/UX team.
b.Create behavioral and dynamic effects in JavaScript, such as sticky menus, dropdown menus, autocomplete effects, etc:
These are all behaviors that go beyond designs requiring a browser to do more than HTML and CSS. JavaScript will also prove useful when it comes to web marketing and tracking (Google Analytics, Facebook Ads, Google Ads, Hotjar, etc.). Marketers add scripts or “tags” to track user’s behaviors on your website and send it back to the script owner. Marketers will be able to segment and target users who performed certain actions on your website.
c.Render the data given by your server into your web pages:
Front-end developers create templates that welcome the data from your database. This is how, for example, a web shop does not need the development of a webpage every time it sells a new product.
Production Pipeline and CI/CD
In this section, we will try to understand how developers produce a web app, where they start and how they upload their work to the internet.
As you could have imagined, a developer will begin the coding process on his own compute: this is known as a local environment only accessible by him.
As soon as the developer has produced something viable, he will push his code to a staging environment, also known as pre-prod or test server. The idea is to test the code developed on a server that has the exact same parameters as the production server. The staging environment address is invariably protected so that it is only known internally for testing purposes so that consumers and competitors are unaware of any ongoing changes.
The last phase of the pipeline is the production server (the code will be pulled from the staging to production by an experienced developer). The production server the actual server on which your users will access your web app on the internet.
In addition to the different development environment, the development team uses a version control system to make sure they are not confused as to which developers are working on which version of the code. The version control system keeps track of who is coding what and tracks all the changes into a software code. Standard version control systems are GitHub, Gitlab, Bitbucket.
Continuous Integration and delivery (CI/CD) to go from a development stage to production. These processes focus on small code changes and the automation of sending those code changes through the local, staging and production pipeline efficiently. There are many approaches to continuous integrations and delivery; the idea is to create a logical and efficient pipeline using for instance a project management software, a version control system and Cloud server tools. CI/ CD is a fashionable way for a project manager to build a web app with a development team.
UX/UI
A brainstorming is necessary before you put your frond-end developers to the work. UI/UX designer analyze user behaviors and how users will interact with your product. The UX/ UI team will create designs and mock-ups. This output will be then forwarded to Front-End developers to be converted into a programming language.
Conclusion
I hope you enjoyed reading this article (if you did please share the love!) as much as I enjoy writing it. If an article cannot make for years of experience, I encourage you to deepen those topics even further. At last, now that you understand how things work you have well deserved that burger 😉