Node.js and Vite: a complete overview, pros, cons and limits

// an API on built-in modules only: no packages to install or update
import { createServer } from 'node:http';

const products = [
  { sku: 'A-100', title: 'Oak table', price: 24000 },
  { sku: 'B-200', title: 'Pine shelf', price: 5000 },
];

export const server = createServer((req, res) => {
  const url = new URL(req.url ?? '/', 'http://localhost');
  if (url.pathname === '/api/products') {
    const max = Number(url.searchParams.get('max') ?? Infinity);
    res.writeHead(200, { 'content-type': 'application/json' });
    res.end(JSON.stringify(products.filter((p) => p.price <= max)));
    return;
  }
  res.writeHead(404).end();
});

// the test runner and fetch are built in too
import { test } from 'node:test';
import assert from 'node:assert/strict';
import { server } from './ex1.en.ts';

test('filters products by price', async () => {
  server.listen(0);
  const { port } = server.address() as { port: number };
  const res = await fetch(`http://localhost:${port}/api/products?max=10000`);
  assert.deepEqual(await res.json(), [{ sku: 'B-200', title: 'Pine shelf', price: 5000 }]);
  server.close();
});

// a price-list import: built-in SQLite, one transaction, no dependencies
import { DatabaseSync } from 'node:sqlite';
import { readFileSync } from 'node:fs';

const db = new DatabaseSync('shop.db');
db.exec('CREATE TABLE IF NOT EXISTS prices (sku TEXT PRIMARY KEY, price INTEGER NOT NULL) STRICT');

const rows = readFileSync('prices.csv', 'utf8').trim().split('\n').slice(1);
const upsert = db.prepare(
  'INSERT INTO prices (sku, price) VALUES (?, ?) ON CONFLICT (sku) DO UPDATE SET price = excluded.price',
);

db.exec('BEGIN');
for (const row of rows) {
  const [sku, price] = row.split(',');
  upsert.run(sku!, Number(price));
}
db.exec('COMMIT');

const { n } = db.prepare('SELECT count(*) AS n FROM prices').get() as { n: number };
console.log(n); // 2 — a repeated import updates prices instead of duplicating rows

import { defineConfig } from 'vite';

// Vite builds scripts and styles for a server-rendered site (PHP, Go)
export default defineConfig({
  build: {
    outDir: 'public/build',
    manifest: true, // manifest.json: which hashed file to include on the page
    rolldownOptions: {
      input: ['src/main.ts', 'src/style.css'],
    },
  },
});