SurrealDB in 100 Seconds

Рет қаралды 398,980

Жыл бұрын

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

Пікірлер: 754

@jaimemorganhitchcock6195 Жыл бұрын

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.

@paupertim5819 Жыл бұрын

It looks like this DB is the surreal deal!

@Arabian_Epileptic Жыл бұрын

Good job! 🎉

@lokenderossii Жыл бұрын

Awesome job!!!!

@brandonmochi Жыл бұрын

Omg is the boss!

@shateq Жыл бұрын

Good luck!

@abdisamadkhalif4283 Жыл бұрын

Respect for the people undertaking these challenges. Databases are getting exciting these days.

@abdisamadkhalif4283 Жыл бұрын

[ ]

@Dubs3 Жыл бұрын

This is one of the coolest new DB projects I’ve seen in a while.

@MerthanMerter Жыл бұрын

because its not a js framework

@pradiptanuryanto Жыл бұрын

agree

@gamerzero6085 Жыл бұрын

@@MerthanMerter it looks like it is.

@mart0347 Жыл бұрын

@@gamerzero6085 written in rust 😉

@gamerzero6085 Жыл бұрын

@@mart0347 yeah whatever, there's already node.

@oplik0 Жыл бұрын

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.

@wanderingthewastes6159 Жыл бұрын

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.

@RoadArchie Жыл бұрын

@@wanderingthewastes6159 probably annoying as shit to implement

@ThePedrolic Жыл бұрын

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

@fltfathin Жыл бұрын

@@wanderingthewastes6159 pretty sure that is the original intent of patents, dissemination of technology without giving away your right to monetize it

@scheimong Жыл бұрын

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.

@Fireship Жыл бұрын

There’s more to this story… Go beyond kzfaq.info/get/bejne/gqlxfM6pltaVm2Q.html

@sporefergieboy10 Жыл бұрын

Im gay and obsessed with you

@shateq Жыл бұрын

How about "How to byo database?" Tutorial? (see how it works moment)

@Kat21 Жыл бұрын

I've been waiting for this video! I saw Code To The Moon's video and i was eventually hoping for this

@Arabian_Epileptic Жыл бұрын

@@sporefergieboy10 🤦‍♂️

@oncedidactic Жыл бұрын

YES PLZ

@DavidL344 Жыл бұрын

The timing is impeccable, I literally found out about the project yesterday!

@420moby Жыл бұрын

same about 3 days ago for me

@siveroo7493 Жыл бұрын

ikr, its _surreal_

@muhammadmejanulhaque3305 Жыл бұрын

yeah, I found it from his tweet

@thomaslisankie342 Жыл бұрын

Knowing how quickly Jeff is able to go from finding out about something a video, he might have found out about it yesterday too

@Zihad Жыл бұрын

me 3 days ago hahaha

@marcoscarlomagno3065 Жыл бұрын

Javascript inside a SQL query 🤯. What's next? Machine learning interpreting queries like 'Select my favorite puppy'? Awesome

@aislanarislou Жыл бұрын

Thats should be freaking awesome too!!

@vaisakhkm783 Жыл бұрын

wow that's a uniq concept

@maxwellflitton3973 5 ай бұрын

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

@marco_ruizv 2 ай бұрын

This aged well...

@wholesome8691 Жыл бұрын

another db to put 10 years of experience in my portfolio

@tsukiiiiiii Жыл бұрын

true

@u4yk Жыл бұрын

It has to be senior level, too.

@sguptzz Жыл бұрын

and still get junior dev role

@karinaplay9025 Жыл бұрын

Ajajajajajajaja

@nonominox Жыл бұрын

This joke is like the running gag of all Fireship comment sections 😹

@KanadaKid19 Жыл бұрын

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.

@theherk Жыл бұрын

This database is the most exciting project I've seen in a good long time. Glad it is generating some buzz.

@scienc3tv Жыл бұрын

I think I never wanted a project to succeed like this one! Keep up guys!

@zhehuizhou Жыл бұрын

OMG, I noticed this project over the weekend and was wondering when it will be covered by Fireship 100s series, and here it comes! 😃

@vasiovasio Жыл бұрын

He is Always Trendy AF!

@codetothemoon Жыл бұрын

Thanks, fantastic video! Glad this thing is getting the attention it deserves!

@coder3101 Жыл бұрын

You covered it before Fireship! I got to know about it from you. Thank you for your videos.

@Seltyk 11 ай бұрын

