Vonng

6 ms·

1.
Show HN: Silo – S3-compatible object storage, a maintained fork of MinIO(silo.pgsty.com)
22 points by Vonng 1mo ago|2 comments
2.
by Vonng 7mo ago
you're right, OpenTofu forked from the last MPL version of Terraform, not BSL. My mistake — I'll correct the post.
3.
by Vonng 7mo ago
Author here. • This is translated from my original Chinese post. I used Claude to polish the English — not a native speaker. Fair criticism on the LLM-ese; I'll tighten it. • This fork exists because MinIO is a production dep in my PG
4.
MinIO Is Dead, Long Live MinIO(vonng.com)
2 points by Vonng 7mo ago|1 comments
5.
by Vonng 7mo ago
A minio community fork with admin console back, CI/CD pipeline for Docker/RPM/DEB packages.
6.
Show HN: PostgreSQL Extension Cloud(pgext.cloud)
2 points by Vonng 10mo ago|0 comments
7.
by Vonng 1y ago
Author here. The post here is a 3rd-party translation and may drifts from original wording in a few spots. Azure and OpenAI sent me some corrections today, so I published an updated English version myself here: https://pigsty.io&
8.
When Postgres Falls for DuckDB(pigsty.io)
3 points by Vonng 1y ago|0 comments
9.
by Vonng 1y ago
BTW for anyone who interested, I've packed pg_search and vchord_bm25 extension RPM/DEBs https://pigsty.io/ext/fts/vchord_bm25 https://pigsty.io/ext/fts/pg_search In case anyo
10.
by Vonng 2y ago
There are 351 available rpm/deb postgres extensions which can do really a lot of things: https://ext.pigsty.io/#/
11.
Show HN: Pig – PostgreSQL Extension Manager on Linux, 340 ext on 10 distro(github.com)
2 points by Vonng 2y ago|0 comments
12.
The idea way to install PostgreSQL extensions?(medium.com)
1 points by Vonng 2y ago|0 comments
13.
Show HN: Self-Hosting Supabase on Your Own Postgres RDS(pigsty.io)
5 points by Vonng 2y ago|0 comments
14.
PostgreSQL Extension Pedia, with 345 out-of-box RPM/DEB packages available(ext.pigsty.io)
2 points by Vonng 2y ago|0 comments
15.
by Vonng 2y ago
I fully support ParadeDB's decision. For an open-source software company, AGPLv3 + Dual License is the most sensible choice. If you go with Apache 2.0, you're literally doing free work for cloud vendors.
16.
The 333 PostgreSQL Extensions available as out-of-box RPM/DEB packages(pigsty.io)
9 points by Vonng 2y ago|2 comments
17.
by Vonng 2y ago
I've set up a supplementary APT/YUM repository, which builds on the official PGDG offerings. This includes 326 extensions for EL distros and 312 for Deb distros, encompassing 121 RPM packages and 133 DEB packages. These packages s
18.
Database in Kubernetes: Is that a good idea?(pigsty.io)
2 points by Vonng 2y ago|0 comments
19.
by Vonng 2y ago
Why not continue to use rpm/apt for building and packaging? You can reuse these packages in the Dockerfile and the image, but not the other way around.
20.
by Vonng 2y ago
RDS is like 4~13x than EC2 on AWS, 2.3x than EC2 on aliyun. https://pigsty.io/blog/cloud/rds/ But The real cost lies on EBS, which is around 60x ~ 200x than local NVMe SSD. https://pigsty.io/b
21.
by Vonng 3y ago
How about: PostgreSQL tuned (x47). PostgreSQL + Hydra Extension (x42) PostgreSQL + ParadeDB Extension (x10.7)
22.
by Vonng 3y ago
That's true for the kernel, How about extensions such as ParadeDB BM25 https://www.paradedb.com/ + PGroonga https://pgroonga.github.io/ + PG Bigm https://github.com/pgbigm/pg_bigm
23.
by Vonng 3y ago
Patroni has native HA support for citus horizontal cluster since v3. Which means your can create a HA citus cluster as simple as: https://pigsty.io/docs/pgsql/config/#citus-cluster
24.
by Vonng 3y ago
pg_hint_plan —— Give PostgreSQL ability to manually force some decisions in execution plans. https://github.com/ossc-db/pg_hint_plan
25.
Postgres is eating the database world(medium.com)
281 points by Vonng 3y ago|142 comments
26.
by Vonng 3y ago
The scale of operation is the crux here. For a modest number of cores, RDS is a congenial choice. However, when you're going to hundreds or, as in our scenario, tens of thousands of cores with PostgreSQL, clinging to RDS is sheer lunac
27.
by Vonng 3y ago
It might require a bit of elbow grease to grasp every component. I'm trying my best to smooth out that learning curve: https://doc.pigsty.cc/#/PGSQL-ARCH?id=component-overview https://doc.pigsty.cc&#x2F
28.
by Vonng 3y ago
Redis is more like a cherry on top. Many applications utilizing PostgreSQL also employ Redis, Gitlab being a notable example, and that includes us as well. Supporting Redis merely involves adding a couple of RPMs and Playbooks, so why not g
29.
by Vonng 3y ago
You don't need to rebuild the docker image and restart the container to get the extension installed & created. And, I haven't found any Postgres docker image with all the extensions I need: you can reuse the RPM in dockerfile
30.
by Vonng 3y ago
The title was auto-updated without the crucial "RDS/Distribution" part before "alternative"...

More ›