# is_even

Calculates if a value is even.

# Countries

This extension creates a table named `countries` which contains the countries of the world. The countries table contains the following columns:

- `name` - full country name.
- `local_name` - local variation of the name.
- `iso2` - ISO 3166-1 alpha-2 code.
- `iso3` - ISO 3166-1 alpha-3 code.
- `continent` - continent of the country.

## Developers

To publish a new version, run the following command from the root folder of this extension:

`dbdev publish`

If you have `dbdev` CLI version `0.1.3` or older, you will need to specify the path explicitly:

`dbdev publish --path .`


# `pg_idkit`

Useful ID generators and utilities. A pure PL/pgSQL port of the popular [Rust version](https://github.com/VADOSWARE/pg_idkit).

The goal is to have no additional extension requirements (eg: no pgcrypto) to maintain portability.

- Source: https://github.com/kiwicopple/pg-extensions/tree/main/pg_idkit
- Docs: https://github.com/kiwicopple/pg-extensions/tree/main/pg_idkit
- DbDev: https://database.dev/kiwicopple/pg_idkit

## Usage

Function signatures follows a similar pattern to the built-in

- `gen_random_uuid_v6()` - generate a random UUID v6
- `gen_random_uuid_v7()` - generate a random UUID v7
- `gen_random_ksuid_second()` - generate a random KSUID with second-level precision
- `gen_random_ksuid_microsecond()` - generate a random KSUID with microsecond-level precision
- `timestamp_from_uuid_v7(uuidv7, timezone?)` - extract a timestamp from a UUIDv7. Optionally provide timezone (like 'America/New_York')

## Installation

```bash
dbdev install kiwicopple-pg_idkit --connection <CONNECTION_STRING>
```

or

```sql
select * from dbdev('kiwicopple-pg_idkit')
```

then:

```sql
create extension pg_idkit;
```

or to install in a separate schema (recommended):

```sql
create extension pg_idkit with schema extensions;
```

## Credits

- [`fabiolimace`](https://github.com/fabiolimace). Most of the work of this repo can be attributed to Fabio's gists on GitHub.

# `supa_audit`

<p>
<a href=""><img src="https://img.shields.io/badge/postgresql-12+-blue.svg" alt="PostgreSQL version" height="18"></a>
<a href="https://github.com/supabase/supa_audit/actions"><img src="https://github.com/supabase/supa_audit/actions/workflows/test.yaml/badge.svg" alt="Tests" height="18"></a>

</p>

---

**Source Code**: <a href="https://github.com/supabase/supa_audit" target="_blank">https://github.com/supabase/supa_audit</a>

---

The `supa_audit` PostgreSQL extension is a generic solution for tracking changes to tables' data over time.

The audit table, `audit.record_version`, leverages each records primary key values to produce a stable `record_id::uuid`, enabling efficient (linear time) history queries.


## Usage

```sql
create extension supa_audit cascade;

create table public.account(
    id int primary key,
    name text not null
);

-- Enable auditing
select audit.enable_tracking('public.account'::regclass);

-- Insert a record
insert into public.account(id, name)
values (1, 'Foo Barsworth');

-- Update a record
update public.account
set name = 'Foo Barsworht III'
where id = 1;

-- Delete a record
delete from public.account
where id = 1;

-- Truncate the table
truncate table public.account;

-- Review the history
select
    *
from
    audit.record_version;

/*
 id |              record_id               |            old_record_id             |    op    |               ts                | table_oid | table_schema | table_name |                 record                 |             old_record
----+--------------------------------------+--------------------------------------+----------+---------------------------------+-----------+--------------+------------+----------------------------------------+------------------------------------
  1 | 57ca384e-f24c-5af5-b361-a057aeac506c |                                      | INSERT   | Thu Feb 10 17:02:25.621095 2022 |     16439 | public       | account    | {"id": 1, "name": "Foo Barsworth"}     |
  2 | 57ca384e-f24c-5af5-b361-a057aeac506c | 57ca384e-f24c-5af5-b361-a057aeac506c | UPDATE   | Thu Feb 10 17:02:25.622151 2022 |     16439 | public       | account    | {"id": 1, "name": "Foo Barsworht III"} | {"id": 1, "name": "Foo Barsworth"}
  3 |                                      | 57ca384e-f24c-5af5-b361-a057aeac506c | DELETE   | Thu Feb 10 17:02:25.622495 2022 |     16439 | public       | account    |                                        | {"id": 1, "name": "Foo Barsworth III"}
  4 |                                      |                                      | TRUNCATE | Thu Feb 10 17:02:25.622779 2022 |     16439 | public       | account    |                                        |
(4 rows)
*/

-- Disable auditing
select audit.disable_tracking('public.account'::regclass);
```

## Test

### Run the Tests

```sh
nix-shell --run "pg_13_supa_audit make installcheck"
```

### Adding Tests

Tests are located in `test/sql/` and the expected output is in `test/expected/`

The output of the most recent test run is stored in `results/`.

When the output for a test in `results/` is correct, copy it to `test/expected/` and the test will pass.

## Interactive Prompt

```sh
nix-shell --run "pg_13_supa_audit psql"
```

## Performance


### Write Throughput
Auditing tables reduces throughput of inserts, updates, and deletes.

It is not recommended to enable tracking on tables with a peak write throughput over 3k ops/second.


### Querying

When querying a table's history, filter on the indexed `table_oid` rather than the `table_name` and `schema_name` columns.

```sql
select
    *
from
    audit.record_version
where
    table_oid = 'public.account'::regclass::oid;
```


kiwicopple

Packages