skysight-inc/HackerNews huggingface dataset:
It would be so cool if these templates were built using a static generator - especially Reactjs/Gatsbyjs.

Cutting these templates into React is hard.
Relational databases represent a column/row-oriented architecture. Data historians are a specialized, non-relational, time-oriented architecture. Using time as a key in a relational index implies that only ordering is important, but that is not the case. Distance between points in time is extremely important because time operates on a continuous 1d line and data points are represented at varying distances between each other on that line. Data historians are architected to both preserve this temporal relationship and take advantage of this by eliminating duplicate data, employing temporal compression techniques to be able to store millions of readings per second for years worth or data.

> From reading your website

My website doesn't have much to do with this because Sentenai isn't a time series database system. I did, however, spend most of my time in research working on temporal data systems, and have been fortunate to collaborate with or learn from researchers who have spent decades solving the unique problems that temporal data presents. What you might consider uncommon for your use cases is extremely common in manufacturing, defense and other areas.

There's a decades-old industry around database systems that handle time natively. And while many support SQL as a lingua franca, and some are column stores, they're not relational by any means as they either extend SQL to support time, or limit non-temporal joins to ensure performance. StreamBase, Kdb, Aurora and many other specialized architectures exist because one size does not fit all. Michael Stonebraker, whose work has included StreamBase, Vertica, Tamr, Postgres, Aurora, and many others, famously published this paper about the very problem: https://cs.brown.edu/~ugur/fits_all.pdf .

Further reading that might be illuminating:

1. http://cs.brown.edu/research/aurora/vldb03_journal.pdf
2. http://www.cs.rochester.edu/u/james/Papers/AllenFerguson-events-actions.pdf
3. https://books.google.com/books?id=BK6oCAAAQBAJ&pg=PA9&source=gbs_toc_r&cad=4#v=onepage&q&f=false (excerpt)
What problem does a college or high school solve by being for girls? What problem does a women's only fitness club solve? What problem does a women's shelter solve? A women-only train car in Japan? A women's washroom or changeroom? Etc.
I'm really curious as to why RocksDB was so slow at loading data from the Optane. An uneducated guess would be that there's some weird interactions with (f)sync () but I'd love to hear anyone else's idea as to why that might be.
Now, if only a good alternative to Reddit existed.
For the sake of clarity, the headline is currently "Dennis Hof, Dead Brothel Owner, Cruises to Victory in Nevada State Election". Prostitution is legal in Nevada. Hof has been accused of rape and sexual assault. Hof held a campaign event the night before his death with a porn actor (Ron Jeremy) and an unofficial symbol of the GOP who was found guilty of egregious racial profiling by the Department of Justice while working in law enforcement (Joe Arpaio). His opponent was a woman who is alive.

The article has some truly disturbing insight from a local professor of Political Science and has tremendous value beyond a funny headline. I am glad that the headline has been revised.
I'd say to try Harvard's CS50, and if he gets stuck to seek out a mentor or one of the online communities to help answer questions.
What you have is the ability to quickly pivot your existing toolkit to suit the needs the teams considering you need.
Ask HN: Clueless, what to do next?
Hey HN,
I am in a really tough spot. So I started a couple of startups because I love working on solving problems using products. Tried to learn the ropes of being a founder/maker and had a really hard time. I built things that never worked out. And the ones that worked out were never really products since it was me getting on a call/email and trying to get things done manually. Anyways, I accepted the reality of the situation and my short comings. I thought working somewhere and getting mentored could help me a lot. Tried finding a job, having done a bit of everything (Sales, Marketing and BD along with trying to get my product off the ground working with designers and developers) I felt like an impostor again. 2-3 months in I was mailing everyone who seemed to have a good mutual proposition. Who is Hiring, We Work Remotely and Angel List did not help at all.I was contemplating to start fresh by commitng suicide. Fortunately, I got a gig one that I loved a lot. I wanted to do everything to make sure that I excelled at it. But, I learnt that I sucked at team management and project management. Shortly after trying to getting the hang of it I was laid off without a warning(I guess I had it coming). Now I am back to the same days where I have no clue as to what to do. All of my flaws are a burden to me and here I am hoping, someone out here can probably give some advice or has been through something similar. This is obviously a throwaway account for obvious reasons. What do you think should I do?
Seems like a justification for mediocrity.

