As far as I can tell, as of
3/28/18, the author of the TechCrunch article:
- Did not cite the original article published for years ago on blog.bolt.io.
- Works at the same company (Bolt Venture Capital) as the author of the original article.
- Copied the headline of the original article.
I suspect that had I turned in such an article back in school, I would have been in a world of hurt.
MySQL has an interesting issue - I call it a problem, I think MySQL calls it documented and expected behavior - where if you attempt to insert a row into a table (InnoDB) and the insertion fails due to a constraint violation, it will still increment the auto-increment counter.
The solution, annoying as it is, is to basically do a check while inserting to not even attempt the insert if that particular constraint (or, really, any other constraint you decide) would fail.
Let's say I have a table of "seen devices." Let's say each device checks in once in a while, but I want to poll the list of active devices far more frequently. I don't want to insert entries for devices showing up present if an identical entry (ID and last-seen timestamp) is already present. (Actually, for safety, let's say that if an entry with the same ID and a greater-than-or-equal-to last-seen timestamp is present.) The code (using prepared statements) looks something like this:
123456 | INSERT INTO devs_alive (dev_id, last_seen)
SELECT * FROM (SELECT ?, ?) AS tmp
WHERE NOT EXISTS (
SELECT entry_id FROM devs_alive
WHERE dev_id = ? AND last_seen >= ?
) LIMIT 1;
|
And since we're using prepared statements, you obviously have to bind the parameters, which might look something like:
1234 | $stmt = $conn->prepare($query);
$stmt->bind_param('iiii', $dev_id, $last_seen, $dev_id, $last_seen);
$stmt->execute();
$stmt->close();
|
Or
123 | $stmt = $conn->prepare($query);
$rows = $stmt->execute($dev_id, $last_seen, $dev_id, $last_seen);
$stmt->finish;
|
Recently, my vacuum-actuator for the supercharger's bypass valve stopped working (stopped holding vacuum, basically), resulting in the SC never being properly bypassed.
I have the 5th gen (intercooled) MP112 Magnuson supercharger on my LS1 engine (and I imagine, for the sake of SEO, that it's the same setup that goes onto the LS6 and other LS engines, among others.)
The resulting rattle and other issues were annoying - if you have an MP112 and you start hearing a metallic rattle at idle, observe whether the bypass actuator's metal ... hook-pole thing ... that pulls down the bypass valve is the thing that's rattling against said bypass valve.
You can also easily tell if it's not working by opening the hood while idling. With the throttle plate nearly closed, the engine should be pulling a high vacuum, and this should be pulling the actuator down, so that the SC is in bypass mode. If it doesn't immediately pull down when the engine is started, get a new actuator.
Their website is pretty hard to follow, but apparently the right part number is 45-00-13-113, and on their (fairly poorly formatted) website, it is listed as the actuator for the 4th gen. Well, they confirmed it was the right component for my car, sent it over (at a cost of about $150 with taxes and shipping) and it fits fine and solves the issue.
I found the following three links very useful when figuring out wheel sizes and tire profiles:
While bolt patterns specify which tires can bolt up to your wheel hub, there's a lot more to it - after the jump: