teleren/devto huggingface dataset:
My Dev Journey: Week 8
Tags: beginners, javascript, codenewbie, bootcamp
Published: 2021-06-27 12:07:16

This week was careers week on my coding bootcamp, and as such this week was a lot less new concept heavy as many of the previous weeks have been. Instead of new technologies we had a few lectures on CV writing, portfolio preparation, and technical tests.

If you've enjoyed any of my blog series, then maybe consider following me on [GitHub](https://github.com/fearneyork) 😁

## What I've done this week

Whilst I created my first development CV during this week the two most important things I've done this week were completing a back-end project I worked on during the back-end portion of the course, this involved a broad scope of unit and integration testing. And then once I was happy with the functionality of my API I hosted it on Heroku which what the first time I've hosted anything. And then I got to write my first README for the repo, and I wanted to make this one as good as I could becasue it's the first I've written and I've really enjoyed this project and didn't want to half-do the last thing 😁

But by far the thing I'm most excited about this week, is buying my first domain for my portfolio site, and creating my first front-end project. We've not done the front end block of the course (this starts next week) but I wanted to complete a portfolio site that I could link to in my CV, for job applications (if any hiring managers are reading my blog still on week 8, then please hire me 😅) and socials too! My portfolio uses a bootstrap template but I went through and dipped my toes in the luke warm waters of HTML and CSS to make it match a style closer to my CV styling.

## Resources I've found useful this week

### Setting up google domains on GitHub pages

