Hey just wanted to say thank you for this amazing DB keep up the good work.

@@alandto3996 Thank you very much for the kind words. We certainly will!

Thank you very much! ❤️

Looks like a brilliant project. Would love to see key-values and websocket auth pubsub soon! 💛

@@fire17102 WebSocket auth already here Tami. Live queries and pub-sub coming very soon!

Is it unique? Looks like OrientDB, which has been around for a decade.

Thanks Wolveric, glad it piqued your interest!

OrientDB is written in Java - I'm sure it's fast, but there's kind of an upper bound to how fast it can be...

Me too

Wow, I hadn't noticed that!

keen eye

❤

In F# you use this operator

It's similar to the syntax of Cypher, the query language of Neo4j

Arrows for marking function output types and for dereferencing a pointer to a compound object both seem appropriate to me. Just my 0.002¢

I agree! Really the perfect operator for working with graphs

Thank you very much @theherk! We have a lot planned on the roadmap!

Agree!

I agree! It definitely has massive potential.

Thanks for the kind words Mike, glad you found it valuable!!

nice, thanks for watching!

Thanks and thanks for watching!

I agree! Choosing a database paradigm is really challenging, the prospect of not having to make that choice upfront will be so liberating...

Thanks, I practiced a bit before recording the video 🙃

Thanks Thomas, let us know how it goes!

I agree Flying Squirrel! To your point - In addition to being feature packed, it has incredible branding which I feel like matters more than most technical people would like to admit

Agree, it seems like the team is aiming to do just that!

Glad you found it valuable, thanks for watching!

agree!

Thank you very much David

Thank you David!

Thanks for watching!

I agree that what they've done is really impressive! Seems like they have a ton of momentum already, hopefully it continues

Thank you very much for the kind words Onizuka ❤️

It's worth giving a try for sure!

Thanks Justine, very happy to have you onboard!

100% agree, can't wait to see how things pan out. I actually hadn't heard of Jepsen, I'm glad you put this on my radar!

Thanks Dabbo will give this a try!

I agree, the SurrealDB team is moving mountains!

Nice, glad you liked it! "Therapeutic" is something I'm very happy to have achieved!

Thanks for watching!

Thank you very much @Elf!

I agree!

Thanks for watching Scott!

It's worth giving a try!

Thanks Singh! Fantastic that you are going to start creating! Please let me know if there's anything I can do to help.

@@codetothemoon Thanks for replying. Will definitely do 😊.

@@leeroyjenkins0 Obsidian MD is not open source, so I don't know what it's written in and note-taking being called a fad is funny can't tell if you're trolling or legit.

Funny story about why I used Obsidian for this - there isn't any readily available SurrealDB SQL syntax highlighting, so I had to hack Obsidian to use the same custom JavaScript syntax highlighting that the SurrealDB website uses 👍

Nice, let us know how it goes!

Glad it piqued your interest as well!

Same, it seems pretty disruptive if the vision fully materializes!

@@codetothemoon yes, especially for small projects it's like having a firebase in a box, at least for me having something like this, if the security layers and event emission works properly, completely removes the need for a server between the client and the DB. And the fact that you can embed js functions into fields makes it even possible to have some business logic too (with limitations I guess) Definitively not the way I would use for a well structured long-term project, but for everything else I don't know... on paper it kinda fits perfectly

I think that's possible - it's a fantastic language! Though I do suspect that there will be a higher level language with things like autoboxing but that leverage Rust idioms like borrow checking. If such a language comes along (maybe its Mojo, maybe nim) it may take a share of the pie...

@codetothemoon Still, Rust is a low level so people will learn Rust instead to do whatever they want and have a good future job as a low level developer.

thank you!

Thanks for watching Tobias!

Thank you very much Ratstail91 ❤️🙌

I think "bonkers good" is a fitting description!

It's true! 🔥

Thank you Zaha! Join the Discord or GitHub if you have any questions - surrealdb.com/community

Yeah I think it's worth a look!

thanks, yeah I think SurrealDB is definitely worth keeping an eye on!

lol thanks! 🚀

Nice, yeah definitely something to explore but probably not ready for production yet. Also, I see you are a fellow Babylon 5 fan!

Good to know, thanks

Thank you Ismaj. We are working on our own key-value store which will bring some additional benefits to SurrealDB in due course.

