Faster Writes With ZFS? | Scaling Postgres 342

Поделиться
HTML-код
  • Опубликовано: 29 янв 2025

Комментарии • 6

  • @utenatenjou2139
    @utenatenjou2139 2 месяца назад +1

    10.08: OpenAI access is interesting, thanks. Love your post, covering this.

  • @debkr
    @debkr 2 месяца назад

    We have been using the sqids for the same reason. That is a good suggestion. Also because database id is numeric we get better query performance.

  • @DylanYoung
    @DylanYoung 2 месяца назад

    Sqids *should not be used for security*. The proper way to do this in a secure manner would be using public key cryptography. Sqids does not do this and since the client knows the shared alphabet, so does a hacker in most applications.

    • @DylanYoung
      @DylanYoung 2 месяца назад

      The Sqids project, to their credit, is relatively clear about this, but the article you cited is not.

    • @ScalingPostgres
      @ScalingPostgres  2 месяца назад

      I agree about using a different method if you want something "secure". Sqids seems more like "security through obscurity". Although, I envisioned that URLs would be generated and translated on the web servers as opposed to clients. Therefore, I would think the alphabet would be unknown to the client. I agree this won't stop hackers, but I think it would prevent John or Jane web user from knowing how many accounts or transactions your application has.