yen223

24 ms·

421.
by yen223 2y ago
Heads up: your link is blank when I opened it in Firefox Uncaught TypeError: SpeechRecognition is not a constructor
422.
by yen223 2y ago
I regularly use an 11" iPad in portrait mode, mostly because I find it easier to hold a tablet in portrait than in landscape. What I can say is that a lot of apps and websites don't quite look right in portrait mode, which is a sh
423.
by yen223 2y ago
https://getselectable.com/ I'm working on Selectable, a mobile-friendly database management app, like dbeaver but for the phone. Working on this project has taught me so much about how Postgres works under the hood, an
424.
by yen223 2y ago
Umami refers to a specific flavour, savoury refers to a broad category of foods that are basically not sweet. You can have "savoury" meals that have no umami flavour.
425.
by yen223 2y ago
A "calling" seems like a perfectly cromulent word for what's being talked about
426.
by yen223 2y ago
I hate performance reviews as much as the next person, but one of the useful things my previous company made us do was the self-reflection. The self-reflection portion forces me to remember what I was doing, and equally importantly it force
427.
by yen223 2y ago
To have discussions people need to be able to see your post, and on HN it can be a matter of luck.
428.
by yen223 2y ago
If you verified the existence of the Higgs Boson you should be entitled to use any font your heart desires.
429.
by yen223 2y ago
Someone made a monospaced version of Comic Sans, and it's ... not terrible? https://dtinth.github.io/comic-mono-font/
430.
by yen223 2y ago
Only just noticed, if you google "Comic Sans" the font changes.
431.
by yen223 2y ago
The bank's trustworthiness doesn't come from their 98 Lighthouse score. It comes from the fact that they have the word "bank" in their name, and people trust banks.
432.
by yen223 2y ago
Postgres makes a distinction between IMMUTABLE, STABLE, and VOLATILE functions, with volatile functions being functions that - with the same arguments - can produce different results even within the same statement. Therefore VOLATILE functi
433.
by yen223 2y ago
One of my earliest web projects was a Lorem Ipsum text generator that pulled text from the /r/nocontext subreddit
434.
by yen223 2y ago
Peter Norvig's post on solving sudoku puzzles helped kickstart my love for programming https://norvig.com/sudoku.html
435.
by yen223 2y ago
For those who don't know, you can click the "past" link in the toolbar, and see for yourself what HN was like on any given past day, and judge for yourself whether the quality has declined https://news.ycombinator.
436.
by yen223 2y ago
You really don't want to give Google any excuse to suspend your account, especially if you're monetising it.
437.
by yen223 2y ago
Starting a company might be easier than you think. Where I'm at, registering a business and getting a D&B number was cheaper than the $99/year Apple makes you pay for the app dev account. This depends on where you are based in
438.
by yen223 2y ago
There goes my thirties too I guess
439.
by yen223 2y ago
Please don't drag me back in, I've already lost a good chunk of my twenties to that game
440.
by yen223 2y ago
Kotlin has an interesting approach to solving this. You can name functions using backticks, and in those backticks you can put basically anything. So it's common to see unit tests like @Test fun `this tests something very complic
441.
by yen223 2y ago
That's how something like `clock_timestamp()` can be supported. It returns the timestamp at time of execution, so it can change even within the same query if called multiple times: https://www.postgresql.org/docs/c
442.
by yen223 2y ago
Databases tend to be "stickier" than other parts of any large software system. Largely because database migrations are costly. You can't just tear down an old database and rebuild a new one, you have to figure out how to move
443.
by yen223 2y ago
Yeah, the new Google Play requirements around Personal accounts are extremely hostile to solo developers. The "simple" workaround is to start a company with a virtual address, and sign up for an Organization account. They'll
444.
by yen223 2y ago
Sometimes I lament the fact that in Jetpack Compose, @Components don't return anything. They are all side-effecting functions, even though the view is supposed to be a function of the arguments. But then I hit a "Unable to infer c
445.
by yen223 2y ago
Jetpack Compose has the benefit of being mostly open source. I can always crack open a misbehaving TextField to see what's going on underneath. SwiftUI has the unfortunate combo of being closed-source, being platform-dependent, and bei
446.
by yen223 2y ago
You aren't renaming tables at scale because there are 27 downstream services that will break if you even think about fixing the name of the revnue_dolars table, and it's not in anyone's OKR to fix it
447.
by yen223 2y ago
Clickhouse is a SQL database, so I guess it is? (Strictly speaking since a "relation" in the original Codd-paper sense is a table, anything with tables is relational. I don't know if that's what people mean by "rela
448.
by yen223 2y ago
That's right. The key difference is using row-based vs column-based databases (i.e. OLTP vs OLAP). Any good database person should be cringing at the thought of using Postgres (or MySQL, Oracle, Sql Server, etc) for pulling reporting d
449.
by yen223 2y ago
I did, twice. The second time, we had a reporting system that eventually stored billions of rows per day in a Postgres database. Processing times got so bad that we decided to migrate to Clickhouse, resulting in a substantial boost to query
450.
by yen223 2y ago
I almost have the opposite view: When starting out you can get away with using a simple Postgres database. Postgres is fine for low-traffic projects with minimal latency constraints, and you probably want to spend your innovation tokens els

More ›