This project implements the PostgreSQL wire protocol in Go using only the standard library.

func main() {
	connStr := "postgres://postgres:123456@localhost:5432/postgres"
	driveConfig := models.DriveConfig{Verbose: true,}
	pgConnection, err := protocol.NewPgConnection(connStr, driveConfig)
	if err != nil {
		fmt.Println(err)
		return
	}
	userToFind := "postgres"
	res, err := pgConnection.Query("SELECT * FROM pg_user WHERE usename = 1ドル;", userToFind)
	if err != nil {
		fmt.Println(err)
		pgConnection.Close()
		return
	}
	fmt.Println("Postgres user: ", res.Rows)
	pgConnection.Close()
}

• Flexible Connection Handling
  • Supports both URL-style connection strings (postgres://user:pass@host:port/db)
  • Supports key-value connection strings (host=localhost port=5432)
• SSL/TLS Support
  • Automatic SSL/TLS negotiation when sslmode=require
  • Secure encrypted connections
• Query Interface
  • Simple query protocol support
  • Extended query protocol with parameter binding
  • Support for parameterized queries using 1,ドル 2ドル etc.
• Connection Configuration
  • Configurable verbose mode for debugging
  • Custom drive configuration options via models.DriveConfig
• Authentication
  • SCRAM-SHA-256
  • md5
  • clear text
• Clean Resource Management
  • Proper connection termination

1. Clone the repository:

   git clone https://github.com/ViniciusCestarii/postgres-protocol-go.git

2. Create environment file:

   cp .env.example .env

3. Set the environment variables in the .env file.

4. Run the client implementation:

   go run cmd/client.go

postgres-protocol-go/
│── cmd/
│ ├── client.go # Client implementation example using this driver
│── internal/
│ ├── pool/ # Buff writer
│ ├── protocol/ # PostgreSQL wire protocol handling
│── pkg/
│ ├── utils/ # Shared utilities (logging, errors, helpers)
│ ├── models/ # Data structures for queries, results, etc.
│── tests/ # Integration and unit tests
│── go.mod # Go module file
│── README.md # Project documentation

To run the tests, use the following commands:

go test ./tests/...

Official Protocol Documentation

Message Formats

pbkdf2 go implementation

gp-pg

This project is licensed under the MIT License - see the LICENSE file for details.