Getting Started

Sails SQLite is a high-performance SQLite adapter built specifically for Sails.js applications, featuring advanced performance optimizations based on SQLite best practices.

Installation

Install the adapter using npm:

npm install sails-sqlite

Basic Configuration

Configure your datastore in config/datastores.js:

// config/datastores.js
module.exports.datastores = {
  default: {
    adapter: 'sails-sqlite',
    url: 'db/production.sqlite'
  }
}

Quick Test

Create a simple model to test your setup:

// api/models/User.js
module.exports = {
  attributes: {
    name: {
      type: 'string',
      required: true
    },
    email: {
      type: 'string',
      required: true,
      unique: true,
      isEmail: true
    }
  }
}

Then test it in your Sails console:

sails console

// Create a user
const user = await User.create({
  name: 'John Doe',
  email: 'john@example.com'
}).fetch()

console.log('Created user:', user)

What's Next?

• Learn about performance configuration for production use
• Explore advanced features like transactions and batch operations
• Check out model definitions and best practices