chousuke

37 ms·

301.
by chousuke 6y ago
null is not a very good default value in most cases though, since the operations you do with values of "real" types will not work on null. Therefore actually using your "default" value is pretty much guaranteed to be a b
302.
by chousuke 6y ago
It does, though? That's what autovacuum is, unless I'm missing something. It's just not always enough without tuning, just like GC.
303.
by chousuke 6y ago
wayvnc and waypipe work just fine nowadays. I've actually used waypipe more often in the last year than I ever used ssh -X, thanks to a shift towards WFH :P It's sometimes useful to be able to run Firefox remotely from my workstat
304.
by chousuke 6y ago
Ansible is okay for stuff like that. I very much don't like that it does the YAML-as-a-programming-language thing that's way too popular nowadays but when judiciously used, Ansible can be useful. I really want something like Ansib
305.
by chousuke 6y ago
I'm somewhat worried about what this means for our organisation. We use both Jira and Confluence, and while they have their issues, we've got many integrations that make life significantly better that will be work-intensive to c
306.
by chousuke 6y ago
It's difficult for me to answer how other people should learn these things, since I personally just... tried to figure things out? It's been so long since I found basic networking mystifying that I'm not sure how to explain i
307.
by chousuke 6y ago
People who know enough to consider architectures like this aren't the ones most likely to accidentally expose databases to the internet. It happens, but most often these mistakes are made by people who just don't have the experien
308.
by chousuke 6y ago
There's no reason "pure FP" should be fundamentally any more inscrutable than Java code; that assumption may just be a personal bias due to familiarity. It's definitely possible to go the other way too, with an object-or
309.
by chousuke 6y ago
Personally I think of working in a branch as the process of creating a patch set. A patch in a series should only depend on its predecessors. You can submit more than one patch in a pull request. I would never send out a patch set for revie
310.
by chousuke 6y ago
> And worth noting that this can be missed during development if you have a good network It can be even worse if development is done using a local database, possibly on super fast local SSD. The latencies can be orders of magnitude low
311.
by chousuke 6y ago
Those are questions where the answer depends a lot on what you're using the database for and what your requirements are. I'm not the best person to evaluate how much of a "hassle" setting up things has been, since I&#x27
312.
by chousuke 6y ago
I most often choose Python because it's what's available, and it's good enough for the things I need to use it for. Other people can generally understand my code, too. F# probably is a good language, but I haven't had a
313.
by chousuke 6y ago
What's complicated about a syslog server? I suppose some applications like to spew out multiline logs (which are something you just can't process outside the source while maintaining sanity) but seriously, when you actually consid
314.
by chousuke 6y ago
For my use cases, the vast majority of errors with dynamic languages boil down to being able to run scripts that have undefined variables; I'm prone to (mental) typos, so if I had a dialect of Python that failed before runtime when und
315.
by chousuke 6y ago
You can get it to work with VMWare and KVM, but in most cases you'll run into problems with hardware . Very few motherboards (and GPUs) actually properly implement the required functionality, so if you don't consider this use cas
316.
by chousuke 6y ago
I've used this for migrating some applications. It worked well enough. In addition, the "orafce" extension was also useful in reducing required changes to the actual SQL queries the applications made. In my case, the applicat
317.
by chousuke 6y ago
I've never felt the need to visualize git scenarios; they just aren't all that complicated most of the time, though I can see how it might be useful to open a graph viewer if you have a tricky merge to sort out. For me, being able
318.
by chousuke 6y ago
This is perhaps not all that relevant to your point, but "the sky is blue" so often being used as an example of an obvious truth is amusing to me, because very often the sky is not all that blue at all. If I look outside right now
319.
by chousuke 6y ago
One new pitfall I learned yesterday is that sourcing a file searches $PATH. I ran a tool that did ". config" on OpenBSD and it tried to source config(8) instead of its configuration in the local directory. Oops.
320.
by chousuke 6y ago
It's that way because in C "declaration follows usage". In the above, you're declaring the types of * a and * b to be char, making a and b pointers to char. (EDIT: how do you escape * properly inline with other text?)
321.
by chousuke 6y ago
It can also be that instead of people giving your Gmail address as their own, the receiver ignores the domain and just assumes that it's @gmail.com. I've had that happen a couple times. People also get very confused about + in a
322.
by chousuke 6y ago
I think PostgreSQL actually is a bit of an odd one in that it relies on the OS to do proper caching of whatever data is read from disk. It has its own buffers for various things, but I'm pretty sure it doesn't (yet) implement its
323.
by chousuke 6y ago
How do they measure unlimited plans? I've never had to pay attention to traffic metering since in Finland virtually all operators offer unlimited data. I seem to use about 100GB a month at worst which would put the price at around 30 c
324.
by chousuke 6y ago
I view Ansible and Terraform as complementary tools; I can imagine performing rolling upgrades by using Ansible to shoot down a node and then have Terraform rebuild it; and Terraform could use Ansible to configure the nodes, if you're
325.
by chousuke 6y ago
As one of those "admin/ops" people with experience of fixing terribly set up systems, a common issue is that users just can't tell the difference between systems that work insecurely and systems that work securely, but t
326.
by chousuke 6y ago
Perhaps it's just that in some cases, the tool is overkill? In one case, I wrote a super simple shell script to track applied migrations to a database that had until then been managed entirely manually; I didn't feel like it was w
327.
by chousuke 6y ago
Of course you don't need to think of every possible way to compromise a system; just enough to reasonably protect against your threat model given the resources you have. If you have a complicated system that requires "hundreds o
328.
by chousuke 6y ago
That's a tricky question. Personally, I find that while reading about something is a good way to gain a vague understanding of how something works, to actually integrate it, I need to actually get a system set up and then just dig arou
329.
by chousuke 6y ago
I'm not sure where you went wrong; by default, Postgres is secure; the configuration listens on localhost and even if you change that, does not allow network access to the superuser. Distributions may ship with less secure configurat
330.
by chousuke 6y ago
they boot using BIOS, yes. I suppose some of our EFI-booting hardware hosts might be affected, but all of our virtual machines boot using BIOS since it happens to be the default and there's not much point in switching them to EFI.

More ›