ahachete

7 ms·

31.
by ahachete 10mo ago
TBH I haven't deeply tested it yet. Laptop is a few days old and I'm still "automating the install" (Ubuntu autoinstall + Ansible tasks for post-installation including BIOS upgrade and install Nix + Nix and home manager
32.
by ahachete 10mo ago
I have two Framework 13 DIY, top of the line (Ryzen AI 9 HX 370, 96 GB of RAM, 2TB WD BLACK SN850X). Well, TBH just one, the other one was stolen with less than one month, but that's a different story. Can't be happier with this c
33.
by ahachete 10mo ago
Thank you for your feedback. I'm trying to extract possible improvement actions from your comment, and here are my thoughts. That certificate expiry issue was unfortunate, but was resolved (if I'm not mistaken) a couple of years a
34.
by ahachete 10mo ago
Hi, StackGres founder here. We're constantly striving to improve the user experience and the quality of StackGres. Would you mind sharing some feedback as to what made your experience not good with it? Did you join the Slack Community
35.
by ahachete 10mo ago
Hi, StackGres founder here. We're constantly striving to improve the user experience and the quality of StackGres. Would you mind sharing some feedback as to what made your experience not good with it? Did you join the Slack Community
36.
by ahachete 11mo ago
Does the unused index feature look into replicas? (I guess it doesn't) It's risky to delete an unused index by looking at a single instance, since it may be used by other read replicas.
37.
by ahachete 11mo ago
Using natural keys is what actually can prevent duplicate rows. In your above example, if email is the PK, there would be no duplicates. But adding an id as a PK would essentially keep your database with duplicates: (1, 'bob', &#x
38.
by ahachete 11mo ago
Logical replication does NOT require a primary key. It requires either a primary key, a unique index or to define a replica identity. Sure, that still boils down, in most cases, to having a PK (replica identity is normally not a good idea),
39.
by ahachete 11mo ago
If I'm not mistaken, since 25.04 root-on-ZFS is available (as experimental) in the installer. I still prefer to do root on ext4 and then a proper ZFS pool for all the mountpoints I want, where I can configure as I wish with encryption
40.
by ahachete 11mo ago
> and technically you can also use ZFS on Linux, even if it's painful Maybe on some distros, but on Ubuntu is just an `apt-get install` away, or can be even be added from installation time. I've been using it for many years wit
41.
by ahachete 1y ago
This is conceptually similar to what we did for Postgres extensions at the StackGres [1] project. I gave a talk at a Kubecon about it [2]. However, this scheme is not perfect. Some Kubernetes security solutions enforce immutable containers,
42.
by ahachete 1y ago
For inserts is "easy" if there's no possibility to write the same PK value twice (e.g. PK are random values like uuids or include as part of a natural key a identifier from the writer that's unique -shard id, region id,
43.
by ahachete 1y ago
I'm not tired of reminding everyone that "conflict resolution" is no more than an euphemism for "breaking durability by dropping already committed and acknowledged data". Either architect for no data overlap on writ
44.
by ahachete 1y ago
I think that there's enough evidence that AZs are kms apart.
45.
by ahachete 1y ago
> And here for AWS multi-AZ losing data: https://news.ycombinator.com/item?id=4115937 That link is from 2012, 13 years ago. AFAIK as of today AWS provides strong guarantees about the AZs being physically, network, and po
46.
Plane heading from Baku to Grozny crashes in Kazakhstan(flightradar24.com)
3 points by ahachete 2y ago|0 comments
47.
by ahachete 2y ago
> Most notably, 'null'::jsonb = 'null'::jsonb is true whereas NULL = NULL is NULL Because 'null' in the JSON spec is a literal value (a constant), not SQL's NULL. Nothing to see here. https:/&#x2F
48.
by ahachete 2y ago
https://github.com/firecracker-microvm/firecracker/issues/16...
49.
by ahachete 2y ago
Last time I checked, Firecracker didn't have a very compelling I/O story, which made it in my opinion not completely adequate for running Postgres (or any other database). In contrast, other similar VMM seem to have a better one,
50.
by ahachete 2y ago
I was thinking of a similar approach, but mounting /nix/store from the host into the guest will only work if you have a single guest. For multiple guests, you should rely instead on: * A snapshot-able filesystem with the option to
51.
by ahachete 2y ago
AGPL is fully open source, and definitely allows you to host it without open sourcing anything of your code. That's one of the very freedoms that the open source definition contains.
52.
by ahachete 2y ago
Lenovo and Dell have some laptops with Linux, and they are very good ones. (not sure if you meant rugged ones, that may not be the case, but I guess this is a tiny percentage of the market)
53.
by ahachete 2y ago
Interested in contributing/co-writing such a runbook for StackGres? [1] [1]: https://stackgres.io/doc/latest/runbooks/
54.
by ahachete 2y ago
AGPL is the best OSS license to ensure project continuity as Open Source. That simple. Permissive licenses allow for proprietary forks, which may become more successful than the upstream project. AGPL would be able to benefit from any impro
55.
by ahachete 2y ago
Congratulations! I also love writing AWS API-compatible services. That's why I did Dyna53 [1] ;P (I know, unrelated, but hopefully funny) [1] https://dyna53.io
56.
by ahachete 2y ago
I'm very happy to hear that StackGres is helping you out. Your feedback is greatly appreciated :)
57.
by ahachete 2y ago
> The things I mentioned (local symbol auto-complete, reference-chasing, global go-to-symbol) are things that modern code editors do by default for any programming language Sure, they can. But as said, they are still quite basic stuff co
58.
by ahachete 2y ago
My experience is that you are slower/way slower without an IDE. I'm myself a CLI person, and I'd consider myself quite proficient using the shell and console editors like Vim. I know many shortcuts and I manage myself quite w
59.
by ahachete 2y ago
I applaud the decision to use AGPL-3.0. For me, it's a license that provides forward guarantees to the Community: no proprietary forks can happen, so any fork will be an OSS fork from which the upstream project may benefit too, which b
60.
by ahachete 2y ago
The (internal) use of DataFusion to create new, powerful extensions for Postgres is a very clever idea. Very good work for the ParadeDB team. I like this one very much. Very simple way to avoid having to use different set of tools and query

More ›