teleren/devto huggingface dataset:
Exploring PostgreSQL Extensions: Improving Performance and Functionality
Tags: apache, postgres, database, sql
Published: 2023-06-12 05:39:55

PostgreSQL is renowned for its extensibility, offering a large selection of extensions that improve its performance and usefulness. With the help of these extensions, you can increase the functionality of your PostgreSQL database to suit particular needs and overcome particular difficulties. This blog post will go into the realm of PostgreSQL extensions, covering its advantages, setup, and well-known extensions that can bolster your database. 

## Understanding PostgreSQL Extensions:
First we need to learn about PostgreSQL extensions and how they offer more functionality on top of the main database engine. Learn about the pros and cons of using extensions, including as modularity, flexibility, and the capacity to tailor PostgreSQL to your particular requirements.

## Installing and Managing Extensions:
Next examine the various PostgreSQL extension installation and management techniques. Learn how to speed up installation by using the CREATE EXTENSION command and package managers like pgxnclient and pgAdmin. Recognize the significance of maintaining extension updates and extension versioning.

## Popular PostgreSQL Extensions:
Some of the famous PostgreSQL extensions are:

- PostGIS: A geospatial extension that enables advanced geographic and geometric data processing.
- TimescaleDB: A time-series database extension that optimizes storage and retrieval of time-series data.
- pg_trgm: A text similarity extension that facilitates efficient text search and matching operations.
- Citus: A distributed database extension that enables horizontal scaling and parallel query execution.

## Performance-Boosting Extensions:
For boosting performance focus on extensions specifically designed to optimize database. Look into extensions like:

- pg_stat_statements: Provides detailed statistics about SQL statement execution, aiding in performance analysis and optimization.
- pg_repack: Enables online table reorganization and compaction, reducing table bloat and improving performance.
- pg_partman: A partitioning extension that simplifies data partitioning, enhancing query performance and data management.

## Best Practices for Managing Extensions:
Describe the recommended practices for managing PostgreSQL extensions, such as taking compatibility into account, keeping track of extension dependencies, and keeping an eye on extension performance. Talk about how to handle extensions during upgrades and migrations.

## Conclusion:
A strong mechanism for enhancing the performance and functionality of your database is provided by PostgreSQL extensions. You can explore and use these extensions to open up new functionality, improve performance, and tailor PostgreSQL to your particular requirements. 

PostgreSQL extensions offer a wide range of options, whether you need sophisticated geographic processing, time-series data management, text search, or distributed database capabilities. Take use of PostgreSQL's extensibility by integrating these potent extensions into your environment to advance your database.
What Is National Engineering Register?
Published: 2023-06-12 05:39:07

