teleren/devto huggingface dataset:
Analysis of cypher_match at AGE16 failing testcases
Tags: apacheage, postgres, database, bitnine
Published: 2023-07-13 15:47:42

### Hello, what is going on?

We are currently having the following state in the test suite of Apache AGE (our regression test)

#### 8 are failing out of 24

- not ok 8     - cypher_match                             1696 ms
- not ok 10    - cypher_set                                416 ms
- not ok 11    - cypher_remove                             290 ms
- not ok 12    - cypher_delete                             525 ms
- not ok 14    - cypher_vle                               1872 ms
- not ok 16    - cypher_call                               101 ms
- not ok 17    - cypher_merge                              372 ms
- not ok 20    - index                                     232 ms

### Let's discuss `cypher_match` is it all failing? Nope.

#### What are the cases causes the issues then?

- Undefined error that we are getting empty results while it should have returned results 
```sql

SELECT * FROM cypher('cypher_match', $$
	MATCH ()<-[]-(n:v2)-[]->()
	MATCH p=(n)-[]->()
	RETURN p
$$) AS (i agtype);
-- Error here is having an empty results while expecting a result set
``` 

- MATCH & OPTIONAL MATCH together error 
```sql
SELECT * FROM cypher('cypher_match', $$
    MATCH (u:opt_match_v)
    OPTIONAL MATCH (u)-[m]-(l)
    RETURN u.name as u, type(m), l.name as l
    ORDER BY u, m, l
$$) AS (u agtype, m agtype, l agtype);
ERROR:  graph_oid and label_id must not be null
```

- MATCH & OPTIONAL MATCH together error 
```sql
SELECT * FROM cypher('cypher_match', $$
    MATCH (n:opt_match_v), (m:opt_match_v)
    WHERE id(n) <> id(m)
    OPTIONAL MATCH (n)-[r]->(p), (m)-[s]->(q)
    RETURN n.name AS n, type(r) AS r, p.name AS p,
           m.name AS m, type(s) AS s, q.name AS q
    ORDER BY n, p, m, q
 $$) AS (n agtype, r agtype, p agtype, m agtype, s agtype, q agtype);
ERROR:  graph_oid and label_id must not be null
```

- MATCH & OPTIONAL MATCH together error 
```sql
SELECT * FROM cypher('test_retrieve_var', $$
    MATCH (a:A) WITH a
    OPTIONAL MATCH (a)-[:incs]->(c)
    WHERE EXISTS((c)<-[:incs]-())
    RETURN a, c
$$) AS (a agtype, c agtype);
ERROR:  graph_oid and label_id must not be null
```

- Cleanup queries of the script which are dependencies of the above failed quires so that we need to fixed the above which will led to fixing them 

#### So in conclusion we are having two types of errors (main) and one dependent:
- ERROR:  graph_oid and label_id must not be null 
That happens when having OPTIONAL MATCH with MATCH
- Undefined error that we are expecting a result set and getting empty result set
- Cleanup error which should be solved if we have resolved the above ones

#### Trials and debugging
Recalling that the problem happens in `transform_cypher_optional_match_clause`
so we trying to resolve the rtindex dependency problems 
What has been already gone through and what I am trying now I will mention that in the next blog.

### References:
- https://github.com/postgres/postgres/tree/REL_16_STABLE
- https://github.com/panosfol/age/tree/PG16
- https://github.com/apache/age/
- https://github.com/muhammadshoaib/age/
Pengertian Chord Musik
Published: 2023-07-13 15:46:21

## Pengertian Chord Lagu

