teleren/devto huggingface dataset:
Clean your git branches local and remote
Tags: git, bash
Published: 2020-11-18 17:52:51

Often after a few months of work I find myself with way too many git branches in my local repos, looking for in the internet how to delete local and remote branches in git, well, I have created a bash function for that, and now I'm goint to share it: 

Add this to your bash profile

```bash
gitrm () { git branch -d $1 && git push origin :$1  }
gitrmf () { git branch -D $1 && git push origin :$1  }
```

Usage:

gitrm fix/fix-this-breaks-that
###To force delete local not merged branches
gitrmf feature/we-dont-even-need-his-feature-anymore
My Hacktoberfest!
Tags: hacktoberfest
Published: 2020-11-18 17:52:23

Hello!
I'm Sowmya. I am currently in my junior year studying Computer Science at Indraprastha University.

This is my very first time at hacktoberfest and have to say this, this has been a truly wonderful experience. No, this is not an exaggeration. 

This is coming from a girl who is afraid of anything that mentions coding. Being in the almost final (pre-final) year really pushed me to do something new and maybe overcome my.. uhmm fear? I think it's more of improving what you are bad/ not so good at.

I have started practicing coding in python in HackerRank for almost a year now (I strongly recommend people to do this. This really improves your skills, trust me) and finally contributed to hacktoberfest this year.

I made 5 PRs in total and only 4 got accepted by the time the fest came to an end. I tried my best to contribute to open source mostly in Python.

I'll be looking forward to contributing to open source next year too!:)
Free SaaS landing page template
Published: 2020-11-18 17:42:37

Hi!

It's time for another freebie. This time a beautiful, designed landing page for your SaaS. It comes in a dark and light version. The landing page is made with Tailwind CSS and optimized for mobile, tablet and desktop use. Icons included in these designs are from the awesome heroicons library.

Grab your free copy here:

👉 https://www.themes.dev/library/tailwindcss-saas-landing-page/

Quick question: What Tailwind CSS template / component would you like to see next? Thinking about a making an app dashboard next.
Querying JSON and its nested objects with TSQL
Tags: sql, todayilearned, database
Published: 2020-11-18 17:42:00

When we were faced to store lot of dynamically modelled data in a relational DB, we decided on storing them in a JSON column of SQL server.

[The well documented](https://docs.microsoft.com/en-us/sql/t-sql/functions/json-functions-transact-sql?view=sql-server-ver15) recourses came in handy during initial development.

Although with some workaround
* Runtime JSON deserialization
* Getting around with Store procedures while whole application runs with entity framework

Until today I never got to query nested arrays of a JSON object with SQL. That is when I stumbled upon another method in T-SQL called **`OPENJSON`**


>OPENJSON is a table-valued function that parses JSON text and returns objects and properties from the JSON input as rows and columns.

In other words, OPENJSON provides a rowset view over a JSON document. You can explicitly specify the columns in the rowset and the JSON property paths used to populate the columns. Since OPENJSON returns a set of rows, you can use OPENJSON in the FROM clause of a T-SQL statement just as you can use any other table, view, or table-valued function.


####Few samples

Consider this sample json data

```
DECLARE @json NVARCHAR(MAX) = '{
	"firstName":"James",
	"lastName":"Doe",
	"ChildrenDetails":[
		{
			"Id":1,
			"Name":"John Doe",
			"Languages":["English", "German"]
		},
		{
			"Id":2,
			"Name":"Jane Doe",
			"Languages":["English"]
		},
		{
			"Id":3,
			"Name":"June Doe",
			"Languages":["German", "Tamil"]
		}]
}'
```

### 1. Querying into arrays (ChildrenDetails)

```
SELECT 
    JSON_VALUE(d.value,'$.Id') AS Id,
    JSON_VALUE(d.value,'$.Name') AS Name
FROM OPENJSON(@json,'$.ChildrenDetails') AS d
```


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

### 2. Flatten Nested arrays (ChildrenDetails + each language)
```
SELECT 
JSON_VALUE(d.value,'$.Id') AS Id,
JSON_VALUE(d.value,'$.Name') AS Languages,
l.value AS Name
  FROM OPENJSON(@json,'$.ChildrenDetails') AS d CROSS APPLY OPENJSON (d.value,'$.Languages') AS l
 ```
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/n6g3426psj8m055t0gy0.png)

Hopefully you can try this with complex JSON structures. The use cases are many, but today this came in handy for a feature to us 😃

Before you leave, a meme:
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/u577z2v5n8z2fssw2n5c.jpg)



