teleren/devto huggingface dataset:
Let's Know about  how much to remove a tree 

Tags: javascript
Published: 2022-02-07 10:55:14

Regardless of whether a tree is inclining, harmed, or simply in some unacceptable spot, a tree evacuation administration can chop it down and frequently discard it for you. Basically, tree expulsion occupations are evaluated dependent on the tallness of the tree, yet we'll go over some different elements that likewise sway tree evacuation costs.

How much to remove a tree?

For the answer of **[how much to remove a tree](https://ventuneac.net/cost-to-remove-a-tree/)**, you can hope to pay somewhere in the range of $150 and $2,000 for tree expulsion administrations, however the normal expense to eliminate a tree is in the $700–$750 territory. Tree evacuation costs rely upon the size of the tree being referred to, and huge trees, as a general rule, cost more to eliminate than little ones.

You might observe that while guessing how much to remove a tree, tree expulsion administrations ready to do the occupation for as little as possible, yet consistently ensure you're recruiting a guaranteed arborist who is safeguarded for tree evacuation. Indeed, even positions that seem straightforward can have unanticipated complexities or long haul outcomes, so don't leave the wellbeing of your property and the soundness of your finishing to risk. Arborists should recharge their licences consistently, so they get continuous preparation in prescribed procedures for tree evacuation.

Kind of Tree

Two trees of generally a similar stature and trunk distance across will ordinarily cost with regards to something similar to eliminate, regardless of whether they're various species. Hence, size is a more solid determinant of cost than tree type. Here is a speedy manual for some normal kinds of trees.

An experienced oak tree is 60–80 feet tall and will normally cost $700 to $1,300 to eliminate and it is how much to remove a tree.
Palm trees change significantly in stature depending on the species, yet their trunks aren't exceptionally thick. Along these lines, they cost about $200 to $900 to eliminate.
The 100+ types of trees in the pine family can develop to just five feet tall to well more than 90 feet, so the overall value range for tree evacuation is somewhere in the range of $150 and $2,000.

Cedar trees can fluctuate in stature so extraordinarily that the expense for expulsion runs from $500 to $2,000.
Mature maple trees can develop to 60–100 feet and are normally very costly to eliminate, ordinarily costing somewhere in the range of $1,100 and $2,000.
Update-informer: a highly customizable Rust library for CLI apps
Tags: opensource, rust, webdev, programming
Published: 2022-02-07 10:07:26

Update-informer allows you to automatically check for new versions on resources like Crates.io and GitHub. Crates.io is the Rust community's crate registry, the main resource where all projects, libraries, etc. are stored.

When you add the update-informer library in your CLI application, which runs in the console, it periodically (for example, once a day) checks to see if a new version has been released. If one is out, then update-informer sends a message to the console like, “A new release is available, update with this link.”

[Read here how to install it!](https://evrone.com/update-informer)
Live reload tool for Go application
Tags: opensource, go, linux, tooling
Published: 2022-02-07 09:33:50

## [air](https://github.com/cosmtrek/air)
<span><strong><i class="fa fa-star">Star 5.8k</i> <i class="fa fa-eye">Watch 47</i> <i class="fa fa-code-fork">Fork 407</i></strong></span>

Live reload for Go apps

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xdghw2w0ouygxncoa0ae.png)

## Motivation

When I get started with developing websites in Go and [gin](https://github.com/gin-gonic/gin) framework, it's a pity that gin lacks live-reloading function. In fact, I tried [fresh](https://github.com/pilu/fresh) and it seems not much flexible, so I intended to rewrite it in a better way.
Finally, Air's born.
In addition, great thanks to [pilu](https://github.com/pilu), no fresh, no air :)

Air is yet another live-reloading command line utility for Go applications in development. Just `air` in your project root directory, leave it alone,
and focus on your code.

NOTE: This tool has nothing to do with hot-deploy for production.

## Features

* Colorful log output
* Customize build or binary command
* Support excluding subdirectories
* Allow watching new directories after Air started
* Better building process

## License
GNU General Public License v3.0
Simple command line video player
Tags: opensource, c, linux, github
Published: 2022-02-07 09:33:08

## [mpv](https://github.com/mpv-player/mpv)
<span><strong><i class="fa fa-star">Star 17.7k</i> <i class="fa fa-eye">Watch 476</i> <i class="fa fa-code-fork">Fork 2.2k</i></strong></span>

## Overview
mpv is a free (as in freedom) media player for the command line. It supports a wide variety of media file formats, audio and video codecs, and subtitle types.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qn8wcl8w3wnfqq3s9e10.jpeg)

## System requirements
- A not too ancient Linux, Windows 7 or later, or OSX 10.8 or later.
- A somewhat capable CPU. Hardware decoding might help if the CPU is too slow to decode video in realtime, but must be explicitly enabled with the --hwdec option.
- A not too crappy GPU. mpv's focus is not on power-efficient playback on embedded or integrated GPUs (for example, hardware decoding is not even enabled by default). Low power GPUs may cause issues like tearing, stutter, etc. The main video output uses shaders for video rendering and scaling, rather than GPU fixed function hardware. On Windows, you might want to make sure the graphics drivers are current. In some cases, ancient fallback video output methods can help (such as --vo=xv on Linux), but this use is not recommended or supported.

## License
GPLv2 "or later" by default, LGPLv2.1 "or later" with `--enable-lgpl`.
Interesting technical interview
Published: 2022-02-07 09:18:03

I had very good and enlightening technical interview with IT company from Cracov last thursday. I learned that I must expand my knowledge about advanced React concepts. Now I'm working on creating React tutorial website. It will be live later this week. Cheers!

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zdu8xv5gw3gmj2mfbucc.gif)
SQL Duplicates
Tags: sql, duplicates, removing, postgres
Published: 2022-02-07 09:13:58

---
title: SQL Duplicates
published: true
description: Notes for myself on how I managed to do this.
tags: SQL, Duplicates, Removing, postgresql
cover_image: https://fdy-images.s3.eu-west-2.amazonaws.com/blogs/blurred_sql.png
---

## Disclaimer
This is a purely self serving article. I've had to do this a number of times and end up having to re-learn it all every time I've done it. SOOOOO this time I will drop some basics here as a reference for my failing memory but if it helps anybody else even better. It's not indented to be instructional or in anyway best practice so if you have issues or know of more appropriate ways please feel fee to drop things in the comments etc.

## The Problem
The key problem being addressed is a number of duplicate records that have found their way into our datasets. These duplicates are matched on the master record id and the description used in the child example  

| id | parentId | description |
| ------------- |:-------------:| -----:|
| 1      | P1 | this is ok|
| 2      | P1  |   I'm here twice |
| 3 | P1      |    I'm here twice |

## Breaking it down
So the first thing I did was a query that will actualy help me find the rows I was looking for and the proof there are actual duplicates.

```sql
select "parentId",
       id,
       description,
       row_number()
       over (partition by "parentId", description order by "parentId", overview) as RN
from "Detail"
```
This produces results like these

| id | parentId | description | RN |
| ------------- |:-------------:| -----:|  -----:|
| 1      | P1 | this is ok| 1 |
| 2      | P1  |   I'm here twice | 1 |
| 3 | P1      |    I'm here twice | 2 |

So we now have a row id/number based on the parentId and the description matching.

We then use this in the delete query to kill al the row numbers over 1

```sql
delete
from "Detail"
where id in (
    select id
    from (
             select "parentId",
                    id,
                    description,
                    row_number()
                    over (partition by "parentId", description order by "parentId", overview) as RN
             from "Detail"
         ) as F
    where RN > 1
);
```
This is probably a convoluted way to achieve this and I'm sure there will be more efficient way but it has worked for me in this occasion so I hope it helps others.

Running the previous query then results in 

| id | parentId | description | RN |
| ------------- |:-------------:| -----:|  -----:|
| 1      | P1 | this is ok| 1 |
| 2      | P1  |   I'm here twice | 1 |
Want to become a successful DevOps Engineer?
Tags: devops, culture, automation
Published: 2022-02-07 08:37:18

DevOps is not just merging teams (developers, operations, and everything in between) into one, neither is it just the tools/technology. DevOps is a cultural shift, where people, practices, and tools are united to enable continuous delivery of value end-users.

_Continuous Value!_

What’s a great product without (great) customers? “Users want it all and want it now”.

DevOps seeks to continuously integrate feedback from users in order to continuously deliver value. Besides learning the tools, a successful DevOps engineer must understand the principles that enable DevOps. 

### Principles Of A DevOps Engineer — CAMS

**1. Culture**: DevOps, like Agile, is product-oriented, and this means that all the parts that make up a product must collaborate and not be siloed (the DevOps engineer must be able to communicate effectively in order to be able to collaborate). Some organizations have employed the use of Slack for creating a safe and transparent space for collaboration.

**2. Automation**: A DevOps engineer must be able to identify manual, repetitive, and time-consuming tasks (referred to as toil) in the product development cycle and seek to automate them so that teams can focus on other things that are in their nature can (should) not be automated. In addition, the everything-as-code mentality behind automation helps to ensure that the systems that are built are reliable and changes can be easily tracked when the code is checked into version control for example.

**3. Measurement**: Knowing what works well and what is failing is very important to the DevOps engineer. Without measurement, there can’t be improvement and without improvements, we cannot continuously deliver value.

**4. Sharing**: The union of people means a shared goal and shared responsibilities. Sharing is fundamental for effective collaboration. The DevOps engineer needs not be the very best at both development and operations, rather a culture of sharing is encouraged across teams.




Follow me on [Twitter @Ileriayooo](https://twitter.com/Ileriayooo) for more on Tech and Opportunities.

If you want to be successful in tech, [here is a simple framework](https://twitter.com/Ileriayooo/status/1490416597596614660).
Career Interests
Tags: career, opensource, linux
Published: 2022-02-07 08:34:32

Hello everyone!

In this blog, I will be discussing my career interests and what I plan to pursue after the end of my internship.

## What comes next after the internship
I believe I am writing this a little more enlightened and a little more ready for the next stage of my career. After working a while with the KernelCI project I fell more in love with the open source community and I would love to work on opensource projects at a professional level.

## What I am looking for 
Prior to starting my internship, I have worked as a Python developer for over three years. My last work involved building a SAAS(Software as A Service) application with Python and Django Framework. Then I decided to explore working in the open source community because that is where the future of software development lies 😊😊.

After my internship in March, I plan to look out for opportunities in the open source community. 
I am willing to relocate as I am currently in Nigeria, and would love to also work remotely if I get the opportunity to do that. 
I am looking for jobs mostly in Python, Site reliability engineering and Linux development, but I am willing to explore new areas, as this is what I love doing. 

You can find me on [Github](https://github.com/mharyam) or [LinkedIn](https://www.linkedin.com/in/maryam-yusuf/).
Use ios library or sdk into android project via React Native
Tags: reactnative, android, ios, javascript
Published: 2022-02-07 08:28:21

Hello Developers,

I have one situation. Need solution for that. Suppose I have iOS library which is coded in Objective-C or Swift programming language. Now I can use or import that library into my React Native project via bridge and setup my all my configurations. This will work on iOS device now. So now comes my actual question. Will this iOS library work on Android devices imported in React Native??

If yes, then can you please guide me how I can I make that possible?

Your response is truly appreciated.
Connect MySQL to Apache NetBeans 🚀
Tags: mysql, java, apachenetbean
Published: 2022-02-07 08:07:53

Hello Everyone, I hope all are doing extremely well 😊

**Prerequisite** 

- [Download Apache NetBeans](https://netbeans.apache.org/download/nb126/nb126.html)
- [Download MySQL](https://www.filehorse.com/download-mysql-64/)
- [Download MySQL connector jar file compatible with your MySQL version](https://jar-download.com/artifacts/mysql/mysql-connector-java)

Connect MySQL to Apache Netbeans it's too headache work but after reading this blog it's a cakewalk. Without wasting time let's get start.

**Step 1 -** Open Apache NetBeans and go to the service tab.



![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jwxpbb27o2cvt1m3pu3d.png)



**Step 2 -** Right click on **Databases** and then click on **New Connection**



![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/vn2fx2nxzge6buvdg8y5.png)



**Step 3 -** Export the downloaded connector folder then click on **add** button then select MySQL-connector jar file. Click on **Next** button.



![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1w9n2smb2fvq75bzwec6.png)



**Step 4 -** Enter your MySQL **username** and **password** (default username is root and port is 3306).



![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pzyi7mfachrexuxl4fqn.png)



After adding the credential you can test connection by click on **Test connection** button if all is working fine then you can click on **Finish** button. 

Happy coding....👍
Handling concurrent mysql transaction request with sequelize
Tags: javascript, sequelize, mysql, node
Published: 2022-02-07 08:05:12

In this post, I just wanna share my experience on handling hundreds of concurrent request on sql transaction using sequelize.

At first, when i build my application. There was no problem during the test. The problem comes when the third party that I want to integrate with is testing my app with a stress test.

And in a result, my app can't handle hundreds of concurrent request. There was no problem with the nodejs. The problem was when the app trying to get a connection from a database pool, but there was no released connection on the pool. Because it was all in use.

My db pool config was :

```
pool: {
      max: 38, // maximum number of pool connection
      min: 0,
      acquire: 60000, // 60 seconds acquire time
      idle: 5000, // 5 seconds idle time
    },
```

And here's the example code :
```
await Promise.all([
  User.findByPk(1, { transaction }),
  Gamelog.bulkCreate(gamelog, { transaction }),
  Balancelog.bulkCreate(balancelog, { transaction })
]);
```

The solution was quite simple, it was an issue from the sequelize itself. https://github.com/sequelize/sequelize/issues/11024

pool.max transactions can run simultaneously, and the (pool.max + 1) transaction will cause a deadlock which completely blocks new transactions.

So we can't use async/await on this scenario, rather we use promises.
```
sequelize.transaction(async transaction => {
  User.findByPk(1, { transaction });
  Gamelog.bulkCreate(gamelog, { transaction });
  Balancelog.bulkCreate(balancelog, { transaction });
})
.then(() => {
  return true
})
.catch(err => return false)
```
Metacortex Engineering: Meta needs Brain—Cortex
Tags: meta, enterprisearchitectu, metaverse, artificialintelligen
Published: 2022-08-17 09:10:03

---
title: Metacortex Engineering: Meta needs Brain—Cortex
published: true
date: 2022-02-07 08:03:39 UTC
tags: meta,enterprisearchitectu,metaverse,artificialintelligen
canonical_url: 
---

![](https://cdn-images-1.medium.com/max/1024/1*r3R-amPXmlFwcHq0MSQvJw.jpeg)
_Original Matrix — Metacortex building_

I see metacortex engineering combination of approaches AI, ethics, systems and enterprise engineering.

When everyone got excited about Meta and Metaverse, I thought two things:

1. We are behind in our exploitation of VR and AR, and we could build VR based interfaces for analysts and data scientists, turning them into Super Analysts. Technology has existed for the last ten years and nothing stops us from building interfaces inspired by Johny Mnemonic and Minority Report. I attempted to do it with The Pattern project and I am glad Facebook now drives traction towards it.

2. There is a lack of useful core in Meta(or web 3.0 discussions). However, I believe it’s solvable with the right application of known approaches in the wider industry: systems engineering (including cyber-physical systems), enterprise engineering (including the theory of constraints), ethics and AI technologies. For example, in a recent discussion, “integrity” or ethics of business model is part of organisation requirements for enterprise engineering. The role of AI can be to remind humans to make ethical decisions.

Name Metacortex featuring in the Matrix movie (respective software company), but the one I liked in Hannu Rajaniemi — Quantum Theif series, where metacortex is core of the collaborative network.

Join the discussion on [TOC and AI](https://lnkd.in/e2JCakQZ) LinkedIn or contribute your ideas to the open-source website [https://metacortex.engineering](https://metacortex.engineering), mind “engineering” bit — the thought or discussion should not be purely abstract, but lead to implementation in a physical world, even if there are gaps in technology.
A Fun Programming Joke To Start Your Day
Tags: jokes, dailydeveloperjokes
Published: 2022-02-07 08:00:29

---
title: "A Fun Programming Joke To Start Your Day"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
published: true
tags: #jokes, #dailydeveloperjokes
---

Hi there! Here's today's Daily Developer Joke. We hope you enjoy it; it's a good one.

![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e1258a3e5534.png)

---

For more jokes, and to submit your own joke to get featured, check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/). We're also open sourced, so feel free to view [our GitHub Profile](https://github.com/dailydeveloperjokes).

### Leave this post a ❤️ if you liked today's joke, and stay tuned for tomorrow's joke too!

_This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit._

<!--
Joke text:
___Q:___ Why did the developer ground their kid?

___A:___ They weren't telling the truthy
 -->
Send email with nodemailer
Published: 2022-02-07 08:00:18

Enable these 
[lesssecure](https://myaccount.google.com/lesssecureapps)
[DisplayUnlockCaptcha](https://accounts.google.com/b/0/DisplayUnlockCaptcha)
```
import nodemailer from "nodemailer";
async function sendEmail(to, subject, text) {
  try {
    const transport = nodemailer.createTransport({
      port: 587,
      host: "smtp.gmail.com",
      auth: {
        user: "<Your Email>",
        pass: "<Your Password>",
      },
    });
    const option = {
      from: "<Email>",
      to: to,
      subject: subject,
      text: text,
    };
    const result = await transport.sendMail(option);
    console.log("function", { result });
    return result;
  } catch (error) {
    return error;
  }
}
```
Cache Busting and Version Pinning when building Docker images
Tags: docker, cache, ubuntu, versionpinning
Published: 2022-02-07 07:30:56

Docker uses Layered Architecture. When using Docker files it creates a new layer in the image which adds additional space to the image based on the instructions for that layer.

When a Docker build command is run it proceeds from the first instruction in Docker file to the last while caching each stage so as if the build fails next time build uses cache until it ran succesully and invalidated the stage that failed and the following stage. Layers repurpose the previous layers and don't have to build all of them again.

In below example Docker file has 6 stages. Each stage will be cached when build command is ran.

Suppose a build fails at Stage 3 due to some reason or new package has to be added the Docker will invalidate the Stage 3 and the following stages

Next time when a issue is rectified the build command will repurpose the previuos layers and build the failed stages


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mma2qoj6j5q2jflit5gg.png)

But in this case the repository will not be update, so how to resolve or update the repository with the packages-
 
**Cache Busting**

In this case we can to combine the instructions so the repository is updated along with packages as below

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6g5n216kgvvw9gglxpdu.png)

Merging  Stage 2 and Stage 3 from the previous docker file in to single instruction will ensure the repository is first udpated and pakages are installed

Merging these stages is called as Cache Busting

**Version Pinning**

You can also explicity mention the version of package to be installed 

In stage 2 docker file is instrcuting to install python3-pip 21.3.1 version

Best Practice-

Instructions which are most frequently modified should be at the bottom of the file and the instructions which are least modified should be at the top of the docker file