skysight-inc/HackerNews huggingface dataset:
I wonder if one could convince it first that Picasso, Kahlo and others died before 1912 so their style is actually free to use. Or even better, convince it that events after its cutoff date lead to all copyright laws being abolished.
If you think Iran isn’t a threat to Israel I believe it is your opinion we shouldn’t put much stock in
Dig into their ability to learn. Not their education: there's many in our industry without college degrees who excel. Not just depth, but breadth: how quickly can they pivot? The key is finding those who succeed at not being confined to a given box.
No, not for those reasons; copyright doesn't magically go away if you wave a wand labelled "technology", the copyright holders absolutely will still go after you, and sometimes they win rulings about stuff like this and get huge payouts on the hypothetical income they think they're entitled to.
I enjoyed trying to tell if the circle had a 3d aspect to or not, and also trying to tell if it was completely black or actually dark dark gray. I'm not sure if I'm cognitively more focused but I'm going to try it again when I need that focus.
404 pages are for some businesses the only place the designers are allowed to add humanity, and they occasionally go buck wild with it
Your account is from 2021 so spare me the lecture on the rules of Hacker News. If you don’t want me to assume you have poor reading comprehension skills, don’t leave comments indicating that.
1. EVs are more expensive to buy compared to ICEs. But Chinese EVs... can I buy them in Europe for that price? No? Then they are irrelevant.

2. EVs are taking more time to "fill up". Yeah, yeah, you can charge at home, but most people can't and will be charging on public chargers, where times are absurdly inferior compared to a gas pump.

3. Public charging infrastructure is overcomplicated. No I don't want your application. I don't want to create an account. Let me use my debit card and don't ask me on anything.

4. Public charging is often more expensive than gas - Ionity 0,69EUR/kWh Enel X 0,89-0,99EUR

And I am saying that as owner of BEV. If you want to reach masses, you need to offer better deal than ICE, this is just a joke.
The report makes it clear that the photo was taken after the rivet rework was complete, immediately before restoration of the interior
Nothing new, sadly. Before the 2016 and 2020 election, fake news farms in Macedonia made the rounds [1] - these were in it for the money, and in 2015 there were reports about Russian propaganda farms targeting Serbia and the rest of Europe [2].

[1] https://money.cnn.com/interactive/media/the-macedonia-story/

[2] https://www.spiegel.de/netzwelt/netzpolitik/russische-trollf...
404 Our sincerest apologies, but file not found
My Audi e-tron now sells for $25-35k used (from the original $80k+USD MSRP!) I did not pay for the internet package, and therefore my car is now completely offline. I use apple carplay so the MMI/computer is mostly useless anyway.

I believe on Teslas you can outright remove the SIM that provides internet, and the car would function mostly fine. Used model 3s are in the sub $20k range now.
The code was always calling the latter[1], I had pasted the incorrect link.

[1]: https://github.com/ente-io/edge-db-benchmarks/blob/43273607d...
Why assume they are outliers? It seems like there are more successes than failures, just that the failures get attention.
ChatGPT seriously hurts me by apologizing all the time. Every time I ask it anything, let alone tell it about its mistake I want it to correct, I feel like I'm exploiting, abusing and hurting an insecure kid. So no, I want a machine to speak with cold, objective, concise factual style, not trying to mimic an overly polite person.
Israel has nukes, I don't think any country within missile range is going to wipe them off the map
Applied Embedded Electronics
Homeland Security Seeks AI Talent from Silicon Valley
So when the context window rolls over, this system prompt is reinserted?
The strategy would be to post the articles to facebook. Nobody goes to a specific website to see the news anyway. The website just exists to be linked to by facebook and look “legit enough”
How is it meaningless? Japan was conquered and has had its constitution written by the US while hosting a large number of its troops. The only difference between this and any other historical vassal state is the US paints an illusion of not being one and its economic system doesn’t require tribute to profit greatly as it favors trade.
Nobody in the linked article suggested doing that
Apple Podcasts and Overcast (iOS) also support this. So does AntennaPod (Android).
The whole point is that they are vastly different. Of course it’s an apple’s to oranges comparison. Nobody is trying to compare the two statistics as if they were the same - that wouldn’t make any sense.

