teleren/devto huggingface dataset:
Synchronize Databases with Only Five Lines of Code
Tags: csharp, dotnet, sql, developer
Published: 2020-09-04 13:44:31

---
title: Synchronize Databases with Only Five Lines of Code
published: true
description: Database synchronization is a common business challenge that can be tough to implement. How do you reconcile the data stored on local databases like SQLite across thousands or more mobile devices with your centralized cloud server? Dotmim.sync can make that happen, and we'll show you how! 
tags: csharp, dotnet, sql, developer
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/l26smyizcbyeqspm49yl.png 
---
[DotMim.sync](https://github.com/mimetis/dotmim.sync) is a framework for synchronizing relational databases. It is a .NET Standard 2.0 library, which means it will run on multiple platforms including Windows, Linux, iOS and Android (via Xamarin) and more. It is production-ready and has been evolving for nearly a decade. The following code sample shows how easy it is to get started. This will automatically sync a client, including creating the tables and populating the data if the database doesn't already exist.

```csharp
// Sql Server provider, the "server" or "hub".
SqlSyncProvider serverProvider = new SqlSyncProvider(
    @"Data Source=.;Initial Catalog=AdventureWorks;" +
    "Integrated Security=true;");

// Sqlite Client provider acting as the "client"
SqliteSyncProvider clientProvider = new
    SqliteSyncProvider("advworks.db");

// Tables involved in the sync process:
var tables = new string[] {
    "ProductCategory", "ProductDescription", 
    "ProductModel", "Product", 
    "ProductModelProductDescription",
    "Address", "Customer", "CustomerAddress", 
    "SalesOrderHeader", "SalesOrderDetail" };

// Sync agent
SyncAgent agent = new SyncAgent(
    clientProvider, serverProvider, tables);

do
{
    var result = await agent.SynchronizeAsync();
    Console.WriteLine(result);

} while (Console.ReadKey().Key != ConsoleKey.Escape);
```

In this episode of the [EF Core Community Standup](https://www.youtube.com/playlist?list=PL1rZQsJPBU2Ry_KbYPklhVu0JhP0kOFbj), the team talks with creator [Sébastien Pertus](https://twitter.com/sebpertus) who shares the project's history and demos several scenarios that illustrate how fast and easy the framework is to use.

{% youtube _SHryJiblRo %}

You can find the links that were discussed in the show at:

[https://www.theurlist.com/efcore-standup-2020-09-02](https://www.theurlist.com/efcore-standup-2020-09-02).

Have feedback for the EF Core team? [File an issue](https://github.com/dotnet/efcore/issues/new) or join one of our many [online discussions](https://github.com/dotnet/efcore/discussions).
I want to build rockets….. with you !
Published: 2020-09-04 13:43:36

Okay so right now you think that I am a weirdo…. And you’re right but it isn’t the point of this article.


I’ve always been fascinated and passionate by space exploration and rockets and everything that has something to do with space or our universe exploration. But sadly, because of my studies, I’ve had to let this passion go away from me… 


But during the COVID-19 lockdown, I’ve returned to this old passion thanks to all the YouTubers that exist in this field.


And here comes this beautiful day of quarantine, when I found this video: https://www.youtube.com/watch?v=xvtzKox3QYg
I just said to myself “ Thomas, this guy is building outstanding rockets with no engineering background at all, you could totally do it too”.
And with a lot of research, I found that yeah, I can do it too.


But I found this boring. And as a full-stack developer, I don’t have any engineering background either, I’ve only built websites, APIs and apps. 


So I’ve figured out a way to build some model rockets.


What if I wasn't the only one on this project?
The fact is that anyone on this platform has his specialty. I just think that if we all try to build this project together, we could create something amazing. Moreover, anyone could learn something from others. 


The project will be to develop features of the launchpad/rocket and accessories together from all around the world. The assembly of the rocket will be done at my place in France.
All steps of the project will be documented on the website and in youtube videos. The goal is that anyone will have the exact same importance in the project. Anyone will be able to talk about the project, or even build another rocket at his own place.


The most important part is that it will be a project done from all around the world and in which everyone will collaborate and learn things. 


I am, at this time, initiating contact with brands, creators, bloggers, etc. To help us with this project. 


The goal of the first part of the project is to create a custom model rocket based on the SpaceX Falcon 9 and launch it near the french coast and try to recover the first stage on a precised landing zone ( just like the real one ). Everything will be fully autonomous.
I am actually writing a complete description of this project and building a website to explain everything. But you can already contact me if you are interested or if you want more information about it.

You can contact me in the comment section, on my website (tsflorus.me), or even by email: tsflorus@gmail.com ( I check everything multiple time a day )


I will be back very soon for a complete description!


See you,
Thomas
sesh kore felse google
Published: 2020-09-04 13:41:30

https://www.bizcommunity.com/Profile/free-north-v-south-live-nz-ru
https://www.bizcommunity.com/Profile/north-vs-south-rugby-live-str
https://battlefy.com/nz-rugby-north-v-south/nz-rugby-live-steinlager-north-vs-south-rugby-live-stream/5f4c983a20ac296025ce7b5d/info
https://www.bizcommunity.com/Profile/north-vs-south-rugby-live-str
https://www.bizcommunity.com/Profile/north-vs-south-live-stream
https://www.bizcommunity.com/Profile/free-north-v-south-live-nz-ru
https://www.bizcommunity.com/Profile/nz-rugby-live-north-v-south
https://www.bizcommunity.com/Profile/rugby-streams-north-vs-south
https://www.bizcommunity.com/Profile/all-blacks-rugby-live-stream
https://www.bizcommunity.com/Profile/nz-rugby-north-vs-south-live
https://www.bizcommunity.com/Profile/rugby-island-north-vs-south
https://www.bizcommunity.com/Profile/steinlager-north-vs-south-rug
https://www.bizcommunity.com/Profile/north-vs-south-rugby-live-str
https://battlefy.com/rugby-all-access/live_~tv%E2%84%A2%C2%AE-north-vs-south-live-stream/5f40bce172caf64e0f2b7d40/info
https://battlefy.com/rugby-all-access/%5Btv-free%5Dnorth-vs-south-rugby-live-stream/5f40d1f772caf64e0f2b80ac/info
How to build your own private cloud on AWS part 2
Tags: aws, cloud, devops
Published: 2020-09-04 13:36:36

 Hi! In the [previous part](https://dev.to/antonnguyen97/how-to-build-your-own-private-cloud-on-aws-part-1-3fp1), we have created our own private cloud using VPC on AWS. If you haven't read it, make sure you do, before starting this article.

 So let's test our VPC. I created 3 EC2 instances in 3 different subnets, as you can see below:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/yxsa4hmesohiqkixm921.PNG)

 [Appus-isolated-subnet-B](appus.software) and [Appus-private-subnet-A](appus.software) do not have a public IP address, they only have private ones - 10.0.23.186 and 10.0.12.221.

 So let's log into our instance that has a public IP address and try to ping Google.
 I have logged into my instance and sent some packages to Google, and as we can see it has an Internet connection:

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/a1i0mfttu36fsp0vebf6.PNG)


 Let's log into our Appus-private-subnet-A instance through a private IP address. Using the ssh command we can log into it "ssh -i your_key.pem ubuntu@your_private_ip".  Now we can ping any host.  

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/1a7m6n8xp5dkm3l4fzd1.PNG)

 As we can see, it is connected to the Internet through the NAT server. But the Internet can not ping our instance since it has no public IP address. So let's exit this server and log into an isolated server. 
 Using the ssh command we can log into an isolated server - "ssh -i your_key.pem ubuntu@your_private_ip".  If we try to ping any Internet host there will be no packages received.


![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/wogj2iaovyv13qfloa9d.PNG)

This is it, I hope this article was helpful for you!
Write A script to create users from csv file.
Tags: bash, linux, programming, scripting
Published: 2020-09-04 13:18:50

Here is the code from which you can create users from csv file .
<pre>
<code>



#!/bin/bash
group=`awk -F, '{print $2}' users.csv `
groups=`echo $group | sed -e 's/\s\+/,/g'`
while IFS=, read -r username group shell homedir status; do
        groupadd  $group
        password=`date +%s | sha256sum | base64 | head -c 32` 

        useradd ${username}  -m -d /home/${username} -s ${shell} -g ${group} -p ${password}

        chmod -R 774 /home/${username} #3 ) 

        chage --lastday 0 ${username} 
        echo -e "${username},${password}" >> cred.txt 

        usermod -aG ${groups} ${username}

        if [[ ${status} == "N" ]]
        then
                userdel -r ${username}
        else
                echo "do nothing "
        fi
done < users.csv  

</code>
</pre>
Daily Challenge #286 - Reverse It Quickly!
Tags: challenge
Published: 2020-09-04 13:17:44

---
title: Daily Challenge #286 - Reverse It Quickly!
published: true
series: Daily Challenge
description: Reverse an array with a twist. 
tags: challenge
//cover_image: https://direct_url_to_image.jpg
---

Typically, reversing an array is a pretty straightforward task even for novice programmers. But not when a crowd of angry zombies scratching your door, looking for a fresh brains. In this case even skilled ninja-geek probably prefers to quickly push his code on github to have enough time to find a chainsaw. So there's two obstacles:

Your code needs to be as short as possible, in fact not longer than 28 characters
Because you are scared and stressed you have forgotten how to use the standard reverse() method

Input: an array containing data of any types. 
Ex: `[1,2,3,'a','b','c',[]]`
Output: `[[],'c','b','a',3,2,1]`

####Tests
[1,2,3,4,5]
[2,4,6,8,10]
["pineapple", "pumpkin", "pear", "peach"]

Good luck!

***
_This [challenge](https://www.codewars.com/kata/reverse-it-quickly) comes from avadakedavra on CodeWars. Thank you to [CodeWars](<https://codewars.com/>), who has licensed redistribution of this challenge under the [2-Clause BSD License](<https://opensource.org/licenses/BSD-2-Clause>)!_

_Want to propose a challenge idea for a future post?  Email **yo+challenge@dev.to** with your suggestions!_
Building Maps with React Leaflet - Course on egghead.io
Tags: react, leaflet, maps, course
Published: 2020-09-04 12:54:20

If you’ve been following along with my work, I tend to talk about maps every so often.

This includes tutorials like [how to create a Coronavirus (COVID-19) statistics map](https://www.colbyfayock.com/2020/03/how-to-create-a-coronavirus-covid-19-dashboard-map-app-with-gatsby-and-leaflet/) or even [how to create your own Santa Tracker](https://www.colbyfayock.com/2019/12/create-your-own-santa-tracker-with-gatsby-and-react-leaflet/).

tl;dr my new course Building Maps with React Leaflet is now available on [egghead.io](https://egghead.io?af=atzgap)!

## Why so much about maps?
While maps aren’t my sole focus for the educational content I create, I’ve developed a passion for maps with my work at [Element 84](http://element84.com/).

With my day job, I’ve been working on building a satellite tasking dashboard, but before I even got started, I learned about how maps have made a huge impact in people’s lives at [State of the Map](https://2018.stateofthemap.us/). The stories are both inspiring and heartbreaking.

As I learned more about maps, the more I realized the learning curve isn’t quite what people would expect. While there’s absolutely some complexity as you start digging deep into maps, getting started with a basic map has a much lower barrier to entry thanks to the tools available to use like [React Leaflet](https://react-leaflet.js.org/en/).

## Learning maps with my new course!
That’s what led me to put my time into developing this Building Maps with React Leaflet course with the [egghead.io](https://egghead.io?af=atzgap) team.

I walk you through building a map from scratch, starting off with essentially a clone version of [Create React App](https://create-react-app.dev/) with a few tweaks to make it easier to focus on learning about maps.

Here’s what you’ll learn:
* How to build a map from scratch in a React app
* How to add markers and shapes to a map
* About geospatial data formats and how to create your own
* How to wrangle that data and visualize that data on a map
* How to use geolocation features to personalize the map
* How to customize the map with imagery and custom markers

After completing this course, you’ll be ready to build maps into your React apps for a ton of use cases, whether it’s visualizing geographical data like a pandemic or adding a store locator to your company’s website.

I’d love for you to take this journey with me and I’d love to hear any feedback.

[Build Maps with React Leaflet](https://egghead.io/courses/build-maps-with-react-leaflet) on [egghead.io](https://egghead.io?af=atzgap).

## On a personal note, this is my first course!
Thanks to the egghead.io team for all the support through this process. Working through my first course was challenging, but it was certainly rewarding.

I hope you all enjoy learning maps with my course as much as I enjoyed putting it together.
How to Add Text to End Number in Excel Office 365?
Tags: addtexttoendnumberin, excelformula
Published: 2020-09-05 10:54:52

---
title: How to Add Text to End Number in Excel Office 365?
published: true
date: 2020-09-04 12:08:53 UTC
tags: AddTextToEndNumberin,ExcelFormula
canonical_url: https://geekexcel.com/how-to-add-text-to-end-number-in-excel-office-365/
---

## Add Text to End Number in Excel:

In this article, we are going to learn how to **Add Text to End Numbers in Excel Office 365**. Let’s get started!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Steps to Add Text to End Number:

- Let us consider a numerical input data as shown in the below image.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-21.png)<figcaption id="caption-attachment-13389">Example</figcaption>

- If you want to add text to the end of each number in the list, do as follows.

### Use this formula to add text at the end of a number in Excel:

**=A2&”S”**

### Formula Explanation:

From the above formula, we can understand that the symbol “ **&** ” acts as an **appending tool**. By using the above formula, we can insert any type of data (“ **Symbol, non-numerical characters, numerical characters, and special**  **characters** “) in front or back to the existing data.

- In the below image, we used ** this formula in cell B1**.

![Enter the Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-18.png)<figcaption id="caption-attachment-13390">Enter the Formula</figcaption>

- Now, you need to drag using the mouse from the **Cell B2** to the **Cell B6**.
- It will auto-fill the remaining cells with the required output values.
- Refer to the below screenshot.

![Text added to the end of the number](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-6.png)<figcaption id="caption-attachment-13391">Text added to the end of the number</figcaption>

From the above steps, we have shown the ways to add text to the end of the numbers in an Excel spreadsheet.

If you want to add or insert the text in front of the data, Then refer to the following article.

- [Add Text at the Beginning of numbers in Excel](https://geekexcel.com/how-to-add-text-to-beginning-number-in-excel-office-365/)

## Verdict:

In this article, you can learn how to **Add Text To End Number in Excel Office 365** with an example. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!
Daily Developer Jokes - Friday, Sep 4, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-09-04 12:00:27

---
title: "Daily Developer Jokes - Friday, Sep 4, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Friday%2C%20Sep%204%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e12597d4e1c1.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*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:___ What accommodations did the JavaScript developer request at the hotel?

___A:___ A room with a Vue.
 -->
How to Add Text to Beginning Number in Excel Office 365?
Tags: addtexttobeginningnu, excelformula
Published: 2020-09-05 10:54:33

---
title: How to Add Text to Beginning Number in Excel Office 365?
published: true
date: 2020-09-04 11:55:38 UTC
tags: AddTexttoBeginningNu,ExcelFormula
canonical_url: https://geekexcel.com/how-to-add-text-to-beginning-number-in-excel-office-365/
---

## Add Text to Beginning Number in Excel:

In this post, you will learn how to **Add Text to Beginning Number in Excel Office 365**. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

Sometimes, you need to add the text at the beginning of a number. Instead of doing it manually, you can use the following method to solve this task quickly. Let’s jump into this article!!

## Steps to Follow:

- Let’s see how to insert the text at the beginning of the number **with an example.**
- In the following screenshot, you can see the input numbers (“here we used only numbers without any text to meet our scenario”) in **Column A**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-22.png)<figcaption id="caption-attachment-13395">Example</figcaption>

- In the beginning, the letter “ **S** ” that needs to be added or inserted.
- To do this, you need to use the below formula to add the text **“S”** in the selected range of cells.

**=”S”&A2**

### Formula Explanation:

From the above formula, we can understand that the symbol “ **&** ” acts as an **appending tool**. By using the above formula, we can insert any type of data (“ **Symbol, non-numerical characters, numerical characters, and special**  **characters** “) in front or back to the existing data.

- Refer to the below image. We used the formula in **cell B2**.

![Enter the Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-19.png)<figcaption id="caption-attachment-13396">Enter the Formula</figcaption>

- After using the formula, you need to **press**  **Enter** and the letter “ **S** ” will be inserted at the beginning of the cell.
- Now, you need to **drag** the cell from **B2** to **B7** using the **mouse** and it will fill the remaining values automatically.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-7.png)<figcaption id="caption-attachment-13397">Result</figcaption>

If you want to add or insert the text at the end of the data, Then refer to the following article.

- [**Add Text at the End of numbers in Excel**](https://geekexcel.com/how-to-add-text-to-end-number-in-excel-office-365/)

## Wind-Up:

In the above article, you can learn how to **Add Text to Beginning Number in Excel Office 365** with an example. Give your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!
Lançando meu primeiro software livre: Yeoman Quarkus Generator
Tags: quarkus, yeoman, java, ptbr
Published: 2020-09-04 11:53:05

O post de hoje é um pouco diferente dos demais. Não teremos nenhum tutorial porque vou fazer meu momento jabá. Vim falar sobre um projeto que eu tenho trabalhado nas últimas semanas, um gerador de código Quarkus baseado em Yeoman =D

Primeiramente, sei que já existe o [jhipster](https://www.jhipster.tech/) que é o melhor e mais topzeira de todos. Também sei que logo vai sair o Quarkus-cli para fazer **bootstrap** da aplicação. Mas quis fazer algo que eu pudesse chamar de meu e que fosse algo beeeeem menor e mais simples e fácil pras pessoas editarem. 

Se houver interesse, eu posso fazer algum tutorial sobre as partes internas do sistema. 

Para usar é super fácil. Ao chamar o comando `yo yeoman-quarkus`, o sistema vai fazer algumas perguntas sobre a sua aplicação junto com a lista de plugins que você vai instalar. Depois disso, ele vai fazer o deploy de tudo.

```console
$ yo yeoman-quarkus
? Select java version:  11
? Insert project name:  Exemplo
? Insert project artifact id:  exemplo
? Insert project group id:  com.hetech
? Insert docker image registry:  
? Insert docker image prefix:  com.prefix
? Insert project version:  0.0.1-SNAPSHOT
? Would you like enable sonar? (not implemented yet) No
? Select all cool things that your application will do:  (Press <space> to select, <a> to toggle all, <i> to invert selection)Kafka Consumer, Kafka Emitter, REST client (not supported yet), REST server, Schedu
led Tasks, Redis Client
Configuring app...
answers: {"javaVersion":"11","applicationName":"Exemplo","artifactId":"exemplo","groupId":"com.hetech","dockerRegistry":"","dockerPrefix":"com.prefix","version":"0.0.1-SNAPSHOT","sonarEnabled":false,"extensions":["kafkaConsumer","kafkaEmitter","restClientNotSupportedYet","restServer","scheduledTasks","redisClient","kafka","rest"]}
   create exemplo/.dockerignore
   create exemplo/.gitignore
   create exemplo/.mvn/wrapper/maven-wrapper.jar
   create exemplo/.mvn/wrapper/maven-wrapper.properties
   create exemplo/.mvn/wrapper/MavenWrapperDownloader.java
   create exemplo/checkstyle.xml
   create exemplo/Jenkinsfile
   create exemplo/mvnw
   create exemplo/mvnw.cmd
   create exemplo/pom.xml
   create exemplo/README.md
   create exemplo/src/main/docker/docker-compose.yml
   create exemplo/src/main/docker/Dockerfile.jvm
   create exemplo/src/main/java/org/acme/ExampleResource.java
   create exemplo/src/main/resources/application.properties
   create exemplo/src/main/resources/META-INF/resources/index.html
   create exemplo/src/test/java/org/acme/ExampleResourceTest.java
```

O projeto ainda está no começo, mas espero conseguir evoluir para que ele permita fazer o **bootstrap** de aplicações bem documentadas e já com tudo meio encaminhado para colocar em produção. 

Quem quiser saber mais sobre ele pode encontrar as informações no [npmjs](https://www.npmjs.com/package/generator-yeoman-quarkus) e se quiserem contribuir, é só chegar lá no [bitbucket](https://bitbucket.org/jlscharf/generator-yeoman-quarkus/src/master/) (num futuro próximo vou migrar para o github).