teleren/devto huggingface dataset:
GCP Essentials :: Course Introduction
Tags: cloud, googlecloud, gcp
Published: 2020-11-24 09:55:47

Hello everyone

This is a complete series on Google Cloud Platform Essentials. In this series you will learn the fundamentals of GCP and you can use this knowledge to create your own cloud infrastructure for your SaaS application or an organisation.

This series is specially designed for IT professionals who are tasked with building and managing solutions in the cloud. But later own in this series, I will pivot towards developers also who are interested in exploring and hosting their applications on the google cloud platform.

To begin with, you should be familiar with IT concepts such as operating systems and networks and some basics of computer science. 

If you have any questions regarding this series, you can either comment down your problems (recommended) or you can reach me out personally at following platforms

+ Email: tbhaxor@gmail.com
+ Twitter: [@tbhaxor](https://twitter.com/tbhaxor)
+ LinkedIn: [@gurkirat--singh](https://www.linkedin.com/in/gurkirat--singh)
+ Instagram: [@_tbhaxor_](https://instagram.com/_tbhaxor_)

So, let's ace the google cloud platform together.
Welcome to Strapi Academy 
Published: 2020-11-24 09:52:30

---
title: Welcome to Strapi Academy 
published: True 
description: 
tags: 
//cover_image: https://direct_url_to_image.jpg
---
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/jh29sudvuqyihb3imhje.png)
We are proud to announce the launch of the **Strapi Academy**, a great resource for the community to **learn Strapi for free!** We created this academy to help our users develop their Strapi expertise and make the most out of it through advanced customization and plugins!

Throughout a series of video tutorials, documentation, and quizzes, our **free Community Edition course** will allow you to master the fundamentals of Strapi. From installing a fresh Strapi application to creating your data structure managing your content and settings from the admin panel, this course walks you through all the steps and best practices to build a successful project with Strapi.

The course also highlights our main features such as the content-types builder, [media library](/blog/beta-20-media-library), components & [dynamic zones](/blog/creating-strapi-dynamic-zone-in-nuxtjs-app), webhooks, and the [Role-Based Access Control](/blog/announcing-3.1-role-based-access-control). Additionally, you’ll find resources about advanced customization as well as plug-in management and deployment.

You can enroll in the course using [this link](https://academy.strapi.io/sign_in). 

![Welcome to Strapi Academy](https://media.giphy.com/media/14aVj10D1TwHu0/giphy.gif)

Last but not least, if you are interested in an **instructor-lead course**, feel free to [reach out](https://strapi.io/contact) to us and we’ll share some more information. 

And that’s it :) 

We look forward to seeing you progress through the course and getting the certification!
Data Factory - Azure AD Authentication for SQL Database
Tags: azure, datafactory, azureactivedirectory, sqldatabase
Published: 2020-11-24 09:46:28


To use Azure identity authentication, follow these steps:
1. **Provision an Azure Active Directory administrator for your 
   server on the Azure portal**, if not already done : This is an 
   important step as for adding Azure data factory's managed 
   identity as a user in SQL, an Azure AD account having **at 
   least "ALTER ANY USER"** permission is required.

    **If 2nd step is performed using a SQL Authenticated account, 
    the SQL command will return error.**

2. **Create contained database users for the Azure Data Factory 
   managed identity**.Connect to the database from or to which 
    you want to copy data by using tools like SQL Server 
    Management Studio, with an Azure AD identity that has at least 
    ALTER ANY USER permission. Run the following T-SQL

      *CREATE USER [your Data Factory name] FROM EXTERNAL PROVIDER*
   
3. Grant the Data Factory managed identity needed permissions as 
   you normally do for SQL users and others. Run the following 
   code 
   *ALTER ROLE [role name] ADD MEMBER [your Data Factory name]*

   *Refer this [link](https://www.sqlshack.com/working-azure-active-directory-azure-sql-database/) for demo.*
How to connect to Google Firebase Realtime database from your web project?
Tags: firebase, cloud, javascript, html
Published: 2020-11-24 09:41:18


If you have a start up idea and have little money to invest for the product, using Google Firebase gives you a great head start. It has a generous free limit in their starter plan. 
One feature is the Google Realtime database.
It is a NoSQL database and helps you perform database operations from your javascript code.

Quite easy to connect to it from your javascript.
Involves just three steps:
1) Create a firebase project in the console
2) Create a realtime database in the console.
3) Copy the configuration details from the console into your javascript.

You are good to go!

Here is a demo :

https://fullstackdeveloper.guru/2020/11/24/how-to-connect-to-google-firebase-realtime-database-from-your-javascript-project/
A super weird case with SVG performance
Tags: html, css, performance
Published: 2020-11-24 09:40:32

(Image from By W3C, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=89557878)

I have this super weird case where I need to display a big tree of text with svg icons. For some reason on the latest Chrome it took almost 30seconds just to render the whole tree (insane). I took a look at Webflow which has a similar tree and there seems to be no issue at all. 

My tree was rendered by Vuejs 2.x, I'm not sure if there is anything to do with that, I could not figure out why. The only thing that I could think of, is that inside the Vuejs template I use something like this to render the svg:

```
<svg>
  <use xlink:href="#general_small--arrow_2_down"></use>
</svg>
```

(The svg sprite is printed on the top of the body tag with display none)

In any case, I put in this temporary fix which manages to bring down the rendering from 30s to 2s:

1. Add a class to hide (display:none) all svg inside the tree every time I need to re-render the tree
2. Set time out (something like 200ms)
3. Remove the class

And now all the SVG icons are shown nicely, instantly.

Edit 1:

So I think I found the issue. The inline sprite svg file that I was including was huge (hundreds of svg files), and it seems like that slows down the lookup drastically (even though the file was already included inline in html). By splitting the file into smaller files I was able to speed up the rendering multiple times.
Industry 4.0+ | IOT, ML & BLOCKCHAIN 
Tags: go, discuss, opensource, webdev
Published: 2020-11-24 09:35:15

Hi, 

Industry 4.0 utilizes best of resources but what if it becomes secure using blockchain? 

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

This is just an architecture I thought about but I'm looking for your feedback on this so that I can move it forward for some concrete structure 

Thanks!
Terraform for Loop
Tags: terraform, tutorial
Published: 2020-11-24 09:34:53

Terraform 0.12 introduces a new construct called a for expression, which allows the construction of a list or map by transforming and filtering elements in another list or map. The example below shows this in use:https://youtu.be/q2ddojN9h8o

Terraform Doc: https://www.hashicorp.com/blog/hashicorp-terraform-0-12-preview-for-and-for-each


{% youtube q2ddojN9h8o %}
Formulas to Sum the Values by a Week Number in Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2020-11-24 09:29:51

---
title: Formulas to Sum the Values by a Week Number in Excel Office 365!!
published: true
date: 2020-11-24 09:26:06 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-sum-the-values-by-a-week-number-in-excel-office-365/
---

In this tutorial, we will explain the **formulas used to sum the values by week number in Excel Office 365**. 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)

[![Formulas to sum by week numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-sum-by-week-numbers.png)](https://geekexcel.com/formulas-to-sum-the-values-by-a-week-number-in-excel-office-365/formulas-to-sum-by-week-numbers/#main)<figcaption id="caption-attachment-17996">Formulas to sum by week numbers</figcaption>
## General Formula:

- Use the below formula to sum the values by a week number in Excel.

**=SUMIFS(sum range, week range, week)**

## Syntax Explanations:

- **SUMIFS** – In Excel, this function helps to sum the cells that meet multiple criteria.
- **Week range** – It represents the week number of the given dates.
- **Sum range** – It is the input values from your workbook.
- **Week** – It is the criteria that help to sum the values.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- In the below image, we are going to see how to sum the values by week numbers.
- Refer to the below example.
- First, we will give the input values in **Column A** , **Column C** , and **Column D**.
- After that, happy the given formula in the formula bar section.
- Finally, it shows the result in **Cell G3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-63.png)<figcaption id="caption-attachment-17998">Example</figcaption>

## Closure:

This article gives you complete information about the **formulas used to sum the values by week numbers in Excel Office 365**. Hope that this article is useful to you. Don’t forget to share your valuable **feedback** in the below section. Thank you so much for Reading!! Keep learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Formulas for Counting the Cells Greater than a Given Values in Excel!!](https://geekexcel.com/formulas-for-counting-the-cells-greater-than-a-given-values-in-excel/)**
- **[Formulas to Sum Bold Values or Numbers Only ~ Simple Method!!](https://geekexcel.com/formulas-to-sum-bold-values-or-numbers-only-simple-method/)**
- **[Excel Formulas to Count Cells that do not contain Errors!!](https://geekexcel.com/excel-formulas-to-count-cells-that-do-not-contain-errors/)**
- [**Excel Formulas to Count Visible Rows in a Range!!**](https://geekexcel.com/excel-formulas-to-count-visible-rows-in-a-range/)
JAVA: Basics
Tags: java, programming
Published: 2020-11-24 09:25:59

Q1. what is java?
Q2. Advantages?
Q3. Disadvantages?

**What is Java?**
-in simple terms, it is a programming language.
-originally developed by James Gosling at Sun Microsystems in 1995
-it can be used by 2 types of people.
-it is an Object-Oriented Programming Language.
-platform-independent i.e. OS(operating system) friendly such as -windows, mac etc. OR it follows WORA protocol i.e. Write Once, Run Anywhere.
-to run any java program you need 3 basic tools
1. Operating System
2. JDK
3. Editor/IDE

1. Developers:-building or developing the applications
2. Testers:-test the application by writing test automation code

-it can be categorized into 2 types
1. core java-(developer, tester)
2. advanced java(developer, not mandatory for testers)

-IDE(Integrated Development Environment) is majorly used to build applications such as IntelliJ, Eclipse IDE etc.

**Advantages?**
1. Object-Oriented- everything is an object thus it can be easily extended
2. Platform Independent- OS/platform friendly, byte code is distributed over the web and interpreted by the JVM(Java Virtual Machine) on executer's platform.
3. Simple- understanding of the basics of java such as OOP Java can help one tap into advanced topics.
4. Secure- authentication techniques are based on public-key encryption, protection from virus and tampering
5. Robust- compile-time error checking and runtime checking
6. Multithreaded- run multiple tasks simultaneously which allows the developers to construct interactive applications that can run smoothly
7. High Performance- use of JIT(Just In Time) compiler improve performance
8. Distributed- able to access files by calling the methods from any machine on the internet

**Disadvantages?**
1. Performance- take much longer time to run compared to C/C++
2. Memory- java Programs run on top of JVM. Thus it consumes more memory
3. Cost- hardware cost increases since the memory and processing requirement is higher
4. Garbage Collection- programmer does not have any control over garbage collection since it does not provide functions like "delete()" etc. But one can call the "System. gc( )" method explicitly in order to inform the JVM to run the garbage collector.
PDOException::SQLSTATE[42000]: Incorrect table definition; there can be only one auto column and it must be defined as a key
Published: 2020-11-24 09:25:43

####Syntax error or access violation on database migration


This likely occurs when you are trying to migrate a pivot table in Laravel in which there is an incorrect table definition, the way to solve it by changing the data type of the foreign keys as shown with the code below:

#####User Table
```php
    Schema::create('users', function (Blueprint $table) {
            $table->id()->unsigned();
            $table->string()->name();
            $table->timestamps();
        });
```
#####Role Table
```php
    Schema::create('roles', function (Blueprint $table) {
            $table->id()->unsigned();
            $table->string()->name();
            $table->timestamps();
        });
```

#####Pivot Table
```php 
    Schema::create('users_roles', function (Blueprint $table) {
            $table->biginteger('user_id')->unsigned();
            $table->biginteger('role_id')->unsigned();
        });

        Schema::table('users_roles', function (Blueprint $table) {
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
            $table->foreign('role_id')->references('id')->on('roles')->onDelete('cascade');
        });
```
Project 16 of 100 - React Quote Generator
Tags: javascript, react, css, 100daysofcode
Published: 2020-11-24 09:23:03

*Hey! I'm on a mission to make 100 React.js projects in 100 days starting October 31, 2020 and ending February 7th, 2021. Please follow my dev.to profile or my [twitter](www.twitter.com/jwhubert91) for updates and feel free to reach out if you have questions. Thanks for your support!*

Link to today's deployed app: [link](https://100-react-projects-day-16-quote-generator.netlify.app/)
Link to the repo: [github](https://github.com/jwhubert91/100daysofreact/tree/master/day-16-quote-generator)

I have finally taken on Bob Ziroll's advanced React bootcamp on Scrimba.com and in the first section we were introduced to `React.Fragment`, default props, and prop types. This project made use of all three concepts, plus the fetch API and the [randomcolor](https://www.npmjs.com/package/randomcolor) npm package.

So how can we make the above 3 concepts into an exciting project? I decided to create an inspiring quote generator application based on a [previous blog post](https://dev.to/asaoluelijah/understanding-fetch-2-building-a-random-quote-generator-app-25nj).

##React.Fragment
The new-ish `React.Fragment` component is a solution to the issue of all React components needing a parent component. It solves the problem of a DOM tree with way too many useless div elements. I used this simple tool to create the Header for this application, which was simply an H2 header and a p element for my name.

##Default Props
Default Props are another cool new-ish addition to React that allows you to inject a value into props from within the component as default if no props are passed down to it. 

This is especially useful if you are using PropTypes and have a required prop. I also found it useful for rendering information before the user interacts with the application without having to mess with componentDidMount or hard-coding stuff into the parent state.

##PropTypes
As Bob Ziroll says, if you're not using Typescript then PropTypes are basically a must-have. They provide a layer of validation during development that shows an error in the console if the wrong type of data is passed to a component.

This isn't native yet so you actually have to install the npm package but it is well worth it to have just that extra layer of caution to make sure you're displaying the right info.

PS - I love html movie backgrounds. They make websites feel so much more modern and inviting. If you want a quick and easy way to do this, whether in vanilla web-dev or with React, I did so using a few hints from this w3schools article: https://www.w3schools.com/howto/howto_css_fullscreen_video.asp

Enjoy!
Python Là Gì- Những Ứng Dụng Của Python Phổ Biến Nhất 2020
Published: 2020-11-24 09:22:24

Python là gì ,chúng có những ứng dụng như thế nào.Hãy cùng chúng tôi tìm hiểu về ứng dụng của Python ngay trong phần chia sẻ dưới đây. Xem chi tiết tại: http://laptrinhvacongnghe.com/ung-dung-cua-python/
Formulas to Sum the Values by Week in Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2020-11-24 09:29:06

---
title: Formulas to Sum the Values by Week in Excel Office 365!!
published: true
date: 2020-11-24 09:21:00 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-sum-the-values-by-week-in-excel-office-365/
---

Here we will guide you to learn the simple **formulas used to sum the values by a week in Excel Office 365**.  Let’s get started!! 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)

[![Formulas to sum by a week](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-sum-by-a-week.png)](https://geekexcel.com/formulas-to-sum-the-values-by-week-in-excel-office-365/formulas-to-sum-by-a-week/#main)<figcaption id="caption-attachment-17982">Formulas to sum by a week</figcaption>
## General Formula:

- To sum the values by a week in Excel, use the below formula.

**=SUMIFS(value,date,”>=”&A1,date,”<“&A1+7)**

## Syntax Explanations:

- **SUMIFS** – In Excel, this function helps to sum the cells that meet multiple criteria.
- **Date** – It represents the input dates that are given in the worksheet.
- **Value** – It is the input values.
- **A1 (Criteria)**– It is the condition that helps to sum the values.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- Now, we are going to see how to sum the values by a  week.
- Refer to the below Example.
- First, we will give the input values in **Column B** and **Column C**.
- Then, enter the given formula in the selected area.
- Finally, we can get the result in the Selected **Cell F3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example1.png)<figcaption id="caption-attachment-17981">Example</figcaption>

## Summary:

From this article, you can get some clarification on the **formulas used to sum the values by a week in Excel Office 365**. Hope that this article is useful to you. If you have any **suggestions,** don’t forget to share it with us. Thank you so much for Reading!! Keep learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas for Counting Occurrences in the entire workbook!!](https://geekexcel.com/excel-formulas-for-counting-occurrences-in-the-entire-workbook/)**
- **[Formulas to Count Unique Text Values with Criteria in Excel!!](https://geekexcel.com/formulas-to-count-unique-text-values-with-criteria-in-excel/)**
- **[Formulas to Count Unique Text Values in a Range in Excel Office 365!!](https://geekexcel.com/formulas-to-count-unique-text-values-in-a-range-in-excel-office-365/)**
- [**Excel Formulas To Count Unique Values In a Column!!**](https://geekexcel.com/excel-formulas-to-count-unique-values-in-a-column/)
ครั้งแรกกับ PostgreSQL (Thai Sorting)
Tags: debian, thaisorting, docker, postgres
Published: 2020-11-24 09:53:13

---
title: ครั้งแรกกับ PostgreSQL (Thai Sorting)
published: true
date: 2020-11-24 09:16:56 UTC
tags: debian,thaisorting,docker,postgresql
canonical_url: 
---

เพิ่งได้ลอง PostgreSQL ครั้งแรกเลยเล่นเรียงลำดับภาษาไทยดู ไม่แน่ใจว่าเข้าใจถูกไหมใครมีความรู้แนะนำด้วยนะครับ

![](https://cdn-images-1.medium.com/max/827/1*AB8yy3hRicMZsB4AwLH4dA.png)

### สภาพแวดล้อม

#### Postgre docker image 13

[postgres - Docker Hub](https://hub.docker.com/_/postgres)

### แบบแรก

start container แบบไม่ปรับแต่งอะไรเลย

#### COLLATE SUPPORT

จะมี th-TH-x-icu มาให้โดยปริยาย

![](https://cdn-images-1.medium.com/max/1024/1*9PurGmzP9kBWYJdGa1wKDg.png)

#### สร้าง Table

```
CREATE TABLE t1 (
  id SERIAL PRIMARY KEY,
  st VARCHAR(255)
);
```

#### Insert ข้อมูล

```
INSERT
   INTO t1(st) 
   VALUES ('เฮ'),('โก'),('กาง'),('ขำ'),('๘'),('ฮา'),('กุม'),('แรง'),('A'),('Z'),('8'),('1'),('๑');
```

#### ลอง Order แบบใช้ค่าปริยาย

![](https://cdn-images-1.medium.com/max/480/1*DVVr02eDqZGeL38AaYCFDA.png)

ลอง Order โดยระบุ COLLATE th-TH-x-icu

![](https://cdn-images-1.medium.com/max/697/1*4sDa2hRqOw53_EPtIAKKWg.png)

จะเห็นความแตกต่างคือ ลำดับการเรียงช่วงภาษาอังกฤษกับภาษาไทยต่างกัน ICU จะเอาภาษาไทยขึ้นก่อนส่วนค่าปริยายจะเอาภาษาอังกฤษขึ้นก่อน

### แบบที่สอง

ผมเลยสงสัยว่าถ้าเรากำหนด locale ของระบบจะมีความแตกต่างไหม ?

สร้าง Image ใหม่ โดยเพิ่ม th\_TH.UTF-8 ให้กับระบบ

![](https://cdn-images-1.medium.com/max/1024/1*Xvn3xwZJ1xzw1tBIvvX5LA.png)

คราวนี้ COLLATE SUPPORT จะมี th\_TH เพิ่มขึ้นมา

ลองสร้าง table และ Order เปรียบเทียบกัน

![](https://cdn-images-1.medium.com/max/563/1*IWNHR35kZVLmAS9KQylqNw.png)<figcaption>COLLATE = C</figcaption>

![](https://cdn-images-1.medium.com/max/613/1*Mp-UZf2_b2kOVxLS8Ab_Rw.png)<figcaption>COLLATE =e n_US</figcaption>

![](https://cdn-images-1.medium.com/max/1024/1*5xfIysE9Qc621IDXNxuEaQ.png)<figcaption>COLLATE ICU vs th_TH</figcaption>

ถ้าดูตามผลที่ได้สรุปว่าถึงจะมี locale th\_TH.UTF-8 หรือไม่การเรียงลำดับก็ไม่ต่างกับ UTF-8 ปกติแต่ Thai ICU จะต่างออกไปสำหรับภาษาไทยผสมกับภาษาอังกฤษ
Frontend Là Gì- Những Kỹ Năng Để Làm Frontend Developer
Published: 2020-11-24 09:13:52

Chắc hẳn với các lập trình viên thì không còn quá xa  lạ với  khái niệm Frontend là gì? thì hãy tham khảo bài viết sau đây để làm sáng tỏ.. Xem chi tiết tại: https://blog.itnavi.com.vn/frontend-la-gi/
How I can extract words from strings using regular expressions?
Tags: help, javascript
Published: 2020-11-24 09:11:43

---
title: How I can extract words from strings using regular expressions?
published: true
tags: help, javascript
---

I have searched on the internet but I don't get any solution. I just confused.

I have this string

`("type": "Person" AND ("specialFields.email": "prathameshmore@gmail.com" OR "specialFields.address": "Jaysingpur"))`

How can I extract data from like this

```
[
  '(',
  '"type": "Person"',
  'AND',
  '(',
  '"specialFields.email": "prathameshmore@gmail"',
  'OR',
  '"specialFields.address": "Jaysingpur"',
  ')',
  ')'
]
```

Please anyone can help with it.