teleren/devto huggingface dataset:
Learn SQL from Scratch - PostgreSQL Tutorial for Beginners
Tags: sql, webdev, tutorial, beginners
Published: 2019-08-12 09:24:30

SQL course covering important topics of Business Intelligence for SQL Database ( PostgreSQL ) for Beginners

Why learn SQL?

SQL is the most universal and common used database language.It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put,If you want to access databases then yes, you need to know SQL.
It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people get interested data from database. It is also an English like language so anyone who can use English at a basic level can write SQL query easily.
SQL is one of the most sought-after skills by hiring employers.
How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.
What's the difference between SQL and PostgreSQL?

SQL is a language. Specifically, the "Structured Query Language"
PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.
All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.
Which is better, PostgreSQL or MySQL?

Both are excellent products with unique strengths, and the choice is often a matter of personal preference.
PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.
Open source development will bring more features to subsequent releases of both databases.

Who uses these databases?

Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.
What's special about this course?

The course is created on the basis of three pillars of learning:

  Know (Study): We have created a set of concise and comprehensive videos to teach you all the SQL related skills you will need in your professional career.
  Do (Practice): We also provide Exercises to complement the learning from the lecture video. These exercises are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.
  Review (Self feedback): Check if you have learnt the concepts by executing your code and analyzing the result set. Ask questions in the discussion board if you face any difficulty.

What you'll learn

  Knowledge of all the basic SQL commands
  Become proficient in SQL queries like SELECT, CREATE and ALTER
  Solid understanding of SQL

{% youtube 6kL-Mn2ZbuI %}
Is there a place for dev.to developers to chat?
Tags: question, meta, discuss
Published: 2019-08-12 09:14:39

---
title: Is there a place for dev.to developers to chat?
published: true
description: 
tags: question,meta,discuss
---

I've recently cloned the dev.to codebase to try and contribute and help with [an issue that I discoverd](https://github.com/thepracticaldev/dev.to/issues/3675) but I'm wondering... where are all the developers!? 🤔

