Hacker Newsnew | past | comments | ask | show | jobs | submit | throwusawayus's commentslogin

lol regarding smart smoke detectors

firstalert acquired luma, which had acquired birdi, which was kickstarter campaign smart smoke thing, which shipped nothing to most of kickstarter backers

some m&a execs clearly did not have good vaporware detector there!!


I’d imagine it has to be a regulatory nightmare. There’s really no options on the market. First alert at this point just has the zwave one that can’t be hardwired or interconnected so it’s not to code in many locales. Nest is pretty good but it won’t work intranet only and that’s a dealbreaker for me; I do iot but it has to be gear that can cope with being on a vlan with no internet access. The only other options are sketchy brands that don’t give a fuck about us regulations. Sometimes it’s a chinese company that has some staying power like xiaomi but sometimes it’s one of those random ones that likely won’t exist in 2 years

A shame because I would really like to be notified if my house is burning down while I’m away from it. Would be pretty handy.


youtube migrated away from vitess several years ago

Mysql product is circling drain under oracles direction anymore. New 8.x “innovation” releases lack any important features. even Mariadb is out executing oracle despite being broke!

Mysql community is in bad shape too. Official slack channel is avalanche of lazy newbie questions. Official linkedin group is endless spew of “learn sql cheat sheet”

Sad. It’s done for. community may still be “enormous” but that is bad thing when its communication channels overrun by sub-bootcamp-level devs


I'll believe it when I see it. Millions of applications use MySQL, and Vitess has only matured and grown.

They said Java was done like five times. It's in the midst of another massive revival. I think the bet on MySQL is a solid one, and I think reasonable minds should be able to differ about this, so I can't bring myself to be as sure as you seem to be.

I can say this: Our app, built on Planetscale and MySQL's protocol, has been fantastic to work with. We run locally against MySQL and H2, and in prod against Planetscale. Everything works really well. Boost, replication, backups, branching, etc etc. We use all of them. Every feature works great, does exactly what it says on the tin. We have never had a single problem.

So, in theory, yes, these things are all on a timeline of some kind between life and death, but I find it very hard to believe MySQL or Vitess are near the end of theirs.


think of big features added to oracles Mysql in past two years. Thats ten releases: eight most recent 8.0.xx, and 8.1 and 8.2.

what are they? are you using any? does it really not worry you at all?


I don't really recall because I don't think our database has needed much on top of stock MySQL. Maybe JSON columns? I don't really care. Just being candid as a user; it has not worried me, no.


ok. json columns were put in eight years ago


Great sounds to me like a fine pace


Nobody cares. Millions of apps run on mysql despite your objections. Good luck with that one


innodb supports cross-schema foreign keys, there’s no limitation to tables in a single database

can be terrible in mysql 8 though due to metadata locks now extending across foreign key boundaries. this means alter in one schema can block things in other schema if foreign key across databases

speaking of, am surprised that blog post author doesnt discuss the new mysql 8 metadata locking behavior, is new major problem with mysql foreign keys!


You are right about cross schema foreign keys being supported, my mistake.


only oracle knows. and they don’t share answer yet, on this site or any other

only public news so far is extremely brief twitter mention of future switch to separate LTS releases from feature releases

big picture, hard to see what would motivate them to major re-invest in current mysql product model! amazon, planetscale, and co all profit off of oracle’s mysql server development efforts. and oracle does not get anything in return

assume this why more and more mysql dev efforts go to saas-only product like “mysql heatwave”!


why always repeatedly write the same comment about not going “all in on github” in these threads? what is goal of writing this hundred+ times?

https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...

i dislike github quite alot but this does not achieve anything. no one else is saying to go all in on github so what is this even reply to?


> why always repeatedly write the same comment about not going “all in on github” in these threads? what is goal of writing this hundred+ times?

Because I can. How many more times does a service need to go down in less than a month to deem it unacceptable for any use? Unless you think paying for downtime is acceptable?

> i dislike github quite alot but this does not achieve anything.

That is not my problem since I saw the problem years ago and chose to self-host instead. Rather than others complain to GitHub, they might as well self-host instead for reliability.

If you can setup a simple SaaS website, you can easily self-host a Gitlab / Gitea instance for 1 to 5 people. It's not that hard.

> no one else is saying to go all in on github so what is this even reply to?

So you didn't read this then?

>> We're all in on Github actions these days but there was a time when we used to maintain our own Jenkins instance. [0]

>> At this point, our self-hosted CI and code review tooling has had significantly better uptime for the past year. [1]

The schadenfreude for GitHub's unreliability and some of its fans celebrating monthly down time only makes it hilarious to watch.

[0] https://news.ycombinator.com/item?id=26302907

[1] https://news.ycombinator.com/item?id=26301740


so, because two people said they go all in on github on an hn thread TWO YEARS AGO , you feel the need to post public i-told-you-so hundreds of times ???!???

i am amazed @dang is ok with that, it seem completely deranged man, borderline harassment


I already gave the solution years ago [0] and each time GitHub goes down, hundreds of comments continue to complain when the solution is right in front of their eyes.

