Loading page
Kai 판매
A SQLite database schema and WAL (write-ahead log) artifact for an AI-powered product recommendation engine, storing cached products with style, occasion, color, and size tags alongside user style profiles and persisted recommendation sets with line items. Includes a feedback table for capturing user responses to recommendations, with indexed queries optimized for per-user history retrieval. Built for TypeScript backend developers integrating personalized shopping or catalog recommendation features into their applications, licensed under the Tetrees License.
Backend 8F2X is a TypeScript backend service that powers an AI-driven product recommendation engine. It manages a local SQLite database to cache products, store user style profiles, generate outfit/product recommendations, track recommendation line items, and collect user feedback — all optimized for fast, personalized retrieval.
| Layer | Technology |
|---|---|
| Language | TypeScript |
| Database | SQLite (WAL mode) |
| Storage Format | Local file (data/ai-recs.sqlite) |
better-sqlite3 or @libsql/client)npm install
The SQLite database file is located at:
data/ai-recs.sqlite
The WAL (Write-Ahead Log) mode is active, indicated by the presence of ai-recs.sqlite-shm and ai-recs.sqlite-wal files. Ensure these files are kept together and are not split across deployments.
npm run dev # Development
npm run build # Compile TypeScript
npm start # Production
products_cache| Column | Type | Notes |
|---|---|---|
product_id | TEXT PK | Unique product identifier |
title | TEXT | Product name |
price | REAL | Default 0 |
currency | TEXT | Default USD |
in_stock | INTEGER | Boolean 0/1 |
style_tags | TEXT | JSON array |
occasion_tags | TEXT | JSON array |
colors | TEXT | JSON array |
sizes | TEXT | JSON array |
item_role | TEXT | Default other |
image_url | TEXT | Optional |
updated_at | TEXT | Auto timestamp |
user_profile_cache| Column | Type | Notes |
|---|---|---|
user_id | TEXT PK | |
preferences | TEXT | JSON object |
style_profile | TEXT | JSON object |
updated_at | TEXT | Auto timestamp |
recommendations| Column | Type | Notes |
|---|---|---|
recommendation_id | TEXT PK | |
user_id | TEXT | |
title | TEXT | |
summary | TEXT | Optional |
total_price | REAL | |
matching_reason | TEXT | Optional |
created_at | TEXT | Auto timestamp |
recommendation_items| Column | Type | Notes |
|---|---|---|
recommendation_item_id | TEXT PK | |
recommendation_id | TEXT | FK → recommendations |
product_id | TEXT | |
variant_id | TEXT | Optional |
item_role | TEXT | Default other |
sort_order | INTEGER | Default 0 |
recommendation_feedback| Column | Type | Notes |
|---|---|---|
feedback_id | TEXT PK | |
user_id | TEXT | |
recommendation_id | TEXT | FK → recommendations |
feedback_type | TEXT | e.g. liked, dismissed |
created_at | TEXT | Auto timestamp |
Specific HTTP routes are not visible in the provided source. Endpoint documentation will depend on the router layer built on top of this data layer. The schema supports the following logical operations:
| Action | Description |
|---|---|
| Upsert product | Cache or refresh product data |
| Upsert user profile | Store or update user style preferences |
| Create recommendation | Generate and persist a new AI recommendation set |
| Add recommendation items | Attach products to a recommendation |
| Submit feedback | Record user response to a recommendation |
| Fetch recommendations | Query by user ID, ordered by recency |
Tetrees License
격리된 샌드박스를 띄워 서버에서 바로 실행하세요 — 로컬 설정 불필요.
샌드박스 검증이 완료되었으며 감지된 실행 경로가 통과했습니다.
This Express backend / api completed archive review. Structure, dependency manifests, documentation, functional source, and common risk patterns were checked by the Tetrees verification pipeline; runtime phases are stated separately.
Deterministic AVCP artifact review
파이프라인 avcp-2026-08-04.1 · SHA-256 8d33f7d4b10028ed…
This version-scoped review deterministically inspects the submitted archive for structure, dependencies, documentation, functional source, and common malicious or high-risk signals. Build and test phases are reported as passed only after an isolated sandbox audition. It is not a guarantee of perfect security.
검토일 2026년 8월 4일
전체 설치 가이드와 연동 프롬프트는 구매 후 열람할 수 있습니다.
이 제품을 AI IDE, 웹 빌더 또는 클라우드 IDE로 바로 가져오세요.
Tetrees를 호환 AI IDE에 연결해 보유 제품을 불러오고, 판매자 업로드 권한을 노출하지 않은 채 검증된 ZIP을 받으세요.
리뷰 24개
Better than I expected. Used this store / POS to sell my storefront and it cut days off the build.
Great starting point. Picked up "AI Recommendation & Activity Backend Kit" for a client storefront — Handles the edge cases I usually have to patch myself. Minor tweaks needed for my use case but nothing broke.
Rock solid so far. Setup was a single command and it ran first try, and the walkthrough got me running in minutes. Support answered my question fast.
Worth every point. As someone who sells these all day, setup was a single command and it ran first try.
Better than I expected. Dropped this store / POS straight into the storefront; the walkthrough got me running in minutes.
Saved me a ton of time. As someone who sells these all day, the code is readable and the structure makes sense. Would buy from this seller again.
Dropped it into my stack and it just worked. Dropped this store / POS straight into the storefront; examples matched the actual API, which is rare. Would buy from this seller again.
This is a keeper. As someone who sells these all day, zero mystery dependencies, everything is documented.
Worth every point. Picked up this store / POS for a client storefront — TypeScript types are actually accurate, no fighting the compiler.
Rock solid so far. No spaghetti — the folder layout is sane, and examples matched the actual API, which is rare.
토론을 불러오는 중…