teleren/devto huggingface dataset:
what is the difference between char and varchar?
Tags: sql, char, varchar, difference
Published: 2021-06-15 18:46:30

In a SQL language, the datatype of a column simply means what type of value the column can hold i.e integers, char, long and etc. In that, there are two data types that appear to be the same but have key differences that we will discuss here.

## CHAR DATATYPE ##
1. It stores character string type of data.
2. It has a fixed length.
3. If the length is less than what is specified, then it is padded with extra blank spaces.
4. It leads to memory wastage.


**Example: Consider there is a Table Employee with column id and name. name is of the data type char(5) with size 5. So, If you insert the name  ‘Hi’ Now, the length of String is less than the size i.e 5 so, it is padded with extra blank spaces.
Note: This datatype should be used when the values in a column are of the same length.**
 
## VARCHAR DATATYPE ##
1. By the name itself, we can understand i.e variable.
2. It also stores character string type of data.
3. It has a variable length.
4. If the length is less than what is specified, then it will store as it is without padding.
5. It saves memory.

**Example: Consider the same example, there is a Table Employee with column id and name. name is of the data type char(5) with size 5. So, If you insert the name  ‘Hi’ Now, the length of the string is less than the size i.e 5 so now, it won’t do the padding of extra blank spaces.
Note: This datatype should be used when the values in a column are of the variable length.**
 
>Important Tip: Performance wise char datatype should get a preference instead of varchar because char takes 1 byte to store each character and varchar takes 1 byte plus extra byte for holding length information.
Thank you for reading this article!!
Data driven game with phaser 3
Tags: gamedev, javascript, angular
Published: 2021-06-15 21:27:56

{% stackoverflow 67992580 %}

well i'm working on an e-learning platform for kids that contain courses and each course contain lessons and some games games will be programmed in phaser 3 so the admin in the dashboard will have a form to add new course (add the lesson which is a video and also a link to the phaser game since the admin is not a developer so i wanted to transform my phaser game to a link or something like that ) my question is how to get a game set up to use data from json objects from a URL [sort of Data-driven game ] ps: to develop this platform i'm using spring boot and angular
Day 388 : What I'd Rather
Tags: hiphop, code, coding, lifelongdev
Published: 2021-06-15 21:25:43

_liner notes_:
- Professional : Pretty chill day. Had a couple of meetings. Dove into some code and documentation and found a thing I've been looking for. Integrated it into my demo application and it worked. Cool. Going to create a code snippet and add it to the documentation site.

- Personal : Last night, I got the tutorial part working on the dashboard. So now, I can add a URL to the tutorial, click a button to get the metadata and then add it to the database. I can look at add submitted tutorials and do the same thing. Plus I can delete tutorials. Got a bunch of stuff done for adding tutorials on the live site, but didn't finish.

![A river running through a very green canyon in Blyde River Canyon, South Africa](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/op96n790z4vo9iih6zpb.jpg)

Checked on the tracking for my laptop. "It's on its way!" Woohoo! So I wasn't scammed. haha We'll see when I open the box. haha Tonight, I want to get the tutorial section on the live page done and start on the HACO portion. After that, the work session should be pretty much good to go. Still haven't watched the first episode of "Loki". haha. You can see what I'd rather do with my free time. haha

Have a great night!

peace piece
Dwane / conshus
https://dwane.io / https://HIPHOPandCODE.com
{% youtube xnP8h_9gIn0 %}
Beware of Fraudulent POS ~cybersafety
Tags: cybersecurity, security
Published: 2021-06-15 21:09:22

so dear friends, 
how has your day been! In times past on my podcast, I've always shared the experiences of others who have been victims of cybercrime. 
Well, today is quite different. Today I will be sharing my own story. Yes, my story if how I was swindled of some hard earned cash and I'd like you all to tell me yours too! let's share and help others avoid the pit falls. more especially, let's learn from each other.
so on this faithful day, I decided to visit the high court at Ikeja. many of us are familiar with this place if you are in Lagos Nigeria. 
I went to process an affidavit. after the process I decided to withdraw from the nearest POS outlet to pay for the services rendered. Just about then, the lady in charge brought out a phony POS machine(see pics below). I was skeptical about it as it looked like an android phone. I was sure it was smart and could capture data. However, it was the only POS stall available. so I gave it the benefit of doubt.
after my transaction, I visited one of my transacting banks to transfer some cash to the bank I've just made withdrawal from. All was fine not until a few hours later I got a debit alert of about 34k from my account. Lo and behold when I checked I saw web purchase! So I checked if had erroneously made a purchase. None to be found. Hence, the only logical explanation was that I had fallen victim to information theft. 

