search

dwyl / learn-postgresql

🐘 Learn how to use PostgreSQL and Structured Query Language (SQL) to store and query your relational data. 🔍
211 stars 23 forks source link

SurrealDB trial Livebook #98

Open ndrean opened 1 year ago

ndrean commented 1 year ago

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 commented 1 year ago

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

ndrean commented 1 year ago

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