How to connect to Postgres db with Unity/C#? How to execute queries? I have Postgres db on Heroku server (not localhost) and was able to work with it via python and psycopg2 but now i use Unity. I have all db credentials. Just do not know which library to use and how to install it. I use Ubuntu and VS Code. I installed Nuget and Npgsql via Nuget but its classes are not visible in VS Code for some reason
6
-
It depends. Do you want to use hand made queries, micro ORM, ORM, ...?Klamsi– Klamsi2021-05-25 08:58:17 +00:00Commented May 25, 2021 at 8:58
-
Hand made @KlamsiBohdan Z.– Bohdan Z.2021-05-25 08:59:33 +00:00Commented May 25, 2021 at 8:59
-
Npgsql maybe?Filburt– Filburt2021-05-25 09:12:36 +00:00Commented May 25, 2021 at 9:12
-
@Fliburt thanks, i want to check it out. however, i do not know yet how to make it work with VS Code + UbuntuBohdan Z.– Bohdan Z.2021-05-25 10:33:26 +00:00Commented May 25, 2021 at 10:33
-
Ok, i used this stackoverflow.com/questions/40675162/… to install nuget and (using nuget) npgsqlBohdan Z.– Bohdan Z.2021-05-25 10:39:31 +00:00Commented May 25, 2021 at 10:39
|
Show 1 more comment
1 Answer
I found Npgsql.dll on dllme.com. I put it to Plugins folder that I created in Assets in Unity. That gave me some errors: Npgsql needed some dlls. I followed them and found those dlls on dllme.com and put them to Plugins also. And continued until there will be no errors. And it works now on my Ubuntu with local PostgreSQL DB. I have 5 dlls in Plugins: Npgsql, System.Buffers, System.Memory, System.Runtime.CompilerServices.Unsafe, System.Threading.Tasks.Extensions