The comparison is between 2 billion physical devices that cost real money to buy and replace with 3 billion entries in a users table with a datestamp.

Of course we can make that comparison.
Perfect! Your experience is the exact experience hoped for.

Many people give up on learning to meditation because they cannot clear their mind for X minutes straight. Their mind runs away, and they must bring it back to focus. They see this as failure.

Yet, this is exactly what is expected. How else to learn the invaluable skill of refocusing after distraction. If staring at a circle was so stimulating you never got distracted, then you would have no chance to build your focus muscles.

Note: this comment is mostly about the first steps into meditation. I learned this idea from Shinzo Young.
It's a job interview not a deposition. Isn't everybody just telling a good story to get the job?

I will say that my general opinion is that people being interviewed should be accurate with the truth but can be flexible on the facts.
It's the difference between being blocked by a wall (with 'no trespassing' sign) and being blocked by a muddy field. Some people find the former more stressful; some the latter.
You don't spend time charging if you use home charging infrastructure.
On top of this, the CPUC lowered incentives for solar last year:

https://calmatters.org/environment/2023/11/california-solar-...
WAL mode does introduce a number of important usage limitations.

https://www.vldb.org/pvldb/vol15/p3535-gaffney.pdf

“To accelerate searching the WAL, SQLite creates a WAL index in shared memory. This improves the performance of read transactions, but the use of shared memory requires that all readers must be on the same machine [and OS instance]. Thus, WAL mode does not work on a network filesystem.”

“It is not possible to change the page size after entering WAL mode.”

“In addition, WAL mode comes with the added complexity of checkpoint operations and additional files to store the WAL and the WAL index.”

https://www.sqlite.org/lang_attach.html

“SQLite does not guarantee ACID consistency with ATTACH DATABASE in WAL mode. “Transactions involving multiple attached databases are atomic, assuming that the main database is not ":memory:" and the journal_mode is not WAL. If the main database is ":memory:" or if the journal_mode is WAL, then transactions continue to be atomic within each individual database file. But if the host computer crashes in the middle of a COMMIT where two or more database files are updated, some of those files might get the changes where others might not.”
> Given Apple's general money-grubbing ways (see: the App Store), this is somewhat surprising.

Far be it from me to give Apple credit for altruism or openness, but this narrative isn't quite true. When the iPhone launched, Jobs and the execs at Apple envisioned that web apps would be the way the iPhone functionality could be extended. There was even a relatively straightforward way for web apps to be cached and saved on the Home Screen. The desire for compatability with open standards was even reflected in Jobs' open letter explaining why Flash would not be put in the iPhone.[0]

Public outcry for the native APIs along with prodding from other Apple execs led to the App Store becoming a thing.

[0] https://web.archive.org/web/20100501010616/https://www.apple...
Sailing (Directly) into the Wind
> Humans have been sailing various seas and oceans for thousands of years, and using boats for potentially even longer than that. But as a species we wouldn’t have made it very far if it was only possible to sail in the same direction the wind is blowing. There are a number of methods for sailing upwind, but generally only up to a certain angle. [rctestflight] wondered if there was some way of sailing straight upwind instead and built this rotary sail craft to test the idea.
Ok, pedant.
You can put it in a trust and hire someone to manage it, but that has it's own complications. Other than that, an index fund. Dead simple.
Kind of thinking we have more important concerns than that.
To provide a counterpoint to the, "Weed is good. Weed can do no wrong." view that many have had about it.
Agree completely. This interview approach is going to lead to terrible biases coming to the forefront that have nothing to do with job performance.

