teleren/devto huggingface dataset:
A one-liner that turns DUMPed table definitions in MySQL into a Confluence Wiki or Markdown notation
Tags: mysql, markdown
Published: 2020-11-02 11:39:07

---
title: A one-liner that turns DUMPed table definitions in MySQL into a Confluence Wiki or Markdown notation
published: true
description: one-liner to turn mysql table definitions into confluence wiki or markdown notation
tags: mysql, markdown
//cover_image: https://direct_url_to_image.jpg
---

I want to easily paste a DUMPed table definition in MySQL into Confluence. I'm sure you've had that happen to you.
I want to paste DUMPed table definitions in MySQL to Dev.to easily. I'm sure you have.

It's a bit tedious to write table definitions for a DB in a document to be delivered. It's not productive at all, and I want to get it done in one shot.

## Target

From

```
+--------------------+------------------+-----------------+------+-----+---------+-----------------------------+---------------------------------+--------------------------------------------------------+
| Field              | Type             | Collation       | Null | Key | Default | Extra                       | Privileges                      | Comment                                                |
+--------------------+------------------+-----------------+------+-----+---------+-----------------------------+---------------------------------+--------------------------------------------------------+
| id                 | int(10) unsigned | NULL            | NO   | PRI | NULL    | auto_increment              | select,insert,update,references | ID                                                     |
| name               | varchar(256)     | utf8_general_ci | YES  |     | NULL    |                             | select,insert,update,references | 名称                                                   |
+--------------------+------------------+-----------------+------+-----+---------+-----------------------------+---------------------------------+--------------------------------------------------------+
```

to

