Database race condition prevention

A non-transitory computer-readable storage medium, the computer-readable storage medium including instructions that when executed by a computer, cause the computer to perform operations comprising:

• setting an orderable entry for a product and an in-stock entry for the product in a database;
• receiving an online order for the product;
• responsive to determining a lock of the database is in progress, suspending the online order;
• updating a quantity of the orderable entry while the lock of the database is in progress;
• removing the lock;
• and
• responsive to determining that the lock is removed:
• responsive to determining that the quantity of the orderable entry is greater than zero:
• decrementing the quantity of the orderable entry by an amount indicated in the online order, and
• determining whether the quantity of the in-stock entry is greater than zero;
• and
• responsive to determining that the quantity of the orderable entry is greater than zero and that the quantity of the in-stock entry is greater than zero, decrementing the quantity of the in-stock entry by the amount indicated in the online order.

A database system, comprising:

• one or more hardware processors;
• and
• a memory storing instructions that, when executed by at least one processor among the processors, cause the system to perform operations comprising, at least:
• setting an orderable entry for a product and an in-stock entry for the product in a database;
• receiving an online order for the product;
• responsive to determining a lock of the database is in progress, suspending the online order;
• updating a quantity of the orderable entry while the lock of the database is in progress;
• removing the lock;
• and
• responsive to determining that the lock is removed:
• responsive to determining that the quantity of the orderable entry is greater than zero:
• decrementing the quantity of the orderable entry by an amount indicated in the online order, and
• determining whether the quantity of the in-stock entry is greater than zero;
• and
• responsive to determining that the quantity of the orderable entry is greater than zero and that the quantity of the in-stock entry is greater than zero, decrementing the quantity of the in-stock entry by the amount indicated in the online order.