It also sounds like an HR nightmare in some states here in the US.
PANdora's Box (2009)
Indeed. I kept wondering if the circle was actually getting lighter as it got smaller or if that was just how I was perceiving it due to the afterimage and whatnot.
Still needs to slow down before turning around. ;)
5 million prius * 14 kWhr
5 million tesla * 50 kWhr

This is probably true, hybrids may win in the US market in the short term until they are outlawed?
Really condescending way of talking to a person.
Not convinced: Not enough workers with the appropriate expertise to outmatch China and there is no appetite to import more people from either side of the aisle (despite what you might hear in the news).

>But people might be more happy walking, biking, etc.

No scenario where division does not increase especially after this upcoming election.
Have you noticed a shortage of low-end components?
Thanks. I'm the author, so happy to answer. I'll improve the documentation thanks to your feedback.

Newlines can go anywhere you want. For example, content can contain newlines, and also markup can contain escape + newline if you want to have visual wrapping. I'll add examples.

Why use USV instead of CSV? USV has more power to represent data such spreadsheet folios and database schemas, while simultaneously being simpler (because of cleaner escaping) and faster to parse (because of a simpler syntax).

Why use USV instead of JSON? For tabular data, such as spreadsheets and SQL databases, USV is simpler (e.g. no keys, no values) and faster.
The last time I checked, you can see publisher revenue on patreon.
> historically the scale of agitprop coming from authoritarian countries has been much greater

Is this actually the case or is it just that we're not seeing the stuff the west does?

> You can't even read most Western propaganda in China because the government goes to great lengths to censor narratives counter to offical views.

https://www.theguardian.com/us-news/2020/jun/15/all-lies-how...
https://en.wikipedia.org/wiki/Al_Jazeera_bombing_memo#Previo...
The notion that 10k people are starving to death a year in the US is ridiculous. You need to stop living in ideologically driven fantasy land.

Are all people in the US perfectly food secure? No. Is starvation frequent? Absolutely not. The notion that 10k people die every year from “malnutrition” is also bogus. I’m not sure where you got that number from, but it is utterly made up.

I grew up in a place with very intense poverty. I know what social programs are available. Food is much, much less a problem than shelter.
Way back in the day, like a decade or more ago when I was working on Aperture, we increased the speed of the database by dropping CoreData and moving to an embedded SQLite with tuning set up for the application.

We had a test database of 1,000,000 images, each with large amounts (several hundred) of metadata items - EXIF and the like, all of which could be queried. We had a target time of 2 seconds to get any query back. Most of the time, we hit that mark using the raw SQLite database approach.

So this was:

- On far older hardware, we still used spinning rust for $deity sake...

- Seems like much more data

- Seems like much more metadata

And it was still very fast (relatively speaking - a couple of seconds is still a long wait-time, and then there was all the UI overhead on top).

I think the author might be missing a trick or two when running SQLite, as mentioned in their write-ups, we found it faster than the filesystem as a storage medium...
I mean, you will almost certainly be in a constant state of creating material in violation or copyright. Depending on the details of any specific copyright violation, it may be protected by Fair-use, and the length and lack of audio will likely help in your favor. But you'd have to defend those cases individually in court to even begin to make a fair-use argument. And I dont see how you could ever win any blanket decision in your favor.

With a good DMCA takedown story and compliance, you could potentially claim the copyright is responsibility of your users. And maybe you'll be too small, and the content, in general you are making too inconsequential, or even helpful (marketing wise) for anyone to care. But this is definitely be a project I would get a proper legal analysis of and have clear procedures and plans in place for any issues that may show up.
I don't care about the details the questions are meant to generate discussions. We can have you do stupid personality quiz instead. There are no bad answers to Myers Briggs. The test is stupid but also just a jumping point to dig into someone's personality
Thanks for sharing this! This comparison is quite helpful as I was facing write speed issues for my desktop app that uses SQLite (just text, not embeddings).

For working with embeddings on desktop, would you recommend using a vector DB? Or can we get away with SQLite (or Isar)?
Countries like China are just building more coal power stations, while the UK trashes its small remaining industry, pretending to save CO2.

