mirek/mssqlite

architecture

mssqlite system architecture: package dependency graph, request lifecycle from TDS packet to SQLite and back, key design decisions (name flattening, NOCASE collation, parameter passthrough, UDF strategy, session model, metadata inference) and current…

原文语言：英语

t-sql

Comprehensive T-SQL language reference for implementing a T-SQL engine. Covers data types, type conversion, operators, expressions, control flow, queries (SELECT, JOIN, CTE, window functions), DML statements (INSERT, UPDATE, DELETE, MERGE), DDL statements…

原文语言：英语

tds-protocol

Comprehensive TDS (Tabular Data Stream) protocol reference for implementing MSSQL clients and servers. Covers packet framing, message types, token streams, data types, login, prelogin, SQL batch, RPC, transactions, error handling, and wire format details. Use…

原文语言：英语

sys

MSSQL system catalog views technical specification for implementing sys.* emulation in mssqlite. Covers schema definitions, column types, relationships, built-in data, and SQLite backing-table design for all essential catalog views.

原文语言：英语

tedious

Using the tedious MSSQL client against mssqlite — connection options that matter (TLS, port, useColumnNames), Request API and events (row, infoMessage on the connection, done vs doneInProc), how tedious maps operations to the wire (sp_executesql RPC,…

原文语言：英语

monorepo

mssqlite repository conventions: pnpm workspace layout, prelude code style (file-per-function, namespace re-exports, immutable readers/results), node-native TypeScript execution, eslint/vitest toolchain, how to add packages and what every package must ship…

原文语言：英语

sqlite

Comprehensive SQLite reference for implementing an MSSQL-compatible server on top of SQLite. Covers SQL syntax, type affinity and STRICT tables, DDL (CREATE/ALTER/DROP TABLE/INDEX/VIEW/TRIGGER, FKs, generated columns), DML…

原文语言：英语

node-sqlite

Comprehensive reference for the built-in Node.js node:sqlite module. Covers DatabaseSync, StatementSync, SQLTagStore, Session/changesets, user-defined functions and aggregates, authorization, online backup, serialize/deserialize, type conversion (BigInt and…

原文语言：英语

verify

Verify a change end-to-end by launching the real mssqlite TDS server and driving it over a socket with a real tedious client. Use after any change to tsql/transpile/catalog/engine/tds/server to observe behavior at the wire surface instead of re-running tests.

原文语言：英语