README
¶
This package provides GopherJS bindings around SQL.js, and a database/sql/driver implementation, for use with the standard Go Database driver infrastructure.
SQL.js is SQLite compiled to JavaScript through Emscripten, which can run in the browser. If your goal is to use SQLite from Go, you should use mattn/go-sqlite3 or go-sqlite instead. If your intention is to use SQLite within GopherJS running on node.js, you should probably use the sqlite3 package instead (which as far as I know, has no GopherJS bindings at the moment).
To be clear: You should only use this package if you are writing code for GopherJS which must run in the browser.
This does not support storing databases on the filesystem--it only supports in-memory databases (which may be imported from binary blobs). The database/sql driver also does not support transactions (what value would they be in an in-memory, in-browser database, anyway?)
Build instructions
As this package provides bindings for a JavaScript package, naturally the JavaScript must be installed to successfully use these bindings. In your GopherJS package, which depends on this one, you can add a package.json which includes sql.js as a dependency, then run npm install prior to building the GopherJS package.
Documentation
¶
Overview ¶
Package sqljs provides a database/sql-compatible interface to SQL.js (https://github.com/lovasoa/sql.js) for GopherJS.
SQL.js does not provide anything like a complete SQLite3 API, and this module even less so. This module exists for one primary purpose: To be able to read SQLite3 databases from within a browser. For such purposes, only a small subset of features is considered useful. To this end, this module is tested only for reading databases. Although writes are supported, there is currently no way to export the database using this package. Also, transactions are not supported.
Index ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
Types ¶
type SQLJSConn ¶
Connection struct
type SQLJSDriver ¶
type SQLJSDriver struct{}
Driver struct. To load an existing database, you must register a new instance of this driver, with an io.Reader pointing to the SQLite3 database file. See Open() for an example.
func (*SQLJSDriver) Open ¶
func (d *SQLJSDriver) Open(dsn string) (driver.Conn, error)
Open will a new database instance. By default, it will create a new database in memory. To open an existing database, you must first register a new instance as the driver. The DSN string is always ignored.
Example:
driver := &sqljs.SQLJSDriver{}
sql.Register("sqljs-reader", driver)
file, _ := os.Open("/path/to/database.db")
driver.Reader, _ = file
db := sql.Open("sqljs-reader","")
type SQLJSResult ¶
type SQLJSResult struct {
// contains filtered or unexported fields
}
Result struct.
func (SQLJSResult) LastInsertId ¶
func (SQLJSResult) LastInsertId() (int64, error)
LastInsertId is not supported. It will always return an error.
func (*SQLJSResult) RowsAffected ¶
func (s *SQLJSResult) RowsAffected() (int64, error)
RowsAffected is not supported. It will always return an error.
Source Files
Directories