teleren/devto huggingface dataset:
#11 DevOps Diary: Let's kick off 2021🎉
Tags: devops, kubernetes, docker, tutorial
Published: 2021-01-03 16:17:07

Welcome beautiful people! 

First of all, congratulations! Congratulations for making it through 2020. It was certainly a tough year for most of us and while we focus on expanding our tech skills and collaborating on tech projects, we shall not forget that we are all human with emotions and human struggles. Let's be kind to each other and support each other throughout 2021.

Happy New Year! 🎉

## Top Learning Resources 📖

- If you would like to learn more about the fundamentals of Computer Science, [this website](https://teachyourselfcs.com/) provides a comprehensive list of high quality resources, including lectures, e-books and more.
- Are you currently preparing for your [CKS Exam](https://training.linuxfoundation.org/certification/certified-kubernetes-security-specialist/)? [This exam serie](https://itnext.io/cks-exam-series-1-create-cluster-security-best-practices-50e35aaa67ae)s by [Killer Shell](https://twitter.com/_killer_shell) provides practice questions and answers in video format.
- Kubernetes Resource thread by [Daniele Polencic](https://twitter.com/danielepolencic), [sharing his 2020 learning journey](https://twitter.com/danielepolencic/status/1343478164836634625).

## Videos🎥

- Get started contributing to open source projects in 2021. Contributing to open source is a great way to contribute to real world projects and to expand your skills. I would highly recommend the [content by Eddie Jaoude](https://www.youtube.com/channel/UC5mnBodB73bR88fLXHSfzYA) to get stated 🙌🏼

## [You can view the entire newsletter here](https://blog.anaisurl.com/11-devops-diary/)
How to Edit a Formula in Excel ~ A Simple Tutorial!!
Tags: excelpreface, editaformula, excelbasics, exceltutorials
Published: 2021-01-03 16:34:38

---
title: How to Edit a Formula in Excel ~ A Simple Tutorial!!
published: true
date: 2021-01-03 16:05:58 UTC
tags: ExcelPreface,editaformula,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/edit-a-formula-in-excel/
---

In Excel, sometimes you need to modify or edit the formula. So here, we will discuss the simple steps used to **edit the formula in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Steps to edit the formula:

Before editing the formula, you need to know how to [enter a formula in Excel](https://geekexcel.com/how-to-enter-formula-in-excel/).

- First, you need to enter the formula in the selected cell.

![Enter formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Enter-formula-1.png)<figcaption id="caption-attachment-20520">Enter formula</figcaption>

- Then, you need to double-click the cell in the worksheet that contains a formula.

![Double-Click](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Double-Click.png)<figcaption id="caption-attachment-20521">Double-Click</figcaption>

- Here, you can change the formula in the selected cell or formula bar section as per your convenience.
- For example, we will change the formula from **“B3+B4-B5”** to **“B3+B4”** in the below image.

![Edit Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Edit-Formula.png)<figcaption id="caption-attachment-20531">Edit Formula</figcaption>

- Press the **ENTER** key from the keyboard to finish.
- Now, you can see the result in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Result-17.png)<figcaption id="caption-attachment-20532">Result</figcaption>

## Bottom-Up:

![🤞](https://s.w.org/images/core/emoji/13.0.1/72x72/1f91e.png) Hope you understood the simple steps to **edit the formula in Excel**. If you have any doubts regarding this article, feel free to let me know. Thank You so much for visiting our site!! To learn more, check out our website **[Geek Excel](https://geekexcel.com/)**.

### Related Articles:

- **[How to Show all Formulas in Excel Office 365 ~ With Examples!!](https://geekexcel.com/show-all-formulas-in-excel/)**
- **[How to Copy a Formula in Excel Office 365 ~ Simple Guide!!](https://geekexcel.com/how-to-copy-a-formula-in-excel/)**
- [**Shortcut to Add or Update Cell Note&#8221; in Excel Office 365**](https://geekexcel.com/shortcut-to-add-or-update-cell-note-in-excel-office-365/)
- **[Excel Formulas to Get the Employee Information with VLOOKUP Function](https://geekexcel.com/excel-formulas-get-employee-information-with-vlookup-function/)**
- **[Keyboard Shortcuts for Cell Edit Mode Option in Excel 365!!!](https://geekexcel.com/keyboard-shortcuts-for-cell-edit-mode-option-in-excel-365/)**
Run Postman Tests on Travis CI
Tags: webdev, testing, tutorial, beginners
Published: 2021-01-03 16:04:05

One of the great features of Postman is that it is really easy to integrate it with CI/CD tools like Travis CI, Jenkins, etc… In this post, we will take a look at how to run Postman tests on Travis CI.

### **Initial Setup**
To get the tests running on [Travis CI](https://travis-ci.com/), you’ll need to do some initial setup –

- Create a GitHub Repository and push collection and environment-related files to GitHub
- Connect your GitHub repository with TravisCI
Creating `.travis.yml` file
Once GitHub and Travis is connected, you can focus on creating the Travis configuration file which will look something like this –

```
language: node_js
node_js:
  - '14.4.0'
install:
  - npm install newman
script:
  - node_modules/.bin/newman run tests/Trello.postman_collection.json -e tests/Production.postman_environment.json
```

Once you push this file to GitHub, Travis will pick up the configuration file and start building your project and run all your tests in your collection.

![Travis Postman Tests Run](https://automationbro.com/wp-content/uploads/2020/12/image-17.png)

---

### **Check out the video below to learn more about Postman Travis integration –**
{% youtube wow432Ilr08 %}

---

### **What to learn next? 🤔**
If you have completed the [Postman Testing Series](https://www.youtube.com/watch?v=XzoIYpQ_k5E&list=PL6AdzyjjD5HCiZyLYZqjRrB15gHLs8uyV) and are now wondering what you should learn next? 

  💎 You can look into doing API automation using your favorite programming language to build a more scalable framework. I have also created a [JavaScript API Test Automation Tutorial Series](https://www.youtube.com/watch?v=ZSVw3TyZur4&list=PL6AdzyjjD5HDR2kNRU2dA1C8ydXRAaaBV) which will take you from scratch to building your own API test framework.

  💎 Or, if you would like to move on to front-end now, you can also check-out my [WebdriverIO Tutorial Series](https://www.youtube.com/watch?v=e8goAKb6CC0&list=PL6AdzyjjD5HBbt9amjf3wIVMaobb28ZYN)

Learning any of these skills will greatly help you in your career and provide you with a full-stack test automation experience.

---

📧 Subscribe to my [mailing list](https://automationbro.com/mailing-list) to get access to more content like this 
👍 Follow [automationbro](https://twitter.com/automationbro) on Twitter for the latest updates

...

I love coffees! And, if this post helped you out and you would like to support my work, you can do that by clicking on the button below and buying me a cup of coffee -

<a href="https://www.buymeacoffee.com/automationbro">![Buy me a coffee](https://dev-to-uploads.s3.amazonaws.com/i/4aw2ub3f4qkyjk0ivwt4.png)</a>

You can also support me by liking and sharing this content.

Thanks for reading!
Checkout git submodules by tag
Tags: git, submodule, devops, bash
Published: 2021-01-03 16:02:26

---
title: Checkout git submodules by tag
published: true
description: 
tags: git, submodule, devops, bash
//cover_image: https://direct_url_to_image.jpg
---

In the git documentation can read that the git submodule doesn't support update the submodule by tag.

This is a simple solution:

```bash
# update submodule
git submodule update --init
# set tag for boost submodules
DEFAULT_TAG="boost-1.70.0"
# update
git config -f .gitmodules --get-regexp '^submodule\..*\.url$' |
    while read -r KEY MODULE_PATH; do
        NAME="$(echo "${KEY}" | sed 's/^submodule\.\(.*\)\.url$/\1/')"
        if [[ $NAME =~ "boost" ]]; then
          pushd "${NAME}"
          git checkout -b new_branch_boost $DEFAULT_TAG                   
          popd
        fi
    done
```
Ebook to start in machine learning
Published: 2021-01-03 15:54:09

From the author of a world bestseller published in eleven languages, The Hundred-Page Machine Learning Book, this new book by Andriy Burkov is the most complete applied AI book out there. It is filled with best practices and design patterns of building reliable machine learning solutions that scale. Andriy Burkov has a Ph.D. in AI and is the leader of a machine learning team at Gartner. This book is based on Andriy’s own 15 years of experience in solving problems with AI as well as on the published experience of the industry leaders.

Link to Download: https://uploadrar.com/r6gvrs0l25fr
A simple way to enable CORS on Laravel
Tags: http, https, beginners, laravel
Published: 2021-01-03 15:48:08

# What is CORS?
CORS stands for Cross Origin Resource Sharing. Origin consists of protocol, domain and port number such as https://hogehoge.com:443. Therefore, CORS means allowing an web application on a certain origin (e.g. https://hogehoge.com) to access an web application on a different origin (e.g. https://fugafuga.com).

# Why is CORS necessary?
In order to prevent cross site scripting (XSS) and cross site request forgeries, JavaScript's asynchronous communication such as Ajax follows the same origin policy, which bans access to a different origin. Without CORS configuration, web applications can not access a different origin.

# What is required to enable CORS?
The simplest method to enable CORS is to add `Access-Control-Allow-Origin:*` to the response header from WEB servers, which allows CORS from any source. If you want to limit the source, you should specify the domain in the configuration such as `Access-Control-Allow-Origin:https://hogehoge.com`. You should note that a domain has to be specified if an http request includes cookie information.

# How to enable CORS on Laravel
You can use an middleware that adds `Access-Control-Allow-Origin` to an http response header.
1. create an middleware
```
$ php artisan make:middleware Cors
```

2.Edit the middleware
```
<?php

namespace App\Http\Middleware;

use Closure;

class Cors
{
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        return $next($request)
            ->header('Access-Control-Allow-Origin', '*')

    }
}
```
3.Add the middleware to Kernel.php
```
protected $routeMiddleware = [
        'auth'          => \Illuminate\Auth\Middleware\Authenticate::class,
        'auth.basic'    => \Illuminate\Auth\Middleware\AuthenticateWithBasicAuth::class,
        'bindings'      => \Illuminate\Routing\Middleware\SubstituteBindings::class,
        'cache.headers' => \Illuminate\Http\Middleware\SetCacheHeaders::class,
        'can'           => \Illuminate\Auth\Middleware\Authorize::class,
        'guest'         => \App\Http\Middleware\RedirectIfAuthenticated::class,
        'signed'        => \Illuminate\Routing\Middleware\ValidateSignature::class,
        'throttle'      => \Illuminate\Routing\Middleware\ThrottleRequests::class,
        'cors'          => \App\Http\Middleware\Cors::class, // added
    ];
```
4.Set the middleware to routes
```
Route::middleware(['cors'])->group(function () {
    Route::post('/hogehoge', 'Controller@hogehoge');
});
```
Placeholder title
Tags: dohackathon
Published: 2021-01-03 15:47:01

## What I built

### Category Submission: 


### App Link


### Screenshots


### Description
 

### Link to Source Code

### Permissive License


## Background
(What made you decide to build this particular app? What inspired you?)

### How I built it 
(How did you utilize DigitalOcean’s App Platform? Did you learn something new along the way? Pick up a new skill?)


### Additional Resources/Info
Day 3 Challenge
Tags: javascript, challenge, webdev, 365daysofcoding
Published: 2021-01-03 15:44:19

Day 3! Today we are going to dive into simple ciphers with a Caesar cipher more specifically ROT13.

The Problem
Create a function that takes a string and returns the string with each letter substituted with the 13th letter after it in the alphabet (ROT13). If there are numbers or special characters included in the string, they should be returned as they are. 

Examples:
```javascript
    rot13("Hello Dev World is awesome")   // Uryyb Qri Jbeyq vf njrfbzr
    rot13("my dogs are the cutest dogs in the world")   // zl qbtf ner gur phgrfg qbtf va gur jbeyq
    rot13("abcdefghijklmnopqrstuvwxyz")  // nopqrstuvwxyzabcdefghijklm
    rot13("#365DaysOfCoding") // #365QnlfBsPbqvat
```
Spring Boot Pagination and Filter Example
Tags: springboot, pagination, filter
Published: 2021-01-03 15:39:06

# Spring Boot Pagination and Sorting Example

- Tutorial Link: https://loizenai.com/spring-boot-pagination-filter/

## Youtube - SpringBoot Pagination and Filter Example

https://youtu.be/5fNK5lrj-X0

![Spring Boot Pagination and Sorting Example](https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Pagination-Sorting-Examples-Filtering-with-MySQL-database-using-Spring-JPA.png)

When we have a large dataset and we want to present it to the user in smaller chunks, pagination and sorting is often helpful solution. So in the tutorial, I introduce how to build “Spring Boot Pagination and Sorting Example” use Spring JPA APIs of PagingAndSortingRepository to do the task with SpringBoot project example.

## Goal – Spring Boot Pagination and Sorting Example

![Spring Boot Pagination and Sorting Example](https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-tutorial-Pagination-and-Sorting-Examples.png)

– Paging Request:

![Paging request](https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Paging-Request-Examples-with-page0-size5.png)

– Pagination and Sorting request:

![SpringBoot Pagination and Sorting Request Examples with page=0, size=5](https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Pagination-and-Sorting-Request-Examples-with-page0-size5.png)

## PagingAndSorting Repository

## Related posts - SpringBoot Pagination and Filter Example

- [Ajax Pagination Filtering and Sorting with SpringBoot RestAPI Example](https://loizenai.com/jquery-ajax-pagination-filtering-sorting-tutorial-bootstrap-table-springboot-restapis-examples/)
- [Angular CRUD Application with SpringBoot and MySQL](https://loizenai.com/angular-crud-application-with-springboot-and-mysql-postgresql-restapis-fullstack-angular-httpclient-post-get-put-delete/)
- [Spring Boot Security JWT Authentication Example](https://loizenai.com/spring-boot-security-jwt-authentication-example-mysql-postgresql-spring-jpa-restapis/)
- [Angular 10 + Nodejs JWT Token Based Authentication with MySQL Example](https://loizenai.com/angular-10-nodejs-jwt-authentication-mysql-examples-tutorials/)
8. Database
Tags: aws, database
Published: 2021-01-03 15:36:28

After setting up the visitor counter for my [website](https://www.komlalebu.com), it was time for setting up the backend database for storing the count data. I chose AWS `DynamoDB` for this purpose. It is a NoSQL database that works primarily on key value pair, requires only a primary key and doesn’t require a schema to create a table. Sounds magical.

![Alt text](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fnerdist.com%2Fwp-content%2Fuploads%2F2017%2F09%2FFroopy-Land.gif&f=1&nofb=1)

#[DynamoDB](https://aws.amazon.com/dynamodb/)![Alt Text](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fupload.wikimedia.org%2Fwikipedia%2Fcommons%2Fthumb%2Ff%2Ffd%2FDynamoDB.png%2F220px-DynamoDB.png&f=1&nofb=1)
I selected `create table` from the DynamoDB console.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/8gu10xzqxwo6a3jkltai.PNG)

Then I named the table as `komlalebuTable` and mention the primary key as `id` with data type as `string`.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/kypjp3cpc493e1w8vnrk.PNG)

Also I unchecked the `default` setting of the table and selected `on-demand` pricing which makes it practically free for my use case.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/hq6ao996zgzd0vv5d5rn.PNG)

This table stores the visitor count of my website in near realtime as we can see below using AWS (API Gateway + Lambda) on page load, which we will explore later sections**. 

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/hyg2hsextd4s4ro6jutj.PNG)

The `like` button appends the string 'YES' to the count value and adds a record.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/pn8kad1vff7549o4mhy1.PNG)

The `dislike` button appends the string 'NO' to the count value and adds a record.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/r50u8et0b6brqovczkls.PNG)

# [AWS::Serverless::SimpleTable](https://docs.aws.amazon.com/serverless-application-model/latest/developerguide/sam-resource-simpletable.html)

However this was the manual method of creating a table from AWS console, the final version of the source code is using a table that is created using SAM template ([Read more](https://dev.to/jicoing/12-infrastructure-as-code-1df4)). With the table name as `komlalebuTable`. 

[template.yaml](https://github.com/jicoing/git-komlalebu-sam/blob/master/template.yaml)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/qq9f27th79hzzyx3orl4.PNG)

         komlalebuTable:
            Type: AWS::Serverless::SimpleTable
            Properties:
              PrimaryKey:
                 Name: id
                 Type: String
             TableName: komlalebuTable

And the backend database was setup.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/0vobgcej8t0ytnl5d9l4.gif)
Golang basic: slice 
Tags: go, tutorial
Published: 2021-01-03 15:26:18

Array is make you think is there any way to make size of array dynamic? and you ask to god, yeah there is a slice. Slice as same as array, a variable has more than 1 values.
Let's we write our code.
## Declare Slice
Declare slice is simple, how do that? 
``` golang
package main

import "fmt"

func main() {
    var students []string
    // OR
    students := []string{}
}
```
You don't need to include number in ``[]`` it will make a dynamic size.
## Assign data to slice
How to assign data to slice? the key is same as array, look at code below.
``` golang
package main

import "fmt"

func main() {
    students := []string{"Linda","Lingling","Wang"}

    fmt.Println(students)
}
```
## Access data slice
You can use ``[index]`` to access the value.
``` golang
package main

import "fmt"

func main() {
    students := []string{"Linda","Lingling","Wang"}
    // Access single data
    fmt.Println(students[1])
}
```
At the code, we get ``1`` as index, so if we mapped the value
0 => Linda
1 => Lingling
2 => Wang
it will return "lingling". But I want to get "lingling" and "Wang" how to do that?
``` golang
package main

import "fmt"

func main() {
    students := []string{"Linda","Lingling","Wang"}
    
    // Access multiple data
    fmt.Println(students[1:3])
}

```
you can use format ``slices[indexfrom:end]`` to access multiple data
## Change single data slice
so how to change that data?
``` golang
package main

import "fmt"

func main() {
    students := []string{"Linda","Lingling","Wang"}
    
    // Change data
    students[1] = "Longda"
    
    // Access data
    fmt.Println(students[1])
}
```
## Add data at the end of slice
So now we want to add student, we can use ``append`` in order to add.
``` golang
package main

import "fmt"

func main() {
    students := []string{"Linda","Lingling","Wang"}

    students = append(students, "Boru")

    fmt.Println(students)
}
```
so format of ``append``` is ``append(slice, value)``
## Conclusion
We have knew about slice and how to write slice in golang, there is many ways to roman city. If you think the data is difficult to predict how size of array max, slice is the best choice for you, even the author of golang, suggest to use slice than array.
Títulos em HTML
Tags: html, braziliandevs, beginners, webdev
Published: 2021-01-03 15:23:32

Olá pessoal, hoje vamos falar sobre títulos em **HTML**. Para adicionar títulos no **HTML**, utiliza-se o `h` e o nível, temos 6 níveis para os títulos.

> Geralmente _websites_ tem apenas um título nível 1 (h1) por página _web_.

Título nível 1:

```html
<h1>título 1</h1>
```

Título nível 2:

```html
<h2>título 2</h2>
```

Título nível 3:

```html
<h3>título 3</h3>
```

Título nível 4:

```html
<h4>título 4</h4>
```

Título nível 5:

```html
<h5>título 5</h5>
```

Título nível 6:

```html
<h6>título 6</h6>
```

{% jsfiddle https://jsfiddle.net/franciscochaves/sxzvm856/1 result,html %}
Day 10 of 100DaysOfCode: Object Inheritance
Tags: beginners, codenewbie, 100daysofcode, python
Published: 2021-01-03 15:14:53

Today is my 10th day of #100daysofcode. I learned more properties of CSS like applied visual Design challenges, Create visual balance using the text-align property, adjusting the width of an element using the width property, adjusting the height of an element using the height property, making use of (strong, U, em , S, hr..) tag from [Freecodecamp](https://www.freecodecamp.org/learn/responsive-web-design/applied-visual-design/create-visual-balance-using-the-text-align-property). I also learned about database on python[coursera](https://www.coursera.org/learn/python-databases/lecture/61E5d/15-4-designing-a-data-model)
 
I also tried to write code in `class` on python.

# Object Inheritance
Here we have two template. Child template is related to the parent template. Here we add capabilities or extend the capabilities of parent. In the code FootballFan is class which extend the PartyAnimal.It has all the property of PartyAnimal. There are two variables `x` and `name` these are attributes also. And we have a constructor that has the name parameter.

After that we have a new calss FootballFan inside the parenthesis we have a name of different class. FootballFan is everything PartyAnimal is plus point we define here. So FootballFan has x instance variable, point inastance variable and name instance variable. And we give object to the PartyAnimal and FootballFan.
```python
class PartyAnimal():
    x = 0
    name = ''
    def __init__(self,z):
        self.name = z
        print(self.name,'constructed')
    def party(self):
        self.x = self.x + 1
        print(self.name,'party count',self.x)
        
class FootballFan(PartyAnimal):
    points = 0
    def touchdown(self):
        self.points = self.points + 7
        self.party()
        print(self.name,'points',self.points)

s = PartyAnimal('sally')
s.party()
 
j = FootballFan('jim')
j.party()
j.touchdown()

``` 
<blockquote class="twitter-tweet"><p lang="en" dir="ltr">Day 10 of <a href="https://twitter.com/hashtag/100daysofcode?src=hash&amp;ref_src=twsrc%5Etfw">#100daysofcode</a> and <a href="https://twitter.com/hashtag/Python?src=hash&amp;ref_src=twsrc%5Etfw">#Python</a> <br>* More about database on python<br>* More about CSS properties like applied visual challenges, create a visual balance using the text align property, adjusting the (width, height) of an element using the width property<br>* Object inheritance <a href="https://t.co/pykn6bN4zU">pic.twitter.com/pykn6bN4zU</a></p>&mdash; Durga Pokharel (@mathdurga) <a href="https://twitter.com/mathdurga/status/1345738710248169473?ref_src=twsrc%5Etfw">January 3, 2021</a></blockquote> <script async src="https://platform.twitter.com/widgets.js" charset="utf-8"></script>