teleren/devto huggingface dataset:
Unlocking Free AWS Certification Vouchers: Your Path to Cloud Career Advancement
Tags: aws, certification, devops, opensource
Published: 2023-10-01 10:04:14

**Have you ever felt hindered by the cost of a certification voucher while pursuing your dream career in the cloud? Imagine the possibilities if you could get your hands on a free AWS certification voucher. Well, the good news is that it's not just a dream! In this post, I'll unveil a remarkable opportunity to obtain 100% free AWS certification vouchers and provide insights into seven other avenues to explore.**

🔍 **Exploring the AWS Emerging Talent Community**
What is the AWS Emerging Talent Community? It's an exclusive, invite-only platform designed to empower learners from AWS Academy, AWS Educate, and AWS re/Start to advance their cloud skills and embark on rewarding cloud careers. By joining this thriving community, you gain access to personalized content recommendations, AWS Certification preparation resources, discount vouchers, and much more! Learn more

💡 **Unlocking Your Invitation**
While it's true that the community operates by invitation only, the process to secure your invite is surprisingly straightforward. You can achieve this too, in just a few hours. Simply create a free account at awseducate.com and utilize the filter feature to locate courses offering a badge. Completing any badge-eligible course puts you in line for an invitation to the ETC.

🌟 **Exploring Other Access Routes**
Apart from AWS Educate, two other AWS Education Programs can grant you access to the AWS Emerging Talent Community: AWS Academy and AWS re/Start.

🏆 **Earn and Redeem**
Once you're part of the community, you can accumulate points by conquering challenges. The more challenges you complete, the more points you earn, which can be redeemed for fantastic rewards, including AWS certification vouchers.

🌐 **Beyond Vouchers: A World of Opportunities**
The benefits of joining the AWS Emerging Talent Community extend far beyond obtaining a certification voucher. I recently took advantage of the AWS Mentor Program, which offers invaluable mentorship for emerging cloud professionals. The ETC is like a daily newspaper for cloud enthusiasts, where you'll discover curated technical and career-related content. It's also a fantastic platform to connect and network with like-minded individuals on their cloud learning journey.

🚀 **Exploring Other Free Voucher Avenues**
But wait, there's more! You can also secure free AWS certification vouchers through various other avenues:

1️⃣ AWS Community Builders Programme
2️⃣ All Builders Welcome Grant scholarship
3️⃣ AWS New Voices foundational speaker training program
4️⃣ Get AWS Certified – Sub-Saharan Africa Challenge organized by AWS Training and Certification
5️⃣ Join and actively participate in AWS User groups
6️⃣ Become an AWS Authorized Instructor
7️⃣ Attain the prestigious title of AWS Cloud Captain
markazpanel
Published: 2023-10-01 09:54:59

