How Drizzle Leverages Turso for Its Products and Services

My name is Aleksandr Blokh, co-founder of Drizzle.

Drizzle is a lightweight, type-safe TypeScript ORM for SQL databases that offers a SQL-like query builder, schema management and support for multiple databases while prioritizing performance and developer productivity.

Drizzle ORM had support for Turso driver since day one, we are actively supporting their users and Turso was the first company to sponsor us! We have a rule of dogfooding everything we build and we have a variety of commercial and non-commercial products we build.

For all of our data-centric apps we use Turso in production.

Turso databases power our Drizzle Studio themes website, our little fun snake game and our new one dollar per month web analytics project, Onedollarstats, which is now in open alpha. We have big plans for it. We want to open source it and build an embeddable version.

#Why we chose Turso for Drizzle's products

Modern cloud solution market is extremely fragmented, our rule of thumb is to keep it as simple as possible with the least amount of moving parts.

Turso meets all of our criterias, first of all it’s based on SQLite, simplest SQL dialect, while powered by extended schema changes capabilities to help us iterate faster and it has native vector support(link here). But the biggest deal for the buck is their pricing model.

Turso’s pricing model is exceptionally transparent and the simplest on the market. There’s no ¼ or ⅜ of a CPU, I just pay for the max performance available, all I care is about writes, reads and storage, which is amazing and unprecedented nowadays.

We pay a flat price, we have read replicas, branches, point in time recovery, multi-region support, database queries inspection dashboard, 10,000 databases, 100 billion row reads and this thing scales. They’ve had 2.5 Trillion row reads in September. Chama!

#How we use Turso

Our Drizzle Studio theming system is backed by Turso for storage and retrieval of theme data. This integration allows us to provide a seamless and performant experience for users customizing their Drizzle Studio environment. The efficiency of Turso in handling read and write operations has been particularly beneficial for this.

We also run our internal analytical backoffice web service and our fun little snake game on Turso. We use multi region replication to keep latency low and build in service redundancy in case a particular region is experiencing any issues.

And we're currently using Turso’s (multitenancy) for an open alpha of our upcoming web analytics service, which ensures each instance has its own private data store and greatly simplifies permissioning.

#The impact of Turso on our development process

Adopting Turso has affected our development workflow in several significant ways:

By reducing the complexity of managing database infrastructure, Turso has allowed our team to focus more on feature development. We spend less time worrying about database optimization and more time improving our products' functionality. This shift has led to faster development cycles and more rapid iteration on our projects.

The transparent pricing model of Turso has made it easier for us to manage and predict database costs as we scale. This predictability is invaluable for planning and budgeting, especially as we launch new services and grow our user base. It allows us to make informed decisions about resource allocation without fear of unexpected cost spikes.

Turso's compatibility with SQLite and various open-source extensions provides flexibility in our tech stack. This compatibility means we can leverage a wide range of tools and libraries, adapting our approach as needed without being locked into a single ecosystem. It also facilitates easier local development and testing, as we can use SQLite locally and Turso in production with minimal changes to our code.

#Future plans

We aim to open-source our web analytics project, making it an accessible and embeddable resource for developers. We're also exploring the development of additional services that can be built efficiently on Turso's infrastructure.

As both Drizzle and Turso continue to evolve, we'll be looking for new ways to integrate Turso's capabilities into our products and services. This ongoing process of exploration and integration helps us stay at the forefront of database technology and continually improve the experience for our users.

#Conclusion

Turso has become an integral part of our tech stack, providing the performance and ease of use we need for our products. Its impact on our development process and product capabilities has been significant, and we're excited about the possibilities it opens up for future projects.

We also believe that Drizzle is the best ORM for Turso users and encourage you to explore for yourself. For more information and updates, you can check our GitHub repository or follow us on Twitter. Our community Discord is also available for developer support and discussions. As we continue to innovate and build new tools, we're grateful to have Turso as a reliable foundation for our database needs.