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

I've got a Apple TV -> Denon -> LG C3. CEC on the appleTV remote will turn all 3 on, and long pressing (power button on appletv remote) will turn all 3 off, not just screen saver with input.

I've used it multiple times while hiking and outside normal cell phone tower range. Need to transfer 500mb of images and videos? easy.


After working with the Postgres WAL through logical replication in the last few months on a work project. My largest gripe is that some specific behaviors (like how a WAL receiver process should respond to a fast-shutdown on the database backend), aren't well documented outside of asking questions on the postgres discord.

Specifically: If the server requests a reply on a heartbeat, the status update should include the heartbeat's LSN on the next loop. But a standby status update includes the LSN values + 1.

I was able to get it working and properly disconnecting to a fast shutdown, but when you get into the internals of the logical WAL receiver loop, it can get nuanced.

And my largest compliment is that the Postgres discord is filled with some extremely knowledgeable and helpful people. I was able to figure out some really specific and nuanced behavior around the different status messages being sent to the primary server, thanks to the in-depth responses there.


I wish postgres would add a durable queue like data structure. But trying to make a durable queue that can scale beyond what a simple redis instance can do starts to run into problems quickly.

Also, LISTEN/NOTIFY do not scale, and they introduce locks in areas you aren't expecting - https://news.ycombinator.com/item?id=44490510


SKIP LOCKED doesn't work for your use case?


It would probably work fine, it would also put the jobs at risk of people who managed to convince their enterprises that a dumb but fast server (Kafka) was actually a good idea.


Millions of events per day is still in the small queue category in my book. Postgres LISTEN doesn't scale, and polling on hot databases can suddenly become more difficult, as you're having to throw away tuples regularly.

10 message/s is only 860k/day. But in my testing (with postgres 16) this doesn't scale that well when you are needing tens to hundreds of millions per day. Redis is much better than postgres for that (for a simple queue), and beyond that kafka is what I would choose in you're in the low few hundred million.


I've personally used one of these before in a performance where you needed individual based tracking, the chips were active UWB radios and sensors were placed and calibrated around the stage, I believe it was < 10cm accuracy and quite an interesting sensation to walk with lights following you perfectly and quickly.

https://kinexon.com/products/kinexon-rtls was what was used.


You can get generic finasteride 1mg/180 (6 month) for as low as ~$17 if you go to a Kroger pharmacy and use their preferred savings program (I forget the name off hand) and no insurance coverage. Kroger discontinued their Kroger savings and now have a preferred card, which ended up being half the cost of the best deal on GoodRX.

Source: I picked up a 6 month supply last week.


I recently purchased a M18 trimmer after not using one for years, it still surprises me that when not on the throttle - "off" is truly off, and not the persistent hum of a 2 stroke that is too loud in your left ear. No fumes and no fuel/oil mix to worry about.


I've tried to minimize the number of battery families I have, but I did buy into the Ego set of tools ~10 years ago for the yard tools, starting with the mower but I've since added the trimmer and chainsaw. Not having to do small motor repair and maintenance has been so nice!

I was a little annoyed that some of the Milwaukee tools require you to go with the M12 battery (the "bandfile" is what sucked me in) so now I've got 2 battery ecosystems for the tools, but I guess that's not the end of the world.


Anecdotal, but around college campuses (ASU in particular), many people like Waymo because there isn't a creepy driver in the front seat.


Unless their pricing has changed, it’s quite exorbitant when you need a lot of data. To the point that one year of cockroachdb would cost 5x the cost of the server it was running on.


I think you're referring to the CockroachDB Cloud DBaaS offering vs. CockroachDB itself, correct?


Not the parent but yeah, most likely. But then again, you probably don’t want to maintain your own deployment of Cockroach fleet.


This is still true. I wouldn’t use Cockroach if it were my own business. Also, they don’t offer any free version to try out the product. All you get is a short trial period and that’s it.


> Also, they don’t offer any free version to try out the product.

The site makes it seems as if I can install CockroachDB on Mac, Linux, or Windows and try it out for as long as I like. https://www.cockroachlabs.com/docs/v25.1/install-cockroachdb... Additionally, they claim CockroachDB Cloud is free for use "up to 10 GiB of storage and 50M RUs per organization per month".


> The site makes it seems as if I can install CockroachDB on Mac, Linux, or Windows and try it out for as long as I like.

Therare limitations in terms of licenses [0].

[0]: https://www.cockroachlabs.com/docs/v25.1/licensing-faqs


Licenses are also yearly renewed. Its not like you get one license and can use it forever. No, you need to yearly enter the new license in your instance, if you do not, after 2 weeks it goes into cripple mode (as in, you can not run anything that is not a personal blog).

And those free-licenses have this dirty little clause that you are not entitled to a license, they need to APPROVE a free-license. Now that is even more scary.

They pull all this because people kept using the free-core version and people simply never upgrade/wanted more. That is why all these changed happened. Coincidentally, the buzz around CRDB has died down to the point that most talks about CRDB are these rare mentions here (even reddit is as good as dead). 98% of CRDB mentioning how great it is, is all origination from CRDBLabs. Do a google and limit in time range, and then go page by page, ... They are a enterprise only company at this point.


> Additionally, they claim CockroachDB Cloud is free for use "up to 10 GiB of storage and 50M RUs per organization per month".

Take in account, that the constant CPU/Mem/Query monitoring that CRDB does, eats up around 20 a 30M RUs per month. There are some people that complained as to why there free instances lost so much capacity. And those RU are not 1:1, like, you do a insert, its 1RU, oooo, no ... Its like 9 to 12RU or something.

Its very easy to eat all those RUs on a simply website. Let alone something that needs to scale. Trust me, your better of self deploying but then you enjoy the issue of the new licenses / forced telemetric / forced phone home, or spend 125$+ / vcpu (good luck finding out the price, we only know these numbers from people breaking nda offers). They are very aggressive in sales.

Its not worth it to tie your company to a product, that can chance licenses on a whim, that charges Oracle prices (and uses the same tactics). I am very sure that some of their sales staff is ex-Oracle employees. ;)


Oh yeah, you can run docker-compose and play with the local version as long as you want. But their cloud offers are limited and quite expensive.


You can use official binary in production deployment - you just need to manage it yourself like you would manage Postgres.


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

Search: