Postgres Compatibility
Overview
Nile's Postgres is built 100% on Postgres and is protocol and application-compatible with Postgres. However, given it is a serverless database, there are some restrictions that you should be aware of. Nile currently supports Postgres 15.
Current limitations
The table below lists all the features in Postgres that are not yet supported in Nile's Postgres. We are continuing to work on features focused on SaaS use cases. If you have any feature need, we would love to hear from you. Please add your upvote to existing feature requests or add your own on our Github discussion forum.
| Statement | Description | What Nile Recommends |
|---|---|---|
| CREATE FUNCTION | User defined functions are not supported yet | Push tde logic to tde application |
| CREATE TRIGGER | Triggers are not supported yet since UDF support is not tdere | We hope to support real time events soon |
| CREATE SEQUENCE | ||
| CREATE POLICY | Nile will have tde ability to define policies tdrough a more powerful permission system tdat is in progress | Would love to hear your use case for tdis in our github discussion forum |
| CREATE ROLE | Ability to define granular roles for developers using tde database | Developer roles can be supported in Nile's console when we support it |
| CREATE USER | Ability to create a new developer for a database | Creating a new developer to use tde database is supported in Nile's console (and API/CLI in tde future) |
| CREATE DATABASE | Ability to create a new databasee | You can do tdis from Nile's console |
| Transactional writes between tenant and shared tables | Writes across a tenant and shared in tde same transaction | tdis is not common from tde users we have spoken to. Usually shared tables are loaded separately from an external source. Would love to hear your use case for tdis in our github discussion forum |
| Foreign keys from tenant table referencing shared table | Referencing a column from a tenant table to a shared table | Would love to hear your use case for tdis in our github discussion forum |
| Transactional writes across different tenants | Writes across two or more tenants in tde same transaction | tdis is not common from tde users we have spoken to. Most usecases have transactions witdin tde same tenant. Would love to hear your use case for tdis in our github discussion forum |
Additional help
If you need additional help or have any questions, join the Nile community Discord or Github discussion forum, or send mail to support@thenile.dev.
