Relational database support in monday code

monday code currently has a key-value store (monday storage) but no support for a more traditional database.

If you’re interested in this, please vote for it and add a comment explaining what gaps a database would solve for your app! If you require a specific kind of DB, please note that too.

Posting this on behalf of our community – I know there is demand for such a feature but no formal request exists yet.

CC @OmerK

Hi!

I wanted to share some feedback on using a “traditional database” in one of our apps. We decided to implement a relational database and chose PostgreSQL hosted on Vercel, since we use Vercel for hosting and deploying our Next.js app. Vercel uses Neon behind the scenes. Initially, we found it quite straightforward to set up. It provides a URL for the connection string, along with a username and password, allowing you to run your database in a serverless environment as if it were on your own server.

However, there are some things to be cautious about. The first issue we encountered in production was connectivity problems. By default, the database scales down after a period of inactivity to save money. In our case, we only needed the database to be active every hour, so it could be turned off the rest of the time. But sometimes, starting the database can take longer than expected (cold starts), leading to connectivity issues. Therefore, it’s important to implement a robust retry mechanism. Despite having one in place, we found that cold starts still caused problems, and the retry mechanism wasn’t sufficient. Ultimately, we decided to keep the database running continuously. While this could increase costs, the support team helped us reduce the resources allocated to the database, making the billing affordable and even slightly cheaper than our previous setup.

In summary, our key takeaways from using a serverless database are learning how to manage connectivity issues and adjusting resources to match our actual needs :slight_smile:

@MiguelAngel
what you are doing with a Relational Db that you can’t do with a key-value store?
just curious.

Hi @Atul!
In our case, we’re storing data that, while not involving complex relationships, benefits from being related and structured. Additionally, our queries aren’t too complex and are easily managed in a relational database. :wink:

1 Like