Yeah, you'll enjoy life more if you're not working 100 hours a week like Elon Musk. But I think you'll be in general better off and happier if you push yourself.

I've always worked very hard at my career and it has paid off. I get to do lots of fun things as a result. It was hard in the moment to make the sacrifices, but that's water under the bridge now. Present and future me are very happy past me spent so much effort getting better.
What features do you disagree about?

Cassandra is not a distributed relational column-oriented database, so yes, it will be bad at OLAP queries.

Cassandra is a "wide-column" or "column-family" database, which is unfortunately confusing industry jargon but better referred to as an advanced/nested key-value store. It comes from the original Dynamo whitepaper, along with similar systems like HBase, BigTable, DynamoDB, Azure Table Storage, etc. They can sometimes handle time-series queries with good data modeling because of fast prefix scans but the lack of a real query language makes them a bad choice for analytics scenarios.
> Hams are allowed to run standard 2.4GHz Wi-Fi equipment at higher power than normal people, provided that we stick to the FCC requirements (station identification in the form of our SSID, no encryption, etc.)

Are you sure about that? It doesn't sound right to me, since 2.4GHz is not a ham band. But I would be happy to be corrected!
PCI: 33 * 32 = ~1 Gbit/s

PCIe 3: 16 lanes * 8 Gtransfers/s * 128/130 (encoding) : ~126 Gbit/s

So, yes, it has changed quite a bit!

But so has everything else.

If you want performance, you still better do it through DMA transfers that bypass the CPU, because otherwise, the CPU will still be waiting for thousands of cycles to fetch data from the device on the other side of the bus.

And the transfers that are done by the CPU should be write-only to the bus as much as possible.
lots of big pharma in La Jolla
Almost All Pakistani Banks' Data Has Been Breached, and for Sale on the Dark Web
They're doing that to keep retirement plans funded way further than they should have to, but have been legally obligated to.
Join the GPL Cooperation Commitment
What is the problem with the Rust toolchain?
Why the sword?
Kdb is a priprietary db that runs using the processor level 2 cache as memory. Therefore it is crazy fast. Also therefore, it does not handle large datasets.
Thanks for this, will be sharing with my team!

The "Graph" part is where this technology is interesting. I'm sure not everyone links together all their models, but if you do things right, you essentially can let the front end pull in very interesting relationships without having to set it all up yourself. Very cool stuff.
PUT IT ON INFINITY FABRIC
Cannot strongly recommend enough "The Mind Illuminated" by John Yates.

https://www.amazon.com/Mind-Illuminated-Meditation-Integrati...

It's been discussed on HN before (it's how I found it a few years ago) and breaks down meditation in a systematic way while relating the phenomena described in Buddhist texts to current psychological principles. This "moments of consciousness model" of the mind is discussed at length and a short answer to you question is yes, different sensory moments are integrated in "binding moments".
i'm a CERT member. I use it to help local police. I use it to help manage safety at running races (marathons, 5ks etc.) I would also use it to help if called out on a search an rescue. These frequently involve multiple police departments and they can rarely talk with each other on their radios, so Hams fill in between departments.

At marathons and such the Hams are the ones with the antennas and the frequencies to get around the physical terrain and help bridge police departments.

I can also use it for communication when the cell networks go after a few hours without power (new england ice storms).