@@SurrealDB ​Do you think it’s more effective to build your own storage engine right now or have a pluggable architecture? I ask because there’s several features that I think would be great if users had a choice and they seem complex to implement in that way out of the box, so if users can choose the right storage engine for their use-case, it would probably be better. Some of the feature choices I’d like to see are LSM vs. b-trees, enabling/disabling record versioning for time-series data, enabling/disabling zero-copy for websockets (I really want something to dethrone Kafka that will integrate natively with a primary data store (Sorry, Redis. Keep dreaming)), and compression algorithm choices. Some of those aren’t even really in current storage engines, so I’d be really interested to see how they can be implemented. I’ll certainly be keeping an eye on this project. Wish you the best of luck!

@@CharlesChacon We always intend to support lots of pluggable storage engines to give developers the choice. Our own key-value store will enable us to offer additional functionality down the line that we can't currently do with the current architectures out there.

Thanks, and thanks for the info - I wasn't aware of TiKV's relationship with RockDB!

they do sound pretty handy!

hard to go wrong with Postgres!

Thanks for watching! Fwiw you don't need to have any Rust knowledge to use SurrealDB! I agree it does seem like a game changer - the current version does have some of the quirks that you'd expect in any beta software, but overall it seems to work really well in its current state!

@@codetothemoon I managed to get an instance served up locally and it worked great, but I'm wondering if it's possible to create a cloud-hosted instance through something like Google Cloud Functions or if that is something I will have to wait for until they release their cloud hosting features?

it's worth checking out!

I agree!

I agree!

agree, there are so many interesting Rust-powered projects popping up, even CLI tools to replace ones that have been around for decades...

I think SurrealDB is really interesting too, but yeah I wouldn't use it in production quite yet. I'm definitely looking forward to watching how the project develops!

For reals!! This is getting ridiculous!! 😂

Hah yeah, I'm skeptical of all new projects - JS, Database, or otherwise - but this one really seemed to stand out from the crowd.

Thanks for watching!

Hi Nathan. Thank you very much. Join the Discord or GitHub if you have any questions - surrealdb.com/community

Convincing others to buy in is the hardest part! Even for game changing technologies.

Perhaps this tech could have some side-project potential for you?

It's ok, given that there seems to be a new JS framework every day, there's bound to be a SurrealJS at some point... 🙃

You can start creating your side projects with Nodejs just for fun :D and connecting with SurrealDB

Agree, it will be a game changer!

Glad you found it valuable and thanks for watching!

Nice, it's worth checking out!

nice!

💍

😂

hah me too!

I agree, I'm looking forward to see where they take this thing!

Surreal indeed! Yeah my understanding is that the UI will be available relatively soon.

Sounds about right to me!

Thanks and thanks for watching!

Thank you very much indeed @gorudonu ! We have lots planned for SurrealDB!

Agree it seems promising!

thank you!

same here!

I try to be! 🦄

Yeah SurrealDB can be downloaded for free!

❤❤

Indeed!

Nice, this actually wasn't on my radar. How does it stack up performance-wise?

@@codetothemoon I haven't done any performance testing. The backend storage engine is very robust and a lot of integration with other systems like Kafka, MQTT, etc. It's a pretty "featureful" database.

Thanks for watching!

Agree, version control is huge, and I'm not sure if Surreal plans to support it. At one company we had implemented our own homegrown version control inside Postgres, and the number of bugs and general pain it caused over many years was hard to fully quantify. It'd be nice to have something like that built in to the database.

My understanding is that it aims to support all of the complex types of queries you'd expect to be able to perform on a traditional relational database. JOINS specifically are eliminated as you are expected to use record links, graph edges and FETCH instead, but you can achieve basically the same thing. I believe subqueries are currently supported (but maybe ask on the SurrealDB discord server to be sure). Not sure to what level CTE-like patterns are currently supported or what is planned there, again maybe check with Tiobe and Jaime.

Nice, thanks for watching!

That would be cool!

Great question - I hadn't delved too deeply into performance benchmarks. In the docs they openly state that the performance currently doesn't yet quite stack up to the more established databases, so I'm wondering if we should wait for a more stable release before reading too deeply into them. Definitely something to keep tabs on though, and it's not unreasonable to be cautious about types of queries that seem to be slow in the beta.

thanks for watching!

Graph is definitely the future @Khari99! That is exactly why we wanted to merge Graph with traditional database concepts.

