Home Projects Portfolio Dashboard Export PDF Log in
SQLite JWT

Building a Foundation: Launching the Ensolvers Notes App

Getting Started

Starting a new project often feels like a balancing act between feature delivery and laying down the right architectural patterns. We recently began development on the ensolvers-notes-app, a project designed to manage personal notes with a focus on simplicity and robust authentication.

Our initial push focused on setting up a clean foundation. By prioritizing a well-documented repository structure from day one, we set the stage for integrating features like secure data storage and identity management.

The Technical Strategy

To ensure the application remains lightweight yet scalable, we made two key architectural decisions regarding our stack:

Local Storage with SQLite

For the persistence layer, we opted for SQLite. It provides the relational power of SQL without the overhead of a dedicated database server, making it ideal for a focused note-taking application.

-- Example schema structure
CREATE TABLE user_notes (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    content TEXT NOT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

Identity with JWT

Security is non-negotiable, even in smaller projects. We integrated JSON Web Tokens (JWT) to manage user sessions. This allows our backend to verify identity stateless, which pairs perfectly with the modular nature of the application.

Future Roadmap

With the initial project structure and documentation in place, our next focus areas include:

  1. Schema Refinement: Expanding the database tables to support metadata and categories.
  2. Authentication Flow: Implementing the token exchange logic for secure user endpoints.
  3. Interface Design: Building a responsive frontend to consume our API securely.

Verdict

Building a strong foundation early—by defining your persistence and auth patterns before writing core business logic—pays dividends in long-term maintainability. If you are starting a new project, prioritize your README and environment documentation; it turns "tribal knowledge" into a project manual for future contributors.

Takeaway: Before diving into feature development, spend time documenting your architectural choices. It keeps the development process focused and prevents technical debt before it starts.


Generated with Gitvlg.com

Building a Foundation: Launching the Ensolvers Notes App
F

Franco Gatti

Author

Share: