If your application needs persistent data, you are going to need a database. Easier said than done because managing a database can be a challenge. Not only do you need to set up, maintain, scale, and patch databases, but also you need to create strong backup policies, ensure sharding and replications. Long story short, managing a database is time-consuming and requires a dedicated and skilled team, which is why people opt for managed databases, sometimes referred to as DBaaS or Database as a Service.

So far in this series, we have been exploring the capabilities of SQLite for classic HTTP request/response type usage. In this post, we will push the boundary further by also using SQLite as a Pub/Sub adapter for ActionCable, i.e., WebSockets. This is no small feat: WebSocket adapters need to handle thousands of concurrent connections performantly.

Have you ever found yourself struggling to identify relevant selectors while writing automation test steps? Have you considered an alternative approach to crafting readable test scenarios without relying on tools like Cucumber, ensuring accessibility to both technical and non-technical stakeholders? If you’ve pondered these questions, this blog post is tailor-made for you.