teleren/devto huggingface dataset:
How much time do we stay in a company ?
Tags: career, discuss
Published: 2019-01-07 17:55:36

---
title: How much time do we stay in a company ?
published: true
description: I often get the feeling that developers don't stay too long in the same company, but I'd like to know what the facts say
tags: #career, #discuss
---

Hello, I'd just like to know if you have any good statistics concerning this question : 

_What is the average time a developer stays in the same company ?_

I'm asking this question because I often get the feeling that developers don't stay too long in the same company, but I'd like to know if there are any statistics I could look to find out whether this feeling is true or not (and to what extent it is far or near from the truth).  

I'm more interested in statistics where the developer chose to left (i.e had the choice to stay but decided to leave, wasn't fired or the company went bankrupt or something of the same kind).  

I thought this would be the best place to get some answers, and I'd like to know if you would by chance have any resource I could look upon.  

Also, on a related note, am I the only one with this feeling or is it something other people here think as well ? 

Thank you for your time.

PS : _I'm not a native speaker, please feel free to correct my mistakes in this post._
Ruby Contracts:  Best of Both Worlds
Tags: ruby, gems, contracts
Published: 2019-01-07 17:49:09

---
title: Ruby Contracts:  Best of Both Worlds
published: true
description: 
tags: ruby, gems, contracts
---

Among the many flame-wars in the developer community is the one about typing:  static vs. dynamic.

In Ruby, we can have the best of both worlds, via gem <code>contracts</code>.

I was going to write about this powerful and flexible gem here, but on second thought will just link to this [excellent page](http://egonschiele.github.io/contracts.ruby/) by the gem's [author](https://github.com/egonSchiele).
What can I do to help my engineering team as a PM?
Tags: discuss
Published: 2019-01-07 17:47:11

---
title: What can I do to help my engineering team as a PM?
published: true
tags: discuss
---
Hey dev.to,

I wanted to get your take on the following observations I've had as a PM in large mega-corporation as we as startups. I figured most people on this site are developers, and could possibly help me understand the following behaviors I see from under performing engineering teams. I'd love to learn what I can do better to help the team win!

In the 4 years I've been a PM, I've had the privilege of working with some really stellar engineering teams. I've also worked with some not-so-stellar ones. The great teams are usually great because we're all communicating and trusting each other enough to enable decentralized decision making. When a team member gets out of sync, they quickly come up to speed and don't freak out if they disagree with a decision that's been made. Part of that is because the team is gelling on a personal level, but also because there's precedent for decisions to be revisited when new data is found.

With the teams where we've struggled, I've noticed the following failure modes can lead to our downfall.

First, there's a mode where the team either is very junior or lives inside an organization with a cover-your-ass culture. Either way, people are scared to commit to dates, goals, or even design decisions. If a team member is really into agile, I hear a lot of, "We're agile - we don't do dates" or "It's not agile to make commitments like this". I'm totally bought into customer obsessive, iterative development, but comments like these in this context make it seem like team members are using agile dogma to enable their pathologies.

Because the technical team members don't want to make decisions, I end up having to spend a ton of time with the entire team getting everyone to come to consensus. I'm afraid that the resulting work is a product of design by committee thinking.

The worst part about this is after we've supposedly come to an agreement, team members seem to have sudden onset amnesia, even if I send out an email summarizing what we agreed to afterwards. The next day or week, we'll be in standup or retro and someone will be shocked to learn that a customer is expecting "feature X" in March 2019.

So, my question to you guys here is: As engineers, have you seen or experienced teams who've fallen into the patterns as I described, and if so, how has the PM contributed to those issues?
Find a Specific Column In An Unknown SQL Table
Tags: sql, table, data, database
Published: 2019-01-07 16:40:14

---
title: Find a Specific Column In An Unknown SQL Table
published: true
description: My weekly blog post describing how I resolved the issue of finding a column I needed in my company's SQL database without knowing which table it resides in.
tags: SQL, table, data, database
---

My company uses Aptean Intuitive ERP as part of our sales processing system and the "middle man" between Intuitive and our processing applications is the SQL database. Our homegrown processor application takes in data from the inbound sales files, inserts the data into the corresponding SQL columns and creates PDF item and sales order files, then Intuitive processes these PDF files and inserts data into the system.

One of my tasks this week was to add Discounts to this chain of events because in its current state the manager must go in and manually update the tables and Intuitive for each order with a discount.

To accomplish this task I first determined where discounts were being managed in Intuitive and what their corresponding column names were so I could make sure the proper table values were being updated when the incoming sales file is processed. After determining the column names I came upon the question I've never had to ask before, "how do I determine which table holds a specific column without searching through all 100+ tables manually?"

After a little digging I discovered a solution that can be done in a rather simple SQL query:
    *&emsp;SELECT 
	&emsp;&emsp;c.name AS 'ColumnName'
	&emsp;&emsp;,t.name AS 'TableName'
    &emsp;FROM
	&emsp;&emsp;sys.columns c
    &emsp;JOIN
	&emsp;&emsp;sys.tables t ON c.object_id = t.object_id
    &emsp;WHERE
	&emsp;&emsp;c.name LIKE '%SOD_DiscPercent%'
    &emsp;ORDER BY
	&emsp;&emsp;TableName, ColumnName*

To break down this query a bit:
&emsp;sys.columns returns a row for each column of a table or view
&emsp;sys.tables returns a row for each table

Joining sys.columns and sys.tables on the object ID and filtering by the column name lets us use our known column to determine which table it belongs to. Using SELECT all would show even more information about your table and column, but for this example I was only concerned with getting a table name.

Using this query I was able to determine which tables need to be updated in the processor application before the item and sales order PDFs are created so the proper fields are updated once it reaches Intuitive.
Navigate apps like Vim on Mac
Tags: macos, vim, lua
Published: 2019-01-07 16:11:06

---
title: Navigate apps like Vim on Mac
published: true
description: Hammer-vim, make every app works like Vim on Mac OS
tags: MacOS, Vim, Lua
---
*Open source repo:*
https://github.com/dashengSun/hammer-vim
Redux - a persistent question
Tags: react, redux, javascript
Published: 2019-01-07 16:08:19

---
title: Redux - a persistent question
published: true
description: 
tags: React, Redux, JavaScript
---

*This article was originally posted [here](https://medium.com/@geojow/redux-a-persistent-question-df5bb15373e8)*.

>Redux is a predictable state container for JavaScript apps. - redux.js.org

As a relative newcomer to all things web development, I came across Redux mere seconds after I started using React.

After what I would say is a fairly steep learning curve, having only just been introduced to state and props, I slowly but surely began to understand how to use Redux, and why it is such a useful weapon when developing web apps.

And that is where my troubles started, I fell into a Redux quicksand of sorts. Every new component I created had its own Redux store. Every single API call had at least one Redux action, and I was forever calling 'SetCurrentUser', or 'ClearCurrentUser' actions just to keep track of things!

>Just because you can, doesn't mean you should

I had built multiple redux stores, all with the same functionality for slightly different components, my redux folder was becoming bloated, and sure, my component files were nice and slimline, but at what cost.

So now when I create a new component, and I reason as to whether to Reduxify it, I as myself the following:

>Do I need the data from the page to persist when I navigate away? Or can I just make the call again when I come back to the page?

More often than not, the answer (to the first part of the question!) is no! And I can just use the components state to handle the data.

I now use Redux for things like Auth, and Permissions, bits of data that I need in more than one place.

This is a massive oversimplification of a complex topic and there are many great articles out there about it, but this is my hot take and a great place to start.
Multi-tabs, Flickity gallery, Purchase cards & more | Module Monday 24
Tags: showdev, opensource, webdev, javascript
Published: 2019-01-07 15:51:30

---
title: Multi-tabs, Flickity gallery, Purchase cards & more | Module Monday 24
published: true
description: Module Monday 24
tags: showdev, opensource, webdev, javascript
cover_image: https://res.cloudinary.com/component/image/upload/v1546643514/tabs_hermtn.gif
canonical_url: https://guide.anymod.com/module-monday/24.html
---

## Open-source mods for your next project

Everything below is open source and free to use on any website, web app, or anywhere else. [Anymod](https://anymod.com) has hundreds more like these.

Click a mod to see it along with its source code.

### Tabbed multi section
Colorful top section with multi-tabbed content below.

<a class="btn btn-sm" href="https://anymod.com/mod/raaaar?v=20">View mod</a>

<a href="https://anymod.com/mod/raaaar?v=20">
  <img src="https://res.cloudinary.com/component/image/upload/v1546643514/tabs_hermtn.gif"/>
</a>

### Purchase cards
Easy call-to-action for purchase.

<a class="btn btn-sm" href="https://anymod.com/mod/lllllo?v=20">View mod</a>

<a href="https://anymod.com/mod/lllllo?v=20">
  <img src="https://res.cloudinary.com/component/image/upload/v1546640793/cards_aat5ue.png"/>
</a>

### Flickity gallery
Swipe gesture enabled gallery with responsive images.

<a class="btn btn-sm" href="https://anymod.com/mod/orrrrn?v=20">View mod</a>

<a href="https://anymod.com/mod/orrrrn?v=20">
  <img src="https://res.cloudinary.com/component/image/upload/v1546644904/gallery_yvoxlm.gif"/>
</a>

### Hero background section
Show off your work with a hero unit.

<a class="btn btn-sm" href="https://anymod.com/mod/nkkkka?v=20">View mod</a>

<a href="https://anymod.com/mod/nkkkka?v=20">
  <img src="https://res.cloudinary.com/component/image/upload/v1546639613/hero-section_v9lxbt.png"/>
</a>

### Quote with border
A simple quotation block with borders before and after.

<a class="btn btn-sm" href="https://anymod.com/mod/baaaao?v=20">View mod</a>

<a href="https://anymod.com/mod/baaaao?v=20">
  <img src="https://res.cloudinary.com/component/image/upload/v1546642323/blockquote_azaxmf.png"/>
</a>

<hr>

I post new mods [here](https://dev.to/tyrw) every (Module) Monday -- I hope you find them useful!

Happy coding ✌️
Consistency Pays Off
Tags: entrepreneurship, productdevelopment, consistency, valuefirst
Published: 2019-01-07 15:42:49

---
title: Consistency Pays Off
published: true
description: 
tags: entrepreneurship,productdevelopment,consistency,valuefirst
---
![Consistency Pays Off](https://thepracticaldev.s3.amazonaws.com/i/vf7mz7d803ezcroj6tuy.png "Consistency Pays Off")

If you have any goals that you want to reach, consistency is key. Do you want to grow an audience, sell a product, make a brand of your own identity? Consistency pays off. For real.

By being consistent (performing the same amount of effort in a frequent, predictable way) you'll be able to make your audience grow. It is what drives steady growth. 

Don't expect this to be a quick hack though. It is something that you need to do on the mid-long to long term.

Consistent effort lets your target audience adapt to your message. It is what lets them get known with your products and services. 

My advice to maximize the efficiency for your consistent efforts:
- Keep your message real
- Don't broadcast, connect with your audience and target market
- Don't go performing sales, but provide value instead

Read in more depth on how consistency might pay off for you at https://www.shipharder.com/consistency-pays-off.
#shipharder #entrepreneur #learn #valuefirst #developer #entrepreneurlife #productdevelopment #startuplife #bootstrapping #makers
Full Regression
Tags: testing
Published: 2019-01-07 15:27:20

---
title: Full Regression
published: true
description: One thing I've come to realize in software testing is to never entertain the idea of a full regression.
tags: testing
canonical_url: https://he-the-great.livejournal.com/60231.html
---

One thing I've come to realize in software testing is to never entertain the idea of a full regression. The idea behind a full regression is to collect a set of test which cover the software's functionality to be confident it can perform the defined behaviors.

The problem comes from expectations, that all test ever run will be run again, after all we said full didn't we. In an agile environment with mid-sprint, when to run this full regression also becomes a question.

Personally I'm also leaning away from this concept of defined regression testing, at least outside automated verification. Following changes and targeted exploratory testing should be preferred.
GraphQL vs REST: Performance
Tags: graphql, webdev, beginners, node
Published: 2019-01-07 14:13:41

---
title: GraphQL vs REST: Performance
published: true
description: let's talk about GraphQL vs REST in terms of performance
tags: graphql,webdev,beginners,node
canonical_url: https://blog.graphqleditor.com/graphql-vs-rest-performance
---


This time let’s take a look at another important aspect of [GraphQL](https://blog.graphqleditor.com/graphql-vs-rest-performance/) vs REST discussion - the PERFORMANCE.


## GraphQL vs REST ;  Performance vs Reliability 

The main [GraphQL](https://blog.graphqleditor.com/grapqhl-vs-rest-caching/) quality is being less loquacious than traditional [REST API](https://www.restapitutorial.com/lessons/whatisrest.html).  GraphQL treats performance as its top priority while REST is focused on keeping services reliability as their main objective. Even if a REST API returns only a basic partial, it is still transferring more data, while GraphQL is always aiming for the smallest possible request. In an example, if the client needs a field, they request it, and if the API adds a new field, clients don't get it, unless it's being added into the GraphQL query.


## No wasted bits over the wire

You all have seen APIs where you need to `GET /author` first and then fetch each book individually via `GET /author/:id/books/:id` endpoint. This result in n+1 queries, a  well-known performance issue face in REST APIs.  While REST API calls are chained on the client side before the final representation can be formed for display, in GraphQL it's simplified by enabling the server to combined all the data for the client within a single query which results in fewer bits being transferred over the wire.

```graphql
{
  author (id: "1") {
    name
    book (id: "5") {
      title
    }
  }
}
```
```json
{
  "data": {
    "author: {
      "name": "George R.R. Martin",
      "book": [
        {
          "title": "A Dance with Dragons"
        }
      ]
    }
  }
}
```

## Conclusion

[GraphQL](https://graphql.org/) is faster than [REST](https://en.wikipedia.org/wiki/Representational_state_transfer) because as you can pick the fields you want to query, so the request will always be the smallest possible. Additionally, with GraphQL, you can enquire multiple entities in one request,  and because less bits will be transferred over the wire so your projects will perform faster than while using [REST](https://en.wikipedia.org/wiki/Representational_state_transfer).
Blockchain Usage as a Marketplace
Tags: marketplace, blockchain
Published: 2019-01-07 14:00:05

---
title: Blockchain Usage as a Marketplace
published: true
description: The creation of Amazon and eBay has changed the process of buying and selling goods. Buyers and seller have more opportunities today. 
tags: Marketplace, Blockchain
---

![Blockchain technology](https://thepracticaldev.s3.amazonaws.com/i/7jtsmcghfx5w0jm0j470.jpg)

Blockchain technology has forced the development of innovated cycle of the online sales. Markets receive additional and even revolutionary opportunities with it. The methods of the transactions are changed.  
Blockchain-based market is a platform technology that includes decentralized blocks using which both sides of money transactions can easily commit all the necessary operations without wasting time and paying for some meaningless services.   
Intermediaries got used to earn some money on their services but there is a proper way to commit the transactions without intermediaries and it is a plus. We save not only money, but time and protect our funds better. Blockchain market simplifies life for sellers, consumers, manufacturers.
At the web-page how to use blockchain technology as a market place http://merehead.com/blog/how-to-use-blockchain-as-a-marketplace/ one could read in details all the peculiarities and advantages of this technology. Even vendors but not only sellers or consumers receive pluses using it in the market. The customers could make the best purchases at the best prices and all the participants of the market receive the optimized solutions for themselves.
Blockchain technology has given an opportunity to track all transactions in public access. The level of transparency and security has increased by times. More that this technology includes intelligent digital agreements, for example digital signature. It helps prevent fraud. The products and services for which we pay and which we offer receive a new high level of trust and quality. No restrictions, no swindlers, no wasting money and time – this is the result of the usage of the blockchain in the market.
What is one essential item in your backpack or computer bag?
Tags: discuss
Published: 2019-01-07 13:53:01

---
title: What is one essential item in your backpack or computer bag?
published: true
description: 
tags: discuss
cover_image: https://thepracticaldev.s3.amazonaws.com/i/7ps8bb0ugws5pukyvdgo.jpeg
---

What is one unexpected item that you always keep with you in your back pack or computer bag? Something that others might not expect but is a huge help to you in your every day routine or just something that you don't want to be caught without?

Mine: [Wrist wraps for carpal tunnel](https://www.amazon.com/Mueller-Fitted-Wrist-Brace-Medium/dp/B002NLGNW8/ref=sr_1_3_a_it?ie=UTF8&qid=1546868686&sr=8-3&keywords=wrist+wraps+for+carpal+tunnel). I keep two of these on me at all times so I never have an excuse to type for extended periods of time without them.
Gatsby and WordPress: Summary
Tags: wordpress, gatsby
Published: 2019-01-06 10:56:13

---
title: Gatsby and WordPress: Summary
published: true
tags: wordpress, gatsby
canonical_url: https://booyaa.wtf/2019/gatsby-wordpress-summary
cover_image: https://thepracticaldev.s3.amazonaws.com/i/mouhxvws4jak9ar3xc5v.png
series: Gatsby x WordPress
---
_Photo by Marvin Meyer on [Unsplash](https://unsplash.com/photos/VvKdB1FYNZs)_

We've reached the end of our blog series, so what have we learnt?

- Gatsby has a great starter template that is highly performant (`gatsby new`). Whilst it's React based, the organisation of resources (components, images, pages, templates) made it fairly intuitive to edit or create new items.
- The build system allows you to get immediate feedback on your changes via live reloading. (`gatsby develop`)
- The Gatsby plugin ecosystem is healthy and provides us with many ways to pull in content to our site.
- The builtin GraphQL explorer (GraphiQL) allow us to query the WordPress data that we pulled in.
- The Gatsby APIs are powerful, but we didn't get overwhelmed by them as we only needed to know about [`createPages`](https://www.gatsbyjs.org/docs/node-apis/#createPages).
- Netlify took a lot of the hard work in continuously deploy new versions of our site.
- Using webhooks we can wire up WordPress and our site on Netlify.

In case you're still puzzling over the blog post title: Keeping it cheap and staying in touch.

- We kept it cheap by using a free blog on [WordPress.com](https://wordpress.com) and free hosting via [Netlify](https://www.netlify.com/).
- We stayed in touch by using the webhook on event feature that comes with WordPress.

There's still so much we haven't covered:

- Creating pages based on tags, categories, media, users, taxonomies or custom post types.
- Provide replacements for shortcodes, user comments and search.
- Image processing (which in turn requires the use of the ACF Entities (Advanced Custom Fields) WordPress Plugin).
- Authentication to have content for signed up members of your site.

Thank you for finishing this series! Please let me know if there are other topics you'd like me to cover around the Gatsby WordPress plugin.

_To go to another part of the series, click on any of the grey dots below which is next to the current marker (the black dot)._
Tea Break Challenge Day #6 + Day #7
Tags: career, softskills
Published: 2019-01-07 13:17:25

---
title: Tea Break Challenge Day #6 + Day #7
published: true
description: Cleanup and Focus
tags: career, softskills
---

### Day #6

Today, take 5 minutes to clean something around you. This could be your inbox, or it could be making your bed. The simple act of doing something positive for your environment can have a positive effect on your mood and productivity.

http://tea.is/d/6


### Day #7

Your challenge today is to abstain from all social media for at least one full hour, and focus on something (anything) else for that full hour. Your focus does not have to be on code; the goal here is to get better at focusing, not to do “more work.”

http://tea.is/d/6
Webpack and puppeteer
Tags: help, javascript
Published: 2019-01-07 13:10:45

---
title: Webpack and puppeteer
published: true
description: how can they work together?
tags: #help #javascript
---

What is the right way of using this two together?

I've been searching for a little while and so far the options that I've come across are

 - [Karma](https://github.com/karma-runner/karma)
 - [poi](https://github.com/egoist/poi) with a [plugin](https://github.com/egoist/poi/tree/master/plugins/puppet) (more info [here](https://dev.to/egoist/easy-browser-testing-with-poi-and-puppeteer-18ah))

And this, but it doesn't use webpack.
 - [puppet-run](https://github.com/andywer/puppet-run)

Based on the poi plugin I made one for webpack (it's [here](https://gist.github.com/VonHeikemen/6ec3543c4229e98963fd376f522bd81b)), so far it works perfectly for my use case, but I still wonder if there is another way.
Webassembly using Rust
Tags: webassembly, rust, javascript, node
Published: 2019-01-07 12:54:50

---
title: Webassembly using Rust
published: true
description: We talk about how to use Rust to write webassembly code and build a small game of life example.
tags: webassembly, rust, javascript, node
---

{% youtube tuKZWlrP9NM %}