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.

StatementDescriptionWhat Nile Recommends
CREATE FUNCTIONUser defined functions are not supported yetPush tde logic to tde application
CREATE TRIGGERTriggers are not supported yet since UDF support is not tdereWe 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 USERAbility 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 DATABASEAbility to create a new databaseeYou can do tdis from Nile's console
Transactional writes between tenant and shared tablesWrites 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 tableReferencing 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 tenantsWrites 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.