sqids-postgresql - GitLite

KO | EN

gitlite — search

#python #hacktoberfest #ai #typescript #llm #golang #go #android #deep-learning #docker #java #windows #cli #ios

sqids-postgresql

(★ 102)

Official PostgreSQL port of Sqids. Generate short unique IDs from numbers.

파일 탐색기

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

- config.toml
- - build.yml
- - setup.out
- - setup.sql
- - pgrx_embed.rs
- error.rs
- lib.rs
- utils.rs
.clippy.toml
.gitignore
Cargo.toml
CHANGELOG.md
LICENSE
pg_sqids.control
README.md
rustfmt.toml

# 설치 가이드

1. 코드 내려받기

git clone https://github.com/sqids/sqids-postgresql

깃허브에서 프로젝트 코드 전체를 내 컴퓨터로 내려받습니다.

cd sqids-postgresql

방금 내려받은 프로젝트 폴더 안으로 이동합니다.

2. 공식 설치 스크립트

쉬움 추천

사전 준비물

Rust (rustup) cargo 명령어를 쓰려면 Rust가 필요합니다.

cargo install --locked --version=0.18.1 cargo-pgrx

crates.io에 배포된 패키지를 빌드해서 설치합니다. 레포를 직접 클론할 필요가 없습니다.

✅ 설치 후 새 터미널을 열고, 프로그램의 버전 확인 명령(예: --version)으로 정상 설치됐는지 확인하세요.

이 레포의 README에 적힌 실제 명령어를 그대로 가져왔습니다.

3. Rust

보통

사전 준비물

Git GitHub에서 프로젝트 코드를 내려받으려면 필요합니다.
Rust (rustup) rustup으로 설치하면 cargo도 함께 설치됩니다.

cargo install --locked --version=0.18.1 cargo-pgrx

crates.io에 배포된 패키지를 빌드해서 설치합니다. 레포를 직접 클론할 필요가 없습니다.

cargo build

Rust 프로젝트를 컴파일합니다.

cargo pgrx run

이 명령어를 터미널에 그대로 입력해 실행하세요.

cargo pgrx package

이 명령어를 터미널에 그대로 입력해 실행하세요.

✅ cargo build가 에러 없이 끝나면 성공입니다. target/ 폴더에 실행 파일이 생성됩니다.

이 레포의 README에 적힌 실제 명령어를 그대로 가져왔습니다.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# [Sqids PostgreSQL](https://sqids.org/postgresql)

[![Github Actions](https://img.shields.io/github/actions/workflow/status/sqids/sqids-postgresql/build.yml)](https://github.com/sqids/sqids-postgresql/actions)

[Sqids](https://sqids.org/postgresql) (*pronounced "squids"*) is a small library that lets you **generate unique IDs from numbers**. It's good for link shortening, fast & URL-safe ID generation and decoding back into numbers for quicker database lookups.

Features:

- **Encode multiple numbers** - generate short IDs from one or several non-negative numbers
- **Quick decoding** - easily decode IDs back into numbers
- **Unique IDs** - generate unique IDs by shuffling the alphabet once
- **ID padding** - provide minimum length to make IDs more uniform
- **URL safe** - auto-generated IDs do not contain common profanity
- **Randomized output** - Sequential input provides nonconsecutive IDs
- **Many implementations** - Support for [40+ programming languages](https://sqids.org/)

## 🧰 Use-cases

Good for:

- Generating IDs for public URLs (eg: link shortening)
- Generating IDs for internal systems (eg: event tracking)
- Decoding for quicker database lookups (eg: by primary keys)

Not good for:

- Sensitive data (this is not an encryption library)
- User IDs (can be decoded revealing user count)

## 🚀 Getting started

### Development

1. [Install Rust](https://www.rust-lang.org/) if you don't have it.

1. Install [pgrx](https://github.com/pgcentralfoundation/pgrx?tab=readme-ov-file#getting-started):

```bash
    cargo install --locked --version=0.18.1 cargo-pgrx 
    ```

1. Install dependencies and run psql session:

```bash
    cargo build
    cargo pgrx run
    ```

1. Install extension:

```sql
    DROP EXTENSION pg_sqids;
    CREATE EXTENSION pg_sqids;
    ```

1. Run sample query:

```sql
    SELECT sqids_encode(1, 2, 3); -- 86Rf07
    ```

### Installing

1. Create the extension:

```bash
    cargo pgrx package
    ```

1. Extension file should be in `target/release`

- For Linux: `libpg_sqids.so`
    - For macOS: `libpg_sqids.dylib`
    - For Windows: `pg_sqids.dll`

1. Install the extension:

```sql
    DROP EXTENSION pg_sqids;
    CREATE EXTENSION pg_sqids;
    ```

## 👩‍💻 Examples

Simple encode & decode:

```sql
SELECT sqids_encode(1, 2, 3); -- 86Rf07
SELECT sqids_decode('86Rf07'); -- {1,2,3}
```

> **Note**
> 🚧 Because of the algorithm's design, **multiple IDs can decode back into the same sequence of numbers**. If it's important to your design that IDs are canonical, you have to manually re-encode decoded numbers and check that the generated ID matches.

Enforce a *minimum* length for IDs:

```sql
SELECT sqids_encode(10::smallint, 1, 2, 3); -- 86Rf07xd4z
SELECT sqids_decode(10::smallint, '86Rf07xd4z'); -- {1,2,3}
```

Randomize IDs by providing a custom alphabet:

```sql
SELECT sqids_encode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', 1, 2, 3); -- XRKUdQ
SELECT sqids_decode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', 'XRKUdQ'); -- {1,2,3}
```

Prevent specific words from appearing anywhere in the auto-generated IDs:

```sql
SELECT sqids_encode(array['86Rf07'], 1, 2, 3); -- se8ojk
SELECT sqids_decode(array['86Rf07'], 'se8ojk'); -- {1,2,3}
```

### Using multiple parameters

Alphabet + min length:

```sql
SELECT sqids_encode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', 10::smallint, 1, 2, 3); -- XRKUdQVBzg
SELECT sqids_decode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', 10::smallint, 'XRKUdQVBzg'); -- {1,2,3}
```

Alphabet + blocklist:

```sql
SELECT sqids_encode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', array['XRKUdQ'], 1, 2, 3); -- WyXQfF
SELECT sqids_decode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', array['XRKUdQ'], 'WyXQfF'); -- {1,2,3}
```

Min length + blocklist:

```sql
SELECT sqids_encode(10::smallint, array['86Rf07'], 1, 2, 3); -- se8ojkCQvX
SELECT sqids_decode(10::smallint, array['86Rf07'], 'se8ojkCQvX'); -- {1,2,3}
```

Alphabet + min length + blocklist:

```sql
SELECT sqids_encode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', 10::smallint, array['XRKUdQVBzg'], 1, 2, 3); -- WyXQfFQ21T
SELECT sqids_decode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', 10::smallint, array['XRKUdQVBzg'], 'WyXQfFQ21T'); -- {1,2,3}
```

## 📝 License

[MIT](LICENSE)