Skip to content

sqlite.md

Latest commit

 

History

History
44 lines (31 loc) · 869 Bytes

sqlite.md

File metadata and controls

44 lines (31 loc) · 869 Bytes

Sqlite

Sqlite is the SQLite dialect object exported by @stackpress/inquire.

import Sqlite from '@stackpress/inquire/Sqlite';

Properties

Property Value
name sqlite
q `

The module also exports typemap.

Type mapping highlights

  • json -> TEXT
  • boolean -> INTEGER
  • integer -> INTEGER
  • datetime -> INTEGER

Behavior notes

  • keeps ? placeholders
  • converts booleans to integers at the connection layer
  • uses backticks for identifier quoting
  • supports fewer direct alter operations than MySQL or PostgreSQL

Example

const request = engine.create('users')
  .addField('id', { type: 'integer', autoIncrement: true })
  .addPrimaryKey('id')
  .query(Sqlite);

Related