Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No-code advanced db storage = smaller db - binary #141

Open
joshstevens19 opened this issue Jan 1, 2025 · 2 comments
Open

No-code advanced db storage = smaller db - binary #141

joshstevens19 opened this issue Jan 1, 2025 · 2 comments

Comments

@joshstevens19
Copy link
Owner

joshstevens19 commented Jan 1, 2025

rindexer at the moment on the no-code route stores things in pure hex strings so its easy to see in reality it could half the size of most things by storing a lot in bytes we could bring in a new field in the yaml under postgres called "binary_storage: true" and if enabled it store everything as binary when it can

note rust projects allow you to store things in bytes easily with the EthereumSqlWrapperTypes

@joshstevens19 joshstevens19 changed the title Advanced db storage = smaller db - binary No-code advanced db storage = smaller db - binary Jan 1, 2025
@nuts-rice
Copy link

Hi i've started a draft pr that addresses this at #153
right now, as a wip, it's just the config details

@joshstevens19
Copy link
Owner Author

#153 (comment)

this has instructions in how you would do it PR welcome

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants