teleren/devto huggingface dataset:
Server Virtualization
Published: 2022-03-24 23:36:32

Server virtualization is the creation of a virtual version of an operating system, a server, a storage device or network resources.

Virtualization can be achieved using an "Hypervisor". Hypervisor is a technology that allows hosting several virtual computers on a physical computer. Hypervisors take some of the hardware resources from the physical computer to create the virtual computer.

The virtual computer can only be given the hardware resources that is available on that computer. These virtual computers are completely isolated from the physical computer and if anything is running or breaking on the virtual computers, it won't affect the main operating system.

## Benefits Of Using Virtualization

1. Provides a cost effective way to separate email, database and web servers.
2. Expedited deployment and redeployment
3. Easier migration to the cloud
4. Reduced heat and improved energy savings

## Types Of Hypervisor

1. Type 1 Hypervisor:This installs guest operating system directly on the hardware. They are also called "Bare metal hypervisors". It controls the hardware resources. E.g VMware, ESXi, Microsoft Hyper-v

2. Type 2 Hypervisor: This is the type of hypervisor that installs guest operating system on top of the host operating system. It is also called "Hosted hypervisors". It shares the hardware resources. E.g virtual box

## Advantages Of Virtualization

1. Lower cost
2. Easier disaster recovery
3. Easier testing
4. Quicker backups
5. Improved productivity
RepliByte - an open-source tool to synchronize PostgreSQL in multiple environments
Tags: database, postgres
Published: 2022-03-24 23:15:27