`EOF`
Strapi vs Netlify CMS
Tags: help, codenewbie, discuss, webdev
Published: 2020-11-18 17:41:40

I currently use Contentful for my blogging site (https://github.com/nishantwrp/nishantwrp-website). But now I wanted to migrate to an Open Source, self hosted CMS. I have two options

- Netlify CMS
- Strapi

I wanted to know which one of these would be best in my case and why?
Connect The Dots Hackathon 2020
Tags: beginners, opensource, webdev, javascript
Published: 2020-11-18 17:27:22

## What is a hackathon?

Remember when **Covid free**, we used to go to over-crowded places, listening to our jam, and envy a high-tech setup someone had in front of us. Working hard was our thing, sleeping less kept us exciting, every hour was counted until the great pitch, where our keyboards were spilled sometimes with a hacker's coffee around, and the end was dedicated to our product we managed to build during that weekend? Yes, that is a hackathon!

## Coder Gals

Three years ago we started the Coder Gals activities focused on Software Development. We found an enormous gap in educational events when it comes to gaining technical skills such as programming, and innovation, especially the competitive ones.
We have built a community that seeks to enhance participation in open-source projects, where everyone is welcome to learn, work, contribute, and have fun working on worldwide solutions.

Successful past/future stories of Coder Gals:
- [Coder Gals - The First Hackathon of Prizren, Kosovo](https://digitalspoiler.com/codregals-the-first-hackathon-of-prizren-kosovo/)
- [Debian Conference 2021 in Kosovo](https://dev.to/codergalsks/debian-os-conference-2021-in-kosovo-4om8)

## What's coming next?

The Coder Gals is excited to announce the **Connect The Dots Hackathon** in partnership with the U.S Embassy in Prishtina and the Kosovo United States Alumni (KUSA). 

**Connect The Dots Hackathon** will be based on three themes, where most of the projects will be open-source. 

1. **Open-Source**
2. **Corporate**
3. **StartUp**

We know you are already asking, what are we going to work within these themes?

A hackathon is all about what kind of a hacker you are.

Are you excited to contribute to OpenStreetMap? Then your place is in the **Open-Source** theme.

Are you someone who will work on a feature we'll publish in your favorite programming language? Then your place is in the **Corporate** theme.

Are you someone who will hack an MVP for the whole weekend? Then your place is in the **Startup** theme.

## Are there any limitations?

Some limitations will help us experience a very smooth event and we will be sharing them soon. #TBA

## Can I apply?

If you are from Kosovo, Albania, North Macedonia, and Montenegro, and your professional career is focused on Software Engineering, please do have the patience to wait until our applications are open, so you can apply to participate in the **Connect The Dots Hackathon**. :)
what should I learn about Django and Reactjs. (consult me please)
Tags: django, react, webdev
Published: 2020-11-18 17:34:38

in the past, I learned how to create a website with pure HTML and javascript and later I leaned Reactjs and I never used pure html+javascript anymore but despite that, I don't consider it as a wast of time because it helped me master and appreciate Reactjs. On the other hand, I regret wasting my time on learning express because I never used it and it never helped me understand or appreciate anything. Now, I'm using Django rest framework with Reactjs with typescript but also I don't want to learn everything about django nor about every way of integrating Django and Reactjs. So, I want to make social applications like Reddit and apps like Notion.so and of course Django is really great at that but I find people integrate django and react via axios or ajax, and others do it by connecting react to templates. what is the difference between all these ways and what is the most flexible and mature way?
Also, I'm learning from this 
course video : https://youtu.be/f1R_bykXHGE
the course final code: https://github.com/codingforentrepreneurs/Tweetme-2
and I'm very sure this will be a very helpful course but I still feel that I am wasting my time on too many unnecessary things.
Side project: Slack Clone -- life update
Tags: sideprojects, jobsearch
Published: 2020-11-18 17:33:35

It's been a while since I've posted on here since I finished my final project at Flatiron School in July. A lot has happened in the past few months. I had a baby! Revel Joy Deaver was born on September 4th at 9:35pm.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/2yt7ua5xfyrzmqsg1qz3.JPG)
She was a big reason why I haven't done many projects. I took some time away from coding to adjust caring for a newborn and a toddler. I'm glad to say that I am slowly starting back with building side projects to fill up my portfolio and continuing my learning. 

My first side project since Flatiron School is a Slack clone. During bootcamp, I used Slack mostly to communicate with my cohort and share resources. This application allows a user to sign up using Google authentication instead of regular email and password. A user then can create a channel and start posting messages in it. It's a very bare-bones with a lot of potential. 

I built this Slack clone using React.js for frontend, Firebase for database management, and Context API for state management. Firebase is Google's platform for developing mobile and web applications. It offers many products but for this project I am using the database and hosting. Context allows me to pass data to many different components at different nesting levels. It is a feature built into React. This app uses Context to manage user state. It allows many different components to access user data regardless of parent-child relationships between components.

I really enjoyed this build as it allowed me to work with new technologies like Firebase and Context. Because I learned Ruby on Rails and SQL at Flatiron, it was much easier to learn Firebase because I was able to compare what I knew about backend and database. Firebase makes setting up a database very simple and easy and it also comes built with authentication versus having to build one in Rails. Firebase also allows for hosting so the app is live [here](https://slack-clone-d89af.web.app). I am excited to create more side projects and continue learning!

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

[GitHub Repo](https://github.com/chayadeaver/slack-clone)
Welcome Thread - v100
Tags: welcome
Published: 2020-11-18 17:33:03

---
title: Welcome Thread - v100
published: true
description: Welcome to DEV! A thread of hellos and intros.
tags: welcome
canonical_url: 
---

![Dog Wig Welcome](https://media.giphy.com/media/5L57f5fI3f2716NaJ3/giphy.gif)

### Welcome to DEV!

1. Leave a comment below to introduce yourself! You can talk about what brought you here, what you're learning, or just a fun fact about yourself.

2. Reply to someone's comment, either with a question or just a hello. 👋 

**Great to have you in the community!**
The Focus For YouTube Content
Tags: devops, development, 100daysofcode, youtube
Published: 2020-11-18 17:22:15

---
canonical_url: https://www.clouddev.engineering/the-focus-for-youtube-content/
---

The time has come where I've started to focus out where my free content will be. My content has come in forms of:

Various blog posts on sites like Pluralsight, TechTarget, CBT Nuggets, and many other platforms

Although I'll still be creating video courses, I want to focus my free content in a specific place. After months of debating, I've decided that it makes more sense for me to put my free content on YouTube for a few reasons:

I love the freedom that videos give you. You can express your emotions. Laugh, smile, show the world you're truly excited.
I've found a passion for editing videos.

I like having the ability to either completely script out what I'm going to do, or showcase technologies on the fly. Sometimes I've never even tested what I'm doing. I just hit the record button and start going.

I like that my viewers can put a face to the content. With blogs, that's of course a bit more difficult.
I truly love creating content in all shapes and forms, but I feel like I can express myself far more in a video vs in a blog.

With that, I'd like to welcome you to my YouTube channel. If you haven't seen it already, it's a place where all levels of programmers can come and enjoy content. I do everything from beginner-level content to more advanced level content. It's a place where you can learn how to program, easily.

I also have two free mini-courses on Go (golang) and Python.

Come check it out and let me know what you think! https://www.youtube.com/clouddevengineering

This does not mean I won't still be writing blog posts. I will, just less frequently as I'll be focusing on YouTube.
Projects
Tags: past, projects, present
Published: 2020-11-18 17:21:19

Projects I've worked on (and continue to work on). Current tally is 9.

| Project        | Started           | Description  | What happened  |
| ------------- |:-------------:| -----:| -----:|
| [AppRamp](https://web.archive.org/web/20141218205638/https://appramp.io/) | 2012 | Build automation service for mobile apps | Shut it down |
| [MadLab](https://web.archive.org/web/20140318051746/http://madlab.io/) | 2013 | A mobile UI A/B testing tool | Shut it down |
| [Billgist](https://billgist.com) | 2014 | A daily or weekly overview of your AWS billing usage | Active |
| Kempt.io | 2015 | iOS app to regain disk space by deleting bad photos | Shut it down |
| [LegalRisk.io](https://angel.co/company/legalrisk-io) | 2016 | A tool to identify personal and professional relationships for managing malpractice risk | Shut it down |
| [Foretheta](https://foretheta.com) | 2016 | Custom software dev and security agency | Active |
| [Cheap Cheap Fares](https://cheapcheapfares.com) | 2019 | Cheap air fare alerting service | Shut it down |
| [Traindex](https://traindex.io) | 2019 | Machine learning augmented search | Active |
| [Whatsup](https://github.com/foretheta/whatsup/) | 2020 | Open source up/down monitor | Active |
My Hacktoberfest Experience
Tags: hacktoberfest
Published: 2020-11-01 17:39:58

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ -->


### [Intro Heading]
<!-- If you are new to the DEV community, introduce yourself and share a bit about why you joined DEV and decided to participate in Hacktoberfest this year.  --> 
### Background
I am new to the DEV community, although I read DEV blogs, this is my first article here, I am Akuagwu Philemon, I am a full-stack developer. I am a passionate developer, with over 3 years of experience. I participated in Hacktoberfest 2019 and Hacktoberfest 2020 because I find it interesting and fun, dedicating a whole month to celebrate open-source and contributing to codes of company and individuals of a different nationality is really fun.
<!-- Are you brand new to open source? What about coding in general? Tell us about how you got here -->

### Progress

I have completed my hacktoberfest challenge and the process has been really interesting, I made 5 Prs to 3 repositories
<!-- Share a bit about where you’re at in your Hacktoberfest journey. What stage are you at? How has the process been?  -->

### Contributions
I contributed to 3 repositories but I am most proud of 1 which is 

https://github.com/Presto412/CryptoFS, I enjoyed contributing to this repo because it was the most interesting, I was tasked to implement AWS S3 bucket as a cloud storage solution, In a way that we hash the file and simply link similar files, to avoid uploading similar files twice.

<!-- This is where you can list the contributions you made and explain why you chose the projects you did. Don’t forget to add links!  -->


### Reflections
<!-- Overall, how has your Hacktoberfest 2020 experience been? If you’re a first-timer, will you participate again? What have you learned? Have you made any interesting connections? What is your next step in open source?  -->
I really enjoyed the whole Hacktoberfest experience, and I will surely do it again next year, I will also try to contribute to more open-source repos at my leisure
What's New in Node.js v15
Tags: node, javascript, npm
Published: 2020-11-18 16:47:54

Node.js is the best way to run JavaScript on the server, and Version 15 brings some surprises, like a new version of npm, some breaking changes with Promises, and several new features in the JavaScript language. Watch this video for more details!

Table of Contents:
0:00 Introduction
1:06 npm 7
2:00 Breaking Changes with Promises
3:27 QUIC support
4:39 New JavaScript features
5:03 Promise.any()
5:41 String.prototype.replaceAll()
6:15 Logical Assignment Operators
8:37 How to install Node.js v15
9:17 Outro

---

🙏 Thanks for taking a look at my content!

📨 Join my newsletter for more: https://ryanlewis.dev

🎥 Subscribe to my [YouTube channel](https://www.youtube.com/channel/UCFqsAphTD7FXKYDCg5zdrOA) for more!

---

[YouTube](https://www.youtube.com/channel/UCFqsAphTD7FXKYDCg5zdrOA) | [Twitter](https://twitter.com/ryanmurakami) | [GitHub](https://github.com/ryanmurakami) | [Site](https://ryanlewis.dev)
Self Service Data Management From Ingest To Insights With Isima - Episode 159
Published: 2020-11-18 16:36:57

<p>The core mission of data engineers is to provide the business with a way to ask and answer questions of their data. This often takes the form of business intelligence dashboards, machine learning models, or APIs on top of a cleaned and curated data set. Despite the rapid progression of impressive tools and products built to fulfill this mission, it is still an uphill battle to tie everything together into a cohesive and reliable platform. At Isima they decided to reimagine the entire ecosystem from the ground up and built a single unified platform to allow end-to-end self service workflows from data ingestion through to analysis. In this episode CEO and co-founder of Isima Darshan Rawal explains how the biOS platform is architected to enable ease of use, the challenges that were involved in building an entirely new system from scratch, and how it can integrate with the rest of your data platform to allow for incremental adoption. This was an interesting and contrarian take on the current state of the data management industry and is worth a listen to gain some additional perspective.</p><p><a href='https://www.dataengineeringpodcast.com/isima-data-management-platform-episode-159/'>Listen Now!</a></p>
How To Make A Text Field in Elasticsearch & Kibanaaggregatable
Tags: elasticsearch, kibana, elk, textfield
Published: 2020-11-18 16:24:32

Learn how to change the status of a text field from non-aggregatable to aggregatable.

<b>How Do I Check If A Field Is Aggregatable?</b>

To check if a field is aggregatable open Kibana choose the 'Management' option on the left hand side menu and then choose 'index patterns'. If there is a check / circle under the aggregatable column then this means the field is aggregated.

[Continue reading this tutorial on the Logit.io blog](https://logit.io/blog/post/how-can-i-make-a-text-field-in-elasticsearch-and-kibana-aggregatable)
What a lovely OS is Pop!_OS!
Tags: linux, upgrade, unix
Published: 2020-11-18 16:10:35

I have been using Pop!_OS as a full time driver for like 3 days and it has been a amazing experience for me. The UI, The color theme and The usual good things with Linux.

I switched from windows to get rid of the bloat in it and have a pure Unix environment.

And I suggest you to try out Pop!_OS, incase you haven't already.
What's wrong with that Arduino wining?
Tags: help
Published: 2020-11-18 16:09:39

I am making a sensor that can sense 3 buttons separately, I wanted to print the number of the button I am pushing to the Serial Monitor, but I did something wrong wiring my Arduino. Here is my code (I think there's nothing wrong with that part of the project):

```
int LedPin = 12;
int buttonPin = 2;
int buttonPin2 = 3;
int buttonPin3 = 4;
//int buttonPin4 = 5;

int buttonState = 0;
int buttonState2 = 0;
int buttonState3 = 0;
//int buttonState4 = 0;

void setup() 
{
  Serial.begin(9600);
  pinMode(LedPin, OUTPUT);
  pinMode(buttonPin, INPUT);
  pinMode(buttonPin2, INPUT);
  pinMode(buttonPin3, INPUT);
  //pinMode(buttonPin4, INPUT);
}
void loop() 
{
  buttonState = digitalRead(buttonPin);
  buttonState2 = digitalRead(buttonPin2);
  buttonState3 = digitalRead(buttonPin3);
  //buttonState4 = digitalRead(buttonPin4);

  Serial.print(buttonState);
  Serial.print(buttonState2);
  Serial.println(buttonState3);

  //delay(1000);
  
  if (buttonState == HIGH) {
    //Serial.println("1");
    digitalWrite(LedPin, HIGH);
  } else {
    digitalWrite(LedPin, LOW);
  }
  
  if (buttonState2 == HIGH) {
    //Serial.println("2");
    digitalWrite(LedPin, HIGH);
  } else {
    digitalWrite(LedPin, LOW);
  }
  
  if (buttonState3 == HIGH) {
    //Serial.println("3");
    digitalWrite(LedPin, HIGH);
  } else {
    digitalWrite(LedPin, LOW);
  }

  /*if (buttonState4 == HIGH) {
    Serial.println("4");
    digitalWrite(Pin, HIGH);
  } else {
    digitalWrite(Pin, LOW);
  }*/
}
```

Problem:

And some pictures with Serial output (when I press any button it outputs 111, if I don't press anything it writes 000)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/837fs58xb99pfxne40wf.png)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/35kjviybfh95q4y0ml2h.jpg)
Making a Timer in JavaScript
Tags: javascript, tutorial, react
Published: 2020-11-18 16:05:52

## TL;DR;

 - [Codesanbox link with notes](https://codesandbox.io/s/timer-example-c8gc8)
 - [Twitch stream, twitch.tv/codesagas](twitch.tv/codesagas) during your lunch break, 11 AM MST
 - [Youtube](https://www.youtube.com/channel/UCeY6Ssc5qnHtZJlS-QoAEEQ)
 - [Twitter](twitter.com/codesagas)

## This is Easy Right
As a coding educator, I have seen many developers make a timer in js like this
```js
setInterval(function(){
  // Do my task every second...
}, 1000)
```
This will work in most cases but there are some cases that it fails. The main case is giving the user time to do a task. Like a timed test or take a turn in a game.

The issue is that they may get extra time because the action itself takes time to compute. Also, knowing when to stop is tricky.

The solution requires a tad bit more work but is simple enough.

## Solution

Just do the interval more regularly. It is easy as a human to get stuck in thinking in seconds because we commonly do that in real life. Computers can handle much smaller time frames. We might have to do a bit more but it gives a better experience.

```js
setInterval(function(){
  // Do my task every 50 milliseconds...
}, 50)
```

## Come Watch
This post was explored in more depth during our [Twitch stream, twitch.tv/codesagas](twitch.tv/codesagas) during your lunch break, 11 AM MST. Come hang out and learn something new with us. We go over most things web development and try to keep it simple. Replays are posted on [Youtube](https://www.youtube.com/channel/UCeY6Ssc5qnHtZJlS-QoAEEQ) in their entirety. And don't forget to follow us on [Twitter](twitter.com/codesagas) for more tips, tricks, and updates.

<span>Cover Photo by <a href="https://unsplash.com/@veri_ivanova?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Veri Ivanova</a> on <a href="https://unsplash.com/s/photos/timer?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></span>