teleren/devto huggingface dataset:
#SQL30 Day 1: Wildfires
Tags: sql, database, postgres, challenge
Published: 2019-10-03 10:28:32

Welcome to the SQL showdown series!  

### What is this and how does it work?

I'm committing to publishing a SQL challenge every day for 30 days.  In each post I'll describe **my** solution to the last day's challenge.  I'll follow that up with a full description of the challenge for the next day.

Write your own solution in the comments!  Let's see who can come up with the most creative solutions.

I'll add connection details for a PostgreSQL database containing test data for the challenge.  Solutions are by no means limited to PostgreSQL, but it's there if you want an easy way to test your query!

### Challenge #1: Wildfire Causes

In this challenge we'll use the [1.88 Million Wildfires](https://www.kaggle.com/rtatman/188-million-us-wildfires) data-set from Kaggle.  

The question is: 

**What are the details of the largest recorded wildfires (by acreage) for each potential cause of wildfires?**  

We want the name of the fire, its cause, the state it happened in, the date it was discovered, and the date at which it was considered contained.  Each output row should be the largest fire that has ever occurred for that particular cause of wildfire.

The **wildfire** table has the following columns:

* name
* cause
* acres
* disc_date
* cont_date
* state

### Sandbox Connection Details

I have a PostgreSQL database ready for you to play with.

![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/zpoed03yjhvjosbii3z7.png)

The password is the same as the username!  To query the **wildfire** table:

```sql
SELECT * FROM day1.wildfire;
```

### Good luck!

Have fun, and I can't wait to see what you come up with!  I'll be back tomorrow with a solution to this problem and a new challenge.
Speedy Spotless
Tags: java, formatter, spotless, maven
Published: 2019-10-03 10:17:27

---
title: "Speedy Spotless"
published: true
canonical_url: "https://committed.software/posts/speedy-spotless/speedy-spotless/"
tags: [ "java", "formatter", "spotless", "maven" ]
image: "speedy-spotless.jpg"
---