Maybe it's just that I'm a bit spoiled by the Ember Community having a very active [Community Discord Server](https://emberjs.com/community/) but I figured the right place to ask would be on dev.to itself 🎉

So folks, if I want to learn how to contribute where should I go to hang out with like-minded individuals? I did find a wonderful [thread to help people with issues](https://dev.to/devteam/devto-open-source-helpdiscussion-thread-v0-1l45) but I'm more so looking for the **discussion** aspect rather than the "I have a problem can you help me fix it" sort of thread.
How to use Error protocol easily in Swift
Tags: swift, errors
Published: 2019-08-12 09:12:42

---
title: How to use Error protocol easily in Swift
published: true
description: Sample code about how to handle Error protocol in Swift.
tags: Swift, Error
cover_image: https://thepracticaldev.s3.amazonaws.com/i/4tdetw5j6lq58t84l9pb.jpg
---

Swift has `Error` protocol that does not have anything default. iOS developers have to extend this protocol to deal with errors in their app. I will introduce a very simple example to manage custom errors. You can define your error cases like following.

```swift
// Error+Extension.swift

enum CustomError: Error {
    case errorOne
    case errorTwo
    case errorThree(message: String)
}

extension CustomError: LocalizedError {
    var errorDescription: String? {
        switch self {
        case .errorOne:
            return NSLocalizedString("Error one's description", comment: "Custom Error")
        case .errorTwo:
            return NSLocalizedString("Error two's description", comment: "Custom Error")
        case .errorThree(let message):
            return NSLocalizedString(message, comment: "Custom Error")
        }
    }
}
```

[I wrote an article about handling UIAlertController](https://dev.to/ngo275/the-easiest-way-to-handle-uialertcontroller-in-swift-1i18). Using this `AlertController`, `Error+Extension.swift` can be improved like this.

```swift
// Error+Extension.swift
enum CustomError: Error {
    case errorOne
    case errorTwo
    case errorThree(message: String)
}

extension CustomError: LocalizedError {
    var errorDescription: String? {
        switch self {
        case .errorOne:
            return NSLocalizedString("Error one's description", comment: "Custom Error")
        case .errorTwo:
            return NSLocalizedString("Error two's description", comment: "Custom Error")
        case .errorThree(let message):
            return NSLocalizedString(message, comment: "Custom Error")
        }
    }
}

extension Error {
    func displayAlert(completion: (() -> Void)? = nil) {
        let alert = AlertController(title: "Error", message: localizedDescription, preferredStyle: .alert)
        let action = UIAlertAction(title: "OK", style: .default)
        alert.addAction(action)
        alert.show(completion: completion)
    }
}
```
Linux by example - Building glibc and configure time and locale
Tags: linux
Published: 2019-08-12 09:09:45

---
title: Linux by example - Building glibc and configure time and locale
published: true
description: We build Glibc in our new system, configure the timezone variables, set the correct time and look into the installation and configuration of locales.
tags: Linux
cover_image: https://thepracticaldev.s3.amazonaws.com/i/5ir8q1u5xrjjcdx4zc12.jpg
---

{% youtube syH_7qVuGp0 %}

We build Glibc in our new system, configure the timezone variables, set the correct time and look into the installation and configuration of locales.
Top 5 Basic Networking Commands In Windows
Tags: commandline, github, linux, discuss
Published: 2019-08-12 09:02:52

"**If you want to know about networking and System hacking so first of all understand the command line interface of any operating system(Linux,Window,Ubuntu...) - Ankit Dobhal**"

I love to work mostly on Command line interface(terminal) of any operating system either it is window,Linux,Ubuntu etc. 

Well **Window** operating system contain  numerous built-in, command line networking utilities or tools.Most important think that as windows **administrator** you have to know about the basic networking utility or tools in Window machine.Windows operating system contain some build in networking **utility** or **commands**. 

# **Networking Commands In Window :**

![](https://thepracticaldev.s3.amazonaws.com/i/x9vu71wm5nzpd1mkv2zb.png)

## **ipconfig :**

ipconfig is one of the important & basic command in windows which can be used to display the network information of your machine like ip address,DNS etc..

**Example:**
**-> open your window terminal and run 'ipconfig' command.**
![](https://thepracticaldev.s3.amazonaws.com/i/dwx6i9ko3u3b6t2m21x3.JPG)

## **ping :**

ping is more often used networking utilities in windows which is used for detecting devices on a network and for troubleshooting network problem.

**Example:**
**-> open your window terminal and run 'ping' command.**
![](https://thepracticaldev.s3.amazonaws.com/i/tlj5hm4yiuyj1ptbd6z9.JPG)

## **netstat :**
netstat is very useful command. It is used for displaying the udp and tcp connection & ports in your system.It is also used to detect any tipe of virus in your system by showing an unknown port. 

**Example:**
**-> open your window terminal and run 'netstat -a' command.**
![](https://thepracticaldev.s3.amazonaws.com/i/4awtwvhxp7bmxsvm9b73.JPG)
**note: -a is used for all ports in system.**

## **tracert :**

tracert stands for traceroute like ping it sends out a data packet as a way to troubleshoot any network issues you might have, but instead tracks the route of the packet as it hops from server to server.

**Example:**
**-> open your window terminal and run 'tracert ip_address' command.**
![](https://thepracticaldev.s3.amazonaws.com/i/r0tszipsjlze396iz9lf.JPG)

## **nbtstat :**
nbstat is a utility that displays protocol statistics and current TCP/IP connections using NBT (NetBIOS over TCP/IP).
In ethical hacking their is a term called enumeration which is used to extract user names, machine names, network resources, shares and services from a system.
So for enumeration sometime nbtstat command uses to enumerate sharing services.

**Example:**
**-> open your window terminal and run 'nbstat ip_address' command.**
![](https://thepracticaldev.s3.amazonaws.com/i/lye3ffiim2a5jx5j3ada.JPG)  


So as I explained the basic networking commands in window . For more details about these commands you can [ask](https://github.com/ankitdobhal) me.
Code Style Matters: Styling Angular apps using Prettier and TSLint (2019)
Tags: angular, javascript
Published: 2019-08-12 09:01:16

Some people think that well-styled code is a waste of effort and as long as the code works you shouldn’t bother. It’s often the same kind of people how says that writing automatic tests are a waste of time because it is faster to only test manually right now but doesn’t take the future maintenance of the code into consideration.

The thing is that code is read way more than it is written. Read that again. If you think logically about this it should be obvious why it pays off to keep the code readable by good and consistent style practices.

Read the post here:
https://christianlydemann.com/style-angular-apps-using-prettier-and-tslint/
background-blend-mode property
Tags: css, tutorial, beginners
Published: 2019-08-12 08:52:54

Some people think that stunning image effects can be achieved only in graphic editors – nothing could be further from the truth. Adobe’s Photoshop did not invent blend modes and you can use them to style your image dynamically with CSS.

In my new blog post I described CSS `background-blend-mode` property with examples: [background-blend-mode property](https://cdn.sanity.io/images/0ugmrqfk/production/7ef97cbe6c227789b6903afc6c978a48e72473b0-1796x977.png?rect=0,236,1796,504&w=1200&h=337&auto=format)

And small CodePen preview of all properties:

{% codepen https://codepen.io/ItsMeNatalie/pen/dxZyOL %}

Enjoy and let me know what you think :)
Distributed locking & rate limiting
Tags: node, javascript, typescript, go
Published: 2019-08-12 08:52:22

In one of my previous projects, I ran into two problems. And this is not  [cache invalidation and naming things](https://martinfowler.com/bliki/TwoHardThings.html) as you might think :). This is distributed locking and distributed rate limiting. In my opinion, I did a pretty good job solving these two. And now after some simplifying and reshaping I think the solutions are ready for publishing and here they are: [go-locker](https://github.com/da440dil/go-locker) &  [go-counter](https://github.com/da440dil/go-counter)   on  [Go](https://golang.org/)  and [js-locker](https://github.com/da440dil/js-locker) &  [js-counter](https://github.com/da440dil/js-counter)  on  [TypeScript](http://www.typescriptlang.org/). Comments are welcome.
Is my CV ready for international jobs?
Tags: career
Published: 2019-08-12 08:47:11

Hi to all!

This is a preview of my personal CV:

![CV](https://www.visualcv.com/nicola-castellani/pdf/)

You can take a look to the full CV [here](https://www.visualcv.com/nicola-castellani/).

Is this a good CV format for American/Extra European jobs in your opinion? If not how do you suggest to improve my CV?

Thanks in advance!
Top Python Posts from August 5 week
Tags: python, bestofdev
Published: 2019-08-12 08:43:53

Hi! I'm Vicente, your friendly Filipino mod for the python tag. Today, is another episode of the Top Python Posts of the week!

Hope you'll follow along!

# 1.) Top 5 Programming Languages Every Software Developer Should Learn

Why I chose these five programming languages? My reasons are simple and practical. I have chosen languages based on their usage, paradigm, and popularity.

{% link https://dev.to/javinpaul/top-5-programming-languages-every-software-developer-should-learn-3o3o %}

# 2.) Dead Simple Python: Lambdas, Decorators, and Other Magic

Those of us coming from object-oriented programming languages have learned to think of everything in terms of classes and objects. Data is organized into objects, alongside the functions responsible for accessing and modifying that data. Sometimes this works, but other times, classes just start feeling like too much boilerplate.

{% link https://dev.to/codemouse92/dead-simple-python-lambdas-decorators-and-other-magic-5gbf %}

# 3.) Learning Python from Scratch: Tuples and Sets

The following are notes and details recapping a past live stream where we live code together. The idea behind these streams is that they provide real-world examples of running into problems and solving them or working towards solving them live.

{% link https://dev.to/azure/learning-python-from-scratch-tuples-and-sets-2e96 %}

# 4.) Python tips and trick, you haven't already seen

There are plenty of articles written about lots of cool features in Python such as variable unpacking, partial functions, enumerating iterables, but there is much more to talk about when it comes to Python, so here I will try to show some of the features I know and use, that I haven't yet seen mentioned elsewhere. So here we go.

{% link https://dev.to/martinheinz/python-tips-and-trick-you-haven-t-already-seen-1p41 %}

# 5.) Adding charts to Django admin

Django offers a functional admin UI out of the box with CRUD interface for db management. This covers most use cases for basic content and user management systems. However, it doesn't have exploratory views that show summaries or historical trends which is something you'd expect from an admin dashboard.

{% link https://dev.to/danihodovic/integrating-chart-js-with-django-admin-1kjb %}


See you again next week!
2 Must-have chrome extensions for Front-end Developers
Tags: frontend, extensions
Published: 2019-08-14 12:02:21

---
title: 2 Must-have chrome extensions for Front-end Developers
published: true
tags: #frontend #extensions
canonical_url: https://theworldwidecode.com/blog/2019/2-must-have-chrome-extensions-for-front-end-developers/
---

Nowadays front-end developers tend to build complex and pixel perfect template
Design Differences between Android and IOS
Published: 2019-08-12 07:46:24

As per the new trends, both these platforms are picking up habits of each other and following trend of both IOS and Android without any obligations. But still, there are some major differences which I am going to mention here.

 
Home Button

In IOS we have a home button in the bottom which is the only way out from the application,won’t say this is a drawback as it cuts the options off and leaves the user with only one option. So when designing for IOS we need to provide a back button in the design for user to get back to the previous screen. On the other hand, android has three buttons at the bottom (Back, Home and Overview) which give the user more freedom for navigation as compared to IOS.

 
Navigation bar

Android device has a universal navigation button at the bottom and we can easily go back to the previous screen by using the back button. But when we talk about iOS there is no universal back button or navigation button so there should have back navigation at the left top corner of every screen.

 
FAB

Floating action button is one of the main differences between Android and iOS which is used to show the most important and most common features of that particular screen. In Android, it can be placed anywhere on the screen. While talking about iOS it is called a Call to Action button which is placed at the right top corner.

 
Typography

iOS platform uses San Francisco while Android uses Robots typeface. In android more white space is used between texts. So we need to be more careful when doing typography in android and iOS.

 
Buttons

Buttons are the most basic element for user interface design. In the iOS app design, we take flat buttons means no or minimal shadow and no capital letter on the button. But in Android App design we give some depth to the buttons with capital letters on it.

 
Grids and Icons

Android and iOS both use the 8dp grid with a most common margin of 16px. In Android, we mostly use filled icons while in iOS we use line icons as per the present trend.

 
Conclusion

We can’t say which one is better “Android and iOS” because it depends upon the choice and need of the customer. Android and iOS both have different design principles which allow a designer to design the best user interface for customers. So as a designer first we should understand the need and requirement of a customer then design it accordingly. All these discussed points in this blog are proven by the experts who provide <a href="https://www.oodlesstudio.com/ui-ux-design-services/"> UI UX design services</a>.
4-hour daily interrogations...?🕵️‍♀️ no, meetings!
Tags: discuss, productivity, career, programming
Published: 2019-08-12 07:42:52

I am a remote developer and work with people from different parts of the world. This funny story is about one of my previous remote projects.

At that time I lived in Italy and my manager was in Brunei (the name of the country has been changed for confidentiality purposes😊). Due to time zone difference, we had daily meetings at my 7 a.m. You cannot imagine how much I love to sleep, but it was a half of the problem. Few times a week our meetings lasted 3-5 hours!

My manager was a good and responsible person, trying to keep everything under his   close control. He was not a developer in the past, as it often happens to IT managers. He was - a crime interrogator. Yes, those ones who catch the criminals. He was trying to get involved in any small technical detail, even when he could not understand a half. He was doing it with such diligence, making 100 questions, that I really felt like we are investigating a criminal case.

This story is already in past and I am happy now working at [Aspose](https://www.aspose.com), in the company where I am free to choose my workstyle. 👩‍💻

But, that interesting experience really showed me how much your way of thinking influence all you do. You may leave being a crime interrogator, but being an interrogator will not leave you! 😅☝🏻 

My longest meeting lasted 6 hours!
And, what was your longest daily meeting?😏
My Journey to finally choosing software as a career
Tags: motivation, beginners, career, coding
Published: 2019-08-12 07:42:18

Hi guys, its your favorite girl... "*** tho in my mind***"

OK OK back to the topic... Hmmm my journey was so blessed, back to how it all started, 

In 2016 after my diploma program I just found out I had this love for tech tho I never knew what it was going to take me to get there, my smart phone was stolen, my personal system was bad, I only had a phone that could google without seeing pictures, well thank God it could, so I started learning HTML and CSS without practicing, yeah without practicing cos there wasn't too good power supply in my vicinity. 

I had a friend who believed in me then but he was like I haven't seen your seriousness to learn this stuff, OK I decided to go out to look for other means so I started my search for an IT placement since I just completed my diploma. I did, went for interview but wasn't called, I went back there and they were like, there was no more space... That was one of the biggest disappointment but all good I went back home and taught about everything, I told my friend and i said i wasnt going back. Few weeks later, my friend said go and start as a volunteer, he said its better to go out every day without being paid than to sit at home all day. I started as a volunteer just cos i really wanted to be a software developer they accepted and I was posted as a receptionist yeah you heard that a receptionist. As a receptionist having access to the internet and a system I started practicing my HTML CSS tho it wasn't easy... Then I didn't even know the difference between frontend and back end but I knew I loved JavaScript... 

The story didn't end there.. To cut the long story short, there were times I gave up my dream cos there was no one to put me through some concept, no mentor, I could remember there was a time I decided to be a chef instead, I enrolled but deep down this wasn't what I wanted to do.. I still went back to programming.

To crown it all please never give up, I really don't know what you might be going through. I might not be where I am but I definitely cannot give up any longer... Believe in yourself and know it takes time to be good...
Cheers
My first react application
Tags: node, react, javascript, design
Published: 2019-08-12 07:10:40

Made my first React + Node project, please take a look at: https://ajaydevarakonda.dev/anonchat/#/ 

Planning to make more changes to the UI design. Going to use google mdl. If you are interested in sending a pull request with UI design improvements, github repository: https://github.com/ajaydevarakonda/anonchat