It's embarrassing that this video contains more information than the entire SurrealDB Rust SDK documentation

@souls.7033 Жыл бұрын

Was waiting for your video since the day I discovered SurrealDB. Congrats to the two founders. They made a fantastic product.

@Brajgamer Жыл бұрын

This sounds too good to believe, would love to see some critical reviews of this.

@pmj_studio4065 Жыл бұрын

'cause, you know, _surreal_ xD They couldn't pick a better name imo

@hojdog Жыл бұрын

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.

@Mankepanke Жыл бұрын

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.

@Brajgamer Жыл бұрын

@@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.

@uema Жыл бұрын

@@Mankepanke That was the HTTP request time, the DB itself took 300~600μs to perform the query.

@nicky_rads Жыл бұрын

Woah, really cool project! All the bells and whistles. Looking forward to the extended cut

@davidyoder5890 Жыл бұрын

Really looking forward to the deeper dive on your new channel!

@leetaeryeo5269 Жыл бұрын

I learned about this db earlier this week and I’m not gonna lie, it’s got me excited about recent db developments.

@didyouknowamazingfacts2790 Жыл бұрын

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.

@cddelgado Жыл бұрын

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.

@tagKnife Жыл бұрын

SurrealDB looks surreal. I cant wait to use it and convince my company to use it.

@peegee101 Жыл бұрын

Very kewl and looking forward to your beyond Fireship edition of the explanation!

@AlbertCloete Жыл бұрын

I was waiting for your video on SurrealDB!

@alokmtu Жыл бұрын

Love this! The feature list is so rich. Surreal

@user-jl7xw1oq5v Жыл бұрын

Wow, it looks amazing!!! I will definitely use it in my next project

@athreyamurali1439 Жыл бұрын

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.

@SogMosee Жыл бұрын

This right here

@DominicFuchs Жыл бұрын

Wow. That's really sick. I will actually try it out in one of my upcoming projects.

@cheegum6296 Жыл бұрын

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!

@covle9180 Жыл бұрын

I am here for all of it. This is a cool project!

@mierenmans881 Жыл бұрын

This sounds so surreal. Really excited to try and use it in my next project

@walderfranco Жыл бұрын

Algo que esperaba desde hace tiempo. Graciasss, buen video, la base de datos del futuro.

@barloc2 Жыл бұрын

The specs were so surreal, at some point I started to doubt them. But man, this is awesome.

@micahmeadows9703 Жыл бұрын

Your editing style is unmatched.

@heckyes Жыл бұрын

Wow, that's impressive. Might finally replace MySQL in my personal project stack.

@dessallidev4890 Жыл бұрын

broken it down makes it seem so user-friendly and easy to use. I can’t wait to start making soft! Thanks again!

@jonahbranch5625 Жыл бұрын

I had a feeling you'd cover this soon!

@waseemtahir6740 Жыл бұрын

Ambitious project, hope it can deliver what it promises, and if it does then it would just revolutionise db development.

@SogMosee Жыл бұрын

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

@jordanstafford5110 Жыл бұрын

Looking forward to that guide! Thanks again

@charlesm.2604 Жыл бұрын

I had my eyes on this project for a few weeks now it's time to contribute.

@fvbixn Жыл бұрын

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.

@amcmillion3 Жыл бұрын

This DB looks incredible.

@Rasecz Жыл бұрын

Indeed sounds surreal. Gotta try this out on my next one

@brandonmint6661 Жыл бұрын

Really excited to use this

@alinawaz4034 Жыл бұрын

This looks Awesome!

@Xeoncross Жыл бұрын

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.

@arnoudt Жыл бұрын

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.

@lancemarchetti8673 Жыл бұрын

So excited about Sureal!!

@aldovia2242 Жыл бұрын

“Engine is written in rust” - I’m sold!

@seth_deegan Жыл бұрын

I'm HYPE for this!

@abnoco Жыл бұрын

Thank you for making this 100 seconds because at 101 seconds, my head would explode.

@xBrainZy Жыл бұрын

I'm not fan of getting deeper into any SQLs but I'm tempted to dive into this 💥💥

@pengain4 Жыл бұрын

Checkout EdgeDB as well. It's more mature, production-ready and has better tooling (migrations, web UI etc).

@sage_gamers Жыл бұрын

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 ^⁠_⁠^

@this.channel Жыл бұрын

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.

@JeremyChone Жыл бұрын

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.

@awsafchowdhury5236 Жыл бұрын

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

