DEV Community: Yan-Ying Liao

Unofficial LeetCode API + Daily Updated Google Sheet

Yan-Ying Liao — Thu, 20 Feb 2025 15:12:24 +0000

Hi everyone,

I've built an unofficial LeetCode API and a daily-updated Google Sheet with all the LeetCode questions. Unlike other projects, you can query problems directly using their questionId. It’s powered by FastAPI with interactive docs, and the Google Sheet lets you sort by likes, like ratio, and tags. (There's another popular sheet, but it's not open source and is missing about 300 questions.)

Check it out:

To enable filtering/sorting in the sheet, select Row 3 and go to Data > Filter views > Create new filter view.

This project is actively maintained, and I’d love your feedback!
Contributions are welcome—check out the GitHub repo to get involved.

GraphRAG Visualizer - An Easy Way to Visualize Microsoft's GraphRAG Artifacts

Yan-Ying Liao — Mon, 12 Aug 2024 19:13:51 +0000

👉 GraphRAG Visualizer
👉 GraphRAG Visualizer Demo
👉 Github Repository

Overview

GraphRAG Visualizer is an application designed to visualize Microsoft GraphRAG artifacts. By uploading parquet files generated from the GraphRAG indexing pipeline, users can easily view and analyze data without needing additional software or scripts.

Features

Graph Visualization: View the graph in 2D or 3D in the "Graph Visualization" tab.
Data Tables: Display data from the parquet files in the "Data Tables" tab.
Search Functionality: Fully supports search, allowing users to focus on specific nodes or relationships.
Local Processing: All artifacts are processed locally on your machine, ensuring data security and privacy.

Using the Search Functionality

Once the graphrag-api server is up and running, you can perform searches directly through the GraphRAG Visualizer. Simply go to the GraphRAG Visualizer and use the search interface to query the API server. This allows you to easily search and explore data that is hosted on your local server.

Graph Data Model

The logic for creating relationships for text units, documents, communities, and covariates is derived from the GraphRAG import Neo4j Cypher notebook.

Nodes

Node	Type
Document	`RAW_DOCUMENT`
Text Unit	`CHUNK`
Community	`COMMUNITY`
Finding	`FINDING`
Covariate	`COVARIATE`
Entity	Varies

Relationships

Source Node	Relationship	Target Node
Entity	`RELATED`	Entity
Text Unit	`PART_OF`	Document
Text Unit	`HAS_ENTITY`	Entity
Text Unit	`HAS_COVARIATE`	Covariate
Community	`HAS_FINDING`	Finding
Entity	`IN_COMMUNITY`	Community

I built a VSCode like Portfolio with React.js

Yan-Ying Liao — Sat, 17 Sep 2022 15:05:27 +0000

Live Demo

https://noworneverev.github.io/

About The Project

I built a VSCode like porfolio to practice with React.js. The project is inspired by Visual Studio Code and caglarturali.github.io. As I used markdown to build pages, it's super easy to modify them and write your own contents.

Features

Powered by markdown
Dark mode and light mode available
Closable tabs
Collapsible explorer
Responsive web design
Google analytics supported

Installation

1、 Clone the repo

git clone https://github.com/noworneverev/react-vscode-portfolio.git

2、 Install NPM packages

npm install

3、 Enter your name in .env.development

REACT_APP_NAME=<your_name>

4、 Add your markdown pages in public/pages
5、 Add your routes in src/app/pages/page.ts, make sure the names of pages are consistent with markdown files.

export const pages = [
  { index: 0, name: 'overview.md', route: '/overview' },
  { index: 1, name: 'skills.md', route: '/skills' },
  { index: 2, name: 'experience.md', route: '/experience' },
  { index: 3, name: 'education.md', route: '/education' },
  { index: 4, name: 'projects.md', route: '/projects' },  
  { index: 5, name: 'certificates.md', route: '/certificates' },
  { index: 6, name: 'accomplishments.md', route: '/accomplishments' },
];

6、 Add your social links in src/app/pages/link.tsx, which will appear in both sidebar and homepage.

 export const links = [
  {
    index: 0,
    title: "Find me on Github",
    href: "https://github.com/noworneverev",
    icon: <FaGithub />,
  },
];

7、 Runs the app in the development mode

npm start

8、 If you would like to deploy your own portfolio, don't forget to change Google Analytic measurement id in .env.production

REACT_APP_NAME=<your_name>
REACT_APP_MEASUREMENT_ID=<your_measurement_id>

Github Repo Link

https://github.com/noworneverev/react-vscode-portfolio

Any comment is welcome. Thank you!