Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
mickeyp
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
11 ms
·
151.
▲
by
mickeyp
2y ago
Screen, tmux, et al. are great. But here's another way of approaching the same problem: Emacs can serve as a superlative terminal multiplexer if you're willing to give it a shot or if you're already an Emacs user, but do not
152.
▲
by
mickeyp
2y ago
Update-related throughput and index problems are only a problem if you update tables. You can use an append-only structure to mitigate some of that: insert new entries with the updated statuses instead. You gain the benefit of history also.
153.
▲
by
mickeyp
2y ago
No, it is not bad practice. Only developers who don't care about money actually coming through the door -- the same ones that get caught up in a local maxima trying to perfect the imperfect -- say that it's bad and that you should
154.
▲
by
mickeyp
2y ago
It's not unbelievable if you know and use Emacs and dired. dired will use `ls' if it is available. You can also control the arguments passed to `ls' if you want to customize sort order and suchlike. You cannot trivially do th
155.
▲
by
mickeyp
2y ago
Emacs has game of life also. M-x life.
156.
▲
by
mickeyp
2y ago
In a similar vein in Emacs: M-x zone Every time you run it, it triggers a random screen saver effect. Fun when it's on a timer and triggers so your work colleagues wonder wth is going on.
157.
▲
by
mickeyp
2y ago
Would you care to tell us what your backup and restore policy would be for 1.7 PB of data?
158.
▲
by
mickeyp
2y ago
Because PHONY targets can do that, too, and without the needless manual work. Because a Makefile can still do Makefile things: PHONY targets depending on other PHONY targets, which so happens to depend on that one openapi json export you al
159.
▲
by
mickeyp
3y ago
This is a great way to tell everyone you've never had to do this type of migration. Oracle's got a lot of nasty things going for it, for sure. But there's a reason people still use it: part of it is vendor lock-in, of course;
160.
▲
by
mickeyp
3y ago
Fitzrovia is laced with fibre; the entire area is/was host to a large number of broadcast service providers, media companies, telcos, etc. Running out of fibre is not likely in that part of London.
161.
▲
by
mickeyp
3y ago
Because if something can return None, you should explicitly check for that, to avoid truthy/falsy gotchas [1]. [1] https://www.inspiredpython.com/article/truthy-and-falsy-gotc...
162.
▲
by
mickeyp
3y ago
It has to be public (or at least not too locked down) or things like Address Book in outlook would stop working. Lots of weird things depend on the LDAP tree being broadly accessible. It's just that it leaks more information than most
163.
▲
by
mickeyp
3y ago
LDAP's full of secrets. It's a great way to keep tabs on what's going on in a company. And to think that you can get nearly all of it with anonymous access. Team or department mergers before they were announced? Yep, I'v
164.
▲
by
mickeyp
3y ago
Yes, of course. It'll work in EAT and M-x term too.
165.
▲
by
mickeyp
3y ago
> C ABI library protocols, and offered stdio and socket interfaces to them, then suddenly the landscape of possibilities in software composition would be way broader You've just invented a rudimentary and worse version of COM. (The
166.
▲
by
mickeyp
3y ago
fzf won't work in shell-mode as it does not handle curses-like apps. Thus, `ezf.el' avoids that problem by using Emacs as the fuzzy searching facility. To say nothing of the fact that this is a fine example to re-use for, similar,
167.
▲
by
mickeyp
3y ago
Graph theory underpins nearly everything we do in software development and computer science. Networkx is an expansive -- though not the only -- package for Python that'll solve 90% of people's problems.
168.
▲
by
mickeyp
3y ago
Laying out a graph so it's "friendly to humans" is a seriously hard problem. I've built complex DAG workflow engines using networkx and its layout tools and they worked just fine. But, yeah, I guess it depends on what yo
169.
▲
by
mickeyp
3y ago
Loved the boxee box. Thanks for that! Do you happen to have the radio specs for the remote? I miss it so much, I want to use it for my home cinema setup.
170.
▲
by
mickeyp
3y ago
But beware row-level security. It's great, but the query planning is a huge mess, and you can end up with serious performance issues real fast if you're not careful.
171.
▲
by
mickeyp
3y ago
> Sometimes you want to swallow exceptions and sometimes you don't. You capture `Exception' in your examples which is a serious anti-pattern in nearly all cases. One of the rare places you'd want to do that is at the top l
172.
▲
by
mickeyp
3y ago
> 1. Very flexible configuration. 2. Can be linked with MySQL/other DBS to do queries for whatever informations and then derive delivery logic from that. Postfix can do this, and could do this, when I set up MySQL integration with p
173.
▲
by
mickeyp
3y ago
Using audit tables is another approach that avoids rolling up the data periodically, and you avoid all the needless complexity this approach can introduce; particularly if you're not 100% sure you need it. You gain temporal querying wi
174.
▲
by
mickeyp
3y ago
> If you define a table as strict, the data is coerced, and if not successful an error is thrown. Coercing the data is hardly better. Now you have data integrity issues and you have no errors!
175.
▲
by
mickeyp
3y ago
Like Dell and Bladelogic used to be? Or VMWare ESXi and friends? Or...
176.
▲
by
mickeyp
3y ago
Oracle has query hints; pg does not. Query planner hinters are useful. That's my point.
177.
▲
by
mickeyp
3y ago
You've never run into a query planner that suddenly changes its mind once your tables grow. Try using row level security in postgres - it's awfully slow and you need to be a master architect and sql developer to make it run fast b
178.
▲
by
mickeyp
3y ago
There are many interesting use cases for `emacsclient' if you use it. Here's a quick shell script that turns your Emacs into the CLI tool `fzf'. Instead of fzf, you can use Emacs's advanced completion tools to do the fil
179.
▲
by
mickeyp
3y ago
This is a great resource and a perfect example of what clear explanations, code and visual aids can do to help you learn a wide range of algorithms.
180.
▲
by
mickeyp
3y ago
> The core problem here is that web application developers don't understand or use database transactions. I've seen this myself at almost every web shop I've ever worked at - queries / updates would be made to the dat
More ›