Hello sqlite my old friend

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

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

  • @sphaerophoria
    @sphaerophoria  3 месяца назад +5

    02:12:55 Using last_insert_rowid() is a mistake I think. In some cases there is no row inserted and it doesn't return something sane. This resulted in us saying "hey I have this session ID and it belongs to this user", but the user was invalid, which made the join invalid, etc. I've adjusted off screen to use the RETURNING clause in sqlite and parse the id out of it