Please share any experiences you may have so others can learn.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wsan3k4t5t4umwrezg46.jpg)
{*Easy ways*} to Align Top in Microsoft Excel 2013!
Tags: aligntopinexcel2013, excelbasics, excel, exceltutorials
Published: 2021-06-23 07:28:21

---
title: {*Easy ways*} to Align Top in Microsoft Excel 2013!
published: true
date: 2021-06-15 18:23:36 UTC
tags: AlignTopinExcel2013,ExcelBasics,Excel,ExcelTutorials
canonical_url: https://geekexcel.com/easy-ways-to-align-top-in-microsoft-excel-2013/
---

## Align Top in Excel 2013:

This tutorial will guide you to know how to **Align Top**  **in Microsoft Excel 2013** in simple steps. Let’s get into the **article!!**

## **Clear cut ways to Align Top in Microsoft Excel 2013:**

### Method 1:

- Select the cell and **Go to the menu bar → click the Home menu → Alignment option,** there you can find the **Top Align.**

![Menu](https://geekexcel.com/wp-content/uploads/2020/04/Screenshot_1-24.png)<figcaption id="caption-attachment-5903">Menu</figcaption>

- Now, the text in the selected cell will be **aligned at the top.**

![Top align text](https://geekexcel.com/wp-content/uploads/2020/04/Screenshot_4-23.png)<figcaption id="caption-attachment-5904">Top align text</figcaption>

### Method 2:

- **Right-click** on the cell, the **popup menu** gets opened in that select the **format cells option**.

![Popup menu](https://geekexcel.com/wp-content/uploads/2020/04/Screenshot_2-23.png)<figcaption id="caption-attachment-5905">Popup menu</figcaption>

- The **Format cells dialog box** will appear in that, select the **Alignment tab.**
- Then, you have to choose **“Top”** in the drop-down options of **‘Vertical’ ** and click **OK**.

![Format cells window](https://geekexcel.com/wp-content/uploads/2020/04/Screenshot_3-22.png)<figcaption id="caption-attachment-5906">Format cells window</figcaption>

- The text gets **aligned at the top** in your current Excel sheet.

## Closure:

In this article, we illustrated how to **Top Align in Microsoft Excel 2013 in simple steps**. Clear-cut screenshots will you to top align the text even simpler. Is this article helpful? Don’t forget to share your valuable **queries/feedback** in the below comment section.

Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!

## Related Articles:

- [**Hide a Worksheet in Excel 365**](https://geekexcel.com/how-to-hide-a-worksheet-in-microsoft-excel-365/)
- [**Unhide a Column in Excel 365**](https://geekexcel.com/how-to-unhide-a-column-in-microsoft-excel-365/)
- [**Hide Formula in Excel 365**](https://geekexcel.com/how-to-hide-formula-in-microsoft-excel-365/)
- [**Change Font color in Excel 2013**](https://geekexcel.com/change-font-color-in-excel-2013-in-different-ways/)
- [**Use Format Painter in Excel 2007**](https://geekexcel.com/how-to-use-format-painter-in-microsoft-excel-2007/)
[Dicas do VIM] Copiar, cortar e colar no VIM / NeoVim
Tags: vim, neovim, braziliandevs, copy
Published: 2021-06-15 21:06:25

Para copiar o texto da linha onde está o cursor

```
yy
```

Para recortar o texto da linha onde está o cursor

```
dd
```

Para colar o texto copiado no local onde está o cursor pressione a **tecla p** (p minúsculo)

```
p
```

Caso queira copiar a palavra onde está o cursor, digite

```
yw
```

Para selecionar um trecho do texto com o curso, é preciso entrar no modo visual pressionando a **tecla v** (v minúsculo)

```
v
```

Esse comando seleciona as linhas de um texto.

![modo visual do vim](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/k46wuvue9mfj9nhwxuoz.gif)

Com o texto selecionado, pressione a **tecla y** (y minúsculo) para copiar

```
y
```

Ou a **tecla d** (d minúsculo), caso queira recortar o trecho selecionado

```
d
```

Caso queira selecionar as colunas, pressione **CTRL+v** (tecla Control e tecla v).

Para fazer uma cópia do arquivo aberto, para um novo arquivo, digite

```
:w <novo nome do arquivo>
```

- digite o novo nome para o arquivo sem os sinais **< e >**.

![copiando todo conteúdo do arquivo para um novo](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4b7y94gjmm6nba9dpxia.gif)
Tutorials Hell
Tags: javascript, react, devops
Published: 2021-06-15 21:02:43

*TUTORIALS HELL*
🔥🔥🔥🔥🔥🔥

When it comes to skill acquisition, hands-on experience redefines you and make you stronger than endlessly watching series of videos.
This article will be brief.
Let's consider some key points:
1.  Why do you want to learn a skill?
2.  What problem(s) are you trying to solve?
3.  How to escape from Tutorials Hell?

I will try to discuss on these few points above.

*1.  WHY DO YOU WANT TO LEARN A SKILLL*

Everyone has their reasons for learning a particular skill or profession. Until you know why you want to learn a skill, you would be revolving in circles.
Every project has a start and a finishing point, from:
Conception, 
Planning, 
Designing, 
Executing, 
Testing, 
Production, 
Recycling (optional), 
Disposing. 

I listed the above activities so you understand that every time you spend learning something that doesn't worth your time and doesn't contribute any value to you, the time wasted is irreversible.

*2. WHAT PROBLEM(S) ARE YOU TRYING TO SOLVE*

This is a very personal question that requires objective reasoning. If you don't know what you want to solve, you will be stock in tutorials hell on places like YouTube, Vimeo, Twitch, etc: The reason being that you rather enjoy watching other people display how they have solved a particular problem and give them a Like 👍, than you trying to solve a problem. 

When you know what you want to solve, you will know the places to go for solutions when you hit a dead end. For example, if you want to design a good landing page, you will Google to see other designs that have been done in the past and take from their ideas to build your own. You can only "steal" from other people's ideas to solve a problem and this way you learn faster. 

*3. HOW TO ESCAPE FROM TUTORIALS HELL*

As stated from the beginning of this article, get your hands dirty by building more projects. It must not be a massive project but a small project for a start.

Oftentimes, when we want to start a project it looks as if that's the moment ideas seems to drain away from our minds. Yes, it's very normal.

When you face situations like this, try to figure out the problem by asking some personal questions:

1. "Is it the design tool I don't understand how to use?" Then go and read documentations about how to use such tool.
2.  "Is it because I have not properly drafted out a project plan?" Go and draft a project plan.

_Remember, nobody can solve your problems the way you solve it._

Thank you for reading this article.
I will appreciate if you like and share it.
😁
Using Asciidoc for Arquitecture Decision Records
Tags: javascript, tool, arquitecture
Published: 2021-06-15 20:50:16

---
title: Using Asciidoc for Arquitecture Decision Records
published: true
description: A small tool for using ADRs
tags: javascript, tool, arquitecture
//cover_image: https://direct_url_to_image.jpg
---


 {% github ninjascl/adr-asciidoc %} 


Requires https://nodejs.org/en/ and https://asciidoctor.org/ installed.

---

More information on MADR is available at <https://adr.github.io/madr/>.
General information about architectural decision records is available at <https://adr.github.io/>.
Need 3 brave (or simply kind) volunteers who have problems with API integration
Tags: android, ios, devops
Published: 2021-06-15 20:08:29

Hi guys,
I am a non developer working with a team to help developers integrate with any website and app, when API is 'crap' or doesn't exist.

Want to know your experience and what is the hardest part of it.
10 minutes. 
Simple questions. 
Your honest answers.

You will help me a lot
The 7 Most Popular DEV Posts from the Past Week
Tags: top7
Published: 2021-06-15 19:36:30

---
title: The 7 Most Popular DEV Posts from the Past Week
published: true
description: A round up of the most-read and most-loved contributions from the community this past week.
tags: icymi
cover_image: https://thepracticaldev.s3.amazonaws.com/i/sfwcvweirpf2qka2lg2b.png
---
_Every Tuesday we round up the previous week's top posts based on traffic, engagement, and a hint of editorial curation. The typical week starts on Monday and ends on Sunday, but don't worry, we take into account posts that are published later in the week._ 


## Making your GitHub profile a thing of beauty

@supritha explains how you can improve and prettify your GitHub profile in fantastic detail.

{% link https://dev.to/supritha/how-to-have-an-awesome-github-profile-1969 %}

## Mistakes were made

and that's ok! In this helpful and candid article, @tyaga001 walks us through some of the mistakes they made early on in their career. There's a lot to learn from here. 
 

{% link https://dev.to/tyaga001/mistakes-i-made-in-my-20s-as-a-software-developer-558d %}

##  Give it up for Ash 👏 

Despite having a challenging week, @ash_bergs managed to write a _fantastic_ guide to understanding React hooks. Really glad you're ok despite the car accident and feeling under the weather, Ash!

{% link https://dev.to/ash_bergs/a-quick-guide-to-understanding-react-hooks-4o1 %}

## Out of the darkness and into the light

It's entirely understandable why dark mode is the preferred mode for lots of devs — but let's play devil's advocate for a moment with @sewangco to explore why light mode might actually be a better choice for some (don't @ me!)


{% link https://dev.to/codesphere/should-you-really-be-coding-in-dark-mode-4ng8 %}

## Sightseeing in Frontend Land 

@snickdx is our tour guide in this awesome, clear series on the frontend. In this edition, you'll learn all about state management. Pack your bags!

{% link https://dev.to/snickdx/the-frontend-hitchhikers-guide-state-management-30ji %}


## The 16 circles of "Dev Hell" 

The road to developer hell is paved with legacy code. Thanks for the fright, @wadecodez 😱 

{% link https://dev.to/wadecodez/16-eternal-hells-of-programming-5h5g %}


## Lots of benefits, few major code changes 

What could be better? Sounds like React 18 Alpha is pretty great. Thanks for walking us through it, @cassidoo!

P.S. Catch Cassidy on the next DEV Community [Twitch](twitch.tv/thepracticaldev) stream this Wednesday at 5 PM UTC. Info [here](https://dev.to/listings/events/walkthrough-wednesday-with-cassidy-williams-jb) ✨ 

{% link https://dev.to/cassidoo/react-18-alpha-is-out-now-what-2apj %}


_That's it for our weekly wrap up! Keep an eye on dev.to this week for daily content and discussions...and if you miss anything, we'll be sure to recap it next Tuesday!_
Generics in java
Tags: java, generic
Published: 2021-06-15 19:33:19

######You can have this dish prepared with any type of meat or fish.
######  -Entry on a restaurant menu.
Classes and methods can have *Type parameter* T, and the type parameter may then have any reference type or class type plugged in for the type parameter.

- The class with type parameter is called **Generic class** or **Parameterized class**,
example:

```java
public class Sample<T> {
    private T data;  //T is a parameter for a type

    public Sample(T data) {
        this.data = data;
    }

    public T getData() {
        return data;
    }
   
}
```
- A generic constructor name has no type parameter with angular brackets <T> with it's name, But it can use the type parameter T with it's parameters.
- You can not plug in a primitive type for a type parameter, for example: if we want **instantiate** the generic class Sample with integer type, we would say:
```java
Sample<Integer> sample = new Sample<>(55);
```
- A type parameter cannot be used everywhere a type name can be used. you can not use the type parameter T with ``` new ```operator to create an object.
example: 
 ```java 
T object = new T (); //the first T is legal while the  second is illegal
```
- A generic class definition can have any number of type parameter, example:
```java 
public class Sample2<T1, T2> {

    private T1 data1;
    private T2 data2;
     .
     .
}
```
- A generic class can not be a an exception class, for example the following exception class will generate a compiler error:
```java
public class Sample<T> extends Exception{} //illegal
```
-To use **compareTo** method in your generic class, you need to ensure that the class implements **comparable** interface  and begin with the following definition:
```java
public class Sample <T extends Comparable>
```
and the part ``extends Comparable `` is called **bound** on the type parameter T, and a **bound** may be a class name, for example the following says that **only** descendent classes of *Employee* may be plugged in for T:
```java
public class Sample <T extends Employee>
```
**Generic Methods**
- the generic method can be member of a generic class or nongeneric class.
ex:
```java
public static <T> T getMidPoint(T[] a){
return a[a.length/2];
}
```
Free Tech Story-Telling Workshop
Tags: workshop, video, communication, children
Published: 2021-06-15 19:11:24

## Feel stumped explaining your work to your children?

Do you children (or even your spouse) appear bored when you talk about servers?

Do you wish you had an approach for communicating the intricacies of class-based routing protocols to non-technical people?

Has anyone ever said “Explain it to me like I’m five”? Maybe even an actual five-year-old?

**What if you were empowered to break down complex topics so that your children could understand, and even enjoy it?**

## Miriam Tocino’s LIVE Story-Telling Workshop makes it easy!

Join me, Jonathan Hall, and children’s book author and technology educator Miriam Tocino, for a free, live, interactive story-telling workshop!

We’ll be streaming live on YouTube, on **Wednesday, June 23 at 17:00 (GMT+02:00)**. Click [**Watch Live**](https://youtu.be/mJPWwWkCPTA), then click the Set reminder button to be notified when the event starts.

<a href="https://youtu.be/mJPWwWkCPTA"><img src="https://dev-to-uploads.s3.amazonaws.com/uploads/articles/diou9e4pdwj133f1db06.png"></a>

![Binary World](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/08x59j8gm2gyrqz2i1um.jpg)

## About the workshop

Children are growing up highly surrounded by technology without knowing what’s behind it. How do we spark their curiosity and introduce them to the world of technology to not only use it as consumers but to start seeing themselves as creators?

In this workshop, you’ll get to know Miriam Tocino, writer and illustrator of [Zerus and Ona](https://zerusandona.com/), a 0 and a 1, living inside your computer and sharing their adventures in The Binary World. Along with her, you’ll create a new story from scratch that will inspire your children to learn more about technology and start gaining superpowers.

## About Miriam Tocino

Miriam Tocino is a programming teacher, software developer, and mom of a 4 year-old boy dedicated to making computers more approachable, friendly, and easy to understand. She is the author of [Zerus & Ona](https://zerusandona.com/), a children’s book series to discover the world of technology through illustration and the power of stories.

![Miriam Tocino](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jfexfuzxmmqnpyhixs4r.jpg)

<a href="https://youtu.be/mJPWwWkCPTA"><img src="https://dev-to-uploads.s3.amazonaws.com/uploads/articles/diou9e4pdwj133f1db06.png"></a>
What does it take to gain expertise in the field of Machine Learning ?
Tags: machinelearning
Published: 2021-06-15 19:09:43

---
title: What does it take to gain expertise in the field of Machine Learning ?
published: true
description: 
tags: machineLearning
//cover_image: https://direct_url_to_image.jpg
---

( This is a placeholder for my learnings in the context of MLExpert , updated almost daily, until I complete the course)

### Foundational Knowledge in Machine Learning

#### Supervised Learning
When machine is learning from the provided data, it is supervised, in the sense that, for it to make sense of data, some labeling information of the data is provided to it, so that, it can map labels with the data.
For example: label all images of cats with 'Cat' / label all images of dogs with 'Dog'

#### Unsupervised Learning
In this also, machine is provided with data, but it is not supervised, in the sense, that, there is no hand holding here. Somehow, machine has to figure out grouping of data and has to create cluster of data points having some sort of similarity.
For example: give a stream of tweets from twitter and let the machine try to find patterns from the textual data. It would clusterize the tweets according to the category of topic associated with the tweet. It could be related to sports or tech or politics etc

#### Deep learning
In this also, data is provided to the machine, but the data would not be clearly structured, for example: image data. This is where neural networks are involved, specifically they are set of functions which try to determine pattern from data. There are lot of hidden layers which try to decode the pattern associated with the data.

#### Recommendation Systems
In this, for the end user, something needs to be recommended. For example, in case of ecommerce platform, we need to recommend products which could be potentially bought by the end user. Or, in case of Youtube / NetFlix, we need to recommend videos, which could be potentially watched / viewed by the end user. ( more time you spend on youtube, its an indicator to advertisers that, the audience is engaged with this platform and it makes sense for the advertisers to spend on Youtube. more time you spend on netflix, its an indicator that, Netflix is providing content suited to your taste, so, the end user is maintained with the perpetual subscription. ) So, ultimately, there are bunch of videos/ items to be recommended to user. Recommendation algorithm picks the best video to be shown to the user

#### Ranking
In this, for the end user, some kind of ranking to be done on content which is being recommended to the end user. So, what's the first video, what is the next best video to engage the user, what video after that, so, there is already set of videos which is stored/created. Ranking algorithms picks the best set of videos and ranks them and the videos are recommended in the order of rank of that video.