Thank you very much Fireship for the feature. As always, we really appreciate it. Have a great 2023! ❤

@nathanoy_

Жыл бұрын

I predict that surrealDB will be the gold standard in a few years.

@x2_zoa141

Жыл бұрын

This actually is the real account

@x2_zoa141

Жыл бұрын

Went on ur website to find out

@ThomPorter74

Жыл бұрын

I found SurrealDB through Fireship, just getting going with it but absolutely LOVE it. You guys are doing awesome work! :)

@chickeninabox

Жыл бұрын

We are already a 1/3 into February now. Time flies, it feels like it is still the 1st of January

One thing I hate about developer tools is developers love making developer tools so there's way too many choices and I get choice paralysis.

1 Planetscale 0:45 2 Yugabyte 1:32 3 Neon 1:51 4 Dolt 2:08 5 CockroachDB 2:43 6 Cloudflare D1 3:08 7 Xata 3:48 8 8Base 4:26 9 EdgeDB 4:47 10 SurrealDB 5:22 11 Fauna 5:55 12 Mem Graph 6:23 13 KeyDB 6:47 14 MeiliSearch 7:20 15 Mindsdb 7:49

@roycechua

Жыл бұрын

Thanks for this!

@CheshireSwift

Жыл бұрын

@Fireship it'd be rad if you could include timestamps like these in the description so that they appear on the video itself 🙏

@LOVETOWATCHNEW

Жыл бұрын

What can you do with this all?

@TheThunder005

Жыл бұрын

Ha great recap thanks @NamalJayathunga

@rl6382

Жыл бұрын

Hero we don’t deserve

"For your next failed side project" - LOL I felt that one.

@silentsushix3

Ай бұрын

Bro, like a hot knife straight to the heart....

0:43 guillermo franchella cameo, nice one fireship

I'm here after 12 seconds. You're welcome, Fireship.

@leonardoraele

Жыл бұрын

What a blazingly fast comment

@ygorperez

Жыл бұрын

Much better comment than the guys who comment first, well done!

@Ctrl_Alt_Elite

Жыл бұрын

@@leonardoraele 20x performance increase!!!! 🔥😱👈👉👆👇👊🙌🤝🙃🔫

@dfsgjlgsdklgjnmsidrg

Жыл бұрын

definitely need a fast database to allow for this speed

@dontreadmyusername6787

Жыл бұрын

Game changing , ultra fast scalable comment section

Thanks for the shout out!

Thanks Fireship for featuring Memgraph!! Streaming graphs FTW

I would have liked you to include some time series optimized databases. They are very essential for IoT projects

@willi1978

Жыл бұрын

Are they so much better? Most of the time I saw time series data stored in relational dbs

@hansiboy5348

Жыл бұрын

@@willi1978 Yes they are. If used correctly they can achieve 90% compression rate on time series data, using compression techniques like delta encoding and run length encoding.

@arlandmv4053

Жыл бұрын

do you know of any? Id like to know some

@ilijanl

Жыл бұрын

timescaledb is probaby a good starting point (just extension of postgresql)

@SamI-yq8oc

Жыл бұрын

@@arlandmv4053 as IlijaNL , timescale is cool. I'm working on migrating my company's crufty postgres db schema to a fresh timescale one. It compressed 100GB of timeseries data (4-5 years' worth) down to 14. And then their downsampling algorithm was able to turn half a year of measurements into 750 data points in 2.7 seconds. I tried it with 1.5 years and it came back in 3.3 seconds. It's insane.

I am currently writing master thesis evaluating the extension Citus that distribute postgresql very efficiently and transparently, but still reusing most of the postgresql code. Definitely interesting as it also supports a lot of extensions, which is also a great property of postgresql.

I am watching again this material 5 months later and still a lot of hints to check over. Thanks for your work - kind of IT tech wikipedia

I'd love to see a video on full text search engine "databases". Things like Elasticsearch, Typesense, algolia, and more. I have a project using Typesense as a full text search engine, but its not feasible for medium-size amateur projects considering its in-memory approach. I'm not sure what to go with. Keep up the good work!

AGE (A Graph Extension) for Postgres seems similar to EdgeDB. Using Cypher to query the graph, but iirc you can mix sql and cypher together to get the best of your existing model with graph on top

@ra2enjoyer708

Жыл бұрын

If you mix SQL and Cypher you get a DSL only one person in the world understands. Also input sanitization and regular expression handling becomes a giga cancer.

minddb is especially helpful to ai/ml researchers and fine-tuners because it's easier to retrieve the training data and then use the training data with a logical "sql" like syntax.

@Cassandra_PGML

6 ай бұрын

I may be biased, but PostgresML is more scalable, more capable and several times faster than MindsDB. You can google it and find the benchmarks.

Now I don't watch your videos for software development purposes, at this point I just enjoy your memes.

@guilledmo4266

Жыл бұрын

the left, right, inner, fullouter joins meme killed me!! hahaha

JS: There is a new framework seems like every day! DB: Hold my bear!

This was awesome thanks for putting it together.

Man your a learning machine or an alien, the way you skeem through all that and teach it to us like you made it :)

