postgres-websockets
Directus
postgres-websockets | Directus | |
---|---|---|
1 | 208 | |
338 | 25,417 | |
- | 1.0% | |
7.2 | 9.9 | |
6 months ago | 4 days ago | |
Haskell | TypeScript | |
BSD 3-clause "New" or "Revised" License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
postgres-websockets
-
PostgREST โ Serve a RESTful API from Any Postgres Database
At work, we've finally replaced a large part of a custom (mostly-)web backend with PostgREST recently, and that's quite a relief: considerably less code to maintain in that project now, and that was a rather awkward code. Something akin to PostgREST's "Embedding with Top-level Filtering" [1] had to be provided for all the tables, with OpenAPI schema and a typed API (Haskell + Servant); I avoided manually writing it all down, but at the cost of poking framework internals, and maintainability suffered. It was particularly annoying that the code doesn't really do anything useful, except for standing between a database and an HTTP client, and simply mimics the database anyway. Whenever a change had to be introduced, it was introduced into the database, the backend, and the frontend simultaneously, so it wasn't even useful for some kind of compatibility.
Now PostgREST handles all that, and only a few less trivial endpoints are handled by a custom backend (including streaming, which I'm considering replacing with postgrest-websocket [2] at some point).
During the switch to PostgREST, the encountered minor issues were those with inherited tables (had to set a bunch of computed/virtual columns [3] in order to "embed" those), and with a bug on filtering using such relations (turned out it was an already-fixed regression [4], so an update helped). Also a couple of helper stored procedures (to use via /rpc/) for updates in multiple tables at once (many-to-many relationships, to edit entities along with their relationships, using fewer requests) were added (though the old custom backend didn't have that), the security policies were set from the beginning, the frontend was rewritten (which allowed to finally switch without adding more work), so it was only left to cleanup the backend.
Not using views, since as mentioned above, database changes usually correspond to frontend changes, and the API doesn't have to be that stable yet.
Happy with it so far.
[1] https://postgrest.org/en/stable/api.html#embedding-with-top-...
[2] https://github.com/diogob/postgres-websockets
[3] https://postgrest.org/en/stable/api.html#computed-virtual-co...
[4] https://github.com/PostgREST/postgrest/issues/2530
Directus
-
How to Deploy Directus as a Backend-as-a-Service (BaaS) on Koyeb
Directus is an open data platform built to serve as a headless CMS, API, or Backend-as-a-Service (BaaS) for other applications. It is designed to make data accessible to people of all technical levels and to make it easy to build data-centric applications. Directus is extensible and can be integrated with many different frontend technologies to create stable, well-structured development and user experiences.
-
Headless CMS: Directus vs Payload vs Strapi in 2024
As of April 2024, Directus' GitHub repository has accumulated 25.2k stars and 3.5k forks, showcasing its active community. The project has secured $8+ million in funding, further fueling its growth and development.
- Our repo hit a milestone today with 25k GH stars
-
Form to DB
I don't know, it's something I've wanted many times.
Recently I discovered https://directus.io/ which comes pretty close and it's open source.
-
Open-Source Headless CMS in 2024
Directus: The Shape-Shifting Maverick
-
A Year of Self-Hosting: 6 Open-Source Projects That Surprised Me in 2023
The Backend to Build Anything or Everything | Directus
-
Best "Excel-as-a-database" alternative?
today I discovered https://directus.io/
-
Ikr
You could try https://www.airtable.com/ (check the prices) or https://directus.io/ (check the prices) or hire someone :)
-
Prismic.io is increasing our price by *1900%* over Christmas
I using Directus CMS on several projects with pretty complicated flows, api extensions etc. probably there will be some work if you move. I liked Directus is because it's standard SQL I can always move my DB and documents to another solution. I don't use their hosted solution but they have an unlimited offering for $100 / month.
-
Looking for a (primarily) WYSIWYG platform to build a MySQL interface.
Have you looked at Directus? Iโm not sure exactly what your needs are (sorry if Iโve misunderstood). I used it for my most recent project as the backend for data entry/queries/administration. It supports MySQL, but admins donโt need to know anything about SQL to do complex queries/filters/CSV exports from the Directus UI.
What are some alternatives?
postgrest - REST API for any Postgres database
supabase - The open source Firebase alternative.
graphql-api - Write type-safe GraphQL services in Haskell
Strapi - ๐ Strapi is the leading open-source headless CMS. Itโs 100% JavaScript/TypeScript, fully customizable and developer-first.
graphql - Haskell GraphQL implementation
Appwrite - Your backend, minus the hassle.
gc-monitoring-wai - a wai application to show `GHC.Stats.GCStats`
budibase - Budibase is an open-source low code platform that helps you build internal tools in minutes ๐
raml - RESTful API Modeling Language (RAML) library for Haskell
KeystoneJS - The most powerful headless CMS for Node.js โ built with GraphQL and React
simpleconfig
appsmith - Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.