%20by%20%E2%80%9EZoish%E2%80%9D%2C%20licensed%20under%20%E2%80%9ECC0%201.0%E2%80%9D%20(https%3A%2F%2Fcreativecommons.org%2Fpublicdomain%2Fzero%2F1.0%2F)%3C%2Fdc%3Arights%3E%3C%2Frdf%3ADescription%3E%3C%2Frdf%3ARDF%3E%3C%2Fmetadata%3E%3Cmask%20id%3D%22viewboxMask%22%3E%3Crect%20width%3D%22560%22%20height%3D%22560%22%20rx%3D%22280%22%20ry%3D%22280%22%20x%3D%220%22%20y%3D%220%22%20fill%3D%22%23fff%22%20%2F%3E%3C%2Fmask%3E%3Cg%20mask%3D%22url(%23viewboxMask)%22%3E%3Crect%20fill%3D%22%23b6e3f4%22%20width%3D%22560%22%20height%3D%22560%22%20x%3D%220%22%20y%3D%220%22%20%2F%3E%3Cg%20transform%3D%22translate(136%20328)%22%3E%3Cpath%20d%3D%22M83%2085.8c-2.4%2017.7%2016.1%2032.5%2032.4%2026-4.3-15.8-20.8-17.4-32.4-26Z%22%20fill%3D%22%23fff%22%2F%3E%3Cpath%20fill-rule%3D%22evenodd%22%20clip-rule%3D%22evenodd%22%20d%3D%22M72.3%20102.8c12.4%2023.4%2036%2029.9%2061.7%2016.3%2010.5-6.4%2014.9-16.6%2018.7-26.1a27.3%2027.3%200%200%200-1.5-24.2C137.2%2043%20120%2042.3%2099.3%2046.2c-22.5%204.3-37.8%2036.4-27%2056.6Zm43.1%209c-16.3%206.5-34.8-8.3-32.4-26%203.7%202.7%207.8%204.7%2011.9%206.7%208.9%204.3%2017.6%208.5%2020.5%2019.3Z%22%20fill%3D%22%23000%22%2F%3E%3Cpath%20d%3D%22M67%2037c8.2%203.7%207.7%209.3%204.2%2015-2.6%204.5-6.5%207.2-11.7%204-4.8-3-3.7-7.1-1-11%202.2-3%203-7.3%208.5-8Z%22%20fill%3D%22%23000%22%2F%3E%3C%2Fg%3E%3Cg%20transform%3D%22translate(246%20125)%22%3E%3Cpath%20d%3D%22M74.2%20188c5.5-3.8%209.7-9.4%2011.8-15.9a23%2023%200%200%200-4.4-22.8c-5.3-6-12.4-3.7-19-1.7-4.2%201.3-9.5%205.3-12.2-1.2-2.4-5.6%201.8-10%206-12.7a28%2028%200%200%201%2026.8-2.8c11.9%204.7%2016.4%2014.5%2018.1%2025.8%206.7%2044.3-31%2054.4-60.7%2052.5-2.1-.2-4.2-1-6-2.2-3.3-2.2-8.6-3.8-7.1-9.1%201.6-6%206.7-5%2011.6-4%2012%202.3%2023.5.2%2035-5.8Z%22%20fill%3D%22%23000%22%2F%3E%3C%2Fg%3E%3Cg%20transform%3D%22translate(-45%20137)%22%3E%3Cpath%20d%3D%22M419.6%20111c-4.2-9.5-9.9-15.2-19.8-15.7-6-.3-7-5.1-8.9-9.8%202-1.5%203.5-3.7%205.3-3.8%2021.1-1.7%2042.4-1.8%2063.5-.1%206%20.4%209.3%208%203.2%2010.4-10%204-12.5%2013.2-18.5%2019.8-8.2%209-15.2%209.1-24.8-.8ZM228.6%2081.4c12.2.7%2023.1%201%2034%202%203.6.3%208%201.8%208%206.7%200%205.6-4.6%205.2-8.3%205.1-6.3%200-9.7%202.7-12.5%208.6-3.4%207.4-6.9%2015.3-18%2014.8-10.5-.5-15.1-7.2-18.1-15.2-2.2-5.7-5-8.4-11-8.2-3.4.1-7.1-.2-7.5-4.9-.4-5%203-6%207-7.2a67.9%2067.9%200%200%201%2026.4-1.7Z%22%20fill%3D%22%23000%22%2F%3E%3C%2Fg%3E%3Cg%20transform%3D%22translate(-45%20137)%22%3E%3C%2Fg%3E%3Cg%20transform%3D%22translate(119%20114)%22%3E%3Cpath%20d%3D%22M30.3%2032.1C58%2010%2089.8%2013.1%20121%2014.1c5.7%200%2012.2%201.3%2014.3%208.3%202.1%207.7-4.6%209.9-8.8%2013.8a44.7%2044.7%200%200%201-52.2%208.6%2037.9%2037.9%200%200%200-31.9%201.6c-2%201-3.8%201.9-5.8%202.6-6.3%202.5-14.3%206-18.6-.4-4.4-6.7%205.6-9%208.3-13.7.6-1%202-1.6%203.9-2.8ZM294.4%2023.8c7.7%204.3%2014.5%2010%2020%2017%202.5%203%205%206.3%203%2010.2-2.4%204.3-6.7%202.7-10.4%202.2-12.5-1.5-23.7-9.2-37-7.2-5%20.8-9.9.7-15%202.5-13%204.7-31-6.4-33-19.8-1-5.4%201-8.5%206.8-10%2022.2-5.7%2044-9%2065.6%205.1Z%22%20fill%3D%22%23000%22%2F%3E%3C%2Fg%3E%3C%2Fg%3E%3C%2Fsvg%3E)
James Wright@jwright· Jul 3
Right — the enqueue is an optimisation, the row is the guarantee. If the queue insert fails, the row is still there to replay from.
Loading
James Wright
@jwright
Distributed systems, mostly the boring reliable kind.
2Kreyts6Followers9Following7Voice
James Wright@jwright· Jun 17
The transactional outbox is the least glamorous pattern I know and the one that’s saved me the most pain. Write your state change and your “I need to tell someone” row in the same transaction, or accept that they’ll drift.