HN user

darthShadow

2,025 karma

https://github.com/darthShadow

Posts24
Comments37
View on HN
joy.ente.com 2mo ago

Working Hard

darthShadow
4pts2
newsletter.posthog.com 1y ago

An engineer's guide to vibe design (with prompts)

darthShadow
3pts0
www.linuxserver.io 1y ago

We Need to Talk About Docker Hub

darthShadow
128pts146
blog.kagi.com 1y ago

Kagi Assistant

darthShadow
492pts236
www.youtube.com 2y ago

Intel has a Pretty Big Problem [video]

darthShadow
8pts2
www.tomshardware.com 2y ago

Intel issues statement about CPU crashes, blames motherboard makers

darthShadow
3pts1
fly.io 2y ago

Fly Kubernetes has reached beta

darthShadow
4pts0
xeiaso.net 2y ago

The Layoff

darthShadow
21pts0
tailscale.com 2y ago

Choose your own IP

darthShadow
302pts173
fly.io 2y ago

The risks of building apps on ChatGPT

darthShadow
1pts0
fly.io 2y ago

Transcribing on Fly GPU Machines

darthShadow
4pts1
blog.kagi.com 2y ago

Unlimited Kagi searches for $10 per month

darthShadow
1748pts942
fly.io 3y ago

Tokenized Tokens

darthShadow
190pts30
blog.kagi.com 3y ago

Updates to Kagi pricing plans – More searches, unrestricted AI tools

darthShadow
92pts77
fly.io 3y ago

A 'No JavaScript' Solution for Dynamic Search in Django · Fly

darthShadow
1pts0
fly.io 3y ago

Carving the scheduler out of our orchestrator

darthShadow
276pts66
tailscale.com 3y ago

Tailscale Actions for iOS and macOS Shortcuts

darthShadow
3pts0
traefik.io 3y ago

Exploring the Tailscale-Traefik Proxy Integration

darthShadow
1pts1
blog.kagi.com 3y ago

Kagi Search Dec'22 Update

darthShadow
5pts0
blog.kagi.com 3y ago

The Age of PageRank Is Over

darthShadow
558pts373
tailscale.com 3y ago

Virtual Private Services with Tsnet

darthShadow
5pts0
vxai.com 3y ago

Search Engine for finding movies in natural language

darthShadow
3pts0
tailscale.com 3y ago

Making an SSH client the hard way

darthShadow
299pts102
blog.kagi.com 3y ago

Kagi/Orion status update: First three months

darthShadow
322pts191

These may be useful reading:

https://github.com/TryGhost/node-sqlite3/issues/408#issue-57...

https://github.com/WiseLibs/better-sqlite3/issues/32#issueco...

Copying a quote from the second:

The sqlite3 C API serializes all operations (even reads) within a single process. You can parallelize reads to the database but only by having multiple processes, in which case one process being blocked doesn't affect the other processes anyways. In other words, because sqlite3 serializes everything, doing things asynchronously won't speed up database access within a process. It would only free up time for your app to do other things (like HTTP requests to other servers). Unfortunately, the overhead imposed on sqlite3 to serialize asynchronous operations is quite high, making it disadvantageous 95% of the time.

From the project README:

Thruster also wraps the Puma process so that you can use it without managing multiple processes yourself. This is particularly useful when running in a containerized environment, where you typically won't have a process manager available to coordinate the processes. Instead you can use Thruster as your CMD, and it will manage Puma for you.

FWIW, auto_vacuum set to INCREMENTAL doesn't do any vacuuming automatically; it just stores the information needed to vacuum the DB.

From https://www.sqlite.org/pragma.html#pragma_auto_vacuum:

When the value of auto-vacuum is 2 or "incremental" then the additional information needed to do auto-vacuuming is stored in the database file but auto-vacuuming does not occur automatically at each commit as it does with auto_vacuum=full. In incremental mode, the separate incremental_vacuum pragma must be invoked to cause the auto-vacuum to occur.

You have already gotten excellent options from the other comments, but here's another one that's not been mentioned yet.

You may want to consider adjusting your partition key (if feasible) as a function of datetime so you can just drop a complete partition when required, rather than needing separate delete queries.

In my experience, it has proven to be a very quick and clean way to clear out older data.

FWIW, I haven't had any failures in ~3-4 months now. Every subscription using Stripe has been working flawlessly for the same time. Even usenet subs have renewed fine this year (just had an automatic renewal processed yesterday).

I use ICICI, Axis & HDFC Cards and all 3 have worked fine.

You may have missed this in the same section:

If such change to Individual plans is to occur, we plan to grandfather-in all early adopters (meaning all current and future paid customers, up until this change) allowing them to keep their existing subscription price as long as they don’t cancel it.

As someone who is deciding whether to splurge on a Quest 2 for exercising, how good is it without a computer system to link with?

Also, is there any step that requires a computer system like the initial setup etc.?

Any recommendations for initial games to try and guides for getting the optimal adjustment are also appreciated.