DuneSQL-TheGreatMigration
DuneSQL is Dune's future, and will soon be the sole query engine. Here's what this means for you, and how we'll tackle the migration together.
News•April 20, 2023•2 min read
Alsie L.Content Marketing Manager at Dune
A few weeks ago, DuneSQL became the default query engine on Dune.com.
We’ve seen impressive early adoption: 85% of all newly created queries are on DuneSQL and 30% of all executions are on DuneSQL. You can read all about DuneSQL in the blogpost from our CTO.
DuneSQL is Dune’s future. Therefore, we will be progressively sunsetting both SparkSQL and Ethereum V1 (Postgres) to make DuneSQL the only query engine available on Dune.
Both SparkSQL and our old Postgres systems are not optimal for querying crypto data. Sunsetting these systems is an inconvenient but necessary step to make Dune the best platform to query crypto data.
A Smooth transition to DuneSQL
We understand that this transition might be challenging, especially if you've previously migrated from V1 to SparkSQL. We empathize with the inconvenience this migration may cause and want to assure you that this is an essential step towards simplifying the user experience on Dune and focusing our engineering resources on a single, powerful query engine.
To smoothen the transition to DuneSQL we are investing heavily in migration support to make the process as seamless as possible.
We are focusing our migration efforts on:
- Supporting migration efforts with powerful features
- Continuously improving DuneSQL stability and performance
- Transitioning Spellbook from SparkSQL to DuneSQL
- We will progressively sunset SparkSQL and PostgreSQL by July 15, 2023.
- To aid you in the migration, we have built and will improve a query migration tool enabled by LLMs.
- We are still optimizing our data storage and query execution to prevent query timeouts.
- Scheduling queries and materialized views will enable you to build data pipelines within Dune to prevent query timeouts.
- Spellbook stays on SparkSQL for the time being.
- A new Version of Spellbook that works with DuneSQL is in Development. Dune will take care of the migration.
Let's do it, together
We appreciate your continued trust in us, and we hope you are as excited as us about the possibilities of DuneSQL.
Please accept our sincere apologies for the inconvenience caused by the migration. Rest assured this is the final migration, DuneSQL is our definitive answer as to how we can build the best crypto data platform!
Thank you for your understanding and support. Don’t hesitate to reach out to us via [email protected] for any questions or concerns.
The data must flow!The data must flow!The data must flow!
