Implementing State Machines in PostgreSQL (2017)

Comments (1)

michelpp · 2h ago

While this is a good approach to implements state machines, the transition function is hardwired to one transition graph. Another approach is to generalize the state and transition graph into a table, and group those transitions by a machine id, as shown here:

https://github.com/michelp/pgfsm

Now many machines (sub-graphs of state transitions) can be defined in general, and the transition checking function checks the validity of the next state based on the table, instead of static rules in a function.

Void: Open-source Cursor alternative (github.com)

A flat pricing subscription for Claude Code (support.anthropic.com)

Fui: C library for interacting with the framebuffer in a TTY context (github.com)

Reservoir Sampling (samwho.dev)

From: Steve Jobs. "Great idea, thank you." (blog.hayman.net)

Notes on rolling out Cursor and Claude Code (ghiculescu.substack.com)

Progress toward fusion energy gain as measured against the Lawson criteria (fusionenergybase.com)

Stability by Design (potetm.com)

When Abandoned Mines Collapse (practical.engineering)

Show HN: Using eBPF to see through encryption without a proxy (github.com)

Newsreels from the UCLA Film and Television Archive (newsreels.net)

Show HN: Req Update Check (github.com)

Podfox: First Container-Aware Browser (val.packett.cool)

How to start a school with your friends (prigoose.substack.com)

First American pope elected and will be known as Pope Leo XIV (cnn.com)

Using NASA’s SMAP satellite to detect L-band interference (radioandnukes.substack.com)

Mathematical Problem Solving (cip.ifi.lmu.de)

Implementing State Machines in PostgreSQL (2017) (felixge.de)

Phoenician culture spread mainly through cultural exchange (mpg.de)

Ciro (YC S22) is hiring a software engineer to build AI agents for sales (ycombinator.com)

Static as a Server (overreacted.io)

The Rise and Fall of the Visual Telegraph (2017) (parisianfields.com)

Block Diffusion: Interpolating Autoregressive and Diffusion Language Models (m-arriola.com)

How the US Built 5k Ships in WWII (construction-physics.com)

The second birth of JMW Turner (newstatesman.com)

A Brief History of Cursor's Tab-Completion (coplay.dev)

Shape and topology morphing of closed surfaces integrating origami and kirigami (science.org)

Prepare your apps for Google Play's 16 KB page size compatibility requirement (android-developers.googleblog.com)

How Obama’s BlackBerry got secured (2013) (electrospaces.net)

Egyptologist uncovers hidden messages on Paris’s iconic obelisk (news.artnet.com)

Ask HN: What are good high-information density UIs (screenshots, apps, sites)?

AI focused on brain regions recreates what you're looking at (2024) (newscientist.com)

Why do LLMs have emergent properties? (johndcook.com)

Using Coalton to implement a quantum compiler (2022) (coalton-lang.github.io)

My stackoverflow question was closed so here's a blog post about CoreWCF (richardcocks.github.io)

How to harden GitHub Actions (wiz.io)

My new deadline: 20 years to give away virtually all my wealth (gatesnotes.com)

Show HN: Kit – open-source toolkit for building AI devtools (kit.cased.com)

Implement Your Language Twice (futhark-lang.org)

Google to back three new nuclear projects (esgtoday.com)

Bento Gets a Makeover (warpstreamlabs.github.io)

Mass spectrometry method identifies pathogens within minutes instead of days (phys.org)

IPinfo started offering free unlimited country-level geolocation and ASN details (ipinfo.io)

DNA is maybe 60-750MB of data (dynomight.net)

Will protein design tools solve the snake antivenom shortage? (owlposting.com)

Passing Messages (thedailywtf.com)

2.5D Rendering on PlayDate (ligeiagames.com)

Show HN: Translate between dialects and share SQL queries on the browser (sqlscope.netlify.app)

Hypermode Model Router Preview – OpenRouter Alternative (hypermode.com)

Heat stress mitigation by trees and shelters at bus stops (sciencedirect.com)

Implementing State Machines in PostgreSQL (2017)

Comments (1)