db + it ops db mysql dump velog.io[Mysql] mysql dump 사용법데이터 백업 : mysqldump는 모든 데이터베이스 테이블의 내용을 SQL 명령으로 추출하여, 이를 통해 테이블 생성과 데이터 삽입을 할 수 있는 SQL 스크립트를 생성합니다.데이터 복원 : 생성된 덤프 파일은 mysql 명령어 라인 유틸리티를 사용하여 MySQL 데 wono 2 months ago | discuss | tweet + it ops db postgresql varchar wiki.postgresql.orgDon't Do This - PostgreSQL wiki wono 2 months ago | discuss | tweet + it ops db postgresql dba.stackexchange.comShould I add an arbitrary length limit to VARCHAR columns?According to PostgreSQL's docs, there's no performance difference between VARCHAR, VARCHAR(n) and TEXT. Should I add an arbitrary length limit to a name or address column? Edit: Not a dupe of: W... wono 2 months ago | discuss | tweet + it ops db plpgsql docs.aws.amazon.comPL/pgSQL의 구조 - Amazon RedshiftAmazon Redshift에서 사용되는 PL/pgSQL 언어의 구조에 대해 알아봅니다. wono 2 months ago | discuss | tweet + it ops db uuid tsid velog.io분산 환경에서 P.K는 어떤 전략으로 가져가면 좋을까?보통 내가 진행하는 프로젝트에서는 단일 데이터베이스를 사용하거나, 단일 시스템에서 동작했기에, auto_increment P.K 전략을 가져가도 중복된 값이 존재하는 경우가 거의 없기 때문에 문제가 되지 않았다. 하지만 대규모 분산 처리 시스템일 때는 이 자동 증가 전 wono 2 months ago | discuss | tweet + it ops db id pk adileo.github.io🔑 Awesome Identifiers wono 2 months ago | discuss | tweet + it ops db postgresql do velog.io[PostgreSQL] Function3이번 장은 for문과 loop를 이용하여 function을 사용하는 법을 익혀보려고 합니다. 우선은 천천히 감을 잡아가기 위해 나름대로의 난이도를 생각하여 쉬운 난이도부터 코드를 늘려가며 난이도를 높여보려고 합니다.for문과 loop 사용 연습 이에 대한 결과로 아래와 wono 2 months ago | discuss | tweet + it ops db postgresql tsid github.compg_random_id/lib/pg_random_id/sql/crockford-pure.sql at 0b4dc52c68b7b4aedca25e6a6cac848da7771d4a · arjunmenon/pg_random_idContribute to arjunmenon/pg_random_id development by creating an account on GitHub. wono 2 months ago | discuss | tweet + it ops db postgresql tsid github.comBuild software better, togetherGitHub is where people build software. More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. wono 2 months ago | discuss | tweet + it ops db postgresql pk gist.github.comPostgreSQL generate unique sorted IDs for timestampsPostgreSQL generate unique sorted IDs for timestamps - snowflake.sql wono 2 months ago | discuss | tweet + it ops db postgresql base32 stackoverflow.comBase58 Encoder function in PostgreSQL> https://www.postgresql.org/docs/9.6/functions-binarystring.html wono 2 months ago | discuss | tweet + it ops db postgresql tsid stackoverflow.comHow 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 2 months ago | discuss | tweet + it ops db postgresql tsid github.comGitHub - sergeyprokhorenko/pg_ulid_comparison: Comparison of ULID generation functions for PostgreSQLComparison of ULID generation functions for PostgreSQL - sergeyprokhorenko/pg_ulid_comparison wono 2 months ago | discuss | tweet + it ops db postgresql tsid github.comGitHub - schinckel/ulid-postgresContribute to schinckel/ulid-postgres development by creating an account on GitHub. wono 2 months ago | discuss | tweet + it ops db postgresql tsid github.comGitHub - 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 2 months ago | discuss | tweet + it ops db postgresql pk shekhargulati.comChoosing 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 2 months ago | discuss | tweet + it ops db postgresql tsid github.comGitHub - vabatta/pg_base32: A base32 postgres extension. Supports RFC4648 and Crockford.A base32 postgres extension. Supports RFC4648 and Crockford. - vabatta/pg_base32 wono 2 months ago | discuss | tweet + it ops db postgresql tsid www.postgresql.orgpgcrockford: 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 2 months ago | discuss | tweet + it ops db postgresql uuidv7 www.dbaglobe.comDonghua'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 2 months ago | discuss | tweet + it ops db postgresql pgpedia pgpedia.infopgPedia - a PostgreSQL Encyclopedia wono 2 months ago | discuss | tweetNext
+ it ops db mysql dump velog.io[Mysql] mysql dump 사용법데이터 백업 : mysqldump는 모든 데이터베이스 테이블의 내용을 SQL 명령으로 추출하여, 이를 통해 테이블 생성과 데이터 삽입을 할 수 있는 SQL 스크립트를 생성합니다.데이터 복원 : 생성된 덤프 파일은 mysql 명령어 라인 유틸리티를 사용하여 MySQL 데 wono 2 months ago | discuss | tweet
+ it ops db postgresql varchar wiki.postgresql.orgDon't Do This - PostgreSQL wiki wono 2 months ago | discuss | tweet
+ it ops db postgresql dba.stackexchange.comShould I add an arbitrary length limit to VARCHAR columns?According to PostgreSQL's docs, there's no performance difference between VARCHAR, VARCHAR(n) and TEXT. Should I add an arbitrary length limit to a name or address column? Edit: Not a dupe of: W... wono 2 months ago | discuss | tweet
+ it ops db plpgsql docs.aws.amazon.comPL/pgSQL의 구조 - Amazon RedshiftAmazon Redshift에서 사용되는 PL/pgSQL 언어의 구조에 대해 알아봅니다. wono 2 months ago | discuss | tweet
+ it ops db uuid tsid velog.io분산 환경에서 P.K는 어떤 전략으로 가져가면 좋을까?보통 내가 진행하는 프로젝트에서는 단일 데이터베이스를 사용하거나, 단일 시스템에서 동작했기에, auto_increment P.K 전략을 가져가도 중복된 값이 존재하는 경우가 거의 없기 때문에 문제가 되지 않았다. 하지만 대규모 분산 처리 시스템일 때는 이 자동 증가 전 wono 2 months ago | discuss | tweet
+ it ops db postgresql do velog.io[PostgreSQL] Function3이번 장은 for문과 loop를 이용하여 function을 사용하는 법을 익혀보려고 합니다. 우선은 천천히 감을 잡아가기 위해 나름대로의 난이도를 생각하여 쉬운 난이도부터 코드를 늘려가며 난이도를 높여보려고 합니다.for문과 loop 사용 연습 이에 대한 결과로 아래와 wono 2 months ago | discuss | tweet
+ it ops db postgresql tsid github.compg_random_id/lib/pg_random_id/sql/crockford-pure.sql at 0b4dc52c68b7b4aedca25e6a6cac848da7771d4a · arjunmenon/pg_random_idContribute to arjunmenon/pg_random_id development by creating an account on GitHub. wono 2 months ago | discuss | tweet
+ it ops db postgresql tsid github.comBuild software better, togetherGitHub is where people build software. More than 150 million people use GitHub to discover, fork, and contribute to over 420 million projects. wono 2 months ago | discuss | tweet
+ it ops db postgresql pk gist.github.comPostgreSQL generate unique sorted IDs for timestampsPostgreSQL generate unique sorted IDs for timestamps - snowflake.sql wono 2 months ago | discuss | tweet
+ it ops db postgresql base32 stackoverflow.comBase58 Encoder function in PostgreSQL> https://www.postgresql.org/docs/9.6/functions-binarystring.html wono 2 months ago | discuss | tweet
+ it ops db postgresql tsid stackoverflow.comHow 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 2 months ago | discuss | tweet
+ it ops db postgresql tsid github.comGitHub - sergeyprokhorenko/pg_ulid_comparison: Comparison of ULID generation functions for PostgreSQLComparison of ULID generation functions for PostgreSQL - sergeyprokhorenko/pg_ulid_comparison wono 2 months ago | discuss | tweet
+ it ops db postgresql tsid github.comGitHub - schinckel/ulid-postgresContribute to schinckel/ulid-postgres development by creating an account on GitHub. wono 2 months ago | discuss | tweet
+ it ops db postgresql tsid github.comGitHub - 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 2 months ago | discuss | tweet
+ it ops db postgresql pk shekhargulati.comChoosing 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 2 months ago | discuss | tweet
+ it ops db postgresql tsid github.comGitHub - vabatta/pg_base32: A base32 postgres extension. Supports RFC4648 and Crockford.A base32 postgres extension. Supports RFC4648 and Crockford. - vabatta/pg_base32 wono 2 months ago | discuss | tweet
+ it ops db postgresql tsid www.postgresql.orgpgcrockford: 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 2 months ago | discuss | tweet
+ it ops db postgresql uuidv7 www.dbaglobe.comDonghua'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 2 months ago | discuss | tweet
+ it ops db postgresql pgpedia pgpedia.infopgPedia - a PostgreSQL Encyclopedia wono 2 months ago | discuss | tweet