This [dev](https://dev.to/trentyang/how-to-setup-google-domain-for-github-pages-1p58) article was really useful in helping guide through setting up my newly minted domain, with github pages, as well as the [GitHub Pages docs](https://docs.github.com/en/pages/configuring-a-custom-domain-for-your-github-pages-site).

### Bootstrap docs

The [bootstrap docs](https://getbootstrap.com/docs/5.0/getting-started/introduction/) were crucial for my brief intro to HTML and CSS work.

### Design inspiration

[Canva](https://www.canva.com/en/) was pretty useful in getting design inspiration for structure of my CV, I then created my CV in Affinity Publisher, which took a fair bit of getting used to again, because I'm much more used to Adobe InDesign
denosaur faster
Published: 2021-06-27 12:07:12

![denosaur Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i1traxp0qcdkt02abots.gif)
Thanks to the parameter **--no-check** you can in **deno** disable type checking.
Which significantly speeds up **typescript** processing. 
Useful when combined with **vscode**, which validates code on development.
SSH Authentication issues: Permission denied(publickey)
Published: 2021-06-27 11:32:04

## Assumptions
1. The author assumes that that you are trying to ssh into a server or (git server) using a public key instead of a passphrase.
2. You have generated a ssh key on your local machine.
3. You have transferred the ssh key to the server, and your OpenSSH server is configured.

## Method 1
If your key is not saved in ``.ssh/id-rsa`` or if you have more than one ssh key on your local machine. Then have to mention the location of your key using the i flag ``(-i)``

``ssh user@192.168.1.101 -i ./.ssh/id_rsa_supremee_key
``
## Method 2
Or better yet, you can configure the OpenSSH client.

On windows the config file is found at ``C:\Users\username\.ssh\config``. So head to this file and add the key\values below, (obviously yours will be different)

<code>
#Personal account, - the default config
Host makhosi6.github.com
   HostName github.com
   User git
   IdentityFile ~/.ssh/id_rsa
   
#work account 
Host dev.github.com  
   HostName github.com
   User git
   IdentityFile ~/.ssh/id_rsa_dev

#supremee
Host 192.168.1.102
   HostName 192.168.1.102
   IdentityFile ~/.ssh/id_supremee_key
</code>

## References
[www.digitalocean.com](https://www.digitalocean.com/community/questions/how-to-ssh-with-i-flag)
[nerderati.com](https://nerderati.com/2011/03/17/simplify-your-life-with-an-ssh-config-file/)
[ssh.com](https://www.ssh.com/academy/ssh/config)
[linuxize.com](https://linuxize.com/post/using-the-ssh-config-file/)
[thereference.dev](https://thereference.dev/article/ssh-authentication-issues-permission-denied)
Re-thinking the note-taking experience on the web
Tags: productivity, ux, webdev, design
Published: 2021-06-27 11:10:48

My next product is a tool that provides a better note-taking experience on the web. This is a  _personal_  problem I’ve always wanted to solve because like most people, I do a huge chunk of my work in the browser.

However, I typically have to write down companion notes to better understand infromation and to quickly catch up on forgotten bits. This is something I believe can be done better and in a significantly more productive way.

This is where this new  tool comes in, it’ll be taking that metaphor to the web where we can leverage the open, interactive and dynamic nature of the web to deliver a rich note-taking experience that is also contextually aware (à la  **Look Up**  in Mac OS or even  **Grammarly**).

![](https://miro.medium.com/max/780/1*7fhQdCpIcOMHSOPNMigMRg.png)

I’m excited about the future and will be sharing more progress soon. Follow my [socials](https://twitter.com/ParticleShift) for updates and register [here](https://mqoq9l8zhct.typeform.com/to/Q2Sps6ki) for the private beta which begins from 12th July 2021.

**Twitter:** https://twitter.com/ParticleShift
Sanity CMS Error: Failed to communicate with the Sanity API
Tags: sanity, cms, sanityapi, jamstack
Published: 2021-06-27 11:04:33

I’ve recently started using the [Sanity Content Management System](https://www.sanity.io/) and came across a particular error.

Running $sanity init in my studio folder I encountered this - 

```
Graemes-MacBook-Pro:studio graeme$ sanity init
You're setting up a new project!
We'll make sure you have an account with Sanity.io. Then we'll
install an open-source JS content editor that connects to
the real-time hosted API on Sanity.io. Hang on.

Press ctrl + C at any time to quit.

Prefer web interfaces to terminals?
You can also set up best practice Sanity projects with
your favorite frontends on https://sanity.io/create

Looks like you already have a Sanity-account. Sweet!


Error: Failed to communicate with the Sanity API:
Unauthorized - Session not found. For more information, see https://docs.sanity.io/help/cli-errors.
    at /usr/local/lib/node_modules/@sanity/cli/bin/sanity-cli.js:4318:3725
    at async e.default (/usr/local/lib/node_modules/@sanity/cli/bin/sanity-cli.js:4318:3549)
```
It’s strange because it recognises that you’re logged in but then says it can’t authorize a connection to the Sanity API.

I tried a number of things and I’m still not sure why this was happening.

I fixed it by simply logging out of the Sanity CLI in the terminal and then logging back in again. As always turning something off and then back on again is worth a try.

```
Graemes-MacBook-Pro:studio graeme$ sanity logout
Logged out
Graemes-MacBook-Pro:studio graeme$ sanity login
```

[Photo by Steve Johnson on Unsplash](https://unsplash.com/@steve_j?utm_source=unsplash&utm_medium=referral&utm_content=creditCopyText)
Scratching an itch with Spark
Tags: scala, spark, excel
Published: 2021-06-27 10:59:18

One of the things I love about Spark is how easy it makes working with various data sources. Once you've got the data out of the source and into a Dataset or DataFrame then you can manipulate that data without thought to the original format. Most of the times this is in CSV, Parquet, JSON, or a few others. But occasionally (or quite a lot of the time it seems if you're me) people will have the bulk of their data in Excel.

I'm not going to go into why Excel is a bad format for data storage and distribution, you can find plenty of reasons on-line, or you've likely encountered it yourself (Excel interpreting dates anyone?).

I've been working on a custom data source for Spark recently using the newer DatasourceV2 APIs, which make it easier to write data sources without having to consider RDDs, whilst bringing along a lot of new functionality like predicate push-down.

At the moment I'm still working through a few kinks, and ensuring that I've got as much code and branch coverage as I can, at which point I'll do a deeper dive into the how as I can't see a lot about how to write your own data sources on-line or off-line. But at the moment the data source supports the following features.

- Handling Excel 97-2003, 2010, and OOXML files (thanks to Apache POI)
- Multi-line headers
- Reading data from multiple sheets matching a given regular expression
- Handle glob patterns for reading multiple files
- Outputting the sheet name in the result set (set via an option)
- Schema inference
- Cleaning up column names (removing invalid characters)
- Handle merged cells (repeats data to all cells in the merged region)
- Formula evaluation (for those supported by Apache POI)
- Long name, short name, and helper method for loading data
- Works in Scala, PySpark, and Spark SQL

![Querying Excel using Spark-SQL](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/78d0i6i5g2itjg3x9anu.png)

This screenshot is querying a sample workbook I put together which contains formula data, I wanted to do this to make sure that the data was extracted as expected. And thanks to the Apache POI library, most formulae people use should be covered.

![The Excel source data](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5q6qcb1nwcdr5y5mt63g.jpg)

Code coverage is looking pretty good at the moment, but I want to make sure all of the key parts of the data source are covered, as there's a few "quirks" of Excel which I need to make sure are working as expected.

![Current code coverage](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rmsdwy1ywi2b4f09xd3r.png)

Hopefully I can jump onto the deeper dive soon, just in case there's anyone else out there crazy enough to want to write their own data source.
Remove continues element from an array
Published: 2021-06-27 05:10:25

### **let's first understand what continuous element**

![remove-continues-element](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/03whs1jcceo6u2k19d73.png)
 

in the above example, you have seen there is a repeating 
now I want to remove all continuous value only (not duplication) and keep 1st element of each repeating value

### **let's see how can we achieve that**

we can achieve that using array filter method 

Javascript filter accept callback function and that callback function accept 3 arguments 
 * element: it's return an current element 
 * index(optional):  it's return index current element 
 * array(optional):  it's return  actual array on which filter is perform 

![Remove continues element from an array](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ypn63p1wrtca598x0yl3.png)


so in above code we first check if element index is 0 or current element is not match with previous element then we return that element 


## **Wrapping up!**

Share this blog with your friends 👩🏼‍🤝‍🧑🏼 and developers 👨‍💻 you know and let them know about these

Your feedback and comments are very important to me. 💌

## **Get in touch 🤜🤛**

 [Instagram](https://www.instagram.com/technonic) 

 [YouTube](https://www.youtube.com/c/pratik-lochawala)
Does Google Docs really support non-English speakers? (Thai, specifically) And, any alternatives?
Tags: help, google, googlesuite, googledocs
Published: 2021-06-27 10:25:17

Something like, long word breaking... no, much longer than German words. AFAIK, auto-hyphenation is missing for some reasons.

![Thai paragraph](https://media.discordapp.net/attachments/712015468965134346/858645961516253184/unknown.png)

Something like, language specific fonts. Sometimes, there are also be Above and Under.

![Complex fonts](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/s1xbmpmmfdw5x3ghpewq.png)
The greatest change and challenge of all...
Tags: productivity, wecoded, theycoded
Published: 2021-06-27 10:22:07

What should you follow when you decide to move to another job? Does the company you are about to move support ethical values? If you need to ask a question, the question would be how included you feel while you are in this company? The world is right around the corner for an enormous change. A good reference in this challenging time is that seeing how tech companies adapt to this situation? How much they care about their employees on the way. 

Choose wisely #BigShift

What do you feel about your company giving you perks on the days like international women's day or pride month? Does that make you feel included only for one day? A very obvious way in my view is that hiring people while considering the diversity and a solid continuity/improvement on that matter.

Does the company you want to work for lead by example to the other companies with their culture? Do they define their success with the team they have? Is it just a company that has diversity except for the management? If you start to ask these questions, either you will get the right answers or red flags like the only same group of people is eligible for the positions. 

You have to be included and speak about yourself without a doubt in the environment you are working to be productive.

If you're considering moving to a country, it's also good to pay attention to the diversity of influential people in the government of that country.

While the industry is changing massively because of the pandemic, you can drive the change. It’s just a matter of the space that exists in the company, so you can create a change.

One of the things I love in a company is that they can step up and talk about inclusion and diversity when they see it is the most important thing we need to talk about. One of the things about caring for your employees is how you care about your customers. It is also a good sign how companies care about diversity towards their customers. How much percentage of accessibility they achieved on the company website? There are tons of extensions and tools you can just click and check the accessibility. If the products are made for all kinds of people of every age or differences in people, that would be a very good sign. 

Finding the right place to work means that you can be productive and be happy in your workplace. Ocean is blue because of the sky is blue and sky is blue because of the ocean is blue. People are the center of success. Success needs you. 

Don’t waste your valuable years by believing generic sentences in the job description and don’t forget to search your answers.
tic-tac-toe game using javascript,html,css
Tags: javascript, html, css
Published: 2021-06-27 08:59:39

## plan to build the tic-tac-toe game

![tic-tac-toe](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/eu0h6ltqx2k5b65kzqzg.png)


before we actually jump into building the application we need to break the big task into subtasks. The frontend of the application is very important to give an impression and to intrigue the user to give the application a try.i have attempted to make the frontend of the application simple yet appealing.so after deciding on the layout of the application i divided the home page into several boxes. the "wrapper" is what i called the box consisiting of the entire page.Next, the wrapper can be divided into left and right subparts after which each subparts can be subdidvided according to their components.by approaching a problem with divide and conquer approach we can concentrate better in developing the details of the application.The styling of the page is done with css and the logic of the game is built with javascript.

[find the source code here!!](https://github.com/aishwaryavasu0509/live-tic-tac-toe-game)
Top 7 Resources to Learn SQL
Tags: beginners, programming, computerscience, database
Published: 2021-06-27 08:50:04

So, you want to go on the path of SQL?

But don't know where to start?

Well, look no further. 

I've compiled a list of the best SQL resources I could find on the internet. 

*PS. If I miss anything, feel free to comment about it in the comments.* 

## [SQL Bolt](https://sqlbolt.com/)

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

This is the platform I used when I first started learning about SQL. It's basically a bunch of interactive lessons that teach you the basics of SQL. I would highly recommend this to beginners, or to someone wishing to freshen up their knowledge.

## [SQL Zoo](https://sqlzoo.net/wiki/Main_Page)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8rc41dslt2vrvymledsz.png)

SQL Zoo is a collection of tests that push your SQL knowledge to the limits. I've done this right after SQL Bolt and it helped immensely. The challenges range from easy ones that you can solve in a couple of seconds to hard ones where your brains are pushed to it's limits.

## [Use the Index Luke](https://use-the-index-luke.com/)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/2y7p3ewknj73o7xwn3qp.png)

After you get the basics of SQL down, you might want to check out "Use the Index, Luke!". It's a site that teaches you about writing efficient SQL code.

## [PostgreSQL Exercises](https://pgexercises.com/)

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

PostgreSQL is one of the world's most popular database management systems. With that in mind, this platform has a bunch of exercises to test your SQL and PostgreSQL knowledge.

## [Khan Academy](https://www.khanacademy.org/computing/computer-programming/sql)

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

I've used Khan Academy for all sorts of subjects and they never disappoint. This course offered by them covers the basics of SQL to more advanced topics such as JOINS, etc...

## [Udacity](https://www.udacity.com/course/intro-to-relational-databases--ud197)

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

If your more of a visual learner, I would recommend checking out Udacity "Into to Relational Databases". It covers beginner and intermediate topics. Along with the videos, it also included coding exercises. Heck, you might even continue on and take their [nanodegree](https://www.udacity.com/nanodegree).

## [SQL for Web Nerds](http://philip.greenspun.com/sql/)

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

This is more of an advanced course, it teaches you the gritty details of SQL. It was developed by MIT Professor Philip Greenspun. The site isn't flashy, but it offers expert-level content. 

## Conclusion

I hope you found some of the resources useful, and have begun your SQL journey. 

Thanks for reading!
Changes in Azure DevOps free grants explained
Tags: devops, azure
Published: 2021-06-27 08:27:06

During the past few days, I received several emails from people asking why their CI/CD pipelines started randomly receiving errors like the following:

![image](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/gct0pwc1f7y6h4a9058c.png)
 
Since 2018, Azure DevOps Services has provided free CI/CD pipelines for its users. By default, it allowed a developer to run arbitrary code for up to 1800 free minutes per month on Microsoft-hosted agents and ten parallel jobs for public projects. However, the market capitalization of cryptocurrency has skyrocketed in recent years, and as a result, it has become very profitable for some folks to violate the terms of service of PaaS providers’ free tiers, like Azure DevOps, to run cryptocurrency miners as a step in their build pipeline.

> “…cryptocurrency surged from $190 billion in January of 2020 to $2 trillion in April of 2021..” CEO of DevOps platform LayerCI, Colin Chartier

Without getting into details, cryptocurrency mining is a process that allows cryptocurrencies to work as a peer-to-peer decentralized network by verifying and adding transactions into the blockchain public ledger or even generate new coins. This process requires high-performance machines, and often they hijack system hardware resources like the CPU, GPU, and network bandwidth, affecting the entire host. As a result, Azure DevOps users saw a degradation in the service, increasing the build time from 20 to 50 percent.

![image](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iz4jnkxjzkgijwwov2he.png)

To guarantee a certain level of performance for its customers, Microsoft marked those activities as abusive and, after seeing an increase in the number of projects used for this purpose on Azure DevOps, announced on February 18th, 2021, that it would stop granting free pipelines to new public projects. Sequentially, crypto miners shifted to private projects forcing Microsoft to do the same for private projects on March 16th, 2021.

**IMPORTANT: This change does not impact any existing organizations. It only affects new public/private projects that you create in new Azure DevOps organizations.**

You can still enjoy the free tier, but to do so, you must send an email to **azpipelines-ossgrant@microsoft.com** and provide the following details:
- Your name
- Azure DevOps organization for which you are requesting the free grant

For public projects, you must also include:
- Links to the repositories that you plan to build
- Brief description of your project
Once the request is received, their team will review and respond in 2–3 business days.

#References:
- **Announcement change in Azure Pipelines Grant for Public Projects:** https://devblogs.microsoft.com/devops/change-in-azure-pipelines-grant-for-public-projects/
- **Announcement change in Azure Pipelines Grant for Private Projects:** https://devblogs.microsoft.com/devops/change-in-azure-pipelines-grant-for-private-projects/
- **Azure DevOps status:** https://status.dev.azure.com/_event/235501110
Awesome Themes for Visual Studio Code
Tags: vscode, javascript, python, programming
Published: 2021-06-27 08:14:09

Visual Studio Code is by far one of the most popular code editors for web, mobile, and hardware developers. More than 2,600,000 people use VS Code every month, up by over 160% in the last year.

Here are three awesome VS Code themes you can start using today.

## 1. Shades of Purple

![1_mYp50UlWTICuJWbXNNVqdw](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jiug7bqnqia5kvb1r51s.png)
 
A professional theme with hand-picked & bold shades of purple for your VS Code editor and terminal. One of the excellent most downloaded and top rated VS Code Themes on the marketplace.

###Installation

* Open the extensions sidebar on Visual Studio Code
* Search for Shades of Purple Theme
* Click Install to install it.
* Click Reload to reload your editor.
* Code/File ＞ Preferences ＞ Color Theme ＞ Shades of Purple.



## 2. One Dark Pro

![1_AzJL7eMEPjbcVO_dqpDwGw](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/asb3eai30zpgknqj7ix5.png)
  
Atom’s iconic One Dark theme, and one of the most installed themes for VS Code! One Dark Pro is based on Atom’s default One Dark theme, and is one of the most downloaded themes for VS Code.

###Installation

* Open the extensions sidebar on Visual Studio Code
* Search for One Dark Pro
* Click Install to install it.
* Click Reload to reload your editor.
* Code/File ＞ Preferences ＞ Color Theme ＞ One Dark Pro.


## 3. Dracula

![1_o8K-ziaotvrYzMDl8Fn4zg](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/kku0x29ej6mdw2iond4u.png)
   
Dracula is a color scheme and UI theme tailored for programming. Made for terminal emulators, code editors, and syntax highlighters. Designed to be aesthetically pleasing while keeping you focused.

###Installation

* Open the extensions sidebar on Visual Studio Code
* Search for Dracula
* Click Install to install it.
* Click Reload to reload your editor.
* Code/File ＞ Preferences ＞ Color Theme ＞ Dracula.

If you know and use another awesome theme that developers would like, please share it in the comment box :)