Psycopg 2

[gitmatsika]

Add Psycopg 2 to flet
https://pypi.org/project/psycopg2/

[FeodorFitsner]

So, how (why?) are we supposed to access PostgreSQL on/from a mobile device? What's the use case here?

[baseplate-admin]

Design something like pgAdmin for android?

[baseplate-admin]

This is generally not a good idea to access a database from clients device.

Databases cant handle concurrent connections like a web server can.

So i am -1 on this

[FeodorFitsner]

That's my concern as well.

I would imaging the usage of firebase/supabase lib to access hosted/cloud instance of PGSQL as a service, but talking to SQL Server directly... 🤷‍♂️ The same could be said about SQL Server via ODBC - would be nearly impossible to make it work on a mobile.

[DavMelchi]

Even if it's not the most suitable way, it's still simple to use in some use cases than going through an API. A personal hosted database without an API. I've already done it for a personal mobile app, just to save information in a my own hosted MySQL database and write some simple sql query. With Flutter, it's possible.
https://pub.dev/packages/postgres

[FeodorFitsner]

Do you use that flutter package to access MySQL as well?

[DavMelchi]

Nope.
https://pub.dev/packages/mysql1 for Mysql DB

[gitmatsika]

For interacting with postgres off a mobile phone

…

On Sat, May 4, 2024 at 10:41 PM Feodor Fitsner ***@***.***> wrote: So, how (why?) are we supposed to access PostgreSQL on/from a mobile device? What's the use case here? — Reply to this email directly, view it on GitHub <#3204 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AXYIYQEMZN4KGRBMHVPYEUTZAVBXDAVCNFSM6AAAAABHG7HONSVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TGMJWGE2TG> . You are receiving this because you authored the thread.Message ID: ***@***.***>