Can Supabase be used for the Pyramid repository?
Hello,
Is it possible to use Supabase (https://supabase.com/), which is a Postgres based database as a service, as the repository database for Pyramid Analytics? When I try to connect to Supabase as a data source in Pyramid it does not work, even though the connection is a Postgres connection.
Thanks,
Rob Clark
2 replies
-
Hi
No. We only support vanilla PostgreSQL, Oracle and SQLServer as database servers for the Pyramid repository.
Supabase may well claim that they are simply PostgreSQL as a service, but already, the standard Pyramid PostgreSQL connector (the standard PostgreSQL JDBC driver) doesn't work with it, so there is immediately something different.
See Help for more details on the Pyramid respository.
Hope that helps.
Ian
-
BTW, If you want to use Supabase as a data source, use the PostgreSQL connector but use the connection details for transaction or session pooler. It works fine:
Hope that helps.
Ian