# pgxr

**Repository Path**: data-visual/pgxr

## Basic Information

- **Project Name**: pgxr
- **Description**: pgxr —— 使用 Rust 开发 PostgreSQL 扩展函数（存储过程） pgxr 是一个 Rust 的 crate 库，可以实现用 Rust 语言来编写 PostgreS
- **Primary Language**: Rust
- **License**: BSD-2-Clause
- **Default Branch**: master
- **Homepage**: https://www.oschina.net/p/pgxr
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2024-04-29
- **Last Updated**: 2024-04-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# pgxr

**Obsoleted**: This project is not maintained now, please refer to the new [pgx project](https://github.com/tcdi/pgx).

Write PostgreSQL extension functions (as stored procedures) using Rust.

![](https://benchmarksgame-team.pages.debian.net/benchmarksgame/download/fast-programs-different-programming-languages.svg)

Use the Fastest, Efficient, Safe, Enjoyable language, to write In-Database programs, for the World's Most Advanced Open Source Relational Database!

# Code Example

```rust
#[macro_use]
extern crate pgxr;

use pgxr::bindings::*;

PG_MODULE_MAGIC!();

PG_FUNCTION_INFO_V1!(pg_finfo_pgxr_example_one);

#[no_mangle]
pub extern "C" fn pgxr_example_one(_fcinfo: FunctionCallInfo) -> Datum
{
    PG_RETURN_I32(1)
}

```

# Usage

```bash
git clone https://github.com/clia/pgxr.git
cd pgxr/examples/pgxr_example_one
cargo build --release
```

Then run `pg_config`

Find `PKGLIBDIR`, such as `/usr/lib/postgresql/11/lib`

```bash
sudo cp target/release/libpgxr_example_one.so /usr/lib/postgresql/11/lib
```

```bash
sudo su - postgres
psql
```

```sql
CREATE FUNCTION pgxr_example_one() RETURNS integer
     AS 'libpgxr_example_one.so', 'pgxr_example_one'
     LANGUAGE C STRICT;
```

```sql
select pgxr_example_one();
```

## bindgen

The included `bindings.rs` is for latest PostgreSQL version, current 11, on the Linux X86-64 arch.
You can `bindgen` your platform's `bindings.rs`, using:

```bash
bindgen wrapper.h -o src/bindings.rs -- -I /usr/include/postgresql/11/server
```

## Other platforms

This repo is for latest PostgreSQL version, current 11, on the Linux platform on X86-64 arch.

There are individual repos for each platform, listed below:

- [pgxr_lin_x64_10](https://github.com/clia/pgxr_lin_x64_10) - PostgreSQL 10 on Linux on X86-64
- [pgxr_lin_x64_11](https://github.com/clia/pgxr_lin_x64_11) - PostgreSQL 11 on Linux on X86-64
- [pgxr_lin_x64_12](https://github.com/clia/pgxr_lin_x64_12) - PostgreSQL 12 on Linux on X86-64
- [pgxr_lin_x64_93](https://github.com/clia/pgxr_lin_x64_93) - PostgreSQL 9.3 on Linux on X86-64
- [pgxr_lin_x64_94](https://github.com/clia/pgxr_lin_x64_94) - PostgreSQL 9.4 on Linux on X86-64
- [pgxr_lin_x64_95](https://github.com/clia/pgxr_lin_x64_95) - PostgreSQL 9.5 on Linux on X86-64
- [pgxr_lin_x64_96](https://github.com/clia/pgxr_lin_x64_96) - PostgreSQL 9.6 on Linux on X86-64
- [pgxr_mac_x64_10](https://github.com/clia/pgxr_mac_x64_10) - PostgreSQL 10 on macOS on X86-64
- [pgxr_mac_x64_11](https://github.com/clia/pgxr_mac_x64_11) - PostgreSQL 11 on macOS on X86-64

You can simply change the crate path in your `Cargo.toml` (No change the crate name `pgxr`) to develop for your target platform.

That is it.

Have fun!