Cara membaca chord pada notasi musik dapat bervariasi tergantung pada jenis notasi yang digunakan. Berikut adalah beberapa cara umum untuk membaca chord pada notasi musik:
1.	Notasi Chord Symbols: Pada notasi chord symbols, chord ditulis menggunakan simbol-simbol tertentu. Simbol yang umum digunakan adalah huruf-huruf yang mewakili nama-nama chord, seperti C untuk C major atau A# untuk A sharp. Selain itu, simbol tambahan seperti + (augmented), - (minor), atau 7 (dominant seventh) dapat digunakan untuk menunjukkan variasi chord. Contohnya, Cm7 berarti C minor seventh chord. Untuk membaca chord pada notasi ini, Anda perlu mengenali simbol-simbol chord dan mengetahui bagaimana membentuk chord tersebut pada instrumen yang Anda mainkan
1.	Notasi Not Balok: Pada notasi not balok, chord ditulis menggunakan tanda-tanda khusus di atas atau di bawah not. Tanda tersebut dapat berupa huruf-huruf yang mewakili nama-nama chord atau simbol-simbol khusus. Misalnya, huruf C di atas not menunjukkan bahwa chord yang dimainkan adalah C major. Selain itu, simbol seperti +, - atau 7 juga dapat digunakan untuk menunjukkan variasi chord. Untuk membaca chord pada notasi ini, Anda perlu mengenali tanda-tanda khusus yang digunakan dan mengetahui bagaimana membentuk chord tersebut pada instrumen yang Anda mainkan
2.	Notasi Trinada (Triad): Pada notasi trinada, chord ditulis menggunakan tiga huruf yang mewakili nama-nama chord. Huruf pertama menunjukkan root note, huruf kedua menunjukkan tipe chord (misalnya, M untuk major atau m untuk minor), dan huruf ketiga menunjukkan variasi chord (misalnya, 7 untuk dominant seventh). Contohnya, Cm7 berarti C minor seventh chord. Untuk membaca chord pada notasi ini, Anda perlu mengenali huruf-huruf yang mewakili nama-nama chord dan mengetahui bagaimana membentuk chord tersebut pada instrumen yang Anda mainkan

[Chord Malam ini turun hujan](https://kabinetrakyat.com/chord-malam-ini-hujan-turun-lagi/)
3.	Dalam membaca chord pada notasi musik, penting untuk memahami simbol-simbol dan tanda-tanda yang digunakan serta mengetahui bagaimana membentuk chord tersebut pada instrumen yang Anda mainkan. Praktik dan pengalaman juga akan membantu meningkatkan kemampuan membaca chord dengan lebih lancar dan cepat.

[](https://kabinetrakyat.com/chord-malam-ini-hujan-turun-lagi/)
)
Stack: deep dive
Published: 2023-07-13 15:16:19

### Stack

- A stack is an ordered list in which insertion and deletion are done at one end, called top. 
- The last element inserted is the first one to be deleted. 
- Hence, it is called the **Last in First out(LIFO)** or **First in Last out (FILO) list**.

### Stack ADT
**Main stack operations**
- Push (int data): Inserts data onto stack.
- int Pop(): Removes and returns the last inserted element from the stack.

**Auxiliary stack operations**
- int Top(): Returns the last inserted element without removing it.
- int Size(): Returns the number of elements stored in the stack.
- int IsEmptyStack(): Indicates whether any elements are stored in the stack or not.
- int IsFullStack(): Indicates whether the stack is full or not.

### Implementing Stack using Array


```
#include<bits/stdc++.h>
using namespace std;

class Stack {
    int size = 5;
    int *items = new int[size];
    int top = 0;

    public:
    void push(int item) {
        if(top == size) cout << "StackOverFlowError" << endl;
        else items[top++] = item;
    }

    int pop() {
        if(top == 0) {
            cout << "StackUnderFlowError" << endl;
            return 0;
            cout <<"HI" << endl;
        }
            cout <<"2HI" << endl;
        return items[--top];
    }

    int length() {
        return top;
    }
   
    void print() {
        for(int i = 0; i < top; i++)
            cout << *(items + i) << " ";
    }

    int top() {
        return items[top-1];
    }

    bool isEmpty() {
        return top == 0;
    }
   
    bool isFull() {
        return top == size;
    }

};


int main(int argc, char const *argv[]) {
    Stack s;
    s.push(10);
    s.push(20);
    s.push(30);

    cout << "Size : " << s.length() << endl;
    return 0;
}
```

### Performance
Let n be the number of elements in the stack. The complexities of stack operations with this representation can be given as:

Space Complexity (for n push operations): O(n)
Time Complexity of Push() :  O(1)
Time Complexity of Pop() : O(1)
Time Complexity of Size() : O(1)
Time Complexity of IsEmpty(): O(1)
Time Complexity of IsFull : O(1)

### Limitations
The maximum size of the stack must first be defined and it cannot be changed. Trying to push a new element into a full stack causes an implementation-specific exception.

### Stacks: Problems

1. Discuss how stacks can be used for checking balancing of symbols.
2. Discuss infix to postfix conversion algorithm using stack.
3. Discuss postfix evaluation using stacks?
4. Can we evaluate the infix expression with stacks in one pass?
5. How to design a stack such that GetMinimum() should be O(1)?
6. For Problem-5 is it possible to improve the space complexity?
connect to wsl mysql from host windows with MySQL Workbench
Tags: mysql, wsl
Published: 2023-07-13 15:30:00

> source: https://stacktuts.com/how-to-connect-to-wsl-mysql-from-host-windows

To solve the problem of fail to connect to localhost, the last method is the only one work for me.
Set the `bind-address = 0.0.0.0` in mysql configuration. I did create an extra inbound rule in the host machine, but not sure if that is optional.  

The next problem is 
> host 'ComputerID' is not allow to connect to this MySQL server
. 
I grant the privileges for the username I created for the project using 
`grant all privileges on *.* to 'user_name'@'host_ip_address' Identified by 'password' with grant option;`

And I can connect to the SQL now! :)
A reminder to use single quotes when writing commit messages
Tags: learning, git, bash
Published: 2023-07-13 15:29:47

