teleren/devto huggingface dataset:
Do Desenvolvimento aos Dados
Tags: datascience, career, aws
Published: 2024-03-21 00:15:49

> "_Estou aprendendo a andar de novo_

> _Acredito que esperei tempo demais_

> _Por onde devo começar?_" - Walk, Foo Fighters

**Alerta: Este texto contém um pouco de desabafo** 😅

## O Fim 

E aí, pessoal, espero que quando se deparem com este post estejam bem. Acredito que, assim como eu, existam outras pessoas que buscam exemplos parecidos para tentar ter um norte na carreira, e com este texto espero que você não se sinta mais só nesse momento.

Desde o início dos meus estudos na área de tecnologia, vinha sonhando em ser desenvolvedor: muitas vagas, altos salários e aquelas propagandas infames de curso falando "seja um desenvolvedor em 6 semanas com um salário de 5k". Acredito que, mesmo com algumas discrepâncias em relação aos anúncios, muitos que tentaram há uns anos realmente alcançaram isso, o que não foi o meu caso, infelizmente 😅.

Passei pela área de suporte ao usuário (o que, para mim, foram experiências que me fizeram pensar em mudar de curso de Ciências da Computação para ADM), pela área de testes de software e, enfim, o tão desejado emprego como desenvolvedor. Aprendi muito, mas senti que desenvolvimento frontend não era para mim.

## Começando Novamente

Desde o fim da minha experiência como desenvolvedor até agora, estou por volta de 1 ano e alguns meses desempregado. Continuei estudando programação, fiz uns projetos como freelancer, o que reforçou ainda mais minha vontade de sair do front. Até que então pensei "e a área de dados?". Decidi me arriscar e investir em dados.

Durante a faculdade e o emprego como analista de testes, estudei um pouco sobre dados, ouvia podcasts, aprendi sobre o Kaggle mas sem me aprofundar tanto, até comprei uns livros da área que ficaram uns 3 anos parados. Hoje agradeço muito pelo Rogério do passado ter comprado isso, ele estava trabalhando e na época os livros estavam mais baratos, hoje desempregado e os livros com valor mais elevado seria muito ruim 😅.

Me matriculei numa pós-graduação de Ciência de Dados e Inteligência Artificial, participei de palestras que me incentivaram a tirar uma certificação AWS (não tenho conhecimento nenhum em nuvem basicamente, mas estou estudando), adquiri alguns cursos de dados e consumo conteúdos sobre também no YouTube.

Não está sendo fácil, a cobrança interna é grande, e durante meus estudos são abordados outros assuntos diferentes do desenvolvimento de software, o que me faz ficar meio perdido, fazendo o estudo se aprofundar mais. Tento tomar isso como combustível para continuar em frente, pois muitas coisas que são boas na vida não são fáceis de conseguir.

Bem, este foi um pouco da minha jornada e um desabafo também. Aos que estão se sentindo perdidos como eu fico às vezes, não parem de andar, é melhor permanecer seguindo em frente de alguma forma do que estagnado, falo isso por experiência pessoal.

Obrigado por ter lido, caso queira comentar algo, dar alguma dica ou até mesmo bater um papo, fique à vontade 😁.

Vlw, Flw.
PostgreSQL command line psql cheat sheet
Tags: postgres, webdev, beginners
Published: 2024-03-21 00:10:41


## Tools Overview
postgres = open source relational database software
psql = command line tool to connect to postgres
pgAdmin = web based tool front end to psql - not discussing here

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


This cheat sheet is for psql.  Other 3rd party tools exist for connecting to postgres databases.  (Dbeaver is a popular choice)

# Postgres cmd line tool psql
Official docs
https://www.postgresql.org/docs/current/app-psql.html

Command | Description
---|---
psql --help |list help
psql --username=postgres | login to postgres cmd line

When logged in:

Command | Description
---|---
\list | print out list of databases
\c \<db name> | connect to a certain database
\dt | show all tables in current schema
\df | list functions of current database
\dv | list views of current database
\du | list users and roles
\q | quit postgres cmd line
SELECT * from mytable; | select statement to table
Test driven development (TDD) with RSpec workshop in July
Tags: learning, testing, ruby, rspec
Published: 2024-03-21 00:07:07

Do you feel uncomfortable working with RSpec? Unsure what to test and how writing tests helps you to write better code? Would you like to build an effective and fast testing environment?

I am running a workshop on test driven development (TDD) in Ruby with RSpec in July.

In four days, you will learn everything you need to know to start practicing TDD. You will understand the basics, apply best practices, learn the difference between test helpers (stubs, mocks, double, spies), create a fake server for testing apis, and optimise your test suite run time. Basically, become proficient with RSpec.

To learn more and get your ticket, visit our [website](https://blackmill.co/coaching-training/workshops/tdd-with-rspec?utm_source=devto&utm_medium=social&utm_campaign=workshops&utm_content=tdd). Early tickets are available now!


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/skdbk9hwxyolzr7e7pc2.jpg)
Why you should use a terminal editor to write a commit message
Tags: softwaredevelopment, softwareengineering, git, linux
Published: 2024-03-20 23:52:22

Ever since starting to only use Git in the command line, I've been writing commit messages through a **terminal editor** (`nano`), instead of passing the message (`-m`) flag. Some colleagues find it odd that I do it this way, so here are **seven** reasons in favor of using a terminal editor:

1. First of all, you need to **pass** the `-m` flag, and that alone is costing you time.
2. You need to **wrap** your message in quotes/ticks (""). Finding them on your keyboard can be somewhat hard.
3. You can't break lines in your message. Your brain is always under pressure to not click the **enter** key, otherwise, you will need to *amend* the commit message.
4. If the repository is configured with `pre-commit` hooks, they won't be executed until you click the **enter** key. This is particularly bad if commit messages need to follow a specific structure.
5. Oh, you managed to click the enter key and **accidentally created** a commit? You need to repeat the whole process to amend the commit message (this includes copying/writing the message and passing the `--amend` flag).
6. Your terminal shell interpreter (`bash/zsh/csh...`) is very **sensitive** to **special characters**. To include them, you will need to think of ways to either escape them or make sure the interpreter won't evaluate them. (e.g., imagine you need to write this message: `fix: apply "$HOME" instead of using single ticks (''))`)
7. Copy-pasting a message might give you a hard time. If the message includes **Unicode** characters that your terminal has issues to **render**, like emojis, it will be a pain to **correct** them. 


All of these issues can be avoided if you learn the basics of a terminal editor (`nano` is really simple!) and type `git commit` (or even better, declare a shorthand alias like `gc` that will save you a ton of time).

Cross-Post: https://joaomagfreitas.link/why-you-should-use-a-terminal-editor-to-write-a-commit-message/

Background Image: https://cbea.ms/git-commit/
Installation of Docker Compose:
Tags: dockercompose, docker, backend, backenddevelopment
Published: 2024-03-20 23:11:42

Create a directory for Docker Compose: 
mkdir -p ~/.docker/cli-plugins/

Download Docker Compose: 
curl -SL https://github.com/docker/compose/releases/download/v2.11.2/docker-compose-linux-x86_64 -o ~/.docker/cli-plugins/docker-compose

Grant execution permissions:
chmod +x ~/.docker/cli-plugins/docker-compose

Verify the installation: 
docker compose version
alpine door service
Published: 2024-03-20 23:10:06

We offer the best rated door repair service in Fort Worth or in Arlington TX. To learn more about how we may assist your needs, see our list of services below. To request a door repair or entry door installation, please request a free quote through our online form or by giving us a call at (817) 332-4442. Alpine Door Service is a door repair company that has been providing professional quality service that people trust for more than 20 years
alpine door service
https://www.alpinedoorservice.com/
817-332-4442
alpineds@yahoo.com
Css
Tags: frontendchallenge, devchallenge, css, javascript
Published: 2024-03-20 23:04:26

_This is a submission for DEV Challenge v24.03.20, CSS Art: Favorite Snack._****
css
## Inspiration 
<!-- What snack are you highlighting today? -->

## Demo
<!-- Show us your CSS Art! You can directly embed an editor into this post (see the FAQ section of the challenge page) or you can share an image of your project and share a public link to the code. -->

## Journey
<!-- Tell us about your process, what you learned, anything you are particularly proud of, what you hope to do next, etc. -->

<!-- Team Submissions: Please pick one member to publish the submission and credit teammates by listing their DEV usernames directly in the body of the post. -->

<!-- We encourage you to consider adding a license for your code. -->

<!-- Don't forget to add a cover image to your post (if you want). -->


<!-- Thanks for participating! -->
Efficient Date and Time Extraction in MS SQL Server
Tags: mssql, dates
Published: 2024-03-20 23:00:00


MS SQL Server offers robust features for structured data management. This article introduces efficient techniques for extracting date and time from the datetime function, focusing on the **`CONVERT`** and **`CAST`** functions.

###Simplified Date and Time Extraction Techniques

The **`datetime`** data type in MS SQL Server holds date and time together. To fetch the current datetime, use **`SELECT getdate();`**. For date extraction, **`CONVERT`** is handy, e.g., **`SELECT CONVERT(date, getdate());`** extracts just the date. For time, **`SELECT CONVERT(VARCHAR, getdate(), 108);`** yields the time in hh:mm:ss format. The **`CAST`** function also plays a crucial role, with **`SELECT CAST(getdate() AS date);`** isolating the date from datetime.

###Concise FAQs

- **How is CONVERT used?** It's used for data type conversion and datetime value extraction.
- **Utilizing CAST for datetime extraction?** It changes the data type of an expression, facilitating the extraction of either date or time from datetime.

###Wrap-Up

The `CONVERT` and `CAST` functions make extracting date and time from datetime values in MS SQL Server both simple and efficient. These methods enhance data manipulation and analysis capabilities. Dive deeper into this topic by visiting [Extracting Time and Date in MS SQL Server: A Comprehensive Guide.](https://www.dbvis.com/thetable/extracting-time-and-date-in-ms-sql-server-a-comprehensive-guide/)
Payment Request API
Tags: frontendchallenge, devchallenge, javascript, webdev
Published: 2024-03-20 22:23:52

_This is a submission for DEV Challenge v24.03.20, One Byte Explainer: Browser API or Feature._

## Explainer
Payment Request API simplifies online payments by offering a standard browser interface for collecting payment details. It smoothens checkout processes, reduces manual input, and supports various payment methods, enhancing user experience and speeding up web transactions.

## Additional Context
Usage example:

```html
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Payment Request Example</title>
</head>
<body>
  <button id="buyButton">Buy Now</button>

  <script>
    // Check if Payment Request API is supported
    if (window.PaymentRequest) {
      const supportedPaymentMethods = [
        {
          supportedMethods: 'basic-card',
          data: {
            supportedNetworks: ['visa', 'mastercard'],
            supportedTypes: ['debit', 'credit']
          }
        }
      ];

      const paymentDetails = {
        total: {
          label: 'Total',
          amount: {
            currency: 'USD',
            value: '10.00'
          }
        }
      };

      const options = {};

      // Create Payment Request object
      const paymentRequest = new PaymentRequest(supportedPaymentMethods, paymentDetails, options);

      // Handle buy button click event
      document.getElementById('buyButton').addEventListener('click', async () => {
        try {
          // Show payment request
          const paymentResponse = await paymentRequest.show();
          
          // Process payment response
          console.log('Payment method:', paymentResponse.methodName);
          console.log('Payment details:', paymentResponse.details);

          // Complete payment
          await paymentResponse.complete('success');
        } catch (error) {
          console.error('Payment failed:', error);
        }
      });
    } else {
      console.error('Payment Request API is not supported.');
    }
  </script>
</body>
</html>

```
One Byte Explainer: matchMedia
Tags: frontendchallenge, devchallenge, javascript, webdev
Published: 2024-03-20 22:21:08

_This is a submission for DEV Challenge v24.03.20, One Byte Explainer: Browser API or Feature._

## Explainer
`matchMedia`, which exists on the window, is a method that facilitates checking CSS media queries in JavaScript. You can even use event listeners, with the `change` event, to detect media changes which can be super useful and, more importantly, cheap!

## Additional Context
`matchMedia` is just so useful for those rare instances where media queries in CSS aren't enough and it's so much lighter than manually getting the size of the page and rechecking on every resize 😅.
Web Audio API
Tags: frontendchallenge, devchallenge, javascript, webdev
Published: 2024-03-20 22:14:00

_This is a submission for DEV Challenge v24.03.20, One Byte Explainer: Browser API or Feature._

## Explainer
Web Audio API: Allows audio manipulation and synthesis directly in the browser. Perfect for creating music apps, interactive games, or audio visualizations, it provides low-latency, high-quality audio processing, enhancing user engagement and creativity on the web.

## Additional Context
Example usage of the Web Audio API: this code would in a file like index.js

```javascript
const audioContext = new (window.AudioContext || window.webkitAudioContext)();
```

```javascript
async function loadAudio(url) {
  const response = await fetch(url);
  const arrayBuffer = await response.arrayBuffer();
  const audioBuffer = await audioContext.decodeAudioData(arrayBuffer);
  return audioBuffer;
}
```

```javascript
async function playAudio(url) {
  const audioBuffer = await loadAudio(url);
  const source = audioContext.createBufferSource();
  source.buffer = audioBuffer;
  source.connect(audioContext.destination); // Connects to speakers
  source.start(0); // Play immediately
}
```

```javascript
const audioUrl = 'audio.mp3';
playAudio(audioUrl);
```
Shadow DOM API
Tags: frontendchallenge, devchallenge, javascript, webdev
Published: 2024-03-20 22:05:31

_This is a submission for DEV Challenge v24.03.20, One Byte Explainer: Browser API or Feature._

## Explainer
<!-- Explain a browser API or feature in 256 characters or less. -->
The shadow DOM API creates an encapsulated DOM tree attached to an element in the actual DOM known as the shadow host.

The nodes in this tree are invisible to CSS and JS except when referenced by the `shadowRoot` property.



## Additional Context
<!-- Please share any additional context you think the judges should take into consideration as it relates to your One Byte Explainer. --> 
This allows you to create nodes without breaking elements in the actual DOM, which can be used to provide additional features to custom elements.


<!-- Team Submissions: Please pick one member to publish the submission and credit teammates by listing their DEV usernames directly in the body of the post. -->

<!-- Don't forget to add a cover image to your post (if you want). -->


<!-- Thanks for participating! -->
Unleashing On-Page SEO: Elevate Your Website's Visibility
Published: 2024-03-20 22:05:15

On-page SEO is a crucial aspect of optimizing individual web pages to improve search engine rankings and attract targeted traffic. Here's a concise guide to mastering on-page SEO for enhanced online visibility.

Key Components:

Keyword Research: Identify relevant keywords and strategically incorporate them into titles, headings, and content.
Content Quality: Create high-quality, informative content that addresses user queries and provides value.
Meta Tags: Craft compelling title tags and meta descriptions to entice users and improve click-through rates.
URL Optimization: Keep URLs concise, descriptive, and include relevant keywords for better visibility.
Internal Linking: Establish a logical internal linking structure to improve navigation and distribute link equity.
Implementation Strategies:

Conduct a comprehensive audit to identify optimization opportunities.
Prioritize optimization based on keyword relevance and content quality.
Utilize on-page SEO tools to streamline optimization processes.
Monitor metrics such as traffic and rankings to refine your strategy.
Conclusion:
Mastering [on-page SEO](http://ayeshaseo.local/on-page-seo-strategic-roadmap-blogs-by-ayesha-seo/) is essential for enhancing your website's visibility and attracting targeted traffic. By focusing on key components and implementing effective strategies, you can achieve sustainable growth in the competitive online landscape.
Service Worker API
Tags: frontendchallenge, devchallenge, javascript, webdev
Published: 2024-03-20 22:05:04

_This is a submission for DEV Challenge v24.03.20, One Byte Explainer: Browser API or Feature._

## Explainer
Service Worker API: Powers offline features, push notifications, and caching for web apps, enhancing performance and user experience by enabling functionality without network connection, reducing dependency on the internet.
Shiba Inu Coin Price Risks Another 40% Fall If This Happens 🚨
Published: 2024-03-20 21:57:40



📉 Shiba Inu Coin price is quickly erasing gains since Q4 last year as meme coins tumble harder than others. With a market capitalization of $15 billion, it lost 19% in seven days and 28% in a fortnight to $0.0000255 on Wednesday. If trading volume continues to drop, Shiba Inu’s recovery will be significantly suppressed.

📈 SHIB had surged to $0.00004563 by March 5, following Bitcoin's rally above $73,000. However, a downturn in prices could impact meme coin hype from Q4 and Q1. Currently hovering between two key levels, SHIB faces resistance at the 20-day EMA at $0.0000265 and support at the 200-day EMA at $0.00002348. Failure to maintain support could lead to further losses. 📉

📊 The Relative Strength Index (RSI) suggests a downward bias, while dwindling network activity, including a 62.4% slump in active addresses from March 5, poses challenges for Shiba Inu's potential recovery. A drop in newly created addresses mirrors the price correction, indicating potential difficulties in sustaining an uptrend. 📉

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dyv54x33onj0ttospt6j.png)
Internet es una red compuesta de Muchas Redes
Published: 2024-03-20 22:02:28

Todo dispositivo conectado a una red tiene una dirección IP
única dentro de esa red.

```
63.123.8.32
```
Como saber si tu IP  es publica o privada
[Whatismyip](https://whatismyip.com.)
**IP pública:** Es una dirección IP que se puede acceder a través de Internet. Es lo equivalente a una dirección física.

**IP privada:** Es una dirección IP que se utiliza en una red local/privada, como la red Wifi de una casa.

**IP dinámica:** Es una dirección IP que puede cambiar en cualquier momento.

**IP estática:** Es una dirección IP que siempre va a estar asociada al mismo dispositivo.

DNS (Domain Name Server) es un servicio que se utiliza para consultar a qué IP está asociado un dominio. Por ejemplo, cuando entras a una página web como www.makeitreal.camp, tu computador, a través de tu conexión a internet, usa el servicio de DNS para encontrar a qué dirección IP está asociado el dominio que estás consultando , y así poder mostrarte la página deseada.
Los DNS mas confiables son los de Google
`
8.8.8.8
8.8.4.4
`
Day 931 : Keep Moving
Tags: hiphop, code, coding, lifelongdev
Published: 2024-03-20 22:02:21

_liner notes_:
- Professional : Pretty good day. Got some really good feedback my blog post on implementing a feature into a product from the folks that worked on the feature. I had a couple of more questions so I'm hoping to hear back so I can then get a content review going. Updated some documentation, code snippets and some tutorials. Followed up on some community questions. Just keep moving tickets! haha

- Personal : Last night, I filled out a bunch of tracks for the radio show for upcoming dates. Didn't get to look up the social media profiles for the artists though. Went down a rabbit hole looking at land. Did some research on my side project. Watched another episode of "Extraordinary". The show is pretty hilarious.

![The photo shows a beautiful landscape with a mountain range in the distance. The mountains are covered in snow. The foreground of the photo shows a valley with a pond. The valley is filled with green grass and yellow and red flowers. The sky is blue and there are some clouds in the sky. The location of the photo is East Fjords, Iceland.](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rxsppst4tp78awmj3d8h.jpg)

Going to go through Bandcamp and pick up some projects and get my social media posts for Friday ready. Maybe put together the starter set of tracks for this week's radio show. I'm thinking create a starter project to try some stuff that I'll eventually need in my current side project..

Have a great night!

peace piece
Dwane / conshus
https://dwane.io / https://HIPHOPandCODE.com
{% youtube 7-lWzQd_xeQ %}
📈💰 XRP Price: Analyst Bullish On XRP To Hit $1 In April As Price Nears $0.6
Published: 2024-03-20 21:58:45



📉 Amid the recent price dip witnessed by altcoins due to market corrections and BTC’s slip to $62K, a prominent analyst’s anticipation of XRP’s imminent run to $1 echoed a sense of frenzy across the crypto horizon today, March 20.

🔮 Dark Defender, a well-known crypto market analyst, recently took to a post on X, showcasing retained bullishness on the Ripple-backed token’s capability to scale $1 in April, giving rise to a colossal torrent of speculations.

💡 According to the analyst’s post on X, a critical examination of XRP’s market dynamics showcased Dark Defender’s previous predictions fell in line with the upcoming potential $1 prediction.

💰 Notably, XRP successfully achieved the $0.6462 target on the specified date, whereas it scaled $0.75, nipping at the heels of the second target. This anchored the analyst’s prediction’s foothold, sparking investors’ enthusiasm orbiting the token’s potential to showcase a phenomenally rising price action ahead.

📈 Meanwhile, based on XRP’s new high of $0.75, the analyst ruled out the next Fibonacci levels as $0.9772-$1.5048 and $2.3172 in the short term.

📊 As of writing, the XRP token’s price jotted a 1.15% upswing over the past 24 hours and is currently trading at $0.5976. Following its recent dip below the crucial $0.6 level, a regained upward momentum promptly nabbed significant attention toward the sixth-largest cryptocurrency by global market cap, falling in line with the analyst’s predictions.

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