datatug_sqlite

datatug-sqlite

SQLite provider for DataTug.app

Overview

This package provides SQLite database schema introspection capabilities for DataTug. It implements the SchemaProvider interface from datatug-core to extract metadata about SQLite database objects including:

• Tables and views
• Columns with types and constraints
• Indexes and index columns
• Foreign key constraints

Installation

go get github.com/datatug/datatug-sqlite

Usage

import (
    "database/sql"
    "github.com/datatug/datatug-sqlite/pkg/sqlite"
    _ "github.com/mattn/go-sqlite3"
)

// Create a schema provider
provider := sqlite.NewSchemaProvider()

// Use the provider to extract database schema information
// See datatug-core documentation for full API details

Package Structure

• pkg/sqlite/ - SQLite schema provider implementation
  • schema.go - Main provider implementation
  • tables.go - Table metadata extraction
  • columns.go - Column metadata extraction
  • indexes.go - Index metadata extraction
  • index_columns.go - Index column metadata extraction
  • constraints.go - Foreign key constraint extraction
  • *.sql - SQL queries for metadata extraction

License

See LICENSE file for details.