"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "vendor/github.com/mattn/go-sqlite3/README.md" between
gitea-1.9.3.tar.gz and gitea-1.9.4.tar.gz

About: Gitea allows to set up a self-hosted code hosting Git service (a fork of Gogs).

README.md  (gitea-1.9.3):README.md  (gitea-1.9.4)
skipping to change at line 13 skipping to change at line 13
[![GoDoc Reference](https://godoc.org/github.com/mattn/go-sqlite3?status.svg)](h ttp://godoc.org/github.com/mattn/go-sqlite3) [![GoDoc Reference](https://godoc.org/github.com/mattn/go-sqlite3?status.svg)](h ttp://godoc.org/github.com/mattn/go-sqlite3)
[![Build Status](https://travis-ci.org/mattn/go-sqlite3.svg?branch=master)](http s://travis-ci.org/mattn/go-sqlite3) [![Build Status](https://travis-ci.org/mattn/go-sqlite3.svg?branch=master)](http s://travis-ci.org/mattn/go-sqlite3)
[![Coverage Status](https://coveralls.io/repos/mattn/go-sqlite3/badge.svg?branch =master)](https://coveralls.io/r/mattn/go-sqlite3?branch=master) [![Coverage Status](https://coveralls.io/repos/mattn/go-sqlite3/badge.svg?branch =master)](https://coveralls.io/r/mattn/go-sqlite3?branch=master)
[![Go Report Card](https://goreportcard.com/badge/github.com/mattn/go-sqlite3)]( https://goreportcard.com/report/github.com/mattn/go-sqlite3) [![Go Report Card](https://goreportcard.com/badge/github.com/mattn/go-sqlite3)]( https://goreportcard.com/report/github.com/mattn/go-sqlite3)
# Description # Description
sqlite3 driver conforming to the built-in database/sql interface sqlite3 driver conforming to the built-in database/sql interface
Supported Golang version: Supported Golang version: See .travis.yml
- 1.9.x
- 1.10.x
[This package follows the official Golang Release Policy.](https://golang.org/do c/devel/release.html#policy) [This package follows the official Golang Release Policy.](https://golang.org/do c/devel/release.html#policy)
### Overview ### Overview
- [Installation](#installation) - [Installation](#installation)
- [API Reference](#api-reference) - [API Reference](#api-reference)
- [Connection String](#connection-string) - [Connection String](#connection-string)
- [Features](#features) - [Features](#features)
- [Compilation](#compilation) - [Compilation](#compilation)
skipping to change at line 252 skipping to change at line 250
## Mac OSX ## Mac OSX
OSX should have all the tools present to compile this package, if not install XC ode this will add all the developers tools. OSX should have all the tools present to compile this package, if not install XC ode this will add all the developers tools.
Required dependency Required dependency
```bash ```bash
brew install sqlite3 brew install sqlite3
``` ```
For OSX there is an additional package install which is required if you whish to build the `icu` extension. For OSX there is an additional package install which is required if you wish to build the `icu` extension.
This additional package can be installed with `homebrew`. This additional package can be installed with `homebrew`.
```bash ```bash
brew upgrade icu4c brew upgrade icu4c
``` ```
To compile for Mac OSX. To compile for Mac OSX.
```bash ```bash
skipping to change at line 285 skipping to change at line 283
## Windows ## Windows
To compile this package on Windows OS you must have the `gcc` compiler installed . To compile this package on Windows OS you must have the `gcc` compiler installed .
1) Install a Windows `gcc` toolchain. 1) Install a Windows `gcc` toolchain.
2) Add the `bin` folders to the Windows path if the installer did not do this by default. 2) Add the `bin` folders to the Windows path if the installer did not do this by default.
3) Open a terminal for the TDM-GCC toolchain, can be found in the Windows Start menu. 3) Open a terminal for the TDM-GCC toolchain, can be found in the Windows Start menu.
4) Navigate to your project folder and run the `go build ...` command for this p ackage. 4) Navigate to your project folder and run the `go build ...` command for this p ackage.
For example the TDM-GCC Toolchain can be found [here](ttps://sourceforge.net/pro jects/tdm-gcc/). For example the TDM-GCC Toolchain can be found [here](https://sourceforge.net/pr ojects/tdm-gcc/).
## Errors ## Errors
- Compile error: `can not be used when making a shared object; recompile with -f PIC` - Compile error: `can not be used when making a shared object; recompile with -f PIC`
When receiving a compile time error referencing recompile with `-FPIC` then you When receiving a compile time error referencing recompile with `-FPIC` then you
are probably using a hardend system. are probably using a hardend system.
You can compile the library on a hardend system with the following command. You can compile the library on a hardend system with the following command.
skipping to change at line 461 skipping to change at line 459
Use `_loc=auto` in SQLite3 filename schema like `file:foo.db?_loc=auto`. Use `_loc=auto` in SQLite3 filename schema like `file:foo.db?_loc=auto`.
- Can I use this in multiple routines concurrently? - Can I use this in multiple routines concurrently?
Yes for readonly. But, No for writable. See [#50](https://github.com/mattn/g o-sqlite3/issues/50), [#51](https://github.com/mattn/go-sqlite3/issues/51), [#20 9](https://github.com/mattn/go-sqlite3/issues/209), [#274](https://github.com/ma ttn/go-sqlite3/issues/274). Yes for readonly. But, No for writable. See [#50](https://github.com/mattn/g o-sqlite3/issues/50), [#51](https://github.com/mattn/go-sqlite3/issues/51), [#20 9](https://github.com/mattn/go-sqlite3/issues/209), [#274](https://github.com/ma ttn/go-sqlite3/issues/274).
- Why I'm getting `no such table` error? - Why I'm getting `no such table` error?
Why is it racy if I use a `sql.Open("sqlite3", ":memory:")` database? Why is it racy if I use a `sql.Open("sqlite3", ":memory:")` database?
Each connection to :memory: opens a brand new in-memory sql database, so if Each connection to `":memory:"` opens a brand new in-memory sql database, so if
the stdlib's sql engine happens to open another connection and you've only the stdlib's sql engine happens to open another connection and you've only
specified ":memory:", that connection will see a brand new database. A specified `":memory:"`, that connection will see a brand new database. A
workaround is to use "file::memory:?mode=memory&cache=shared". Every workaround is to use `"file::memory:?cache=shared"` (or `"file:foobar?mode=m
emory&cache=shared"`). Every
connection to this string will point to the same in-memory database. connection to this string will point to the same in-memory database.
Note that if the last database connection in the pool closes, the in-memory
database is deleted. Make sure the [max idle connection limit](https://golang.or
g/pkg/database/sql/#DB.SetMaxIdleConns) is > 0, and the [connection lifetime](ht
tps://golang.org/pkg/database/sql/#DB.SetConnMaxLifetime) is infinite.
For more information see For more information see
* [#204](https://github.com/mattn/go-sqlite3/issues/204) * [#204](https://github.com/mattn/go-sqlite3/issues/204)
* [#511](https://github.com/mattn/go-sqlite3/issues/511) * [#511](https://github.com/mattn/go-sqlite3/issues/511)
* https://www.sqlite.org/sharedcache.html#shared_cache_and_in_memory_databas
es
* https://www.sqlite.org/inmemorydb.html#sharedmemdb
- Reading from database with large amount of goroutines fails on OSX. - Reading from database with large amount of goroutines fails on OSX.
OS X limits OS-wide to not have more than 1000 files open simultaneously by default. OS X limits OS-wide to not have more than 1000 files open simultaneously by default.
For more information see [#289](https://github.com/mattn/go-sqlite3/issues/2 89) For more information see [#289](https://github.com/mattn/go-sqlite3/issues/2 89)
- Trying to execute a `.` (dot) command throws an error. - Trying to execute a `.` (dot) command throws an error.
Error: `Error: near ".": syntax error` Error: `Error: near ".": syntax error`
Dot command are part of SQLite3 CLI not of this library. Dot command are part of SQLite3 CLI not of this library.
You need to implement the feature or call the sqlite3 cli. You need to implement the feature or call the sqlite3 cli.
More infomation see [#305](https://github.com/mattn/go-sqlite3/issues/305) More information see [#305](https://github.com/mattn/go-sqlite3/issues/305)
- Error: `database is locked` - Error: `database is locked`
When you get an database is locked. Please use the following options. When you get a database is locked. Please use the following options.
Add to DSN: `cache=shared` Add to DSN: `cache=shared`
Example: Example:
```go ```go
db, err := sql.Open("sqlite3", "file:locked.sqlite?cache=shared") db, err := sql.Open("sqlite3", "file:locked.sqlite?cache=shared")
``` ```
Second please set the database connections of the SQL package to 1. Second please set the database connections of the SQL package to 1.
```go ```go
db.SetMaxOpenConn(1) db.SetMaxOpenConns(1)
``` ```
More information see [#209](https://github.com/mattn/go-sqlite3/issues/209) More information see [#209](https://github.com/mattn/go-sqlite3/issues/209)
# License # License
MIT: http://mattn.mit-license.org/2018 MIT: http://mattn.mit-license.org/2018
sqlite3-binding.c, sqlite3-binding.h, sqlite3ext.h sqlite3-binding.c, sqlite3-binding.h, sqlite3ext.h
 End of changes. 10 change blocks. 
11 lines changed or deleted 18 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)