SPBS

47 ms·

211.
by SPBS 5y ago
TOML sucks for list of tables simply because they intentionally crippled inline tables to only be able to occupy one line. For ideology reasons ("we don't need to add a pseudo-JSON"). Unless your table is small, it's goi
212.
by SPBS 5y ago
> eschew unnecessary abstractions The problem is, no one can agree on what is the 'necessary level of abstraction'. Where you stand on that scale determines whether you love or hate Go as a language.
213.
by SPBS 5y ago
> goes into maintenance mode, only getting updates when a new OS update breaks it. I don't see anything wrong with this. Users buy software because it solves their current problem now, rather than a possible feature in the future. T
214.
by SPBS 5y ago
I genuinely couldn't tell if the author was being sarcastic when he said Larry Ellison was down on his luck because he dropped from 5th richest to 10th richest (and the whole thing about pulling himself out of the gutters by clawing up
215.
by SPBS 5y ago
Wait til they find out that methods cannot introduce generic parameters. I predict that complaints will shift from ‘no generics’ to ‘no generic methods’.
216.
by SPBS 5y ago
Yeah, I'm starting to warm to the idea of `CREATE TABLE tbl ( created_at INT ) STRICT;`. The name still hints at what domain type it contains, and enforcing INT timestamps should make any indexes on that column considerably smaller.
217.
by SPBS 5y ago
STRICT tables forbid the use of any other types besides INT/INTEGER, REAL, TEXT, BLOB (and ANY). What about TIMESTAMP? DATETIME? You can't use that as a type name anymore. Either pick INT, REAL or TEXT for that. What about JSON? Y
218.
by SPBS 5y ago
Oh okay, so you can store authorization data in a table mapping user_ids to location_ids right? Then instead of using `IN (big_list)` (which can't use indexes) you join on the mapping table (which can use indexes). Something like
219.
by SPBS 5y ago
> you can't use groups that your customer knows about I don't understand why you can't use groups to organize access control. Is this a customer-enforced restriction? Or a technical one?
220.
by SPBS 5y ago
Maybe not the symbol, but the article artificially constraining itself to 'M' seems a bit suspect to me. In my country the symbol for the metro isn't even M [1] [1] https://upload.wikimedia.org/wikipedia/
221.
by SPBS 5y ago
I pity the student who only knows how to hit the compile button in the IDE and not `javac`. That's a terrible thing to inflict on a beginner, everything will seem like a mystical black box to them with no way forward when they hit enco
222.
by SPBS 5y ago
Compared to Tachyons being tiny by default and you just add anything else you need in another CSS file. It's just another CSS file, why is the 'Tailwind way' so averse to using custom CSS? Instead it includes every style by d
223.
by SPBS 5y ago
> In many countries, FB-only internet is free and that means FB-only internet is the internet for like a billion people. I'm not so sure that this shows Facebook pulling off an odds-defying feat. AFAIK Facebook targeted people who w
224.
by SPBS 5y ago
If you have multiple pages each with their own javascript that allows them to behave like an application, is it still considered a SPA? Yes it behaves like an application, but javascript running AJAX is hardly different from what traditiona
225.
by SPBS 5y ago
From https://htmx.org/ : > Why should only <a> and <form> be able to make HTTP requests? > Why should only click & submit events trigger them? > Why should only GET & POST be available? > Why
226.
by SPBS 5y ago
I'm somewhat skeptical of Wix's engineering principles in general. Back in 2015 they released an article[0] about using MySQL as a better NoSQL database and talked about how joins are bad for latency, and then their example of a &
227.
by SPBS 5y ago
> neither are you ever going to use Confluence as a filesystem storage to replace Google Drive. This means that your knowledge’s single-source of truth needs to accept external tools content as possible documentation. This interfacing, t
228.
by SPBS 5y ago
> look at the success at medium for tech writers I feel like medium doesn't even care about tech writers -- don't people still have to host github gists for code snippets? The biggest middle finger to tech bloggers, and yet the
229.
by SPBS 5y ago
The top comment: > You'll check the analytics. Abysmal. Nobody is reading! > You may write a few more posts, but it's always the same story. A lot of work goes in, but not much comes out. I never understood this sentiment. W
230.
by SPBS 5y ago
Any discussion on the utility of currying (i.e. closures) vs constructing an object with methods always reminds me of this parable: ``` The venerable master Qc Na was walking with his student, Anton. Hoping to prompt the master into a discu
231.
by SPBS 5y ago
> And then the obvious thing happened: a complete breakdown of all important systems, like a house of cards. And: most vendors were not working due to lockdowns or other important issues during the pandemic. > The only system not affe
232.
by SPBS 5y ago
Cool, it appears that the trend towards JS may be causing self-selection -- if a page has a high amount of JS, it is highly unlikely to contain anything of value.
233.
by SPBS 5y ago
Doesn't matter, the standard library simply has to set a consistent example for people to follow. They can choose to ignore it.
234.
by SPBS 5y ago
Why would anyone use Hyper? It's not like there aren't better terminal emulators out there for each platform. Using Electron to emulate a terminal is plain insanity to me, you are trading off performance and system resources for t
235.
by SPBS 5y ago
No way, OP is essentially serving a static webpage from a database. That's nothing to brag about if comparing with mangadex.
236.
by SPBS 5y ago
> It is recommended to learn if subtransactions are used in your systems. If they are, it does not immediately mean that they need to be eliminated – it all depends on the risks of your particular case. Evaluating such risks is a complex
237.
by SPBS 5y ago
> When doing multiple steps that need to track external state Do you have an example of this? Many explanations for SAVEPOINT say it is useful when 'recalculation is deemed too expensive' but I cannot come up with a satisfactor
238.
by SPBS 5y ago
any examples of companies who have successfully fended off the big corps in this scenario?
239.
by SPBS 5y ago
> But these two camps of databases are slowly converging too, with JSON datatype support in MySQL and PostgreSQL, and pseudo-JOINs and transactions in MongoDB. That's not enough to justify 'Oh I guess SQL vs NoSQL isn't ab
240.
by SPBS 5y ago
You don't drop the timezone information. You manually normalize the timezone to UTC time, application side, before storing it in the database. This is to get around MySQL's crap handling of datetime types: - TIMESTAMP 'stores

More ›