SPBS

16 ms·

181.
Apple reaches $50 mln settlement over defective MacBook keyboards(reuters.com)
5 points by SPBS 4y ago|2 comments
182.
Small is the new big (2005)(seths.blog)
3 points by SPBS 4y ago|0 comments
183.
by SPBS 4y ago
Especially egregious in technical blog posts when the author uses them because they think it looks nice but then forgets that not everyone knows what those symbols mean. Leave ligatures out of code blocks.
184.
by SPBS 4y ago
I just use whatever is the default in the terminal or IDE. I used to care (it was either Consolas or Source Code Pro for me) but now I find it easier to just not care about it.
185.
by SPBS 4y ago
This enlightens me as to how people can code with ed (and why Ken Thompson famously said 'I don't want to see the state of the file when I'm editing.'). It's basically a REPL for writing code. Same as psql, the comm
186.
Why Can't Database Tables Index Themselves? (2006)(blog.codinghorror.com)
158 points by SPBS 4y ago|119 comments
187.
by SPBS 4y ago
A nursery is just an errgroup ( https://pkg.go.dev/golang.org/x/sync/errgroup ). I almost never have to use the `go` keyword directly, only through errgroups. Now I can see that it's because `go` is usuall
188.
by SPBS 4y ago
I was excited to prototype a HTML-template driven application using Wails, but found out that you're basically forced into making a SPA i.e. URL routing doesn't exist, you have to handle page transitions using JavaScript. Also the
189.
by SPBS 4y ago
I look up to https://sqlite.org/lpc2019/doc/trunk/briefing.md (discussed at https://news.ycombinator.com/item?id=25167423 ) as an example of how to talk about something very technical with sim
190.
by SPBS 4y ago
So cursor pagination is just keyset pagination, except instead of using a column value directly you use an opaque string that gets translated back to a column value. So you can modify how the cursor gets translated back to a column value an
191.
by SPBS 4y ago
That's the Trucker's Hitch, using a simple overhand knot for the loops. You can use any knot to create a loop, my preferred one is the alpine butterfly because it can be tied in the middle of any rope without needing access to the
192.
by SPBS 4y ago
This is a data serialization format, not a replacement for storing your business data. Your business data needs to have the same schema enforced everywhere, otherwise how are you going to reconcile your user data now and your user data 5
193.
by SPBS 4y ago
SQLite doesn't support adding generated stored columns to a table once the table has been created, so you basically have to decide upfront which generated columns must be stored, and then you can't touch it anymore (short of dropp
194.
by SPBS 4y ago
100% agree. "It's not a real programming language" has become construed as an attack against anyone who makes a career in tech writing DSLs, now everyone labels anything technical as "programming". Laypeople probabl
195.
by SPBS 4y ago
> The problem with *-tab is that each application has no fixed place in that space. BTW Win+1 to Win+9 will switch to the first 9 pinned items in taskbar. If there isn’t an available window it will open one. I have Outlook pinned as the
196.
by SPBS 4y ago
Note to author: the part with actual shell examples is buried too deep, I didn't think it was capable of actual shell things (seemed more like a scripting language) until I came across the 'Shell Capabilities' chapter. Seems
197.
by SPBS 4y ago
That seems like a weird thing to put in the site footer, are they getting a lot of haters?
198.
by SPBS 4y ago
For those blocked by a paywall, Real Engineering did a video on it [ https://www.youtube.com/watch?v=jEbRVNxL44c ]. The most interesting aspects to me were: - The drone is not a quadcopter, they are too inefficient. Mini plan
199.
by SPBS 5y ago
Implicitly it means is not to model a program purely through types and how they interact with each other. In general you do start programming by defining domain types (through a combination of structs, slices and maps), but it is up to the
200.
by SPBS 5y ago
What a coincidence, everything that the author is complaining about I have an third party application to make up for - Window management (Magnet) - Command-tab (Contexts) I guess this means corporate-enforced macOS (no downloading of unappr
201.
by SPBS 5y ago
Basically functions are not abstractions, the data structures that functions act on are the real abstractions. Because the data structures have been planned out in a particular way, functions can manipulate them as if they were manipulating
202.
by SPBS 5y ago
> A big part of why I'm saying "I don't need a VPS anymore", is because I'm also saying "I don't need dynamic sites anymore". I've been building dynamic sites for two decades (once upon a time
203.
by SPBS 5y ago
Hardship makes people more resilient, yeah. I don't think it's exclusively about being an outsider.
204.
by SPBS 5y ago
> We toyed with another approach to avoiding having to track old_record by first checking to see if the `record_id` exists in the audit table, and then inserting a row with the OLD values with a `SNAPSHOT` `operation` if it does not. &gt
205.
by SPBS 5y ago
https://www.sqlite.org/json1.html#interface_overview mentions that a binary encoding of JSON was experimented with, but no significant speedup or space savings were observed. If the functions are parsing and caching JSON th
206.
by SPBS 5y ago
What kind of CSS do you need to add to <select>? Do you have an example of this modern design?
207.
by SPBS 5y ago
why was $FAMOUS_COMPANY lowercased to $Famous_company in the title? That's weird.
208.
by SPBS 5y ago
I'd like to correct myself on this point, it seems that if Postgres picks custom_plan over generic_plan it will always re-plan (that is what custom_plan is, it takes the prepared statement parameters into account while generic_plan alw
209.
by SPBS 5y ago
Use named prepared statements (the ones where you have to manually DEALLOCATE to free up resources on the server). It is to my understanding that a named prepared statement runs five times using both a custom query plan and a generic query
210.
by SPBS 5y ago
This only targets SELECT queries right? I guess there's not much to improve on for INSERT, UPDATE and DELETE queries. BTW window definitions are reusable using the WINDOW clause, there's no need to define it over and over in SELEC

More ›