pgparser

KO | EN

gitlite — search

#python #typescript #go #machine-learning #deep-learning #docker #macos #nodejs #java #windows #awesome #kubernetes #pytorch #open-source

(★ 31)

Pure Go PostgreSQL Parser. 100% compatible with PostgreSQL 17.7 AST and regression tests.

pgparser 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

> [!NOTE]
> pgplex: The Postgres Toolchain for Humans and Agents - [pgconsole](https://github.com/pgplex/pgconsole) · [pgschema](https://github.com/pgplex/pgschema) · [pgtui](https://github.com/pgplex/pgtui) · **pgparser**
> 
>  Brought to you by [Bytebase](https://www.bytebase.com/), open-source database governance platform.

![](https://raw.githubusercontent.com/pgplex/website/refs/heads/main/public/banner-pgparser.png)

# pgparser - Pure Go PostgreSQL Parser

`pgparser` is a **pure Go** implementation of the PostgreSQL SQL parser. It translates the original PostgreSQL grammar (`gram.y`) into Go using `goyacc`, ensuring **100% compatibility** with the PostgreSQL parse tree structure.

> **Target PostgreSQL Version**: 17.7 (REL_17_STABLE)

## Features

- **100% Native Go**: No CGO, no external dependencies.
- **AST Compatibility**: The generated Abstract Syntax Tree (AST) strictly matches PostgreSQL's internal `Node` structures (`parsenodes.h`), enabling seamless integration with other PG-compatible tools.
- **Battle-Tested**: Verified against PostgreSQL's own massive regression test suite (~45,000 SQL statements) with a **99.6% pass rate**.
- **Thread Safe**: The parser is designed to be safe for concurrent use.

## Installation

```bash
go get github.com/pgplex/pgparser
```

## Quick Start

```go
package main

import (
	"encoding/json"
	"fmt"
	"log"

"github.com/pgplex/pgparser/parser"
)

func main() {
	sql := "SELECT * FROM users WHERE id > 100"

// Parse the SQL string
	stmts, err := parser.Parse(sql)
	if err != nil {
		log.Fatalf("Parse error: %v", err)
	}

// Print the AST as JSON
	jsonBytes, _ := json.MarshalIndent(stmts, "", "  ")
	fmt.Println(string(jsonBytes))
}
```

## Architecture

This project is not a hand-written parser. It is a **port** of the official PostgreSQL source code:

1.  **Grammar**: `parser/gram.y` is a translated version of PostgreSQL's `src/backend/parser/gram.y`.
2.  **Lexer**: `parser/scan.l` logic is reimplemented in Go in `parser/lexer.go`.
3.  **Nodes**: `nodes/` contains Go struct definitions that map 1:1 to PostgreSQL's C structs.

## Development

### Requirements

- Go 1.18+
- `goyacc` (installed via `go install golang.org/x/tools/cmd/goyacc@latest`)

### Build & Test

```bash
# Regenerate parser (if gram.y changed)
make generate-parser

# Run tests
go test ./...

# Run PostgreSQL regression tests compatibility check
go test ./parser/pgregress -run TestPGRegressStats -v
```

## Star History

[![Star History Chart](https://api.star-history.com/svg?repos=pgplex/pgparser&type=date&legend=top-left)](https://www.star-history.com/#pgplex/pgparser&type=date&legend=top-left)

## Sponsor

[Bytebase](https://www.bytebase.com?utm_sourcepgparser) - open source, web-based database DevSecOps platform.

pgparser

pgparser 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

pgparser

pgparser 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README