When 911 happened we had massive communication network failures and the Hams were the ones that were desperately needed by emergency crews to get messages in and out.
How to remove image from content in php
Another gallery template for startups https://www.lapa.ninja/
Timescale is an extension to add automatic partitioning to PostgreSQL to give you some scalability and performance benefits. It is nowhere near the performance potential of a real distributed column-oriented database, which are strongly consistent, have rich SQL support, and even support transactions.
If it was a sane country, he'd be in jail for all that voter suppression he's done and also this!
Ask HN: How to ace the unofficial official interview?
I am being courted (at arms length) for a technical leadership position in a small startup (~30 people). The non-technical founder CEO asked me to come to the office on Friday just to see the place and catch up, but I assume that she'll want me to meet her teams and the other founders. I feel like this is an unofficial interview, but official in the sense that if it doesn't go well there likely won't be a next meeting.

What kinds of things should I be aware of when going to their office? What things should I do/say? What should I avoid doing/saying? I'm strongly interested in this position, but it's not a do or die situation if I don't get it.
I understand. Can you give an example of a “modern distributed relational column-oriented database”?

Two capabilities that are important in my work are roll-ups (reducing resolution of data) and fast bulk deletes of old data.
> Distributed relational column-oriented databases are the best at large OLAP data volumes and queries. KDB+ is one of those, even though they call it a TSDB in marketing terminology because of its FinTech customer base.

You're mistaken about Kdb's relational features. Kdb was designed as a time series processing engine using arrays (columns). Column storage doesn't have anything to do with whether a database is relational or not, and Kdb wasn't originally any more relational than the language Erlang is.
google is you friend google clickhouse vertica etc. the comment about limited analytical power is especially fun.
Cloudflare is ingesting 11 million rows per second into CH.
yep. then i realized it’s not just google search results. that’s just most obvious case.if i click very carefully it works first click.

so my working theory is that drag sensitivity has increased. so a sloppy 1 pixel click-drag used to be a click but now it’s an imperceptible drag. i haven’t got up the motivation yet to audit a mouse event log.
Not really what I was saying at all.

Timescale adds automatic partitioning to Postgres, a single-node rowstore relational database. This will naturally give you better performance for larger data (whether time-series or not).

This will not approach the performance and scalability of a fully distributed relational column-oriented database like Clickhouse or MemSQL, because automatic partitioning is just one of many techniques they use for fast performance. There is nothing a special TSDB, or TSDB extension, can do that these database cannot already do faster, while providing rich SQL and joins.
Only if you're spamming, and not actually answering questions with a useful solution while declaring your affiliation.

Here's an example answer: https://stackoverflow.com/questions/409999/getting-the-locat...
No, I'd create and share a one time link that'd take them to a page where they could enter their CC details via stripe Checkout.js.
Yeah, true enough..
HTTP Problem Statement (1995)
Yes I can confirm data historians like PI are used heavily in my industry (manufacturing).
It reads as if he conducted a study in which he got informed consent from its participants.

As is, they were told that they'd either receive an injection with the cement or a placebo injection, and they agreed to participate under those terms.
> We are also way more sensitive about our personal information than we used to be

That's not the typical narrative. I think people share far more than they ever did before, and when asked about privacy they express much less interest than previously (though that is changing a little now): People share things on social media that were never public before; they allow corporations and government to monitor and record their activities at scales that are orders of magnitude beyond what was done before. The threat of big brother and totalitarian government used to be a widespread concern (the book 1984 being an obvious example); now that it's happening, few seem to be bothered.
We all agreed a long time ago to never talk about S voice again.
The finding highlights and perhaps provides somewhat of a meaningful answer to philosophical arguments around what we perceive to be reality around us in fact being very much an illusion of continuity. The fact that we so readily trick ourselves into believing, and only through intense mindfulness/introspection are we able to contradict that sense of internal consistency, is quite profound in my opinion.
I used to do this but now I just review my git history
Big investors sue banks in U.S. over currency market rigging
How to Bypass iCloud Activation Lock on iPhone XS/XS Max/XR/X/8
There's a great future in plastics. Think about it.
Intro to Vectors in Python – Linear Algebra Part 1
One concept I appreciate: you can bridge two common skills together in a way such that you are uniquely qualified to practice this combination of skills and you have zero (or near-zero) competition.
Sure they can handle them, just not in an economically viable fashion.
Step by step process to start a successful business
They can't handle high cardinality. Imagine having millions of columns in the column-oriented database (70% of those columns are updated every second). Imagine that you have to add new columns all the time.

