db

it ops db postgresql tsid

GitHub - schinckel/ulid-postgres

Contribute to schinckel/ulid-postgres development by creating an account on GitHub.

wono | discuss |

it ops db postgresql tsid

GitHub - chrhansen/postgres-ulid: Generate ULIDs (https://github.com/ulid/spec) in Postgres, with options to output in Base58 and/or prefix IDs.

Generate ULIDs (https://github.com/ulid/spec) in Postgres, with options to output in Base58 and/or prefix IDs. - chrhansen/postgres-ulid

wono | discuss |

it ops db postgresql pk

Choosing Primary Key Type in Postgres

In relational database design one of the key decisions is choosing the right primary key type for tables. In this post I am talking about surrogate or synthetic primary keys. They are called surrog…

wono | discuss |

it ops db postgresql tsid

GitHub - vabatta/pg_base32: A base32 postgres extension. Supports RFC4648 and Crockford.

A base32 postgres extension. Supports RFC4648 and Crockford. - vabatta/pg_base32

wono | discuss |

it ops db postgresql tsid

pgcrockford: Crockford Base 32 encoding for unsigned ints

The pgcrockford extension provides Base 32 encoded integers as a PostgreSQL base type. From [Douglas Crockford's requirements][crockford] for the specification, …

wono | discuss |

it ops db postgresql uuidv7

Donghua's Blog - DBAGlobe

A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.

wono | discuss |

it ops db postgresql pgpedia

pgPedia - a PostgreSQL Encyclopedia

wono | discuss |

it ops db postgresql uuidv7

Waiting for PostgreSQL 18 – Add UUID version 7 generation function. – select * from depesz;

wono | discuss |

it ops db postgresql uuidv7

UUIDv7 in YugabyteDB

When creating a user-defined function for inserts, such as one that generates a default value, you... Tagged with yugabytedb, distributed, postgres, sql.

wono | discuss |

it ops db postgresql uuidv7

GitHub - dverite/postgres-uuidv7-sql: Pure SQL functions to use UUIDs v7 in PostgreSQL

Pure SQL functions to use UUIDs v7 in PostgreSQL. Contribute to dverite/postgres-uuidv7-sql development by creating an account on GitHub.

wono | discuss |

it ops db uuid postgresql

Functions for generating UUIDv6 and UUIDv7 on PostgreSQL

Functions for generating UUIDv6 and UUIDv7 on PostgreSQL - UUIDv6.sql

wono | discuss |

it ops db postgresql identity

PostgreSQL Identity Column

This tutorial shows you how to use the GENERATED AS IDENTITY constraint to create the PostgreSQL identity column for a table.

wono | discuss |

it ops db xid

GitHub - modfin/pg-xid: pg-xid is a globally unique id generator for postgres

pg-xid is a globally unique id generator for postgres - modfin/pg-xid

wono | discuss |

it ops db postgresql tsid

TSIDs strike the perfect balance between integers and UUIDs for most databases – Foxhound Systems

A look at why TSIDs are the best of both worlds when it comes to database keys.

wono | discuss |

it ops db postgresql

Choosing a Postgres Primary Key

Turns out the question of which identifier to use as a Primary Key is complicated -- we're going to dive into some of the complexity and inherent trade-offs, and figure things out

wono | discuss |

it ops db postgresql

Postgres 유용한 query모음.

Postgres 유용한 query모음. GitHub Gist: instantly share code, notes, and snippets.

wono | discuss |

it ops db postgresql

[Postgresql] uuid 생성함수

uuid 생성방법에는 여러가지가 있다. 방법1. CREATE OR REPLACE FUNCTION gen_uuid() RETURNS uuid stable language sql as 'SELECT md5(random()::text || clock_timestamp()::text)::uuid'; SELECT gen_uuid(); 방법2 CREATE EXTENSION "uuid-ossp"; SELECT uuid_generate_v4();

wono | discuss |

it ops db tsid

Function for generating Time Sortable ID with microsecond precision on PostgreSQL

Function for generating Time Sortable ID with microsecond precision on PostgreSQL - fn_tsid_micro.sql

wono | discuss |

it ops db uuid tsid

GitHub - junyoung-kang-kurly/insert-test-demo: mysql, postgresql 을 이용해서 uuid 등을 insert 하는데 속도를 체크해본다

mysql, postgresql 을 이용해서 uuid 등을 insert 하는데 속도를 체크해본다 - junyoung-kang-kurly/insert-test-demo

wono | discuss |

it ops db pk uuid

분산환경에서 DB 기본키(PK)는 어떤 ID 생성 전략으로 만들어야할까? (UUID,ULID,TSID...)

보통 개발 편의성을 위해 Oracle의 Sequence, MySQL의 auto_increment 로 숫자를 1씩 증가시키는 것으로 만든다. 이것은 어떤 문제점이 있을까? 외부에서 해당 시스템 PK를 예측하기 쉬워져서 SQL Injection 문제 Sequence, auto_increment는 중앙 집중식으로 값을 생성하는 방식이므로 DB에 의존적이게 되어 확장성이 제한되는 문제 서비스 폭풍성장 시, ID 고갈되는 문제 (BIGINT 최댓값은 4,294,967,295 이고, unsigned BIGINT라면 18,446,744,073,709,551,615) 데이터베이스 변경의 어려움 DB가 2대 이상일 때 중복 문제 💡 MySQL 5.7 이하 버전에서는 AUTO_INCREMENT counter 값을 메모리에..

wono | discuss |