![Table View!](https://dev-to-uploads.s3.amazonaws.com/i/lvn2umrx7ixtaaljqdd3.png)

## One-liner

### Confluence Wiki

```
$ mysql -h (host) -u (user) -p (schema) -e 'show full columns from (table)' | sed 's/^/|/g;s/$/|/g;s/\t/ | /g;1 s/|/||/g'
```

### Markdown

```
$ mysql -h (host) -u (user) -p (schema) -e 'show full columns from (table)' | sed -E "s/^/\| /g;s/$/ \|/g;s/\t/ \| /g;1{h; p; s/\w+/:-:/g}"
```

By using xsel or pbcopy, save it in clipboard in one shot.
Was muss eine Lernplattform können?
Published: 2020-11-02 11:37:06

Die Art, wie wir lernen, hat sich in den vergangenen Jahren stark verändert. Durch das Internet stehen uns eine Fülle an Informationen jederzeit und überall zur Verfügung. Durch digitale Lernplattformen ist auch Bildung online gegangen. 
Doch es sind bei Weitem nicht alle Angebote passend. Was sollte eine gute Lernplattform können?

...

Weiter lesen: [Was muss eine Lernplattform können](https://kursprofi.com/lernplattform-koennen/)
The iOS 14 update adds a hidden, customizable iPhone button
Published: 2020-11-02 11:28:41

Just shortly after the release of iOS 14 for iPhones, developers found a new feature in the system that adds a lot of functionality to phones and can be easily customized. As the feature includes the phone's sensitivity to clicking on its back cover, and after activating it from the settings it is possible to customize the command so that you can tap twice on the back of the phone to operate the camera, or tap 3 times to swipe down or perhaps open the notification center.

The feature was not included in the announcement and details of the iOS 14 system, but if you have upgraded to this version you will be able to activate it under Settings, Accessibility Options, and then activate the "Back Tap" option. As there are several basic tasks available within the options, but with the feature being linked to the system's shortcuts application, it will be possible to place any task you want just clicks away on the back of the phone.

What is unique about this new feature is that it does not really need any additional hardware, but rather it depends on the phone’s sensitivity to movement through the acceleration and rotation sensors, and depending on the machine learning patterns, the phone can distinguish the intended clicks on the back of it and activate the required feature better and better with time.

It should be noted that a similar feature was available in the beta versions of the Android 11 system for the recent Pixel phones, but as it has become usual recently, the feature was removed without explaining the reason from the stable version of the system.
Use QuickOrgs to speed up scratch org creation
Tags: salesforce, sfdx, devops, dx
Published: 2020-11-02 09:35:49

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/81dixkqbf945test17y6.png)

Salesforce scratch orgs are a great developer tool for us Salesforce Developers but **they are slow**.

In fact, with multiple Managed Packages the scratch org creation and setup is so slow that I often see scratch orgs not being used at all or not as an org that can be scratched.

Many projects are relying on Managed Packages from the Salesforce AppExchange. To be able to develop inside a scratch org means that the development team needs to install these managed packages every time a scratch org is created.

This takes a **lot** of time.

It takes so long (for big packages like Salesforce's HealthCloud ~30min) that it often means it is unusable for Continuous Integration and as a throwaway org.

To be able to get an org that is ready to go with all underlying needs addressed (like installing Managed Packages, unlocked packages, and so on..) would save 1h **every** time.

And this is where QuickOrgs promises to come in.

QuickOrgs provides a simple way to create orgs with packages installed, ready to go to develop in, or run your Continuous Integration on.

If you would like to know more, sign up to the beta [here](https://quickorgs.webflow.io/) or comment below.
Where do you get illustrations?
Tags: webdev, watercooler, ui, design
Published: 2020-11-02 11:28:01

---
title: Where do you get illustrations?
published: true
description: 
tags: webdev, watercooler, UI, design
cover_image: https://www.startthefup.co/wp-content/uploads/2019/08/Screenshot-2019-08-30-at-15.26.06.png
---
When working on a project with tight deadlines, using free illustrations might both look good and save time.

Some of my favorite resources include [unDraw](https://undraw.co/illustrations), [IRA Design](https://iradesign.io/), [Ouch](https://icons8.com/illustrations), [DrawKit](https://www.drawkit.io/) and [Humaaans](https://www.humaaans.com/). Downloads are available in both PNG and SVG.

What are your favorite sources for free illustrations?
How to build Netflix's Coming Soon page in React
Tags: react, javascript, webdev, tutorial
Published: 2020-11-02 11:23:16

---
title: How to build Netflix's Coming Soon page in React
published: true
description: React tutorial on how to build Netflix's Coming Soon page
tags: react, javascript, webdev, tutorial
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/n24owrhi6j1l8ef45rnl.png
canonical_url: https://aleksandarpopovic.com/How-to-build-Netflix's-Coming-Soon-page-in-React/
---

A couple of days ago I noticed something interesting in the Netflix mobile app. It has a Coming Soon page which shows movies and TV shows that are soon coming to Netflix.

It has a few interesting functionalities. It’s loading data from somewhere and sorting it into cards. You can bookmark a movie to let Netflix know you want to be notified when it comes out. It has a cool, modern looking share menu for which you need to manage state.

What’s interesting is - this page is not available outside of their mobile app - so you can’t find it on your desktop or TV, and that got me thinking, wouldn’t it be cool to recreate it for web?

So, that’s what we are doing today. I am going to show you how you can recreate Netflix’s Coming Soon page in React, and I will show you some interesting concepts that you can adapt and use in your other React projects, like handling and rendering data, using state hooks, and sharing states between your components. The whole project is a bit too lengthy to fit into a single blog post, but you can check out the video version with full instructions and explanations on Youtube:

{% youtube lEXc1UTTLzc%}
Hacktoberfest Challenge
Tags: hacktoberfest
Published: 2020-11-02 10:59:23

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ -->


### [Introduction]
<!-- If you are new to the DEV community, introduce yourself and share a bit about why you joined DEV and decided to participate in Hacktoberfest this year.  --> 
Hey! I'm Chanchal K Maurya from India. I decided to participate in Hacktoberfest because i really wanted a start in open Source. I didn't know about open source before. I have a learnt a lot during this fest.

### Background

<!-- Are you brand new to open source? What about coding in general? Tell us about how you got here →
I'm new to open source. I know the coding stuff and i do the coding but i wasn't aware of Open Source untill i heard about Hacktoberfest.

### Progress

<!-- Share a bit about where you’re at in your Hacktoberfest journey. What stage are you at? How has the process been?  -->
Now I know much about open source like how to make your own projects,how to contribute, how to collaborate with others,etc.
I learnt about git and github during the Hacktoberfest.

### Contributions

<!-- This is where you can list the contributions you made and explain why you chose the projects you did. Don’t forget to add links!  -->
I contributed in some of the repositories..
1. NovaStarCoder's Repo.
2. Adarsh Repo.


### Reflections
<!-- Overall, how has your Hacktoberfest 2020 experience been? If you’re a first-timer, will you participate again? What have you learned? Have you made any interesting connections? What is your next step in open source?  -->
The Hacktoberfest journey was awesome.It will be a great pleasure to participate in such Events.
Looking for beta users !
Published: 2020-11-02 10:55:17

Today we launched Pmbot 2.0.0 beta, and are looking for beta users that would like to try it out.

It's a complete re-write and setup is now just one click !

Blog article [here](https://blog.pmbot.io/introducing-pmbot-v2-0-0-beta/).

New cloud platform at [cloud.pmbot.io](https://cloud.pmbot.io).

Looking forward to your feedback !

![Screen Shot 2020-11-01 at 13.02.48](https://dev-to-uploads.s3.amazonaws.com/i/5fpt5xw8riubi0wj0zvt.png)
![Screen Shot 2020-11-01 at 13.01.13](https://dev-to-uploads.s3.amazonaws.com/i/y94el0zb5zt2m44lp362.png)
![Screen Shot 2020-11-01 at 13.01.21](https://dev-to-uploads.s3.amazonaws.com/i/fg27jg629ro3gxt0gmgj.png)
![Screen Shot 2020-11-01 at 13.01.28](https://dev-to-uploads.s3.amazonaws.com/i/9otndsmig4o1mt18id4q.png)
![Screen Shot 2020-11-01 at 13.01.37](https://dev-to-uploads.s3.amazonaws.com/i/j7tov9evywvj1dw47cxt.png)
![Screen Shot 2020-11-01 at 13.01.47](https://dev-to-uploads.s3.amazonaws.com/i/57i2uctbnlhk01ycozzd.png)
![Screen Shot 2020-11-01 at 13.02.07](https://dev-to-uploads.s3.amazonaws.com/i/mneacv22qvrbqgbzkba2.png)
Open source library for high-dimensional statistics
Tags: cpp, machinelearning, computerscience, opensource
Published: 2020-11-02 10:50:07

volesti is a generic open source C++ library, with R and Python interfaces.

https://github.com/GeomScale/volume_approximation

volesti provides functionality for high-dimensional sampling, volume estimation and convex optimization. 

volesti has been used for high-dimensional copula estimation  to model financial crises, as well as for analysing metabolic networks in systems biology.
Hello dev.to
Tags: intro, hello, developer, software
Published: 2020-11-02 10:47:19

Hello dev.to,

My name is Mert and I live in Ankara, 10 year experienced software developer. So far I have worked for five startup companies as a backend developer. I mostly used php, python3, GoLang and JS.

I just opened my account and my objective is stay in touch and follow related software development posts.

My interests;
* python
* Django w/python3
* GoLang
* React
* Flutter
* Cloud solutions (AWS, Oracle, Google Cloud etc.)

Also I'll try to share posts that include interesting development issues and solutions which I experience.

Happy to be here.
.Net Là Gì- Làm Thế Nào Để Trở Thành Lập Trình Viên . Net
Published: 2020-11-02 10:21:46

Hiện nay, nhiều người vẫn chưa biết rõ liệu ngôn ngữ .NET là gì? Cần tìm hiểu những gì để trở thành một .NET Developer?Hãy theo dõi bài viết dưới đây nhé. Xem chi tiết tại: https://blog.itnavi.com.vn/ngon-ngu-net-la-gi-nhung-kien-thuc-de-bat-dau-voi-net-framework/
Changelog: API updates
Tags: changelog
Published: 2020-11-02 10:20:27

We recently shipped a series of improvements to the Forem API thanks to our open source contributors:

- Fetching articles by their slugs
- Fetching podcast episodes comments
- Retrieving a list of followed tags
- Getting the list of articles in the reading list
- Finding organizations details

Read on to find more about these changes!

Thanks to [Oghenebrume50](https://dev.to/Oghenebrume50) we can fetch an article by its slug:

{% github https://github.com/forem/forem/pull/8929 %}

You can find more information [in the documentation](https://docs.dev.to/api/#operation/getArticleByPath) and try it here: https://dev.to/api/articles/devteam/the-7-most-popular-dev-posts-from-the-past-week-4fhi


Thanks to [jkrsn98](https://dev.to/jkrsn98) we can retrieve a podcast episode’s comments:

{% github https://github.com/forem/forem/pull/9677 %}

You can find more information [in the documentation](https://docs.forem.com/api/#operation/getCommentsByArticleId) and try it here: https://dev.to/api/comments?p_id=15564

[jkrsn98](https://dev.to/jkrsn98) also added the missing `created_at` field in comments that will help determine when a comment was posted on the website:

{% github https://github.com/forem/forem/pull/9829 %}


Thanks to [danascheider](https://dev.to/danascheider), a user can retrieve a list of the tags they follow:

{% github https://github.com/forem/forem/pull/9108 %}

You can find more information [in the documentation](https://docs.forem.com/api/#operation/getFollowedTags)


Thanks to [bhacaz](https://dev.to/bhacaz) a user can retrieve a list of articles in their reading list.

{% github https://github.com/forem/forem/pull/10540 %}

You can find more information [in the documentation](https://docs.forem.com/api/#operation/getReadinglist).

Thanks to [diogoosorio](https://dev.to/diogoosorio) we can retrieve the profile image of a user or an organization.

{% github https://github.com/forem/forem/pull/10547 %}

You can find more information [in the documentation](https://docs.forem.com/api/#operation/getProfileImage) and try it here https://dev.to/api/profile_images/devteam

Thanks to [twinsfan421](https://dev.to/twinsfan421) we’re one step closer to having API for organizations:

{% github https://github.com/forem/forem/pull/10931 %}

You can find more information [in the documentation](https://docs.forem.com/api/#operation/getOrganization) and try it here: https://dev.to/api/organizations/devteam

We hope you’ll find these updates to the Forem API useful!
Top remote jobs for developers!(November)
Published: 2020-11-02 10:19:46

1) Boatyard

[Remote Senior Ruby on Rails Engineer] (https://www.remotely.jobs/remote-senior-ruby-on-rails-engineer-job-at-boatyard)

We are looking for a senior engineer who would embrace the opportunity to take a leadership role with our fast-growing startup. Our ideal candidate has 7+ years of experience as a Ruby on Rails engineer, with 3+ years in a leadership role.

2) Buysellads

[Full Stack Developer](https://www.remotely.jobs/remote-full-stack-developer-job-at-buysellads)

3+ years of experience working with node.js and/or comparable languages (Typescript, React, Ruby, PHP)
3+ years experience leading database management (MySQL, Redis, GraphQL, Postgres)

3) GlassDollar 👍

[Full Stack Developer](https://www.remotely.jobs/remote-full-stack-developer-node-js-react-job-at-glassdollar)

- strong professional background in JavaScript/Typescript, Node.js, and React
- product-focused mindset with the customer need always front of mind

4) Data (SimplyAnalytics)

[Software Engineer](https://www.remotely.jobs/remote-software-engineer-data-100-remote-job-at-simplyanalytics)

- Must be able to maintain our full data processing stack, which includes code written in both PHP and Python 
- Linux servers, including Linux command line and SSH

5) BetterProducts.co 🤘

[Lead Developer Node.js for greenfield project](https://www.remotely.jobs/remote-lead-developer-node-js-for-greenfield-project-job-at-betterproducts-co)

- Backend: You have at least 4 years Node.js plus a popular framework like express / hapi / koa /etc
- Frontend: You have at least 3 years of experience with react.


Find more remote jobs on [Remotely.jobs](www.remotely.jobs)
Self-hosted web based tool to get tasks done efficiently
Tags: productivity, agile, webdev, node
Published: 2020-11-02 10:05:14

---
title: Self-hosted web based tool to get tasks done efficiently
canonical_url: https://blog.markjgsmith.com/2020/11/02/self-hosted-web-based-tool-to-get-tasks-done-efficiently.html
---
A short while ago I was wanting to have a self-hosted tool to manage sets of tasks in an efficient way, so that tasks actually get done. I wanted it to be simple enough not to require much maintenance, with minimal chances of something breaking because of software upgrades. 

I built a simple statically generated web based tool that is based on the agile software development methodology, which uses a “backlog” of “stories” that you complete during time periods called “sprints” (usually 2 weeks long).

Another key idea is that writing things down is a great way to focus on the task at hand and a way to drive your way as you forge your path.

It uses the [eleventy](https://www.11ty.dev) static site generator to render all the pages. 

Here is the [Github repo](https://github.com/mjgs/eleventy-agile-blog).

How does it work? 

From the repo docs:

> Use blog posts to describe your work, what you did, what you are about to do, then create "stories" that you add to the "backlog". Assign stories to "sprints", these last 1 week. Flesh out the stories, implement them, and then move these to "done" when you complete them.
>
>At the end of the week do a retrospective of what you did, and plan (i.e. create and assign stories to the next sprint) for the upcomming week.
>
>Whenever you are a bit unsure of your path, read the above 2 paragraphs. You probably need to write a blog post.

Benefits:

- Self hosted - run it in the cloud or just locally on you machine
- Everything is a file, versioned using git
- Create items written in [markdown](https://www.markdownguide.org/basic-syntax)
- Easily backup your repo using one of the many git hosting providers
- Never have a migration problem, it’s all just text files
- Works offline

This is aimed at personal use rather than for large projects. I think for big projects, especially where you are collaborating with others, it’s probably better to use more comprehensive tools.

What productivity tools do you use?

Let me know what you think in the comments.

--

Thanks for reading!

[@markjgsmith](https://twitter.com/markjgsmith)

*[I’m currently available for hire](https://blog.markjgsmith.com/about)* - Consider hiring me!

If you liked this article you might like adding my [blog feed](https://blog.markjgsmith.com/feed.xml) to your RSS reader, reading my [daily linkblog](https://links.markjgsmith.com) or signing up for my [weekly newsletter](https://markjgsmith.substack.com). :)

*Originally posted on [blog.markjgsmith.com](https://blog.markjgsmith.com/2020/11/02/self-hosted-web-based-tool-to-get-tasks-done-efficiently.html)*
System Engineer Là Gì? Những Điều Cần Biết Về System Engineer
Published: 2020-11-02 10:04:11

Một trong những công việc đang được quan tâm hiện nay là System Engineer. Vậy System Engineer là gì và có trách nhiệm quan trọng như thế nào? Xem chi tiết tại: https://blog.itnavi.com.vn/system-engineer-la-gi/
A growing collection of free web templates and page components
Published: 2020-11-02 09:51:07

---
title: A growing collection of free web templates and page components
published: true
description: 
tags: 
//cover_image: https://direct_url_to_image.jpg
---

I am currently working on ui elements for building marketing and product pages, with new templates added every week. You can use any of these templates for free on your own products or websites.

Check them out here: https://pheeque.com/web-templates. Do let me know what you think!
Kotlin là gì? Ưu điểm nổi bật của ngôn ngữ lập trình Kotlin
Published: 2020-11-02 09:47:03

Ngôn ngữ lập trình Kotlin là gì và ưu điểm của ngôn ngữ lập trình này là gì không phải ai cũng biết.Hãy theo dõi bài viết dưới đây để hiểu rõ hơn nhé. Xem chi tiết tại: https://blog.itnavi.com.vn/kotlin-la-gi-va-uu-diem-cua-ngon-ngu-lap-trinh-kotlin/
My first journey on the Open source world
Tags: hacktoberfest, opensource
Published: 2020-11-02 09:46:49

# ![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/6jujr5wiznqjxwqdn8mb.png)

### *About me*
Hi, guys! 👋
I am Ky Huynh.

Currently, I'm a Java developer and also a newcomer in the open-source community.

### *Chance* 🚀
I encountered Hacktoberfest via my teammate. He encouraged me to join this event, he promised that I will get a ton of funs and also gain knowledge. Obviously, my eagerness growing rapidly. OK, Let's make a start !!!!


### *Contributions* 🐇
Firstly, I'm a newcomer so I decided that I will take on some challenges which for the newbie. I research with the query:
```javascript
"label:hacktoberfest is:issue is:open label:"good first issue"" 
``` to filter out it. If you also a newbie like me, for the 1st - 2nd issues, you can take an easy one but then you can challenge yourself without "good first issue". 

Besides, I set the goal that I want to get more experience on this journey so I conducted to work on 4 different repositories. I finished three first PRs at the early of this month but the fourth PR is finished by the end of the month. In case you wish to get a T-shirt, you should have 4 pull requests in the middle of the month because the event will take 15 days to validate your PRs. Please note that!

### *Reflections* ✨ 
It was an amazing event for us who are programmers. It is a playground where brings substantial benefits. I am elation after I completely finished the challenge for this year not about the award but also the mindset for contributing to open source. Certainly, I will join in next year.
Last but not least, thank you who created the Hacktoberfest event for us.
See you soon.

### *Hacktoberfest spread the world !!!*