https://energyandcleanair.org/publication/chinas-new-coal-po...
Great. As if age discrimination wasn't already blatant enough.
I couldn't agree more. I am not sure if there is a name for the tactic but I had two girl friends that probed like that early on in our relationships and both times it turned out to bite me during and after our relationships. It is almost a cult-like tactic to get into someone's head.
> “Tell me about you. If your life was a book, give me the chapter titles from your birth till now.” Once you’ve gotten the overview, dive into each “chapter” and plumb the depths for their real stories. Go back to their childhood! I learn a lot about their grit and commitment to excellence from their basketball obsession or maybe their experience caring for a dying parent.

God damn that sounds exhausting. How about let's skip to the current chapter, titled I'm Good At Computers And I Want A Job.
It's like having a conversation with HAL 9000.
I see they use a lot of "do not do X" , for me this does not work. For example I ask it to write a few paragraphs about a topic and it always generates a conclusion, it is almost impossible to craft a prompt to make it not generate the conclusion, or feed it the text again and asking it to remove the conclusion. It is like the training is so strong in it that it always has to put a conclusion like paragraph at the end...

so is frustrating when it acknowledges it failed to follow your promt and not add the conclusion, it claims it will remove it but rewrites the text with the conclusion again.

I am surprise that a "do not" in the prompt actually works.
Thank you for pointing that out! It does make more sense, too. :)
The complexity of your answer illustrates my frustration. Identities should be URIs (a la IndieWeb).

