stablekernel / Postgresql Dart
Licence: bsd-3-clause
Dart PostgreSQL driver: supports extended query format, binary protocol and statement reuse.
Stars: ✭ 105
Programming Languages
dart
5743 projects
Labels
Projects that are alternatives of or similar to Postgresql Dart
Psycopg2
PostgreSQL database adapter for the Python programming language
Stars: ✭ 2,425 (+2209.52%)
Mutual labels: postgresql, driver
Psycopg3
New generation PostgreSQL database adapter for the Python programming language
Stars: ✭ 278 (+164.76%)
Mutual labels: postgresql, driver
Postgres
Postgres.js - The Fastest full featured PostgreSQL client for Node.js
Stars: ✭ 2,193 (+1988.57%)
Mutual labels: postgresql, driver
Hasql
Performant PostgreSQL driver with a flexible mapping API
Stars: ✭ 415 (+295.24%)
Mutual labels: postgresql, driver
Neo4j Core
A simple unified API that can access both the server and embedded Neo4j database. Used by the neo4j gem
Stars: ✭ 99 (-5.71%)
Mutual labels: driver
Activerecord Clean Db Structure
Automatic cleanup for the Rails db/structure.sql file (ActiveRecord/PostgreSQL)
Stars: ✭ 101 (-3.81%)
Mutual labels: postgresql
Splits Io
a speedrunning data store, analysis engine, and racing platform
Stars: ✭ 99 (-5.71%)
Mutual labels: postgresql
Postguard
🐛 Statically validate Postgres SQL queries in JS / TS code and derive schemas.
Stars: ✭ 104 (-0.95%)
Mutual labels: postgresql
Pg flame
A flamegraph generator for Postgres EXPLAIN ANALYZE output.
Stars: ✭ 1,391 (+1224.76%)
Mutual labels: postgresql
Maha
A framework for rapid reporting API development; with out of the box support for high cardinality dimension lookups with druid.
Stars: ✭ 101 (-3.81%)
Mutual labels: postgresql
Openseedbox
OpenSeedbox - Open Source Multi-User Bittorrent Web UI
Stars: ✭ 101 (-3.81%)
Mutual labels: postgresql
Adminer Custom
Customizations for Adminer, the best database management tool written in PHP.
Stars: ✭ 99 (-5.71%)
Mutual labels: postgresql
Spring Boot 2.x Examples
Spring Boot 2.x code examples
Stars: ✭ 104 (-0.95%)
Mutual labels: postgresql
Pgcli
Postgres CLI with autocompletion and syntax highlighting
Stars: ✭ 9,985 (+9409.52%)
Mutual labels: postgresql
Docker Laravel
🐳 Docker Images for Laravel development
Stars: ✭ 101 (-3.81%)
Mutual labels: postgresql
Active record Mti
ActiveRecord support for PostgreSQL's native inherited tables (multi-table inheritance)
Stars: ✭ 100 (-4.76%)
Mutual labels: postgresql
postgres
A library for connecting to and querying PostgreSQL databases.
This driver uses the more efficient and secure extended query format of the PostgreSQL protocol.
Usage
Create PostgreSQLConnection
s and open
them:
var connection = PostgreSQLConnection("localhost", 5432, "dart_test", username: "dart", password: "dart");
await connection.open();
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];
}
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"];
}
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
});
});
See the API documentation: https://pub.dev/documentation/postgres/latest/
Features and bugs
Please file feature requests and bugs at the issue tracker.
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].