@salmanbehen4384

Жыл бұрын

Seriously, All I want from him is how to learn in 100 seconds

@maythesciencebewithyou

Жыл бұрын

He got 1.84 million subscribers. People like that make a lot of money on KZread. Enough to pay people to do research for them, write a script and help with the editing.

@salmanbehen4384

Жыл бұрын

@@maythesciencebewithyou Thanks for the red pill.

@jordanmoats872

Жыл бұрын

That's probably the most important skill a developer can have today. You need to keep up on new technologies constantly to stay competitive in this industry.

wow. A few hours ago I was searching for a cool new db to use in my own project. And bam! This video released!

@GuruCodeWriter

Жыл бұрын

Same for me! Ship sails

Thanks a lot ! Really helpful 👍🏻👍🏻

very interesting and useful video. thanks for sharing so many interesting projects, many I hadn't heard of yet

Dude, you're klillin' it. So happy for you.

Your well-produced videos help increase the speed in which my failed-side-projects can ramp up.

Rip Planet Scale free tier

Really nice👍Thanks!

Awesome video, holy information overload. More databases than I would ever want to learn.

Wonderful summary of databases i heard first time

ArrangoDB is also a graph + document database with it's own programming like wish language.

Still waiting for that awesome sounding full Svelte(kit) course!

These videos keep getting better. The goat!

You should do one of CouchDB - I think it is underrated as a NoSQL database for mid-size projects.

@Darth_Bateman

Жыл бұрын

No, bad! *sprays you with anti-intellectual spray* BAD!!!!

@biomorphic

Жыл бұрын

It's bad, the codebase is terrible, it is very slow, only works over http/https. I wrote a query server and a client, so I know what I am talking about. It has a lot of limitations, and I still regret I have used in a project. It is underrated because it sucks, MongoDB is way better.

@MrBeast-1

Жыл бұрын

@@biomorphic I agree not good for larger projects, but I found the usability of it pretty straight forward with libraries like pouchDB.

@Darth_Bateman

Жыл бұрын

@@biomorphic We have standards Biomorphic. . . . *We have standards.*

@wchorski

Жыл бұрын

big fan of PouchDB with CouchDB

that's an hell of a headache of a video! great research

I'm impressed by how funny you can make these vids. The Rust joke and the "image of two dolphins f**cking" made me lol.

8base looks pretty cool. Definitely taking this for a spin.

I just signed up for 8base, looks like fun to experiment with 😄

Thank you fireship!!!

Hadn't really thought of AI inside my DB, but it sounds interesting. Would love to learn a little more about potential usages and have a more precise example. ^^

@pruthvirajshiv

Жыл бұрын

Bigquery, Aurora already does some ML inside the DB. Check it out

Best part of waking up, is fireship in your notifications. Neat.

Not quite I sure the idea behind database branching. Like does the data replicated to the branch as well? Or is it just the schema? If so what’s the benefit vs just checking that locally… Maybe you can create a video on that?

Lokking forward to see how surrealDB will evolve

i love your channel very much. I've learnd so many useful things and now planetscale made my life 2.66 times easyer. thank you

Very smart to put 8base on 8th place! 😁

Would love to see more content on edgedb

I'm always amused just how well Google/Amazon/MS have sold web devs on the 'infinitely scalable cloud' Kool-Aid. Seems most don't even know what a modern server (measured in hundreds of cores and terabytes of RAM) is capable of any more. Better usability (like SurrealDB) I do get excite for 🤘🤘 At least until AWS "adapts" it into a cloud offering and it dies as an open-source project.

@martinchoutka2279

Жыл бұрын

