skysight-inc/HackerNews huggingface dataset:
The "lack of functions" is what allows SQLite to be what it is: a small, efficient SQL database that works on everything from mainframes to a watch. The fact it doesn't have every possible feature you want or need is not a deficiency of SQLite: if you need tons of features then, by definition, you're outside the niche of what SQLite was built to handle and you need a large, full-featured database server.
What happened in the Nebraska case was more subtly bad: if the government had to subpoena HER for her location data on that day, there would likely be no criminal conviction at all. The 5th amendment would be a valid excuse to avoid giving out the data. However, they only had to subpoena Facebook, whose data is not covered by 5th amendment protections, and who would like to maintain a friendly relationship with governments.

EDIT: This is generally called the principal-agent problem, and there are lots of rules around agent behavior when it traditionally applies (eg attorney-client privilege and doctor-patient confidentiality).

Also, you should note that there are lots of crimes, and you probably commit a lot of them. If you have ever used someone else's WiFi without permission, that's one. If you carried a screwdriver or a sharpie into a store, that's a separate crime. The list goes on and on.
> Google says they won't give Mark his account back because they found another "problematic" image in his files

Whoever is responsible for this decision and the resulting communication, I have nothing constructive to say. Sincerely, fuck you.

I can't believe they went through this person's account to find justification for their first mistake. This is intolerable.
Energy too cheap to meter doesn't sound like a good investment from a capitalistic viewpoint.
Hungary's weather chief sacked over wrong forecast
TPMS is very important with run-flat tires because you cannot easily tell if one has a puncture or is low on air by looking at it - they hardly bulge at all.
Your lecture would have been more reasonable if I had not already given a specific example of diversification. Namely the construction of a LNG terminal.

Here are numbers for you. The Sabine Pass LNG project in Louisiana, USA, was constructed for about $5 billion. Its capacity is almost exactly the same as the Nord Stream 1 pipeline, which was constructed for approximately €15.7 billion. Thus for 1/3 of the cost of the pipeline, Germany could have provided themselves a backup plan for Russian gas, while requiring zero changes from industry and consumers.

This one time investment would have been a fraction of what Germany spends each year subsidizing renewable energy, and a drop compared to the cost of shutting down nuclear. Therefore the cost of making sure that there was a second supplier of gas available would have been quite reasonable to do some years ago.

Given that it hasn't been done, it is impossible to do on short notice. But Germany could have done it, should have done it, and was repeatedly advised by allies to do exactly that. And failed to.
There's no lack of people to walk the earth who have no evil though. You have to contrive good people to be evil to make that the case.
I can’t tell if you’re being intentionally funny or just funny.
Tasks automation for social media only
Hello all

I’m working on a web app prototype:

A set of useful and automated tasks/workflows for social media only.
They will be configured by you and executed when an event is triggered.

Examples:

Event: If I’m on holidays,
Action: Then automatically update my twitter profile banner.

Event: If I’m on holidays
Condition: And a follower DM me,
Action: Then Send my auto response message.

I know Zappier gives some of theses triggers but there are not totally social media oriented at all. (only 8 triggers exist for twitter)

Is this something you might be interested of ?
Do you have any ideas on what triggers you would like me to create?

