magic
postgrest
Our great sponsors
magic | postgrest | |
---|---|---|
141 | 98 | |
946 | 21,997 | |
- | 1.3% | |
9.9 | 9.7 | |
12 days ago | about 14 hours ago | |
TypeScript | Haskell | |
GNU General Public License v3.0 only | MIT License |
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.
magic
-
No more Mr. Open Source Guy
In addition I've got zero contributions to my primary projects. Some guy contributed to Lizzie a couple of years ago, but my primary project has zero contributions. Notice, I happen to know for a fact that there are a whole range of really, really, really rich companies using Magic for instance, some of whom are cashing in millions of dollars in profit every single year.
-
Magic is no longer Open Source
In addition Magic Cloud has now become a real business model, with a quite substantial amount of revenue, through our AI and Low-Code hosting provider. So to avoid having leeches exploiting our work for free without contributing in any ways, it's therefor with heavy heart we announce that all future releases of Magic will be in the form of closed source distributions.
Starting from today Magic's open source GitHub repository will no longer be actively maintained. Due to recent events, we've unfortunately been forced to exclusively continuing maintenance of Magic Cloud as a close source project.
-
The Mechanics of Silicon Valley Pump and Dump Schemes
I have an open source project myself, and I am building an AI and Low-Code/No-Code platform company on top of it. Contrary to SupaBase though, I have spent 4 years creating real value in my platform. The project solves a real problem, it consists of a lot of real innovations, and I’ve spent a lot of time building it.
-
How we Built a 20 Billion Dollar Company in 20 minutes
Warning - This is not going to make any sense for anyone reading this, including me, so I won't try to make any sense of it - I'll let the reader interpret it in whatever way the reader wants to interpret it. However, when you're building an open source platform, such as our Magic Clouc, the first thing investors will ask you about is how many users you have.
-
Celebrating 10 Million Downloads
We've always been an open source company. Our entire platform is open source, and it gives us great pleasure contributing to our community with free software.
When the article was published, it rapidly broke all records, and became the 5th most read article Microsoft had ever published. Today the article is a bit dated, and if you're interested in learning Hyperlambda, you're much better off reading its official documentation.
-
Hyper IDE, using No-Code and Low-Code to Generate Software
Our means to accomplish the above is Magic.
-
Create a Registration API in 15 minutes
/* * Allows the user to verify his or her email address * * Very cool app! */ .arguments token:string username:string /* * Returns the specified [key] configuration setting. * * Notice, to traverse into for instance magic.foo.bar, you'll have to colon separate * your path as follows "magic:foo:bar". */ execute:magic.workflows.actions.execute name:config filename:/misc/workflows/actions/misc/config.hl arguments key:"magic:auth:secret" /* * Joins the specified [values] into a single string. * * Notice, the [separator] is inserted between each string. If no [separator] argument is provided, * the strings will simply be concatenated instead. */ execute:magic.workflows.actions.execute name:strings-join filename:/misc/workflows/actions/strings/strings-join.hl arguments values .:x:@.arguments/*/username .:x:--/execute/=config/*/value separator:, /* * Creates a hash of the specified [input]. * * Use [algorithm] to override the default hashing algorithm used. The default hashing algorithm * is SHA 256. */ execute:magic.workflows.actions.execute name:hash filename:/misc/workflows/actions/misc/hash.hl arguments input:x:--/execute/=strings-join/*/result algorithm:sha256 /* * Executes the specified [action] if the specified [condition] is true. * * Will pass in all arguments specified to the action. The [condition] can be two different * values or expressions, and the [comparison] can be eq, neq, mt, mte, lt, lte, or some other * comparison operator. * * The action will use the [comparison] to compare the [lhs] and [rhs] values/expressions. */ execute:magic.workflows.actions.execute name:execute-action-if filename:/misc/workflows/actions/misc/execute-action-if.hl arguments lhs:x:--/execute/=hash/*/result comparison:neq rhs:x:@.arguments/*/token action:/misc/workflows/actions/misc/error.hl arguments message:Bogus token, go home!! status:400 public:true /* * Associates the specified [username] with the specified [roles] roles. * * Notice, does not remove roles from user, only adds roles. This action will also throw * if you try to associate a user with a role the user is already associated with. */ execute:magic.workflows.actions.execute name:roles-add filename:/modules/registration/workflows/actions/roles-add.hl arguments roles .:guest username:x:@.arguments/*/username // Redirects the client to the specified [url]. execute:magic.workflows.actions.execute name:http-redirect filename:/misc/workflows/actions/http/http-redirect.hl arguments url:"https://ainiro.io"
In the video below I am demonstrating how to use Magic's No-Code and Low-Code features to create it from scratch, in 15 minutes.
postgrest
- Soul: A SQLite REST and Realtime Server
-
Build a simple project management app with Neon, PostgREST, and DigitalOcean
wget 'https://github.com/PostgREST/postgrest/releases/download/v11.2.0/postgrest-v11.2.0-linux-static-x64.tar.xz'
-
Oink: An API for PHP in a single file
You don't need this PHP snippet:
To get the same functionality without the extra step, simply use PostgREST [1]
- Ask HN: Popular open source tool originally written in Haskell?
-
Use PostgREST and HTMX to Build RESTful APIs from PostgreSQL Databases
PostgREST is a standalone web server that turns your PostgreSQL database into a RESTful API using the database's structural constraints and permissions to define the API's endpoints and operations. In this tutorial, you will create a simple note-taking app by leveraging PostgREST to construct a RESTful API for the app and using htmx to deliver HTML content.
-
We built our customer data warehouse all on Postgres
You might find some info in the docs of PostgREST [1] or in the previous discussions on HN about it [2].
For the versioning, I just have a git repo where I keep every role, schema, table, view, function, trigger, etc. definitions. Every time I change something in the database I first change it in the git repo too to have an history.
-
Pandoc
Don't know if you would call this a "program" but PostgREST is written is Haskell too.
-
2024 Web Development Wish List
Despite what most people think, postgREST is incredibly powerful. I know, I am a sponsor. I specifically am trying to get nested mutation built-in. Currently, queries are probably more powerful than Hasura or Prisma, but most people don't know this.
-
DB2Rest VS postgrest - a user suggested alternative
2 projects | 8 Jan 2024
Others https://github.com/Azure/data-api-builder https://github.com/directus/directus https://github.com/dreamfactorysoftware/dreamfactory https://github.com/prest/prest
-
PostgREST: Providing HTML Content Using Htmx
[2]: Also part of the PostgREST team and major contributor https://github.com/PostgREST/postgrest/graphs/contributors
What are some alternatives?
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
supabase - The open source Firebase alternative.
postgres-websockets - PostgreSQL + Websockets
Appwrite - Build like a team of hundreds_
gotrue - An SWT based API for managing users and issuing SWT tokens.
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql
appsmith - Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
simpleconfig
json - Haskell JSON library
swagger2 - Swagger 2.0 data model.
pg-transact - Another postgresql-simple transaction monad