0 purchases
Description:
postgres fork
postgres #
postgres fork from https://github.com/isoos/postgresql-dart
Support has been implemented to change the character encoding for the connection, this makes it possible to change the default encoding from utf8 to win1252, iso8859, among others.
implemented executing a prepared statement with question mark placeholder style similar to PHP PDO
final results = await connection.query(
' SELECT * FROM public.table_example LIMIT ?',
substitutionValues: [2000], placeholderIdentifier:
PlaceholderIdentifier.onlyQuestionMark);
copied to clipboard
A library for connecting to and querying PostgreSQL databases (see Postgres Protocol).
This driver uses the more efficient and secure extended query format of the PostgreSQL protocol.
Usage #
Create PostgreSQLConnections and open them:
var connection = PostgreSQLConnection("localhost", 5432, "dart_test", username: "dart", password: "dart");
await connection.open();
copied to clipboard
Execute queries with query:
List<List<dynamic>> results = await connection.query("SELECT a, b FROM table WHERE a = @aValue", substitutionValues: {
"aValue" : 3
});
for (final row in results) {
var a = row[0];
var b = row[1];
}
copied to clipboard
Return rows as maps containing table and column names:
List<Map<String, Map<String, dynamic>>> results = await connection.mappedResultsQuery(
"SELECT t.id, t.name, u.name FROM t LEFT OUTER JOIN u ON t.id=u.t_id");
for (final row in results) {
var tID = row["t"]["id"];
var tName = row["t"]["name"];
var uName = row["u"]["name"];
}
copied to clipboard
Execute queries in a transaction:
await connection.transaction((ctx) async {
var result = await ctx.query("SELECT id FROM table");
await ctx.query("INSERT INTO table (id) VALUES (@a:int4)", substitutionValues: {
"a" : result.last[0] + 1
});
});
copied to clipboard
See the API documentation: https://pub.dev/documentation/postgres/latest/
Additional Capabilities #
The library supports connecting to PostgreSQL using the Streaming Replication Protocol.
See PostgreSQLConnection documentation for more info.
An example can also be found at the following repository: postgresql-dart-replication-example
Features and bugs #
This library is a fork of StableKernel's postgres library.
Please file feature requests and bugs at the issue tracker.
License
For personal and professional use. You cannot resell or redistribute these repositories in their original state.
Files In This Product:
Customer Reviews
There are no reviews.
