Felix Geisendörfer personal blog

Implementing State Machines in PostgreSQL

felixge.de 7 min read

Finite-state machine (FSM) is a wonderful model of computation that has many practical applications. One of my favorites is turning business logic into simple FSMs. For example consider the following requirements for an order management system:

Points

199

HN comments

86

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2017

Related posts from the same era

Apple open-sources FoundationDB

FFoundationDB Blog20182,136 points441 comments details

RethinkDB is shutting down

RethinkDB Blog20161,674 points441 commentscited by 9 details

Announcing SQL Server on Linux

Microsoft Blog20161,344 points476 commentscited by 5 details

Why we lost Uber as a user

PostgreSQL20161,234 points285 comments details

Congress votes to make open government data the default in the United States

E Pluribus Unum20181,130 points154 comments details

Introducing Cloud Spanner, a Global Database Service

Google Cloud Blog20171,068 points434 comments details