The main misconception about TSDB's is that it's just a data with timestamp. TSDB's has multi-dimentional data model, time is only one of the dimensions.
Homeopathic products cannot make claims about treating or curing diseases.
Yes, the NY Times changed the headline (though evidence of it is still in the URL)
I agree! Vertica's temporal capabilities are marvelous and the engineers who worked on the planner optimizations for the time extensions are brilliant.

There are of course trade-offs to the approach Vertica takes -- look at StreamBase for a very different take on the problem, another Stonebraker project.

Any of course historians represent yet another take, optimized for point-in time queries that are native and don't need the processing extensions Vertica uses.
How do you know what 40 ms feels like as opposed to say 60?
Happens to me too all the time. I've noticed it usually happens when I click near the bottom of the link. But it may just be the drag sensitivity. Highly annoying.
It made sense when I got to this part...

His election means that county commissioners from his district will pick a replacement, who must be a Republican and live there. That will most likely play out in the coming weeks after the election results are confirmed on Friday, said Arnold Knightly, a spokesman for Nye County, the main county in Mr. Hof’s district.
Is Elon Musk not "semi-rad"? He's seems to have a wide breadth of knowledge in multiple fields (engineering, business). He's not the best at anything other than being himself, which I think is the point.
To everyone citing transitions and Mac & iPhone, I meant two architectures for the same product, not as stop gap, but fully supported going forward.

And it’s not that the can’t techically, it’s that they are all about focus and unambiguous messages to developers and costumers.

But after reading it all, I guess they could fork the Mac into two categories. Air, light or whatever, and Pro.

I actually like that idea a lot.
How appropriate, pots are legal now.
I think Clickhouse would do well but I've seen other metrics/observability vendors (like Honeycomb) also build their own systems given the scale and cost factors.

Isn't Datadog on AWS? If you have very specific needs and can build a vertical infrastructure stack then it makes perfect sense to build your own.
TLDR: "Why Not to Build a Time-Series Database? Because we're building one and you should pay us."

> Hopefully our story will make you think twice before trying to build your own TSDB in house using open-source solutions, or if you’re really crazy, building a TSDB from scratch. Building and maintaining a TSDB is a full time job, and we have dedicated expert engineers who are constantly improving and maintaing our TSDB, and no doubt will iterate the architecture again over time as we hit an even higher magnitude of scale down the line.

> Given our experience in this complex space, I would sincerely recommend you don’t try and do this at home, and if you have the money you should definitely outsource this to the experts who do this as a full time job, whether its Outlyer or another managed TSDB solution out there. As so many things turn out in computing, it’s harder than it looks!
You appear quite desperate and perhaps this desperation is coming through to the people you talk to and the interviews you do. As a hiring manager I can tell you, desperation is a massive turn-off and red flag.

Change your resume as the others have directed you and keep applying. Perhaps take a look at remote work options as well. But you need to dial back the desperation.
Surveyforcustomers
well, you have written a masterpiece and i must appreciate the work you are doing. You are spreading this type of information which is very much valuable for the people. Much Appreciated. Keep posting this type of information.
https://surveyforcustomers.com
Clickhouse, MemSQL, Redshift, MapD, Kinetica, etc.

If you just want rollups and don't care about every row, then look at Druid (or imply.io for a startup making it easier).

