RFC6238 TOTP implementation in pure PostgreSQL

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • totp

    RFC6238 TOTP implementation in pure PostgreSQL plpgsql

  • The file you're pointing to is not the full extension, here it is:

    https://github.com/pyramation/totp/blob/master/packages/totp...

  • mintotp

    Minimal TOTP generator in 20 lines of Python

  • This is very interesting if it was done for fun.

    However, this is very likely not suitable for real world usage. A couple of issues I could see with a quick glance:

    * The function random() used at line 121 is not a cryptographically secure random number generator.

    * Using '=' for comparing TOTPs at line 111 is not safe from timing attacks.

    By the way, a shameless plug: TOTP generation in Python is only 30 lines of code, thanks to its extensive standard library: https://github.com/susam/mintotp

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • postgres-deno

    Discontinued A PostgreSQL extension for Deno: run Typescript in PostgreSQL functions and triggers.

  • > except if my backend is in JS, there's a cognitive cost to adding another language to the stack.

    Agreed.

    However, I don't see why not use one of the other mature "real" extension languages other than pl/pgSQL.

    As for typescript, maybe there's (distant) hope:

    https://github.com/supabase/postgres-deno

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • django authentication , login with otp

    1 project | /r/django | 6 Jul 2023
  • WebAuthn Is Great and It Sucks

    2 projects | news.ycombinator.com | 2 Jul 2023
  • Managing credentials for automated scripts

    1 project | /r/learnpython | 15 Jun 2023
  • PyPI announces mandatory use of 2FA for all software publishers

    3 projects | /r/programming | 30 May 2023
  • Minimal TOTP Generator in 20 Lines of Python

    1 project | /r/Python | 5 May 2023