The SQLite Rewrite In Rust

  Рет қаралды 194,737

ThePrimeTime

ThePrimeTime

Күн бұрын

Пікірлер: 702
@ThiagoRochaA1
@ThiagoRochaA1 Ай бұрын
Limbo is not the best place to leave your data
@77696b
@77696b Ай бұрын
yeah, the name is not the best
@thtcaribbeanguy
@thtcaribbeanguy Ай бұрын
i know they will rename but for now.... its pretty funny
@SimGunther
@SimGunther Ай бұрын
Or your soul
@Kane0123
@Kane0123 Ай бұрын
Love their sense of hunour
@worldspam5682
@worldspam5682 Ай бұрын
@@SimGunther idk, better than hell, for sure.
@YvesBlatti
@YvesBlatti Ай бұрын
Also : Chaos Godzilla is implemented for free by CrowdStrike
@bhargavlakkurkushakumar8999
@bhargavlakkurkushakumar8999 Ай бұрын
😂
@HickoryDickory86
@HickoryDickory86 8 күн бұрын
An apt name indeed, CrowdStrike.
@randomexplosion6527
@randomexplosion6527 Ай бұрын
Everything that can be rewritten in rust will eventually be rewritten in rust
@randomexplosion6527
@randomexplosion6527 Ай бұрын
Whether it should be is another thing entirely
@dkr91
@dkr91 Ай бұрын
@@randomexplosion6527 Prisma went from Rust to TS
@JasonKingKong
@JasonKingKong Ай бұрын
Your [Rust programmers] were so preoccupied with whether they could, they didn’t stop to think if they should.
@apatterndarkly
@apatterndarkly Ай бұрын
Partially because there's a whole heck of a lot of former JS devs writing rust these days. (see also: Atwood's Law)
@Mihaugoku
@Mihaugoku Ай бұрын
"I am currently rewriting politics to Rust"
@dirkschannel5817
@dirkschannel5817 Ай бұрын
SQLite is the one project written in C that I would consider to be one of the most scrutinized open source code and thus put it on the bottom of the list of projects in need of a rewrite in Rust. However I love Rust and enjoy using it. Thanks to everyone involved :-)
@guillemgarcia3630
@guillemgarcia3630 Ай бұрын
this is for using io uring, so it might be worth the rewrite
@dirkschannel5817
@dirkschannel5817 Ай бұрын
@guillemgarcia3630 I see. IO uring offers a lot of benefits. Thanks for pointing this out.
@dirkschannel5817
@dirkschannel5817 Ай бұрын
@@guillemgarcia3630 I see. Thanks for pointing that out
@OnFireByte
@OnFireByte Ай бұрын
Turso really like sqlite but they need some of somewhat niece features for their usage, so they decide to rewrite it in rust.
@mynameisshadywhat
@mynameisshadywhat Ай бұрын
​@@OnFireByteas opposed to nephew features?
@ngideo
@ngideo Ай бұрын
Making Limbo async by default means it's a totally new database. The sync nature of SQLite makes it really attractive for a lot of embedded app use cases. Async and networking means its just another database server.
@AJMansfield1
@AJMansfield1 27 күн бұрын
I'm sure it depends on the company/project, but async code is _very_ common in embedded code, at least the sort I do. Blocking calls to 'slow' operations (e.g. writing to flash, executing I2C transactions, or just about anything else you can set an IRQ handler for) are handed off to IRQ-based drivers that configure hardware to perform the job and then suspend execution until the interrupt service routine is called and then resume your task code. That often isn't in the form of an explicit language-level async feature or library, but entering/exiting processor sleep states, saving state for a completion callback to use, or having a master polling loop spin checking for each different thing that could be completed, is just asyncs you've rolled yourself.
@Daktyl198
@Daktyl198 25 күн бұрын
The small binary size and easy setup/access is what makes SQLite popular, not its synchronous nature. It’s super easy to ship with your own code and doesn’t need to run the entire time your application is running like other DBs.
@RogerValor
@RogerValor 25 күн бұрын
you can just run an async loop controlled from a synchronous environment, or even sync it out, if you need, but because async does not mean it is parallelized, i would beg to differ to it just being another db, as most databases you would use over the network, which makes them independent processes. Especially single processor implementations should benefit from async in the long run, in the end it just abstracts task switching inside your process in a syntactic way.
@bjorgemeulemeester1398
@bjorgemeulemeester1398 2 күн бұрын
Right, I thought the lack of async and networking was exactly why sqlite is applicable in ways others are not
@username7763
@username7763 Ай бұрын
One very nice thing about sqlite is that it will compile on a large number of C compilers. This includes compilers available for older platforms, or embedded or more specialized use. Not everyone is running the latest MacOS / Windows / Linux. Rust is llvm compiler only and is available for far fewer platforms. Maybe that doesn't matter to your project, but it does matter.
@user-sb5vt8iy5q
@user-sb5vt8iy5q Ай бұрын
llvm is basically available anywhere, it probably works on your smart fridge too
@hanifarroisimukhlis5989
@hanifarroisimukhlis5989 Ай бұрын
I mean, if you _really_ needs arcane embedded, you can use WASM as intermediate. Rust -> WASM -> machine code. Translating WASM instruction to machine code is _almost_ trivial.
@username7763
@username7763 Ай бұрын
I did some looking into it and there are far more llvm targets than I was aware of. They'll always be something that isn't supported, but I'm impressed at how much is.
@AlexMax2742
@AlexMax2742 Ай бұрын
@user-sb5vt8iy5q LLVM is absolutely NOT available for everything. GCC is the most widely compatible compiler out there, and even then there are many targets where your only option is an ancient in-house fork of GCC that will likely never see support for anything modern.
@TurtleKwitty
@TurtleKwitty Ай бұрын
@@hanifarroisimukhlis5989 Those working in proprietary platforms that get handed a proprietary compiler for c98 and nothing else is possible won't magically have a wasm compiler. There's probably a way to Rust -> WASM -> Ancient C -> machine code but that's one hell of a build chain and you're better off using sqlite thats been tested in ancient c from the start
@augustdahlkvist3998
@augustdahlkvist3998 Ай бұрын
Everybody is gangsta until their favourite library gets rewritten in rust
@NotAFanMan88
@NotAFanMan88 Ай бұрын
if it exists, there will be a Rust version of it.
@thegrumpydeveloper
@thegrumpydeveloper Ай бұрын
Unless it’s written in go
@floridaman964
@floridaman964 Ай бұрын
@@thegrumpydeveloper BASED
@my_online_logs
@my_online_logs 29 күн бұрын
​@@skulversaid from a stupid nonsense
@gbube054
@gbube054 27 күн бұрын
​@@skulver😂
@2loafabread
@2loafabread Ай бұрын
Elevator pitch: I am upset there are so many different SQL type syntaxes I've learned to use throughout the years... so lets just make fun of this first world problem with a new syntax called: YASS - "Yet another SQL syntax"
@LutherDePapier
@LutherDePapier Ай бұрын
Yass.
@TheCommunistRabbit
@TheCommunistRabbit Ай бұрын
💅🏻
@worldspam5682
@worldspam5682 Ай бұрын
YASS - Your ASS
@thesenamesaretaken
@thesenamesaretaken Ай бұрын
YASS I assume is short for YASS (ain't) SQueenL slay
@smort123
@smort123 Ай бұрын
"There are 14 different SQL syntaxes. We need to make one to combine the best of all of them!" "There are now 15 competing SQL syntaxes."
@mrpocock
@mrpocock Ай бұрын
It will be interesting to see how they do the very core indexing data structures in rust. My understanding is that to make databases work well, they use very unsafe structures!
@da40au40
@da40au40 Ай бұрын
This is very interesting now you've commented it.
@giorgos-4515
@giorgos-4515 Ай бұрын
unsafe is not inherently bad it is required for core stuff, it just indicates that more attention is required
@mrpocock
@mrpocock Ай бұрын
@@giorgos-4515 yes, but some of the index datastructures support things like multiple readers during multiple updates, various skip and bidirectional pointers, and other crazy things that are inherently non rusty. It is possible there are other ways to do it that are more rust friendly. Database guts are not my happy place.
@ClimateChangeDoesntBargain
@ClimateChangeDoesntBargain Ай бұрын
@@mrpocock mpmc channels support that as well in Rust
@shadergz
@shadergz Ай бұрын
It's faster cause it doesn't have 1/3 of the SQLite features...
@mysterry2000
@mysterry2000 Ай бұрын
Tbf I don't mind having a less feature-rich, faster software over a bloated one, as long as the basic features are around
@_Verac
@_Verac Ай бұрын
@@shadergz How so as they're fork of it with backward merge so they should have all its features plus some more?
@TheRealCornPop
@TheRealCornPop Ай бұрын
​@@mysterry2000What's bloated about sqlite? Limbo doesn't even have the basics yet. It's currently unusable and a wip
@aqua-bery
@aqua-bery Ай бұрын
​@@TheRealCornPop how can it not have features if it's a fork?
@paxcoder
@paxcoder Ай бұрын
@@mysterry2000 Until you need that one feature?
@tate_rs
@tate_rs Ай бұрын
We should make a page like the js framework one "Days Since Last Rust Rewrite" (I'm a Rust dev myself but this is kinda getting out of hands)
@monsterhunter445
@monsterhunter445 Ай бұрын
Is it gettign of hand? Sqlite in rust makes sense.
@comradepeter87
@comradepeter87 Ай бұрын
This _is_ the kinda software that actually makes sense in Rust though. Front-end frameworks in Rust is where I'd say it becomes a bit unnecessary (I'm a hypocrite in this sense because the only mildly serious UI I've ever written is a web extension who's UI and logic is both in Rust).
@HYDROGEN_OS
@HYDROGEN_OS Ай бұрын
its make sense, rust enforce safety whether the progammer is junior skill, medium skill, or senior skill where c++ will be crazy in junior skill programmers
@tate_rs
@tate_rs Ай бұрын
Don't get me wrong, i'm part of this rust rewriting community but i just find it funny. I also do agree it makes total sense regarding the speed and safety. It will just take some time till it's somewhat usable in production.
@MiaChillfox
@MiaChillfox Ай бұрын
Just make it a static html page stuck on 0 days. It will always be correct.
@thtcaribbeanguy
@thtcaribbeanguy Ай бұрын
primeagen is messing with my OCD when he highlights perfectly each time everything except the first letter and last letter!!!!!!!!!!!!!!!!!
@nathanfranck5822
@nathanfranck5822 Ай бұрын
It's how he aim trains
@thtcaribbeanguy
@thtcaribbeanguy Ай бұрын
@@nathanfranck5822 normally my OCD is not that strong anymore but it triggered by it. but since he doing it to train himself , question i have now why?
@amsyarasyiq
@amsyarasyiq Ай бұрын
i used to get annoyed by that too, but i slowly get used to it
@thesenamesaretaken
@thesenamesaretaken Ай бұрын
​@amsyarasyiqDoctor Primeagen or How I Learned to Stop Worrying and Love the Autistic Compulsion
@monad_tcp
@monad_tcp Ай бұрын
that's an entire new level of OCD that you need to unlock
@seanwoods647
@seanwoods647 Ай бұрын
Deterministic Testing is not the same thing as 100 branch testing. The aircraft industry demands that every possible branch in the code is exercised in testing. Sqlite's current test suite does that. Also chaos monkey/gorilla/kaiju isn't really applicable to an embedded database.
@platin2148
@platin2148 21 күн бұрын
Well you will get the argument that rust doesn‘t need that as its so perfect and beautiful. The reality is it breaks apart in an instant and currently there isn‘t any avionics certified compiler similar to automotive where they reached certification but still don‘t have a ISO for the language as such can‘t be used in SIL.
@BrettW
@BrettW Ай бұрын
Im here so fast I must be written in Rust.
@albizutoday2754
@albizutoday2754 Ай бұрын
@@BrettW And you need a Code of Conduct!
@_kostant
@_kostant Ай бұрын
If you were written in rust you would’ve been much slower to comment and would not have missed the apostrophe.
@gg-gn3re
@gg-gn3re Ай бұрын
@@_kostant hahah owned
@ClimateChangeDoesntBargain
@ClimateChangeDoesntBargain Ай бұрын
@@_kostant why would he have been slower? And Rust doesn't prevent logic bugs, so the missing apostrophe aligns with Rust.
@chrisdaman4179
@chrisdaman4179 Ай бұрын
@ClimateChangeDoesntBargain He would still be in development for another 4-5 years, and then get dropped because the basement coders working on it would have gotten tired and moved on well before 0.7 release.
@oflameo8927
@oflameo8927 Ай бұрын
I am fine with SQLite keeping out posers, it keeps the project from inflating to nonsense.
@mberlinger3
@mberlinger3 Ай бұрын
As a business engineer it's hard to hear Squeal. I've only heard SQL or Sequel never Squeal 🐷
@HerbieBancock
@HerbieBancock Ай бұрын
The people who know what they're doing/talking about don't have time to make these shitty videos.
@gariklaw
@gariklaw Ай бұрын
Why pronounce 3 or 2 syllables when 1 will do? Blame Fireship? kzbin.info/www/bejne/aoKxYnWwratrra8
@monad_tcp
@monad_tcp Ай бұрын
Sequel is only for Sequel Server, which is Sybase, I mean, Microsoft SQL Server. If its any other mere relational database, then its squeal. There's an exception for oracle, if its Oracle, then its pronounced SQL esse, queue, el. because Oracle is boring.
@rezah336
@rezah336 2 күн бұрын
what is a business engineer?
@zappellin2398
@zappellin2398 Ай бұрын
I read somewhere that you can access the SQLite test suite, but you need to be a contributor and that require a screening process or that you are a big company willing to provide contributions
@seanwoods647
@seanwoods647 Ай бұрын
And not, say, a hacker looking to find exploits.
@reybontje2375
@reybontje2375 Ай бұрын
I'm thrilled if this can evolve into a maintained project. There are so many cool embedded databases in Rust, but they also generally don't have a stable file format or become abandoned adter a few versions. I basically am stuck with RocksDB as the best worst choice.
@xpusostomos
@xpusostomos Ай бұрын
Presumably the file format is stable since they're copying.
@RobertFletcherOBE
@RobertFletcherOBE 28 күн бұрын
You should try SQLite, its well maintained, incredibly stable, and free of the bloat you usually see in design by committee projects
@xpusostomos
@xpusostomos 28 күн бұрын
@@RobertFletcherOBE one might argue sqllite is mostly bloat... The people who tend to use it have to wrap the SQL into some kind of object relational interface, to save their objects into somewhere. So a ton of code is written to convert what you want to do into SQL, then sqllite has a ton of code to turn SQL back into a set of fields to store.
@MaxTechEngineering
@MaxTechEngineering Ай бұрын
That lib file with the unsafe is just the bindings, not the core code. Any ffi is fundamentally unsafe since the compiler can’t control what outside callers are doing.
@platin2148
@platin2148 21 күн бұрын
So everything is unsafe until you make one gigantic monolithic binary which contains even the uefi code and all the stuff for the nvm controllers rtos as well as any server switch or anything you can connect to.
@allesarfint
@allesarfint Ай бұрын
Prime forgot to mention Chaos Grizzly, which goes a step further and kills the entirety of Netflix.
@thewhitefalcon8539
@thewhitefalcon8539 29 күн бұрын
Isn't that just called the CEO?
@h7hj59fh3f
@h7hj59fh3f Ай бұрын
i miss the dyslexic title of this video 😭
@redyau_
@redyau_ Ай бұрын
What was it??
@apolmedrano3914
@apolmedrano3914 Ай бұрын
@@redyau_^^
@kreuner11
@kreuner11 Ай бұрын
Maybe the rust rewrite in sqlite?
@avwie132
@avwie132 28 күн бұрын
The premise on why to rewrite basically is: we have a fuck ton of VC money and don’t know what to do with it. They claim the drawback of SQLite is proprietary testing code but as a solution they are going to use proprietary testing code. They claim modern architectures but support less architectures than SQLite.
@PakRoc-dev
@PakRoc-dev Ай бұрын
I'll take the database protected by the Rule of St. Benedict, thanks.
@Margen67
@Margen67 Ай бұрын
birb
@jacekkurlit8403
@jacekkurlit8403 Ай бұрын
Can you elaborate on that? Which db is protected by Rule of St. Benedict?
@monad_tcp
@monad_tcp Ай бұрын
specially because that trigger some "liberaloids"
@aciesara5444
@aciesara5444 29 күн бұрын
@@jacekkurlit8403 For the context, you can search "sqlite code of ethics" in search engine. It should be the first result from offical sqlite website.
@mskiptr
@mskiptr 29 күн бұрын
@@jacekkurlit8403 SQLite is famous for being quite unique. While it is Open Source, it is Free Software and it is even (meant to be) public domain, it is not really developed in the open. As in, it is not generally open to external contributions. Unlike most FOSS projects nowadays it is not developed on GitHub nor on any other competing forge. In fact the devs don't even use Git for it, but a custom revision control system called Fossil. > In order to keep SQLite completely free and unencumbered by copyright, the project does not accept patches. If you would like to suggest a change and you include a patch as a proof-of-concept, that would be great. However, please do not be offended if we rewrite your patch from scratch. [1/3]
@eltreum1
@eltreum1 Ай бұрын
An educational exercise or self-torture. I bet the word "unsafe" appears often in the repo.
@dataolle
@dataolle Ай бұрын
Are they planning on doing the Safety critical stuff with DO-178b and testing all branches?
@georgecrisan9499
@georgecrisan9499 Ай бұрын
so nice you approached this on a serious manner
@toastcereal
@toastcereal Ай бұрын
8:16 got a link for the TigerBeetle talk?
@HickoryDickory86
@HickoryDickory86 8 күн бұрын
I guess we should think of it like a game-of-the-year remaster. I remaster of the base game, but with all the DLCs also remastered and bundled with it.
@RogerValor
@RogerValor Ай бұрын
we really dont need sqlite reimplemented in a C variant, it is fine if it is in rust, as it allows to have a clean rust alternative to bindings, so i am glad they stayed on track.
@worldspam5682
@worldspam5682 Ай бұрын
dude, it's a db. What in the name of purist zealot is this?
@RogerValor
@RogerValor 25 күн бұрын
@@worldspam5682 the idea is that you can easier integrate something in rust, that is compiled in the same ecosystem, which can play to the strengths of rust, being easier to compile on different target systems. integrating sqlite on windows e.g. is a lot of work. This notion, that everything related to rust must be some kind of zealotry is it's own kind of zealotry by now. having a database installable by cargo will ease a lot of development, also in the python or js world, which they obviously also go for.
@worldspam5682
@worldspam5682 25 күн бұрын
@RogerValor I'm really tempted to 🤡 on someone, who tells that integrating SQLite is some kind of a problem, and so it needs to be rewritten in rust. Somehow others are completely fine, but rust even here got to be a special kid.
@TeDynef
@TeDynef Ай бұрын
This will be pain in the ass with 3 implementations of sqllite which are not feature identical... The same shit was done to the sass precompiler and now you have to lookup the correct software to just precompile css. Great... Just name it different...
@tomorrow6
@tomorrow6 Ай бұрын
Everything rewritten in rust will eventually be rewrittten in stainless.
@elau1004
@elau1004 Ай бұрын
There some know "issues" with SQLite but due to the large installed code base they decided that it is a feature to keep it backwards compatible. Will Limbo keep compatible with these know "issues".
@roccociccone597
@roccociccone597 Ай бұрын
Yeah I've been investigating DST at work. It sounds cool I just gotta get used to testing like that...
@alst4817
@alst4817 Ай бұрын
Everything rewritten in Rust will eventually be re-rewritten in Lisp
@monad_tcp
@monad_tcp Ай бұрын
YES !!!
@RustIsWinning
@RustIsWinning 28 күн бұрын
NOO !!!
@alst4817
@alst4817 28 күн бұрын
@@RustIsWinning (come (to the dark) side)
@interfleshtv
@interfleshtv Ай бұрын
The esoteric becoming mainstream through influence = paradigm shift
@grok_coder
@grok_coder Ай бұрын
when did we even accept squeal for SQL
@ryanb509
@ryanb509 Ай бұрын
I think Chaos Godzilla would be to simulate an entire cloud provider going down if they ever went with a multi cloud deployment.
@ceigey-au
@ceigey-au 29 күн бұрын
I saw the thumbnail and thought “I hope they’re working with the Turso/LibSQL team”. And I guess they are!
@Wizatek
@Wizatek 29 күн бұрын
I don't understand why they keep trying to make Rust happen, it won't..
@my_online_logs
@my_online_logs 29 күн бұрын
said a kid who doesn't know anything about low level. everyone outside uses logic not like you who use subjective personal moron. it happened long before, microsoft, google, aws, discord have migrated to rust in their core system. because they use logic not like junior c and c++ kid. writing good rust is far easier than writing good c and c++. in c and c++ will add time spending time just for debugging, in rust is far far less, fact and it has happened because people know the value, only people who don't understand don't know the value because they don't understand how can they know
@RustIsWinning
@RustIsWinning 28 күн бұрын
Says the PHP skid 😂
@wallacecarvalhoo
@wallacecarvalhoo Ай бұрын
Ativa a dublagem automática dos seus vídeos broher! Seus vídeos são ótimos, obrigado pelo trabalho, abraço!
@bertram-raven
@bertram-raven Ай бұрын
Now I know what to call the testing paradigm I have been using since 1997. DST.
@geoffl
@geoffl Ай бұрын
sqlite is one of the best codebases available. I question this company's priorities to rewrite something that is already excellent.
@tomorrow6
@tomorrow6 Ай бұрын
The only way from excellence is down
@maf_aka
@maf_aka Ай бұрын
the closed source nature prevents natural extension of the project (vector db, wasm, etc.). did you not watch the video?
@kuhluhOG
@kuhluhOG Ай бұрын
yeah, one would think they have other dependencies which they would focus on first
@famshare-esl2453
@famshare-esl2453 26 күн бұрын
@@tomorrow6 Said the person trapped in the medieval era.
@dewaldesterhuysen712
@dewaldesterhuysen712 Ай бұрын
The issue is that they are rewriting it for computer use but a large part of SQLite is how well it works one embedded. On some embedded projects even C++ is to resource inefficient compared to C. I doubt Rust will be as efficient with ram as C is
@theultimateevil3430
@theultimateevil3430 Ай бұрын
Can't you just write C++ without C++ features that introduce tons of indirection, and in a data-driven manner to minimize copying/allocations?
@oserodal2702
@oserodal2702 Ай бұрын
Rust is as efficient on RAM as C is, if not even more since a lot of conventions in C is the passing of object heap pointers. Unlike in C where resources (in this case, memory) have non-deterministic lifetimes, Rust has an explicit destructor called et the end of each scope.
@galbatrollix5125
@galbatrollix5125 Ай бұрын
@@theultimateevil3430 You can. C with templates can be written just fine. Though C++ forces malloc casts which can be really annoying.
@lennymclennington
@lennymclennington Ай бұрын
C++ isn't "too resource inefficient compared to C". Shows you have no idea what you're talking about when you frame it like that. What in C++ has an inefficient memory layout compared to the equivalent in C? If you need to perform whatever task in C or C++, you're still doing the same stuff. If you make inefficient design choices then that's on you, not on the language.
@dewaldesterhuysen712
@dewaldesterhuysen712 Ай бұрын
@@theultimateevil3430 Yes you can, which is not a bad idea since you will always have the option to make use of an expensive functionality if you have resources left.
@cg219
@cg219 Ай бұрын
how do you perform DST?? Is there a video on that?? Like practically
@Satook
@Satook 6 күн бұрын
One comment re. The “Tiger Beatle made deterministic simulation famous”. I read articles over 20 years ago about Age of Empires 2, Quake 3 and other games that used of simulation testing. How else were you going to test your network replication logic?
@Spaztron64
@Spaztron64 Ай бұрын
Fitting title for where your data will end up :)
@sebastienlehmstedt772
@sebastienlehmstedt772 Ай бұрын
Serious talk, what is the difference between "full deterministic testing" and unit testing ? It seems that the term unit testing is still today a lot misunderstood.
@andreffrosa
@andreffrosa 28 күн бұрын
It's just integration testing with a fancy name, running in a simulator
@sebastienlehmstedt772
@sebastienlehmstedt772 28 күн бұрын
@andreffrosa Yeah, this is what I thought
@famshare-esl2453
@famshare-esl2453 26 күн бұрын
It's a form of fuzzing. Specifically, it seems to be fuzzing applied at the level of the system running the code. So searching through not just the formal input space to the code but through the environment space. That said, it seems, like most computer terms, that its effective definition will depend on what mix of theory and practice is settled on. As even with simpler version of fuzzing and property testing how you generate inputs is a complicated subject.
@wing-it-right
@wing-it-right Ай бұрын
i am watching this on the side like squirrel what?
@m.irfan-7069
@m.irfan-7069 Ай бұрын
From build everything with javascript to rewrite everything with rust
@my_online_logs
@my_online_logs 29 күн бұрын
there is nothing wrong with rewriting in rust, its their choice and their own project (forked) why you cry? rust give many benefits, cry more.
@m.irfan-7069
@m.irfan-7069 28 күн бұрын
@@my_online_logs ??? You can rewrite anything as you like, no one stops you
@my_online_logs
@my_online_logs 28 күн бұрын
@@m.irfan-7069 reread your comment kid, suct a nonsense hater, no logical thinking because this is far higher from your brain level that never touch complex low level code
@DM-pg4iv
@DM-pg4iv Ай бұрын
You have any resources for simulation testing? How to get started? I can't find anything
@Shri
@Shri Ай бұрын
Prime you have stopped looking at the cam these past few videos. What's up with that? Your earlier videos, your eyes were level with the cam. Something's up with the setup my friend!
@_Verac
@_Verac Ай бұрын
They had to go with the devil as the logo.😂
@tylercoffman540
@tylercoffman540 Ай бұрын
Looks more like a bull to me.
@tikabass
@tikabass 26 күн бұрын
Rewriting the best maintained, tested and running software library in another language? This is pure madness, and is asking for trouble. I'd rather go with the fully tested FAA-certified C project, any day of the week.
@RustIsWinning
@RustIsWinning 24 күн бұрын
@@tikabass Ah yes "best maintained". How many other imaginary tiltles did boomers invent for themselves. Here is a star ⭐️ HAHAHA 🤣
@tikabass
@tikabass 24 күн бұрын
@@RustIsWinning It is the best maintained. It has to be, as it has to be fit for running in NASA, Airbus and Boeing vehicles. These companies pay a lot of money for that. And that's the reason why SQLite development and testing is not open to the Rusty public.
@RustIsWinning
@RustIsWinning 24 күн бұрын
@@tikabass Ah thanks for explaining it. Learned something new. A rewrite would probably not help those companies but Turso's DST approach is still interesting tbh.
@tikabass
@tikabass 24 күн бұрын
@@RustIsWinning A rewrite does not help anybody, and the time could be used to write something new and useful. But, that's apparently uncool in the Rust community, they'd rather let the innovation to the C/C++ people. In my humble experience, rewriting code is good when learning, as an exercise for the debuting student. And the resulting code should NOT be meant to used by the public at large.
@tiranito3715
@tiranito3715 21 күн бұрын
@@RustIsWinning Bro everywhere I see you, you always spout some nonsense and get owned, rather than going around yelling at anyone who disagrees with you, how about you actually inform yourself first? you literally came here to shit on SQLite without even knowing what it is? bruh
@9nr
@9nr Ай бұрын
Squill makes me cringe, every single time
@modolief
@modolief Ай бұрын
Pro tip for Finnish names: You say the double consonant *twice.* So "Pekka" is not PEKA, but PEK-KA. Accent on the first syllable.
@RustIsWinning
@RustIsWinning 28 күн бұрын
Perkele
@modolief
@modolief 28 күн бұрын
@@RustIsWinning 😆😆😆
@Mtylgd
@Mtylgd Ай бұрын
The 3 maintainers of SQlite: 1. NSA 2. CIA 3. FBI
@da40au40
@da40au40 Ай бұрын
Lol😂
@worldspam5682
@worldspam5682 Ай бұрын
sounds more like a rust thing, as this cult is just like those cults that were controlled by cia...
@modestas3d391
@modestas3d391 Ай бұрын
And people also use SQLite as database when integration testing apps that have MS SQL or MySQL in the back that behave differently and shit happens after deployment, when some ORM translated query was not understood xD
@RaaynML
@RaaynML Ай бұрын
Some part of me feels this rewrite culture is futile. We are fundamentally flawed, the language we write in, at best, only prolongs our mistakes, and at worst, masks them until they are debilitating. I can absolutely see the usefulness in small projects, but if a human can take a shortcut, they eventually will, regardless of how high the wall TO the shortcut is built.
@0rmai
@0rmai 16 күн бұрын
First time I heard him say sequel instead of squeal
@rjScubaSki
@rjScubaSki Ай бұрын
Really find promoting Zig over Rust for this completely incomprehensible
@maniacZesci
@maniacZesci Ай бұрын
Database in language that is not stable yet. Remember he thinks Linux kernel should have used Zig too. People take these KZbin pundits way to seriously.
@TheCommunistRabbit
@TheCommunistRabbit Ай бұрын
Them zigooners
@araarathisyomama787
@araarathisyomama787 Ай бұрын
@@maniacZesci I don't remember it that way. I took it as "It's too bad Zig didn't come up 10 years earlier, so that it'd have a chance to compete with Rust in Linux project" which I think is a completely reasonable way to think about this. Though, I'm not sure if it's actually my opinion that clarified when I watched the stream or me filtering his streamer language. He's a zigooner though ngl.
@maniacZesci
@maniacZesci Ай бұрын
@@araarathisyomama787 Now I'm not sure either. I don't remember him saying that 10 years earlier part but I might be wrong.
@jlp2011
@jlp2011 27 күн бұрын
are they gonna add a native date type?
@neerajrajpal
@neerajrajpal Ай бұрын
Here before the title change o7
@a_rugau
@a_rugau Ай бұрын
Hey was waiting for you to talk about that!
@odishosamano5663
@odishosamano5663 Ай бұрын
Someone should rewrite this job market with rust.
@geoffl
@geoffl Ай бұрын
any speculation on on causes of network delays for the tyson vs. jake paul fight?
@thehumbledeveloper4427
@thehumbledeveloper4427 Ай бұрын
Yup, time for a Python dev to learn everything rust 🤘😎
@dezly-macauley
@dezly-macauley Ай бұрын
I'm starting to wonder who is more. Unhinged.... The average JS/React dev or the average Rust dev
@JeremiLorenti
@JeremiLorenti Ай бұрын
I'm only 15 seconds in, and I already want to Pekka Prime's Glauber
@I_am_who_I_am_who_I_am
@I_am_who_I_am_who_I_am Ай бұрын
where does libsql fit in?
@albizutoday2754
@albizutoday2754 Ай бұрын
Thats a new license, you rewrite it in Rust and it’s yours! ⭐️
@RustIsWinning
@RustIsWinning 28 күн бұрын
Thanks! Will put that to all the other stars that we have...
@KangJangkrik
@KangJangkrik 29 күн бұрын
So what next? Rewrite Laravel in Rust?
@kodosunofficial_5
@kodosunofficial_5 25 күн бұрын
Rewrite linux kernel in rust
@KangJangkrik
@KangJangkrik 25 күн бұрын
@kodosunofficial_5 already in progress lol
@monad_tcp
@monad_tcp Ай бұрын
1:54 no languages are actually memory safe. The only thing proven to be memory safe is HyperVisors and the actual hardware virtualization on some platforms (IBM mainframes, not Intel/AMD, sorry). (its memory safe when its inside a virtual machine)
@my_online_logs
@my_online_logs Ай бұрын
said from a kid
@johndoe2-ns6tf
@johndoe2-ns6tf 29 күн бұрын
@@my_online_logs why are your answers and writing so similar to @HYDROGEN_OS?
@RustIsWinning
@RustIsWinning 28 күн бұрын
HyperV and "safe" LOL. So vm escapes dont exist hahaha
@lutfiikbalmajid
@lutfiikbalmajid Ай бұрын
database is getting bigger. meanwhile me, using json and fs. Phew
@test-y1p7r
@test-y1p7r Ай бұрын
This Rust rewrite pandemic needs to be tamed.
@edhahaz
@edhahaz 20 күн бұрын
We need a word for: software rug pull as an initially open source service
@daviyen
@daviyen Ай бұрын
That Microsoft team btw was Excel.
@pxkqd
@pxkqd Ай бұрын
How complete is it?
@adudeandacat
@adudeandacat 21 күн бұрын
Why does he always highlight everything but the first and last letter of selected text?
@HedgehogGolf
@HedgehogGolf 29 күн бұрын
Is the Limbo cover art just AI generated? I can't find a credit for the artist anywhere and the background texture is weird
@tiranito3715
@tiranito3715 21 күн бұрын
it is indeed AI generated, just like the code.
@fluxcaruso345
@fluxcaruso345 Ай бұрын
At this point, i should rewrite myself in rust
@HomeEngineer-wm5fg
@HomeEngineer-wm5fg Ай бұрын
Keep the free nature of SQLite, completely free in all aspects and I am sold!
@freeideas
@freeideas Ай бұрын
I wonder why zig was rejected in favor of rust? Usually you hear the other way around, e.g. "it became super difficult with rust, so we switched to zig".
@freeideas
@freeideas Ай бұрын
As a corollary to my question, I wonder if the following statement is true: "anything you can write in rust, you can write the exact equivalent code in zig, translating almost line-for-line... but the reverse, of course, is not true".
@smile4cs
@smile4cs Ай бұрын
id imagine rewriting something in Rust wouldn’t be too hard (compared to writing something new), since you would already know exactly what you’re building.
@hanifarroisimukhlis5989
@hanifarroisimukhlis5989 Ай бұрын
Zig isn't 1.0 yet, so...
@ClimateChangeDoesntBargain
@ClimateChangeDoesntBargain Ай бұрын
@@freeideas you are probably talking about Rust without unsafe, as you can write anything in Rust
@oserodal2702
@oserodal2702 Ай бұрын
Tsoding : "The typical zigooner..."
@TheRich107
@TheRich107 Ай бұрын
Ashes to ashes rust to rust
@MattJoinerPwns
@MattJoinerPwns 28 күн бұрын
I work with sqlite in multiple languages and multiple libraries and can say that the I/O in sqlite is the biggest bottleneck. This rewrite seems like the real deal
@robchr
@robchr Ай бұрын
DST sounds a lot like property based testing which has been around for along time.
@xdzzz0
@xdzzz0 27 күн бұрын
Similar idea but still different angles/philosophy! We use PBT at my company. DST, from what I can grok, runs a simulation of a process in an end-to-end fashion with a set of randomized initial conditions & the output of the process should be expected to be reproducible every time with same ICs. Whereas PBT randomizes various properties/states (not necessarily ICs) in a process in a shotgun-like fashion for edge-case discovery. DST seems a more "linear" approach? Which makes it easier to identify exactly where/how things went wrong. PTB on the other hand just tells you something broke "at this point, with this state" but doesn't necessarily tell you how you get into that state.
@LutherDePapier
@LutherDePapier Ай бұрын
"If I were to get a real job again..." 😂😂😂
@InternetKilledTV21
@InternetKilledTV21 Ай бұрын
I've been kind of inclines to say "go with rust" for the real-world benefits rust brings plus a little bit of I want to see a Mozilla W streak
@asmod4n
@asmod4n Ай бұрын
How did they solve the issue that you cant use async rust with io_uring?
@HYDROGEN_OS
@HYDROGEN_OS Ай бұрын
lmao since when rust cant use async in io uring lol, compio is one of io uring based async runtime, lmao
@asmod4n
@asmod4n Ай бұрын
@@HYDROGEN_OS the type system of rust aint capable of safely using io_uring. it makes all kinds of assumptions which io_uring broke.
@HYDROGEN_OS
@HYDROGEN_OS Ай бұрын
@@asmod4n you are totally wrong. many io uring async runtime exist, tokio, compio, glomio, etc, and they are all safe unlike c/c++.
@asmod4n
@asmod4n Ай бұрын
@@HYDROGEN_OS rust makes the assumptions all syscalls happen in userspace and immediately return their result. io_uring doesn't work that way. you cant use async await with io_uring till rust is patched for that. you are leaking file descriptors all over the place and no crate can solve that, it has to be solved on a type system level. Rust Futures are not capable of handling io_uring doing syscalls in a kernel thread out of control of rust. look here: github.com/ethe/io-uring-is-not-cancellation-safe/blob/master/src/main.rs
@asmod4n
@asmod4n Ай бұрын
@@HYDROGEN_OS just search for io_uring is not cancellation safe with rust.
@krunkle5136
@krunkle5136 Ай бұрын
Yes, more code that's exponentially hard to dive into unless you're an AI (eventually).
@ragectl
@ragectl Ай бұрын
Chaos Godzilla should be Netflix losing an entire country in the Pacific like Japan 😂
@vlknckl
@vlknckl Ай бұрын
I wonder how they provide async support on Mac, Linux and Windows because iouring is pretty messy and different on all of this platforms
@vlknckl
@vlknckl Ай бұрын
I don't even know if there is any rust crate that provide iouring support on Mac
@HYDROGEN_OS
@HYDROGEN_OS Ай бұрын
most of io_uring based async io runtime in rust are already support windows and linux. and there is one that i know is completed cross platform io_uring based async io runtime in rust, its compio. it supports linux, windows, and mac completely
@HYDROGEN_OS
@HYDROGEN_OS Ай бұрын
​@@vlkncklthere is, compio supports linux, windows, and mac completely.
@HYDROGEN_OS
@HYDROGEN_OS Ай бұрын
​​@@vlknckleven rust has cross platform native GUI async library, named winio in which IO operations and GUI coexist in one thread without blocking each other, it also uses compio with uses io_uring
@HYDROGEN_OS
@HYDROGEN_OS Ай бұрын
​@@vlknckleven rust has cross platform native GUI async library, named winio in which IO operations and GUI coexist in one thread without blocking each other, it also uses compio with uses io_uring
@ambhaiji
@ambhaiji Ай бұрын
1:57 I don't mind that color scheme
@VolodymyrMoon
@VolodymyrMoon Ай бұрын
Have heard about RocksDB?
@LutherDePapier
@LutherDePapier Ай бұрын
Twitch comments literally went "Hawk tuah." 😂😂😂😂
@YvesBlatti
@YvesBlatti Ай бұрын
Chaos Godzilla is implemented at Meta (BGP)
@Freshbott2
@Freshbott2 Ай бұрын
Can’t wait for SQLite written in Mojo.
@my_online_logs
@my_online_logs 29 күн бұрын
there is nothing wrong with rewriting in rust, its their choice and their own project (forked) why you cry? rust give many benefits, cry more.
@johndoe2-ns6tf
@johndoe2-ns6tf 29 күн бұрын
@@my_online_logs did you run out of meds?
@my_online_logs
@my_online_logs 29 күн бұрын
@johndoe2-ns6tf do you need tissue? 🤭🤭
@Freshbott2
@Freshbott2 29 күн бұрын
@@my_online_logs Hu cry? U cry.
@my_online_logs
@my_online_logs 29 күн бұрын
@johndoe2-ns6tf kep crying 🤭
@MohamedNasserGubran
@MohamedNasserGubran Ай бұрын
please please .. STOP saying "squeal" !! I'll accept "sequel". I'll accept "es kew el". But not "squeal". Absolutely abhorrent
@ThePandaGuitar
@ThePandaGuitar Ай бұрын
Speaking of Spolksy, Things You Should Never Do, Part I never felt more relevant.
@xpusostomos
@xpusostomos Ай бұрын
Squeal lite? Not sequel lite?
@nikitasavelyev9171
@nikitasavelyev9171 Ай бұрын
Why is ffmpeg unhinged?? What did I miss?
@worldspam5682
@worldspam5682 Ай бұрын
It's not written in rust)
MircroServices (and a story about Netflix) | Prime React
14:22
ThePrimeTime
Рет қаралды 255 М.
Why Your Backend Shouldn't Serve Files
19:40
Boot dev
Рет қаралды 76 М.
coco在求救? #小丑 #天使 #shorts
00:29
好人小丑
Рет қаралды 120 МЛН
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 81 МЛН
$2 Gaming Setup
12:28
schvabek
Рет қаралды 1,3 М.
Interview With Sr Rust Developer | Prime Reacts
15:01
ThePrimeTime
Рет қаралды 640 М.
i dove down the 7z rabbit hole (it goes deep)
12:50
Low Level
Рет қаралды 612 М.
The Worst Kind Of Programmer
19:15
ThePrimeTime
Рет қаралды 589 М.
All Rust string types explained
22:13
Let's Get Rusty
Рет қаралды 196 М.
Why More People Dont Use Linux
18:51
ThePrimeTime
Рет қаралды 347 М.
I spent six months rewriting everything in Rust
15:11
chris biscardi
Рет қаралды 451 М.
The Perfect Dependency - SQLite Case Study
19:32
Tom Delalande
Рет қаралды 81 М.
The Secret Language Scaling WhatsApp and Discord
28:32
Theo - t3․gg
Рет қаралды 187 М.