avinassh

8 ms·

91.
by avinassh 2y ago
This looks great, how are you doing the benchmarks? It claims to be way faster than Redis. Can you also measure it against Microsoft Garnet? Whats the secret sauce for beating in latency? Redis: Write Latency ~1.1ms Read Latency ~
92.
Scunthorpe Problem(en.wikipedia.org)
3 points by avinassh 2y ago|0 comments
93.
by avinassh 2y ago
> But tables in PG are heaps, so appending to them is even faster than in b-trees. elaborate? how it is different, than say, MySQL?
94.
by avinassh 2y ago
Is there any introduction post on why one should use tmux OR what one is missing by not using them?
95.
It's probably time to stop recommending Clean Code(qntm.org)
7 points by avinassh 2y ago|0 comments
96.
by avinassh 2y ago
I am on both, but I actively use Bluesky (along with Twitter)
97.
Ask HN: What was the best research paper you read in 2024?
3 points by avinassh 2y ago|0 comments
98.
SQLite4 – SQLite on LSM Tree (2014)(sqlite.org)
2 points by avinassh 2y ago|0 comments
99.
by avinassh 2y ago
Larry always makes appearances in his reviews, lol > But the real big news in 2023 was how Elon Musk personally helped reset Larry's Twitter password after he invested $1b in Musk's takeover of the social media company. And wit
100.
Databases in 2024: A Year in Review(cs.cmu.edu)
625 points by avinassh 2y ago|209 comments
101.
by avinassh 2y ago
Both the words "Battleship" and "War ship" are used by DRH to describe USS Oscar Austin, so I used the same. I did not know about distinction, so TIL!
102.
by avinassh 2y ago
That sentence builds up on the previously mentioned sentence about types. > It is “weakly typed”. SQLite calls it “type affinity”. Meaning you can insert whatever in a column even though you have defined a type. Strong typed columns are
103.
by avinassh 2y ago
Both the words "Battleship" and "War ship" are used by DRH to describe USS Oscar Austin, so I used the same. I did not know about distinction, so TIL!
104.
by avinassh 2y ago
> OP is wrong, SQLite does match the requirements outlined in the OSI's definition: https://opensource.org/osd OSI also says Public Domain is not open source: Public Domain Is Not Open Source https://open
105.
by avinassh 2y ago
this is how SQLite page says: > Since SQLite is used extensively in every smartphone, and there are more than 4.0 billion (4.0e9) smartphones in active use, each holding hundreds of SQLite database files, it is seems likely that there ar
106.
by avinassh 2y ago
thank you for your kind words!
107.
by avinassh 2y ago
I have covered in the blog already, no? > Strong typed columns are opt-in. I will rephrase this
108.
by avinassh 2y ago
> The original source[0] (which you don't link to): this is simply untrue! This is the first link in the sources. I do highlight this part specifically in the image as well.
109.
by avinassh 2y ago
hey, I do provide all the sources at the end! In the initial draft, I kept links next to text and the images, but I didn't like it aesthetically. So I moved all them to the bottom.
110.
by avinassh 2y ago
> Recycled, old points in listicle format on a popular topic with questionable accuracy. Could you please state which are inaccurate? I am happy to correct them. As for the rest of the comment, well, I don't know what to say. I am a
111.
by avinassh 2y ago
I will try to rephrase it and include links to Wikipedia and OSI > As for whether SQLite is open source, well, the only reason a public domain dedication doesn’t meet the OSD is that it’s not a license. It’s more open. That's true a
112.
by avinassh 2y ago
oops, I fixed the typo. Thank you!
113.
by avinassh 2y ago
> The OP failed to mention that SQLite does have opt-in strict tables I did not, but probably I did not phrase correctly: > Strong typed columns are opt-in.
114.
Fun facts about SQLite(avi.im)
393 points by avinassh 2y ago|191 comments
115.
by avinassh 2y ago
> TLDR- - Position: Kneel on something raised (like a 6.5" platform), put your head lower than your stomach by resting it on your hands on the floor A picture would help me. Is there any name of this exercise so that I can Google?
116.
PostgreSQL Meets ScyllaDB's Lightning Speed and Monstrous Scalability(medium.com)
7 points by avinassh 2y ago|1 comments
117.
by avinassh 2y ago
hey could you let me know which part you found confusing specifically, so that I can rephrase it? Thanks!
118.
How bloom filters made SQLite 10x faster(avi.im)
504 points by avinassh 2y ago|121 comments
119.
It is becoming difficult for me to be productive in Python(avi.im)
2 points by avinassh 2y ago|1 comments
120.
by avinassh 2y ago
but they also have this: > 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 gre

More ›