crunchy-proxy
pREST
Our great sponsors
| crunchy-proxy | pREST | |
|---|---|---|
| 2 | 15 | |
| 391 | 3,701 | |
| 0.3% | 2.9% | |
| 0.0 | 4.2 | |
| over 1 year ago | 1 day ago | |
| Go | Go | |
| Apache License 2.0 | 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.
crunchy-proxy
-
GCP Cloud SQL Migration without outage?
This is why I always recommend using a postgres proxy so you can point it to different database servers as you stand them up. AWS does this by default but GCP doesn’t yet, so you have to have your own Postgres proxy (e.g https://github.com/CrunchyData/crunchy-proxy) or move to an HA Postgres setup like Patroni that has streaming replication (https://github.com/zalando/patroni).
pREST
- Need help connecting VueJS 3 UI to a database
- Postgres as Rest
-
pREST on YugabyteDB
In a previous post, I published an example with PostgREST on YugabyteDB. Here is another one: pREST opens a REST API to PostgreSQL. YugabyteDB is a PostgreSQL-compatible Open-Source Distributed SQL database. It adds horizontal scalability to applications built for PostgreSQL. Let's see how it integrates with pREST.
-
PostgREST – Serve a RESTful API from Any Postgres Database
Pretty sure I started with this: https://github.com/prest/prest/blob/main/cmd/root.go
And from there you can execute your own command and add handlers or other things as you wish.
-
Accessing Postgres via REST using pRest
With pRest, it is possible to create a RESTFul API to access the contents of a Postgres database in a fast and straightforward way. The project, written in Go, can be found on its official website and Github.
-
Admin panel for Go back end?
So this is something I've been pondering about for a while and I think I've settled to using Directus: https://directus.io/ as my db admin and dbmate for migrations. Alternatively you could use react admin: https://marmelab.com/react-admin/ . The only problem with the latter is that it requires you to build your rest endpoint for CRUD but you can use postgrest: https://postgrest.org/en/stable/ (or it's go alternative prest: https://prestd.com/) for that.
-
Full Text Search in PostgreSQL
prest / prest
There is PostgREST written in Haskell, but keeping Haskell software in production is not an easy job. With this need pREST was born. Read more.
This feature was implemented in version 1.0.5 as a search filter and works like this:
What are some alternatives?
go-pg - Golang ORM with focus on PostgreSQL features and performance
go-cache - An in-memory key:value store/cache (similar to Memcached) library for Go, suitable for single-machine applications.
go-mysql - a powerful mysql toolset with Go
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
stolon - PostgreSQL cloud native High Availability and more.
tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial
dgraph - Native GraphQL Database with graph backend
diskv - A disk-backed key-value store.
patroni - A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
ozzo-dbx - A Go (golang) package that enhances the standard database/sql package by providing powerful data retrieval methods as well as DB-agnostic query building capabilities.
prometheus - The Prometheus monitoring system and time series database.
pgweb - Cross-platform client for PostgreSQL databases