Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
- API
  
  Reference documentation for the pkg.go.dev API
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

sqlite

package

Go to main page

Versions in this module

v1

v1.7.4

Jun 18, 2026

v1.7.3

Jun 18, 2026

v1.7.2

Jun 16, 2026

v1.7.1

Jun 15, 2026

v1.7.0

Jun 13, 2026

Changes in this version

+ var ApplySQLiteConnectionPragmas = sqlcommon.ApplySQLiteConnectionPragmas

+ var BuildPostgresDSN = sqlcommon.BuildPostgresDSN

+ var FilterSuffix = map[string]string

+ var QuoteMySQLIdent = sqlcommon.QuoteMySQLIdent

+ var QuotePGIdent = sqlcommon.QuotePGIdent

+ func AlterTableAddFieldSQL(engine, tableName string, f *models.FieldInfo) ([]string, error)

+ func ApplyLitestreamConnectionPragmas(ctx context.Context, orm *bun.DB, engine string) error

+ func ApplyTursoSyncConnectionPragmas(ctx context.Context, orm *bun.DB, engine string) error

+ func BuildCombinedMetaQuery(keys dataloader.Keys, param *QueryBuilderParam) ([]byte, error)

+ func BuildCombinedRelationQuery(cfg *models.Config, relationType string, parentModel string, ...) (string, []interface{}, *string, error)

+ func CommonDocTransformation(model *models.ModelType, local string, result map[string]interface{}, ...) (*types.DefaultDocumentStructure, error)

+ func ConditionBuilder(variable string, args map[string]interface{}, modelType *models.ModelType, ...) (map[string][]string, error)

+ func FilterBuilder(variable string, where map[string]interface{}, modelType *models.ModelType, ...) ([]string, error)

+ func LimitBuilder(param *graphql.ResolveParams) (int, int)

+ func MediaDocTransformation(docType string, result map[string]interface{}) (*models.FileDetails, error)

+ func PhysicalSQLColumnForSystemRelationField(identifier string, modelType *models.ModelType) string

+ func PreflightSQLiteRelationParentTablesForAddRelation(ctx context.Context, db bun.IDB, engine string, ...) error

+ func RootConnectionResolverQueryBuilder(cfg *models.Config, param *models.CommonSystemParams) (string, error)

+ func RootResolverMediaQueryBuilder(param *graphql.ResolveParams) (string, error)

+ func RootResolverQueryBuilder(cfg *models.Config, param *models.CommonSystemParams, returnCount bool) (string, []interface{}, error)

+ func RunAnalyzeAfterIndexDDL(ctx context.Context, d *Driver)

+ func RunSQLiteLikePostDDL(ctx context.Context, d *Driver) error

+ func SelectBuilder(mv string, local string, modelType *models.ModelType, returnCount bool) []string

+ func StripArangoEnvelopeKeysForSQLInsert(data map[string]interface{}, param *models.CommonSystemParams)

+ type Driver struct

+ func GetDriver(cfg *models.Config, cred *models.DriverCredentials) (*Driver, error)

+ func (a *Driver) CheckTableOrCollectionExists(ctx context.Context, param *models.CommonSystemParams) (bool, error)

+ func (a *Driver) RemoveAuthAddOns(ctx context.Context, project *models.Project, option map[string]interface{}) error

+ func (d *Driver) AddATeamMemberToProject(ctx context.Context, req *models.TeamMemberAddRequest) error

+ func (d *Driver) AddAuthAddOns(ctx context.Context, project *models.Project, auth map[string]interface{}) error

+ func (d *Driver) AddDocumentToProject(ctx context.Context, param *models.CommonSystemParams, ...) (interface{}, error)

+ func (d *Driver) AddFieldToModel(ctx context.Context, param *models.CommonSystemParams, isUpdate bool, ...) (*models.ModelType, error)

+ func (d *Driver) AddModel(ctx context.Context, project *models.Project, model *models.ModelType) (*models.ProjectSchema, error)

+ func (d *Driver) AddRelationFields(ctx context.Context, from *models.ConnectionType, to *models.ConnectionType) error

+ func (d *Driver) BuildFieldClassification(_fields []*models.FieldInfo) *FieldClassification

+ func (d *Driver) CheckProjectExists(ctx context.Context, projectId string) (bool, error)

+ func (d *Driver) ConnectBuilder(ctx context.Context, root *models.CommonSystemParams) error

+ func (d *Driver) CountDocOfProject(ctx context.Context, param *models.CommonSystemParams) (interface{}, error)

+ func (d *Driver) CountDocOfProjectBytes(ctx context.Context, param *models.CommonSystemParams) ([]byte, error)

+ func (d *Driver) CountMedias(ctx context.Context, projectId string, param *graphql.ResolveParams) (int, error)

+ func (d *Driver) CountProjectAuthUsersByRole(ctx context.Context, tenantID string) (map[string]int, error)

