Debian Codegraph @

HISTORY

raw
1 2023-June-06
2
3 Version "0.9.6"
4
5 Added parameterised iterators.
6 Added documentation warning static link issues.
7 Fixed old links in docs.
8 Added support for comercial CEROD feature.
9
10 2018-June-30
11
12 Version "0.9.5"
13
14 Since the "0.9.4-devel" release of this Lua library...
15
16 Lua 5.4 compatibility (backward compatible with Lua 5.3, 5.2, and Lua 5.1.5).
17
18 2016-November-13
19
20 Version "0.9.4"
21
22 Since the "0.9.3-devel" release of this Lua library...
23
24 Add functions db:get_ptr() and sqlite3.open_ptr(db_ptr) to pass a db connection between threads.
25 Add function db:db_filename(name).
26 Update sqlite3_open to sqlite3_open_v2 and add open flags constants.
27 Thanks to Wolfgang Oertl!
28
29 Added second module 'lsqlite3complete' that statically links sqlite.c. Continue to use
30 'lsqlite3' for dynamic linking to 'sqlite3.so' or 'sqlite3.dll'.
31
32 Added Online Backup API
33
34 Added unit tests for NULs in BLOBs and TEXT columns. (Refute defect report.)
35
36 Use lua_createtable() in lieu of lua_newtable() when number of table elements is known.
37 This will improve performance.
38 Thanks to Egil Hjelmeland for the suggestion.
39
40 2015-January-06
41
42 Version "0.9.3"
43
44 Since the "0.9.2-devel" release of this Lua library...
45
46 Added lversion() function to report library version, "0.9.3".
47
48 Added db:load_extension() function to support SQLite extension libraries.
49
50 Added some tests for new funcitons and Lua 5.3 64-bit integers in the database.
51
52 Fixed longstanding bug: if db is no longer live, it is auto-closed by gc, but there may still
53 be live prepared statements. Executing these statements would produce an error. Prepared
54 statements now hold a reference to the db to prevent it from being collected while the prepared
55 statement is live. Manually closing the db will continue to finalize the statements, as before.
56
57 Fixed bug in PUSH_INT64 macro for Lua < 5.3 introduced in version 0.9.2-devel.
58
59 2015-January-04
60
61 Version "0.9.2-devel"
62
63 Since the "0.9.1-devel" release of this Lua library...
64
65 Lua 5.3 compatibility (backward compatible with Lua 5.2 and Lua 5.1.5).
66
67 Finally uses sqlite3_prepare_v2() to preserve detailed error codes in statement stepping
68
69 With Lua 5.3, 64-bit integer database values are supported for reading and writing columns;
70 all other values, e.g., status and counts, are now also returned as integers. The only use of
71 doubles is for values of that type read from or written to columns.
72
73 Added support for stmt:last_insert_rowid() as requested
74
75 2013-April-08
76
77 Version "0.9.1-devel"
78
79 Since the "0.9-devel" release of this Lua library...
80
81 Updated examples and tests from Dmitry Pashkevich.
82
83 2013-March-30
84
85 Version "0.9-devel"
86
87 Since the "0.8-devel" release of this Lua library...
88
89 Updates for Lua 5.2 (backward compatible with Lua 5.1.5).
90
91 Uses lunitx-0.6-1.rockspec for Lua 5.2 compatible testing.
92
93 Added sqlite3.update_hook(), sqlite3.commit_hook() and
94 sqlite3.rollback_hook() at the suggesiton of Dmitry Pashkevich, who
95 also contributed examples and some testing assistance on this release.
96
97 Converted Makefile to depend on luarocks.
98
99 2011-January-10
100
101 Version "0.8-devel"
102
103 Since the "0.7-devel" release of this Lua library...
104
105 Added a missing lua_pop in dbvm_bind_names()
106 Now dbvm_bind_index() binds a boolean as 1 or 0
107 Thanks to Ronny Dierckx
108
109 Since the "0.6-devel" release of this Lua library...
110
111 Made db_exec_callback thread safe.
112 Thanks to Grant Robinson.
113
114 Bug fix in dbvm_bind_index error message.
115 Thanks to Dirk Feytons.
116
117 Added a few casts and changed a few comments to ANSI C style.
118 Thanks to Corey Stup.
119
120 Note that Thomas Lauer has a patch referenced on LuaForge
121 to make collations thread safe(r). This issue is still
122 under investigation: the patch has wide ranging affect
123 and to me it appears unsafe wrt GC. The whole issue of
124 thread references in callbacks deserves thorough review.
125 A new design that places referenced values in the upvalues
126 of the callback function (rather than in the registry of
127 the function defining thread) would be preferable. It may
128 also make sense to keep thread references in a shared
129 environment of the library's functions, and/or require
130 all callbacks to be defined in the main lua state (so
131 they the state is guaranteed to outlive other threads).
132
133 -=-
134
135 2007-August-15 e
136
137 Version "0.6-devel"
138
139 Since the "0.5-devel" release of this Lua library...
140
141 Tested with SQLite 3.4.2
142
143 Added some documentation.
144
145 Thanks to Thomas Lauer...
146
147 Moved line 525 ("luaL_checktype(L, 2, LUA_TTABLE);")
148 below the declarations to eliminate non-gcc compiler errors.
149
150 Added create-collation, and associated test case.
151
152 -=-
153
154 2006-October-02 e
155
156 Since the "0.1-devel" release of this Lua library...
157 - updated for Lua 5.1
158 - provide automatic re-preparation of queries after schema changes
159 - made prepared statements with bindings work with for-loops
160 - added some compatibility names
161 - added many test cases, and ported Mike Roth's tests and examples
162
163 -=-
164
165 Below is a header comment from the 2004 "0.1" version of the library...
166
167 /************************************************************************
168 $Id: lsqlite3.c,v 1.3 2004/09/05 17:50:32 tngd Exp $
169
170 To consider:
171 ------------
172
173 EXPERIMENTAL APIs
174
175 * sqlite3_progress_handler (implemented)
176 * sqlite3_commit_hook
177
178 TODO?
179
180 * sqlite3_create_collation
181
182 Changes:
183 04-09-2004
184 ----------
185 * changed second return value of db:compile to be the rest of the
186 sql statement that was not processed instead of the number of
187 characters of sql not processed (situation in case of success).
188 * progress callback register function parameter order changed.
189 number of opcodes is given before the callback now.
190
191 29-08-2004 e
192 ------------
193 * added version() (now supported in sqlite 3.0.5)
194 * added db:errmsg db:errcode db:total_changes
195 * rename vm:get_column to vm:get_value
196 * merge in Tiago's v1.11 change in dbvm_tostring
197
198 23-06-2004 e
199 ------------
200 * heavily revised for SQLite3 C API
201 * row values now returned as native type (not always text)
202 * added db:nrows (named rows)
203 * added vm:bind_blob
204 * added vm:get_column
205 * removed encode_binary decode_binary (no longer needed or supported)
206 * removed version encoding error_string (unsupported in v 3.0.1 -- soon?)
207
208 09-04-2004
209 ----------
210 * renamed db:rows to db:urows
211 * renamed db:prows to db:rows
212
213 * added vm:get_unames()
214 * added vm:get_utypes()
215 * added vm:get_uvalues()
216
217 08-04-2004
218 ----------
219 * changed db:encoding() and db:version() to use sqlite_libencoding() and
220 sqlite_libversion()
221
222 * added vm:columns()
223 * added vm:get_named_types()
224 * added vm:get_named_values()
225
226 * added db:prows - like db:rows but returns a table with the column values
227 instead of returning multiple columns seperatly on each iteration
228
229 * added compatibility functions idata,iname,itype,data,type
230
231 * added luaopen_sqlite_module. allow the library to be loaded without
232 setting a global variable. does the same as luaopen_sqlite, but does not
233 set the global name "sqlite".
234
235 * vm:bind now also returns an error string in case of error
236
237 31-03-2004 - 01-04-2004
238 -----------------------
239 * changed most of the internals. now using references (luaL_ref) in
240 most of the places
241
242 * make the virtual machine interface seperate from the database
243 handle. db:compile now returns a vm handle
244
245 * added db:rows [for ... in db:rows(...) do ... end]
246
247 * added db:close_vm
248
249 * added sqlite.encode_binary and sqlite.decode_binary
250
251 * attempt to do a strict checking on the return type of the user
252 defined functions returned values
253
254 18-01-2004
255 ----------
256 * add check on sql function callback to ensure there is enough stack
257 space to pass column values as parameters
258
259 03-12-2003
260 ----------
261 * callback functions now have to return boolean values to abort or
262 continue operation instead of a zero or non-zero value
263
264 06-12-2003
265 ----------
266 * make version member of sqlite table a function instead of a string
267 ************************************************************************/