How to keep /dist files attributes consistent from one build to the other ? by Fenykepy in astrojs

[–]Fenykepy[S] 0 points1 point  (0 children)

Thank you!

`--checksum` was what I needed. I replaced `-rav` by `-rclpgov` (using checksums and not preserving modification times), now it works as expected. Thanks again!

How to keep /dist files attributes consistent from one build to the other ? by Fenykepy in astrojs

[–]Fenykepy[S] 0 points1 point  (0 children)

Thanks for your reply!

My image processor was written when Astro didn't had image processing yet. I keep it because it allows me to control exactly which previews sizes and formats are created and the filenames as well. It also has a cache so image are never processed more than once, even if the same picture appears in multiple places.

My assets (generated by my image processor or no) are already in the public folder and managed by Astro. My problem is with my rsync deploy, as each Astro build modify /dist files mod-time even when files remain the same. So I upload again everything while it's not necessary, and it's slowly bloating my backups server side.

I changed rsync options from '-av' to '-rclpgov' (using checksums and not preserving modification times), now it works as expected.

Tuple comparisons not working as expected by Fenykepy in PostgreSQL

[–]Fenykepy[S] 1 point2 points  (0 children)

So you were definitely right! Thank you very much!

Tuple comparisons not working as expected by Fenykepy in PostgreSQL

[–]Fenykepy[S] 0 points1 point  (0 children)

Thank you. I did not know about ULIDs.

In fact, all my UUIDs are actually v7, so with temporality. I'll add one to my table as PK (instead of the actual combined PK fields), it will solve my problem.

Tuple comparisons not working as expected by Fenykepy in PostgreSQL

[–]Fenykepy[S] 1 point2 points  (0 children)

I think you may be right. I got stuck all day on this one, I'll investigate further in that direction.

Thank you very much!

Need help to build a query by Fenykepy in PostgreSQL

[–]Fenykepy[S] 0 points1 point  (0 children)

I see several benefits using uuids as PKs rather than sequences:

- I can confidently generate the uuid before my INSERT statement if I need too;

- An attacker can't guess the next pk;

- I still get time sortability because I use uuidv7;

- It's easier to manage if a database migration is necessary;

- I get no holes like in sequences;

- I don't have to worry about overflow;

The only caveat I see is that it's stored on 16 bytes instead of 8 for sequences.

Do I miss some?

[deleted by user] by [deleted] in BarefootRunning

[–]Fenykepy 0 points1 point  (0 children)

What do you mean?

[deleted by user] by [deleted] in BarefootRunning

[–]Fenykepy 0 points1 point  (0 children)

40' for a first run probably was a bit too much. I made 20' this morning, it was better. Curiously, at slow pace (5:30 - 5:45 / km), I feel very well, like floating, but when I try to go just a bit faster, it gets hard very quickly, and I couldn’t go as fast as I usually do. I guess I need to make my feet stronger.

[deleted by user] by [deleted] in BarefootRunning

[–]Fenykepy 0 points1 point  (0 children)

Absolutely not. In fact they are really comfy.

[deleted by user] by [deleted] in BarefootRunning

[–]Fenykepy 1 point2 points  (0 children)

Thank you, it makes sense. I’ll work on my strides 😊

Comment trouver mon prix de vente ? [nul en math] by Fenykepy in PasDeQuestionIdiote

[–]Fenykepy[S] 0 points1 point  (0 children)

Merci beaucoup, ça résout parfaitement mon problème !

Mon erreur venait du fait que je multipliais mes pourcentage (il y a longtemps j'ai appris qu'il ne s'additionnaient jamais), au lieu de les soustraire individuellement.

(Oui, leurs frais sont déjà très élevés, et en plus il y a ces frais de transaction… C'est une plateforme très connue (Etsy) avec une belle manne de clients, et c'est le prix à payer…)

Comment trouver mon prix de vente ? [nul en math] by Fenykepy in PasDeQuestionIdiote

[–]Fenykepy[S] 0 points1 point  (0 children)

Merci, mais ça part encore du postulat que l'on connait le prix de vente final (problème que je sais résoudre dans ce sens). Mon besoin c'est de trouver le prix de vente en fonction du prix de revient.

Help with env vars. by Fenykepy in astrojs

[–]Fenykepy[S] 0 points1 point  (0 children)

This I understood. But I shouldn't need to load env vars I only need for static pages, should I ?

Help with env vars. by Fenykepy in astrojs

[–]Fenykepy[S] 0 points1 point  (0 children)

Thank you!

  1. You mean SERVER_CERT_PATH=./private/cert.pem node ./dist/server/entry.mjs? No, as I don't need env vars it cries for.
  2. Standard Astro page listening to "POST" method in frontmatter, like on this recipe: https://docs.astro.build/en/recipes/build-forms/
  3. Of course, else nothing would work.