+ func (d *Driver) CreateMediaDocument(ctx context.Context, projectId string, media *models.FileDetails) (*models.FileDetails, error)

+ func (d *Driver) CreateModelTable(ctx context.Context, model *models.ModelType, ifNotExists bool) error

+ func (d *Driver) CreateProjectAuthUser(ctx context.Context, user *models.ProjectAuthUser) (*models.ProjectAuthUser, error)

+ func (d *Driver) CreateProjectFile(ctx context.Context, file *models.ProjectFile) (*models.ProjectFile, error)

+ func (d *Driver) CreateTableOrCollection(ctx context.Context, param *models.CommonSystemParams, indexes []string) error

+ func (d *Driver) DeleteDocumentFromProject(ctx context.Context, param *models.CommonSystemParams) error

+ func (d *Driver) DeleteProject(ctx context.Context, projectId string) error

+ func (d *Driver) DeleteProjectAuthUser(ctx context.Context, userID string) error

+ func (d *Driver) DeleteProjectBase(ctx context.Context, param *models.CommonSystemParams) error

+ func (d *Driver) DeleteProjectFiles(ctx context.Context, ids []string) error

+ func (d *Driver) DeleteRelationDocuments(ctx context.Context, projectId string, from *models.ConnectionType, ...) error

+ func (d *Driver) DisconnectBuilder(ctx context.Context, param *models.CommonSystemParams) error

+ func (d *Driver) DropField(ctx context.Context, param *models.CommonSystemParams) error

+ func (d *Driver) EnsureFilesTable(ctx context.Context) error

+ func (d *Driver) EnsureMetaFilesTables(ctx context.Context) error

+ func (d *Driver) EnsureMetaMediaTables(ctx context.Context) error

+ func (d *Driver) EnsureModelUserFieldColumns(ctx context.Context, model *models.ModelType) error

+ func (d *Driver) EnsureRelationArtifactsFromSchema(ctx context.Context, modelsList []*models.ModelType) error

+ func (d *Driver) EnsureSchemaOptimizationsV1(ctx context.Context) error

+ func (d *Driver) EnsureUsersTable(ctx context.Context) error

+ func (d *Driver) GetAllRelationDocumentsOfSingleDocument(ctx context.Context, from string, arg *models.CommonSystemParams) (interface{}, error)

+ func (d *Driver) GetProjectAuthUser(ctx context.Context, userID string) (*models.ProjectAuthUser, error)

+ func (d *Driver) GetProjectAuthUserByUsername(ctx context.Context, username string) (*models.ProjectAuthUser, error)

+ func (d *Driver) GetProjectFile(ctx context.Context, fileID string) (*models.ProjectFile, error)

+ func (d *Driver) GetSingleProjectDocument(ctx context.Context, param *models.CommonSystemParams) (*types.DefaultDocumentStructure, error)

+ func (d *Driver) GetSingleProjectDocumentBytes(ctx context.Context, param *models.CommonSystemParams) ([]byte, error)

+ func (d *Driver) GetSingleRawDocumentFromProject(ctx context.Context, param *models.CommonSystemParams) (interface{}, error)

+ func (d *Driver) InitProjectBase(ctx context.Context, param *models.CommonSystemParams, indexes []string) error

+ func (d *Driver) IsRemoteSQLiteLikeTurso() bool

+ func (d *Driver) ListMedias(ctx context.Context, projectId string, param *graphql.ResolveParams) ([]*models.FileDetails, error)

+ func (d *Driver) ListProjectAuthUsersByEmail(ctx context.Context, tenantID, email string) ([]*models.ProjectAuthUser, error)

+ func (d *Driver) ListProjectAuthUsersByGoogleSub(ctx context.Context, tenantID, googleSub string) ([]*models.ProjectAuthUser, error)

+ func (d *Driver) ListProjectAuthUsersByPhone(ctx context.Context, tenantID, phone string) ([]*models.ProjectAuthUser, error)

+ func (d *Driver) QueryMultiDocumentOfProject(ctx context.Context, param *models.CommonSystemParams) ([]*types.DefaultDocumentStructure, error)

+ func (d *Driver) QueryMultiDocumentOfProjectBytes(ctx context.Context, param *models.CommonSystemParams) ([]byte, error)

+ func (d *Driver) RelationshipDataLoader(ctx context.Context, param *models.CommonSystemParams, ...) (interface{}, error)

+ func (d *Driver) RelationshipDataLoaderBytes(ctx context.Context, param *models.CommonSystemParams, ...) ([]byte, error)

+ func (d *Driver) RemoveATeamMemberFromProject(ctx context.Context, projectId string, memberId string) error

+ func (d *Driver) SQLDriverShell() *sqlcommon.Driver

+ func (d *Driver) SQLEngineName() string