thank you
"When I started this company, all I had was a dream and 6 million pounds."
Great, then surely labor will be able to pay for it.
I already put my kids in a software driven car every day. It has automatic cruise control, automatic lane keeping, and automatic emergency braking. I don't trust Tesla's Autopilot yet but as soon as there is a self-driving car which I believe is safer than a car driven by me, I will switch to that.
First about 18 months ago they said I had an IP phone and could no longer log in (my carrier is Republic Wireless). When I contacted support and told them that I had been able to login with that number in the past they basically said "we're tightening up security, too bad so sad. get another phone number" Then recently I found that I was able to log in when I wanted to try midjourney (Republic changed something back in April, apparently so they it no longer looks like an IP phone#). Then I wanted to login to discord on the my desktop and it gave me some weird errors which basically amounted to "this number is already claimed" (it was, by me) so now I'm back to ignoring discord again.
CC0 - no one owns the copyright, so everyone is free to use
> If you are creating, for instance, an idle game where the user can pay to skip time; that's a problem.

This statement is also true in isolation.
Chechnya was inside of Russia's national boundaries. And therefore was not a violation of international law.
You can also be more efficient with heat pump than with direct gas heating, including when producing electricity from gas, eg:

https://twitter.com/DrSimEvans/status/1560556804051968000

"Thought experiment:

1 UK replaces 24m gas boilers with electric heat pumps

2 UK builds new gas plants to supply the electricity

=> Overall UK gas demand falls by 120TWh (15%)"
My experience with "Big Data" is pretty dated, 5 years at least. At that time I think a good cutoff for "big data" might have been like a petabyte +/- a factor of 10 depending on your gear. I imagine now even 1PB is probably pretty mild by "big data" standards.

But once you're up in that "I can't even fit this in an 4-8U sled" territory (whatever it is in a given decade) you're probably doing some kind of map/reduce thing, so there's a strong incentive to have a column-major layout. If you can periodically sort by some important column so much the better (log2 n binary search), but mostly you've got a bunch of mappers (which you work hard to get locality on relative to the DFS replicas where the disks live, maybe on the same machine, maybe in the same top-of-rack switch or whatever) zipping through different columns or column sets and producing eligible conceptual "rows" to go into your "shuffle/sort/reduce" pipeline to deal with joins and sorts and stuff like that.

I don't know how Google does it, but I think most everyone else started with something like the Hadoop ecosystem and many with something like Hive/HQL to give a SQL-like way to express that job, especially for ad-hoc queries (long-lived, rarely changing overnight jobs might get optimized into some lower-level representation).

Around the time I was getting out of that game, Spark was starting to get really big, which was due to some combination of RAM getting really abundant and just kind of a re-think on what was by then a pretty old cost model. I have no idea what people are doing now.

I'd love it if someone with up-to-date knowledge about how this stuff works these days chimed in.
They have it right on the first page: look for the little diamond that represents the marginal cost to produce power at a fully depreciated gas plant, $24/MWh. [This price is certainly no longer true thanks to Russia].

But it's unfair: what is the marginal cost of solar or wind at a fully depreciated solar or wind plant?

Also: they have the cost of PV+storage on the last page.
Agreed. I also have a hard time accepting the idea of any concessions to Russia, but I understand the principle of being willing to consider any (morally acceptable) possibility to preserve irreplaceable human lives.

Also agree we’re headed for a multipolar world, with climate change impacting geopolitics in the Northern hemisphere, majority of the global pop. concentrated around SEAsia, and a looming demographic collapse putting pressure on nation states to act now-or-never.
I like that specification. I've used something similar for many years. I code my task list into a text file using a single character to show status:

. This is a pending/idle task item, and normal priority
_ Task is pending/idle, and low priority (the "someday" tasks)
! This is a pending/idle task item, and high priority (fix today/soon)
* Currently working on this item
# Task was completed
X Task was cancelled
> Task is delayed/deferred, waiting until later time
Z Task is sleeping, waiting for some dependency

I also tend to code year/month after the symbol like 2022/08 (not shown in the listed examples)

By keeping a single char in the first line, I can easily grep and sort tasks to make sense of things. I know it's very crude, but it works well for my purposes. I welcome any suggestions or improvements

(edit: formatting)
Perhaps the spec could allow an implementation to support a run-time option to recognize alternate characters for syntactic elements. This would have the downside that one person's data might not be shareable with another person's [x]it installation. But that's not necessarily a bug, especially to people who don't plan to share their todo lists.

This run-time-option-only approach would be much better than the "be liberal in what you accept and strict in what you emit" philosophy that tends to cause fragmentation on lots of different levels.
Seems like we're hearing only one side of the story
There's no point in precise measurement because tire pressure is going to vary widely over temperature and how laden the vehicle is.
This is a false equivalency. The extent to which Pakistan used its military apparatus to train militias and other terrorist organizations is unparalleled. There is a reason Osama Bin Laden found a safe heaven.

This is the what aboutism that most politicians toy with when they want to fool the public. But like I said this is a populous that are truly detached and delusional. They brought it on themselves.
At least Google services can be replaced by alternatives, though perhaps painfully. Running from the police doesn't generally end well.
Inside the Pinecone
They haven't, actually. Standards of living were terrible in the 1800s because enclosure had forced most people off farmland and into overcrowded cities where they were effectively forced to work long hours in incredibly dangerous conditions. Actually wellbeing has at best returned to the level of the early modern period in the global north, with standards in the global south being worse by an order of magnitude.
Yes if you're willing to build a huge heliostat you can heat things to arbitrary temperatures. I first saw this dish-shaped heliostat in the mid-90's in Texas, and its biggest problem was controlling it so it didn't melt the hot side of its generator.

https://en.wikipedia.org/wiki/Stirling_Energy_Systems

The only thing that's really new in solar in the last thirty years is the steady progress of semiconductor physics and technology. All the rest of it just follows from "sun is large and hot" which has been known for a long long time.
I just started shooting bracketed exposures last week trying to captures exterior of homes better. I’m going to try this.
"Falsehoods programmers believe about black hole orbits..."
I always use UK layout.
"nm" it's your friend here.
It isn't so much a race to find the oldest document, but rather a way to acknowledge the ancient giants on whose shoulders we stand.

Citing all the way back to Laozi is kind of a power-move, though. Done wrong, it seems silly and contrived. In this Nature article, it was well done and gave a broad facet of humanity to an otherwise-technical work.
The oil for heating has been phased out in favour of gas because of emissions. So for most homes this would mean to convert back to bulky oil tanks. It's probably cheaper than heat pumps and you can keep the plumbing. The plumbing and use of radiators is a big problem for heat pumps because of the higher temperatures that are needed to heat radiators on the 4th floor etc.

Other houses never had oil. They switched from coal straight to gas in the 60s and 70s. But here the furnace is usually on the same floor as the radiators. But conversion is still expensive.

> Germany obviously has options but why is it taboo to ask them to change their policies abruptly and temporarily?

It's not taboo to ask to change policies. Actually a lot of policies are changing. Even support for nuclear is on the rise.

But one of these changes in policies might have to be abandoning some goals of emission reduction. One of the reasons why gas was on the move up is because it burns much cleaner than oil or coal. So converting all that oil heating to gas was incentivised by the government. Also gas is much better in filling in the gaps for renewables than nuclear or coal which can't be switchted off again so easily.

The plan was to move from coal to renewables. The path there was via gas. A very reasonable bridge technology.

Putin's war came too early for that conversion but luckily not too late to stop switching coal to gas.

BTW, Germany never had enough nuclear plants to provide more than about a quarter of today's electric demand anyway. Most was coal. Even if Germany never decided to phase out nuclear, the problems would pretty much have the same magnitude.
I was an embarrassing number of years old when I realized Jimi Hendrix wasn't just really into Voodoo Chili.

I mean. Still a minor. But it stings to this day.
> also home of the best green chile

Them's fight'n words.

> https://solarroast.com/

I do like that coffee. Nice strong robust roast without tasting burnt.
Time to lawyer up. Looks like a fun case.
They did it to prevent people from upgrading the RAM, and instead having to buy an entirely new machine.
Let's hear the other.
Only if you think the history of now is moot.
> buy modern motherboard

The next AMD CPU to be released will almost certainly have a new AM5 socket. I'm waiting for this reason alone, considering the amazing support AM4 has had.
Hi yawnxyz - absolutely we intend to have support for Svelte in due course! We aren't Svelte users ourselves, so any suggestions or ideas are very welcome! Do let us know in the community - https://surrealdb.com/community
I remember as a kid, in India, solar, gobar/bio gas and alternative ways of cooking and heating were all the rage. Then liquified petroleum gas became cheaper and everything just died. Here’s[1] an example of what I’m talking about. It was mostly for rural areas without reliable ways of delivering cooking fuels.

[1]
https://www.rudrasolarenergy.com/solar-cookers.html (parabolic mirror based “cooker”)

https://www.indiamart.com/proddetail/gobar-gas-plant-3976916... (basically methane collected from composting)
The fifth amendment provides a right not to testify against yourself. It has little to do with documents, whether they are in your possession or someone else's. The fourth amendment is the one that applies there. If her phone were recording location data locally (or if she were keeping a paper diary of her location, for that matter), the government could have obtained that information with a search warrant, and it would have been perfectly admissible.
You're still excused while you kiss this guy.
> This seems overly pedantic.

Mixing up text and images isn't really pedantic. One is reading my thoughts, one is monitoring my captured moments. They're both bad, but very different. Even the author issued a correction at the top of the article, but should have updated the title to reflect the correction.

> However, it's not a far stretch (nor hard to imagine) this same technology is running on every Google-enabled service.

OK, but then write those articles, with proof. Until then, just keep journalism as accurate as possible. When we lower the bar so much that we're writing about things that we can imagine being true, it's just fantasy land.

> If your photos are being scanned the system is compromised.

I can have a Gmail account without having a Google Photos account, so no not everyone who sees the "Gmail will call the copy on you" headline has a reason to panic.

> Perhaps the author intended to produce a chilling effect necessary for people to understand this.

That's really irresponsible fear-mongering and I doubt was done by this author since they were responsible enough to post a correction at the top of the article. The truth is the scariest thing because it's real. Fantasy isn't scary because it's fiction.
Absence of a signal is itself a signal.

I’ve built a business around this one!
I'm an alcoholic, but thanks. Care to eschew your sarcasm and have a discussion about why we should use how OP's body responds to alcohol as the primary reason to cast this entire article (that came with cited studies) as "bullshit"? Because that's all my point was.
Red chile is better.

- A contemptuous New Mexican.
I remember when 10BASE-T was brand new and hilariously fast and radically better than the clumsy, bulky connectors and cables that had preceded it.
You can use it as a web service by visiting https://maps.earth/
Gas turbine are the cheapest electricity generator to build, only expensive to operate due to fuel cost.

That's why people don't mention overbuilding gas2power capacity.

Data from:

https://www.eia.gov/analysis/studies/powerplants/capitalcost...
What does this have to do with running from the police? That isn't part of this story.
What 'history' books did you get this alternative fiction from regarding the Holodomor [1]? The Soviet state as personified by Stalin was the main cause for the depths of despair and depravity experienced in Ukraine. If you can leave back that 'history' book I'd suggest doing so, otherwise use it to start your stove this coming cold winter - you'd still be better off than those who Stalin and the Soviet system of collectivisation followed by annihilation sentenced to starvation.

[1] https://www.britannica.com/event/Holodomor
You're conflating "right" with "far-right". American libertarianism is moderately right-wing. Left-wing libertarians are anarchists, not against "rules" but against power hierarchies (freedom from oppression). Right-wing "libertarians" are laissez-faire capitalists (freedom from interference).

I realize that the prevalence of religious fundamentalist opinions in US politics skews the perception of what "left" and "right" mean but NOT being a theocrat or NOT actively wanting a white ethnostate doesn't make anyone "left-wing".
On Linux? I know it has been confirmed on macOS. I haven’t heard anyone say they ran 32 bit code on Linux.
Indeed. The whole point is to extend it with application-specific functions since the database is typically hosted in-process.

This is what we have done. We have a lot of domain-specific UDFs available in our SQLite scopes. Both scalar and aggregate types. Note that not all functions must be pure. You can quickly repurpose SQLite into a full-blown DSL by going down this path.

See: https://www.sqlite.com/appfunc.html

And: https://docs.microsoft.com/en-us/dotnet/standard/data/sqlite...
>How much money do I need to pay to make my house hot using solar panels?

It might possible depending on how much land you have, but is certainly impractical. I mean you could theoretically do it with a large enough area and your own storage system, but it would sure cost a lot.

>And natural gas?

It's completely impossible without the natural gas grid (and electric grid). Unless.. do you have a natural gas well on your property?
There is plenty of value discussing it here. You don't need to join in if you don't want to.
> Photostructure (https://photostructure.com/) lacks a lot of features google photos has - but one of those missing features is calling the police on you.

Yet. They will be forced to implement it.
I remember, maybe in 2008 (I might be off by few years and it's too late at night to check my sources) yahoo had a breach which resulted in emails going into hackers hands. This made me thinking AI scanning your email is certainly not a good thing, but to have somebody to take a loan in your name because you happened to have a scan of your ID in one of your emails might end up with much much worse consequences (I was one of those dummies who had scan of their ID stored in inbox, once I learned about breach I was running to invalidate it). This was a lesson I needed to make me stop using google/yahoo/similar. I'm too small (and unknown) to be attacked (however who knows..?), but yahoo was big enough and probably harvest was worth it.
I'm sorry, but I think you're just kind of making things up here to perpetuate an unproductive argument. By "conservative", I meant that CERT is broadly anti-disclosure in all forms, which I think is a claim that pretty much anyone working in vulnerability research would recognize.

Here's the 2002 I-D that Weld worked on with Steve Christey standardizing the term. It's notable for being roughly contemporaneous with @stake firing Dan Geer over, as I recall, somehow alienating Microsoft, one of @stake's larger clients.

https://cve.mitre.org/data/board/archives/2002-02/msg00026.h...

Your link, for what it's worth, doesn't use the term at all. But even if it had, it wouldn't change anything.

Just to keep this on track: your claim was that "Coordinated Disclosure" --- the near-universal standard term for what used to be called "Responsible Disclosure" --- is an "Orwellian re-imagining". Leaving aside the fact that there's nothing intrinsically "Orwellian" about renaming something, the fact remains: "Responsible Disclosure" was researcher-hostile and patronizing, and has been chucked out the window by almost everybody who matters in vulnerability research.

We've managed to hash out a hot topic from, like, 2012 on this thread, which is great, it's progress, we move forward bit by bit here on HN, just like Joel Spolsky once said; "fire and motion". But we can probably be done now.
If Sqlite is missing functionality for your particular use-case, there is probably an extension that adds it. If not, you can write your custom extension.
Do you mean 01-01-1970 or 01-01-1970?
You have to handle your own conflict resolution. Ive only used it client-side because our apis have been existing REST systems.
Why Oracle XE and not PostgreSQL? What advantages does Oracle XE have over it?
You answered your own question.

>And many normal cultural things in the US would be regarded as an egregious offense in Japan

Many taboos are specific to culture. That's the point
This has been my experience, too, with security reports in general. We see things like:

- "An attacker could spoof an email from you to a user." (POC video shows Yahoo webmail succeeding. We try the same thing in Gmail, and it gets sent to the spam folder because it fails SPF and DKIM.)

- "If I try logging in as a user with an invalid email too many times, it locks them out of their account. That's a denial of service." (Well, yeah, and that's a bummer, but it beats allowing an attacker unlimited attempts.)

I'll say, though, that H1 has been super helpful at screening the worse reports. Sometimes they'll initially block reports like the above, but the researcher will insist that this time it's for real. I don't feel too bad closing those reports as invalid.

In all, I'm a very happy H1 customer. They've been good to work with.
I don't think the Mac Mini's case has gotten any thinner in spite of having soldered RAM. The M1 says it's 3.6cm thick, while my old intel mini is 3cm exactly, in spite of having socketed DIMMs (I upgraded it to 32GB, which was slightly harder than I expected, but manageable).
What's more fun than a working man facing off against the legal team of one of the most powerful multinationals in the world?
First paragraph I should read shall start as : "Photostructure is ...."
I personally have not had much experience with it.

Would love to hear some horror stories you've encountered. It might help me keep an eye out for it.