Forked rebuild & upgraded to FastAPI 0.88, SQLAlchemy 1.4, & Nuxt 3.0

[turukawa]

I forked this repo more than a year ago for a major project and, with help from @br3ndonland, consolidated it on his Inboard FastAPI images, added in support for Neo4j (so I could use it for search), and fixed some of the things what were broken.

With several big generational updates on core dependencies, I've spent the last two weeks updating and refactoring. All dependencies upgraded to the latest long-term support & working versions, and I built a tiny blog-type app as the base stack. Still a Cookiecutter template.

Key updates:

• Inboard 0.10.4 -> 0.37.0, including FastAPI 0.88
• SQLAlchemy 1.3 -> 1.4
• Celery 4.4 -> 5.2
• Postgresql 12 -> 14
• Neo4j pinned to 5.2.0
• Nuxt.js 2.5 -> 3.0
• Pinia for state management (replaces Vuex)
• Vee-Validate 3 -> 4
• Tailwind 2.2 -> 3.2
• Authentication refresh token tables and schemas for long-term issuing of a new JWT access token.

I also rebuilt the auth 'n auth to make it a bit more reliable. I haven't rebuilt the tests yet.

Here's instructions for use and I'd appreciate your trying it out and letting me know if it is helpful.

Projects it was used for:

• openLocal.uk - visual data explorer for a quarterly-updated commercial location database for England and Wales.
• Qwyre.com - online ereader and collaborative self-publishing.

Next project for the rebuild: Enqwyre.com - implementation of a "no code" method for schema-to-schema data transformations for interoperability.

[br3ndonland]

Thanks @turukawa. I'd second that - if you've been stuck waiting for updates to this Cookiecutter, give the fork a try. It's an updated stack, and many of the bugs reported here have been resolved.

[podaga]

Thanks a million for this brilliant work.

Just a small typo in .../backend/app/app/core/config.py

Line 11 should read : ACCESS_TOKEN_EXPIRE_SECONDS and not ACCESS_TOKEN_EXPIRE_MINUTES

[turukawa]

Updated @podaga ... thanks.

I've been working on extending the authentication system to include TOTP and "magic link" logins, with fall-back to passwords.

Let me know if this is of interest?

[dazzag24]

+1 for the TOTP work.

[turukawa]

Version 0.7.0 released:

• New feature: magic (email-based) login, with password fallback
• New feature: Time-based One-Time Password (TOTP) authentication
• Security enhancements to improve consistency, safety and reliability of the authentication process (see full description in the frontend app)
• Refactoring of login APIs
• Requires one new frontend dependency: QRcode.vue