- fix bug on insert with prepared statement and implement queryUnnamed method for execute a prepared unnamed statement
- placeholder identifier option implemented in queryUnnamed and prepareStatement methods,
this makes it possible to use the style similar to PHP PDO in prepared
queries Example:
queryUnnamed('SELECT * FROM book WHERE title = ? AND code = ?',['title',10],placeholderIdentifier: PlaceholderIdentifier.onlyQuestionMark)
- implemented ResultStream and Results class for return data from queryUnnamed and querySimple
- fix bugs on queryUnnamed and prepareStatement
- fix bugs on query error and database restart error
- Serious bug fix that caused intermittent error when executing prepared statement with selects that return too much data
- add 'win1252' Windows CP1250 support to CoreConnection
- Example: var con = CoreConnection('user', database: 'db', host: 'localhost', port: 5432, password: 'pass', textCharset: 'win1252');
- implemented Connection pool (PostgreSqlPool) with option to automatically reconnect in case of connection drop
final settings = ConnectionSettings(
user: 'user',
database: 'database',
host: 'localhost',
port: 5433,
password: 'password',
textCharset: 'latin1',
applicationName: 'dargres',
);
final conn = PostgreSqlPool(2, settings, allowAttemptToReconnect: true);
- fixes critical bug in version 3.0.0 that caused stack overflow, timeout parameters were removed from query execution methods such as queryNamed, queryUnnamed, querySimple, execute, prepareStatement, executeStatement
- fix bug on set application_name to postgresql < 8.2
- Breaking change: decode timestamp without timezone as local DateTime and decode timestamp with timezone respecting the timezone defined in the connection
- add more flexibility on how date, timestamp and timestaptz types are decoded by adding flags to the TimeZoneSettings
- fix init Location By default with UTC