teleren/devto huggingface dataset:
Quick Demo! Five months of building.
Tags: postgres, javascript, elixir
Published: 2020-08-05 10:50:45


This is also available as a full [blog post](https://supabase.io/blog/2020/08/02/supabase-alpha-july-2020) with videos.

After 5 months of building, we're releasing one of our most anticipated features: Supabase Auth. 


## Auth

This month, we're ecstatic to announce a feature we think you'll love: Supabase Auth. It's too big to fit into a monthly update so look out for a full update in the next few days.

We want to make it easy to add Auth to your own apps, so we've released a [simple example and a video tutorial](https://dev.to/supabase/create-a-slack-clone-with-next-js-and-supabase-3lhd) which shows you how to implement a basic auth system using PostgreSQL's Row Level Security.

## Table Editor

We've made some massive improvements to our Table Editor that we're excited to share.

#### Relationship drill down

Last month we made it easy to drill into your table relationships. This month, we make it possible to drill multiple levels deep. 

![Drill into your releationships](https://user-images.githubusercontent.com/10214025/89403216-8f4d9700-d74a-11ea-9365-4f229edc8efd.png)


#### Add, delete, and download rows

We're making it easier to manipulate your data. Next month, you'll be able to add and remove columns directly from the Table view.

![Download data as a CSV](https://user-images.githubusercontent.com/10214025/89403262-a096a380-d74a-11ea-9275-6ca4cca9512b.png)

## New Postgres Extensions

If you launch a new Supabase project, you'll have access to several new Postgres extensions:

- [pgsql-http](https://github.com/pramsey/pgsql-http): HTTP client for PostgreSQL, retrieve a web page from inside the database.
- [pgjwt](https://github.com/michelp/pgjwt): PostgreSQL implementation of JSON Web Tokens
- [plpgsql_check](https://github.com/okbob/plpgsql_check): a linter tool for language PL/pgSQL
- [pljava](https://github.com/tada/pljava): write Java in your stored procedures, triggers, and functions

## Kaizen

We have a number of small improvements:

- Added Auth documentation to the auto-generated docs in each project
- Added a new `or` filter [to the client library](https://supabase.io/docs/library/get#or)
- Table View now remembers which tabs you had open.
- We have [released](https://github.com/supabase/pg-api/releases) a lot of new functionality to [pg-api](https://github.com/supabase/pg-api), a server for for managing Postgres internals via a REST interface.
- Performance: the "flash of black" which was appearing on page transition is now gone

### Get started

- Start using Supabase today: [app.supabase.io](https://app.supabase.io)
- Make sure to [star us on GitHub](https://github.com/supabase/supabase)
- Follow us [on Twitter](https://twitter.com/supabase_io)
- Become a [sponsor](https://github.com/sponsors/supabase)
Should you learn X or Y? Listen to the market
Tags: jobs, remote, react, career
Published: 2020-08-05 10:35:25

I've been freelancing & working remotely for almost 4 years now. And as a senior full-stack dev, one of the most overrated common questions that junior devs keep asking is: "What should I use, X or Y?"

Whether it's React vs Vuejs or JS vs Ruby. If you want to build stuff for yourself, **IT DOESN"T MATTER**. Just use whatever you like or already know. Users/visitors don't care what is your stack, they only care about a functional app or website.

The only reason you should be asking these kinds of questions is to figure out what is the market's demand, to land the best good job, as quickly as possible.

Since the world is going remote with the global situation. I thought I should share with you some of the skills with high demand now.

The following screenshot is from Toptal referral program that shows the skills they are willing to PAY for and get on the network. If you never heard of Toptal, it's a global remote company that provides a freelancing platform that connects businesses with software engineers, designers, and business consultants.

![](https://i.imgur.com/A2rqepR.png)

I've been part of Toptal's network since I started freelancing, and it's actually where I got my first remote job, and I've been working with them on-off for the past 4 years.

Toptal is a huge network and I believe the skills they ask for, reflect the market's demand. And it could be a good answer for juniors, and even seniors, for what to you focus on and what framework or lang to learn.

Toptal's hiring process is very similar to any Tech company, and working with them has it's Pors and Cons. My intention with this post is not to promote them. However, if you are looking for a remote job, I think Toptal is a good starting point. If you think you are ready to apply, you can use [my referral link](https://www.toptal.com#get-just-awesome-computer-engineers-now).

If you have any questions about Toptal, the hiring process, freelancing, or working remotely I would be happy to answer. Leave me a comment here or reach out to me on Twitter [@jamalx31](https://twitter.com/jamalx31)
What to do if Java command is not recognized by terminal.
Tags: java, compiler
Published: 2020-08-05 10:13:44

Now a days we install java in our windows for our own work.But it's quite annoying while it's not recognized by the terminal.Sometimes we even run java file from terminal so it needs to be fixed.
So here is the thing that you can do.
Step 1:
First of all right click on this pc.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/y1uiop7yxjjvc2rix0i1.PNG)
Step 2:
Go to properties and click advanced system settings.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/bljaibr5fhtuiz75mbc6.PNG)
Step 3:
Now click on environment variables.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/oqhyj99kq9uvmxe63m8i.PNG)
Step 4:
Now look at user variables. Look if there is any path variable. 
If there is path variable then look at <b>Method 1</b>..
If there is no path variable then look at <b>Method 2</b>..
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/dfhxfjp3qao1t2d18spi.PNG)
<b>Method 1:</b>
in your case if there is path variable.You have to select path variable and click edit.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/qm9zegbw59rnl9rkoun4.PNG)
Now click on new . And paste the location of your java bin folder.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/l13pxd4izsnq8nwlvxjm.PNG)
Click and copy the location.In my case it's location is:
C:\Program Files\Java\jdk-14.0.1\bin
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/4ka3sjgll6o97yjmq0c0.PNG)

Now click on ok .Then open the terminal.
write--> "Java -version".
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/q2xcz47gzb1t5vvu1r7r.PNG)
it should show your java version. 
If it's not then reinstall java by downloading java executable file from https://www.oracle.com/java/technologies/javase-downloads.html

<b>Method 2</b>
If there is no path variable then click on new.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/5vkiybxtqv5kzqb27gaf.PNG)

write the variable name as "path" And paste the location of your java bin folder in variable value box.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/l13pxd4izsnq8nwlvxjm.PNG)
Click and copy the location.In my case it's location is:
"C:\Program Files\Java\jdk-14.0.1\bin"

So i have wrote the variable name as "path" and pasted "C:\Program Files\Java\jdk-14.0.1\bin"
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/rdd3hnvk3e8nwqol1mo0.PNG)

Now click on ok .Then open the terminal.
write--> "Java -version".
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/q2xcz47gzb1t5vvu1r7r.PNG)
it should show your java version. 
If it's not then reinstall java by downloading java executable file from https://www.oracle.com/java/technologies/javase-downloads.html

Hope it will help you. Thanks !
Spread love with Python
Tags: python, love, programmingfun, shortposts
Published: 2020-08-05 09:57:42

---
title: Spread love with Python
published: true
description: 
tags: Python, Love, programmingfun, shortposts
---

Past week, I was busy coding in Python for one of our demos (which turned into a blog post later). At one point, I was recalling the syntax and thought why not spread some :heart: with code. The very basic rule is not IDE whatsoever

Python is one programming language where you have the freedom to express yourself until you adhere to the indentation :wink:

So, here's what I did on my command line

![](https://pbs.twimg.com/media/EdDDEb0VcAEwoCd?format=png&name=medium)

[Link to the tweet](https://twitter.com/VidyasagarMSC/status/1283763317832593409?s=20)

### all() Function
> Python all() Function: The `all()` function returns True if all items in an iterable are true, otherwise, it returns False. If the iterable object is empty, the `all()` function also returns True.

### None
> None equals to null or no value. It is not 0, False, or an empty string. Try `type(None)`, you will see the fun.
If programming isn't for career, what you doing it for?
Tags: discuss, watercooler
Published: 2020-08-05 09:37:39

I used to do it for CSV and text files crunching at first, but now I care more about FOSS contributions.

Also, as I have made webapps, I started to care more about [security](https://dev.to/t/security) and [reliability](https://dev.to/t/sre).

Only later that I started to get an online (but local) university degree, about medical informatics...

Care to share your stories (and your current living role)?
Why is a good strategy to take written notes
Tags: codenewbie, webdev, tips
Published: 2020-08-05 09:21:18

When it comes to taking notes, every one of us, as coders, we use different techniques. As usual, if you have read before any article of mine, I don’t like long introductions, and if this is the first time you are here I would like to present myself: Hi 👋 I am Luc, a fresh web developer in his early 40’s.

##Why taking notes
You can call me old-school (oh well I am 🙂), but I like to write things down as my memory needs to boost up with Magnesium. So after a month, when I start to learn how to code, back in February 2019, I decided to take notes. Especially for JavaScript. I have a visual memory, so when I want a concept to be memorized I am drawing it according to my understanding. Even that taking notes for some it looks old, for me, it works as I am seeing my advancement into grasping the main core of JavaScript. So, in this case, taking notes brings a deeper understanding of the concepts that need to be memorized as it is translated to your perception. Bellow, I added how I understood the concept of a variable. I used the image of a bucket that stores values for later use. If you ask me “What is a variable?” I will answer that is a bucket that has values for later use.

![a bucket of variables](https://blog.accolades.dev/wp-content/uploads/2020/08/containers.png)
#####this are actual real photos from my notes

##How do you remember where is which?
I had this question asked by many people, either on Twitter or in person, when I tell them that I use this technique. My friend Adrian showed me, for instance, how an EventListener – Bubbling vs Capture works. If you are interested to see the picture, I posted it here. After I posted that picture on social media, I’ve been asked how do I know where to look in my notebook where I can find something specific. I used the technique that I called it “bent corner”. Instead of explaining in detail, I would like to show what I mean, take a look at the picture below.

![bent corners] (https://blog.accolades.dev/wp-content/uploads/2020/08/doubled-corner.png)

What I did, was to bend the corner of the page with the Information on the page. Each of every page that changes the notes, it has its own “bent corner”, so that it’ll be easier to find what I wrote when I need to revisit the concepts.


##Conclusion
Whether you have a visual memory and you translate the Information into images for better understanding, or you comment your code for your later use and understanding, you must get comfortable with the concepts so that you can implement them in a future project.

###_I hope this tip will help you to improve your coding journey, until next time, Happy Coding_ 🤓

You can find me on [Twitter] (https://twitter.com/accolades_dev), [LinkedIn](https://www.linkedin.com/in/luc-constantin/) or [Instagram](https://www.instagram.com/accolades_dev/) as well.
Introduction
Tags: programmers, learning
Published: 2020-08-05 09:05:55

Welcome to This Mortal Coil of Bugs and Errors, or tmcobae for short. 

So you know how Sarah J. Maas has a book series that's always "A court of X and X"? A Court of Thorns and Roses, A Court of Mist and Fury, A Court of Frost and Starlight, et cetera. Well, you probably didn't know that, because this is dev.to and not tumblr. My point is, that's where the structure of this blog's name comes from. This Mortal Coil of ever-revolving Bugs and Errors, because I tend to ignore compiler warnings, possibly a future song title for Fall Out Boy, official launch date: Aug 5, 2020. 

I figured, since I run into so many idiotic issues while coding, and because my til.md is growing to an unmanageable size, I might as well document all of it in a proper blog and cringe about everything years after. 


For the next few months (I think) I'll be focusing on Ruby and its backend framework, Rails. That being said, I still have some ongoing projects that require other languages, and sometimes I might want to revisit my Archive of Very Old Notes to make a post, so this isn't just going to be a Ruby-oriented blog. In fact, the majority of posts are probably not going to be about Ruby. It's just that I'll be more inclined to use the language and its libraries whenever I have the freedom to do so, and me yelling this plan to your face right now.

I feel like for a while I've always gone "whelp, wanna make a project, lemme just use Javascript for it." Desktop widgets? Coffeescript. Music Player? Javascript with Electron. Game development? Javascript all the way. Javascript has (weirdly enough) become my go-to programming language, but I've been stagnant on actually digging into the more niche parts of it. Yes, I'm still going to continue studying and using JS, but I just don't \**insert kowalski meme*\* vibe with it enough to call it my favorite, despite having used it in a fair amount of my projects. 

As for Ruby, I've dipped into it a while back, but never delved deep enough to consider myself even remotely competent at the language. My brief interactions with it gave off very "fun" feels though, so I'm willing to explore it a little more. Plus, you know, it just hits different when your personality/identifier is being a Ruby hobbyist. 

Well, the (metaphorical) night is young, I am young, and my programming career is still in its early stages. This is the programming equivalent of me moving to a new city, changing my wardrobe and hairstyle, and \**be unbound by the shackles of expectation my pre-existing identity has wrought upon myself*\*. 

And it might be a tad bit dumb to post this on the very first entry for this blog, but this is my way of holding myself accountable. Having profoundly announced this to my personal corner of the vast, vast internet should be able to provide decent motivation in the upcoming months. 

This blog is mostly going to be me bitc- sry, complaining about the everyday headaches that occur during my programming journey. Buckle up, cause you are about to observe a whole lot of breakdowns, shoddily assembled solutions, and 3am ramblings. 

\- Kevin
QUEPPELIN BEST FRAMEWORKS FOR DEVELOPING AUGMENTED REALITY APPS
Tags: frameworks, arapps, augmentedreality, queppelin
Published: 2020-08-05 09:00:44

Augmented Reality is the technology of giving a touch of virtual components or layers to the real world by placing digital information in the physical environment, in real-time. It models our view of the real world by taking information about the real world and overlaying digital information. Augmented Reality is pulling in more investment and fundings as it is set to soon evolve from being just another tech field to a lifestyle. The technology has the potentials of far-reaching implications in diverse areas ranging from marketing to design applications. 
Learn More from Our Blog: https://www.queppelin.com/queppelin-best-frameworks-for-developing-augmented-reality-apps/
Should I host two websites on a single domain?
Tags: devops, webdev, discuss
Published: 2020-08-05 08:57:09

I have two websites, one for mobile and one for desktop (i.e. this is not a responsive website). Both websites show similar (not identical) content for the same routes, so going to `/about-us` for each site would show the same content (80-90% similar, main content identical but peripheral content might change) within a different HTML structure. 

Ordinarily, I would setup one website on `m.mydomain.com` and the other on `mydomain.com`. However we have been looking into using the same domain (no subdomains) for both websites.

A load-balancer would send the traffic to the respective server based on the user-agent (to recognise mobile/desktop traffic). This might seem similar to what Amazon.com does (not aware of the internal workings)

Is this setup a good idea or is it going to lead to problems? 

**Pros:**
- An improved user experience (debatable)
- Possibly improved SEO as only a single website is indexed

**Questions:**
- Will there be caching issues since assets are different? What about service-workers?
- What about redirects? If one of the websites has a 301/302 redirect that is cached.
JavaScript closure
Tags: javascript
Published: 2020-08-05 08:52:03

I've read posts by several authors who patiently and kindly try to explain to me what a closure is. I can follow their logic. However,  because the explanations are lengthy, I'm not satisfied with the fact that I can't pin down the concept with a few words. And I found it somewhat confusing when trying to delineate a closure's relationship with a scope.

The concept of closure becomes much clearer to me after encountering [a sentence written by MDN](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Closures):

"a closure gives you access to an outer function’s scope from an inner function"

I feel that there may be more to what a closure is, but the description above will be a solid point of departure and return. Cheers to precise and concise explanations!
FAANG or  !FAANG?? 
Tags: webdev, javascript, faang, programmer
Published: 2020-08-05 08:47:41

Hey, Fellow Developers
I am a recent grad and going for masters in the computer science. 
I am also a fullstack developer. 

So, let's get straight to the point.
Every programmer have a dream of working in some of the largest companies like Facebook, Microsoft, Apple, Google, Amazon and Netflix(FAANG).
And here I want to ask you guys is it really that big of a deal to work in these companies? I mean I've heard from somebody that if you haven't been in any of these companies you are not a great computer engineer. What you all think of this? I really want to know. I mean is it all about company?
Look into foreign key constraint error in MySQL
Tags: mysql
Published: 2020-08-05 08:31:39

Sometimes we encounter the error that we cannot insert/update/delete records by foreign key constraint error. 

The error message like

```
[23000][1452] Cannot add or update a child row: a foreign key constraint fails
```

But this message may not help us to solve the problem because it doesn't have the detail.

So we can see the detail with the below query.

```sql
mysql> show engine innodb status;
```

Then we can get the detail in "LATEST FOREIGN KEY ERROR" section.

```
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2020-08-05 07:37:15 0x7fe488261700 Transaction:
TRANSACTION 306127, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
...
```
The Simplest Recycler EmptyView
Tags: recyclerview, android, emptyview, ui
Published: 2020-08-05 08:24:41

---
title: The Simplest Recycler EmptyView
published: true
description: Here's the code, and it's all XML
tags: recyclerview, android, emptyview, ui
//cover_image: https://direct_url_to_image.jpg
---

A recyclerview with something to show when it's empty is a pretty common pattern, many times we're tempted to do this in code.

We're going to look at a better way to do than:
Checking if the number of items in the adapter is zero and then show the empty view else, show the recyclerview.

Here's the code, and it's all XML
{% gist https://gist.github.com/AniketSK/7a4583ed3282ccceee99aa2eb6845be2 %}

No code required. This will show the recyclerview when items are present, and the progressbar in the center when it's not.

# How does it work?
A few key points
1. The layout is a vertically oriented LinearLayout with only two items, the recyclerview and the container for the progressbar.
2. The progressbar is the second item in this list.
3. Recyclerview's widths and heights are always calculated from their children.
If there are no children, it sets itself to zero. When there are children, it actually follows the rest of the rules given to it like ```match_parent```

If you look into the [source code](https://android.googlesource.com/platform/frameworks/support/+/refs/heads/androidx-master-dev/recyclerview/recyclerview/src/main/java/androidx/recyclerview/widget/RecyclerView.java#3656) of the RecyclerView you'd see this line in onMeasure, which is what defines the dimens of the view.
```java
mLayout.setMeasuredDimensionFromChildren(widthSpec, heightSpec);
```

So that's it! You can now get a clean empty view that naturally gets shoved under the recyclerview when there are items and you didn't one bit of Java/Kotlin code to do it yourself!
How to give CSS class in jQuery?
Tags: html, css, webdev, beginners
Published: 2020-08-05 07:59:17

This post was originally published at https://www.blog.duomly.com/6-most-popular-front-end-interview-questions-and-answers-for-beginners-part-3/#how-to-give-css-class-in-jquery

---

{% youtube xCmRYzlnAMU %}

Did you think jQuery is dead already, and nobody uses it?

Nothing more wrong!

It’s kinda similar, like with PHP, that modern web-development doesn’t want to use it so much, but still, most of the internet is powered by that tech.

The jQuery library is still alive, and around 75% of all websites are using jQuery, so it is definitely worth knowing at least basics.

One of the features that we’ll be using with jQuery is to manipulate the elements, add styles, hide, show, add or remove attributes.

In this case, I’ll show you the two things, the first one (you’ll use it very often) is how to take element by the selector.

When we take element by a selector (in this case, we take it by id), we can add the class to the selected element.

Let’s take a look at the code example that I’ve created.

In the code example, I’ve created an element with id “hero”.

Next, I’ve created the js script, where I’ve used jQuery to take the “hero” element by its id.

And as the last step, I’ve added the class “rounded” to that element.

```html
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Learn coding on Duomly.com</title>
    <script
    src="https://code.jquery.com/jquery-3.5.1.min.js"
    integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0="
    crossorigin="anonymous"></script>
  </head>
  <body>
    <div id="hero">
      This is hero element
    </div>
    <script>
      $("#hero").addClass('rounded');
    </script>
  </body>
```

<a href="https://www.duomly.com/?code=lifetime-80">![Duomly - Programming Online Courses](https://dev-to-uploads.s3.amazonaws.com/i/bde89cw4h64z765g2l4r.png)</a>

Thank you for reading,
Radek from Duomly