After months of experimenting with different ways of synchronizing databases, I am super excited to announce [RepliByte](https://github.com/Qovery/replibyte) - an open-source tool to synchronize cloud databases and fake sensitive data - This tool is written in Rust.

As explained in the README, my primary motivation is to respond to a widespread need that most developers have - cloning the production database into a development database while cleaning the sensitive data. It is precisely the purpose of RepliByte.

I am still in the early days of development, but you can look at the code and the README. It should be clear enough to help me out in that journey, and why not contribute?!

RepliByte supports PostgreSQL, MySQL and MongoDB supports is in progress by the community 😎.

--

I freshly recorded this short demo explaining what is RepliByte and how to use it.

{% embed https://www.youtube.com/watch?v=IKeLnZvECQw %}

1. Happy to have your feedback.
2. RepliByte is written in Rust and we are looking for contributors.
Simplificá los estilos de tus botones y todas sus variantes con filtros CSS
Tags: css, filters, spanish
Published: 2022-03-24 22:06:41

¡Hola! Les traigo un tip muy útil para cuando tienen que escribir los estilos de botones o links, y deben tener en cuenta los distintos estados o variantes de los mismos.
Este es un ejemplo de dos tipos de botones y sus estados.

![Tabla de botones que incluye las variantes default, hover, active, focus y disabled](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/92cfnzycwusxo8c8vaot.png)

El proceso lógico es empezar por los estilos del botón en su estado inicial y después desarrollar los estados mediante las [pseudoclases](https://developer.mozilla.org/es/docs/Web/CSS/Pseudo-classes) correspondientes.
Lo recomendable es que si estás replicando una interfaz de un wireframe o estás utilizando un UI kit, respetes todos los colores y estilos acordados. En cambio, si estás programando tu propia UI y sólamente querés que tus botones queden funcionales, te voy a mostrar cómo podés alivianarte mucho el trabajo. Obviamente también suponemos que no vas a usar una librería UI.

Lo que lleva mucho tiempo al momento de estilizar los botones es buscar los colores correctos para los distintos estados, y se complica más aún si no tenés conocimientos sobre colores en UI. Y todavía más complicado si queremos tener botones con degradado porque tenemos que armar mínimo tres degradados que queden bien.
Acá es cuando aparecen los [filtros CSS](https://developer.mozilla.org/es/docs/Web/CSS/filter) 👐
La idea es escribir sólo los estilos del estado por defecto, y obtener la apariencia de los demás estados mediante la propiedad filter, olvidándonos de todas las variaciones de los colores.
En el siguiente ejemplo uso la función `brightness()`. Entonces hago el botón más clarito para el hover y lo hago más oscuro para active y focus.
Pero también podés usar otras funciones como `opacity()`, `grayscale()` y `saturate(`). Es cuestión de probar lo que mejor se ajuste al aspecto que querés conseguir.
Podemos ver que incluso podemos aplicar lo mismo para enlaces.

{% codepen https://codepen.io/LucasMaidana/pen/jOqREYj default-tab=css,result %}

En resumen:

```
button:hover {
    filter: brightness(1.15);
}
button:active, button:focus {
    filter: brightness(0.95);
}
```

Podés encontrar más ejemplos en los links que dejo al final.
Muchas gracias por leerme. Ojalá te sirva este tip para tus próximos proyectos. 💪

### Fuentes:
- [Using the brightness() CSS Filter to generically highlight Content - Rick Strahl's Web Log](https://weblog.west-wind.com/posts/2020/Jul/28/Using-the-brightness-CSS-Filter-to-generically-highlight-Content)
- [Button styles using filter and brightness](https://codepen.io/parkji/pen/bxunC)


[![Invitame un café en cafecito.app](https://cdn.cafecito.app/imgs/buttons/button_1.svg)](https://cafecito.app/lucasmaidana)
Strategies to understand codebase ?
Tags: webdev, programming, productivity, discuss
Published: 2022-03-24 21:24:04

The ability to understand a codebase is really helpful when one is trying to make tweaks/develop the underlying code.  Ideally, repos have good documentation to guide the interested developer but for the most part, this may not necessarily exist.

Therefore, given a GitHub repo, what's a good strategy to understand _(in broad strokes)_ the structure of the code?
echo3D graduates from Intel Ignite--Building the backend of the Metaverse
Tags: metaverse, intel, 3d, gamedev
Published: 2022-03-24 21:01:31

[**echo3D**](http://www.echo3D.co) officially graduated from [Intel Ignite](https://www.intel.com/content/www/us/en/now/ignite/overview.html), Intel's startup growth program. Chosen out of hundreds of applicants, only 10 companies, including echo3D, made the final cut and participated in the 12-week intensive program, focused on innovative deep tech startups.

echo3D offers a cloud platform for 3D/AR/VR that provides tools and network infrastructure to help developers & companies quickly build and deploy 3D apps, games, and content. With Intel Ignite's support, echo3D is working to build and support the backend of the Metaverse and streamline the 3D development process by providing a way to manage, store, and stream 3D data. echo3D's 3D-first content management system (CMS) and delivery network (CDN) and a scalable BaaS infrastructure enable developers to build and deploy real-time 3D/AR/VR applications across platforms, headsets, and mobile devices, by connecting them to the cloud.

"_Intel Ignite's commitment to authentic mentorship, collaboration, and giving back is like noting I've seen before in any other program I've encountered_," Said Koren Grinshpoon, founder and COO of echo3D. "_It what makes the impossible, possible_." Intel Ignite provides startups with access to global experts in technology and business as well as a preferred path to seasoned investors.

**Applications for Intel Ignite's next cohorts in** [**Tel Aviv**](https://www.f6s.com/intel-ignite-tlv-6/apply) **and** [**Munich**](https://www.f6s.com/intelignite/connect) **are now open!**

***

>_**echo3D** ([www.echo3D.co](http://www.echo3d.co/); Techstars 19') is a cloud platform for 3D/AR/VR that provides tools and network infrastructure to help developers & companies quickly build and deploy 3D apps, games, and content._

![](https://miro.medium.com/max/1400/0*9sQLAWCD9hzFXH8y.png)
Service Discovery in Microservice Architecture.
Tags: serviceregistry, servicemesh, microservices, node
Published: 2022-03-24 20:35:09


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8v1dlx02e22yezmb13bt.png)In this article I will try to explain about Service Discovery in the Microservices Architecture.

As we all know that, in MS Architecture all the services may have n number of instances running. In this type of architecture, services might be scaled up or down which make the changes in number of instances particular services. As a result,  all of the instances of the services are running on different port. Then how can an application handle request and find the suitable or desirable service among these ports ? That's where we need Service Discovery mechanism in order to serve request according to need of application. 


**What is Service Discovery ?**

It is an infrastructure which keep tracks of all the services instances and route the request to it. 

There are 2 Ways to Implement such infrastructure.

1.Service Mesh 
- This is used in mostly containerized infrastructure, where container keeps tracks of services.

2.Service Registry 

-  When application does not have any control over network and there can be lot of inclusion of services then this pattern is more useful as it is working at application level. 

- Here, whenever a new service gets a life it will register it self to this service registry. So now if application wants to know about this service it will query to this service registry and service registry will provide metadata about requested services.

- In addition to these, if one service has more than one instances running and registered @ service registry then service registry will provide port of request service to the application in such a way that load can be balanced in more efficient way.
What happens to the records inserted into a table variable, if the transaction rollback?
Published: 2022-04-09 15:35:47

---
title: What happens to the records inserted into a table variable, if the transaction rollback?
published: true
date: 2022-03-24 20:25:41 UTC
tags: 
canonical_url: https://blog.rajanand.org/what-happens-to-the-records-inserted-into-a-table-variable-if-the-transaction-rollback
series: SQL Interview Questions and Answers
---

```
DECLARE @People TABLE (first_name VARCHAR(50), age int);
BEGIN TRAN
INSERT INTO @People VALUES ('John', 25);
INSERT INTO @People VALUES ('Daniel', 30);

ROLLBACK

SELECT * FROM @People;

```

## Answer:

The records inserted into a table variable will not be affected by the transaction rollback.

![1118_20220406_004013.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1649189941814/YBUdXEA2w.png)

Reference: [Brent Ozar](https://twitter.com/BrentO/status/1296117565823934464)

If you like this SQL interview question, you may also like the below interview question and answers.

- [What happens to the variable value set during the transaction, if its rollback?](https://blog.rajanand.org/what-happens-to-the-variable-value-set-during-the-transaction-if-its-rollback)
- [How to generate permutations in SQL?](https://blog.rajanand.org/how-to-generate-permutations-in-sql)
- [How to do reciprocal in SQL?](https://blog.rajanand.org/how-to-calculate-total-travel-hours-between-city-x-and-y-and-vice-versa)
- [How to find account balance (running total) in SQL?](https://blog.rajanand.org/how-to-find-an-account-balance-in-sql)
Myfe - 24/03/22
Tags: css, python, gamedev, html
Published: 2022-03-24 20:24:37

## CSS

So I decided to add CSS to my game to make it look a bit better.
Problem is, I'm not that great at CSS, so I tried as much as I could.
First I created a file called `style.css` in the folder `static` and then gave it a url in `app.py`:

```py
@app.route("/style.css")
def stylecss():
  return send_file("static/style.css")
```

After that I linked the css file to every HTML page, by doing the code below:

```html
<link href="/style.css" rel="stylesheet" type="text/css" />
```

Then I added some simple dark mode code in the CSS file:
```css
body {
  background-color: #121212;
  color: white;
  font-family: 'Source Code Pro', monospace;
  scroll-behavior: smooth;
}
```
which gave the background a dark grey colour, made the text colour white, gave the text have the `Source Code Pro` font, add gave the page a smooth scroll-behavior, just incase I needed it for the later.

The output looked like this:

![css output 1](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dqq96dsibv15u56ntmem.png)

So I decided to work on the links and added the following code:
```css
a {
  text-decoration: none;
  color: rgb(206, 203, 203)
}

a:hover {
  color: rgb(136, 133, 133)
}
```

and that gave the output of:

![css output 2](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fsq7jxe2drc21wzlfwyz.png)
with the `Profile` link being hovered.

The navbar didn't look that good, so I added the following code to make it look better:
```css
.navbar {
  text-align: center;
  overflow: hidden;
  border-bottom: 1px solid #2b2a2a;
  background-color: #121212;
  position: sticky;
  top: 0;
}

.nav-link {
  font-weight: bold;
  font-size: 14px;
  text-transform: uppercase;
  text-decoration: none;
  color: rgb(204, 206, 209);
  padding: 20px 0px;
  margin: 0px 20px;
  display: inline-block;
  position: relative;
  opacity: 0.75;
}

.nav-link:hover {
  opacity: 1;
}

.nav-link::before {
  transition: 300ms;
  height: 5px;
  content: "";
  position: absolute;
  background-color: rgb(204, 206, 209);
}

.nav-link-ltr::before {
  width: 0%;
  bottom: 10px;
}

.nav-link-ltr:hover::before {
  width: 100%;
}
```

That gave me the output of:

![css output 3](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3is2hvae9dqlo3jngf86.png)

with the `Profile` link being hovered on.

That looked much better!

And for the finishing touches I changed the text-align of the header to the center:

```css
.header {
  text-align: center;
}
```

Now it looks like:

![css output 4](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i956bdwotfff1qug80uo.png)

Yay! Next time I'll be working on the Python part and MongoDB.
Thanks for reading and if you liked it make sure to follow me!
We wanted to create a tool to fix yamls...then we got a community
Tags: yaml, devops, python, kubernetes
Published: 2022-03-24 20:24:28

## 👉 Intro

Recently we built a library that would lint & fix `yamls`, that we also did embed as a Github Action so we could use this tool as part of our CI pipeline : 

{% embed https://dev.to/adriens/let-ci-check-fix-your-yamls-kfa %}

What we did not know at that time is that...

> _that was just the beginning of a journey._

## 📦 Release the `cli`

Progressively we started to focus on `yamlfixer` `cli` user experience, features, packaging and delivery.

So the context slowly started to shift from a background  hidden tool to a full tool, with more features and more integrations.

We started to automate [package delivery on `pypi`](https://pypi.org/project/yamlfixer-opt-nc/), make install process much easier, [create demo scenarios](https://www.katacoda.com/opt-labs/courses/devops-tools/yamlfixer), create [one liners](https://github.com/opt-nc/yamlfixer/blob/main/README.md#-one-liners), [plug into `jq`](https://github.com/opt-nc/yamlfixer/blob/main/README.md#piping-json--summary-through-jq) , plug it into [gomplate template engine](https://github.com/opt-nc/yamlfixer/issues/31), ...integration scenarios and many other exciting things, very efficiently around our Dev & OPS pipeline, all that very naturally.

> While the collaboration through GH issues was fully remote, we even did an internal (30' minutes long) meetup to share about vision and issues.

At the end of the first week I was mesmerized : 

{% embed https://asciinema.org/a/478928 %}

> _we wanted a `cli` tool to fix `yamls` but finally we built a community !_

## 🎞️ Video demo

Find below first live demo video (in French) with a lot of more details about what we did :

{% youtube https://youtu.be/_FiVaMFITkI %}

## 🎬 asciinema demos

Below some dedicated [`asciinema`](https://asciinema.org/) demos :

- [First Kickstart](https://asciinema.org/a/478928)
- [Backup suffix](https://github.com/opt-nc/yamlfixer/issues/70) feature [demo](https://asciinema.org/a/479510)

Feel free to contribute yours on the GH project 👇

## 🧑‍🤝‍🧑 Contributors

Many thanks to the core team I really enjoy working with on a daily basis on many other DevOPS challenges, helping pushing disruptive new ideas :

- 👱‍♀️ [Michèle](https://dev.to/mbarre)
- 🧔‍♂️ [Jérôme](https://github.com/tamere-allo-peter)

## 🔖 Project repo

For more about the project just : 

{% github opt-nc/yamlfixer %}
Electron meets Vue.js 3 and Parcel.js 2
Tags: vue, electron, parceljs
Published: 2022-03-24 20:06:56

---
title:Electron meets Vue.js 3 and Parcel.js 2 
published: true
description: Electron meets Vue.js 3 and Parcel.js 2 
tags: VueJs, Electron, ParcelJs
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1zdovs7z49wsdfwgti1d.png
---

It’s easy to build a desktop app through Electron. But if you need state management or interesting views, it can get complicated. 

If you search for boilerplates with Electron + React or Vue, you’ll find that many of them have added complexity that isn’t needed for building a small app.  That’s why I created **this boilerplate with the basic features, which you can find on Github.** 

### Why this three technologies

It was a no-brainer for me to use these technologies: 

- **Vue.js** as the front end framework. When it comes to building a UI, it doesn’t get much simpler.
- **Electron.** Used in many of the apps we use daily. (It’s bananas that it’s just javascript.)
- **Parcel**. My go-to building tool. It just works. Perfectly.

And like everything, it wasn't all plain sailing. Putting together an app when Vue.js 3 and Parcel 2 were in their early stage versions was challenging at times but that led me to learn even more about the three technologies.

I’ve written detailed documentation in the Readme, including folder structure, how to make a release, and how the events works in Electron.

### Real world example

The motivation for this project came from my friends complaining about the HEIC format of iPhone photos. I decided to create a simple program to convert HEIC files to PNG/JPG, and this is where this boilerplate becomes handy. 

![the app](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/803a5417m91q50mdno1o.gif)

The app is **free to** **download** and the code is on Github. 

My first article 🥳 🎉
#Day 5 of Solving 450 questions[18/450]
Published: 2022-03-24 19:33:18

📅Day 5 : March 24,2022
Problems solved today : 
[Median of Two Sorted Arrays](https://leetcode.com/problems/median-of-two-sorted-arrays/)
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wra72r0qlt22vnp9bh3x.png)
 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fdo9wp9u4n59lflyptea.png)

[valid-palindrome](https://leetcode.com/problems/valid-palindrome/submissions/

[Intersection of Three Sorted Arrays](https://leetcode.ca/all/1213.html)


Things I learned Today:

Apparently, Regex cant be used to determine a palindrome according the Computational Theory(Stack overflow) or can it?
(1)https://leetcode.com/problems/valid-palindrome/discuss/1879713/Isalnum() --->Many ways to do it, but this is cooler.
(2) For last question ,be it easy, we needed to find an optimal soultion:
a)XOR operation is one way.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4lya6wk2qdepwtg7mkhd.png)
(b)Making Dictionary and Counting frequencies  
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iu9av28nlqq2an21yvhv.png)
Much Faster than traversing through 3 loops!
Reliability, Scalability and Maintainability
Tags: ddia, systems, distributedsystems
Published: 2022-03-24 19:31:30

- Reliability: The system should continue working correctly even when things go wrong e.g. the system should be able to deal with the user making mistakes.
- Scalability: The system should be able to serve it's users as the userbase grows.
- Maintainability: Many people will work on a given system and this should be as productive as possible.

**Load**
We can define the load on a system using load parameters and this varies from system to system.
Examples:
- Requests per second to a web server
- Number of concurrent users
- Hit rate on a cache

**Latency vs Response Time**
Response time is what the client sees (the time taken to process the request). Latency is the duration during which a request is waiting to be handled (awaiting service).

When discussing response times, using percentiles is better than just describing the average response time. The average does not provide an idea of how many users actually experience that delay. High percentile of response times (e.g. 99.9th percentile) aka tail latencies are important as they affect the users experience of the service.

Percentiles are often used in SLAs.

**Coping with load**
- Vertical scaling: moving to a more powerful machine
- Horizontal scaling: distributing load across multiple machines

Elastic systems involve scaling horizontally once an increase in load is detected.

**Maintainability**
A maintainable system is one that is easy to operate (easy for ops teams to keep the system running smoothly), simple to understand for new engineers and is easily extensible or evolvable.


(_summary of chapter 1 from Designing Data-Intensive Applications by Martin Kleppmann_)
Let's See How We Can Use ADF To Load Data from Any Source to Snowflake .
Tags: snowflake, azure, adf
Published: 2022-03-24 18:57:19


**Azure Data Factory Mainly Follow Two Approaches**

1. Direct Copy Approach . 
2. Stage Copy Approach .


- **Direct Copy Approach** 

To load Data From Sources like Azure Blob Storage or other Azure Storage Services and Destination Other than Snowflake, In that case we can use Direct copy Approach , We do not need to Configure Staging area . By Just passing Source Data Set and Sink Data Set we can Implement our Pipeline .

- **Stage Copy Approach**

If We Want to Load our Data to Snowflake from Sources other than Azure Storage Services , we will use a Stage Copy Approach. For that we need to Configure our staging , and pass the Source Data Set as well as Sink Data Set .
 

![Stage Copy Approach](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7o4e497z9m81cl1hsiew.png)


**Now Let's See how we are Loading data from MYSQL to Snowflake using ADF**

**Steps - **

1. Setup Azure Account → SignIn into your account → Go to Azure Portal.
2. In Azure select and create a new Project in Azure Data Factory.
3. Setup Snowflake Account → Create a  Users → Create a Database and Schemas.
4. In Studio Go to the Manage Section , And Create a new Linked Service To Connect MYSQL with ADF.


![MYSQL Linking Services](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/aftvhcutrjby4egs9b27.png)


5. After that , Create a New Linked Service for Snowflake .


![Snowflake Linking Services](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/q5e6rq8l6sgty028vbmx.png)

6. Now go to the author section in ADF and click on the icon of the data set and create a new data set from the source table.
7. After creating data sets from source, now create a data set for destination. For this we need a table in our snowflake account, so create a table in a snowflake account and then in  ADF create a new data set for the snowflake table.

![Snowflake Dataset](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/gf1mm2vogrerjiszr1up.png)

8. After you are done with creating data sets now we are good to move to create a pipeline. For this you need to go in the pipeline section and create a new pipeline, In activity section you will Copy Data.


![Creating a PipeLine](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/x83xlgsv3nh7poqxmciy.png)


9. Now , click to the Copy Data command and configure the Source and Sink Tabs.
10. Run your Azure Data Factory Pipeline to load the data into Snowflake. You should see in Snowflake a call to the ODBC in your history table. This is how you know ADF has successfully landed data in Snowflake .