5 Npgsql 0.7beta3 development release
8 Large Object support: Npgsql now supports large object operations. Thanks Emiliano Necciari (e dot necciari at blogic dot it) for the patch!
12 Added workaround when using extended query mode to add parameter types explicitly when sending Parse messages. Backend was sending errors for some queries like (select * from t where $1 in (...) ). Backend was saying it could not recognize parameter type of $1. Thanks Martin ( martijn at boland dot org) for heads up.
14 Fixed parameter replace when next byte after parameter name is '\\r'. Thanks Ivan Radovanovic (rivan at sezampro dot yu) for the fix.
16 Fixed NpgsqlDataReader.GetBytes: Added a little fix for proper handling of getbytes with current Npgsql semantics in mind. For while, we just support offset value of 0 as we read all the bytes field value at a time. So there is no copy when offset is not 0.
18 Fixed IDisposable pattern implementation of NpgsqlTransaction. Now it doesn't incorrectly raise InvalidOperation exceptions. Thanks Ivan Radovanovic ( rivan at sezampro dot yu ) for heads up.
20 Fixed NpgsqlCommand.Connection set property. Now connection values can be set when a connection is in place, but just if the connection being set is the same as the connection which the transaction is running on. Thanks Ivan Radovanovic ( rivan at sezampro dot yu ) for heads up.
22 gborg 1000: Fixed NullReferenceException when setting parameter value to DBNull after creating parameter without specifying its NpgsqlDbType.
24 Fixed NpgsqlDataReader.GetBytes for .Net 1.0 compliance. CopyTo() doesn't have an overload which takes an Int64. Thanks Brar Piening (brar at piening dot info) for heads up
26 Fixed assembly info version to 0.7.
28 Fixed handling of invalid authentication methods. Thanks Magnus Hagander (mha at sollentuna dot net) for the heads up.
34 Npgsql 0.7beta2 development release
38 Added support for DbType.Byte type. Thanks Martijn Boland (martijn at boland dot org)
44 gborg 952: Added missing handling of NoData message.
46 Fixed a NullReferenceException when passing a null connnection string to NpgsqlConnection.
48 gborg 941, 955: Fixed null values handling when using NpgsqlCommand.Prepare(). Thanks Martijn Boland (martijn at boland dot org) for helping with test case.
50 Fixed an infinite loop when trying to use a parameter whose name is equals to same type name. i.e.: parameter name :text which would conflict with :text
51 parameter name which was being added in the replacement string.
53 Fixed handling of strings with backslashes. Now they are properly escaped.
55 Improved portal and plan name creation to use an unique number from NpgsqlConnector instead of using an static field in NpgsqlCommand. Thanks Martin ( martijn at boland dot org) for the heads up.
57 Improved implementation of NpgsqlConnection.Dispose. Also added warning logging for NpgsqlConnection leakings.
59 Fixed code to allow calling NpgsqlConnection.Close() many times even when being disposed.
61 Added support for case insensitive fields index lookup in NpgsqlDataReader. Thanks Martin ( martijn at boland dot org)
64 Note: Still missing generated html api docs.
68 Npgsql 0.7beta1 development release
73 Added support for point, box, lseg, path, polygon and circle datatypes. They are mapped to NpgsqlPoint, NpgsqlBox, NpgsqlLSeg,
74 NpgsqlPolygon and NpgsqlCircle respectively. Thanks Glen Parker for help.
76 Added NpgsqlDbType enumeration with all supported types.
81 Added api documentation in code. Thanks Glen Parker. (No html generation yet. This will be fixed in next release)
82 Fixed deserialization of NpgsqlException. There are some issues yet, just the base message is being deserialized. Errors collection are null. Thanks David Palmer (David dot Palmer at SensusTech dot com) for the heads up and fix.
83 Improved Unicode encoding support. It was possible to characters in unicode cross the stream buffer and be discarded. Now we use Decoders which handle that situation. Thanks Oskars Ozols (oskars dot ozols at di dot lv)
84 Improved connection startup code. Now new connections in ms.net goes a lot faster. Thanks Mikko Korkalo (mikko.korkalo at f-solutions dot net) for the patch.
85 Fixed a problem with plan execution in 7.3 backend versions. The text parameters weren't being quoted and backend complained about that.
87 - gborg 898: Added HasRows method to NpgsqlDataReader. Thanks keitsi at minttupuffet dot net for feature request.
88 - gborg 899: Fixed return of IsClosed after closing NpgsqlDataReader. Thanks Mikko Korkalo (mikko.korkalo at f-solutions dot net) for the patch.
91 There are some reports about initial connection delay when using Npgsql in windows with ms .net implementation. We are still investigating what is causing that. Please, report us if you also have this problem.
96 Npgsql 0.6 development release.
98 After so much time without a release, we finally got this out! Sorry
99 for all this time without releases. We will try to get more often releases
101 I'd like to specially thank Glen Parker (glenebob at nwlink dot com) for all the help given in this release. Thank you very much Glen!
103 What's new in this version:
105 - Connection Pooling support. Glen Parker worked very much in the
106 redesign of connection pooling. You can use the connection pooling
107 by specifying the following key-value pairs in the connection string:
109 MaxPoolSize: specifies the max number of connections Npgsql will use
111 Pooling: True or False. Controls whether connection pooling is used. Default = True;
112 Timeout: Time to wait for connection open in seconds.
114 - SSL Connection support. You now can connect to postgresql using ssl connections. To
115 do so, you must add the pair ssl=yes in connection string. Thanks Carlos Guzman (carlosga at telefonica dot net)
117 - More connection string options:
118 Protocol: Protocol version to use, instead of automatic; Integer 2 or 3;
119 Encoding: Encoding to use when connected to backend. Currently can only be SQL_ASCII or Unicode. Default: SQL_ASCII.
122 NpgsqlException is now used exclusively for errors reported by the backend.
123 NpgsqlException now provides access to all information returned by the backend with an error. (More specific informations as error number only available on 7.4+ server versions)
126 Protocol version 3 handling is much closer to completion.
127 Lots of API documentation added.
132 Added support for Unicode encoding. Fixes feature request 534 on gborg. Thanks Ivar
133 <ivar at lumisoft dot ee> for pointing it out.
135 Added code to set datestyle to iso when connecting using protocol 3.0 version. Thanks Sami Kuhmonen <feenix at iqs dot fi> for pointing it out.
137 Faster support of bytea binary data. Thanks Jackson Harper (jackson at ximian dot com)
138 and Jonathan Gilbert (2a5gjx302 at sneakemail dot com). The performance for adding binary data is
139 10x faster than original code :)
141 CommandBuilder and better Dataset support. Thanks Pedro Yoros (yoros at wanadoo dot es).
143 Fixed problem when getting empty resultsets. Thanks lynnroth for pointing it out.
145 Connection.Close couldn't be called twice. gborg 828. Thanks Glen Parker (glenebob at nwlink dot com)
147 Wrong date format sent to DB. Thanks Glen Parker (glenebob at nwlink dot com)
149 RedHat Postgresql messes version string. Thanks Glen Parker (glenebob at nwlink dot com)
151 NpgsqlMessageTypes.EmptyQueryResponse doesn't read enough from response string. Thanks Glen Parker (glenebob at nwlink dot com)
153 Problem with czech diacritics. Thanks stehule at kix dot fsv dot cvut dot cz for the patch.
155 fill method updates db without specifying insert command and creates wrong commandtext.
164 Npgsql 0.5 development release.
166 What's new in this version:
168 - New datatypes supported: bool, int2, int4, int8, numeric, timestamp, date, time and text data types.
169 These types are mapped to DbTtype enum: Boolean, Int16, Int32, Int64, Decimal,
170 DateTime, Date, Time and String.
172 - NpgsqlParameter now supports those types through the DbType enumeration and not just Int32, Int64
174 - NpgsqlDataAdapter now has more helper contructors. Thanks stevenao for reporting this (Bug 455)
176 - MD5 Authentication is now supported. Thanks Brar Piening.
177 Mono MD5 implementation is being used. Thanks Sebastien Pouliot.
179 - NpgsqlDataAdapter can be used to select, insert, update and delete data with DataSets.
181 - StrongType datasets generated with xsd can be used.
183 - Support for Listen/Notify events through the NotificationEventHandler delegate and
184 NpgsqlConnection.OnNotification event. Thanks Wojtek Wierzbicki. Now applications can
185 hook on it to receive notification messages from server. This notification is asynchronous which means they will
186 be delivered to client apps in the next interaction of Npgsql with backend.
188 - NUnit20 tests were added. There are 48 tests which can also be used as a source of references of new Npgsql functionality.
189 Of course, new tests are very welcome :)
194 - Large resultsets are now correctly handled(Bug id 467). Thanks Chris Wenneman.
195 - Null values handling are now fixed. Thanks Stuart Ballard for showing this problem.
196 - Quotes in strings are now *actually* working.
199 This release is very stable and have a lot of immediate functionality is now working.
200 It can be used in production environments. Please, get the non-debug releases to production use.
201 Thanks all for help debugging and sending your bug reports and patches! :)
210 Npgsql 0.2 development release.
212 In this version we got many things working...
214 - You can send insert, update, delete queries through NpgsqlCommand.ExecuteNonQuery() method.
215 - You can send queries like, select count(*) from table, select version() with
216 NpgsqlCommand.ExecuteScalar() method.
217 - There is logging support. (Thanks Dave Page)
218 To use it, place code like that in your program:
221 NpgsqlEventLog.Level = LogLevel.Debug; // LogLevel.
222 NpgsqlEventLog.LogName = "NpgsqlTests.LogFile"; // LogFile.
224 - You can use Npgsql with Mono (Thanks Kristis Makris). It is not working perfectly. :(
225 - There is a winforms test suite (Thanks Dave Page).
226 - Clearer code in NpgsqlConnection removing *magic* numbers and constants. (Thanks Kristis Makris)
227 - Better support of ODBC-like ConnectionString in NpgsqlConnection (Thanks Dave Page)
228 - Thanks Ulrich Sprick for all discussion and ideas.
230 And much more to come!
235 First Npgsql beta release.
236 In this version there is a limited functionality. It is only possible to
237 connect and disconnect from server.
238 Only clear text authentication is supported right now.
239 To compile you can use the SharpDevelop to open the Combine file (Npgsql.cmbx) or
240 type at command console: csc /t:library /out:Npgsql.dll NpgsqlConnection.cs AssemblyInfo.cs NpgsqlException.cs
241 This will create the file Npgsql.dll that can be copied to the application directory.
243 I will be working in the Command functionality now.
246 Play with it and send your bugs and comments :)