teleren/devto huggingface dataset:
PostgreSQL and OpenCypher a short overview
Tags: cypher, intern, swe, apacheage
Published: 2023-07-22 23:34:38

## Introduction

The convergence of PostgreSQL and OpenCypher represents a significant step towards bridging the gap between traditional relational databases and the world of graph databases. This integration enables developers to seamlessly query both structured and graph data, unlocking new possibilities for data modeling, analysis, and application development.

## How it works

PostgreSQL, a robust relational database management system, and OpenCypher, a versatile query language for graph databases, converge to create a powerful combination for data management. This integration allows developers to leverage the strengths of both technologies, facilitating seamless querying of structured and interconnected data. 

## My studies

I am currently working on Opencypher's functions, creating coding implementations for the Apache AGE repository. Specifically, I have developed two functions: "toIntegerList," which converts a list of elements into the Integer type, and "toFloatList," which converts a list containing floating-point numbers.

Check the repository: [Apache AGE](github.com/apache/age)
CSS Selectors
Published: 2023-07-22 23:17:20

Selectors target HTML elements and apply styles based on their attributes, types, and relationships.

<u>Universal selector</u>:
```
*{
}
```

Element:
```
element{
}
```

<u>Attribute</u>:
```
#id {
}
```
```
.class {
}
```
```
element[attribute='value'] {
}
```

<u>Pseudo-class</u>:
Select and style elements based on their state
Pseudo-class attached to a selector
```
selector:pseudo-class {
}
```
Pseudo-classes include:
:hover
:active	
:focus
:visited
:first-child
:last-child
:not
:enabled
:disabled

