Sabitlenmiş Tweet
Was trying to update sqlite version for Turso and add more tests, and somehow ended up finding 3 optimizer bugs in SQLite. Wasn’t expecting that, but hey, I’ll take it.
English
Pavan-Nambi
89 posts
Pavan-Nambi
@pavan4820
GSoC 23 | Databases | https://t.co/5b1BzaKFVL
Katılım Ekim 2021
271 Takip Edilen112 Takipçiler
Pavan-Nambi retweetledi
Everywhere I go, people keep commenting on how wild it is that I have something working with us straight from *prison*.
Well, no longer.
Tomorrow, at 8 am in the morning, @PThorpe92 is a free man.
Preston is an inspiration to us all. He achieved so much from behind bars. I am sure he will go even higher as a free man.
English
@el_yawd 7... 😅 those 3 are quint specific, 3 optimizer bugs were found while working on turso(tursos test suite caught 1)
English
Pavan is really cooking here, he found what, 3/4 bugs in SQLite so far?
Pavan-Nambi@pavan4820
Quint helped finding a minor UB regression on trunk(not release) sqlite.org/src/info/7cd76… reported yesterday and fixed today
English
So far quint helped in finding a UAF(not security vuln), crash,UB
And that's in the hands of rather inexperienced person lol I wonder how much a experienced person in fm can do.
Pavan-Nambi@pavan4820
Quint helped finding a minor UB regression on trunk(not release) sqlite.org/src/info/7cd76… reported yesterday and fixed today
English
reported at sqlite.org/forum/forumpos…
I also ended up learning some misunderstandings I have around readonly and backup api, thanks to sqlite maintainers being quick and helpful.
English
Quint helped finding a minor UB regression on trunk(not release) sqlite.org/src/info/7cd76… reported yesterday and fixed today
Pavan-Nambi@pavan4820
Another crash found with quint fixed few hours ago. github.com/sqlite/sqlite/…
English
@pavan4820 Is the shadow model bugs related to fault determinism or just false implementations? We were discussing this a few months back, I think it’s a solvable problem and we should try to solve it if it’s causing significant problems with your workflows.
English
yeah, this has been my experience with turso's simulator too,
it's awesome when it works but chasing false positives is annoying. i have no idea how folks at tigerbeetle managed to do it so well lol.
Chris@criccomini
Spent the past week on SlateDB's DST harness. It was a bit of a slog. The more state I explored, the more false positives I encountered. rng.md/posts/determin…
English
@Keleesssss i meant - getting shadow model correct is hard and most of times i have to figure out if its a bug in sim or in database and it's time consuming when trying to get something like write-heavy/insert...selects as they take more time to just finish the run.(tl;dr skill issue)
English
Pavan-Nambi retweetledi
Total SQLite domination. Richard Hipp is the 🐐
Lewis Menelaws@LewisMenelaws
Posted a 30 minute documentary about how SQLite dominated the world. I even sat down with the creator (Richard) so he can share parts of the story we haven't heard about.
English
Pavan-Nambi retweetledi
Posted a 30 minute documentary about how SQLite dominated the world.
I even sat down with the creator (Richard) so he can share parts of the story we haven't heard about.
English
@criccomini @quint_lang xd you are the second person to tell me about fizzbee too @LeMikaelF is the first, perhaps i should checkout it.
English
@pavan4820 @quint_lang Second person to recommend quint to me! I have been a fizzbee fan.
English
Spent the past week on SlateDB's DST harness. It was a bit of a slog. The more state I explored, the more false positives I encountered.
rng.md/posts/determin…
English
@penberg @CorvusCrypto lol i saw aretta mentioned by mikael on github and been searching and can't find anything, thanks, this looks really interesting. (i am assuming he meant this? ) #issuecomment-4347126892" target="_blank" rel="nofollow noopener">github.com/tursodatabase/…
English
@CorvusCrypto Ageee, I am very curious to see what folks like aretta.ai are able to do to reduce the barrier of entry for formal methods
English
DST is hard, but I will probably never build software without it
Chris@criccomini
Spent the past week on SlateDB's DST harness. It was a bit of a slog. The more state I explored, the more false positives I encountered. rng.md/posts/determin…
English
Another crash found with quint fixed few hours ago. github.com/sqlite/sqlite/…
Pavan-Nambi@pavan4820
last week i was trying to learn more about quint and tried to use it for sqlite-c-api , it discovered a crash/UAF in sqlite (it exist since 2018) - this is fixed now in trunk sqlite.org/forum/forumpos…
English
Pavan-Nambi retweetledi
Pavan-Nambi retweetledi
Ghostty is leaving GitHub. I'm GitHub user 1299, joined Feb 2008. I've visited GitHub almost every single day for over 18 years. It's never been a question for me where I'd put my projects: always GitHub. I'm super sad to say this, but its time to go. mitchellh.com/writing/ghostt…
English
reminds me that i have 2 sim pr's i haven't completed since like 2 months now lol
Pekka Enberg@penberg
I did not realize that our Turso challenge at @algoraio has a slick leaderboard! Some familiar faces there... 😉 algora.io/challenges/tur…
English
motivation is- to learn about how to use quint and formal methods more but if we have a solid spec we can later apply it to turso's c-api and be more confident that we are not doing anything weird.
gh-repo github.com/Pavan-Nambi/sq…
this is obviously does not cover full c-api yet.
English
last week i was trying to learn more about quint and tried to use it for sqlite-c-api , it discovered a crash/UAF in sqlite (it exist since 2018) - this is fixed now in trunk
sqlite.org/forum/forumpos…
GIF
Pavan-Nambi@pavan4820
Was trying to update sqlite version for Turso and add more tests, and somehow ended up finding 3 optimizer bugs in SQLite. Wasn’t expecting that, but hey, I’ll take it.
English