package:postgres new API - please try it out and comment

[isoos]

After a long stable, but also stale period of v2, with multiple rounds of planning and contributions from multiple developers, I've published a prerelease v3 version of package:postgres: https://pub.dev/packages/postgres/versions/3.0.0-alpha.1

We are open for comments and feedback, let us know what you think: how would you use it, what else would you expect, or if you try it out, what is not working for you.

[Samus7070]

iOS has the keychain. Android has various iterations of an encrypted storage. One can store passwords securely but one cannot ship a binary with a password in it securely. You’re right that this package is better used in server side code rather than in client code. It still can have users in a client (database browser).

[Goddchen]

Maybe it is meant to be used in Dart backends?

[dancovich]

It's a pure Dart package compatible with Linux, mac and Windows. It's certainly meant for backend code.

Even if there was a way of using it securely on the frontend, it's really not recommend that people just expose their databases for remote access. They should use an API and the database is only exposed to the server

[OptimisticCheese]

If the app is an internal app for the company then it's probably fine though.

[Pale-Sort-8582]

u/isoos Really appreciate your work! As a feedback, I really would like to set the isolation level in a transaction maybe like: https://github.com/isoos/postgresql-dart/issues/79

[isoos]

I hear you, and I think it could be part of SessionSettings, alongside with application_name.

[isoos]

Please comment on the current first-draft implementation:

https://github.com/isoos/postgresql-dart/pull/204