<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div markdown-here-wrapper-content-modified="true" style=""
class="markdown-here-wrapper" data-md-url="null">
<p style="margin: 1.2em 0px ! important;">Everyone,</p>
<p style="margin: 1.2em 0px ! important;">I just merged
3113-qsequence-serial, which uses a PostgreSQL sequence to
efficiently allocate monotonically increasing qsequence values
to new job tasks.</p>
<p style="margin: 1.2em 0px ! important;">Because sequences are
specific to PostgreSQL, this required changing the way Rails
dumps the API server’s database schema. <code style="font-size:
0.85em; font-family:
Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em;
padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid
rgb(234, 234, 234); background-color: rgb(248, 248, 248);
border-radius: 3px 3px 3px 3px; display: inline;">config/application.rb</code>
now specifies <code style="font-size: 0.85em; font-family:
Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em;
padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid
rgb(234, 234, 234); background-color: rgb(248, 248, 248);
border-radius: 3px 3px 3px 3px; display: inline;">config.active_record.schema_format
= :sql</code>. The schema has moved from <code
style="font-size: 0.85em; font-family:
Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em;
padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid
rgb(234, 234, 234); background-color: rgb(248, 248, 248);
border-radius: 3px 3px 3px 3px; display: inline;">db/schema.rb</code>
to <code style="font-size: 0.85em; font-family:
Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em;
padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid
rgb(234, 234, 234); background-color: rgb(248, 248, 248);
border-radius: 3px 3px 3px 3px; display: inline;">db/structure.sql</code>,
which is a more literal SQL dump. You still write database
migrations the same way, and when you do, you'll push changes to
this file just like we've done with <code style="font-size:
0.85em; font-family:
Consolas,Inconsolata,Courier,monospace;margin: 0px 0.15em;
padding: 0px 0.3em; white-space: pre-wrap; border: 1px solid
rgb(234, 234, 234); background-color: rgb(248, 248, 248);
border-radius: 3px 3px 3px 3px; display: inline;">db/schema.rb</code>
in the past.<br>
</p>
<p style="margin: 1.2em 0px ! important;">Let me know if you have
any questions about this.</p>
<p style="margin: 1.2em 0px ! important;">Thanks,</p>
<div
title="MDH:RXZlcnlvbmUsPGJyPjxicj5JIGp1c3QgbWVyZ2VkIDMxMTMtcXNlcXVlbmNlLXNlcmlhbCwgd2hpY2ggdXNlcyBhIFBvc3RncmVTUUwgc2VxdWVuY2UgdG8gZWZmaWNpZW50bHkgYWxsb2NhdGUgbW9u
b3RvbmljYWxseSBpbmNyZWFzaW5nIHFzZXF1ZW5jZSB2YWx1ZXMgdG8gbmV3IGpvYiB0YXNrcy48
YnI+PGJyPkJlY2F1c2Ugc2VxdWVuY2VzIGFyZSBQb3N0Z3JlU1FMLXNwZWNpZmljLCB0aGlzIHJl
cXVpcmVzIGNoYW5naW5nIHRoZSB3YXkgUmFpbHMgZHVtcHMgdGhlIEFQSSBzZXJ2ZXIncyBkYXRh
YmFzZSBzY2hlbWEuwqAgYGNvbmZpZy9hcHBsaWNhdGlvbi5yYmAgbm93IHNwZWNpZmllcyBgY29u
ZmlnLmFjdGl2ZV9yZWNvcmQuc2NoZW1hX2Zvcm1hdCA9IDpzcWxgLsKgIFRoZSBzY2hlbWEgaGFz
IG1vdmVkIGZyb20gYGRiL3NjaGVtYS5yYmAgdG8gYGRiL3N0cnVjdHVyZS5zcWxgLCB3aGljaCBp
cyBhIG1vcmUgbGl0ZXJhbCBTUUwgZHVtcC48YnI+PGJyPkxldCBtZSBrbm93IGlmIHlvdSBoYXZl
IGFueSBxdWVzdGlvbnMgYWJvdXQgdGhpcy48YnI+PGJyPlRoYW5rcyw8YnI+PGJyPg=="
style="height:0;font-size:0em;padding:0;margin:0;"></div>
</div>
<div class="moz-signature markdown-here-signature">-- <br>
Brett Smith</div>
</body>
</html>