sjmiller609

5 ms·

1.
The Jobs to Be Done by the Ideal Postgres Extension Ecosystem(tembo.io)
16 points by sjmiller609 3y ago|3 comments
2.
by sjmiller609 3y ago
At Tembo, we built Trunk (pgt.dev), which is a free and open source Postgres extension registry with over 200 extensions, published under the postgres license. We aim to improve the developer experience within the Postgres extensions ecosys
3.
Thoughts on PostgreSQL in 2024(jkatz05.com)
124 points by sjmiller609 3y ago|48 comments
4.
by sjmiller609 3y ago
I wish there was some way to compress JSON data across multiple rows, I often have very similar blobs in each row. Or some other way to reduce amount of storage for a lot of similar blobs across many rows, for example 10kB JSON where only o
5.
RAG vs. Finetuning or Both(rungalileo.io)
1 points by sjmiller609 3y ago|1 comments
6.
by sjmiller609 3y ago
Found this a helpful explanation
7.
by sjmiller609 3y ago
As a devops / platform guy, I would have typically made something like this by gluing a bunch of cloud / data tools together. e.g. like an ETL tool, orchestrator tool, maybe some process that dumps a DB, run a custom script, etc.
8.
Anonymized dump of your Postgres data, without installing an extension in prod(tembo.io)
2 points by sjmiller609 3y ago|1 comments
9.
by sjmiller609 3y ago
I wrote a guide and simple experimental setup for this extension: https://tembo.io/blog/table-version-history
10.
Version history and lifecycle policies for Postgres tables(tembo.io)
3 points by sjmiller609 3y ago|1 comments
11.
by sjmiller609 3y ago
I like how S3 object versioning and expiry works. I wanted something like that for Postgres tables, so I tried out a couple of extensions and wrote about what I found.
12.
Enter the matrix: the four types of Postgres extensions(tembo.io)
5 points by sjmiller609 3y ago|1 comments
13.
by sjmiller609 3y ago
Before working for a Postgres company, I had never used extensions. Now, I'm part of a team working to fully automate turning on any extension. I didn't find great resources to explain the process of turning on an extension, and w
14.
by sjmiller609 3y ago
That is awesome! Did you consider using the temporal_tables extension? I think it's basically like version history for tables. I haven't used this before personally though. https://pgt.dev/extensions/temporal_