@wfl-junior Жыл бұрын

This is insane, actually surreal.

@jort93z Жыл бұрын

this is so cool. I want to learn it.

@carpenecopinum1665 Жыл бұрын

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...

@bienv2lis Жыл бұрын

Check out ArangoDB and AQL

@BosonCollider Жыл бұрын

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.

@carpenecopinum1665 Жыл бұрын

@@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.

@emmanueloluga9770 Жыл бұрын

@@bienv2lis Thanks for the recommendations

@miguel_bogota Жыл бұрын

OMG this db is awesome!

@Arabian_Epileptic Жыл бұрын

This was surreal!

@GlitchyPSI Жыл бұрын

This project is drop dead crazy

@Equilibrier Жыл бұрын

This is just too awesome !!!

@master9391 Жыл бұрын

wow, so many features, it seems like a surreal database.

@basheyev Жыл бұрын

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!

@gnosis8142 11 ай бұрын

With Physical Technologies - definitely ― with Virtual Technology - there's no such limit.

@Wubwub772 10 ай бұрын

@@gnosis8142 of course there's limits... software design is all about making the right trade offs

@shimadabr Жыл бұрын

Now that's a new and exciting project! With potential to change for the better the development process, not another JS framework.

@MtthwBrwng Жыл бұрын

Neat! It's similar to Arangodb

@OzzyTheGiant Жыл бұрын

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

@titan8788 Жыл бұрын

Very cool! Can you do 100 seconds of BASIC next?

@Raezard77 11 ай бұрын

MY BRAIN IS F***ED THIS IS HEAVENLY!

@_sevelin Жыл бұрын

Whoa, thats a powerful DB, gotta try...

@TheR0yalBeast Жыл бұрын

This looks like wizardry. I love it,

@TheBadFred Жыл бұрын

the holy trinity of database.

@dhiliph98 Жыл бұрын

System design interviews are gonna get even harder 😭

@dhiliph98 Жыл бұрын

Easier I guess.. No more discussing the tradeoffs between databases.

@demonlegit9012 Жыл бұрын

@Fayaz Mohammad Every sys designer interviewee is a Schizo

@shashishekhar---- Жыл бұрын

This is the most interesting comment thread I've seen on this channel lol

@amjed-ali-k Жыл бұрын

All in one DB for real 😎

@FourOf92000 Жыл бұрын

1:46 congratulations to Jeff

@info662 Жыл бұрын

That's so Surreal!

@FreeLibyanism Жыл бұрын

time to change my project's db again 🔥🔥

@i3looi2 Жыл бұрын

Will wait for the benchmarks.

@gaurdianAQ Жыл бұрын

Would love to see you do a video on ArangoDB as well, sounds like it and SurrealDB have some stuff in common.

@bienv2lis Жыл бұрын

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.

@gaurdianAQ Жыл бұрын

@@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

@soviut303 Жыл бұрын

Would be really nice to see a built in GraphQL endpoint for this.

@sujezz Жыл бұрын

I found out about it like 2 days ago. I'm more than interested in trying in out once they support more languages.

@bdbose123 Жыл бұрын

got a new db to implement for a weekend project

@nrdfoss Жыл бұрын

this DB is truly surreal

@oursbrun4243 Жыл бұрын

Built using RUST. Surreal ❤️.

@DollyOmegaX Жыл бұрын

Thanks!

@vladoportos Жыл бұрын

Interesting project.

@dalisoft Жыл бұрын

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

@VincentJenks 4 ай бұрын

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!

@ScoutSniperMC Жыл бұрын

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.

@cryonim Жыл бұрын

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.

@randall.chamberlain Жыл бұрын

A quick shout to my man Jeff, 99 and still rocking the boat.

@wandenreich770 Жыл бұрын

Best thing ive heard👌

@gotxe Жыл бұрын

Waiting for the EdgeDB review 🙂

@abdoulkarimkhattali4008 Жыл бұрын

Bro I will start using that for now on

@sovietxcp4288 Жыл бұрын

good work ya gini

@immortalsun 6 ай бұрын

Holy shit. This is absolutely insane! Some might even call it surreal.

@TheIndieGhost Жыл бұрын

It's official: Fireship is becoming a Database Channel after undergoing a web dev phase.

@gngn2973 Жыл бұрын

Oh this looks interesting. Wonder how fast it is.

@BHVampireLF Жыл бұрын

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.

@uziboozy4540 Жыл бұрын

PlanetScale is pretty sweet