@@jaimemorganhitchcock6195 I understand the desire to combine different DB models. A better metaphor for how I see this is sticking with a hybrid vehicle instead of going full electric because it’s assumed that having both gas and electric together is more convenient. Convenient sure but is it a better design? I don’t believe so. Currently the database I mainly use is Dgraph. I’ll see how Surreal compares but I haven’t found anything that’s close that simplifies my architecture as much as Dgraph.

Dgraph is definitely a cool database @Khari99. With regards to multi-model, we wanted to ensure that SurrealDB was easy-to-use coming from all different database backgrounds. In addition, the design is such that the performance isn’t affected regardless of what data model you use in SurrealDB - obviously there are no JOINS, so SurrealDB is definitely closer to MongoDB/Dgraph as a concept. We have some really great things planned on our roadmap, so hopefully we’ll sway your mind in the not-too-distant future 😊!

@@jaimemorganhitchcock6195 While I like Dgraph a lot, I don't think it's perfect. Outside of the GraphQL API, I feel like there are a lot of ideas that you can pick up on to make SurrealDB better. 1. Automatically generated CRUD queries from a schema definition. I've only seen this implemented with GraphQL so I don't know if this is possible for your architecture. But this significantly reduces how much code needs to be written and maintained in the server. 2. Implement lambda functionality. Dgraph has a philosophy of moving the DB to the middle layer and allowing queries to trigger lambdas that either run custom computations or can reach out to a server externally for some request if needed. I really like this approach as it helps further reduce architectural complexity. But right now I'm limited to JavaScript lambdas. Rust lambdas would be amazing. 3. Auth & Access Control patterns. I looked through the documentation for Surreal and haven't seen anything around this topic. I understand the philosophy of leaving this up to server logic but if these features are baked into the database, it's one less thing for me to worry about. Even though I moved away from Fauna, they have this integrated into their DB, which is why I tried them out in the first place. 4. Logical Inference Rules. I've only seen these implemented in TypeDB. one of the things that Dgraph is missing that almost makes me want to develop a DB in Rust myself is the ability to create a knowledge graph intuitively. If you could look into how TypeDB accomplishes this and think of a similar implementation, this would be awesome. 5. Indexes. I also didn't see this in the documentation. Dgraph has indexes that enable full-text search (along with many other index types) out of the box. I would rather not have to implement elasitcsearch separately.

This is really cool, I haven't heard of many folks switching from pure relational to pure graph!

Hey Matt! I understand your tech stack position. We have some awesome things planned for SurrealDB so hopefully we can sway your mind in due course 😀

@@jaimemorganhitchcock6195 If you get full-text search in there, I’ll bite!! 😄👍🏽

Just checked the Docs and I'm blown away by the full-text support. I'm blown away by everything actually. They actually have a bunch of drivers and great extensibility points. Wow!!

It's probably not a good fit for every use case, especially when one db paradigm can handle all of your access patterns and you don't need the built-in auth and REST APIs that Surreal has. But yeah I agree it'll be cool to see how the project develops!

Thanks - unfortunately I don't have the queries posted anywhere, but you can check out README.md on the SurrealDB GitHub repository for some good examples!

?

I haven't heard of any courses for SurrealDB yet - it's still very new, but I'm sure there will be one before too long.

Thank you very much Mo!

Glad it piqued your interest as well!

μs means microseconds 😎

Yeah I'm curious as well to see what the cloud version looks like!

I'd love to do such a follow up, but I might wait until it goes 1.0 to do so!

Most production dbs are written in c, and tested throughout decades. It will be extremely difficult to beat performance but you never know.

@@nobytes2 well-written rust is potentially faster than C due to the rust compiler having more information to make agressive optimisations

@@eliottveyrier6253 show data or else stop making guesses, "potentially" lmao 😂

@@nobytes2 "potentially" because it's not automatically faster, it depends on what you write, but for the same code in c and in rust you will either have rust and C roughly equal (same llvm backend) or rust faster because the compiler has more information to prove more things about the program and use more agressive optimisation. If you want data you can look for it yourself you have Google too.

This is coming very soon!

Sounds like it's in the works!

Nice! It's completely free to download and host however you like. But SurrealDB is aiming to also provide a managed cloud version of it that comes at a cost, which I imagine will be a pretty compelling value prospect.

You can run it yourself in a docker container on a VPS. Should be pretty simple.

Thanks!

I haven't yet tried any of the "*bases", keep hearing good things about them. I agree the UI will be a game changer - the screenshots look really nice