ops + 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 | tweet + it ops db postgresql pk Choosing Primary Key Type in PostgresIn 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 | tweet + 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 | tweet + it ops db postgresql tsid pgcrockford: Crockford Base 32 encoding for unsigned intsThe pgcrockford extension provides Base 32 encoded integers as a PostgreSQL base type. From [Douglas Crockford's requirements][crockford] for the specification, … wono | discuss | tweet + it ops be uuid tsid ID 채번 전략 비교 및 TSID 도입 왜 Auto_Increment 대신 랜덤 식별 값을 고려하게 되었는가 그동안 참여했던 웹 프로젝트에서도, 학습 과정에서 활용되었던 프로젝트에서도 자원을 식별하는 값의 전략으로 Auto Increment 를 사용해왔습니다. Auto Increment 전략은 테이블에 wono | discuss | tweet + it ops naming auth "auth" 대신 "permissions"와 "login"을 사용합시다 | GeekNews"auth"라는 용어는 인증(authentication)과 권한 부여(authorization) 두 가지 의미를 가짐이로 인해 라이브러리나 패키지 이름에서 혼란이 발생함"authn"과 "authz"라는 용어는 명확하지 않고 이해하기 어려움인증과 권한 부여의 차이인증(authentication): 사용자가 누구인지 확인하는 과정권한 부여(authorizati wono | discuss | tweet + it ops db postgresql uuidv7 Donghua's Blog - DBAGlobeA blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. wono | discuss | tweet + it ops db postgresql pgpedia pgPedia - a PostgreSQL Encyclopedia wono | discuss | tweet + it ops db postgresql uuidv7 Waiting for PostgreSQL 18 – Add UUID version 7 generation function. – select * from depesz; wono | discuss | tweet + it ops db postgresql uuidv7 UUIDv7 in YugabyteDBWhen creating a user-defined function for inserts, such as one that generates a default value, you... Tagged with yugabytedb, distributed, postgres, sql. wono | discuss | tweet + it ops db postgresql uuidv7 GitHub - dverite/postgres-uuidv7-sql: Pure SQL functions to use UUIDs v7 in PostgreSQLPure SQL functions to use UUIDs v7 in PostgreSQL. Contribute to dverite/postgres-uuidv7-sql development by creating an account on GitHub. wono | discuss | tweet + it ops db uuid postgresql Functions for generating UUIDv6 and UUIDv7 on PostgreSQLFunctions for generating UUIDv6 and UUIDv7 on PostgreSQL - UUIDv6.sql wono | discuss | tweet + it ops db postgresql identity PostgreSQL Identity ColumnThis tutorial shows you how to use the GENERATED AS IDENTITY constraint to create the PostgreSQL identity column for a table. wono | discuss | tweet + it ops db xid GitHub - modfin/pg-xid: pg-xid is a globally unique id generator for postgrespg-xid is a globally unique id generator for postgres - modfin/pg-xid wono | discuss | tweet + it ops db postgresql tsid TSIDs strike the perfect balance between integers and UUIDs for most databases – Foxhound SystemsA look at why TSIDs are the best of both worlds when it comes to database keys. wono | discuss | tweet + it ops db postgresql Choosing a Postgres Primary KeyTurns 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 | tweet + it ops db postgresql Postgres 유용한 query모음.Postgres 유용한 query모음. GitHub Gist: instantly share code, notes, and snippets. wono | discuss | tweet + 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 | tweet + it ops db tsid Function for generating Time Sortable ID with microsecond precision on PostgreSQLFunction for generating Time Sortable ID with microsecond precision on PostgreSQL - fn_tsid_micro.sql wono | discuss | tweet + 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 | tweetNext
+ 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 | tweet
+ it ops db postgresql pk Choosing Primary Key Type in PostgresIn 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 | tweet
+ 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 | tweet
+ it ops db postgresql tsid pgcrockford: Crockford Base 32 encoding for unsigned intsThe pgcrockford extension provides Base 32 encoded integers as a PostgreSQL base type. From [Douglas Crockford's requirements][crockford] for the specification, … wono | discuss | tweet
+ it ops be uuid tsid ID 채번 전략 비교 및 TSID 도입 왜 Auto_Increment 대신 랜덤 식별 값을 고려하게 되었는가 그동안 참여했던 웹 프로젝트에서도, 학습 과정에서 활용되었던 프로젝트에서도 자원을 식별하는 값의 전략으로 Auto Increment 를 사용해왔습니다. Auto Increment 전략은 테이블에 wono | discuss | tweet
+ it ops naming auth "auth" 대신 "permissions"와 "login"을 사용합시다 | GeekNews"auth"라는 용어는 인증(authentication)과 권한 부여(authorization) 두 가지 의미를 가짐이로 인해 라이브러리나 패키지 이름에서 혼란이 발생함"authn"과 "authz"라는 용어는 명확하지 않고 이해하기 어려움인증과 권한 부여의 차이인증(authentication): 사용자가 누구인지 확인하는 과정권한 부여(authorizati wono | discuss | tweet
+ it ops db postgresql uuidv7 Donghua's Blog - DBAGlobeA blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. wono | discuss | tweet
+ it ops db postgresql uuidv7 Waiting for PostgreSQL 18 – Add UUID version 7 generation function. – select * from depesz; wono | discuss | tweet
+ it ops db postgresql uuidv7 UUIDv7 in YugabyteDBWhen creating a user-defined function for inserts, such as one that generates a default value, you... Tagged with yugabytedb, distributed, postgres, sql. wono | discuss | tweet
+ it ops db postgresql uuidv7 GitHub - dverite/postgres-uuidv7-sql: Pure SQL functions to use UUIDs v7 in PostgreSQLPure SQL functions to use UUIDs v7 in PostgreSQL. Contribute to dverite/postgres-uuidv7-sql development by creating an account on GitHub. wono | discuss | tweet
+ it ops db uuid postgresql Functions for generating UUIDv6 and UUIDv7 on PostgreSQLFunctions for generating UUIDv6 and UUIDv7 on PostgreSQL - UUIDv6.sql wono | discuss | tweet
+ it ops db postgresql identity PostgreSQL Identity ColumnThis tutorial shows you how to use the GENERATED AS IDENTITY constraint to create the PostgreSQL identity column for a table. wono | discuss | tweet
+ it ops db xid GitHub - modfin/pg-xid: pg-xid is a globally unique id generator for postgrespg-xid is a globally unique id generator for postgres - modfin/pg-xid wono | discuss | tweet
+ it ops db postgresql tsid TSIDs strike the perfect balance between integers and UUIDs for most databases – Foxhound SystemsA look at why TSIDs are the best of both worlds when it comes to database keys. wono | discuss | tweet
+ it ops db postgresql Choosing a Postgres Primary KeyTurns 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 | tweet
+ it ops db postgresql Postgres 유용한 query모음.Postgres 유용한 query모음. GitHub Gist: instantly share code, notes, and snippets. wono | discuss | tweet
+ 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 | tweet
+ it ops db tsid Function for generating Time Sortable ID with microsecond precision on PostgreSQLFunction for generating Time Sortable ID with microsecond precision on PostgreSQL - fn_tsid_micro.sql wono | discuss | tweet
+ 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 | tweet