All these systems can delete old data very quick as they just delete entire compressed partition files.
Dutch man, 69, brings lawsuit to lower his age 20 years
October Startup Funding: IoT, Security, Auto
Samsung One UI
The amateur radio community emphasizes logging all contacts. It builds a habit, especially since a lot of community interaction is around (friendly) competitions of who can make the most distant contacts, etc. All informal, but it teaches the habit through cultural acclimation.
I agree that it makes sense in the abstract that ostensibly private organizations conduct themselves as they see fit. But in the U.S. the practical reality is that the Democratic and Republican Parties are effectively official institutions. If voters' only input was to choose between two people secretly selected by these organizations, it wouldn't be very democratic. And imagine that happening in the many U.S. voting districts where the same party always wins - it would be completely undemocratic.

On the other hand, IIRC my history, before maybe the 1970s the U.S. parties did use more private processes, selecting candidates in the 'smoke-filled room' (the image is of fat old men smoking cigars and making deals). Some say the quality of candidate was better then.
Long Island City wonders how Amazon would fit
Windows 10 gets a $20 Linux distro option
Another thing to remember about the 'old days' (80's and earlier) is that in addition to there being no public Internet for (most) people to hook into[1], was the expense of actually using the phone. Except for local calls (pretty much people in/near your city), everything was metered: we had zone calls where calling someone more than ~5-10 miles away incurred per-minute costs (iirc, $0.10-0.20/min), long distance calls (>30-50 miles) were more expensive (iirc, $0.30-0.50/min), and international (esp. overseas) calls were insane (you would typically try to keep conversations very short as the costs would start at $1-2/minute.)

So amateur radio was a very cost effective way to communicate with like-minded people with very rapid payback. That said, a lot of people just liked chatting with strangers from far away places.

[1] There were commercial services and BBS's but they were also relatively niche until the late 80's largely due to the actual cost of the phone call as described above.
Yeah, I own it. "Binding moments" is why I asked that question :-).

I'm partly wondering if peoples' experience matches the book's description, and partly looking for more detail about what the actual experience is like than the book provides.

Would second the recommendation though: it's a great book.
Disagree. I have many family members who I cannot convinvce to go to a doctor, for thay are terrified of financial ruin. Literally will not go near a healthcare facility.

Then there are the family and acquaintances who go to the hospital Emergency Room, because although they have no insurance, an Emergency facility is generally required to treat them.

On one hand, we have people who do not receive routine care, who only seek healthcare long after a point where early diagnosis or treatment would have been inexpensive.

On the other hand, we have people who use a military-grade triage center for flu symptoms.

Both situations are ruinously expensive. And continue to contribute to trillion-dollar government-budget shortfalls. To say nothing of the inevitable, preventable zombie apocalypse.
An officer probably wouldn't have bothered to make the stop

If I had a dollar for every DUI story I've heard that involved getting pulled over "a block from home" after rolling through a stop sign..

I don't necessarily disagree with your point but I've seen and been on the receiving end of what could only described as "bored cop"
I disabled Bixby and Facebook, my phone is flying, battery is amazing . Check out the ADB shell commands to uninstall/hide packages. Seriously, the phone didn't last more than 8 hours, now passed 14 hours and I will have 42 battery.
Common mistakes people make while choosing a mobile phone repairer
I'm talking about how ARM got their first on the process and now AMD has a chance to fab using that as well. AMD got out of the fabrication game, they couldn't keep up, which means they can use specialists like TSMC which are killing it now.

Intel's largely "secret sauce" process has been their greatest asset. Now it looks like a huge liability.
> the personally identifying information is what used to be available in the phone book

I think on HN we know well that changes in technology greatly affect the value and power of information.
Because it disregards common sense in favor of mindlessly adhering to the law simply for the sake of doing so, without any thought about context or why the law exists in the first place.

Assuming the OP is correct, and he could actually see there were no cars, pedestrians, or cyclists nearby.
Not using silicon they won't but other materials might make that possible. I doubt TSMC will sit on the sidelines as those become more mainstream.