> i am amazed @dang is ok with that, it seem completely deranged man, borderline harassment

What harassment exactly? That whatever helpful advice I said in [0] and not 'centralizing everything to GitHub' seems to have aged well?

There is nothing 'deranged' about explaining preventative solutions like 'self-hosting' to those still using an unreliable service. In fact, it is more 'deranged' to believe that GitHub has gotten any more reliable after Microsoft acquired it.

You can continue to use GitHub's services, but don't complain when something from GitHub goes down again in less than a months time when the solution has been in front of you for years.

[0] https://news.ycombinator.com/item?id=22867803


i pointed out no one in THIS THREAD said anything about “all in on github” and you replied linking to different thread from TWO YEARS AGO. deranged!

who else posts i-told-you-so’s hundreds of times for two years shouting to void? is madness!

>> it is more 'deranged' to believe that GitHub has gotten any more reliable after Microsoft acquired it.

ok? and who in THIS THREAD is saying anything remotely like that?

>> You can continue to use GitHub's services, but don't complain when something from GitHub goes down again

i dont use githubs services, where did i say i do?

i have not conplained about github going down

who are you responding to??!?? comments makes no sense, derangement!!!


Seems like you're the one that is showing signs of 'derangement' and episodes of 'madness'. I'm just laughing at you and also at the ones that still continue to rely on a service that evidently goes down each month with the solution given to them, years ago.

> ok? and who in THIS THREAD is saying anything remotely like that?

Whatever someone said about exactly “all in on github” verbaitim is a 'minute detail' you decided to focus on to deliberately miss the forrest for the trees and to make an excuse for an argument. I also include using any of GitHub's services, which as the evidence suggests is beyond poor and comes with folks here complaining about them. Especially GitHub Actions.

So you attempting to narrow the scope to who said what verbaitim from the start is essentially missing the wider point. In fact, it is a distraction, derailing the general and entire point of GitHub's years of unreliability.

> who are you responding to??!?? comments makes no sense, derangement!!!

So far, you for showing yourself as a prime example fitting the definition of 'derangement' and to everyone else who is complaining about GitHub going down despite its track record, assuming you have read the links. There's no need for you to continue embarrassing yourself here and in your next reply, since you continue screaming and 'shouting' in caps-lock whilst attempting to put forward distractions that fails to address the main issue of GitHub's history of downtime and incidents.


you are spending time creating multi-year linked list of hn comments every single time a website you dislike and dont use goes down

i am “failing to address main issue of github’s downtime history”? indeed sure i am not addressing this, because it is not my care to address! why care when website i dont use and dont like goes down? not my problem!

do you see anyone else on entire hn creating redundant toplevel comments that then link to previous comment on same topic, spanning hundreds of comments across multiple years, all to post told-you-so to some random other commenters from 2-3 years ago? no one else do this, is deranged!


have done both. meth is a strong drug but its experience is absolutely not “profound” at all

why do you keep making comments like this about meth in this thread?

better comparison, LSD and shrooms are very profound, but in a different way than E, think like introspective -vs- social

even better comparison is 2ct7, felt like a nice balanced combination of mdma and lsd, profound but not overwhelmingly


I kept making comments because nobody answered. I now have answers thanks.


i strongly dislike planetscale and even i think this is not a useful or fair comparison .. sqlite works with local files, much simpler, no network latency, no HA


> i strongly dislike planetscale and even i think this is not a useful or fair comparison .. sqlite works with local files, much simpler, no network latency, no HA

To be fair, if you accomplish the same effect without needing distributed computing, then the solution gets much simpler, you cut out worrying about network latency and HA*

* the probability of node failure grows very rapidly with the number of nodes. Same reason you probably don't need RAID for 1 disk, but you definitely do for a dozen


At that scale any blip on the node cut out millions of users? no one sane would do that with a single box.


You can still do primary/stand-by replication.

If you actually crunch the numbers, you'll see that the likelihood of multiple node simultaneous failure of a larger cluster is actually often as high, or higher than the likelihood of a single node failure on a non-distributed application.

Despite running redundant distributed set-ups, services today really don't have particularly spectacular availability. Google, Facebook, Twitter, Github; all go down or brown out frequently.


Keep a replica.


I respect your intellectual honesty here.


why do you dislike t?


tracking access time (every read) is huge performance bottleneck. especially if reliably persisting this

same reason why filesystems are often mounted with noatime attribute !


Yes, the sensible default for this feature would be opt-out, like noatime, in case you need the performance boost and understand the implications of the choice.


This feature has zero performance impact on your database. It is powered by insights which is served from a separate data store.


I think they meant if you were to add this as a default metadata feature into mainline mysql


article title is misleading! it is about planetscale only, not mysql in general. borderline click bait

also posted by a former github person. not sure if poster is author or works at planetscale but a lot of ex github engg are there


It wouldn’t be a PlanetScale post without our biggest fan throwusawayus. Let me know if you want a hat.


maybe helps that project co creator is famous photographer https://en.m.wikipedia.org/wiki/Noah_Kalina

heard zuckerberg booked him as wedding photographer (for real)


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: