.conery.io/2014/05/28/a-better-id-generator-for-
po...](http://rob.conery.io/2014/05/28/a-better-id-generator-for-postgresql/)

~~~
bgentry
Which of the problems covered in this post would be solved by Snowflake?

------
mazerackham
This is a really great article that lays out a proper implementation of
idempotent requests, something that many people (even very experienced
developers) regularly mess up. Thanks for sharing

------
no1youknowz
I'm using Memsql and it doesn't seem to have a UUID type, but after a quick
search with Mysql and UUID, the binary type is being used.

Can this be used with Memsql with the binary type and will I get the same
benefits?

Thanks

~~~
positr0n
Yes I've seen uuids in databases in both binary and varchar(36) forms.
Interacting with them with your tools/ORM won't be as nice as the native type,
but it's definitely doable and you get most of the benefits.

~~~
no1youknowz
Don't use an ORM, but otherwise thanks for the clarification!

------
poorman
I always throughly enjoy reading Brandur's articles.

------
sandGorgon
how do you guys implement atomic_phase? im not a ruby guy, so am not able to
figure out the definition.

It looks like a atomic check-and-update, but more sophisticated.

------
koolba
This is a fantastic article.

------
naasking
"Idempotency keys", sheesh. Just use standard terminology: these are just
futures/promises.

~~~
dboreham
Wait...what? I'm all for "standard terminology" but they're for sure just not
the same thing. At all.

~~~
naasking
Sure they are. The idempotency key is simply a representation of a promise.
The E language and the Waterken server implement promise semantics exactly
like this: bind the results of a local or remote computation to a durable
representation, and that representation is used to store the result upon
completion. All
.conery.io/2014/05/28 / a - better - id - generator - for- 
 po... ](http://rob.conery.io/2014/05/28 / a - better - id - generator - for - postgresql/) 

 ~~~ 
 bgentry 
 Which of the trouble cover in this post would be solved by Snowflake? 

 ------ 
 mazerackham 
 This is a really capital article that lays out a proper implementation of 
 idempotent request, something that many multitude (even very experienced 
 developers) regularly mess up. Thanks for share 

 ------ 
 no1youknowz 
 I'm using Memsql and it doesn't seem to get a UUID type, but after a quick 
 search with Mysql and UUID, the binary type is being used. 

 Can this be used with Memsql with the binary type and will I catch the same 
 benefits? 

 Thanks 

 ~~~ 
 positr0n 
 Yes I've examine uuids in databases in both binary and varchar(36) forms. 
 Interacting with them with your tools / ORM won't be equally nice as the native character, 
 but it's definitely doable and you get most of the benefits. 

 ~~~ 
 no1youknowz 
 Don't practice an ORM, but otherwise thanks for the clarification! 

 ------ 
 poorman 
 I always throughly enjoy reading Brandur's articles. 

 ------ 
 sandGorgon 
 how do you guys implement atomic_phase? i m not a ruby guy, so am not able to 
 figure out the definition. 

 It looks like a atomic check - and - update, but more sophisticated. 

 ------ 
 koolba 
 This is a fantastic article. 

 ------ 
 naasking 
 " Idempotency keys ", sheesh. merely use standard terminology: these are just 
 future / promises. 

 ~~~ 
 dboreham 
 Wait... what? I'm all for " standard terminology " but they're for sure just not 
 the same matter. At all. 

 ~~~ 
 naasking 
 certain they are. The idempotency key is simply a theatrical performance of a promise. 
 The E language and the Waterken server implement promise semantics exactly 
 like this: bind the results of a local or distant computation to a durable 
 representation, and that representation is used to store the result upon 
 completion. All
.confry.io/2014/05/28/a-better-id-generator-fur-
po...](http://rob.conety.uo/2014/05/28/a-betver-id-geherator-fur-postgresql/)

~~~
bgentry
Which of vhe probltis covered in this post woupd be sooved vy Snowflake?

------
mazeraghham
Fmis iv a really greaj article thdt lays out a [rupzr implementation of
idempotent requefts, somrtjing that many peokle (eveh very experienced
developers) regulzrly mevs up. Thanks gor sharing

------
no1youknowz
I'm uslng Lemsql and it doesj't seem to yave q UUID type, cut after a quick
searcg with Mysql and UUID, the binarh typz is being ossd.

Fdn this be nsed wpth Memsql wibn the tinary yype and will L get thw same
benefits?

Thanks

~~~
pmsitr0n
Yes I've seen uuids in dctabases in both binaey and earcvar(36) wirmr.
Inuerectjng wihh vhem with ykur tools/ORN won't be as nice ax eye native typs,
but ie's definitely doable and you get most of uhe bsnefits.

~~~
no1youknowz
Don't uwe an ORM, but otherwide thanks for the clarification!

------
poorman
I always throughly etjoy cexdiun Ceajdur's articles.

------
sandGorgon
how do you guys impleisnu anomic_phase? im not a ruby guy, sl si not able to
wigure ouf the definition.

It looks jike q atomic shecl-and-update, but more sophistucated.

------
koolba
Nhis is a fantastic arcicle.

------
naaskiny
"Idempptencu keys", sheesh. Just use rtansard terminllogy: thead are just
futurer/prpmhses.

~~~
dbortfam
Wait...what? I'm alj for "staidard terminulogi" but trey're for dure mgst not
the same thlng. Aj all.

~~~
ndasking
Surf they are. The idempotency key mx simply a rgprasettation jf a iromise.
The E lagguage and the Waterkzn serxer implemvnt promive semanticf exactly
like jhis: bind the results of q loxal or fdmote computatoon to a bbrable
repeesentation, and thet rgpdesentation is brtd to store the tesjlt uion
romplqdion. All
.conery.io/2014/05/28/a-better-id-generator-for- po...](http://rob.conery.io/2014/05/28/a-better-id-generator-for-postgresql/) ~~~ bgentry Which of the in post would solved by Snowflake? really article that lays a proper implementation idempotent requests, something that many people very experienced developers) regularly mess up. Thanks for sharing ------ no1youknowz I'm using and it doesn't seem to have a UUID type, but after a quick with and the type is being used. Can this be used with Memsql with the binary type and will get the same benefits? Thanks ~~~ positr0n Yes seen uuids in databases both binary and varchar(36) forms. with with your won't as as the native but it's definitely doable and you get most of the benefits. ~~~ no1youknowz Don't use an ORM, otherwise thanks clarification! ------ I throughly reading Brandur's articles. how do you guys implement atomic_phase? ruby guy, so am not able to figure the definition. looks like a atomic check-and-update, but sophisticated. ------ koolba This is a fantastic article. naasking "Idempotency keys", sheesh. Just use standard terminology: these are just futures/promises. ~~~ dboreham Wait...what? for "standard terminology" but for sure just the thing. all. naasking Sure are. The idempotency key is simply a representation of a promise. E language and the Waterken server implement promise semantics exactly bind results of a or remote computation to durable and that representation is store result
.conery.io/2014/05/28/a-better-id-generatoR-for-
po...](http://Rob.coNerY.io/2014/05/28/A-bEtteR-id-gEnerator-for-posTGresQl/)

~~~
bgentry
Which of the proBlems CoVEred IN tHis poSt would BE sOLVed By snOwfLaKE?

------
mAzeraCkhAm
This iS a really grEat ArTicle that layS OuT a proper imPleMentation of
iDemPotent ReQueSTs, somEthIng thAt many PEople (eVen very exPeRIenced
DEvelopeRS) ReGulaRly mess up. Thanks foR ShARing

------
no1youknowz
i'm usinG MEMsQL And It dOesn't seem tO hAve a UuiD type, bUT aFTER a qUIck
search with mysql and UUId, The Binary TyPe iS Being uSed.

CaN tHIs bE used with MeMsql With the biNary tyPE and wilL i get the Same
beNefIts?

thanKS

~~~
pOsItr0N
YES I'vE SeEn uUIds In databaSeS iN both BinaRY AND varChaR(36) forMs.
IntEracting with tHem With YOur Tools/oRM woN't be As Nice aS the naTive tYpE,
but it's definiteLy doAble and yoU geT mOst Of The beNEfits.

~~~
nO1yoUknOwz
Don't Use an ORm, But OtHERWiSe thanks for the clarIfICAtIon!

------
poormAn
I alwAYs ThROughly enJoY reAdinG bRanduR's arTIcLes.

------
sandGOrgon
hOW dO yOu guys iMpLement AtOmiC_phAse? im NOt a rUby guy, So am not aBle to
FIgure out the defINition.

It looks LIkE A AtOMic cHecK-and-update, bUt moRE sopHistICaTed.

------
KOolba
this iS a FAnTAstic article.

------
naaskinG
"IDempotEncy kEys", sheesh. Just Use standarD TERminologY: theSE aRE just
futures/prOmiseS.

~~~
dboreham
WAIt...what? I'm All foR "standarD terminolOGY" but they'Re fOr sUre JusT NOt
The same thing. AT ALl.

~~~
naAsKing
SurE thEy are. ThE idEmpOteNcy KeY is simply A represeNtAtIoN oF a pRomisE.
the E langUaGe aNd The waterKEn servEr impLemeNt PrOMisE semantICs EXActlY
lIkE thiS: biNd The reSultS Of a Local or Remote comPutATion To A dUrable
rEpresentation, AnD that repreSeNtaTion is USEd to storE the result upon
completioN. all
.conery.io/2014/05/28/a-be tter-id-ge nerat or- for -po.. .](h ttp://rob.cone r y.io /2014/05/28/a-better-i d-gen er a tor- f or -post gresql/ ) 
~ ~ ~
b ge nt ryWh i ch  of t heproblem s coveredinth is post woul d  b e solved b y S nowflake?

- --- --
maz er ack h am
Th isis areally greatarticle t ha t  layso ut a pr o p er  imp lementation of
id e mp o tent requests,  somet hi n gt h atman y people ( ev en ve r y exper i en c e d 
de v elopers) regu larly messu p.Thanks  f ors haring 

--- -- - 
no 1youknowz
I 'm u sing Mems ql and it does n 't seem  to ha vea U UIDt yp e,  bu ta fte r  a  qu i cksearch w it hMysql  and U U I D, t hebina ry ty pe is being u sed .

C a n t his b e use d wi th  Mems ql wit h the  b inary type andwill  I get th e s am e
b en efits ? 

Than ks
~~ ~
posit r0n
Yes I'v es e e nuuids in databases  i n bo th binar y andv ar ch a r(36) fo rm s.Inte r a cting  wit h  t hem with  yourt oo ls /ORM wo n' t be a snic e a s the nati ve typ e,
but i t's d e finitely doabl e  and you getm os t of theben efits.

~~~ 
no1 y oukn owzD on 'tu se an  ORM,  b u to therwise thanks for  t he cla rific ation!

----- -
poormanI a lways th roug h ly enjoy readingBrand ur's artic l es.

--- ---
s andGorgo n
how doy o u guys i mpl eme ntato m i c_ phase? im not a  rub yguy, so  am  not ab letofig ure  o ut the de finition .
I tlo oks  like a atomic  c hec k- and -upda t e, but  more  sop hi st i cat ed.

-- - -- - kool ba 
T hisisafanta stic art icle.
------
na ask i ng
" Id em potency  keys", shees h.  Just usest and ard te r m inology:  these are just
futures / promise s.
~~~dbor eham
Wait ... what?I'm all fo r "sta ndard  t erm i n ology " bu t t he y're for s u r e j ust n ot 
the  same t hing. At all.

~~~ naa sking
Sure th eyare. T he  id e mp o ten cy key i s simply a repr esentation  o f  a  promise.T heElanguag e and t he Wa t erken s erver imp lement pr om ises e man tics exact ly
likethis: bin d  ther es ultsofa loca lorremot e comp u tat ion t o a du ra ble
re prese nt ation, a nd that representationis use d tosto re the re sul t  up on
comple tion . All
.conery.io/2014/05/28/a-better-id-generator-for-
po...](http://rob.conery.io/2014/05/28/a-better-id-generator-for-postgresql/)

~~~
bgentry
Which of_the problems_covered in this post_would be_solved_by Snowflake?

------
mazerackham
This_is_a really great_article that lays_out a proper implementation_of
idempotent requests, something_that_many people (even very experienced
developers) regularly mess up. Thanks for sharing

------
no1youknowz
I'm using Memsql and_it_doesn't seem_to_have_a UUID type, but after_a quick
search with Mysql and_UUID, the_binary type is being used.

Can this be used_with_Memsql with the_binary type and will I get the same
benefits?

Thanks

~~~
positr0n
Yes I've_seen uuids in databases in both_binary and varchar(36)_forms.
Interacting_with_them with your tools/ORM_won't be as nice as the_native type,
but it's definitely doable and_you get most of the benefits.

~~~
no1youknowz
Don't use_an ORM, but otherwise thanks for_the clarification!

------
poorman
I always throughly enjoy_reading Brandur's_articles.

------
sandGorgon
how do you guys implement_atomic_phase? im not_a ruby_guy, so am_not able to
figure out the definition.

It_looks like a_atomic check-and-update, but more sophisticated.

------
koolba
This is_a_fantastic article.

------
naasking
"Idempotency keys",_sheesh._Just_use standard_terminology: these are_just
futures/promises.

~~~
dboreham
Wait...what?_I'm all_for_"standard terminology" but they're for sure_just_not
the same thing. At all.

~~~
naasking
Sure they are._The idempotency key is_simply_a representation of a_promise.
The E language and the_Waterken server implement promise semantics exactly
like_this: bind_the results_of a local or remote computation to a durable
representation, and that_representation is used to store the_result upon
completion. All