postgresql + it ops db postgresql pk PostgreSQL generate unique sorted IDs for timestampsPostgreSQL generate unique sorted IDs for timestamps - snowflake.sql wono | discuss | tweet + it ops db postgresql base32 Base58 Encoder function in PostgreSQL> https://www.postgresql.org/docs/9.6/functions-binarystring.html wono | discuss | tweet + it ops db postgresql tsid How to encode a byte array to base32 in PostgreSQLI have a Java application that generates ids for primary keys by encoding cryptographically random bytes to base32 (RFC4648). How do I do the same with PostgreSQL from an SQL script? The gen_random... wono | discuss | tweet + it ops db postgresql tsid GitHub - sergeyprokhorenko/pg_ulid_comparison: Comparison of ULID generation functions for PostgreSQLComparison of ULID generation functions for PostgreSQL - sergeyprokhorenko/pg_ulid_comparison wono | discuss | tweet + it ops db postgresql tsid GitHub - schinckel/ulid-postgresContribute to schinckel/ulid-postgres development by creating an account on GitHub. wono | discuss | tweet + 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 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 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 | tweetNext
+ it ops db postgresql pk PostgreSQL generate unique sorted IDs for timestampsPostgreSQL generate unique sorted IDs for timestamps - snowflake.sql wono | discuss | tweet
+ it ops db postgresql base32 Base58 Encoder function in PostgreSQL> https://www.postgresql.org/docs/9.6/functions-binarystring.html wono | discuss | tweet
+ it ops db postgresql tsid How to encode a byte array to base32 in PostgreSQLI have a Java application that generates ids for primary keys by encoding cryptographically random bytes to base32 (RFC4648). How do I do the same with PostgreSQL from an SQL script? The gen_random... wono | discuss | tweet
+ it ops db postgresql tsid GitHub - sergeyprokhorenko/pg_ulid_comparison: Comparison of ULID generation functions for PostgreSQLComparison of ULID generation functions for PostgreSQL - sergeyprokhorenko/pg_ulid_comparison wono | discuss | tweet
+ it ops db postgresql tsid GitHub - schinckel/ulid-postgresContribute to schinckel/ulid-postgres development by creating an account on GitHub. wono | discuss | tweet
+ 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 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 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