SQLite
Overview
The SQLite data source connector connects Prisma to a SQLite database file. These files always have the file ending .db
(e.g.: dev.db
).
Example
To connect to a SQLite database file, you need to configure a datasource
block in your schema file:
schema.prisma
1datasource db {2 provider = "sqlite"3 url = "file:./dev.db"4}
The fields passed to the datasource
block are:
provider
: Specifies thesqlite
data source connector.url
: Specifies the connection URL for the SQLite database. The connection URL always starts with the prefixfile:
and then contains a file path pointing to the SQLite database file. In this case, the file is located in the same directory and calleddev.db
.
Data model mapping
The SQLite connector maps the scalar types from the data model to native column types as follows:
Alternatively, see Prisma schema reference for type mappings organized by Prisma type.
Data model | SQLite |
---|---|
String | TEXT |
Boolean | BOOLEAN |
Int | INTEGER |
BigInt | INTEGER |
DateTime | NUMERIC |
Float | REAL |
Decimal | DECIMAL |
Json | Not supported |
Bytes | Not supported |
Connection details
Connection URL
The connection URL of a SQLite connector points to a file on your file system. For example, the following two paths are equivalent because the .db
is in the same directory:
schema.prisma
1datasource db {2 provider = "sqlite"3 url = "file:./dev.db"4}
is the same as:
schema.prisma
1datasource db {2 provider = "sqlite"3 url = "file:dev.db"4}
You can also target files from the root or any other place in your file system:
schema.prisma
1datasource db {2 provider = "sqlite"3 url = "file:/Users/janedoe/dev.db"4}