SPBS

28 ms·

241.
by SPBS 5y ago
> There's three common ways to store timestamps in MySQL and they all stink I used to think that, but now I realize those problems would disappear if you set server time to UTC and only work with UTC values. It's not an excu
242.
by SPBS 5y ago
> This has saved me from a lot of errors Are your projects in a dynamically typed language? I struggle to think why a statically typed language would have this problem, because the data being transferred at the boundary between applicati
243.
by SPBS 5y ago
As it rightfully should. God forbid people start returning Result[T] types instead of (T, error) and splintering the ecosystem. Option types are pointless if you don't have exhaustive pattern matching to ensure correctness.
244.
by SPBS 5y ago
It’s not as bad as Java’s NullPointerException because primitive types and compound primitive types are much more prevalent (which are guaranteed to never be nil).
245.
by SPBS 5y ago
CSV is often used as a database-agnostic data dump file. Since the author suggested sqlite as a possible alternative to CSV, I think that using sqlite as a database-agnostic data dump file actually sounds pretty good. For starters, all data
246.
The Multiple SQLite Problem(ericsink.com)
4 points by SPBS 5y ago|0 comments
247.
by SPBS 5y ago
The targeting of the education system is insidious. Hong Kong youths may be known for being outspoken about democracy today, but Hong Kong youths tomorrow will become passionate about the CCP. We are seeing a turning point in history.
248.
by SPBS 5y ago
I think this might be it. I remember my first interactions with Tik Tok to be full of teens lip-syncing songs while preening on camera. I'm still not a regular user, but now whenever I open the app I actually see people from all walks
249.
by SPBS 5y ago
> Apple's license agreement says that they own the operating system, but that doesn't give them permission to search whenever they want or to take content. If this is true, how has this gotten past Apple's legal team? Are
250.
by SPBS 5y ago
> Thus they will often say things with implicit meanings that are contrary to their literal meanings — aka irony — that go right over American heads. An interesting counterpoint would be that although Japanese communication is extremely
251.
by SPBS 5y ago
Nope. The same philosophy of imperfect design can be held to imperfect naming as well. When will this unexpectedly-intelligent behaviour that belies its name ever bite a user in the ass? Hardly ever? Then it's fine to have a slightly d
252.
by SPBS 5y ago
> if the directory has many files or sub-directories, tree becomes much less helpful: you only see the last screen full of information as files scroll past you. > broot solves this problem by being aware of the size of your terminal w
253.
by SPBS 5y ago
I disagree, because Bottom Line Up Front. Take the straightest path to communicating intent. Word count is not important. If your intent is to make the reader feel things with flowery language, then it's appropriate to use flowery lang
254.
by SPBS 5y ago
It’s fine, a lot of people still use Safari on desktop despite Google Chrome being available. And developers have to support it all the same
255.
by SPBS 5y ago
Even SQLite supports transactional DDL. MySQL (and Oracle) are the exceptions here.
256.
by SPBS 5y ago
> I’ll admit, multiple dispatch is a super abstract concept, one that you really only appreciate when you need it. After reading this post and this stackexchange link[0], I'm not sure it is that complicated. The behaviour in the pos
257.
by SPBS 5y ago
SQL is a pretty warty implementation of relational databases (with non-composability being its primary sin IMO), but we're stuck with it at this point. A new querying DSL that fixes all of SQL's flaws is only half the story, getti
258.
by SPBS 5y ago
FWIW the scoping in JavaScript is exactly the same in Go, so it's not something obscure that only JavaScript cooked up.
259.
by SPBS 5y ago
But Ctrl+Cmd+Space already brings up the emoji picker no matter what application you’re in. The analogue for Windows is Win+. or Win+;. The touch bar isn’t so unique for its emoji capabilities.
260.
by SPBS 5y ago
> In actual practice, the superior reporting tools available in Fossil mean that the added "mess" is not a factor. Okay, what tools are these? Fascinating to see how Fossil handles the commit mess.
261.
by SPBS 5y ago
Very cool, shocking that this may be the only mention of it on the internet because Google shows 0 search results for it.
262.
by SPBS 5y ago
> Inheritance is much less troublesome in, say, Smalltalk, since the language is dynamically typed. If someone expects you to implement Foo, you can (almost always) just implement its relevant methods without explicitly extending the cla
263.
by SPBS 5y ago
Factory functions don't mean using the (admittedly ugly) IIFE syntax or accessing __proto__ fields. This is an example of factory function function NewObj(n) { let myPublicInt = n; let myPrivateInt = 0; f
264.
by SPBS 5y ago
I don't understand why people are so hyped about OOP syntactic sugar when JavaScript could already do those ages ago. For example: the class keyword. JavaScript could already do classes via factory functions (return an object with asso
265.
by SPBS 5y ago
> The blogpost here drilling down into every perceived slight and human failing lacks grace and magnanimity and doesn't seem much better at You forget that the author is personally offended too. He just has no way to extract a prope
266.
by SPBS 5y ago
Well, yes. Vimscript plugins will see better adoption. Lua matters for compute-heavy plugins. > Ahh, yes, the Turing-equivalence fallacy: "technology A is theoretically capable of doing everything that B does, therefore they're
267.
by SPBS 5y ago
I use nvim in the terminal and gvim/macvim on the desktop. I don't like how the nvim community seems to be throwing themselves wholeheartedly into lua and lua-only plugins (vimscript plugins are better because they work with both
268.
by SPBS 5y ago
Given that time-ordered UUIDs are hardly a new concept, it would be nice if the author did a comparison with the current state of the art rather than let such a bland README do the talking.
269.
by SPBS 5y ago
The semantic difference between `jsonb_set` and the new subscripting syntax reminds me of ES6 arrow function situation: a new and improved syntax built seemingly to replace the old one, except there's a slight semantic difference such
270.
by SPBS 5y ago
Fat server, thin client might be an attractive model for businesses if all they had to do was issue cheap laptops and reap powerful hardware performance. But Mighty only targets web applications? How many slow web applications do people use

More ›