Smart ledger and order management
A ledger and order application covering record management, order summaries and attachment previews, with external identity integration and desktop/H5 entry points. Contribute to business pages, order and attachment APIs, cross-platform experience and access flows.
- Order and attachment interactions across clients
- Connection release and concurrency in authentication
Context
Bring ledger and order workflows into an existing business system and desktop entry points, with record access, attachment previews and external identity integration.
My contribution
- Work on ledger pages, order management and attachment previews, including PDF compatibility in older WebViews.
- Coordinate desktop entry points, standalone H5 and backend APIs, checking build environments and access flows.
- Contribute to order summaries, attachment fields, external authentication and trial provisioning, with targeted tests.
A representative problem: connections held during authentication
External calls, concurrency locks and database transactions interact during access checks. A request can hold a database connection while waiting on another operation.
I contributed to request-lifecycle analysis, token concurrency handling and connection release, supported by connection-pool tests.
Verification and scope
Check client compatibility and database transactions separately: attachment rendering on the client, and connection lifecycles under waiting, failure and concurrency on the server. Production behavior requires deployment and live-request checks.
Related articles
- Technical notes: No slow SQL, yet the connection pool is exhausted
- Technical notes: The app loads, but previews fail in an older WebView
- Vue 3
- React
- TypeScript
- Pinia
- ant-design-vue
- PDF.js
- SheetJS
- docx-preview
- FastAPI
- SQLAlchemy
- PostgreSQL