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.

Sign up for GitHub

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

Jump to bottom

SurrealDB trial Livebook #98

Open
ndrean opened this issue Feb 20, 2023 · 2 comments
Open

SurrealDB trial Livebook #98

ndrean opened this issue Feb 20, 2023 · 2 comments
Labels
discuss Share your constructive thoughts on how to make progress with this issue documentation Improvements or additions to documentation enhancement New feature or enhancement of existing functionality research Research required; be specific T2h Time Estimate 2 Hours technical A technical issue that requires understanding of the code, infrastructure or dependencies

Comments

@ndrean
Copy link

ndrean commented Feb 20, 2023 •
edited

I was looking at the Nosql SurrealDB. Can run in-memory, seem light, and perhaps cheaper than Redis (but probably less performant), and can synchronize easily (?) with a remote backend. The DSL is SurQL, almost SQL, and the notion of joins disappears. Handy graphs. Don't know if SQL injection is a problem. I decided to give it a try. Still needs more documentation though as I couldn't test web sockets.

[UPDATED]

Run in Livebook

Screenshot 2023-02-20 at 23 09 55
@ndrean ndrean added the documentation Improvements or additions to documentation label Feb 20, 2023
@nelsonic nelsonic added enhancement New feature or enhancement of existing functionality technical A technical issue that requires understanding of the code, infrastructure or dependencies discuss Share your constructive thoughts on how to make progress with this issue T2h Time Estimate 2 Hours research Research required; be specific labels Feb 21, 2023
@ndrean
Copy link
Author

ndrean commented Feb 21, 2023 •
edited

UPDATED to download a CSV file and serialize it into a SurrealDB table. Comparison with SQLite.

@ndrean
Copy link
Author

ndrean commented Feb 23, 2023

I updated some metrics. Quite a performance gap between SurrealDB and SQLite, in favour of SQLite.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
discuss Share your constructive thoughts on how to make progress with this issue documentation Improvements or additions to documentation enhancement New feature or enhancement of existing functionality research Research required; be specific T2h Time Estimate 2 Hours technical A technical issue that requires understanding of the code, infrastructure or dependencies
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@nelsonic @ndrean