SQLiteFS is a Go package that implements the fs.FS interface using SQLite as a storage backend. This allows you to store and access files directly from a SQLite database, which can be useful for embedded applications, resource-constrained systems, or when you need a unified storage for both files and metadata.
- Implementation of the
fs.FSinterface - File storage in SQLite database
- Support for concurrent writes through a shared channel
- Fragmented file storage for efficient handling of large files
- Automatic MIME type detection for files
To use SQLiteFS in your Go project, run the following command:
go get github.com/jilio/sqlitefs
Here's a simple example of how to use SQLiteFS:
package main
import (
"database/sql"
"fmt"
"io/fs"
"log"
"github.com/jilio/sqlitefs"
_ "modernc.org/sqlite"
)
func main() {
// Open a connection to the SQLite database
db, err := sql.Open("sqlite", "files.db")
if err != nil {
log.Fatal(err)
}
defer db.Close()
// Create a new instance of SQLiteFS
sqliteFS, err := sqlitefs.NewSQLiteFS(db)
if err != nil {
log.Fatal(err)
}
defer sqliteFS.Close()
// Write a file
writer := sqlitefs.NewSQLiteWriter(sqliteFS, "example.txt")
_, err = writer.Write([]byte("Hello, SQLiteFS!"))
if err != nil {
log.Fatal(err)
}
err = writer.Close()
if err != nil {
log.Fatal(err)
}
// Read a file
file, err := sqliteFS.Open("example.txt")
if err != nil {
log.Fatal(err)
}
defer file.Close()
content, err := fs.ReadFile(sqliteFS, "example.txt")
if err != nil {
log.Fatal(err)
}
fmt.Printf("File content: %s\n", content)
}