PLaneT Package Repository : PLaneT > jaymccarthy

PLaneT > jaymccarthy > sqlite.plt

View packages: 4.x | [3xx]
[contribute a package / log in]

Package sqlite.plt contributed by jaymccarthy

To load: (require (planet jaymccarthy/sqlite:3:1/sqlite))

Old style: (require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 1)))

Package description:

Allows access to SQLite databases.

Downloads this week: 0

Total downloads: 8329

Tickets: 0

Open tickets: 0

Primary files:

sqlite.ss

Name	Contract
`SQLITE_OK`	—
`SQLITE_ERROR`	—
`db-handle`	(c-> db? cpointer?)
`statement-handle`	(c-> statement? cpointer?)
`open`	(c-> path? db?)
`close`	(c-> db? void?)
`exec`	(c-> db? string? (c-> vector? vector? integer?) void?)
`exec/ignore`	(c-> db? string? void?)
`insert`	(c-> db? string? integer?)
`select`	(c-> db? string? (listof vector?))
`prepare`	(c-> db? string? statement?)
`load-params`	(->* (statement?) (listof (union string? number? bytes?)) (void?))
`step`	(c-> statement? (union (vectorof (union string? number? false/c bytes?)) false/c))
`run`	(->* (statement?) (listof (union string? number? bytes?)) (void?))
`reset`	(c-> statement? void?)
`finalize`	(c-> statement? void?)
`errmsg`	(c-> db? string?)
`changes-count`	(c-> db? integer?)
`total-changes-count`	(c-> db? integer?)
`step*`	(c-> statement? (listof (vectorof (union string? number? false/c bytes?))))
`with-transaction*`	(c-> db? (symbols 'none 'deferred 'immediate 'exclusive) (c-> any/c any/c) any/c)
`with-transaction/lock`	—
`with-transaction`	—
`(struct exn:sqlite ())`	—
`statement?`	—
`db?`	—

Current version

PLaneT version	External version	Source	DLs	Docs	Req. PLT	Date added
(3 1)	—	[browse]	1149	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet jaymccarthy/sqlite:3:1/sqlite))`
Available in repositories: 4.x, 3xx
[no release notes]

No Tickets Currently open for this Package [New Ticket]

Old versions

PLaneT version	External version	Source	DLs	Docs	Req. PLT	Date added
(3 0)	—	[browse]	194	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 (= 0))))`
Available in repositories: 4.x, 3xx
[no release notes]
(2 0)	—	[browse]	198	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 2 (= 0))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 9)	—	[browse]	1080	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 9))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 8)	—	[browse]	3	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 8))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 7)	—	[browse]	5	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 7))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 6)	—	[browse]	9	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 6))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 5)	—	[browse]	5	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 5))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 4)	—	[browse]	9	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 4))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 3)	—	[browse]	3	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 3))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 2)	—	[browse]	5	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 2))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 1)	—	[browse]	3	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 1))))`
Available in repositories: 4.x, 3xx
[no release notes]
(1 0)	—	[browse]	3	[none]	[none]	Sunday, April 1st, 2007
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 1 (= 0))))`
Available in repositories: 4.x, 3xx
[no release notes]

Packages in other repositories

These packages are not available in the 3xx repository, but they are available for other versions of Racket.

PLaneT version	External version	Source	DLs	Docs	Req. PLT	Date added
(5 1)	—	[browse]	545	[none]	[none]	Friday, May 6th, 2011
To load: `(require (planet "sqlite.rkt" ("jaymccarthy" "sqlite.plt" 5 (= 1))))`
Available in repositories: 4.x
Rackety
(5 0)	—	[browse]	203	[none]	[none]	Friday, September 3rd, 2010
To load: `(require (planet "sqlite.rkt" ("jaymccarthy" "sqlite.plt" 5 (= 0))))`
Available in repositories: 4.x
Rackety
(4 6)	—	[browse]	1761	[none]	[none]	Thursday, December 17th, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 4 (= 6))))`
Available in repositories: 4.x
Allowing negative INTEGER column values
(4 5)	—	[browse]	2106	[none]	[none]	Monday, July 27th, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 4 (= 5))))`
Available in repositories: 4.x
Exposing statement-names
(4 4)	—	[browse]	23	[none]	[none]	Wednesday, July 22nd, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 4 (= 4))))`
Available in repositories: 4.x
Better contracts for statement operations Improve syntax error messages
(4 3)	—	[browse]	109	[none]	[none]	Monday, June 22nd, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 4 (= 3))))`
Available in repositories: 4.x
Bug in handling of REAL, VARCHAR, and other column types
(4 2)	—	[browse]	33	[none]	[none]	Friday, June 5th, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 4 (= 2))))`
Available in repositories: 4.x
Bug in handling of returned NULL values Fixed a 64-bit bug Does not use malloc anymore select/exec/insert are now implemented in PLT Scheme, which causes them to have backwards incompatible contracts select/exec/insert now support parameters for loading into the implicit statement The FFI now has contracts
(4 1)	—	[browse]	132	[none]	[none]	Monday, March 9th, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 4 (= 1))))`
Available in repositories: 4.x
Fixed a 64-bit bug Does not use malloc anymore select/exec/insert are now implemented in PLT Scheme, which causes them to have backwards incompatible contracts select/exec/insert now support parameters for loading into the implicit statement The FFI now has contracts
(4 0)	—	[browse]	12	[none]	[none]	Tuesday, February 24th, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 4 (= 0))))`
Available in repositories: 4.x
Fixed a 64-bit bug Does not use malloc anymore select/exec/insert are now implemented in PLT Scheme, which causes them to have backwards incompatible contracts select/exec/insert now support parameters for loading into the implicit statement The FFI now has contracts
(3 8)	—	[browse]	273	[none]	[none]	Friday, February 13th, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 (= 8))))`
Available in repositories: 4.x
Updated to PLT 4.0
(3 7)	—	[browse]	81	[none]	[none]	Wednesday, January 21st, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 (= 7))))`
Available in repositories: 4.x
Updated to PLT 4.0
(3 6)	—	[browse]	3	[none]	[none]	Wednesday, January 21st, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 (= 6))))`
Available in repositories: 4.x
Updated to PLT 4.0
(3 5)	—	[browse]	29	[none]	[none]	Monday, January 12th, 2009
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 (= 5))))`
Available in repositories: 4.x
Updated to PLT 4.0
(3 4)	—	[browse]	181	[none]	[none]	Tuesday, October 14th, 2008
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 (= 4))))`
Available in repositories: 4.x
Updated to PLT 4.0
(3 3)	—	[browse]	23	[none]	[none]	Tuesday, September 30th, 2008
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 (= 3))))`
Available in repositories: 4.x
Updated to PLT 4.0
(3 2)	—	[browse]	149	[none]	[none]	Monday, August 11th, 2008
To load: `(require (planet "sqlite.ss" ("jaymccarthy" "sqlite.plt" 3 (= 2))))`
Available in repositories: 4.x
Updated to PLT 4.0