The [National Engineering Register (NER)](https://www.cdrreportwriter.com/what-is-national-engineer-register) is a professional register for engineers in Australia. It is managed by Engineers Australia, which is the professional body representing engineers in the country. The NER serves as a platform to recognize and showcase the qualifications, skills, and experience of engineers who meet the required standards of professionalism and competency.

Engineers who are listed on the National Engineering Register have undergone a rigorous assessment process to ensure they possess the necessary qualifications and experience in their respective engineering disciplines. This includes demonstrating their competence, adherence to ethical standards, and commitment to continuous professional development.

Being listed on the NER is often considered an important milestone for engineers in Australia. It not only provides recognition of their expertise but also enhances their professional credibility and career prospects. It serves as a valuable resource for employers, clients, and the public to identify and engage with qualified and competent engineers for various projects and services.
Serverless Computing for Genese Academy Nepal
Tags: aws, lambda, serverless, community
Published: 2023-06-12 04:53:06

AWS Community provides a remarkable platform for knowledge sharing across borders. With a vast network of professionals from various countries and backgrounds, the AWS Community enables global collaboration and learning. Through online forums, meetups, webinars, and conferences, AWS users can connect, exchange ideas, and share experiences with peers across borders.

As a collaborative effort from AWS User Group Nepal, lead by Barsha Bhandari and AWS User Group India, happily delivered expert talk to Genese Academy, Nepal on Server Less Computing with AWS Lambda. For sure, AWS Community acts as a bridge, connecting individuals and enabling the collective growth of the global cloud computing community.

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

Thanks a lot to Genese Academy staff for such a warm welcome and hosting us for this wonderful session.

There is yet another reason to cherish this talk forever. 

One of the most rewarding moments is guiding and transforming an aspiring cloud engineer into a tech speaker. Witnessing the growth and development of a mentee, especially during their debut tech talk, is truly incredible. The joy and satisfaction that come from seeing them step onto the stage and share their knowledge with confidence are unparalleled. It's a privilege to have had the opportunity to mentor my mentee, Omshree Bhutani, and witness her remarkable journey as she embraced the role of a tech speaker. And here is [Omshree's interesting journey](https://dev.to/omshree/celebrating-milestones-reflecting-on-my-debut-tech-talk-at-the-aws-community-21n7)

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


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


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

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

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


**Reference Links**
[Link 1](https://www.linkedin.com/feed/update/urn:li:activity:7072494295039041538/) 
[Link 2](https://www.linkedin.com/posts/bhuvanas_server-less-computing-with-lambda-activity-7073682863027601408-6Jyt)
Difference between innerText and textContent ?
Tags: vanillajavascript, javascript, codenewbie, beginners
Published: 2023-06-12 04:38:30

When working with the text content of HTML elements in JavaScript, programmers commonly utilize two properties: "textContent" and "innerText". While these properties may initially appear similar and interchangeable, they possess distinct differences. In this post, we will explore the major disparities between "textContent" and "innerText" and gain insights into their appropriate usage.

Firstly, let's consider the handling of hidden elements. The "textContent" property retrieves the text content of all elements regardless of their visibility. However, the "innerText" property takes CSS styling into account. It excludes hidden elements that employ properties like "display: none;" or "visibility: hidden;", ensuring that only text visible to the user is returned.

Secondly, there is a significant dissimilarity in how these properties handle CSS styles and layout information. "textContent" disregards CSS styling and layout properties, providing access to the raw text content, including text within hidden elements. On the other hand, "innerText" considers rendering and visibility based on CSS styles. It solely returns text content that is visually rendered to the user. This aspect makes "innerText" useful when dealing with text affected by CSS styles and layout.

Performance-wise, "textContent" generally outperforms "innerText". As "textContent" does not account for CSS styles or layout, it offers faster access to the text content of elements. Therefore, it is the preferred choice when only the raw text content is required, without considering visibility or styling.

Considering browser compatibility, "textContent" is widely supported across all modern browsers, including older versions. In contrast, innerText may not be supported by certain older browsers. Thus, if broader compatibility is needed, it is recommended to use "textContent".

In conclusion, the differences between "innerText" and "textContent" primarily lie in their handling of hidden elements, CSS styling, performance, and browser compatibility. "textContent" provides raw text content for all elements, irrespective of visibility or styling, while "innerText" considers CSS styles and returns only visibly rendered text. By understanding these distinctions, you can make informed decisions and ensure the appropriate handling of text content in JavaScript.
Switch To Astro
Tags: webdev, astro, beginners, tutorial
Published: 2023-06-12 04:11:57

## Why Astro ?
Astro is a modern static site generator that allows developers to build fast and flexible websites using JavaScript. It is designed to be easy to use and highly customizable, making it a popular choice for building static websites. In this blog post, we will introduce Astro and its key features.

## What is Astro?

Astro is a modern static site generator that allows developers to build fast and flexible websites using JavaScript. It is designed to be easy to use and highly customizable, making it a popular choice for building static websites. Astro uses a file-based approach to building websites, which means that each page is a separate file that can be edited and managed individually.

## Key Features of Astro

### 1. Performance

Astro is designed to be fast and efficient. It uses a modern build pipeline that optimizes images, minifies code, and caches assets to ensure that websites built with Astro load quickly.

### 2. Flexibility

Astro is highly flexible and customizable. It allows developers to use any JavaScript framework or library they prefer, including React, Vue, and Svelte. This makes it easy to build websites that are tailored to the needs of the developer and the user.

### 3. Modern Development Experience

Astro provides a modern development experience that is familiar to JavaScript developers. It uses a file-based approach to building websites, which means that each page is a separate file that can be edited and managed individually. This makes it easy to develop and maintain websites built with Astro.

### 4. Built-in Features

Astro comes with built-in features that make it easy to build websites. These features include support for CSS preprocessors, image optimization, and code splitting. This makes it easy to build websites that are optimized for performance and user experience.

## Getting Started with Astro

To get started with Astro, you will need to have a basic understanding of HTML, CSS, and JavaScript. You will also need to have Node.js and npm (Node Package Manager) installed on your computer.

Once you have these prerequisites, you can start by installing Astro using npm.

    npm install astro

After installing Astro, you can create a new Astro project using the astro create command.

    npx astro create my-astro-project

This will create a new Astro project in a directory called my-astro-project. You can then start the development server by running the following command.

    cd my-astro-projectnpm start

This will start the development server, and you can start building your Astro website.

## Conclusion

Astro is a modern static site generator that allows developers to build fast and flexible websites using JavaScript. It is designed to be easy to use and highly customizable, making it a popular choice for building static websites. Astro is fast, flexible, and provides a modern development experience that is familiar to JavaScript developers. If you are looking for a static site generator that is easy to use and highly customizable, Astro is a great choice.
How to Configure Product Catalog Search in Magento 2
Tags: magento, magento2, magento2tutorial
Published: 2023-06-12 03:59:39

Improving the product search experience in Magento 2 can offer significant advantages to your customers, enabling them to swiftly locate the items they desire by utilizing the product search form.

When combined with layered navigation, Magento 2's catalog search provides a smooth shopping experience and flexible navigation through the product catalog.

The search form represents the most commonly used means of catalog navigation, accessible by simply entering a word or phrase.

Moreover, customers who employ the search form are more inclined to complete a purchase, highlighting its critical role in the overall shopping journey.

This article explores the process of **_How to Configure Product Catalog Search in Magento 2_**, discussing the various types of catalog search available and offering detailed, step-by-step instructions for its setup.

For more information , please visit this :- **_[https://webguru.dev/how-to-configure-product-catalog-search-in-magento-2/](https://webguru.dev/how-to-configure-product-catalog-search-in-magento-2/)_**
lancet: a comprehensive, efficient, and reusable util function library of Go
Published: 2023-06-12 03:15:55

### 1. What is lancet? 

Lancet is a comprehensive, efficient, and reusable util function library of Go. It's been a year since lancet was released and now it supports more and more features. which makes go development more efficient. In this tutorial, you will have an overview of lancet.

For more details. please see [lancet repository](https://github.com/duke-git/lancet). 


### 2. What can lancet do?

In daily development, we will collect some common code logic into util functions. but different projects sometimes have the same utility function, which will cause bad code smell. That's what lancet try to solve. With lancet, you don't have to write lots of same util functions. Because there are more than 300 util functions in lancet.


### 3. How to use lancet?

Lancet organizes the code into package structure, you need to import the corresponding package name when use it. For example, if you use string-related functions, import the strutil package like below:

```go
import "github.com/duke-git/lancet/v2/strutil"
```

Here takes the string function Reverse (reverse order string) as an example, the strutil package needs to be imported.

```go
package main

import (

    "fmt"

    "github.com/duke-git/lancet/v2/strutil"

)

func main() {

    s := "hello"

    rs := strutil.Reverse(s)

    fmt.Println(rs) //olleh

}
```

###  4. How much feature lancet support?

Lancet has extensive support for Go development. Eg. algorithm, concurrency, convert, crypto, datetime, file, slice, math, net, string, system... You can explore it via [lancet repository](https://github.com/duke-git/lancet). 


### 5. How to contribute code?

Appreciate any code commits which make lancet powerful. Please follow the steps below to create your pull request.

- Fork the repository.
- Create your feature branch.
- Commit your changes.
- Push to the branch
- Create new pull request.
Terminal minigames
Tags: beginners, python
Published: 2023-06-12 03:00:04

Minigames(currently only connect four) that can be played in the terminals.

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

This program selects games according to users' input and makes the games run, after which the program will ask if the players want to play again or not.

[Link Github](https:/github.com/BasilMan69/minigames)

This is a beginner project that is of fairly low complexity. There might be existing unfixed bugs.
Simplifying VSCode
Tags: webdev, vscode, productivity
Published: 2023-06-12 02:30:05

## Introduction
As a long-time user of Visual Studio Code (VSCode), I've accumulated a vast array of extensions, settings, and files that have made my workspace cluttered and overwhelming. I found myself spending more time searching for files and navigating through menus than actually coding. It was time for a change.

In this blog post, I'll share my experience of cleaning up and simplifying my VSCode workspace. I'll discuss the steps I took to remove unused extensions, organize my files, customize settings, and use keyboard shortcuts and snippets to streamline my workflow. By the end of this post, you'll have a better understanding of how to optimize your workspace and improve your coding experience. So, let's dive in!

## Extensions I Removed 

- [codecrumbs-vs-code](https://marketplace.visualstudio.com/items?itemName=codecrumbs.codecrumbs-vs-code) - Never used it after the first few weeks of installing
- [Codetour](https://marketplace.visualstudio.com/items?itemName=vsls-contrib.codetour) - Same as above
- [Import Cost](https://marketplace.visualstudio.com/items?itemName=wix.vscode-import-cost) - I use Bundlephobia for this instead
- [Playwright Test for VSCode](https://marketplace.visualstudio.com/items?itemName=ms-playwright.playwright) - I use [Playwright's UI mode](https://playwright.dev/docs/test-ui-mode) for this functionality now
- [Polacode](https://marketplace.visualstudio.com/items?itemName=pnp.polacode) - I use [ray.so](https://ray.so/) instead now
- [ReacTree](https://marketplace.visualstudio.com/items?itemName=ReacTreeDev.reactree) - Seemed cool when I looked at it, but I've never had a use case for it
- [Remove Non ASCII Chars](https://marketplace.visualstudio.com/items?itemName=SamuelCharpentier.remove-non-ascii-chars) - The linting tools I use already handles this

## Status Bar Sections Removed
- Workspace Trust
- GitLens Commit Graph
- Problems
- Editor Selection
- Editor Indentation
- Editor Encoding
- Editor End of Line
- Editor Language Status
- Editor Language
- Prettier
- Feedback
- Notifications

## Sidebar Icons Removed
After years of use, the sidebar in VSCode can become cluttered with icons, making it difficult to navigate and find what you need. To simplify my workspace, I recently removed the below sidebar icons:

- Run and Debug
- Extensions
- GitLab Workflow
- GitLens
- TODOs
- Bookmarks
- Accounts

## Conclusion

In conclusion, by removing unused extensions, status bar sections, and sidebar icons, as well as organizing files, customizing settings, and using keyboard shortcuts and snippets, I was able to simplify my VSCode workspace and improve my coding experience. It's important to regularly review and optimize your workspace to ensure that it remains efficient and clutter-free.
The basic commands in Angular
Tags: webdev, angular
Published: 2023-06-12 01:56:15

**Basic commands to initialize your project in Angular:**
- To create a new project, open your terminal and execute:
```
ng new project-name
```
- To execute your application and create the server project, execute the following commands:
```
ng serve
```
- Create a component:

```
ng g c /folder-name/component-name
```

- Create a module:
```
ng g m /folder-name/component-name
```

- Create an interface:

```
ng g interface /folder-name/interface-name
```

- Create a service:

```
ng g s /folder-service/service-name
```

- Install CLI:

```
npm i -g @angular/cli
```

---
**If you want to deploy your Angular project locally or on GitPages, for example, execute:**

```
ng build
```
This command allows you to generate a "bundle" of the entire project, in the format of HTML + Javascript + CSS files, to be published on any static server.

---
**Observations:**

- Services are not automatically imported into app.module.ts (unlike components).
- :host {} in the SCSS file modifies only that specific file.
Comandos básicos em Angular
Tags: webdev, angular
Published: 2023-06-12 01:35:39

**Comandos básicos para iniciar seu projeto:**
- Para criar um novo projeto, abra o terminal e execute:
```
ng new nome-projeto
```

- Executar sua aplicação e criar o servidor do projeto:
```
ng serve
```

- Criar um componente:

```
ng g c /nome-pasta/nome-componente
```

- Criar um módulo:

```
ng g m /nome-pasta/nome-modulo
```

- Criar uma interface:

```
ng g interface /nome-pasta/nome-interface
```

- Criar um service:

```
ng g s pasta-serviço/nome-serviço
```

- Instalar a CLI:

```
npm i -g @angular/cli
```

---

**Caso você deseje implantar seu projeto Angular em algum local, como o GitPages, por exemplo. Execute:**

```
ng build
```
Este comando permite gerar um "empacotamento" de todo o projeto, no formato de arquivos HTML + Javascript + CSS para ser publicado em qualquer servidor estático.

---
**Observações:**
- Services não são importados automaticamente para o app.module.ts (diferente dos componentes).
- :host {} = no arquivo SCSS altera exclusivamente aquele arquivo.