Repository navigation
Support SQLite in Cartesi node #71
Description
📚 Context
To run the node, we need to start a PostgreSQL database. This is great for deploying the node in the cloud, but cumbersome when running it locally. It increases the startup time and the processing requirement to run the node.
✔️ Solution
Add support for SQLite as the rollups database. The indexer should store the data in SQLite, and the GraphQL server should read from it.
This should be a CLI/ENV option; the Postgres option should also exist.
📈 Subtasks
- Design solution and write the next subtasks.
Activity
[-]Support SQLite in Carteis node[/-][+]Support SQLite in Cartesi node[/+]endersonmaia commentedon Jun 6, 2023
As a suggestion, we could parse a
DATABASE_URLand detect it by protocol.<protocol>://[<user>][:password>@<host>[:<port>]/[<database>]and support:
postgresql://...sqlite:///path/to/file.sqlite