*Originally published at https://rivea0.github.io/blog.*

Using backticks in the shell results in _command expansion_, for example:

```
echo `which cp`
```

is the same as 

```
echo $(which cp)
```

It finds the directory the `cp` command is in (executes the `which` command), and then prints it to the screen.

Normally, when using double quotes, many types of expansions do not work (like word-splitting and brace expansions), but with command expansion, this is not the case.

Commands inside backticks are executed if they are inside double quotes.

When writing a message to `git commit`, rendering the name of a function in monospace, for example, is easy to do using backticks.

So, my hypothesis is that when I do something like

```
git commit -m "Add `doThis` function"
```

If `doThis` is a command, it will be executed.

So, if we write something like

```
git commit -m "Add `which cp` thing"
```

It will replace it with the directory that `cp` is in, so that our commit message will look like:

```
Add /bin/cp thing
```

In fact, after trying it, it turns out to be true, and this [Stack Overflow answer](https://stackoverflow.com/a/71155997) has a nice short explanation.

Single quotes, on the other hand, suppress all expansions, so if written like this:

```
git commit -m 'Add `which cp` thing'
```

It won't execute `which cp`, but write it as it is: 

```
Add `which cp` thing
```

So, I think it is safer to use single quotes, whether you want to use a code block a la markdown styling or not.

---

*This enlightenment is thanks to the "Seeing the World as the Shell Sees It" chapter from William E. Shotts' book [The Linux Command Line: A Complete Introduction](https://archive.org/details/tlcl-19.01/page/76/mode/2up).*
Streamlining the Software Development Process with CodaEA
Published: 2023-07-13 15:16:56

In our [latest blog post](https://codaea.blogspot.com/2023/07/streamlining-software-development.html), we take a look at how CodaEA makes it easier to resolve errors in the software development process.  Are you integrating the best way to resolve errors and save you time?  Find out how CodaEA can give you a single click to find already-known solutions to the errors you get, or let you post and leverage solutions you already found but can't remember the next time you come across it.
JavaScript 🐲 challenges_5 ⚔️
Tags: challenge, javascript, webdev, beginners
Published: 2023-07-13 14:59:14

## Exes and Ohs

- Check to see if a string has the same amount of 'x's and 'o's.
- The method must return a Boolean and be case insensitive.
- The string can contain any char.

#### Example:

```
XO("ooxx")      => true
XO("xooxx")     => false
XO("ooxXm")     => true
XO("zpzpzpp")   => true // when no 'x' and 'o' is present should return true
XO("zzoo")      => false
```

[Task URL](https://www.codewars.com/kata/55908aad6620c066bc00002a)

### My solution:

```
function XO(str) {

    let stringLower = str.toLowerCase();
    let charArr = stringLower.split('');
    let xoList = ['o', 'x'];
    let x = 0;
    let o = 0;

    let compare = charArr.filter((char) => {
        xoList.includes(char)
        if (char === 'x') return x += 1
        if (char === 'o') return o += 1
    });

    if (x !== o && compare !== []) {
        return false
    };
    if (compare !== [] || compare === []) {
        return true
    };

};
```

### Code Snapshot:


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


###### 10 JavaScript Games to learn-Totally Cool & Fun 🚀✨🔥

🎥 {% youtube 9EZ0TpuHYvI%}


### Connect with Me 😊

#### 🔗 Links

[![linkedin](https://img.shields.io/badge/linkedin-0A66C2?style=for-the-badge&logo=linkedin&logoColor=white)](https://www.linkedin.com/in/mahmoud-el-kariouny-822719149/)

[![twitter](https://img.shields.io/badge/twitter-1DA1F2?style=for-the-badge&logo=twitter&logoColor=white)](https://twitter.com/Mahmoud42275)
We accelerated the answering of support requests by 40% 😎
Tags: cloudcomputing, virtualmachine, news, tutorial
Published: 2023-07-13 14:55:58

Hey, Guys! Now we actively working on speeding up user request processing and want to share the first results. We declare that the initial response time for requests a 40% lower now!

We expanded the library of common user requests, prolonged support specialists studying and set maintenance KPIs. As you can see, these steps have already shown their effectiveness.

The goal of this project is to find a solution for any request within 30 minutes. Achieving this benchmark is the key to generating irresistible customer satisfaction.


[We told a little more about this project on our website](https://serverspace.io/about/news/serverspace-accelerated-the-answering-of-support-requests-by-40/). Check!
AWS Amazon Captcha Solver : Captcha Solver
Tags: aws, captcha, javascript, webdev
Published: 2023-07-13 14:51:52

# How to Solve AWS WAF Captcha
![](https://assets.capsolver.com/prod/images/post/2023-07-12/b0e1e5aa-2fdc-4e6a-913e-2eddbbb53d13.png)

Before we start solving AWS WAF Captcha, there are some requirements and points that we need to be aware of:

### Requirements:

- CapSolver Key
- Proxy (Optional)

Proxy is optional, but always recommended that you use your own proxy for AWS WAF Captcha as IP is very important.

### Points to be aware of:

- The website URL needs to be correct
  For find the good website URL, you just need to check that the website url have the status code 405 and return a html with iv, key, context values. Check the image:
![](https://assets.capsolver.com/prod/images/post/2023-07-12/9cc47bce-350d-4e9d-83d6-a3463e0a4e70.png)
Not always is the same URL, so you need to check that the URL return 405 status code.You need to trigger AWS Captcha to be able to see this URL.
Also the URL return a HTML that have these values:
![](https://assets.capsolver.com/prod/images/post/2023-07-12/a916fe59-0de5-4388-ab5d-52c4f3845699.png)
**If the website return 405 status code and return a response html that have key, iv, context, then it's the right url that you need to send to us.**

To solve AWS WAF Captcha, follow our documentation. For this example, we will only use the required parameters. The task types for AWS WAF Captcha are:

- AntiAwsWafTask: This task type requires your own proxies.
- AntiAwsWafTaskProxyLess: This task type doesn't require your own proxies.

We will use AntiAwsWafTaskProxyLess.

### Step 1: Submitting the Information to CapSolver

```json
POST https://api.capsolver.com/createTask
{
 "clientKey":"yourapiKey",
 "task":
 {
 "type":"AntiAwsWafTaskProxyLess",
 "websiteURL":"https://efw47fpad9.execute-api.us-east-1.amazonaws.com/latest"
 }
}
```
### Step 2: Getting the Results
We will need to retrieve the getTaskResult method until the captcha is solved.
```json
POST https://api.capsolver.com/getTaskResult
Host: api.capsolver.com
Content-Type: application/json
{
 "clientKey":"YOUR_API_KEY",
 "taskId": "TASKID OF CREATETASK" //ID created by the createTask method
}
```
Captcha solution will look like:
![AWS CAPTCHA TOKEN SOLUTION](https://assets.capsolver.com/prod/images/post/2023-07-12/925dd643-d8b9-4a7b-923c-f0b0c897e04e.png)

**After the captcha has been solved, you can check by creating the cookie aws-waf-token and adding the value that we return to you**

In conclusion, solving AWS WAF Captcha can be a daunting task, but with the help of capsolver.com, it can be done quickly and efficiently. By following the steps outlined above, you can easily solve AWS WAF Captcha.

CapSolver Team 💜
Sloan's Inbox: What's it take to go from 0 dev skills to successful game developer?
Tags: discuss, career, gamedev, beginners
Published: 2023-07-13 14:50:02

Heyo! Sloan here... DEV Moderator and resident mascot 🦥

Welcome to a new installment of Sloan's Inbox, your go-to place for sharing advice and observations. Whether it's career development, office politics, industry trends, or improving technical skills, we've got you covered. So, let's continue our journey of learning and growth together.

As always, I'm here to dive into your questions, comments, and thoughts. So, let's get to it!

### Today's question is:

> I'm 35 years old and haven't programmed a single line of code... is becoming a successful game developer a pipe dream? And even if it is, if I want to get into game development where should I start? Also, what's it like being an indie game dev versus a game dev for a mid- to large-sized studio?
> 

Share your thoughts and let's help a fellow DEV member out! Remember to keep kind and stay classy. 😎

---


*Want to submit a question for discussion or ask for advice? [Visit Sloan's Inbox](https://docs.google.com/forms/d/e/1FAIpQLSc6wgzJ1hh2OR4WsWlJN9WHUJ8jV4dFkRDF2TUP32urHSAsQg/viewform)! You can choose to remain anonymous.*
Announcing the "St. Albnas" Hackathon! Clean some data, win $20 of swag.
Tags: programming, github, showdev, ai
Published: 2023-07-13 14:49:31

Hey DEV Community!

We're excited to announce the "St. Albnas" Hackathon! Clean some data, have some fun, win some swag.

If you work with data at all, you've probably seen the [St. Albnas meme](https://www.linkedin.com/posts/aesroka_management-we-have-great-datasets-the-datasets-activity-7072180991229874176-p8PX/) originally shared by Adam Sroka.

![Various misspellings of "St. Albans"](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/czbdfg35fbzr21fzfzl3.png)

We decided to have some fun with it and run a li'l hackathon.

If you can write some code to successfully converge all the inaccurate spellings of `St. Albans` to the correct spelling - while avoiding false positives - we'll send you a code to get $20 in free [Tinybird](https://www.tinybird.co) [swag](https://shop.tinybird.co).

## Here's how to do it

⭐️ Star and fork the repo
🧑🏽‍💻 Write some code to clean the data
📩 Submit a PR by 5 PM on Friday Jul 21
🐦 Follow Tinybird on [Twitter](https://twitter.com/tinybirdco) or [LinkedIn](https://www.linkedin.com/company/tinybird-co)
📣 Share your submission on social media using the hashtag `#stalbnashackathon` (notice the intentional misspelling! 🤪) and tag Tinybird!

Full rules are in the [GitHub repo](https://github.com/tinybirdco/st-albnas-hackathon)

This is just for fun. No winners and losers. Just free swag for giving it a go.

But just to incentivize the competitors, we'll post the final leaderboard after it's all over.

What are you waiting for? Clone the repo and get going!
TIL About Web Accessibility
Tags: webdev, a11y, beginners
Published: 2023-07-13 14:48:17

The internet is an amazing resource that can level the playing field between people of different backgrounds and provide opportunities for education and enrichment for all.

That being said, the internet has not always been designed with diverse users in mind.  This has frequently resulted in pages that may look and sound beautiful to the average user, but will be completely inaccessible to those with a wide array of disabilities.

Today, I took the time to look into different ways to make a website accessible.  I already knew the importance of using _alt_ descriptions for images and video, and providing transcripts for audible content, however I had not considered other ways of doing so.  The methods I learned today - ARIA (Accessible Rich Internet Applications) Landmarks, and alternatives to using CAPTCHA technologies.

[ARIA Landmarks](https://www.w3.org/WAI/ARIA/apg/patterns/landmarks/examples/general-principles.html) are a way to identify the structure and navigation of a webpage.  By identifying different sections of the web page with roles like "main" or "navigation" or "form", it will be easier for a variety of user agents to parse, such as a screen reader for those with visual disabilities.

[CAPTCHAs](https://www.w3.org/WAI/intro/captcha.php) have been an invaluable tool in preventing bad actors and bots from overloading a website with requests and minimizing bandwidth costs and preventing DDOS attacks.  They have also been a fundamental tool in training AI to recognize text and images.  However, despite their benefits, they are frequently not designed in an accessible way.  There are a variety of alternatives to CAPTCHA that seek to solve this problem.  For example, many sites are beginning to use behavioral analysis that observes the way in which you have interacted with the website to determine if you are likely a human or a bot, but many still use a CAPTCHA as a back-up option in case of false results from the behavioral analysis.  This definitely seems like a hard problem to solve.  As AI and bots become more advanced, we will need to come up with more sophisticated measures to detect them while also being careful to not become inaccessible to humans.
Creates Beautiful & Amazing Graphics In MINUTES
Tags: design
Published: 2023-07-13 14:41:13

This is a great designing tools which is easy to setup and design.

For High-Converting Sales Funnels, Websites,
Stores & Blogs To Get More Leads & Sales!

No Prior Design, Technical Skills or Outsourcing Needed.
https://hop.clickbank.net/?affiliate=rijanc&vendor=clkdesigns