teleren/devto huggingface dataset:
Experimenting Flyway with SQL Server
Tags: sqlserver, sql, database, flyway
Published: 2019-03-13 06:53:33

---
title: Experimenting Flyway with SQL Server
published: true
description: A quick look at Flyway and its usage with SQL Server
tags: #sqlserver #sql #database #flyway
---

Recently, in my tea talks with my colleagues, Flyway came up. I was curious to experiment with it. According to their official site, Flyway is the version control for your database with many great features.

# Why Flyway?
One of the most important questions before even experimenting is WHY? 
Well, my take on this is that Version control is very important when it comes to databases. In many cases, techies develop their in-house version controls or tools to manage schemas and scripts. Bottom-line is that version control is indeed important.


# How?
Well, to try Flyway, I would sum it down to 5 easy and quick steps:

1. Download Flyway zip folder from [here](https://flywaydb.org/download/#downloads) and extract it to your machine.
2. Copy this folder path and add it to your Environment Variables. If you are not sure how to add a path to Environment Variable, check [here](https://www.architectryan.com/2018/03/17/add-to-the-path-on-windows-10/)
3. In the extracted folder, there will be a conf folder. Under it, update the flyway.conf with database connections.
4. Place your database migration scripts under sql folder. This folder will be present under the extracted flyway folder. Note:Please refer this [link](https://flywaydb.org/documentation/migrations#naming) for the naming conventions for flyway.
5. Open your command prompt, and run ```flyway migrate```. This will run your migrations. In case if you get the error```ERROR: Found non-empty schema(s) [dbo] without schema history table! Use baseline() or set baselineOnMigrate to true to initialize the schema history table.``` In this case run this: ```flyway migrate -baselineOnMigrate=true```. This command will create a baseline schema version table and data in your db for Flyway

Et voila !

This will run the scripts and update the version in your database.

Flyway supports a no of databases and is worth a try.

There are many more things that can be experimented with it.
Underrated Articles on Dev.to Last Week
Tags: top7, webdev, bestofdev
Published: 2019-03-13 06:17:32

---
title: Underrated Articles on Dev.to Last Week
published: true
description: 
tags: icymi, webdev, meta, bestofdev
cover_image: https://thepracticaldev.s3.amazonaws.com/i/djebdvq8ywi1kz1pl36f.png
series: Underrated Articles
---
Hey, I'm back with another installment of underrated DEV posts of last week! I had such a packed week I almost skipped this week's post, but in the end decided not to. Only 5 posts this time, however.
Before we begin, though, I just want to say that reading all the #SheCoded posts was so great! It was a hugely uplifting experience, and I remain positive about the future of women in tech.

Let's check out my favorite underrated posts of last week now.

## 1. Building Trust in the Team

Lack of trust has a tendency to ruin productivity and leads to mismanagement. It’s surely not easy to recover from a lack of trust in a team. So in this post, Matylda tells us strategies for building trust in a team. Build trust by openly communicating, sharing news and information, being there for your team, and making employees feel like they’re valued and appreciated.
{% link https://dev.to/matylda_wro/trust-building-strategies-for-teams-1ifb %}

## 2. Nested comments in Ruby on Rails

Blogs, social networks, learning resources, they all have some kind of a commenting system.  The most natural way to represent replies is to nest them. In this article, Lucy shares the necessary steps to make nested comments.  
{% link https://dev.to/lucysuddenly/nested-comments-in-ruby-on-rails-1k1f %}

## 3. Basic API Calls with Python

 This article by Hiro Nishimura will help you set up a virtual environment (venv) with Python and make basic API in Python with the Flask Framework. The whole procedure is explained properly and systematically in this post. 
{% link https://dev.to/hiro/learning-api-for-newbies-day-1-294 %}

## 4. Women in Tech

In this post, Debbie highlights the experiences of female developers in the tech industry. This article is heart-warming and full of appreciation for women who are role models to the other women and are who mentor others to succeed.
{% link https://dev.to/codementor/what-it-means-to-be-a-women-in-tech-in-2019--4el6 %}

## 5. Benefits and Drawbacks of Kotlin and Java

Android and Java, like fish and chips, have often been bonded together. Android SDK is even written in Java. However, with the invention of Kotlin, things have started to change. In this article by Aleksandra, we’re going to be looking at all the major differences between Kotlin vs Java. Advantages and weak points of both are explained well in this post.
{% link https://dev.to/bessalitskykh/kotlin-vs-java-which-programming-language-to-choose-for-your-android-app-3o5 %}

---
*That's all for now. These were my personal favorite underrated posts from last week. I hope you liked this post. Tell me in the comments about your favorite posts of last week that went underrated!* ❤️
Magento2 Google Map Store Locator Extension
Tags: magento2googlemap, magento2storelocator, fmegooglemap, marketplacefme
Published: 2019-03-13 06:12:48

---
title: Magento2 Google Map Store Locator Extension
published: True
description: This extension enables the customers to search physical store locations near their present location.
tags: magento2 google map, magento2 store locator, FME google map, MarketPlace-fme
---
 [Magento2 Google Map Store Locator Extension](https://marketplace.magento.com/fme-module-google-maps-store-locator.html) by FME allows the users to explore the closest physical store locations near to them by using Google Maps. It also facilitates the user by showing necessary details about the store timings and holidays and other useful things.

  ![Alt text of image](https://marketplace.magento.com/media/catalog/product/cache/c687aa7517cf01e65c009f6943c2b1e9/1/_/1.1advancegooglemapsstorelocatorextension_1.png)

  ![Alt text of image](https://marketplace.magento.com/media/catalog/product/cache/c687aa7517cf01e65c009f6943c2b1e9/1/_/1.2advancegooglemapsstorelocatorextension_1.png)


**Magento2 Google Map Store Locator Extension offers a bunch of useful features some of which are the following:**

• Create Listings page that brings all the stores to the Limelight
• Create an independent page for each store location
• Manage Multiple Stores
• Create store tags for good understanding of user
• Manage SEO configurations 
• Import CSV files to save data from Magento 1 stores

**Demo Links**:
[Frontend](https://mag2-administration.fmeplugins.net/advancegooglemaps/shops.html/)
[Backend](https://mag2-administration.fmeplugins.net/advancegooglemaps/admin_4ce40dc/admin/index/index/key/b779d874f727855cc17654b1c6cfe7bf5094a71e209c6690395d2fdf9244bd35/)
Now upload PWA to Google Play
Tags: pwa, progressivewebapp
Published: 2019-03-13 05:12:54

---
title: Now upload PWA to Google Play
published: true
description: Now Play store allows progressive web apps(PWAs) to be listed. Follow these steps(or watch video) to learn how.
tags: PWA, progressive web app
---

The following video shows how one can upload their PWAs to Playstore.
https://youtu.be/Ppzjg6uzWt8
Music vs Podcasts while coding? Any recommendations?
Tags: discuss, productivity
Published: 2019-03-13 05:04:45

---
title: Music vs Podcasts while coding? Any recommendations?
published: true
description: 
tags: discuss, productivity
---

I understand that developers listen to different things while coding. I want to expand my audio palette for my code sessions, and would like to get your opinions!

So, do you listen to music or podcasts when you code?

What specific genres / playlists / artists / shows do you recommend?
How I improved my git skills
Tags: uncategorized
Published: 2020-01-07 21:28:43

---
title: How I improved my git skills
published: true
date: 2019-03-13 04:36:07 UTC
tags: Uncategorized
canonical_url: 
---

Knowing how to use git for version control is a very important skill every software developer needs to have. I’ve been using git for a while, but I decided that I needed to get a better understanding of how it works and how to use it.

I learn best by trying things out, so I specifically looked for interactive courses. As I wanted to learn as much as possible, I used 3 websites:

[https://learngitbranching.js.org/](https://learngitbranching.js.org/)

“Learn Git Branching” is a very neat website that is not only interactive, but also comes with great visual representations of how a git branch looks like. After every lesson, one can try out to solve a problem oneself directly in the browser.

[https://lab.github.com/](https://lab.github.com/)

Github is almost a synonym of Git, so it’s worth learning how to use the Github features. The courses “Introduction to GitHub” and “Managing merge conflicts” are both interactive and create an actual test repository right inside your Github account for you to practice with.

[https://www.katacoda.com/courses/git](https://www.katacoda.com/courses/git)

This Katacoda course is also free and browser-based and helped me review and understand better various concepts.

[http://gitimmersion.com/](http://gitimmersion.com/)

I haven’t actually taken the Git Immersion course, but I’m linking it here so that I can find it if I decide to review again how to use Git at a later point.

Apart from going through these courses, I also decided to simulate some things for myself by setting up a second GitHub account. For setting things up locally on my Mac I followed this article: [How to manage multiple GitHub accounts on a single machine with SSH keys](https://medium.freecodecamp.org/manage-multiple-github-accounts-the-ssh-way-2dadc30ccaca).
How do we React - Part 3
Tags: aurelia, react, javascript, jsframework
Published: 2019-03-13 04:16:01

---
title: How do we React - Part 3
published: true
description: Part 3 of 3 parts series on how Aurelia covers common React scenarios
tags: aurelia,react,javascript,jsframework
---

Part 1: https://aurelia.io/blog/2019/02/21/how-do-we-react-part-1

Part 2: https://aurelia.io/blog/2019/03/01/how-do-we-react-part-2

Part 3: https://aurelia.io/blog/2019/03/12/how-do-we-react-part-3/

In this last part, `React.Children` is discussed...
Example to Set Border Radius of an Image in React Native
Tags: react, reactnative, android, javascript
Published: 2019-03-13 02:57:20

---
title: Example to Set Border Radius of an Image in React Native
published: true
description: Example to Set Border Radius of an Image in React Native
tags: #react #reactnative #android #js
---

---
source : <a href="https://www.skptricks.com/2019/03/example-to-set-border-radius-of-image-component-in-react-native-app.html"> Example to Set Border Radius of an Image in React Native</a>
---

In this tutorial, we are going to explain how to set border radius on an images in react native application. if you remember a month back we have shared demo on React Native to display or show Border Around Images, similarly here we are going to implement for setting border radius of  an images. Lets get started.

Set Border In React Native component :
Using below CSS properties you can set border width and color in react native component.
borderWidth : This will set border width.
borderColor  : This will set border color.

Set Border Radius In React Native component :
Using below CSS properties you can set border radius around image in react native application.
borderColor: '#F44336',  // Set border Hex Color code here. 
borderRadius: 10  // Set border Radius.


<a href="https://www.skptricks.com/2019/03/example-to-set-border-radius-of-image-component-in-react-native-app.html"> Example to Set Border Radius of an Image in React Native</a>

<img src="https://2.bp.blogspot.com/-JEmjc84ca-I/XITilms6kRI/AAAAAAAACgY/QuuBVlgm3YIODdMBvmAV6uXrAmgibAxowCLcBGAs/s640/border.png" />
LeetCode in Ruby: 70. Climbing Stairs
Tags: leetcode, ruby, dynamicprogramming
Published: 2019-03-13 02:06:33

---
title: LeetCode in Ruby: 70. Climbing Stairs
published: true
description: Solution + explanation for Problem 70
tags: #leetcode #ruby #dynamicprogramming
series: LeetCode in Ruby
---

# Dynamic Programming

```ruby
def climb_stairs(n)
  p = 1
  q = 1

  (n - 1).times do
    temp = q
    q += p
    p = temp
  end

  q
end
```

This problem can be solved by using dynamic programming. We define `f(n)` as the number of ways you climb to the `n`th step from:

1. one step from `n-1`th step or,
1. two steps from `n-2`th steps.

Therefore, `f(n) = f(n-1) + f(n-2)`, which is the same as the Fibonacci sequence. We have two bases cases: `f(1) = 1` and `f(2) = 2`. The lines 4 and 5 are the first two numbers of the Fibonacci sequence. To get the nth number, we add up the numbers up to nth number. Here, we optimize the performance the just storing the previous two numbers.

_Time complexity_: `O(n)`

_Extra memory_: `O(1)`
What Is An ISF File And Why Would You Want To Use It?
Tags: isf, opengl, glsl, mmv
Published: 2019-03-13 00:36:58

---
title: What Is An ISF File And Why Would You Want To Use It?
published: true
description: 
tags: ISF, OpenGL,GLSL,MMV
---

#What is an ISF file?
ISF stands for Interactive Shader Format, it is an extension of the language GLSL that adds interactivity and dynamics. GLSL is a language created to interact directly with the gpu, commonly used to render images and videos based on complex mathematical formulas. ISF was created by the Company VidVox, which is an industry leader for creating live animations. 
<br>    ISF adds that interactivity by letting you alter the variables that feed the formulas in real time. 
<br>    ISF is very versatile in what it can do, from color correcting an existing photo or video to generating complex 3d fractals. Additionally, in your host program, you can chain ISF files together to create complex scenes that one file couldn’t do alone. 
<br>    You don’t need to know how to program an ISF file to be able to use them effectively

##Some Neat Examples
[Color Correction](https://www.interactiveshaderformat.com/sketches/27)
[Fractal 1](https://www.interactiveshaderformat.com/sketches/2291)
[Fractal 2](https://www.interactiveshaderformat.com/sketches/2119)
[Voronai](https://www.interactiveshaderformat.com/sketches/1792)


#Why would you want to use an ISF file over a pre-rendered animation?

1. ISF files are relatively lightweight, file sizes are usually less than 10kb, and it is essentially just a text file. When presenting visuals, you want to be able to run them as close to 60fps as possible, since ISF files are all mathematical formulas and GPUs are very good at calculating straight math, these files can run very fast.

2. ISF files can render images/videos that are very hard to replicate in 2d or 3d animation programs, particularly fractals. Some rendering engines such as Octane has experimental features for creating fractal meshes, however it still takes a screipt file that is very similar to openGL files

3. ISF files are dynamic. You can change the variables that feed the formula in real time. Your host program will be able to map values to those variables from stuff such as a knob on your controller or an audio frequency analysis

4. ISF files can loop seamlessly and indefinitly (or as long as your floats can be). Some files do break as they approach infinity, however this is more likely the formula breaking and not the framework.

5. ISF files can work on their own or input a photo or video

6. ISF files have a small but highly dedicated community with incrediably smart members

7. ISF files can do everything OpenGL can plus more.

#Where would you see an ISF file being used?

You probably wouldn’t see an ISF file or openGL shader used in a high level production (Think Bonnaroo or Coachella). You are much more likely to find them in productions run by a smaller community, think Burning Man or small tier music/art festivals
    Often these files are used as a visualizer for music or as part of a visualizer. A branch of this is Live Coding, where you write the file as it’s rendering.
AWS ALB routing based on HTTP method
Tags: aws, alb, loadbalancer, http
Published: 2019-03-12 23:46:11

tldr;- It's not possible at this moment.

The new AWS ALB has more flexible way to route incoming requests compared to ELB classic but still fell short. It only support path or host based routing. So you can route requests to `/customers/logs/` and `/customers/orders/` to different target group, like different cluster of ec2 instances.

But it's not possible to route based on http method, like `POST /customers/orders/` and `GET /customers/orders/` to different target. One practical use case is when `GET /customers/orders/` will be resources intensive and you want to segregate the requests to avoid impact on other parts of your services.

Today, a friend also shared about load balancer from the guy at Gojek (ride hailing services in Indonesia) called [Weaver][1]. It seem to support method based routing:-

```
{
  "id": "gojek_hello",
  "criterion" : "Method(`POST`) && Path(`/gojek/hello-service`)",
  "endpoint" : {
    "shard_expr": ".serviceType",
    "matcher": "body",
    "shard_func": "lookup",
    "shard_config": {
      "999": {
        "backend_name": "hello_backend",
        "backend":"http://hello.golabs.io"
      }
    }
  }
}
```

The criterion expressed based on [Vulcand Routing][2], which is another load balancer from MailGun. The vulcand documentation say:-

>package route provides http package-compatible routing library. It can route http requests by hostname, method, path and headers.

And that's all for my own notes.

Image credit to https://www.flickr.com/photos/small_realm/14699606019.

[1]:https://github.com/gojektech/weaver
[2]:https://godoc.org/github.com/vulcand/route
Community Bridge – community maintenance and funding for OSS?
Tags: discuss, community, opensource, webdev
Published: 2019-03-12 23:02:48

---
title: Community Bridge – community maintenance and funding for OSS?
published: true
description: The Linux Foundation just shipped Community Bridge as a way to fund OSS, improve security, and grow communities. What do you think?
tags: discuss, community, opensource, webdev
---

Today at their Open-source Leadership Summit event, the Linux Foundation shipped a new project called Community Bridge.

You can find the project on its site: https://communitybridge.org/

I've yet to form an opinion about it. It seems like their attempt to build something like OpenCollective... but different? I'm curious: what are your initial thoughts?
React SSR fetch per components
Tags: react, ssr
Published: 2019-03-12 22:22:38

---
title: React SSR fetch per components
published: true
description: React SSR fetch per components
tags: react, ssr
---

Hi folk!

After a lots of googling and reading regarding the best way to handle fetch per components in a SSR way I came to the conclusion that I need some React community help hehe.

I tested razzle, nextjs, custom setup with express... and all the approaches follow the same pattern;

1 Fetch all you data and 
2 pass it to the <app> 
3 render to string ...
4 hydrate, _initial_state_ ... etc etc

However, there is something that I do not like with this approach. I did a lot of SPA project in the past without caring about seo and being able to share page on facebook nor twitter, having Helmet changing my meta on the fly...

But now, with this ssr way to do thing, not being able to fetch data in my component constructor... I feel that I have to break the way I am doing stuff.

So the question, is there a way, to have a none ssr react spa project transfers to ssr without having to fetch all my data at the begining if favor to a per components approach like I did without ssr.

side note:
The closest I get is a try with JSDOM, where I am able to use Render( from react-dom in the server instead of renderToString... the downside with this approach is that I did not see any blog post exposing this approach. the other downside is I cannot know when all the components are done with theirs fetching, so I have to embed everything in a ; setTimeOut with a exagerated delay to be sure everything is done.

Thank you
A Water Filling d3.js Visualization
Tags: javascript, d3
Published: 2019-03-12 20:30:32

---
title: A Water Filling d3.js Visualization
published: true
description: A little fun with a JavaScript water-gauge visualization
tags: js, d3
---

I stumbled across a really oddball JavaScript visualization that probably doesn't have a whole range of uses. But in the world we live in nowadays, AI technology and home-smart devices, I thought of a perfect use-case.

Let's imagine your house combi-boiler (this is what they're called in the UK) is linked to your home internet. Then, you actually had access to its data, namely, how much water is currently being pumped through due to the load-request from the taps!

With this single value of data, you could build the following JavaScript visualization on your own personal Home-Dashboard.

<h3>Water Load Gauge</h3>
<b> Hit the switch to turn on the water! </b>

{% codepen https://codepen.io/DanEnglishby/pen/ZPJQjq %}


By using a little d3.js and an additional community plugin, this brilliant little visualization can be achieved.


For reference, the JS used to produce this visualization are found in the following links - 

[d3.js](https://d3js.org/d3.v3.min.js)
[brattonc liquidFillGauge.js](https://bl.ocks.org//raw/5e5ce9beee483220e2f6/4c2e1e4b0ed515d9d9de26d0996519fc16c2ae43/liquidFillGauge.js)

And credit to prakash27dec for the toggle switch snippet which can be found here - 
[prakash27dec toggle switch](https://bootsnipp.com/snippets/z8b8y)

Enjoy
Organizational Tip for Gradle
Tags: android, gradle, mobiledev, tutorial
Published: 2019-03-12 20:54:31

---
title: Organizational Tip for Gradle
published: true
description: 
tags: #android #gradle #mobiledev #tutorial
cover_image: https://thepracticaldev.s3.amazonaws.com/i/n72nwf92auwdy5zde7qx.jpeg
---

If you're anything like me, Gradle can be a bit of a mystery at times. I'm trying to better understand it and what kinds of things I can do to make it my own! 

Here's the TL;DR that I included in my post:

1) Create a libraries.gradle file in your root project folder

2) In your project-level gradle, write apply from: 'libraries.gradle' above the buildscript block

3) Declare your dependencies in libraries.gradle, using `ext.versions` for the version codes, `ext.libraries` for the gradle artifacts, and `ext.libPacks` for the implementation groups

4) To use in your module’s build.gradle file in the dependencies block, all you need to do is write libPack.retrofit or libPack.glide


A little more longwinded explanation is here: https://medium.com/@cor.johnson/a-simple-way-to-improve-your-android-build-gradle-files-c7325731b3ea

---- 

If anyone has any other awesome tricks they use, I'd love to hear about them!
Phpstorm Laravel Snippets
Tags: opensource, phpstormlaravel
Published: 2019-03-12 20:38:40

---
title: Phpstorm Laravel Snippets
published: true
description: Phpstorm Laravel Snippets
tags: opensource, Phpstorm Laravel,
---


[Documentation](https://github.com/Alicannklc/phpstorm-laravel-snippets/blob/master/README.md)


[Plugin Url](https://plugins.jetbrains.com/plugin/10928-laravel-snippets)


* Auth
* Cache
* Console
* Config
* Cookie
* Crypt
* DB
* Eloquent
* Event
* Hash
* Helper
* Input
* Log
* Mail
* Redirect
* Relation
* Request
* Response
* Route
* Schema
* Session
* Storage
* View
* Validator