TsunamiDeal-SingleStoreDB

Overview

TsunamiDeal is a minimalistic and a backend-centric e-commerce application that provides all the required fundamental features such as:

• buying a product
• selling
• cancelling an order
• returning an order
• a profile page to add amount to one's account There are some additional ones such as voice chat and fuzzy search.

The database was originally implemented in PostgreSQL, which has now been migrated to SingleStore. Some of the important features of the database design is that it uses transactions. All the transactions use repeatable read isolation level with complex combinations of commits and rollbacks to savepoints. SingleStore has conveniently managed to execute these transactions.
Other features include the support of enums in the schema.

Migration Process and Outcomes

Creating a workspace and a database and connecting to the client application was effortless. There were a couple of roadblocks, but the detailed documentation proved to be helpful.

Observations

SingleStoreDB has a lot of advantages over PostgreSQL:

• First, it provides a very aesthetic UI and the platform is intuitive.
• The integration of the SQL editor is very convenient.
• The database queries are now visibly faster than the ones using PostgreSQL.
• The overall migration was easy enough.
• The unique combination of in-memory row-store and in-disk column-store tables.

Built With

• mysql
• node.js
• react.js
• singlestore