273 karma · joined September 3, 2017
Most people I know, myself included, pronounce it that way. But Richard Hipp, the creator of SQLite, actually pronounces it SQL-ite, like a mineral.
just as a substitute for up-arrowing, have you tried ctrl-r/reverse-i-search? (if that's a thing in fishshell)
edit: I see wodenokoto already mentioned this workflow in another comment
Regarding the n+1 problem: of course that can be solved with plain rest endpoints as well, but it requires you to form your API around it, where if you have one unified endpoint solving the n+1 problem is a mere implementation detail on the backend.
In situations where it's desirable that a system's complexity is expressed in the API design, I can see GraphQL not being a good fit. If I compare it to SQL it is understandable that you sometimes do need to restrict what can be done to clear predefined operations, say for performance reasons. But if you can get away with this general "intent-based" querying, which GraphQL does well, I recommend it over plain rest endpoints.
"JSON lines" extends JSON by a) not allowing newlines in values and b) allowing newlines to be used as a top-level separator for elements of a list, instead of the JSON-compliant comma-separated list enclosed in square brackets
This allows for per-line parsing, which can significantly reduce memory usage and allow for partial parsing in some scenarios. I've seen it used where the data is fundamentally a large collection at the top level where producing proper JSON was using too much memory
Seemed like a free way to offer slightly better performance on the API (both serialize/parse times and bandwidth), since it can just serialize any data without specifying protocols or schemas, like json serializers can too. I didn't know about any alternatives that would also require no further configuration or infrastructure, so it seems like msgpack fills this 'free performance boost' niche quite nicely
Are there already existing, more polished wrappers around ffmpeg that include enough escape hatches to be able to fully leverage everything ffmpeg supports? I probably just didn't search and evaluate options long enough.
- I want to see the changes in a directory tree that I can navigate through!
- I want to comment on any piece of code, not only changes and their surroundings!
- I want to hide things, or mark them as "seen", to be able to look at things in the order I want without any risk of losing progress!
- I want to be able to filter/sort by the "change type", e.g. Imports, renames, indentation changes etc.!
- I want the diff to be aware of programming semantics, e.g. know when a function just moved from one file to another, or I add a method overload and don't get a diff telling me I added a closing bracket and another whole method signature in the middle of the old method!
- Let me type code! I want to try out and propose changes!
- I want freedom editing my review before submitting it the way I have freedom editing my branches before committing it!
- I want to have single comments refer to ranges of changes, which aren't necessarily connected or in the same file!
- I want to easily see what happened to the changes since I reviewed them! (Not a clickable link "changed since then bla bla", show me right there!).
- And probably most important: It has to be fast! Hyperbole: Having to wait for the page to load for a minute for large diffs, and then having to wait another minute for all changes to _actually_ be visible is a no-go.
The available tooling is already very powerful, but it still frequently fails me and I believe having this be extremely polished would be a real productivity game changer. Maybe there are already some great tools? Last time I had to look over a huge amount of changes I resorted to a patch file; grepping away unnecessary changes like package renames etc and just deleting text lines I considered sufficiently reviewed.
Also small sidenote: Does it not properly sign the PGP test mails for anyone else?