[CSS Syntax and Selectors cheat sheet] (https://www.codecademy.com/learn/learn-css-introduction/modules/syntax-and-selectors/cheatsheet)
Speeding up Data Science ChatGPT API requests using async and task rerun
Tags: python, chatgpt, datascience
Published: 2023-07-22 22:41:54


![async vs multiprocessing](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i6nwze251m5rsnw99rj7.png)




How often do you see this error message when working with LLMs?


> _openai.error.ratelimiterror rate limit reached for default-gpt-3.5-turbo in organization_


If you are working with LLM models you might already experienced a problem with processing multiple messages at a reasonable time. Large LLMs might take up to 20 seconds to generate an AI response. Obviously this means that processing messages sequentially and waiting 20s after every request before processing next one is not a good option.

Thus many data scientists switched to multiprocessing for speeding up their work. Multiprocessing limits your request to number of threads of your local machine. Yes, this means that let's say 4 local threads are waiting for their responses from server API, and server is processing this four responses. But does this mean that you are using all compute power of a server? In reality your 4 API requests wouldn't account ever for 0.1% sever load.

More advanced developer will say that the correct solution would be to use async requests. In this case server is processing all received requests in parallel. Simply speaking if you don't have any server side limits than you will be able to send all your requests in one go and get result in 20 seconds (server will process all your requests in parallel).  

However API's tend to return errors, thus it is quite expected that most of your requests will fail because of errors like `RateLimit` or generic `APIError`. This means that correct async implementation should use reasonable batch size which won't trigger exceptions like 'RateLimit' from the server and on top of that your implementation should restart all failed async tasks.

I have created small code snippet that will help you to start using such async implementation of API requests to ChatGPT in your projects. Please check my github repo code for examples.
[Github async_chatgpt](https://github.com/Sirorezka/async_chatgpt)

For example here is how easily to run the code directly from the jupyter notebook:
![Running the code from Jupyter](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7yknc0z5zwbyni2cc7tp.png)

To make your code more robust my recommendations would be to break your chats in reasonable batches (for example send 50 chats at a time) and store API responses of each batch on the disk before proceeding to sending next batch in async mode. 

While processing a batch you will see logs with information on how many tasks were completed, how many will be restarted and what were the exceptions during processing.
![async chatGPT batch logs](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/w9bj224fx5ln44fnarbg.png)

Hope this will help you to automate some of your analysis. 

If you like this post don't hesitate to:
☑ add a reaction ♡ 🌺 🍒 ✨
☑ post a comment 📣 🔊
☑ give a star to the github repo ★ ☆ ★
A Journey Through 6 Months of Backend Engineering: Building Robust Foundations
Tags: webdev, backend, tutorial, javascript
Published: 2023-07-22 22:32:47

Discover the ultimate guide to backend engineering with our six-month roadmap. Learn how to build robust and scalable infrastructures, from planning and architecture design to testing and maintenance. Unlock the secrets of successful backend development and equip yourself with the skills to thrive in the dynamic world of software engineering. Start your journey now!

## Month 1: Introduction to Backend Technologies

**Week 1: Introduction to Backend Concepts**

Understand client-server architecture
Learn about HTTP, APIs, and RESTful principles

**Week 2: Setting Up Development Environment**

Install necessary software (e.g., text editor, Git, Node.js, etc.)
Familiarize yourself with the command-line interface (CLI)

**Week 3: Basics of Database Management**

Learn about relational and NoSQL databases
Practice basic CRUD operations (Create, Read, Update, Delete)

**Week 4: Web Development Framework**

Choose a backend framework (e.g., Express.js for Node.js)
Build a simple API using the chosen framework

read full schedule at 
{% embed https://frontendchef.com/6-month-backend-engineering-schedule/ %}
My second day writing code
Published: 2023-07-22 22:05:44

I made a start on my CSS courses on freecodecamp. I am about 80% through!

Today I focused on learning CSS. CSS stands for Cascading Style Sheets and is used to style an HTML document. I learnt how to style different elements by adding different properties such as :
- background colours, using the `background` property
- align text, using the `text-align` property, for example 
- select different widths on the page by using the `width` property and selecting the respective number, for example, `max-width: 300px` if you want the max width to be 300 pixels.
- border colour by using the `border-colour` property

CSS is so much more creative, it allowed me to see the different tweaks on the website to come to life!

After that, I explored different class selectors in order to change fonts, font styles and played around with the hover selector on links!
A library of infinite possibilities : The Library of Babel
Tags: algorithms, beginners
Published: 2023-07-22 21:24:52

## **What is The Library of Babel?**

The Library of Babel website is an online project inspired by Jorge Luis Borges' fictional concept. It was created by Jonathan Basile and launched in 2015. The website attempts to simulate the experience of the Library of Babel as described in Borges' story. You can access the website at libraryofbabel.info.

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


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

This website contains lots of imaginary "books" made up of random letters and symbols. Each "book" has a unique address like a house with a room number. **_This website contains every possible combination of 1,312,000 characters, including lower case letters, space, comma, and period. Thus, it would contain every book that ever has been written, and every book that ever could be - including every play, every song, every scientific paper, every legal decision, every constitution, every piece of scripture, and so on._**



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

At present it contains all possible pages of 3200 characters, about 10 to the power 5000 books. For comparison, it **is estimated that there may be 10 to the power 80 atoms in the known universe.**_

You can use a search function on the website to look for specific texts or sentences. If you search for something, the website will try to find a "book" that matches your search. 

## **What's so special about it?**

Think of this website as a virtual library that represents all possible knowledge. It's like looking for a specific piece of information in a huge pile of random texts. The website is a fun way to explore the concept of a library with infinite possibilities. **_I mean it would be crazy to think that one of the combination could contain the cure to cancer, or how the world turns out in the future and many more.
_**
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7lffhgiwpg0w4hwsnnfg.png)

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


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


Just one of the many wonderful things on the internet!
How to use Playwright with external/existing Chrome
Tags: playwright, javascript, chrome
Published: 2023-07-22 19:50:51

Mostly example using Playwright in JavaScript is using Chromium that bundled with Playwright. How about if we want to use existing or external Chrome?

No worries, it means you have to set the Playwright to connect to a Chromium instance manually using Chrome DevTools Protocol (CDP) and that means you should run the Chrome with `--remote-debugging-port=9222`.

For the external Chrome I recommend using Chrome for Testing that is good for this situation. Just to to https://developer.chrome.com/blog/chrome-for-testing to read more.

I have created the repository and quick script sample about this. Just go to https://github.com/sonyarianto/playwright-using-external-chrome

Wanna quick try? Here is the script `index.js`.

```js
import { chromium } from 'playwright';

(async () => {
    try {
        const browser = await chromium.connectOverCDP('http://localhost:9222');

        console.log(browser.isConnected() && 'Connected to Chrome.');
        console.log(`Contexts in CDP session: ${browser.contexts().length}.`);
        
        const context = browser.contexts()[0];

        const page = await context.newPage();
        await page.goto('https://example.com');
        await page.screenshot({ path: 'example.png' });

        await page.close();
        await context.close();
        await browser.close();
    } catch (error) {
        console.log('Cannot connect to Chrome.');
    }
})();
```
Then run it like this. Make sure you already run the Chrome first (with argument `--remote-debugging-port=9222`).

```bash
node ./index.js
```

Happy using Playwright.
Rust Me Baby All Night Long
Tags: rust, discuss, coding, github
Published: 2023-07-22 19:37:23

Recently, I've been consumed by the task of job hunting, yet I have not lost sight of my passion for writing. This week, I am determined to contribute something unique and creative despite the demanding nature of my current pursuit. My goal is to diversify my creative exploration and invite fresh insights into my process.

As a part of this endeavor, I am eager to see the work you've accomplished. If you have any projects written in Rust, I would love to see them. If you have any repositories on GitHub that showcase your Rust coding capabilities, do share those as well. Anything that you've created and is currently live, I would love to see. Honestly, any work you've done and are proud of, I invite you to share. The aim is to seek inspiration from your work and to foster an environment of mutual creative growth.

If you enjoy my technology-focused articles and insights and wish to support my work, feel free to visit my Ko-fi page at https://ko-fi.com/philipjohnbasile. Every coffee you buy me helps keep the tech wisdom flowing and allows me to continue sharing valuable content with our community. Your support is greatly appreciated!
Octos - HTML live wallpaper engine
Tags: javascript, webdev, programming, html
Published: 2023-07-22 19:36:00

Octos is an HTML live wallpaper engine for your Windows desktop. Explore a library of community-made wallpapers or write your own with HTML/CSS/JS when you download the Octos app.

Octos now lets you build live, interactive, and beautiful wallpapers in your favorite web-based language with full mouse and keyboard support. Use the Octos API to power up your wallpaper with features like media playback controls and local file support. The app also has a user-friendly interface for managing your installed mods as well as a full-fledged documentation with resources and guides for using the app and developing your own mods.

Octos is currently in an early stage, so feedback is greatly appreciated! Check it out/download on [GitHub](https://github.com/underpig1/octos). Thanks for your support!
Getting Started With PostgreSQL: Basic Querries (Part 2)
Tags: postgres, postgressql
Published: 2023-07-22 19:28:25

## Introduction

In this blog post, we'll continue our investigation of various PostgreSQL queries, starting with the UPDATE query and moving on to the DELETE, WHERE, ORDER BY, and LIMIT and OFFSET clauses at the end. Let's get started with some real-world examples to help you understand.

## UPDATE Query

A table's existing records can be easily changed using to the UPDATE query.
The age of the user "john_doe" is now 35.
```
UPDATE users
SET age = 35
WHERE username = 'john_doe';
```

## DELETE Query

You can efficiently delete records from a table using the DELETE query if specific requirements are satisfied.

Let's delete the user with the username "john_doe" from the "users" table

```
DELETE FROM users
WHERE username = 'john_doe';

```

## WHERE Clause

In SELECT, UPDATE, and DELETE queries, the WHERE clause applies a filter to the data depending on predefined criteria.

Let's retrieve users who are above the age of 25

```
SELECT * FROM users
WHERE age > 25;
```

## ORDER BY Clause

You can use the ORDER BY clause to arrange the result set in either ascending or descending order according to one or more columns.

Let's retrieve users from the "users" table sorted by age in descending order

```
SELECT * FROM users
ORDER BY age DESC;
```

## LIMIT and OFFSET Clauses

While the OFFSET clause skips a predetermined number of rows, the LIMIT clause limits the amount of rows returned in the result set.

Let's get the first three users from the "users" table.

```
SELECT * FROM users
LIMIT 3;
```
Use the OFFSET clause to return the following three users while skipping the first three rows.

```
SELECT * FROM users
LIMIT 3 OFFSET 3;

```

## Conclusion

Now that you've learnt about the fundamental PostgreSQL queries UPDATE to LIMIT and OFFSET. You may manage your PostgreSQL database effectively by manipulating data, filtering outcomes, and using these queries. Your ability to handle challenging data tasks will increase as you explore deeper into the world of databases and find even more powerful queries and features.Good Luck!
Need help with Vue SSR and unhead
Tags: vue
Published: 2023-07-22 19:28:20

I have been trying to implement SSR in Vue 3 with very good results. However, I have hit a complete roadblock with how to add SEO Tags. I have been using unhead for this purpose and it seems to load the title and tags fine once the page is loaded. However, the server does not seem to loading the tags. I am not sure where I am going wrong. So, please do help.

// main.ts
export const createApp = () => {
    const app = createSSRApp(App)
    const pinia = createPinia()
    const head = createHead()
  
    app.use(router)
    app.use(pinia)
    app.use(head as any)
  
    return {
      app,
      pinia,
      router,
      head
    }
}

// entry-server.ts
export async function render(url:string, manifest:any):Promise<any> {
  const { app, router, head } = createApp();

  await router.push(url);
  await router.isReady();
  await head.resolveTags()

  const payload = await renderSSRHead(head as any)

  const ctx:any = {};
  const html = await renderToString(app, ctx);

  const preloadLinks = renderPreloadLinks(ctx.modules, manifest);
  return [html, preloadLinks, payload];
}
The visual Studio component cache is out of date, please restart Visual Studio.
Tags: visualstudio, sqlserver
Published: 2023-08-30 18:53:15

---
title: The visual Studio component cache is out of date, please restart Visual Studio.
published: true
date: 2023-07-22 18:30:00 UTC
tags: VisualStudio,SQLServer,VisualStudio,SQLServer
canonical_url: http://www.codetolive.in//visual%20studio/sql%20server/the-visual-studio-component-cache-is-out-of-date-please-restart-Visual-Studio/
---

I’ve faced an issue while opening Visual Studio 2022/2019, and SSMS (MS SQL Server Management Studio) states that,

> The Visual Studio component cache is out of date. Please restart Visual Studio.

  ![](http://www.codetolive.in/assets/images/posts/codetolive-ssms-cache-error-dialog.png)  

_Fig 1. SSMS error_

> You can run the Visual Studio installer again to repair the IDE to solve this problem, or follow the below steps to manually delete the temp files to clear the corrupted files.

The issue usually occurs when you install the latest OS updates or any tool-specific updates that cause the problem.

**_Solution:_**

```
Steps:
1. Press Windows + R. The Run dialogue will open.
2. Enter the following command: %temp%.
3. Delete all the files.

```
Get notification for Affiliate Sale
Tags: automation, pipedream, tutorial
Published: 2023-07-22 18:27:59

Get your self motivated with your sale from Admitad (affiliate programs) with automatic notification for sale.

**Summary**: You already have approved Admitad account, and want mobile notification for sale.

Follow these sample steps, we are going to use [Pipedream](http://pipedream.com?via=wasim)  as automation (Free).

 
Step 1: Create New **Pipedream Account ** [Pipedream](http://pipedream.com?via=wasim) and Create new Workflow.

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

Step 2: Create new Webhook Request as shown in below image.

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


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


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/11n9ykrd5fr6n6ppdkt6.jpg)

Step 3 : Add Postback URL in Admitad Dashboard

If you are marketer , dont worry about the technical terms :) just follow the steps as shown in the Image.


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/2ijchrm3nvko5lnxky4k.jpg)


![Postback URL Admitad option](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/phz25xg04d7ilty7sst0.jpg)


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

Select Option as above image , and past webhook url in link field.

Add Postback Parameters.

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

Test your postback URL


![New Post in Pipedream](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lthk6d6674ikif5fkh8v.jpg)


![Response in Pipedream](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/66pngw96bacta3vjuq59.jpg)


Check response in Pipedream Workspace


![Post Back Request in Pipedream](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/9oi261lggk45w0x8m515.jpg)


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

Step 4: Add new Step in Pipedream and Select "Send Email"


![Send Email with Pipedream](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fjldknrwvyreum62lnsa.jpg)

Add subject and body for email notification


![Compose Email in Pipedream](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qfdstcyf2n68xsn59rqg.jpg)

`Offer Name - {{steps.trigger.event.body.program}}
Payment -  {{steps.trigger.event.body.payment}} `

Click on Test and You will receive test email notification

![Pipedream Email Notification](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ync62ssl3rvtsy5frk8a.jpg)

You can now Deploy the Pipedream work flow and whenever there is new sale, you will get email notification.
Book No 6: Architecting Modern Applications using Monolithic Architecture in Asp.Net Core Web API By (Sardar Mudassar Ali Khan)
Tags: webdev, softwareengineering, software, architecture
Published: 2023-07-22 18:19:46

Architecting the modern applications in asp.net core web API in this book we adopted a practical approach for the development of software products. This book is divided into four parts every part has its dimension. In this book, we will explain the fully featured projects and how we can architect the application using the following architectures.

1. Monolithic Architecture
2. Clean Architecture
3. Onion Architecture
4. Three Tier Architecture
5. Application Deployment on Azure
### PART 1: Monolithic Architecture

- Introduction
- Complete Understanding of Monolithic Architecture
- Practical Approach for Architecting the Application with Asp.net Core
- Conclusion
- Complete Project GitHub URL
### PART 2: Three-Tier Architecture.

- Introduction
- Complete Understanding of Three Tier Architecture
- Practical Approach for Architecting the Application with Asp.net Core
- Conclusion
- Complete the Project GitHub URL
### PART 3: Onion Architecture.

- Introduction
- Complete Understanding of Onion Architecture
- Practical Approach for Architecting the Application with Asp.net Core
- Conclusion
- Complete Project GitHub URL
### PART 4: Clean Architecture.

- Introduction
- Complete Understanding of Clean Architecture
- Practical Approach for Architecting the Application with Asp.net Core
- Conclusion
- Complete the Project GitHub URL
### PART 5: Application Deployment on Server.

- Introduction
- Deployment Procedure
- Server Configuration
- Deployment Steps
- Conclusion
[Download My Complete Book About Architecting Modern Applications using Monolithic Architecture in Asp.Net Core Web API](https://a.co/d/79Yzf2v)