github remix-run/remix data-table-sqlite@1.1.0
data-table-sqlite v1.1.0

latest releases: ui@0.14.0, test@1.2.0, static-middleware@1.0.3...
one hour ago

Minor Changes

  • Query builder results now decode values SQLite stores in another form: json() columns are parsed with JSON.parse(), boolean() columns read as true or false instead of 1 or 0, and timestamp() columns stored in SQLite's current_timestamp format, with optional milliseconds, read as Date objects. Timestamp text in another format and text in a json() column that is not valid JSON are returned unchanged, and db.exec() results keep the stored values. Code that compared these columns against 1, 0, or JSON text should compare against the decoded values instead. (#12337)

     let settings = await db.query(userSettings).find(userId)
    -if (settings.enabled === 1) applyTheme(JSON.parse(settings.data))
    +if (settings.enabled) applyTheme(settings.data)

Patch Changes

  • Bind Date and boolean parameters consistently. Previously, a Date in the first parameter position was read as a named-bindings object in Node.js, shifting the remaining values, and a Date anywhere else failed, which broke timestamp column writes, including the default created_at and updated_at values. Dates are now bound as UTC strings in SQLite's current_timestamp format, such as '2026-06-01 12:00:00' (with milliseconds only when they are nonzero), and booleans in raw sql statements are bound as 1 or 0 like query builder values. Invalid dates are rejected. (#12335)

    Object and array parameters other than typed arrays are now rejected in both Node.js and Bun. In Bun, an object parameter was previously read as a set of named bindings; pass each value positionally instead.

  • Bumped @remix-run/* dependencies:

Don't miss a new remix release

NewReleases is sending notifications on new releases.