[Speedy Spotless](https://github.com/commitd/speedy-spotless) is a Maven plugin for easy formatting of staged changes. It is inspired by [pretty-quick](https://github.com/azz/pretty-quick) but for Java.

[Spotless](https://github.com/diffplug/spotless) is a tool to automatically format your code. It can format in various languages in a multitude of different ways. Regularly running an automatic code formatter like Spotless is a great way to maintain a consistent code style and to keep changes readable. It is good practice to use a [Git hook](https://www.atlassian.com/git/tutorials/git-hooks) to format new code as it is being committed.

[Existing approaches](https://github.com/diffplug/spotless/issues/178) for formatting staged changes don't address what to do for the formatting of partially staged files. If the formatter makes changes to the file it is no longer obvious what changes to include in the commit! Speedy Spotless will format such files, but will cancel the commit, allowing the developer to decide what to do instead of doing something that the developer may not have intended.

Speedy Spotless is a drop in replacement for Spotless Maven Plugin and supports the same configuration options, but also includes the new goal `speedy-spotless:staged` to trigger the formatting staged changes and `speedy-spotless:install-hooks` that creates & installs the Git hook to format staged changes automatically. It will even preserve any existing hooks!

[Speedy Spotless on Github](https://github.com/commitd/speedy-spotless).
ReactJS v/s AngularJS
Tags: react, angular
Published: 2019-10-03 10:12:58

ReactJS or AngularJS which framework is more important to build the application. Before talking about the contrasts that both have here is brief introduction given below to simplify the concept of ReactJS and AngularJS. They both are well-known program developing languages that help coders or developers to build an application or websites.

AngularJs

AngularJS is a JavaScript Web application framework originally created by Google, and it is actively supported by Google and it is also a community of developers. As we all know AngularJS created by Google, and according to this Angular is a great platform for web applications.


ReactJS

React JS is indeed one of the most popular frameworks for developing web applications, which attracted a large and active community. And according to this, a vast wealth of reusable components for it that will save the time of coders, when the developers coding, this library helps the coders to write the code that is modular. As we all know that Facebook created React, as well as, chosen a design different from AngularJS but a similar MVC framework which, the part of the AngularJS.


Future of AngularJS and ReactJS is– now Angular 8 is the latest version for Angular. This is a huge step up from AngularJS. Most of the changes are behind the scenes. The update from Angular to Angular 8 did not change how the coder code. Now Google introducing Angular8 in the market which is the advanced version of Angular. There how Angular improve itself from time to time.

let's get a brief comparison between- https://codersera.com/blog/reactjs-v-s-angularjs/#comment-8
How to send Bulk SMS using Magento 2 SMS Extension
Tags: magentosms, smsapiintegrationinmagento, magentosmsextension, magento2smsextension
Published: 2019-10-03 10:05:01

Purpletree Magento 2 SMS extension allows admin to get an SMS on various actions by customer or admin regarding order or customer. This extension allows admin to simply set API for SMS on setting page and admin has then nothing to worry about how to send SMS to the customer regarding anything. There are few options that are given to admin to be setup from the admin panel for SMS. The Text in a message can easily be setup.

Setting up SMS API URL

First of all, the admin must have some API for SMS which will be sending SMS. Purpletree only provides the platform to send SMS to the customer. The API is to be provided by the website store admin. Purchase any SMS API from a third-party 
source and get the API URL from them which we need in our settings.

· Enable the Module from Admin > Stores > Settings > Configuration.
· Enter Valid License Key which you have obtained from Purpletree Software LLP. Please contact support if you have not received the Valid License key for your extension. This is required to activate the extension.
· Now Enter SMS API URL which you have obtained from any third party SMS provider.
· Now your extension is ready to use. Just setup the setting when you want to send SMS to customers.

Selecting Customers

By using this admin would be able to send SMS to bulk customers from the admin panel. If it is enabled from admin settings. Then admin just needs to go to Customers > All Customers and on the listing page, select the checkbox on left, for which admin wants to send SMS and then click on Actions Dropdown above and Select SMS to Customers.

Sending SMS

On the next page, after Selecting Send to SMS, Admin would be redirected to Send SMS Form page, from there admin can enter any message they want to send it to Selected customers.

In the Message, part admin can write any text. Along with that, there is two variable, one is _NAME_ for Customer name and _URL for the Website Store Url.
For example, if you want to send SMS to Customers as "Dear John"(Customer Name), Then you can write "Dear _NAME". By doing this you don't have to worry about writing Name for each customer in the message. In the same way, there is a Store Url variable which is _URL_. Just write this variable in SMS if you want the customer to send the website link to check.

Get This extension At: https://www.purpletreesoftware.com/auto-sms-for-magento2.html
Learning to Program 01: Hello Programmer
Tags: learning, beginners
Published: 2019-10-03 08:50:11

Most programming textbooks, tutorials etc. start out with the classic, the sometimes maligned and the universally known _Hello World_ program. Something like:

```python
print("Hello World")
```

or

```csharp
Console.WriteLine("Hello World");
```

or

```rust
println!("Hello World");
```

Those examples are _python_, _C#_ and _rust_ incidentally. Three of the languages I enjoy working with and am most comfortable with.

The idea behind this small little program is quite simple I think. You, as the budding novice programming, are standing up and saying _Hello_ to the big scary world of programming.

But the title of this post is _Hello Programmer_, and I'd like to focus more on _you_ as the programmer, rather than the _World_ into which you will be programming (more on that later!).

So, what _is_ a programmer? There are many definitions and debates about this but here is mine that I'm going to be working off for the rest of this series:

> A programmer is some who is _unapologetically stubborn_ about solving problems, always _willing to learn_ and has an _insatiable passion_ to build things.

That doesn't described you? Don't worry, these traits can be learned, and most programmers don't start out this way. You slowly build up to _being_ this kind of person. A programmer is something you _are_ not something you _do_.

Maybe all you are interested in is earning a good salary. Or perhaps you want to expand your skillset to keep up with changes in your, non-programming, industry. Or perhaps you just want to build a Mod for your favourite game and you have no idea where to start.

That's all fine, for a start. The _why_ is less important for the beginner programmer, but it does become important to keep your interest alive.

So instead of saying _Hello World_ first, take a moment to say (insert your own name):

```rust
println!("Hello Pieter");
```

and ask yourself _why_ are you doing this.

---

Link to [Main Content Post](https://dev.to/pieterjoubert/learning-to-program-02-the-what-4n2g). If you are confused about this post start here.
I see a fresh website and I want it painted black.
Tags: design, webdev, help
Published: 2019-10-03 10:02:43

My portfolio website is coming on nicely, but one thing that bothers me. I swear I used to be able to design before I learned about good accessibility practices. You see I like colour, and I know of some color pallettes that aren't too bad for getting a AA or even triple AAA rating. Sounds good so far, "I could splash a little yellow here, a little blue there, oh that pink looks nice.. ". I have just broken a rule. Not too many colours!

Okay let's try this again, make the colors more muted, use 3 colors max, keep things consistent. Oh it looks like IV just made a black and white website...

I find that my websites always just end up as black and white generic box stacks. I want to use black, white, brown and copper colours. Then I need to decide how much ratio of each colour, as a big slab of brown could look like 💩.

Okay so perhaps I have a way forward, wait isn't copper the colour of 3rd place medals.. oh choosing a scheme is so hard, even with a decent pallette, making. The rules that's the hardest bit.

I have no idea how to make rules for my colours and if there is a way to look modern but break out of the generic hero image and stacks of boxy content, or if my theme should be dark or light.
Pixact: игра в пиксели
Tags: javascript, программирование, кодинг
Published: 2019-10-03 14:51:36

---
title: Pixact: игра в пиксели
published: true
date: 2019-10-03 09:57:15 UTC
tags: JavaScript,Программирование,Кодинг
canonical_url: http://pixact.ly/
---

[Условия простые](http://pixact.ly/): игроку предстоит нарисовать коробку, максимально приближённую к заданным параметрам. У игры есть явный недостаток - труднопроизносимое название, но глазомер она действительно развивает.
Building a honkify extension for bpmn-js
Tags: webdev, bpmn, bpmnio, javascript
Published: 2019-10-03 09:48:56

---
title: Building a honkify extension for bpmn-js
published: true
description: bpmn-js extension which is inspired by honkify
tags: #webdev #bpmn #bpmn-io #javascript
---

Something for the fun department: Yesterday I found this amazing project, which replaces any link on a page with a duck "honk": [honkify.js](https://github.com/jlengstorf/honkify).  This inspired me to build a simple [bpmn-js](https://github.com/bpmn-io/bpmn-js) extension which adds this honk on several modeling operations, e.g. adding, moving or removing BPMN shapes from the canvas:

```js
/// Honk.js

import CommandInterceptor from 'diagram-js/lib/command/CommandInterceptor';

import inherits from 'inherits';

import showToast from 'show-toast';

export default function Honk(injector) {

  injector.invoke(CommandInterceptor, this);

  const audio = new Audio(
    'https://res.cloudinary.com/jlengstorf/video/upload/q_auto/v1569957993/honk-sound.mp3',
  );

  function _honk(context) {

    console.log('honk fired.', context);

    // honk
    audio.play();

    // show toast
    showToast({
      str: 'Honk 🦆🦆🦆!',
      time: 500,
      position: 'top'
    });
    return false;
  }

  this.execute([
    'shape.create',
    'shape.move',
    'shape.delete'
  ], _honk);
}

Honk.$inject = [
  'injector'
];

inherits(Honk, CommandInterceptor);
``` 

I put the results in a [small GitHub project](https://github.com/pinussilvestrus/bpmn-js-honkifay), which everyone can simply install via `npm` and directly integrate into their [bpmn-io](https://bpmn.io) application. 

![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/t2y0ruenpelh3i2gee6b.gif)

This fun example showcases how easy it is to build extensions for the bpmn-io toolkit. Also, have a look at the [bpmn-js-nyan-cat](https://github.com/bpmn-io/bpmn-js-nyan) for another little example of how to bring joy in your modeling application.

Enjoy!
Rakuten Japan open 2019 Championship
Tags: rakuten, japanopen
Published: 2019-10-03 09:33:55

Here you can watch Rakuten Japan Open Tennis Championships 2019 HD live streaming in high-quality video and sound on all kinds of smart devices from all over the world. The Rakuten Japan Open Tennis 2019 is the 46th edition and it is part of the ATP World Tour 500 Series, it will be played on the hard court at the Musashino Forest Sports Plaza in Tokyo, Japan from 30 September to 6th October 2019.
<a href="https://livesportworld.com/rakuten-japan-open-live-stream/">Rakuten Japan Open championship</a>

<a href="https://livesportworld.com/rakuten-japan-open-live-stream/">Rakuten Japan Open</a>
The Japan Open Tennis 2019 is hosted by the Japan Tennis Association (JTA), it is the largest ATP World Tour tennis event in Asia and was 1st take place in 1972. Rakuten Japan Open is one of the last stops on the schedule with players all wildly battling for one of 8 spots at the visit finals in London. The qualifying matches will begin from 28 September to 29 September 2019 and the tournament will begin on Monday 30 September 2019. Don’t miss to watch Japan Open Tennis 2019 live online on your favorite smart devices across the earth. 
<a href="https://capitalsins.tumblr.com/post/188101840414/rakuten-japan-open-live-stream-watch-japan-open">Rakuten Japan Open championship</a>
<a href="https://www.facebook.com/events/2494219727473827/">Rakuten Japan Open championship</a>
Watch live 
Event: ATP Rakuten Japan Open Tennis 2019
Date: 30 September- 6 October 2019
Category: ATP World Tour 500 Series
Surface: Hard
Location: Musashino Forest Sports Plaza in Tokyo, Japan
Tips to prevent Fistula in a software engineer’s life
Tags: health
Published: 2019-10-03 09:00:53

Anal Fistula or Fistula in Ano is an abnormal tunnel under the skin which connects the anal canal in the colon to the skin of the buttocks. 

1. Eat a balanced diet

2. Drink more Water

3. Use Pillows

4. Maintain good personal hygiene

5. Strengthen your immune system

6. Practice Healthy Bowel habits

If your symptoms are consistent , consult our colorectal surgeon at siicp.com for safe and advanced fistula treatment.
Learning to Program 00: Prologue
Tags: beginners, learning
Published: 2019-10-03 08:51:40

Just like any good novel, where the prologue hints at a massive world filled with mystery, interesting characters and looming threats, I wanted to start this series with some background and some hint of where it's going to go.

I teach programming for a living. And I've been teaching programming in some capacity (either professionally or incidentally) for almost 20 years know. It's my one great passion in life, helping _anyone_ understand how to program. I've used tools and languages such as _Visual Basic_, _python_, _Scratch_, _C#_, _Unity_, _HTML + CSS + JavaScript_ on top of a full _PHP_ and _MySQL_ stack and even _Lego Mindstorms_, to teach a range of people from 10 year old school children, to working adults how to program.

The purpose of that previous paragraph was not to brag about all the languages I know (and the fetishization of languages is a topic I'll probably cover later on), but to bring up an important point: learning programming is _not_ learning a language.

You will learn a language along the way, but that's almost incidental. I say _almost_ as the choice of language will have some impact on how and what you learn.

The background has been set, at least one character has been introduced (whether he is interesting or not is up to the reader to decide), all that's left is the looming threat.

In the prologue to Game of Thrones, the reader is given the briefest hint of the _White Walkers_ and the possible threat they might pose to our protagonists. In our journey what then is the looming threat, the hinted at horror that well be revealed piece by piece?

It's simply _time_. Programming is not something you learn over a weekend, or over a 6 week bootcamp, or even really over a 4 year degree. It's a continuous process, that, everyday in some small way you need to push forward on. Programming is one field where it is literally true that if you aren't moving forward you are moving back ward.

Let's start with that first small step right now: {% link https://dev.to/pieterjoubert/learning-to-program-hello-programmer-46if %}

<!-- {% replit @PieterJoubert/RepulsiveOddPheasant %} -->
[Devmates.co] Roman 🏦 Goldman Sachs
Tags: challenge
Published: 2019-10-03 08:47:23

*Hello👋, 
*My name is [Alex](https://twitter.com/alexwawl) and I'm maker of [Devmates.co](https://devmates.co).* 😊

*We are resolving daily coding problems which asked by top tech companies together. We share our solutions, give some help if anyone stuck, support each other and just hangout together in the internet.* 🍻☕️💬

*I get this problem from our members or just searching them in the internet(leetcode forums, Glassdoor, teamblind, etc.). Sometimes this problem can be very easy, sometimes too 👷‍♂️hard, everything depends on skills but we are trying to resolve all of them and Have Fun.*  🙌 

Today I want to share problem which was asked by 🏦 Goldman Sachs.

#####Problem:

Roman numerals are represented by seven different symbols: __I__, __V__, __X__, __L__, __C__, __D__ and __M__

For example, 2 is written as __II__ in Roman numeral, just two one's added together. 12 is written as, __XII__, which is simply __X__ + __II__. The number 27 is written as __XXVII__, which is __XX__ + <b>V</b> + __II__.

Roman numerals are usually written largest to smallest from left to right. However, the numeral for four is not __IIII__. Instead, the number four is written as __IV__. Because the one is before the five we subtract it making four. The same principle applies to the number nine, which is written as __IX__. There are six instances where subtraction is used:

* __I__ can be placed before __V__ (5) and __X__ (10) to make 4 and 9. 
* __X__ can be placed before __L__ (50) and __C__ (100) to make 40 and 90.
* __C__ can be placed before __D__ (500) and __M__ (1000) to make 400 and 900.

Given a __Roman__ numeral, __convert it__ to an integer. Input is guaranteed to be within the range from 1 to 3999.

#####Example:
__Input:__ "III"
__Output:__ 3

__Input:__ "IX"
__Output:__ 9

__Input:__ "LVIII"
__Output:__ 58

__Input:__ "MCMXCIV"
__Output:__ 1994
Amazon's Great-India-Sale-InfoScrapper Cum Notifier : 

Tags: webdev, python, aws, github
Published: 2019-10-03 08:42:42



#Amazon  #Great-India-Sale #shopping #Flipkart #python #web-scrapping


Python script, written so that when the desired product hits a lower price than the desired price, then we'll get a push notification! so that the deal cannot be missed.




https://github.com/abhisheknaiidu/Amazon-Floatify
Hacktoberfest Plans
Tags: hacktoberfest, iot, circuitpython, c
Published: 2019-10-03 08:24:34

Happy Hacktoberfest! 

I am happy to be participating this year, and I thought it'd  be fun to  share my plans:

1. Moddable — I am working to create a way to send an I2C timeout option for the I2C initialization function, the PR is open and in progress: [https://github.com/Moddable-OpenSource/moddable/pull/271](https://github.com/Moddable-OpenSource/moddable/pull/271)
2. RaverLights — I am working on documenting @nebrius' side project, RaverLights: [https://github.com/nebrius/raver-lights](https://github.com/nebrius/raver-lights)
3. Keyboard featherwing — @Arturo128 was nice enough to send me a board so that I can add documentation: [https://github.com/nodebotanist/keyboard_featherwing_sw](https://github.com/nodebotanist/keyboard_featherwing_sw)

This is my scope for now and I can definitely commit to at least 4 PRs.
Using netcat as a test statsd server
Tags: todayilearned, netcat
Published: 2019-10-03 08:02:20

---
title: Using netcat as a test statsd server
published: true
description:
tags: til, netcat
---

Netcat will listen on a port and write what it receives to stdout.

```bash
nc -u -l -p 8125
# -u UDP
# -l Listen
# -p Port
```

It only works for a single line/connection. (Other versions have an option to keep listening. However, I wasn’t able to find one that ran on MacOS).