+ func (d *Driver) SearchProjectAuthUsers(ctx context.Context, tenantID string, limit, offset int) ([]*models.ProjectAuthUser, int, error)

+ func (d *Driver) SearchProjectFiles(ctx context.Context, param *models.CommonSystemParams) (*models.SearchResponse[models.ProjectFile], error)

+ func (d *Driver) SumProjectFilesSize(ctx context.Context) (int64, error)

+ func (d *Driver) TransferProject(ctx context.Context, userId, from, to string) error

+ func (d *Driver) UpdateDocumentOfProject(ctx context.Context, param *models.CommonSystemParams, ...) error

+ func (d *Driver) UpdateProjectAuthUser(ctx context.Context, user *models.ProjectAuthUser) error

+ func (f *Driver) CountMultiDocumentOfProject(ctx context.Context, param *models.CommonSystemParams, previewMode bool) (int, error)

+ func (s *Driver) AddRelationFields_AUTOGEN(ctx context.Context, from *models.ConnectionType, to *models.ConnectionType) error

+ func (s *Driver) AddTeamMetaInfo(ctx context.Context, docs []*models.SystemUser) ([]*models.SystemUser, error)

+ func (s *Driver) AggregateDocOfProject(ctx context.Context, param *models.CommonSystemParams) (interface{}, error)

+ func (s *Driver) AggregateDocOfProjectBytes(ctx context.Context, param *models.CommonSystemParams) ([]byte, error)

+ func (s *Driver) CheckOneToOneRelationExists(ctx context.Context, param *models.ConnectDisconnectParam) (bool, error)

+ func (s *Driver) ConvertModel(ctx context.Context, project *models.Project, modelName string) error

+ func (s *Driver) CreateIndex(ctx context.Context, param *models.CommonSystemParams, fieldName string, ...) error

+ func (s *Driver) CreateRelation(ctx context.Context, projectId string, relation *models.EdgeRelation) error

+ func (s *Driver) DeleteDocumentRelation(ctx context.Context, param *models.CommonSystemParams) error

+ func (s *Driver) DeleteDocumentsFromProject(ctx context.Context, param *models.CommonSystemParams) error

+ func (s *Driver) DeleteMediaFile(ctx context.Context, param models.CommonSystemParams) error

+ func (s *Driver) DeleteRelation(ctx context.Context, param *models.ConnectDisconnectParam, id string) error

+ func (s *Driver) DeleteRelationDocuments_AUTOGEN(ctx context.Context, projectId string, from *models.ConnectionType, ...) error

+ func (s *Driver) DropIndex(ctx context.Context, param *models.CommonSystemParams, indexName string) error

+ func (s *Driver) DropModel(ctx context.Context, project *models.Project, modelName string) error

+ func (s *Driver) DuplicateModel(ctx context.Context, project *models.Project, modelName, newName string) (*models.ProjectSchema, error)

+ func (s *Driver) GetAllRelationDocumentsOfSingleDocument_AUTOGEN(ctx context.Context, from string, arg *models.CommonSystemParams) (interface{}, error)

+ func (s *Driver) GetLoggedInProjectUser(ctx context.Context, param *models.CommonSystemParams) (*types.DefaultDocumentStructure, error)

+ func (s *Driver) GetProjectUser(ctx context.Context, phone, email, projectId string) (*types.DefaultDocumentStructure, error)

+ func (s *Driver) GetProjectUsers(ctx context.Context, projectId string, keys []string) (map[string]*types.DefaultDocumentStructure, error)

+ func (s *Driver) GetRelationDocument(ctx context.Context, param *models.ConnectDisconnectParam) (*models.EdgeRelation, error)

+ func (s *Driver) GetRelationIds(ctx context.Context, param *models.ConnectDisconnectParam) ([]string, error)

+ func (s *Driver) GetSingleProjectDocumentRevisions(ctx context.Context, param *models.CommonSystemParams) ([]*models.DocumentRevisionHistory, error)

+ func (s *Driver) NewInsertableRelations(ctx context.Context, param *models.ConnectDisconnectParam) ([]string, error)

+ func (s *Driver) RenameField(ctx context.Context, oldFieldName string, parentField string, ...) error

+ func (s *Driver) RenameModel(ctx context.Context, project *models.Project, modelName, newName string) error

+ type FieldClassification struct

+ BooleanFields []string

+ DateFields []string

+ GalleryField []string

+ ListFields []string

+ MultilineFields []string

+ ObjectField []string

+ PictureField []string

+ RepeatedFields map[string][]*models.FieldInfo

+ type Meta2 struct

+ CreatedAt time.Time

+ CreatedBy string

+ DocID string

+ ID string

+ Status string

+ UpdatedAt time.Time

+ UpdatedBy string

+ type QueryBuilderParam struct

+ Args map[string]interface{}

+ CollectionName string

+ ModelType *models.ModelType

+ ParentModel string

+ RelationName string