SurrealDB in 100 Seconds
HTML-код
- Опубликовано: 14 сен 2022
- SurrealDB is a "NewSQL" multi-model database with an impressive list of features from popular relational, graph, and document paradigms. Its query language is based on SQL, but does not rely on JOINs for queries.
Full Tutorial Coming Soon on Beyond Fireship / @beyondfireship
#database #programming #100SecondsOfCode
🔗 Resources
SurrealDB Github github.com/surrealdb/surrealdb
Surreal Docs surrealdb.com/
SQL in 100 Seconds • SQL Explained in 100 S...
7 Database Paradigms • 7 Database Paradigms
🔥 Get More Content - Upgrade to PRO
Upgrade to Fireship PRO at fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.
🎨 My Editor Settings
- Atom One Dark
- vscode-icons
- Fira Code Font
🔖 Topics Covered
- What is SurrealDB?
- Is SurrealDB legit?
- Databases written in Rust
- Multi-model databases
- What is the best database?
- Database with realtime updates Наука
Hi Fireship! SurrealDB Founder here with my brother Tobie. Wow! Thank you very much indeed for this video! Just the two of us at the moment but aiming to grow very quickly. We are working on lots of performance improvements, GraphQL integration, and our own key-value storage engine coming in due course. Thank you once again for this video! We really appreciate it.
It looks like this DB is the surreal deal!
Good job! 🎉
Awesome job!!!!
Omg is the boss!
Good luck!
Respect for the people undertaking these challenges. Databases are getting exciting these days.
[ ]
This is one of the coolest new DB projects I’ve seen in a while.
because its not a js framework
agree
@@MerthanMerter it looks like it is.
@@gamerzero6085 written in rust 😉
@@mart0347 yeah whatever, there's already node.
A fairly interesting part of this project IMO is its license - the core is not actually FOSS, it's under a permissive version of BSL that allows for basically any usage outside of offering DBaaS (which is how they're planning to monetize it), but they commited to a rolling time limit where the license for each release will convert to Apache License 2.0 after 4 years.
Which honestly seems like an interesting compromise between preventing a Cloud platform from just taking the code and ultimately having it fully open (albeit after some time) so that even if development stops someone might at least pick up an older version.
I’ve always wondered why more people don’t do this type of “It’ll be 100% FOSS in X years so I can earn some money before it” type of license/agreement.
@@wanderingthewastes6159 probably annoying as shit to implement
This is fascinating and seems like it could serve as a really good model of FOSS moving forward, especially for companies who are skiddish about open sourcing their software
@@wanderingthewastes6159 pretty sure that is the original intent of patents, dissemination of technology without giving away your right to monetize it
I actually love this idea. As long as we're not in "the communist utopia", FOSS still can't pay the bills with passion alone. It's only fair that their own work gives them a bit of exclusivity and therefore competitive advantage.
TBH making a living with FOSS has always been my distant career dream. Maybe one day in the future I will also adopt this model with my own projects.
There’s more to this story… Go beyond ruclips.net/video/LCAIkx1p1k0/видео.html
Im gay and obsessed with you
How about "How to byo database?" Tutorial? (see how it works moment)
I've been waiting for this video! I saw Code To The Moon's video and i was eventually hoping for this
@@sporefergieboy10 🤦♂️
YES PLZ
The timing is impeccable, I literally found out about the project yesterday!
same about 3 days ago for me
ikr, its _surreal_
yeah, I found it from his tweet
Knowing how quickly Jeff is able to go from finding out about something a video, he might have found out about it yesterday too
me 3 days ago hahaha
This is the coolest looking project I've seen in a long time! Even for Fireship I've never had so many ideas "click" or gone from "who cares?" to "oh no that seems really useful!" so quickly before.
another db to put 10 years of experience in my portfolio
true
It has to be senior level, too.
and still get junior dev role
Ajajajajajajaja
This joke is like the running gag of all Fireship comment sections 😹
OMG, I noticed this project over the weekend and was wondering when it will be covered by Fireship 100s series, and here it comes! 😃
He is Always Trendy AF!
This database is the most exciting project I've seen in a good long time. Glad it is generating some buzz.
I think I never wanted a project to succeed like this one!
Keep up guys!
Javascript inside a SQL query 🤯. What's next? Machine learning interpreting queries like 'Select my favorite puppy'? Awesome
Thats should be freaking awesome too!!
wow that's a uniq concept
Hey I'm Maxwell Flitton (author of the O'Reilly async rust book and Packt book rust and web programming), SurrealDB hired me about 8 months ago to build an ML engine. I got it stable about a week ago. You can train ML models in either SkLearn or PyTorch, it compiles to our own surml file format, and you can include it now in your SQL statements, so you can run ML in your SQL queries. Do you can get ML models to calculate results and use those results in queries. In terms of sentences, I'm now working on tokenizers like BERT, and combining this with Emmanuel's (the guy who put JSON in Redis DB and is now at SurrealDB), vector search, we will be able to interpret sentences in the SQL query in the future
This aged well...
Was waiting for your video since the day I discovered SurrealDB. Congrats to the two founders. They made a fantastic product.
Thanks, fantastic video! Glad this thing is getting the attention it deserves!
You covered it before Fireship! I got to know about it from you. Thank you for your videos.
Woah, really cool project! All the bells and whistles. Looking forward to the extended cut
As a DBA this is pretty cool. Once I started learned about NewSQL databases about 8 years ago. I knew it would be the future.
It's embarrassing that this video contains more information than the entire SurrealDB Rust SDK documentation
Really looking forward to the deeper dive on your new channel!
I learned about this db earlier this week and I’m not gonna lie, it’s got me excited about recent db developments.
This is easily the most wild database I've ever seen. I had to stop and count the months because I thought it was an April Fools joke at first. This is amazing and I dread the day I find the project that needs it.
Very kewl and looking forward to your beyond Fireship edition of the explanation!
This sounds too good to believe, would love to see some critical reviews of this.
'cause, you know, _surreal_ xD
They couldn't pick a better name imo
I had to check if it was April 1st, and even after that I still didn't believe it since fireship is a true jokester even on the most sensible of days.
Seems performance is very slow. 15ms to query a single field from a DB with a single table with a single record, when Fireship demonstrated it.
I have to try it myself before I know, but I suppose that is the main drawback right now.
@@Mankepanke Thanks for the information. All classic DBS have been through rigorous performance optimization in all these years. So if the slow performance isn't by design, it's a great tool to keep a tab on.
@@Mankepanke That was the HTTP request time, the DB itself took 300~600μs to perform the query.
I look at these new database designs and wonder how people can be this innovative. This looks so cool, definitely would want to explore the creators' design process for this.
This right here
Wow, it looks amazing!!!
I will definitely use it in my next project
Wow. That's really sick. I will actually try it out in one of my upcoming projects.
I was waiting for your video on SurrealDB!
SurrealDB looks surreal. I cant wait to use it and convince my company to use it.
I am a windows systems admin who has dealt with databases for installation and very minimal troubleshooting. I don't see myself getting into databases but this was amazing!
Whoa, all of the features really sound awesome. Gotta try it out on a test project. It's many things I dream about that SQL Databases would have.
Love this! The feature list is so rich. Surreal
I am here for all of it. This is a cool project!
This sounds so surreal. Really excited to try and use it in my next project
Wow, that's impressive. Might finally replace MySQL in my personal project stack.
Algo que esperaba desde hace tiempo. Graciasss, buen video, la base de datos del futuro.
broken it down makes it seem so user-friendly and easy to use. I can’t wait to start making soft! Thanks again!
I had a feeling you'd cover this soon!
The specs were so surreal, at some point I started to doubt them. But man, this is awesome.
Ambitious project, hope it can deliver what it promises, and if it does then it would just revolutionise db development.
full text search and real-time events? schema and schemaless?
Its on track to put dynamodb, mongodb, mysql, firebase, and neptune all out of business in one shot
Your editing style is unmatched.
I had my eyes on this project for a few weeks now it's time to contribute.
Finally, a database powerful and flexible enough to handle every type of transport layer and query system I'm going to need to expose my react counter button with.
This looks really cool. I've been thinking lately about what could dethrone SQL and never imagined something this cool could be created. SQL could be the SQL killer.
This is awesome. Building a Rust desktop app template right now and this could be a great fit. I need to see how simple it is to embed. I looked at Sled, and while very nice, makes schema evolution kind of hard.
Looking forward to that guide! Thanks again
Thank you for making this 100 seconds because at 101 seconds, my head would explode.
I'm HYPE for this!
Please make video on your journey as a developer and the ups-downs you faced. btw love watching your video and it inspires a lot ^_^
Indeed sounds surreal. Gotta try this out on my next one
This looks Awesome!
This DB looks incredible.
Really excited to use this
I'm not fan of getting deeper into any SQLs but I'm tempted to dive into this 💥💥
“Engine is written in rust” - I’m sold!
Love the concept! I’ll definitely be taking it for a spin soon and keeping an eye on its progress. Hope to see this get market traction, because traditional RDBMS systems have been showing their age for quite a while. It’s all just too difficult to manage. I’m curious to see if cloud vendors catch on to Surreal. Also curious about admin around it, dev lifecycle, etc. What do migrations look like? So many questions. Exciting stuff!
Very cool! Can you do 100 seconds of BASIC next?
SurrealDB raises 6M for its database-as-a-service. Tech Crunch just published the news yesterday (Jan 4 2023). Watched this video yesterday, thought I should come back to comment for those interested.
So excited about Sureal!!
Checkout EdgeDB as well. It's more mature, production-ready and has better tooling (migrations, web UI etc).
Being able to have JS directly in the query sure looks nice. For the rest I'm a bit on the fence about it... one thing I've been looking for, but never could really find is basically a relational DB that is queried more like a NoSQL DB. Postgres does a good portion of that already, with it's ability to aggregate stuff as JSON (so things like "Get me all the users and their top 10 posts each and for each post the top-rated comment" become expressible in a single query, which wouldn't be possible with most other RDMBSs), but the queries become kind of unwieldy very quickly and also don't compose very well. Something more along the lines of GraphQL, but meant as a real DB querying language and not an API design pattern would be great...
Check out ArangoDB and AQL
You may be interested in the pg_graphql postgres extension. It makes querying postgres really comfy since you can mix graphql and sql easily when writing queries that are supposed to return json.
@@BosonCollider will definitely have to look into that. Since I'm already on PostgreSQL, having something on top of it so I can migrate smoothly will be a huge plus.
@@bienv2lis Thanks for the recommendations
Often when you try to combine the strengths of technologies into one product, you end up with a product that combines all the weaknesses. Anyway, I wish you success guys!
With Physical Technologies - definitely ― with Virtual Technology - there's no such limit.
@@gnosis8142 of course there's limits... software design is all about making the right trade offs
This is just too awesome !!!
This was surreal!
OMG this db is awesome!
Would love to see you do a video on ArangoDB as well, sounds like it and SurrealDB have some stuff in common.
I have tried probably a dozen alternatives and ArangoDB is the one that turned out perfect for me. I've been using it 2 years now and AQL is like a dream.
@@bienv2lis nice, at some point I'm hoping to mess around with different databases just to learn more about them, Arango is definitely on my list
I feel like it's no exaggeration to say you are a godsend. I've been making my own soft since i was 14ish and since then it's beco my
A quick shout to my man Jeff, 99 and still rocking the boat.
Now that's a new and exciting project! With potential to change for the better the development process, not another JS framework.
this is so cool. I want to learn it.
This is insane, actually surreal.
I really appreciate the improved flexibility in data modeling. I’ve had to work on projects that imposed using MySQL on largely document-oriented data, and it was an over-budget NIGHTMARE.
I’m a little concerned as to how many APIs they’re offering, feel like such a project needs lots of focus.
sql goes out of hand real fast, but it is the "tried and tested" thing with a lot of development so its the db standard.
wow, so many features, it seems like a surreal database.
That's so Surreal!
Would be really nice to see a built in GraphQL endpoint for this.
I could be wrong but the way this database was presented makes me think that if it's this good, backend projects could be vastly simplified
Finally🔥🔥
I was thinking Beyond Fireship is fake account and copies video from Fireship. 😂
I will subscribe, you is one of best tutorial maker. Within 100 seconds and very clear
I found out about it like 2 days ago. I'm more than interested in trying in out once they support more languages.
Hi can you please do a video on Parse Platform , I don't know if it is a firebase alternative , but It is pretty easy to use.
Damn, that's too beautiful to be real. Coincidentally I'm going crazy choosing a DB for my new project, because I really hate every one of the databases I've used.
PlanetScale is pretty sweet
Whoa, thats a powerful DB, gotta try...
It's official: Fireship is becoming a Database Channel after undergoing a web dev phase.
good work ya gini
All in one DB for real 😎
This project is drop dead crazy
Will wait for the benchmarks.
System design interviews are gonna get even harder 😭
Easier I guess.. No more discussing the tradeoffs between databases.
@Fayaz Mohammad Every sys designer interviewee is a Schizo
This is the most interesting comment thread I've seen on this channel lol
This is actually really interesting. How rough around the edges is it?
Lots going on in the DB space. I’ve been using EdgeDB for the last couple of months and have been enjoying it. Anyone have experience or points of view between this and Edge?
Best thing ive heard👌
I've been following their LinkedIn profile of SurrealDB for weeks now, this sounds really cool to be used projects
time to change my project's db again 🔥🔥
MY BRAIN IS F***ED
THIS IS HEAVENLY!
got a new db to implement for a weekend project
1:46 congratulations to Jeff
this DB is truly surreal
Neat! It's similar to Arangodb
This looks like wizardry. I love it,
Holy shit. This is absolutely insane! Some might even call it surreal.
Waiting for the EdgeDB review 🙂
Was wondering about the scenario where you have a bidi stream, like a chat server or game server. Would the Surreal DB be able to host the server code (either starting another process on some port, or otherwise connection some running code started within own its own process)? Or would you just need a separate process from the get go in this case?