I'm not sure I understand your message. Are you telling us, that developers nowadays don't think that sometimes your own server is better than cloud providers that scale the resources based on your project needs? And that developers straight up want to run their apps in the cloud rather on their own infrastructure?

@Microphunktv-jb3kj

Жыл бұрын

From all this video, surreal seemed something i want to explore what it is... how is surreal better than postgres for example? ...

@pastelstoic8416

Жыл бұрын

Luckily, that won't happen! Surreal has a "you aren't allowed to sell this, looking at you Amazon" clause in their license.

@AlecThilenius

Жыл бұрын

@@pastelstoic8416 That'll just slow them down a bit. Maybe. I like those new licenses but Amazon will find a way to rip any good idea off. Interestingly, their retail is notorious for that as well, ex Sling: kzread.info/dash/bejne/epasuamjgZXZqrQ.html But hey, what's a poor guy that needs a third G-650 supposed to do 🤷‍♂

@shableep

Жыл бұрын

A lot of people just want to build an app and not want to have the very real effort of managing the IT of a physical server. I get maybe you or others similar don’t think it’s any effort. But it is. Along with managing reliability and stability of your own server. I mean props to you and others like you for doing it. But the. loud isn’t Kool-Aid, and rolling your own server isn’t a silver bullet.

Outside of jokes, the fact that your are showing off new technologies in a world where people seem to only give them a chance when they get "stable", makes your channel a TOP! Bonus for the way you present things and for your humor ;)

Your videos are educational and people of all ages use them to learn. Was the dolphin scene really necessary or useful?

@paradiseexpress3639

Жыл бұрын

It was necessary and useful. Cry about it

@thethiny

Жыл бұрын

@@paradiseexpress3639 are you mentally ill my friend? What I said is not wrong and not crying and stop liking your own comments.

@javiercandalaft

Жыл бұрын

Exactly, I now I won't share this publicly in a work environment, just in case someone I don't know sees it and makes them feel uncomfortable not knowing where it comes from.

@thethiny

Жыл бұрын

@@javiercandalaft and then you get kids like panda express above telling you it was necessary, lmao. Clearly they had no jobs before.

You will love to make a 100-sec video on DuckDB, given their cloud proposition is called MotherDuck, and they have Ducklings in their architecture. The script just writes itself

Being able to delete databases using drop is great :)

Great videos. Nun-db will soon be in this list ❤️

Those were some crazy ass databases fr

ArangoDB, it's a multi model database. Not so new, since 2011. Tried it personally, not on a project. Meili is really good so far. Using it on a project for a year and a half. Recently released version 1.0.

@lootic

10 ай бұрын

I've also tried arangodb in a failed hobby project. I find it extremely well designed with exactly the features you need. It feels intuitive quite quickly. Problem is, as with all lesser known projects, it lacks an ecosystem.

Wow, so many things popping up pushing the boundaries and so much of docs to be digested to put out such although short but saturated videos on the topic. I'd love to watch about graph databases which in my view are solid-grounded and must be safe to use in production today and may be worth replacing SQL types manywhere.. Sorry, non-english from central Asia:))

@stultuses

8 ай бұрын

Your English is fine mate!

Man... IT S AWESOME ! Thanks for sharing ! I think that I will try that SurrealDB "Develop easier.Build faster.Scale quicker." Sounds way to good but let's go !

0:25 excellent illustration 😀

Branching is also available on PlanetScale

I was expecting at least a mention of DGraph, which is a native GraphQL database (data is stored in graphs), is made in Go, and is pretty straightforward.

You didn't mention Virtuoso DB, and I am quite sure it needs to be on your list. It is RDF server that supports SPARQL 1.1 but it is made on top of super fast SQL server written in C++

Awesome reviews as always. I would probably also mentioned RethinkDB as an interesting player.

@fred.flintstone4099

Жыл бұрын

Yeah, it's pretty cool because you can get updates in real-time by listening on changes.

Thanks!

Is it blazingly fast?

0:41 Saludos desde Argentina, great video :D

What about ArangoDB ? it's multi paradigm document-key/value-graph, seems interesting

For scaling Postgres, there's also Citus which is a fully open source extension bringing distributed tables and columnar support. It's acquired by Microsoft and also served as a service under CosmosDB brand.

@uziboozy4540

Жыл бұрын

Yugabyte is pretty much Citus on steroids

@aamederen

Жыл бұрын

