What is PostgREST
PostgREST is a powerful backend server that transforms your PostgreSQL database into a fully functional RESTful API, providing a faster, cleaner, and more standards-compliant solution than building one from scratch.
By using PostgREST, you can create a RESTful API for your existing PostgreSQL database in no time, without the need for complex coding or configuration. Additionally, PostgREST utilizes the OpenAPI standard to generate comprehensive and up-to-date API documentation, making it easier to maintain and scale your API.
To take things to the next level, you can use a tool like Swagger-UI to render interactive documentation for demo requests against the live API server, improving the user experience and making it easier to onboard new developers. In short, PostgREST is an excellent choice for anyone looking to build a fast, reliable, and scalable RESTful API from their PostgreSQL database. Try it today and see the benefits for yourself!
What does PostgREST stack include
- PostgreSQL server
- Preconfigured JWT token authentication
Who is using PostgREST
- Frontend Web Developers
- REST API developers who know Haskel
What are the benefits of using PostgREST
- Open-source
- Painless updates and easy rollbacks
Why using PostgREST
PostgREST provides a compelling alternative to manual CRUD programming. Custom API servers can encounter various issues, such as duplicating, ignoring, or compromising the database structure while writing business logic. Additionally, object-relational mapping can create leaky abstractions that result in slow, imperative code.
PostgREST takes a different approach by promoting a philosophy that centers around a single declarative source of truth: the data itself. This approach helps to eliminate the problems caused by custom API servers and object-relational mapping by providing a more efficient and intuitive way to create RESTful APIs.
By using PostgREST, you can bypass the need for custom coding and rely on the declarative nature of your database to generate a fully functional API. This approach saves time and effort while improving the performance and scalability of your API.
In conclusion, PostgREST offers a fresh perspective on creating APIs by focusing on the data and removing the need for custom coding. If you want to avoid the common problems associated with custom API servers and object-relational mapping, give PostgREST a try today!
Number of servers required:
Single VPS server
Companion apps
Traefik is Edge Router that makes publishing your services.
knockd is a port-knock server. It listens to all traffic on an ethernet (or PPP) interface, looking for special knock sequences of port-hits. A client makes these port-hits by sending a TCP (or UDP) packet to a port on the server. This port need not be open -- since knockd listens at the link-layer level, it sees all traffic even if it's destined for a closed port. When the server detects a specific sequence of port-hits, it runs a command defined in its configuration file. This can be used to open up holes in a firewall for quick access.
Fail2ban scans log files and bans IPs that show the malicious signs. Highly recommended for simple VPS server setup
Minimal docker container management panel. Allows you to check the status and logs of all services of this stack. It also simplifies SSL setup and configuration.
Portainer is a lightweight management UI which allows you to easily manage your different Docker environments (Docker hosts or Swarm clusters)