HackerTrans
トップ新着トレンドコメント過去質問紹介求人

Taywee

no profile record

コメント

Taywee
·3 年前·議論
It's hard to find a UI worse than that of your average Smart TV. They're in a league of their own when it comes to spectacularly terrible UIs.
Taywee
·3 年前·議論
FLAC is lossless. Any audio CD ripped and encoded to FLAC will be the exact same accuracy as WAV.
Taywee
·4 年前·議論
You should be using prepared statements and variable bindings. You should never have to parse any statement more than once (many dynamic language interfaces even cache statements for you, and many SQLite libraries also offer an interface for this out of the box). You should also never be formatting integers into strings, but simply binding them to the prepared statement. I really hope you weren't interpolating them and formatting each statement with the literal values in the string. That would be horridly inefficient, and a bad misuse of any modern SQL database. I also hope you were properly using transactions to speed up your batches.

See: https://www.sqlite.org/c3ref/stmt.html
Taywee
·4 年前·議論
According to Wiktionary, it's been used since at least 2001. I was similarly confused.
Taywee
·4 年前·議論
An improvement is an improvement. A flaw of seatbelts is that some people still die when they wear them. That's not a valid argument to not wear seatbelts.