HNHacker News
TopNewBestAskShowJobs

cobythedog

76 karma · joined July 14, 2017

submissionscomments
cobythedog··on SQLite Query Language: upsert
They are run together every time. You could run a check but it would probably cost as much as the update, which does nothing when a record is not found.

In PostgreSQL (for example) you could use a CTE and the RETURNING clause to prevent two statements from having to run. I don't think sqlite supports that. Current version of PostgreSQL makes that unnecessary as it has "upsert" as well.

cobythedog··on SQLite Query Language: upsert
UPDATE phonebook SET phonenumber = 704-555-1212' WHERE name = 'Alice';

INSERT INTO phonebook(name, phonenumber) VALUES ('Alice','704-555-1212') WHERE NOT EXISTS (SELECT 1 FROM phonebook WHERE name = 'Alice');

cobythedog··on Community-Owned Fiber Networks: Value Leaders in America
I'm in PDX with the same speed and rate. I have Wave Broadband. I don't think it is available everywhere - possibly only in condo and apartment buildings.
cobythedog··on Verizon Throttles Netflix Subscribers in Test It Doesn't Inform Customers About
That's very true. I can't stream one of my favorite shows, Northern Exposure, because of the music licensing. They even had to change some music in order to release the DVDs. http://actsofvolition.com/2005/03/musiclicensing/
cobythedog··on REST in Peace. Long Live GraphQL
I read that too and assumed the author was confining that to the type of development they do. Either way it comes off a ignorant and even a little rude.
cobythedog··on Employees Who Stay in Companies Longer Than Two Years Get Paid 50% Less
Come on...

""" Be civil. Don't say things you wouldn't say in a face-to-face conversation. Avoid gratuitous negativity.

When disagreeing, please reply to the argument instead of calling names. E.g. "That is idiotic; 1 + 1 is 2, not 3" can be shortened to "1 + 1 is 2, not 3." """

cobythedog··on I mean, why not tell everyone our password hashes?
Even some software do that. You can connect to a SAS server using your hashed password, which is stored in an XML config file on your computer when using EG.
← PreviousPage 2 of 2