| 1 |
libdbi NEWS file |
| 2 |
================ |
| 3 |
|
| 4 |
$Id: NEWS,v 1.9 2013/03/12 00:08:12 mhoenicka Exp $ |
| 5 |
|
| 6 |
______________________________________ |
| 7 |
libdbi 0.9.0 (the "Autumn Shade" release) |
| 8 |
|
| 9 |
Bugfixes |
| 10 |
|
| 11 |
- libdbi now supports using custom driver functions correctly (none of |
| 12 |
the drivers had implemented this feature before libdbi-drivers 0.9.0, so |
| 13 |
this was not really a problem). |
| 14 |
|
| 15 |
- a variety of other bug fixes too numerous to list here, see ChangeLog |
| 16 |
|
| 17 |
Improvements |
| 18 |
|
| 19 |
- libdbi now supports several independent "instances" per |
| 20 |
process. This makes the library safe to use in programs that |
| 21 |
dlopen() plugins at runtime which in turn are linked against |
| 22 |
libdbi. The new function dbi_initialize_r() creates a handle which |
| 23 |
the functions dbi_shutdown_r(), dbi_set_verbosity_r(), |
| 24 |
dbi_driver_list_r(), dbi_driver_open_r(), and dbi_conn_new_r() use |
| 25 |
to operate on a particular instance. A new function |
| 26 |
dbi_driver_get_instance() helps to determine the instance at runtime. |
| 27 |
The old interface (with just one instance per process which is |
| 28 |
managed internally) is still around but deprecated. See the file |
| 29 |
UPGRADING for detailed instructions. |
| 30 |
|
| 31 |
- libdbi now provides functions for managing transactions and savepoints |
| 32 |
|
| 33 |
- libdbi now provides a hint to drivers indicating the current position |
| 34 |
in a result set. This allows drivers to implement additional optimizations |
| 35 |
|
| 36 |
- the libtool library versioning numbers were now set appropriately |
| 37 |
(they had fallen out of maintenance somehow in the past), and starting |
| 38 |
with this release the release number will match the libtool numbering |
| 39 |
scheme. libtool manages shared objects in a way to allow the loader |
| 40 |
to detect whether an application was linked against a compatible |
| 41 |
version of a library. This will avoid runtime errors in future |
| 42 |
releases if backwards-incompatible changes are necessary. |
| 43 |
|
| 44 |
- pgk-config (http://pkg-config.freedesktop.org/wiki/) is now supported |
| 45 |
|
| 46 |
- if CFLAGS is set in the environment, it is now used appropriately in |
| 47 |
./configure |
| 48 |
|
| 49 |
|
| 50 |
______________________________________ |
| 51 |
libdbi 0.8.3 (the "Steeltown" release) |
| 52 |
|
| 53 |
Bugfixes |
| 54 |
|
| 55 |
- database engine client libraries which install exit handlers are not |
| 56 |
safe to unload on some systems. libdbi now checks the driver |
| 57 |
capability "safe_dlclose" and unloads the driver only if the driver |
| 58 |
claims it is safe to do so. |
| 59 |
|
| 60 |
Improvements |
| 61 |
|
| 62 |
- three functions were added: dbi_conn_escape_string(), |
| 63 |
dbi_conn_escape_string_copy(), and dbi_conn_escape_binary_copy() |
| 64 |
perform the same escaping of special characters as the corresponding |
| 65 |
*_quote_* functions do, but they do not surround the resulting |
| 66 |
string with quotes. This may at times be more convenient if the |
| 67 |
escaped strings are not directly inserted into a SQL query. |
| 68 |
|
| 69 |
- error handling and reporting was changed once again. The |
| 70 |
dbi_conn_error_flag() function is now deprecated. Instead, a call of |
| 71 |
dbi_conn_error() is all it takes to check the error status. This |
| 72 |
function returns zero if the last operation was successful, < 0 (one |
| 73 |
of several predefined libdbi error codes) for internal errors, and > 0 |
| 74 |
for client library errors. To maintain backwards compatibility, |
| 75 |
dbi_conn_error_flags() reports the same error codes as |
| 76 |
dbi_conn_error() so older code should not break as long as you checked |
| 77 |
against the predefined error codes. |
| 78 |
|
| 79 |
- deprecated functions will now cause compiler warnings to make you |
| 80 |
aware of this fact. This does not negatively affect your programs |
| 81 |
but it kindly reminds you of the fact that right now is a good time to |
| 82 |
modify your sources. |
| 83 |
|
| 84 |
|
| 85 |
__________________________________________________________ |
| 86 |
libdbi 0.8.2 (the "Sunday Night Buttermilk Waltz" release) |
| 87 |
|
| 88 |
Minor enhancements: |
| 89 |
|
| 90 |
- the TIME and DATETIME types now support a numeric timezone suffix, |
| 91 |
like in "23:12:30+01:00" |
| 92 |
- improved error handling and error reporting code |
| 93 |
- some memory leaks were plugged |
| 94 |
- the "--disable-docs" configure switch now allows to build libdbi |
| 95 |
without having the sgml toolchain installed |
| 96 |
|
| 97 |
|
| 98 |
___________________________________________ |
| 99 |
libdbi 0.8.1 (the "Get used to it" release) |
| 100 |
|
| 101 |
This is a bugfix release. It fixes the following bug: |
| 102 |
|
| 103 |
- dbi_result_get_string_idx() and dbi_result_get_string() returned |
| 104 |
NULL if the database returned an empty string. However, ''!= NULL in |
| 105 |
SQL. Now the functions correctly return a pointer to an |
| 106 |
empty string if the database returns an empty string, and NULL if the |
| 107 |
database returns NULL. The functions |
| 108 |
dbi_result_get_string_copy_idx() and dbi_result_get_string_copy() were |
| 109 |
not affected by this bug. |
| 110 |
|
| 111 |
|
| 112 |
_______________________________________________ |
| 113 |
libdbi 0.8.0 (the "When I come around" release) |
| 114 |
|
| 115 |
Major internal fixes. Remember that the integer type changes are |
| 116 |
mostly silent on 32bit platforms, but you should check in detail. The |
| 117 |
changes in the return codes of some functions require particular |
| 118 |
attention. |
| 119 |
|
| 120 |
|
| 121 |
- Functions that return string sizes or accept string sizes as an |
| 122 |
argument now use size_t throughout. Affected functions are: |
| 123 |
|
| 124 |
dbi_driver_quote_string() |
| 125 |
dbi_driver_quote_string_copy() |
| 126 |
dbi_conn_query_null() |
| 127 |
dbi_result_get_field_length() |
| 128 |
dbi_result_get_field_length_idx() |
| 129 |
dbi_result_get_field_size() |
| 130 |
dbi_result_get_field_size_idx() |
| 131 |
|
| 132 |
as well as the new dbi_conn_quote_* functions |
| 133 |
|
| 134 |
|
| 135 |
- Functions that deal with field indexes or field counts now use |
| 136 |
unsigned int throughout. Affected functions are: |
| 137 |
|
| 138 |
dbi_result_get_field_idx() |
| 139 |
dbi_result_get_field_name() |
| 140 |
dbi_result_get_numfields() |
| 141 |
dbi_result_get_field_type_idx() |
| 142 |
dbi_result_get_field_attrib_idx() |
| 143 |
dbi_result_get_field_attribs_idx() |
| 144 |
dbi_result_field_is_null_idx() |
| 145 |
dbi_result_get_fields() |
| 146 |
dbi_result_bind_fields() |
| 147 |
dbi_result_get_char_idx() |
| 148 |
dbi_result_get_uchar_idx() |
| 149 |
dbi_result_get_short_idx() |
| 150 |
dbi_result_get_ushort_idx() |
| 151 |
dbi_result_get_long_idx() |
| 152 |
dbi_result_get_int_idx() |
| 153 |
dbi_result_get_uint_idx() |
| 154 |
dbi_result_get_ulong_idx() |
| 155 |
dbi_result_get_longlong_idx() |
| 156 |
dbi_result_get_ulonglong_idx() |
| 157 |
dbi_result_get_float_idx() |
| 158 |
dbi_result_get_double_idx() |
| 159 |
dbi_result_get_string_idx() |
| 160 |
dbi_result_get_binary_idx() |
| 161 |
dbi_result_get_string_copy_idx() |
| 162 |
dbi_result_get_binary_copy_idx() |
| 163 |
dbi_result_get_datetime_idx() |
| 164 |
|
| 165 |
|
| 166 |
- Functions that get or bind 4-byte integers were renamed and their |
| 167 |
return type was changed from long to int, because long is an 8byte |
| 168 |
value on 64bit platforms. The old versions are still around, but they |
| 169 |
also use int as the return type. |
| 170 |
|
| 171 |
long dbi_result_get_long() -> int dbi_result_get_int() |
| 172 |
long dbi_result_get_ulong() -> int dbi_result_get_uint() |
| 173 |
long dbi_result_get_long_idx() -> int dbi_result_get_int_idx() |
| 174 |
long dbi_result_get_ulong_idx() -> int dbi_result_get_uint_idx() |
| 175 |
dbi_result_bind_long() -> dbi_result_bind_int() |
| 176 |
dbi_result_bind_ulong() -> dbi_result_bind_uint() |
| 177 |
|
| 178 |
|
| 179 |
- Field attributes are now implemented using unsigned int instead of |
| 180 |
unsigned long. Functions that deal with attributes were adapted |
| 181 |
accordingly: |
| 182 |
|
| 183 |
dbi_result_get_field_attrib() |
| 184 |
dbi_result_get_field_attrib_idx() |
| 185 |
dbi_result_get_field_attribs() |
| 186 |
dbi_result_get_field_attribs_idx() |
| 187 |
|
| 188 |
|
| 189 |
- The return values in case of an error were changed in the following |
| 190 |
functions: |
| 191 |
|
| 192 |
dbi_result_get_field_length(): DBI_LENGTH_ERROR instead of 0 |
| 193 |
dbi_driver_quote_string(), dbi_driver_quote_string_copy(): 0 instead |
| 194 |
of -1 |
| 195 |
dbi_result_seek_row(): 0 instead of (0 or -1) |
| 196 |
dbi_result_get_numrows(): DBI_ROW_ERROR instead of 0 |
| 197 |
dbi_result_get_field_length(), dbi_result_get_field_length_idx(), |
| 198 |
dbi_result_get_field_size(), dbi_result_get_field_size_idx(): |
| 199 |
DBI_LENGTH_ERROR instead of 0 |
| 200 |
dbi_result_get_field_type(),dbi_result_get_field_type_idx(): |
| 201 |
DBI_TYPE_ERROR instead of 0 (the same numerical value!) |
| 202 |
dbi_result_get_field_attrib(), dbi_result_get_field_attrib_idx(), |
| 203 |
dbi_result_get_field_attribs(), dbi_result_get_field_attribs_idx(): |
| 204 |
DBI_ATTRIBUTE_ERROR instead of 0 |
| 205 |
dbi_result_field_is_null(), dbi_result_field_is_null_idx(): |
| 206 |
DBI_FIELD_FLAG_ERROR instead of 0 |
| 207 |
dbi_result_bind_fields(): DBI_FIELD_ERROR instead of -1 |
| 208 |
dbi_result_bind_*(): DBI_BIND_ERROR instead of -1 (same numerical |
| 209 |
value!) |
| 210 |
|
| 211 |
|
| 212 |
- New functions were added to improve the support for character |
| 213 |
encodings: |
| 214 |
|
| 215 |
dbi_conn_quote_string() |
| 216 |
dbi_conn_quote_string_copy() |
| 217 |
dbi_driver_encoding_to_iana() |
| 218 |
dbi_driver_encoding_from_iana() |
| 219 |
|
| 220 |
|
| 221 |
- A new function was added to improve support for binary strings: |
| 222 |
|
| 223 |
dbi_conn_quote_binary_copy() |
| 224 |
|
| 225 |
- Two functions were added to retrieve the version number of the |
| 226 |
database engine: |
| 227 |
dbi_conn_get_engine_version() |
| 228 |
dbi_conn_get_engine_version_string() |
| 229 |
|
| 230 |
- The following functions were labelled "deprecated". They are still |
| 231 |
implemented in the current version, but you should use their |
| 232 |
replacements as these functions are likely to be dropped in a future |
| 233 |
release: |
| 234 |
|
| 235 |
dbi_result_get_field_size() -> dbi_result_get_field_length() |
| 236 |
dbi_result_get_field_size_idx() -> dbi_result_get_field_length_idx() |
| 237 |
dbi_result_get_long() -> dbi_result_get_int() |
| 238 |
dbi_result_get_ulong() -> dbi_result_get_uint() |
| 239 |
dbi_result_get_long_idx() -> dbi_result_get_int_idx() |
| 240 |
dbi_result_get_ulong_idx() -> dbi_result_get_uint_idx() |
| 241 |
dbi_result_bind_long() -> dbi_result_bind_int() |
| 242 |
dbi_result_bind_ulong() -> dbi_result_bind_uint() |
| 243 |
|