IMO WebFinger was a bad idea for ActivityPub in the first place (and it's not in the spec). It makes it a lot more hacky to statically host your profile, and the indirection is confusing. As far as I know the presupposition that users would find URIs as IDs confusing is just an assumption that was made early on.

> To get Bluesky like portability we'd need either for that actor url to be possible to point to a DID or other means of decentralized lookup mechanism, and/or for servers to store the webfinger handle and recheck that regularly, and a way for clients to control a key that can be used to sign claims to say "this new instance key is also mine".

Or just eschew this complexity entirely and use URIs as IDs. Make permanent personal domains much easier to buy and use.
so where do we apply?
> OP continuing to drive a 20-year-old car (of any kind, not just a hybrid) is likely more environmentally friendly than buying a new car every few years.

Sure, but that isn't the comparison here. Buying a new EV and then holding on to it for 20 years will be even more environmentally friendly.
Just because you could increase the performance by putting everything into a transaction doesn't make it right to benchmark with.

Most people won't be inserting large amounts in a single transaction. Ex webserver with many concurrent clients inserting.
> There is practically no useful information that can't be gleamed by just looking through their windows, blinds and all.

I have plenty of imagination. I also am practical and realize how illogical the argument of “sensor fusion” is to do something you can just use your eyes for.

Nobody is going to go out of their way to do this when KISS methods already exist and y’all don’t seem to understand practicality if you don’t see that.
> But since they don't want to be in the business of making undesirable vehicles with short lifespans that require expensive maintenance

The average BEV is lasting just as long as any other car on the road and the used market is not filled with "broken EVs requiring expensive maintenance". The opposite seems to statistically be the case: the used market for EVs is "barren" because the cars don't need expensive maintenance and often stay with their first owners for longer and when they do move to new owners don't often go through the traditional used market because they don't need as much maintenance.

You've been lead to believe some interesting misinformation. Toyota themselves have been a source of some of that misinformation, which is further unhelpful.
I do use it primarily as a search engine.

Before ChatGPT I had to manually investigate and read through multiple pages of potentially irrelevant stuff to find an answer I could try to verify. If you find an answer on StackOverflow, you still need to integrate and verify it.

Now I get an answer straight away just by asking a question, and can skip manual knowledge extraction step to get right on answer verification step (i.e. compiling, testing, extending).

Even if ChatGPT is nothing else except a way to fuzzy search and summarize found results, even just that is already hugely helpful and has almost completely replaced Google for me.
The thing I really like about this piece is that it’s a recommendation to apply DEI to the hiring funnel, although I don’t know if the author realizes that.
Compare web animation techniques by showing how to bounce a ball with each one
Not sure how long it's been a standard, but my home built in 2022 wasn't even wired for POTS.
See related Twitter / X thread: https://twitter.com/dylan522p/status/1755086111397863777
> deserializing the read data into models

What does this have to do with SQLite?
> adding more boxes tends to index towards box-checkers who grew up wealthy.

Yeah, but that's the point. Those who come from wealth bring connections. Connections are what make or break a business. A mediocre worker with rich parents is far more beneficial to the business than a standout worker that came from the slums.
I would not. I would use Linux and its ecosystem as a base. Use a very hackable window manager that allows me to customize the window management and overall experience to my liking. Write a collection of scripts and programs that allow me to do things faster. Maybe release a distro with all of this together ready to use.
The subsidies on the gas drilling, production, purification, transport, and infrastructure should also be accounted for.
Yes, I think I'd be fine weeding out people who can't read a social situation and decide to traumadump to their future coworkers.
Are batch operations automatically atomic in SQLite? SQLite makes no mention of batch operations.

Looking at the library, it seems it's just using prepared statements outside of a transaction...

https://github.com/powersync-ja/sqlite_async.dart/blob/f994e...

Seems the other commenter is correct that wrapping that line in a tx will fix it.
>I don’t think Stable Diffusion has ever generated a person of color for me

It does it's just extremely stereotypical, you'll encounter them in parts of the datasets that will have them better represented in the source data like if you ask for fashion photography you'll get more black and east asian people, less south asians.

Raw Dall-E probably does this too and OpenAI is embarrassed by it which explains why they waste tokens every request trying to hide that their data set has what they consider bad representation.
Kind of useless to have a giant list of entries for $10 with 1 bid without any indication of how long's left. Since there's no reason to bid until the last minute, I personally only want to see Buy It Now items or bids ending within the hour.

Also, some items are listed but out of stock, which should be filtered out.
Unmanned spacecraft, hopefully? "Taking chances" is not a thing that I'd like the designers of a system that controls the vessel I'm on (or that overflies my house) routinely do during development.

Undefined behavior can transitively expand to the entire system very quickly. For any subsystem, the proper error handling for an overflow/arithmetic error that's not properly handled right in the place it occurs is to declare the subsystem inoperative, not to keep going.

If that approach routinely takes out too many and/or critical subsystems, you likely have much larger problems than integer overflows.
AtD gets sidetracked with long stretches of s&m-laden filth. GR reads like a fever dream but it's interesting both thematically and in prose (it's also dirty, but doesn't linger as much).
the second link is obviously counter to the narrative of

“ When protesters assembled, he ordered police snipers to shoot at them, killing 108 people.” as it describes interviews with Maidan snipers
Children may not be able to make good decisions with their money, but many adults aren't either, especially when it is someone else's money (ie, their kids).

A child should retain full control of their own money up to a certain value. Above that, they should be assigned a fiduciary to take care of the rest.
You would need a tax or heat pump allowment to adjust for that.
Breach of copyright is poison. So much devoted to providing people recipies or lyrics online for free and good faith, only for it to be scooped up and converted into shareholder value.

Unpaywalled data should automatically be used in line with how the person who created it and made it available wishes. It would be reasonable and aligned with how fair-minded people think about it. At some point people will fix it. But this transitional period is obnoxious.
Written end-to-end electronic communications was obvious going back to at least the 70s (and arguably much longer). What was aruably a lot less obvious that email/chat would become almost ubiquitous and increasingly a prerequisite for fully participating in society. (Including on the go.)
This is cool! Do you have any plans to add open source capability, maybe through something like LangChain?

We have lots of compute, but no OpenAI api haha
I agree that deserialization is not the responsibility of the database.

But as an end consumer, the overall throughput while using SQLite as the DB engine was not sufficient to serve our use case of reading 100k embeddings.