HN user

wkrp

27 karma
Posts1
Comments23
View on HN

In my (minor) experience Timescale works fine. The developer experience is good and it is very convenient to be able to JOIN against your hypertables. My only real complaints are operational (no logical replication, normal postgres update complaints), but man Clickhouse is really slick. I wrote some small reviews of the two in my submission history if you want a bit more detail.

DARPA’s new X-76 5 months ago

Modern tactics are to use every radar around via datalink (AWACS, Ground Station, stealthy drones flying ahead). The onboard radar is last resort, but still very capable.

There are tools such as deploy-rs, colmena, and morph that let you deploy nixOs configs using nix. I can't speak to how good they are personally, I use ansible to push my nix configs.

I wrote a blog post about my experience using Clickhouse on a side project. You normally see discussions of Clickhouse involving large data sets and complex problems. I previously used Timescale to store the same data, so this also covers a comparison of the development experience between the two.

I was a little unclear, I think Timescale performs quite well. Just that in my (very limited) experience, Clickhouse performs better on the same data.

I actually have a blogpost on my experience with it here: https://www.wkrp.xyz/a-small-time-review-of-timescaledb/ that goes into a bit more detail as to my use case and issues I experienced. I'm actually half-way through writing the follow up using Clickhouse.

As detailed in the blog post, my data is all MMO video game stats such as item drops. With Timescale, I was able to join an "items" table with information such as the item name and image url in the same query as the "item_drops" table. This way the data includes everything needed for presentation. To accomplish the same in clickhouse, I create an "items" table and an "items_dict" dictionary (https://clickhouse.com/docs/sql-reference/dictionaries) that contains the same data. The Clickhouse query then JOINs the item_dict against item_drops to achieve the same thing.

If you know the shape of your data, you can probably whip up some quick scripts for generating fake versions and inserting into Timescale to get a feel for storage and query performance.

I was using Timescale for a small project of mine and eventually switched to Clickhouse. While there was a 2-4x disk space reduction, the major benefits have operational (updates & backups). The documentation is much better since Timescale's mixes their cloud product documentation in, really muddying the water.

Despite that, man it is really nice to be able to join your non-timeseries data in your queries (perhaps the fdw will allow this for clickhouse? I need to look into that). If you don't have to deal with the operations side too much and performance isn't a problem, Timescale is really nice.

I don't have any examples from my code, so the best I can do is the relevant documentation.

Its all done using phx-hook https://hexdocs.pm/phoenix_live_view/js-interop.html#client-... . While the documentation makes it look a bit more fancy, it is just a JS object with mounted() function. I set up my columnDefs and gridOptions in that function, and add the handleEvent() callbacks that are where I get data from the elixir side using send_update/3. Ag-grids vanilla JS documentation has been very helpful for how to use it without the benefit of react/vue,

LiveView is so nice for full stack development, it's a wonderful palette cleanser after a day of enterprise programming.

I can attest to its JS interoperability. I have a project that streams data realtime into a liveview page that uses a combination of ag-grid, maplibre-gl, vega+lite, and Google's model-viewer all at once. All it takes is a little bit of JS plumbing to handle create and updates.

Well for one, the Army would have to start worrying about bases with full landing strips, pilot training, the bureaucracy and command structure that would be required to run the squadrons. They would need mechanics that know how to repair them, people that know how to arm and refuel them.

You end up doing a good amount of work just to try and protect a very expensive plane from Air Force politics. Ideally, the Air Force would just settle on an inexpensive prop plane that could perform the same missions as the A-10 at much less of the cost.

I'm not knowledgeable on how effective a helicopter is for CAS.

Half-Life: Alyx 7 years ago

I think he means that if you dont have a VR ready graphics card, that costs another $200.

I'm also a mostly backend dev (C#) and Vue didn't take too long to get started. Outside of getting node/yarn set up on my machine, I was able to create a project and start fiddling with Vue pretty quickly.

I found https://www.taniarascia.com/getting-started-with-vue/ as a better initial starting point compared to the Vue website.

I've been using Vue for the past few weeks on a for-fun project and have been loving it once I grasped the basic concepts.