markazpanel is best company in iran this is best for buy sandwichpanel
sandwichpanel have alotof panel see our sites.
[ساندویچ پانل چیست
](https://markazpanel.com/what-is-sandwichpanel/)
[ساندویچ پانل دیواری](https://markazpanel.com/wall-sandwichpanel/)
[ساندویچ پانل سقفی
](https://markazpanel.com/roof-sandwichpanel/)
[ساندویچ پانل پلی اورتان](https://markazpanel.com/polyurethane-sandwichpanel/)
8 Methods to Help You Index and Rank Your Pages Faster | Readmorr.com
Tags: website, webdev, indexwebsite, rankwebsite
Published: 2023-10-01 09:40:42

# 8 Methods to Help You Index and Rank Your Pages Faster
https://readmorr.com/index-and-rank-your-pages-faster/

Introduction
In the world of digital marketing, getting your website’s pages indexed and ranked by search engines is crucial. Here are eight effective methods to help you achieve this goal faster.

## 1. Create High-Quality Content
Content is king in SEO. High-quality, unique, and relevant content attracts more traffic, which signals search engines about the importance of your website.

## 2. Use Relevant Keywords
Identify and use relevant keywords in your content. This helps search engines understand what your page is about and index it under the right categories.

https://readmorr.com/index-and-rank-your-pages-faster/

## 3. Optimize Your Meta Tags
Meta tags provide information about your webpage to search engines. Make sure to optimize your meta title and description with relevant keywords.

## 4. Use Internal Linking
Linking your pages internally helps search engines discover more of your content. It also improves the user experience by providing them with additional relevant information.

## 5. Build High-Quality Backlinks
Backlinks from reputable websites signal search engines about the credibility of your website, which can improve your ranking.

## 6. Improve Your Page Speed
Search engines favor websites that load quickly. Optimize your images, use browser caching, and reduce server response time to improve your page speed.

## 7. Use Social Media
Sharing your content on social media can increase its visibility and bring more traffic, which can help in faster indexing.

## 8. Submit Your Website to Search Engines
You can manually submit your website or a new page to search engines for faster indexing.

## Conclusion
By following these steps, you can improve the visibility of your website on search engines, leading to more traffic and higher conversions. Remember, SEO is a continuous process that requires time and effort, but the results are worth it.
WATCH FREE ASIA CUP - 2023
Published: 2023-10-01 09:38:59

In the fast-evolving digital entertainment landscape, finding the best platform to watch the much-anticipated Asia Cup 2023 can be a game-changer for sports enthusiasts. Among the various options available, the ""Pikashow app - download apk"" emerges as a prominent choice, offering a seamless and convenient way to catch all the action without a subscription fee.
**[Here](https://storysseed.blogspot.com/watch-free-asia-cup-2023)**

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wzjz4uq5r1cmm37u6bkz.jpg)
Distributing executable binaries in npm package
Tags: webdev, npm
Published: 2023-10-01 20:03:16

---
title: Distributing executable binaries in npm package
published: true
date: 2023-10-01 09:28:23 UTC
tags: webdev,npm
canonical_url: https://stereobooster.com/posts/distributing-executable-binaries-in-npm-package/
---

Let’s say you need to distribute binary in npm. I’m not talking about node extensions (node-gyp, napi, etc.). I’m talking about standalone executables, like CLI applications.

We have options. **How to distribute binary** :

1. host executables on some server, for example, GitHub releases, and download appropriate (e.g. for given OS and architecture) binary on installation
2. put all executables (for all OSs and architectures) in one npm package
3. create sub-packages with binary for each OS and architecture and one “root” npm package which would list all sub-packages as optional dependencies

**How to run the binary** :

1. Use JS wrapper which would call actual executable with `exec`, `spawn`, etc.
2. On installation figure out where Node puts binaries and overwrite it with your binary from the package
3. Use JS script to call node binding (`*.node`) or WASM

**Tools and blog posts** :

| name | distribution | execution |
| --- | --- | --- |
| [binary-install](https://github.com/EverlastingBugstopper/binary-install) | 1 | 1 (`spawnSync`) |
| [binwrap](https://github.com/avh4/binwrap) | 1 | 1 (`spawn`) |
| [bin-wrapper](https://github.com/mole-inc/bin-wrapper) | 1 | 1 (`spawn`, …) |
| [prebuild-install](https://github.com/prebuild/prebuild-install) | 1 | 3 |
| [blog.xendit.enginee](https://blog.xendit.engineer/how-we-repurposed-npm-to-publish-and-distribute-our-go-binaries-for-internal-cli-23981b80911b) | 2 | 2 |
| [hspak.dev](https://hspak.dev/post/publish-npm/) | 2 | 2 |
| [prebuildify](https://github.com/prebuild/prebuildify) | 2 | 3 |
| [blog.orhun.dev](https://blog.orhun.dev/packaging-rust-for-npm/) | 3 | 1 (`spawnSync`) |
| [napi-rs](https://github.com/napi-rs/package-template) | 3 | 3 |

**Example projects** :

| name | distribution | execution |
| --- | --- | --- |
| [odiff](https://github.com/dmtrKovalenko/odiff) | 2 | 2 |
| [@astrojs/compiler](https://github.com/withastro/compiler) | 2 (WASM) | 3 |
| [esbuild](https://github.com/evanw/esbuild) | 3 | 1 (`execFileSync`) |
| [biome](https://github.com/biomejs/biome) | 3 | 1 (`spawnSync`) |
| [Turborepo](https://github.com/vercel/turbo/tree/main/packages/turbo) | 3 | 1 (`execFileSync`) |
| [lightningcss](https://github.com/parcel-bundler/lightningcss) | 3 | 3 |
Vector Databases & AI Applications for Dummies
Tags: singlestoredb, vectordatabase, pinecone, openai
Published: 2023-10-01 09:18:17

The new book "Vector Databases & AI Applications for Dummies" is now available. [Register](https://www.singlestore.com/resources/vector-databases-and-ai-applications-for-dummies/) to get your free copy. Visit [GitHub](https://github.com/singlestore-labs/vector-dbs-ai-apps) for online supporting material for this book.

![Vector Databases & AI Applications for Dummies](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/k56bu9le07kf9f22ebsw.png)
Hire Wise – Multipage Job platform
Tags: tailwindcss, astro, webdev, javascript
Published: 2023-10-01 09:11:13

Hire Wise – Multipage Job platform
Built with Astro, Tailwind CSS and MDX

Includes
- Pages 25
- Sections 50+
- Components 80+

See it live and learn more:
- lexingtonthemes.com/info/hirewise

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/cpzk405gctow0svnayh4.png)
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/einl66x9dfsc3xi6yul6.png)
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/nsk63edh0k1nx3un56lg.png)
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/z615ov590fdrx33bxq6u.png)
Database Keys
Tags: database, sql, learning
Published: 2023-09-30 20:57:58


**what is a key?**

A data item that allows us to uniquely identify an individual occurrence, record or an entity[table] in databases

**Types of keys:**

**1.Primary key** : One or more column or attribute that distinguishes a specific record from another e.g Employee_id in employee table,
employee_id & id_number also being used as primary key


**2.Foreign Key**-One or more attribute in an entity/table that enables a relationship to another entity 

e.g deptno in employee table

**3.Candidate key**-Any column that could be used as the primary key.

**4. Secondary Key**-Candidate key that is not chosen as the primary 
key. Primary key is selected from candidate keys, and those not selected are referred to as secondary key

**5.Simple key**: A single attribute that uniquely distinguishes a specific record from another e,g employee_id only or id_number only

**6.compound key**: A key made up more than one simple key and each of the keys making up the compound key are simple keys on their own 

**7.composite key** : A key made up or more than one simple key and each of the keys making up the composite key are **not** simple keys on their own 

e.g employee_id and employee_jobtitle employee_id is a simple key but employee_jobgroup is not a simple key on its on

**8.Artificial Key**: Keys generated by a business e.g., VIN numbers for vehicles, ISBN for books.

**9:Natural keys** : keys derived from real world occurrences e.g 
SSN,ID number

**10: Surrogate key**: A key that uniquely identifies a row, has no relationship with the record it is identifying other than identifying the row uniquely, it is system generated and is mainly used in OLAP systems to maintain history


**Advantages of surrogate key**

•It is good for maintaining history, used mainly in OLAP e.g., in slowly changing dimension

•it is immutable and has high performance because of its compact datatype (such as a four-byte integer).
 
•Surrogate keys are also less expensive to join (fewer columns to compare)

•Uniformity - When every table has a uniform surrogate key, some tasks can be easily automated by writing the code in a table-independent way.


                    
**Disadvantage**:

•Disassociation- The values of generated surrogate keys have no relationship with the real world meaning of data stored/held in a row.

**11. Business Key**: Unlike surrogate key , business key is a type of key that uniquely identifies an object or a record in the 
database.
Mastering SQL's Recursive CTEs
Tags: sql
Published: 2023-10-01 09:08:41

**Common Table Expressions (CTEs)** are a powerful feature in SQL, and when combined with recursion, they become even more formidable. Recursive CTEs allow you to generate sequences, hierarchies, and perform other complex operations with elegance. In this blog, we'll explore the basics and provide practical examples to demonstrate their potential.

## Understanding Recursive CTEs

A Recursive CTE is like having a reusable script, where a query refers to its own output. This feature is ideal for tasks that involve iteration or hierarchical data.

### Example 1: Generating a Sequence of Numbers

Let's start with a classic example: generating a sequence of numbers. In this case, we want to create a sequence from 1 to 10.

```SQL
WITH RECURSIVE numbers AS (
  SELECT 1 AS n
  UNION ALL
  SELECT n + 1 FROM numbers WHERE n < 10
)
SELECT * FROM numbers;
```

![Sequence of Numbers](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/9bfib9tnrczai2x1mlnw.png)

This query initializes the CTE with 1, then repeatedly adds 1 to the previous value until the condition `n < 10` is met. The result is a sequence from 1 to 10.

### Example 2: Calculating Factorials

Recursive CTEs are not limited to sequences. You can also use them for more complex calculations, like calculating factorials.

```SQL
WITH RECURSIVE factorials AS (
  SELECT 1 AS n, 1 AS factorial
  UNION ALL
  SELECT n + 1, (factorial * (n + 1)) FROM factorials WHERE n < 9
)
SELECT * FROM factorials;
```

![Calculating Factorials](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/bjor7c7vfi02ph9wbv7q.png)

Here, we calculate factorials from 1 to 9. The CTE multiplies the current factorial by the next number in the sequence until `n < 9`.

## Conclusion

Recursive CTEs are a powerful tool in SQL, enabling you to solve various problems efficiently. They are not limited to simple sequences and can handle complex calculations and hierarchies. Understanding how to use them can significantly enhance your SQL skills and make your queries more elegant and concise.

Happy querying! 🚀📊
Embracing the Digital Age: An Introvert's Perspective on Professional Social Engagement
Tags: introvertprofessionals, socialengagement, careergrowth, professionalcommunity
Published: 2023-10-01 08:51:15

As an introvert with more than 14 years of experience in the software profession, I often find myself reflecting on the bustling world around me. It's a world where individuals are relentlessly focused on doing anything and everything to stay relevant and thrive. They're writing blogs, crafting articles, producing captivating reels, and creating engaging YouTube videos, all in the pursuit of recognition and influence in their respective fields. It's not just about entertainment; this eagerness for self-promotion extends across professions, from Chartered Accountants and Financial Consultants to Entrepreneurs and Engineers. Many of us can relate to this ever-increasing demand for visibility and presence.

But, as they say, time waits for no one, and we must keep pace with the rapidly evolving landscape of our digital age. I'm not entirely sure why I'm penning down these thoughts, but it's been on my mind for a while now. I've felt the urge to join the social bandwagon, to engage, to share, and most importantly, to learn and connect with my professional peers. My aim is to make meaningful contributions to my professional community, and I believe that now is the time to do just that.

In this era of constant connectivity, we introvert, often labelled as reserved or shy, have a unique perspective to offer. We're deep thinkers and keen observers, and we excel at listening and processing information. While we may not be the ones to grab the spotlight at a conference or post daily updates on social media, we possess valuable insights and a wealth of knowledge to share.

The digital realm offers introverts a comfortable platform to express themselves. We can write thoughtful blog posts, engage in meaningful discussions on LinkedIn, and share our expertise through articles and videos, all while staying true to our introverted nature. It's not about competing with the extroverts; it's about finding our voice and making our mark in the online professional community.

So, if you're like me, an introvert who's been considering a more active role in the digital age, I encourage you to take that leap. Embrace the opportunities that social engagement offers, whether it's through writing, video content, or even thoughtful comments on industry discussions. Let's learn from one another, contribute our unique perspectives, and make our presence felt in the ever-evolving professional landscape.

The world is changing, and it's time for us introverts to evolve along with it, finding our place in the digital tapestry that connects professionals across the globe. Together, we can create a space where introverts shine just as brightly as their extroverted counterparts, making meaningful contributions and fostering enriching connections in our professional journey.
How to Install NVM and Node on macOS M1 Silicon in 2023
Tags: mac, node, nvm, m1
Published: 2023-10-01 08:40:10

As a software engineer working on a Mac with an M1 Silicon chip, having NVM (Node Version Manager) and Node.js installed is crucial. In 2023, setting up your development environment for Node.js on an M1 Mac is easier than ever. In this guide, we'll walk you through the steps to install NVM and Node.js, enabling you to streamline your development workflow.

**Step 1: Get NVM**

1. **Check for .zshrc Profile**: Open a new terminal window and run the following command to check if you already have a .zshrc profile:

   ```shell
   $ ls -a
   ```

   If you see `.zshrc` in the list, you can skip this step. However, if it's not there, you need to create one:

   ```shell
   $ touch .zshrc
   ```

2. **Install NVM**: Now that you have a .zshrc profile, it's time to install NVM. Visit the official NVM GitHub repository [[here](https://github.com/nvm-sh/nvm#install--update-script)] to find the NVM cURL install command. The command should look something like this:

   ```shell
   $ curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.39.1/install.sh | bash
   ```

   Copy this command and paste it into your terminal. This will download and install NVM, making it available for use.

3. **Refresh .zshrc**: As this installation affects your .zshrc profile, you should run the following command to update it:

   ```shell
   $ source .zshrc
   ```

   Congratulations, you now have NVM installed on your Mac!

**Step 2: Get Node**

1. **Install Node**: To install Node.js using NVM, simply run this command in your terminal:

   ```shell
   $ nvm install node
   ```

   This command will download and install the latest version of Node.js.

2. **Activate Node**: While Node.js is now downloaded, you need to activate it to use it. Run the following command:

   ```shell
   $ nvm use node
   ```

   This command sets the recently installed Node.js version as the active one.

Conclusion:
You've successfully set up NVM and installed Node.js on your macOS M1 Silicon-based machine. This streamlined process ensures you have the tools necessary for your development tasks in 2023. With NVM and Node.js at your disposal, you can easily manage Node.js versions and enjoy a smooth development experience on your M1 Mac.

By following these steps, you'll be well-prepared to tackle your software development projects on your Mac with confidence. Happy coding!
A Comparative Overview of Leading Web Servers: Nginx, Apache, LiteSpeed, and More
Tags: webdev
Published: 2023-10-01 08:35:06

## Introduction:
In the landscape of web hosting and server technologies, the choice of a web server plays a important role in ensuring the performance, security, and reliability of your online applications and websites. With a multitude of web servers available, each offering unique features and capabilities, it's essential to make an informed decision that aligns with your specific needs.

This article goes into the world of web servers, providing a short and comparative overview of some of the most prominent options available today. Whether you're a seasoned sysadmin, a web developer, or simply someone interested in the web hosting landscape, this guide will help you navigate the choices and find the ideal web server for your projects.

## Nginx:

- Creator: Igor Sysoev
- Language: C
- Popularity: High
- Notable Modules: ngx_http_ssl_module (SSL/TLS support), ngx_http_proxy_module (HTTP proxy), ngx_http_fastcgi_module (FastCGI support)
- Year Introduced: 2004
- Famous Companies: Airbnb, Dropbox, Netflix, WordPress.com


## Apache HTTP Server (Apache):

- Creator: Apache Software Foundation
- Language: C
- Popularity: High
- Notable Modules: mod_ssl (SSL/TLS support), mod_rewrite (URL rewriting), mod_proxy (reverse proxy)
- Year Introduced: 1995
- Famous Companies: Apple, IBM, Cisco

 
## HAProxy:

- Creator: Willy Tarreau
- Language: C
- Popularity: Medium
- Notable Modules: N/A (primarily a load balancer and proxy)
- Year Introduced: 2001
- Famous Companies: GitHub, Stack Overflow, Imgur

## Caddy:

- Creator: Matt Holt
- Language: Go
- Popularity: Medium
- Notable Modules: tls.dns.cloudflare (DNS challenge provider for Let's Encrypt), http.expires (HTTP caching), http.proxy (HTTP proxy)
- Year Introduced: 2015 (Caddy 1.0), 2020 (Caddy 2.0)
- Famous Companies: Segment, Atlassian, HashiCorp


## Traefik:

- Creator: Containous
- Language: Go
- Popularity: Medium
- Notable Modules: acme (Let's Encrypt certificate automation), traefik-forward-auth (authentication middleware), consul (Service discovery)
- Year Introduced: 2014
- Famous Companies: SendGrid, Nokia, Ubisoft


## Envoy:

- Creator: Lyft
- Language: C++
- Popularity: Medium
- Notable Modules: N/A (primarily a proxy)
- Year Introduced: 2016
- Famous Companies: Airbnb, Pinterest, eBay

 
## Tomcat:

- Creator: Apache Software Foundation
- Language: Java
- Popularity: Medium
- Notable Modules: N/A (primarily a servlet container)
- Year Introduced: 1999
- Famous Companies: eBay, Adobe, LinkedIn



In conclusion, the choice of a web server depends on your specific project requirements and goals, with options like Nginx, Apache, LiteSpeed, and others catering to various needs. Understanding their strengths, modules, and popularity can guide you in selecting the right one for your web hosting and application deployment.

Please provide information on the web server you are currently using and the reasons behind your choice?

Best
Hash
Weekly reading digest #7
Tags: php, backend, symfony, softwareengineering
Published: 2023-10-01 08:00:00

[Upgrade Symfony 3 to 4 without Flex](https://www.tobymackenzie.com/blog/2019/06/07/upgrade-symfony-3-to-4/)

[Upgraded Symfony 4.4 to 5.4](https://www.tobymackenzie.com/blog/2023/03/01/upgraded-symfony-4-4-to-5-4/)

[Symfony + Outbox Pattern + RabbitMQ: A Key for Reliable Microservices](https://medium.com/devwarlocks/symfony-outbox-pattern-rabbitmq-a-key-for-reliable-microservices-10bf267fdb0a)

[To Array is Human](https://blog.mnavarro.dev/to-array-is-human)

[Solving PHP Scaling Issues](https://www.eloquentarchitecture.com/solving-php-scaling-issues/)

[Can I PHP?](https://caniphp.com/)

[A ramble on Unit Tests](https://coderambling.com/2023/09/a-ramble-on-unit-tests/)

[An Overview of Indexes in MySQL 8.0: MySQL CREATE INDEX, Functional Indexes, and More](https://www.percona.com/blog/mysql-8-0-functional-indexes/)

[Faster database indexes (straight from the docs)](https://youtu.be/5aezDBaNfcc?si=SJKuKLvgtTHRD2N9) (video)

[Make your database queries 1000 times faster!](https://youtu.be/sJVzvBLDqqw) (video)