HNHacker News
TopNewBestAskShowJobs

devnull3

823 karma · joined August 2, 2021

submissionscomments
devnull3··on Ask HN: Best Course for Leetcode Questions?
For folks who do did not get the reference, here is THAT runout:

https://www.youtube.com/watch?v=XxiyKWBPshg

Not that watching this will greatly increase the understanding of the game who do not know cricket.. but still.

(Basically the the guy in greens who was not batting simply did not run ... his is Alan Donald)

devnull3··on Letter to Sundar Pichai from TCI Fund Management [pdf]
I think 12k is just the start. The overall number will higher.
devnull3··on Why I’m emigrating from zero-growth Britain’
How so? I don't know much about Dubai (from emmigration pov) other than the fact that its a low-tax destination.
devnull3··on Why I’m emigrating from zero-growth Britain’
As a high-earning & tax paying immigrant in UK, it seems it is much easier to come to UK illegally than by legal means. It is getting harder to get a PR.

Cost of living, rise in taxes and degradation in Govt services (e.g NHS) really has got me thinking whether staying in UK is really worth it.

devnull3··on Why I’m emigrating from zero-growth Britain’
https://archive.md/zPOUa
devnull3··on The world is burning more coal than ever before, new report shows
> is combined with oxygen to form carbon dioxide

Isn't that some mass will be get converted to energy while burning? So the weight of the resultant CO2 will be less than the fuel burnt.

devnull3··on The world is burning more coal than ever before, new report shows
I have a naive question:

   When we use/burn non-renewable fuels (crude, wood, coal, etc) it will reduce the mass of earth over the period of time. At which point (if at all) it will affect gravitational force between earth & sun as per the formula [1]
By "affect" I mean in a noticeable way.

[1] https://www.google.com/search?q=gravitational+force+formula

devnull3··on PhD student solves 2,500-year-old Sanskrit problem
I don't think so. Govt of India has been promoting Sanskrit (without much success) since many decades. There is/was even Sanskrit news. Now-a-days I can see "Weekly Sanskrit Magazine: Vaartavali" from national news Doordarshan [1]

[1] https://www.youtube.com/watch?v=ELmU3GXcuuo

devnull3··on Indian Air Force inducts natively developed light combat helicopter ‘Prachanda’
> Brahmos

Nitpick: It is actually amalgamation of Indian & Russian rivers. Brahmaputra (India) and Moskva (Russia)

devnull3··on Show HN: Versioning Filesystem for SQLite
There is a requirement where I need data which existed at timestamp T or version V. So even a WAL needs to be versioned.
devnull3··on Show HN: Versioning Filesystem for SQLite
This is a part of a larger system which requires versioning of data. So there is a requirement of reading the data as of timestamp T. The sqlite is supposed to be metadata of that large data. Since the larger data itself is versioned I need metadata to be versioned.

Some of the use-cases are mentioned at: https://news.ycombinator.com/item?id=32629548

devnull3··on Show HN: Versioning Filesystem for SQLite
In git, each version of the database will be a full copy. The git has to perform diff i.e. scan the database file. Imagine doing commits & creating snapshots very frequently.

Have a look at https://github.com/sudeep9/mojo/blob/main/design.md#index

devnull3··on Show HN: Versioning Filesystem for SQLite
Yes. But you need to have such a filesystem installed at the first place.

Mojo can run on any filesystem which does not support snapshots/versions. This makes it portable not only across different fs but also across OS.

devnull3··on Show HN: Versioning Filesystem for SQLite
Noted.

I have changed the license to MIT.

devnull3··on Show HN: Versioning Filesystem for SQLite
I have changed the license to MIT. Sorry for the wrong impression.
devnull3··on Show HN: Versioning Filesystem for SQLite
(I am the author) Some of the use-cases of mojo I could think of:

1. Rollbacking DDL changes (like create table, adding columns, etc)

2. (My use-case) Multiple readers-single writer. Readers read old versions. Writers do not block readers and vice-versa. Note: this is different than reading+writing in the same version can still happen but with database-level locking.

3. Extension of #2: The older versions read from S3 so that lamda can read.

4. Extension of #3: Readers reading from old immutable snapshots makes the database as a queue of complex changes with indexes and all the benefits of SQL.

5. Backups and replication.

Oh: I have change the license to MIT

devnull3··on Show HN: Versioning Filesystem for SQLite
From what I know of litestream, it should be decoupled from VFS implementation. The versions/snapshots are not known to the database.
devnull3··on Show HN: Versioning Filesystem for SQLite
I think you can read the code. I knowingly made the repo public. You do not even have to login to github. I think it should be ok.
devnull3··on Show HN: Versioning Filesystem for SQLite
Not sure I understood your question fully, but if there are multiple versions, then read will be over multiple files but writes go to a single active version.
devnull3··on Show HN: Versioning Filesystem for SQLite
I am the author. Mojo is both an extension and a VFS implementation.

> AFAIK only one VFS can be active at a time.

You can specify VFS as a part of connect URI.

devnull3··on Show HN: Versioning Filesystem for SQLite
> is it some kind of a tease

(I am the author). It's definitely not a tease. The license will change within a week (max 2). This is my first open source project. The purpose is to validate the approach.

This has been a private project for a very long time. It can be argued that I should have figured out the license but the delay from my side reached a tipping point. I just thought "make it public, figure the rest later".

devnull3··on Show HN: Versioning Filesystem for SQLite
Only modified pages go into a version data file [1]

[1] https://github.com/sudeep9/mojo/blob/main/design.md

devnull3··on LiteFS a FUSE-based file system for replicating SQLite
I can confirm that it does. I am working on it as I write this :).

Technically, an extension and VFS are separate things.

An extension when loads, allows you to register the VFS with the Sqlite. It can also register virtual tables as well.

devnull3··on LiteFS a FUSE-based file system for replicating SQLite
It just so happens that I am working on a versioned file system for sqlite based on its VFS interface. Planning to release it in a week's time. It will be in pre-alpha stage and its more of a proof-of-concept.

Having worked with FUSE in the past, there is always some performance penalty, but the advantage is that there is no change in the application.

The VFS will need change in the application but less overhead. Trade-offs!

devnull3··on How I went about learning Rust
> What would be a good use case of Rust than Golang

If you can afford GC in your project go for Golang else Rust.

devnull3··on Ask HN: Can you both take climate change seriously and against nuclear energy?
I don't know how much nuclear reactors have advanced. But I can understand the fear in the someone's back of their mind: What if something goes wrong?

I see this risk = Fallout x Probability. Even though the proponents argue that the tech is much more safer, the fallout is so huge and generational that its it neutralises the low probability of any accidents.

PS: I am neither for or against the nuclear tech.

devnull3··on India could become a 'mushroom superpower'
India consistently disappoints the most optimists and the pessimists about its potential.
devnull3··on A religious sect landed Google in a lawsuit
Until last year I too use to dream working in Google. But increasingly the attractiveness is decreasing. I cannot put a finger on one specific thing. It has gone too large from a career pov.
devnull3··on Researchers achieve ‘absurdly fast’ algorithm for network flow
Nice! Now this would be expected algo from candidates in google/meta interviews, especially for senior IC roles.

Update your leetcode answers folks.

devnull3··on Absolute truths I unlearned as junior developer (2019)
Small piece of wisdom I received when I was an intern:

"Never get sentimental with your code"

← PreviousPage 6 of 9Next →