# UUID Field Type or Formula

**URL:** https://community.baserow.io/t/uuid-field-type-or-formula/1877
**Category:** Feature Ideas
**Tags:** data, formula
**Created:** [December 14, 2022, 2:12pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877 "2022-12-14T14:12:28Z")
**Posts on this page:** 6
**Page:** 2

<div class="post-metadata">

### Author: ![glarrain-cdd](https://community.baserow.io/letter_avatar_proxy/v4/letter/g/c2a13f/32.png) [@glarrain-cdd](https://community.baserow.io/u/glarrain-cdd)
#### Post date: [November 3, 2023, 4:05pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/21 "2023-11-03T16:05:24Z")

</div>

Thanks for your response.

A couple of comments:

- `uuid_generate_v4` **is supported in PG 11** , in the`uuid-ossp` [official extension](https://www.postgresql.org/docs/11/uuid-ossp.html)
- PG 11 end of life (end of official support) is [9 Nov 2023](https://endoflife.date/postgresql) (Postgres policy is to do this 5 years after the initial release (2018 in the case of PG 11)

---

<div class="post-metadata">

### Author: ![bram](https://community.baserow.io/letter_avatar_proxy/v4/letter/b/9d8465/32.png) [@bram](https://community.baserow.io/u/bram)
#### Post date: [November 5, 2023, 1:01pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/22 "2023-11-05T13:01:22Z")

</div>

Hi @glarrain-cdd, I realize that there are extensions that can help with generating UUIDs, but unfortunately, we can’t depend on PostgreSQL extensions. This is because we allow users to self-host, and we never know whether they can access to installing extensions.

We’re soon going to make PG 12 as minimum requirement for Baserow. Unfortunately, the native uuid functions were included in PG 13.

---

<div class="post-metadata">

### Author: ![glarrain-cdd](https://community.baserow.io/letter_avatar_proxy/v4/letter/g/c2a13f/32.png) [@glarrain-cdd](https://community.baserow.io/u/glarrain-cdd)
#### Post date: [November 7, 2023, 1:01pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/23 "2023-11-07T13:01:00Z")

</div>

A minor comment that might be useful for others interested in the details, or for future reference:

- Postgres SQL function `random` (part of the math functions) returns pseudo-random values, which means those values can not be used for crypto-secure purposes
- Postgres UUID (v4) SQL functions do return values that have been calculated using crypto-secure tools (true random number generators (RNGs))

Thus, the aforementioned custom formula is supposed to be appropriate for most cases, but it is not entirely equivalent to Postgres UUID (v4) generation SQL functions. For most people, that detail would be insignificant.

---

<div class="post-metadata">

### Author: ![bram](https://community.baserow.io/letter_avatar_proxy/v4/letter/b/9d8465/32.png) [@bram](https://community.baserow.io/u/bram)
#### Post date: [November 8, 2023, 9:37am UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/24 "2023-11-08T09:37:59Z")

</div>

Thank you for explaining that @glarrain-cdd. Would you mind sharing more about your use-case for the UUID field so that I have a better understanding of what you need true random values for?

---

<div class="post-metadata">

### Author: ![glarrain-cdd](https://community.baserow.io/letter_avatar_proxy/v4/letter/g/c2a13f/32.png) [@glarrain-cdd](https://community.baserow.io/u/glarrain-cdd)
#### Post date: [November 13, 2023, 4:59pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/25 "2023-11-13T16:59:45Z")

</div>

Sure. We have many databases in disparate systems. We refactor and move tables a lot, and for that has been extremely valuable to have a globally unique ID per record.

We’ve been wanting to use baserow in our company for some time, and have been waiting until all our non-functional requirements are fulfilled. The UUID v4 data type (and random value generation on record creation) is one of those.

---

<div class="post-metadata">

### Author: ![guiolmar](https://community.baserow.io/user_avatar/community.baserow.io/guiolmar/32/866_2.png) [@guiolmar](https://community.baserow.io/u/guiolmar)
#### Post date: [December 20, 2023, 12:26pm UTC](https://community.baserow.io/t/uuid-field-type-or-formula/1877/26 "2023-12-20T12:26:09Z")

</div>

Version 1.22 is now available and with it this feature. 😊

[Previous page](https://community.baserow.io/t/uuid-field-type-or-formula/1877.md?page=1)
