boundlessdreamz's comments

On: Building a Blog with Elixir and Phoenix

[boundlessdreamz]

Why is it useless?

On: How we give every user SQL access to a shared ClickHouse cluster

[boundlessdreamz]

How do you copy all the relevant data? Doesn't this create unnecessary load on your source DB?

[cjonas → boundlessdreamz]

We have various data sources (which is another benefit of this approach). Data from the application DB is currently pulled using the FE apis which handle tenant isolation and allow the application database to deal with the load. I think pg_duckdb could be a good solution here as well, but haven't gotten around to testing it. Other data come from analytics DB. Most of this is landed on an interval via pipeline scripts.

On: Design and Implementation of Sprites

[boundlessdreamz]

Is there a way to copy files to/from the sprite? Couldn't see an option for that in the CLI

[tptacek → boundlessdreamz]

There's an FS API that shipped yesterday:

    /fs/read?path=X   | GET           | Read file (supports Range headers)           
    /fs/write?path=X  | PUT           | Write file (body = raw bytes)                
    /fs/list?path=X   | GET           | List directory 
    /fs/delete?path=X | DELETE/POST   | Delete files/dirs                            
    /fs/rename        | POST          | Rename/move                                  
    /fs/copy          | POST          | Copy files/dirs                              
    /fs/chmod         | POST          | Change permissions                           
    /fs/chown         | POST          | Change ownership                             
    /fs/watch         | GET (WebSock) | Watch for filesystem changes                 

It'll get CLI support very soon.

But I've just been using magic-wormhole for this.

[Imustaskforhelp → tptacek]

Piping server is another interesting idea for ephemeral transfers They are pretty cool!

https://github.com/nwtgck/piping-server

[aostiles → boundlessdreamz]

I was trying to copy a directory and used:

Pull from sprite to local: sprite exec -s my-sprite sh -c "tar -czf - /home/sprite/<my_dir>" | tar -xzf - -C ./

Push from local to sprite: COPYFILE_DISABLE=1 tar -czf - <my_dir> | sprite exec -s my-sprite sh -c "tar -xzf - -C /home/sprite/"

[MildlySerious → boundlessdreamz]

I would love to just mount a directory via SFTP, so I can use my IDE alongside the far-away Claude. That would put this in the realm of daily use for development.

[mrkurt → boundlessdreamz]

`cat file.txt | sprite exec -s <name> bash -c "cat > ~/file.txt"` is my go to.

On: Design and Implementation of Sprites

[boundlessdreamz]

Yeah. My sprites never idled inspite of having nothing running in them and had to be destroyed. Ideally there should be two settings

1. A timeout after the last console session is exited 2. Force idle using the CLI

[panarky → boundlessdreamz]

Just tried it again. Creation took a very long time, then errored.

    $ sprite version
    sprite version v0.0.1-rc30

    $ sprite create quk

     Error creating sprite: failed to create sprite: Post "https://api.sprites.dev/v1/sprites": context deadline exceeded (Client.Timeout exceeded while awaiting headers)

But despite the error, the sprite was apparently created, and it runs continuously.

    $ sprite ls
    Sprites in organization <redacted>:

    ┌────┬───────┬────────┐
    │NAME│STATUS │CREATED │
    ├────┼───────┼────────┤
    │quk │running│14m ago │
    └────┴───────┴────────┘

    Total: 1 sprite(s)

[loloquwowndueo → panarky]

Get a console in your sprite. Run “screen”. Run a loop in there : while date; do sleep 1; done. Detach screen and exit the session. Wait a few minutes and go back into the sprite. Reattach screen. You’ll see a gap in the timestamps.

They do suspend even when they say they are “running”.

On: $50 PlanetScale Metal Is GA for Postgres

[boundlessdreamz]

Off-topic: when will postgres 18 be offered on metal?

[kelp → boundlessdreamz]

You can expect to see it in early 2026 for both Metal and EBS backed databases.

[kelp → kelp]

In typical PlanetScale style, we like to beat our estimates.

https://planetscale.com/blog/postgres-18-is-now-available

On: Maestro – Next generation mobile UI automation

[boundlessdreamz]

When testing mobile apps, how do you manage the data at the backend? i.e how do you ensure that data that you see in the app is he same every time and actions during the test do not affect the data for the next test?

When testing the backend in frameworks such as Rails, this is taken care of by seed data and DB transactions.

On: 7 Databases in 7 Weeks for 2025

[boundlessdreamz]

This comment was most likely generated using AI It is reusing phrases from previous comments -

https://news.ycombinator.com/item?id=42330710 and https://news.ycombinator.com/item?id=42330639

On: Sanding UI

[boundlessdreamz]

Linear has the best UI/UX of all the web apps I have used. After Gmail and Google Maps, I don't recall any other web app wowing me as much as Linear.

On: Show HN: From dotenv to dotenvx – better config management

[boundlessdreamz]

This is similar to how Rails handles secrets - https://edgeguides.rubyonrails.org/security.html#environment...

In Rails, the entire file is encrypted unlike here where only the secrets are

[vinnymac → boundlessdreamz]

Dotenvx used to encrypt by file. It’s a very recent design decision to encrypt by secret.

[kinduff → boundlessdreamz]

I really like how its implemented in Rails

[kevlened → boundlessdreamz]

How do reviewers of a PR know when/which environment variables changed?

On: Do we need to store all that telemetry?

[boundlessdreamz]

You question his competence.

> i feel like you have never touched servers/backend in anything more than simple projects (or at all). with full storage/memory there could be an issue that you won't be able to ssh to the server, so it speaks about your knowledge in this matter.

He was answering that.

If instead of dismissing someone outright and question their competence, you had raised specific concerns, this would have been a more productive conversation

[aPoCoMiLogin → boundlessdreamz]

> You question his competence. > He was answering that. > If instead of dismissing someone outright and question their competence, you had raised specific concerns, this would have been a more productive conversation

he first said that we don't need to monitor anything, just enable debugging when "business metrics" are failing, and then he changed his stance to "polling from time to time". that's just shows that his first take wasn't thoughtful, so I assumed that he never worked in "the field" or worked on smaller projects, as nobody that worked in bigger projects would say that "we don't need CPU/mem/hdd metrics". it's not like hes proposing something novel, that just ridiculous take that needs to be called out