@@uziboozy4540 they have different approaches in the dsql area. For example, Citus keeps the PG as is, doesn't fork or anything, and installed on top of the regular pg as an extension, which is important for many. Also their approach for many db concepts like HA or replication are different. The list can go on. btw disclaimer I work on Citus.

@franckpachot2511

Жыл бұрын

@@uziboozy4540 Yes, different architecture. CitusDB is sharding on top of PostgreSQL. YugabyteDB is SQL on top of distributed DB. So different use cases. Datawarehouse need many analytic pushdowns, and no need for global transactions or HA -> CitusDB. OLTP need global transactions, foreign keys, HA and elasticity -> YugabyteDB

@georgehelyar

Жыл бұрын

Switched from nosql to citus recently and love it. Nosql was just so painful to work with, having to know how data will be queried at the time of writing, having to denormalise data and write it many times by different keys, etc. Queries existed but had such bad performance that point reads were needed to make it scale well enough, at which point it's just key-value. We evaluated vitess as we run in kubernetes but it was a headache to manage and it was missing many features of mysql 8, while citus is kept up to date with postgres within weeks. Switching to citus (cosmos postgresql) has reduced the amount of data we store, made it much easier to work with to implement new features and improved performance dramatically. Huge success story for us.

I always enjoy your content (esp. the multi-compare format videos). That said, I would hesitate to use any of these offerings in a production system. I've seen too many projects go south due to jumping onto some brand new flashy bandwagon, only to have that wagon dead in short order. Personal/side projects, sure... but staking an enterprise-type app on anything other than solid, well-established foundational tools is a mistake, imo.

I used to spend long time to decide what DB i will go for, thanks fireship and I will spend an era

In the key-value/cache category, DragonflyDB is notable as well. 😃

TigerBeetle is another new entry that's really, really interesting. Very excited to see where it goes and how it evolves

cool! thank you :)

After video maybe I will choose "Xata" for next project Thank you for great and interesting video!

Last one is interesting!

Edge, Surreal, Xata and MindsDB look pretty awesome.

@fred.flintstone4099

Жыл бұрын

EdgeDB is written in Python, I am not sure I would trust my data with that. Python isn't great for performance, scalability or reliability.

0:25 perfect depiction of Joins 😂

This kinda of video show me how much of my area I don't know. Really important

Gonna need a database of all the database engines.

Neondb is postgres the only difference is they separated compute from storage and persist the storage in something like s3 and cache the important data in the VM , they also have a bunch of tricks to allocate more VMS to handle scaling while retaining the ability to scale down to 0, they even went as far as commiting the changes back into postgres but they probably won't be merged

I have been edified and entertained.

02:00 made my day man, made my day.

Great video! Curious if you have covered the popular Snowflake engine. As a data engineer I see snowflake as the gold standard. Integrating that with dbt and you have the hippest BI stack!

@tycooperaow

Жыл бұрын

I use Snowflake at my job and I love it. Unfortinately they aren't startup friendly

Super happy with Meilisearch.

Dolt is brilliant!

This video came at the time I needed it the most and I'm late, 2mins late

We need a database to manage these databases.

Edge DB seems promising. I will give it a try!

Vector Databases would have been a great addition

Nice! Now they only need to mature about 10 years and then I'm more than happy adopting them :D

Could you do a video on Turso and Sqlite?

Love seeing Guillermo Franccella's meme and "Te lo resumo así nomás" logo. 🇦🇷

that join's got me

Thank you I will use every one of them in my next 15 side projects.

I’m really curious how you get to know all these possible options

It would be nice to have a video like this one, but exclusive for message brokers and streaming plataforms like Rabbit and Kafka.

Thanks

Not my next failed side project tho 😭😂😂😂 you're too funny!

You’ve overlooked Astra from Datastax, an Apache Cassandra-based serverless database that can run on the three major clouds. For that matter you also missed Amazon Keyspaces, which is similar but is only in AWS and lacks the integration with Apache Pulsar and Kaskada (an AI platform).

mindsDB looks realy awesome.

0:42 I wasn't expecting to see Guillermo Francella in a video about databases.

Pretty cool 😎

The moment i saw the title, i knew right away that surreal would have a place in the list

@fred.flintstone4099

Жыл бұрын

Rightfully so!

crazy ass DBs got me

WHY HAVE YOU NOT TOLD ME BEFORE THAT YOU HAVE A SECOND CHANNEL.... more content to binge watch. nice.