avinassh

11 ms·

151.
by avinassh 2y ago
> I feel it's quite unfair for the title to call out sqlite on checksums, when in reality, as the very closing line of the article states most databases don't do checksum verifications. Hi, author of the post here. I work mostl
152.
Writing and Getting from Zero to Done(jack-vanlightly.com)
1 points by avinassh 2y ago|0 comments
153.
How the New Sqlite3_rsync Utility Works(nochlin.com)
5 points by avinassh 2y ago|1 comments
154.
DuckDB Is Not a Data Warehouse(materializedview.io)
4 points by avinassh 2y ago|0 comments
155.
by avinassh 2y ago
is there any page which explains how does Accelerate works? I am interested knowing the internal technical details
156.
by avinassh 2y ago
I love one Raindrop’s feature where it lets you bookmark all the tabs in a window
157.
by avinassh 2y ago
Hey! I am @avi.im I mostly post stuff about databases, distributed systems and my frustrations with Rust https://bsky.app/profile/avi.im
158.
How to create a custom memory allocator in Rust(brochweb.com)
2 points by avinassh 2y ago|0 comments
159.
by avinassh 2y ago
checkout Simon Willison's notes if you want to know how to get this running and try: https://til.simonwillison.net/sqlite/compile-sqlite3-rsync
160.
by avinassh 2y ago
related: any high level architecture details on how BlueSky uses SQLite per user?
161.
The Teacher's Nemesis(jack-vanlightly.com)
1 points by avinassh 2y ago|0 comments
162.
Hard Mode Rust(matklad.github.io)
1 points by avinassh 2y ago|0 comments
163.
Rust Prism(registerspill.thorstenball.com)
7 points by avinassh 2y ago|0 comments
164.
Dolt Corruption Challenge(dolthub.com)
1 points by avinassh 2y ago|0 comments
165.
Why Write Engineering Blogs?(freecontent.manning.com)
2 points by avinassh 2y ago|0 comments
166.
The Unison Programming Language(unison-lang.org)
9 points by avinassh 2y ago|2 comments
167.
by avinassh 2y ago
I'd love to know how they have hooked VFS with WAL to monitor changes. The SQLite's WAL layer deals with page numbers where as VFS deals with file and byte offsets. I am curious to understand how they mapped it, how they get new w
168.
by avinassh 2y ago
it does mention it: there’s just 1 static binary, all I need to do to deploy it is copy the binary. If there are static files I can just embed them in the binary with embed.
169.
by avinassh 2y ago
Is the benchmark code available somewhere / open source?
170.
by avinassh 2y ago
last I checked, Substack did not allow writers to set canonical links for their posts.
171.
by avinassh 2y ago
side note: (assuming you are the author) could you please add RSS feed to your blog? thank you!
172.
by avinassh 2y ago
slightly related: earlier I was experimenting with Rust string allocations, even though my code did almost same as standard library, the heap allocations were taking 10x of time. Relevant code: fn alloc_string(s: &str) -> NonNull
173.
by avinassh 2y ago
> we tail postgres’ WAL to detect novelty and use last-write-win semantics to handle conflicts can you elaborate more on how you achieve this
174.
by avinassh 2y ago
You may check https://cstack.github.io/db_tutorial which teaches writing an SQLite compatible database from scratch in C. I know you mentioned about RDBMS, but may I introduce you to a structured path for building a KV Stor
175.
by avinassh 2y ago
Can you elaborate? Are there studies showing changes in metabolism preventing cancer?
176.
by avinassh 2y ago
> How do you think I should reason about making this distributed - should I use one of the (various) sqlite replicatoin libraries? Or should this be something I roll on my own (on top of some other protocol, such as raft, or something el
177.
by avinassh 2y ago
Have you considered libsql? It is a distributed SQLite database, written mostly in Rust. There is a go database/sql and GORM driver available - https://github.com/tursodatabase/libsql disclaimer: I am one of the m
178.
Programming Languages Resources(bernsteinbear.com)
2 points by avinassh 2y ago|0 comments
179.
One process programming notes (with Go and SQLite)(crawshaw.io)
1 points by avinassh 2y ago|0 comments
180.
Substack Has Failed Indian Creators(blog.codingconfessions.com)
8 points by avinassh 2y ago|4 comments

More ›