SPBS

17 ms·

151.
by SPBS 4y ago
My honest take as an experienced vim user is that you could use vscode for the rest of your life and not miss a thing. There's nothing inherently virtuous about using vim keybindings to edit vs standard OS keybindings. It won't ma
152.
by SPBS 4y ago
https://sqlite.org/forum/info/2ad28cb1e0356816e7b0bd2ab458f7... I don't think BEGIN CONCURRENT is out yet. AFAIK it's only available if you build the experimental wal2 branch yourself.
153.
by SPBS 4y ago
When will mithril.js get the hype it deserves, I'm a sucker for simple tiny libraries with no dependencies and no build steps that are mature as well (6 years). I guess it doesn't have a flashy community with talks and developer a
154.
by SPBS 4y ago
Pleasantly surprised that RUM is just a drop-in replacement for the built-in GIN index, you can still use Postgres' native FTS operations with it.
155.
by SPBS 4y ago
it looks like it aggregates all footnote definitions into one where it can be printed with the keyword 'notes' (hardcoding? too clever? what if you want to separate footnotes?)
156.
by SPBS 4y ago
Reading between the lines, it's simply the author projecting. He has a theory that "attention, validation and connection" and important human needs and he looks at the creator with lots of followers and goes "well he sur
157.
by SPBS 4y ago
`sanitizeMessage` is literally just `message.replace(/</g, '<')` but it has to go through a ton of abstractive scaffolding just so that it can fit into a single call to map(). This is like jumping through a ton
158.
by SPBS 4y ago
Exactly what I was thinking, by omitting the <html> <head> and <body> HTML can be quite concise [1]. Additionally the closing </li> can be omitted from lists and <li> barely a step over using - for bullet
159.
by SPBS 4y ago
I don’t mind Go’s error handling a single bit. Reducing 3 lines to 1 line is hardly a win because people will still complain that their code looks bloated. I’m not against more concise error handling I just don’t like any of the current sol
160.
by SPBS 4y ago
You could have put it in a less sarcastic way. I don't see 88MB upfront anymore, because it seems to be lazy loaded (but still very laggy when it does). But it's not wrong to point out that the current UX is not perfect.
161.
by SPBS 4y ago
SQLite needs this, because changing column types is such a pain in the ass. The answer to "I want to move from INT primary keys to TEXT/UUID, how do I change the column type?" is "just insert the data into the column bec
162.
by SPBS 4y ago
If anyone is curious: https://valep.vc.univie.ac.at/virtualarchive/public/Archive/... (from https://news.ycombinator.com/item?id=33244723 )
163.
I finally figured out Twitter (2009)(jtolio.com)
2 points by SPBS 4y ago|0 comments
164.
by SPBS 4y ago
If you're inserting a lot of data with a high likelihood of conflicts you're probably better off using `INSERT ... SELECT .. WHERE NOT EXISTS` instead, that way you can have gapless sequences. -- Will leave gaps INSERT I
165.
by SPBS 4y ago
Oh, if I had read further into the README I would have seen this: > https://github.com/LycheeOrg/Lychee#build > Lychee is ready to use, right out of the box. If you want to contribute and edit CSS or JS files, yo
166.
by SPBS 4y ago
The UI from the screenshots look slick, but I can't help but notice that there is barely any JavaScript listed in the repo. Is this a primarily server-side rendered UI?
167.
by SPBS 4y ago
On the other hand, I write for me. I find it valuable simply penning down my thoughts so my future self can see what I was thinking of back then (or the events that happened in the past).
168.
by SPBS 4y ago
happiness is also how you choose to frame your world, not necessarily from doing an external action
169.
by SPBS 4y ago
Absolutely. People who say they want to just manipulate objects and let the ORM take care of persistence have no idea how much of a losing battle they are fighting. Sure, let me learn all about the intricacies of the Criteria API instead of
170.
by SPBS 4y ago
I'm sorry, but this is wrong. By including a brief description of your problem you are actually giving them a choice whether or not to respond, rather than just guessing at your intentions. Don't worry about a huge message appeari
171.
Prosser: Fourth-Generation iPhone SE to Adopt Same Design as iPhone XR(macrumors.com)
2 points by SPBS 4y ago|0 comments
172.
by SPBS 4y ago
Why does it kill you? A NULL in a row is semantically identical to the row never existing in the first place, unless there is some other non-null column (the primary key) that lets you disambiguate between the two cases. It's hardly a
173.
by SPBS 4y ago
Reminds me of this comment from antirez back in 2012: https://news.ycombinator.com/item?id=4560591 > This is one of the few programming quotes that is not just abstract crap, but one thing you can use to improve your pro
174.
by SPBS 4y ago
Frankly bizarre article. The author argues that SQLite is inappropriate for storing 16GB of <10KB text files because if you don't index by filename, looking up a file by its filename is going to be very slow (What he experienced). H
175.
by SPBS 4y ago
Yeah, the idiomatic (and fast) chi router does this ( https://github.com/go-chi/chi#url-parameters , https://github.com/go-chi/chi/blob/v1.5.4/context.go#L10 ). Routing information in
176.
by SPBS 4y ago
It's not difficult to make a stdlib-compatible handler with bells and whistles: just stuff everything into a context and provide helper functions for retrieving those variables from the context. This is what https://pkg.go.d
177.
What happened to simple, basic web hosting?(blog.jonudell.net)
2 points by SPBS 4y ago|2 comments
178.
by SPBS 4y ago
DynamoDB can model relational data just fine, if you're okay with setting your query access patterns in stone and never changing them again.
179.
by SPBS 4y ago
I assume such senior engineers who used to care about page weight have left YouTube by now. The trend of every big site (Facebook, Twitter, YouTube) is to go towards a fat multi-megabyte SPA.
180.
by SPBS 4y ago
I believe this https://sqlite.org/src/doc/json-in-core/doc/json-enhancement... is more up to date, as json_nextract is no longer in the core functions.

More ›