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 the logic to the 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 the ability to define policies through a more powerful permission system that is in progress	Would love to hear your use case for this in our github discussion forum
CREATE ROLE	Ability to define granular roles for developers using the 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 the database is supported in Nile's console (and API/CLI in the future)
CREATE DATABASE	Ability to create a new databasee	You can do this from Nile's console
Transactional writes between tenant and shared tables	Writes across a tenant and shared in the same transaction	this is not common from the users we have spoken to. Usually shared tables are loaded separately from an external source. Would love to hear your use case for this 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 this in our github discussion forum
Transactional writes across different tenants	Writes across two or more tenants in the same transaction	this is not common from the users we have spoken to. Most usecases have transactions with the same tenant. Would love to hear your use case for this 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.