Home

Welcome to the alembic-rds-vpn-terraform wiki!

• https://roman.pt/posts/pydantic-in-sqlalchemy-fields/#:~:text=In%20a%20post%20Don't,to%20objects%20representing%20your%20domain.

• Updates to JSON field don't persist to DB

More Optimal Embeddings?

• https://neon.tech/blog/pg-embedding-extension-for-vector-search
• https://neon.tech/blog/pgvector-meets-hnsw-index
• https://www.analyticsvidhya.com/blog/2023/10/introduction-to-hnsw-hierarchical-navigable-small-world/
• https://aws.amazon.com/blogs/database/accelerate-hnsw-indexing-and-searching-with-pgvector-on-amazon-rds-for-postgresql/
• https://code.dblock.org/2023/06/16/getting-started-with-vector-dbs-in-python.html
• https://neon.tech/blog/understanding-vector-search-and-hnsw-index-with-pgvector

Arrays <> or contains

• https://popsql.com/learn-sql/postgresql/how-to-compare-arrays-in-postgresql
• https://docs.sqlalchemy.org/en/20/dialects/postgresql.html#sqlalchemy.dialects.postgresql.ARRAY.Comparator.contained_by

More Auths

• https://testdriven.io/blog/fastapi-jwt-auth/
• https://stackoverflow.com/questions/60538047/jwt-private-public-key-confusion
• https://python-jose.readthedocs.io/en/latest/jwk/
• https://portswigger.net/web-security/jwt#jwt-format
• https://github.com/navikt/mock-oauth2-server
• https://openid.net/specs/openid-connect-discovery-1_0.html
• https://dev.to/spaceofmiah/implementing-authorization-in-fastapi-a-step-by-step-guide-for-securing-your-web-applications-3b1l
• https://fastapi.tiangolo.com/tutorial/security/oauth2-jwt/
• https://docs.aws.amazon.com/cognito/latest/developerguide/federation-endpoints.html
• https://pazel.dev/teach-me-pkce-proof-key-for-code-exchange-in-5-minutes
• https://stackoverflow.com/questions/40302349/how-to-verify-jwt-from-aws-cognito-in-the-api-backend (for javascript)

Fastapi techniques

• https://stackoverflow.com/questions/70051619/pass-on-value-from-dependencies-in-include-router-to-routes-fastapi
• https://fastapi.tiangolo.com/tutorial/dependencies/sub-dependencies/

OAuth

• https://www.youtube.com/watch?v=996OiexHze0
• https://medium.com/@vivekpemawat/enabling-googleauth-for-fast-api-1c39415075ea
• https://medium.com/workpeer/microsoft-oauth-2-0-graph-api-using-python-28a7a099dd2a

Data engineering?

• https://api.openalex.org/works?filter=publication_date:2020-01-01&sort=publication_date:desc&per-page=100&cursor=*
• https://export.arxiv.org/oai2?verb=ListRecords&metadataPrefix=oai_dc&from=2023-10-01&until=2023-10-02
• https://docs.openalex.org/api-entities/works/filter-works
• https://docs.dagster.io/concepts/resources
• https://dagster.io/blog/duckdb-data-lake
• https://docs.dagster.io/_apidocs/libraries/dagster-aws
• https://docs.openalex.org/how-to-use-the-api/get-lists-of-entities/paging

Salt and Hashed Password

• https://security.stackexchange.com/questions/17421/how-to-store-salt#:~:text=The%20salt%20can%20and%20should,of%20password%2Dhash%2Dpairs
• https://stackoverflow.com/questions/1054022/best-way-to-store-password-in-database