Thread by @CookiesNotFound

What are some database engines that works great with serverless architecture?

#database #CodeNewbie #Serverless #javascript

Note to Self: MongoDB can be used with serverless functions by caching the initial connection.
database engines were designed much before the serverless architecture was a thing.

a connection to the database is always persistent. meaning, it lasts for a really long time.

also, there is a limit(imposed by DBaaS provider) on how many connections a database can have at any given timestamp.

a lambda function is invoked every time a client(generally, browsers) creates a connection. this means a new connection to the database as well.

this, in turn, would reach the connection quota really soon.

having a cache connection to database helps up to some extent. simply store an existing connection in a variable..and reuse it whenever you need to connect to the database.

a better way is: having a proxy DB server sitting in front of the actual database server.
this way, one persistent connection would be made to the database(by that proxy)..and serverless functions can connect to the proxy server as and when needed.

you can also abstract all database operations into a separate server and let the
serverless functions communicate with that through a RESTful API :)

#serverless #aws #Lambda