SPBS

15 ms·

91.
by SPBS 3y ago
I feel like this is one of the things beginner programmers eventually figure out on their own without having to be told about it, otherwise they'd never be able to complete fairly basic programs but large programs which touch a lot of
92.
by SPBS 3y ago
> NULL makes little sense from first principles. You need something to represent lack of a value on LEFT JOINs. The author acknowledges as much, the two things he seems to be complaining about are: 1. It's impossible to distinguish
93.
by SPBS 3y ago
I saw the value in Tailwind, then switched over to Tachyons when I realized it was just like Tailwind but without the JavaScript build step (and you can actually use the full bundle as-is because it's 14kb gzipped) Tailwind probably lo
94.
by SPBS 3y ago
> Yes, there are features you can defer implementing until later, but their absence infects everything until you do. I still see cases where people have to drop down into ADO.Net code for C#, and the fact that you still see DBNull.Value
95.
by SPBS 3y ago
Apple notes is my todo list. When a task is done I just delete the line. It's genuinely useful because it helps me remember things I would otherwise forget. I don't use it as a "Getting Things Done" list. It's more
96.
by SPBS 3y ago
Well I don't really mean white, but more of pick a default theme that works in both day and night and stick with it. So that it's all kept very simple. You could use a dark theme as the default as well, but light mode tends to be
97.
by SPBS 3y ago
Honestly if the goal is a website as simple as possible, dark mode should not belong there at all. We've had simple readable websites in 90s long before the dark mode fad was a thing, only having light mode is fine. > Third, this bi
98.
by SPBS 3y ago
I'm convinced that there are two kinds of learning - conscious and subconscious. Most people think of learning as a purely conscious effort but I would point out that becoming fluent in a new language is almost entirely a subconscious
99.
by SPBS 3y ago
I had no idea RealPython was so well respected, but the example article is really quite egregious. I think the problem is the title was written for experts, but the contents were written for a beginner. Content mismatch.
100.
by SPBS 3y ago
I don't understand why this is so high when it's just using awk to naively split on commas. Any programming language could do that! I was expecting an actual command line tip that can handle CSV files in general, looks like it&#x2
101.
by SPBS 3y ago
I wish. I have it justified to me as "our SQL is not good" as the reason to use ORMs in my workplace. The result is code that primarily centers around the idea of fetching objects into memory and flushing them back to the database
102.
by SPBS 3y ago
Perhaps I was unclear, my underlying point is that short strings are cheap . And enum names are almost always short strings. 4 characters not enough? What about 8? That’s the size of a BIGINT, which everybody now uses for primary keys (the
103.
by SPBS 3y ago
Yeah the full text of the enum is stored in the table ('my_enum_xyz' is 11 ASCII characters so it takes up 11 bytes, plus 1 byte needed to store the length of the string).
104.
by SPBS 3y ago
I prefer directly using strings as enums, and using the foreign key constraint only to validate enum values. CREATE TABLE my_enum ( name TEXT PRIMARY KEY ); CREATE TABLE foo ( my_enum TEXT REFERENCES my_enum (name) ); The reas
105.
by SPBS 3y ago
And there's nothing special about Tcl the language that makes it special for scripting GUIs -- some people just put in the work to make a cross-platform GUI library and now everyone using Tcl benefits from it. I really wish Go had some
106.
by SPBS 3y ago
Substack is definitely scummy in this regard, it's not really the author's choice (although a conscious decision was made to host it on Substack).
107.
by SPBS 3y ago
> I hate articles like this because they present highly opinionated solutions as something definite even though it has a narrow focus on what the author cares about. Whatever the author says about custom scrollbars isn't going to st
108.
by SPBS 3y ago
Not really. A context-less function can call a contextual one by passing in a context.Background(), and a contextual function can call a context-less one by leaving out the context. This is unlike the split between sync/async.
109.
by SPBS 3y ago
The is great news, thank you for your work on this.
110.
by SPBS 3y ago
JSON is basically perfect if it allowed trailing commas and comments. TOML is not a replacement for JSON because of how badly it chokes on nested lists of objects (being both hard to read and hard to write), due to a misguided attempt to av
111.
by SPBS 3y ago
So this variant of T-SQL runs as fast as C right?
112.
by SPBS 3y ago
So it's both ubiquitous and a terse DSL for managing and coordinating programs. Yeah I agree. Also if you're on Windows it's nice that PowerShell is always preinstalled and serves the same purpose.
113.
by SPBS 3y ago
1. Nobody uses UUIDv1. Why use UUIDv1 as a straw man argument? 2. UUID strings are awful for storage -- don't use them. Yes there are databases that support UUIDs natively, why is whether or not a UUID fits into a machine word relevant
114.
by SPBS 3y ago
> For any given user it is better to have denormalised data where the data model is perfectly aligned to their use case. For a system with multiple users it is better to have normalized data. I don't see why you are making the disti
115.
by SPBS 3y ago
This post is about data analysis i.e. read-only queries. Of course denormalization wouldn't hurt, and might speed things up. Normalization is about making writes easier, because you only have a single source of truth to update. Try w
116.
by SPBS 3y ago
This is a Progressive Web App [1]? Terrible reading experience. The home page is just the book "cover", with no way to scroll down to the table of contents because it's convinced it has to behave as a real "book". E
117.
by SPBS 3y ago
I was expecting something like this article https://alexkrupp.typepad.com/sensemaking/2021/06/django-for... (discussed at the time https://news.ycombinator.com/item?id=27605052 ) but was greet
118.
by SPBS 3y ago
1. Craigslist is only used as an example. It could have been any other minimalist website. The post is not calling to imitate Craigslist because it is successful, it is calling to use minimal design (like Craigslist) for your MVP because if
119.
by SPBS 3y ago
Interesting tidbits to know about the English language but I'm not about to correct someone for that.
120.
by SPBS 3y ago
Huh, I was under impression AutoIt was the enterprise (i.e. paid) version of AutoHotKey. I'm surprised to find out it's freeware. I never touched it because I thought I had to pay.

More ›