skysight-inc/HackerNews huggingface dataset:
> I have trouble imagining a future where people don't want to trade their time for more goods and services. New phones, nice holidays. Especially with the advertising industry constantly bombarding them with messages about how their lives could be better if they just spend a little more.

This difficulty in imagining a qualitatively different future is what Mark Fisher called "capitalist realism". A changed society produces a changed population, and therefore a society without advertising will not have its members affected in the same compulsion as they are due to advertising today.
I created a python package to run sql query and get json result.

I have created multiples python scripts to to run specific query return json, again and again.

But since now i only need to create my sql query and run it using sql2json.

I think that this tool can be useful for automations.

Right now i'm using it in personal project to run queries with dynamic date parameters and post result to a rest API with a linux cron job.

Also i'm testing it to send data to geckoboard using curl with sql2json response and geckoboard dataset api.

I want to receive some feedback from this community, how can improve it, is it useful for you.

Thanks
Kind of like this? https://www.youtube.com/watch?v=JUOGxePBs50
Why India Needs You to Register Your Drones ASAP
Cool! I was thinking doing something similar.

Question: why not put everything into the SQLite DB as opposed to files next to the db in an archive?
Are you sure there’s no correlation between spelling and intelligence? Can you provide a source?

It’s counterintuitive that people with extremely low IQs aren’t more likely to make spelling mistakes.
> Peter Jackson and team were extremely good at portraying evil in all of its ugliness but failed to portray "goodness" with equal skill

I think that's a fair comment. I would go even further--in fact I did, some time ago:

http://blog.peterdonis.com/opinions/tolkiens-ring.html
Toronto can't stay without a delay for more than 15 mins... on the subway system.... I agree with you :)
Looking for an Account Executive for Iris Automation – AI Software for Drones
To both comments, not really.

It can get wet, but just not too wet. And it doesn't necessarily die when the initial nutrients run out as long as more naturally enter. The solution is to deal with sub-maximal strength and provide a slow nutrient drip(or possible occasional soaking with a nutrient slush).
Therefore more roads => more cars => same trip times. I could see that people would make decisions to take jobs where they travel by car, or choose to live further away etc. with more tunnels. That could be a good thing or bad, but yes the demand will increase, because people will find new reasons to get about if there is more road to do it on. Let alone business use of roads.
I stand by my comment.

https://m.youtube.com/watch?v=CCDDwR2x9k0
> exactly when I want to

What about everyone else and their cars?
> I pulled up the scripts our team had created to programmatically refund all the fraud victims. "Damn," I thought. "If this script doesn't work exactly like it's supposed to, there's no telling what could happen."

> [...] Lesson #2: It's OK to go manual sometimes

I'm not going to disagree that SOMETIMES a manual approach is better, but where's the part that validates the decision to the degree that it becomes a "lesson" from the incident? Just the fact that they managed to finish?
You might be interested in the Holographic Principle [0]

[0] https://en.wikipedia.org/wiki/Holographic_principle
As another lefty, I don't see the issue, unless you write with a "hook hand." I hold the pen (pencil, etc.) as a right-handed person would, just mirrored. I've even done both European and Chinese calligraphy left handed (much to the amusement of the Chinese calligraphy teacher, but for European calligraphy, I have to turn the paper 90° to the right).
Job 1: Graduated college and got a job in my major

Job 2: Economy shifted (dot-com bubble popped.) CEO asked me to over bill hours to our largest client

Job 3: Company went bankrupt

Job 4: Ran my own company for 13 years. Went to Burning Man and it flipped switches in my brain. I could no longer stand working alone in my basement and got a regular job

Job 5: After a fun 3 years, Board of Directors seized control of the company, fired the founder/CEO, and replaced managers with people from their last startup. I gave it a year, but we didn't click and I left over personality differences.

Job 6: Best job ever. Company and I both took a risk as I was under-qualified but the position was open for more than a year. Eventually wasn't able to perform as needed and we decided to separate. Cool company let me stay on as long as I needed to interview, let me make contact with anyone in their LinkedIn network, etc. Fired in the nicest way ever and still respect them.

Job 7: Myself an several others injured during office renovation. The office turned into a literally a toxic environment. After returning from Worker's Comp, CEO started referencing imaginary "performance problems" and thought our injuries were all "pre-existing conditions" despite OSHA investigation. Decided I liked being able to breathe air and not worry about getting fired.

Job 8: Having a great time with new coworkers and hope I stay here a long time!

(This covers 1996 to 2020)
They just used an off-the-shelf machine from another company. Modern tunnel boring machines are this fast.
Magnetic Universe
We already have slow-curing low-emissions concrete, which has existed for centuries. Fast setting is a core feature of modern (Portland) concrete, and any "replacement" which doesn't do that is not a replacement at all. Companies want to build their 40-story towers in 6 months, not 6 years.
This seemed pretty obvious when all the stories were about cannabis vaping, not nicotine.

And now vaping is thought to be unhealthier than tobacco smoking.
SICP is not about Lisp, Scheme was chosen because of its simplicity, but the book is not about Scheme. If you always wanted to go through the book, maybe also take a look at "How to design programs." It's a bit like a SICP, but it's written in a different style, you may prefer that one instead.

- If you want something practical - do try Clojure. Don't listen to JVM haters and Lisp "purists". JVM is a pretty robust piece of tech and Clojure is a proper Lisp dialect. Besides, Clojurescript is a lot of fun.

- If you like Lua, and want to make simple, fun games try Fennel. If you're into math and enjoy playing with fractals and such, do try Racket.

- If you are serious about Lisp, sooner or later you may want to learn Common Lisp. Especially if you already using Emacs and want to improve your emacs-lisp skills.
What's the state of all the laws brought in against vapes under the pretence that nicotine vaping is causing the outbreak in lung illnesses.
Very early on scientists identified vitamin E additives as being the cause. Most black market vapes added vitamin E acetate ,etc.. to enhance the flavor profile of the "carts". Overall this isn't super surprising.
Since you said Stanford...I am more or less sure your 'boss' is your advisor or some Professor?
Well, in that case, he really doesn't need to show anyone what he is doing with his funds (well not true technically, but its still pretty flexible than any company)
> His entire arc was in the backstory, prior to the events of the books.

Not only that, but even the character arc in the backstory (the Tale of Aragorn and Arwen) is nothing like the arc portrayed in the movies. Even as a young man, Aragorn is noble, confident, and driven: he is only twenty years old when he returns from great deeds in the company of the sons of Elrond and is told his true name and lineage, and from that point he knows he wants to fulfill that lineage; he is never in any doubt about it. His character arc is about all of the things he has to do and all of the knowledge he has to gain in order to be able to fulfill his lineage when the time comes.
I think some countries should just bite the bullet and start replacing their archaic writing systems with something more modern

Phonetical alphabet, standardized spelling, etc

Few people nowadays have the time and willingness to learn thousand of characters and their stroke orders. Not to mention the whole "every character has several unrelated pronunciations, but hey, context, right?!" of Japanese.
Oh I have. And I had been buying them in large quantities since 1984. But the astonishingly low quality of Apple's hardware and software over the last 5 years has made me stop.
The Islamic Golden Age saw scholars from Syria, Iraq, Anadlus, and Iran rise to the fore. Many tried to consolidate the Greek-Hellenistic, Neo-Platonic, Aristotlist, Hindu, Nesotarian, Judeo-Christian philosophies as if they were searching for singularity. The foremost book in that regard is authored by an anonymous group from Basra (Iraq) called the Ikhwan-al-Safa [0].

Meta-physics (and philosophy) was considered the highest form of knowledge. And the tradition of pioneering various sciences and philosophy was started in Medina (present-day Saudi Arabia) by a certain Mohammed Baqir and his son Ja'far Sadiq, who at peak is believed to have taught 25,000 people [1]. Jabir Hayyan (Geber, father of Chemistry) was Ja'far's student. Avicenna's ancestors were Ja'far's followers, too.

At the peak of rivalry between the Abbasids of Iraq and Fatimids of Egypt (who later invented the Pen), the schools of wisdom and schools of sciences were established by both as a means to compete with each other, politically and religiously, and take over the tradition started by Mohammed Baqir. The Nizaris would later scede from the Fatimids and settle at the Alamut Castle in Iran under the leadership of Hasan Sabah, a student of the Egyptian school of wisdom and the founder of the feared Hash-hasins (Assassins).

[0] https://plato.stanford.edu/entries/ikhwan-al-safa/

[1] https://www.al-islam.org/life-imam-jafar-al-sadiq-baqir-shar...
War is still highly profitable for oil companies (like Aramco) as long as they can get oil fields for cheap, set the price for oil and poor people (central banks) pay for the costs.

In the next 20 years both oil companies and central banks are getting distrupted, at the same time a brave new world is coming...
If the headline says that the CDC confirms something, shouldn't a CDC press release or paper be used? Article seems to be from some third party citing this paper[0] and claiming they predicted it before. Title seems a little misleading.

[0] https://www.cdc.gov/mmwr/volumes/69/wr/mm6902e2.htm?s_cid=mm...
I think different people have different criteria on "trustworthy".

Most are only looking for confirmation. There are a few are looking for nonpartisan, unbiased reports.

For those who are interested in nonpartisan, unbiased reports. I highly recommend https://thedispatch.com/ . Yes, they clearly state they are conservative leaning, but I found their reports are very good. I also would like to know any liberal leaning website like this .
More like:

Phase I: Will this treatment immediately kill people?

Phase II: Does this methodology seem like the right methodology to show some sort of result in larger trials?

Phase III: Does the treatment work better than some type of placebo for at least a few weeks without causing obvious and unjustifiable harms during those few weeks.

Phase IV: Let's shift our marketing budget into R&D so that we can claim to be unprofitable to congress.
Yeah, it's easy to forget now how demoralized the US was for the first six months or so. Japan was really kicking ass at first.
Except Montana, and afaik other places, banned forms of nicotine vaping in response to this. Also the general public seems to think it's related to nicotine, not thc.
It reminds me of "the great hack". Disinformation is so disturbing.
The Coming of the Great White Handkerchief is near!
> Learning to spell isn't memorizing lists of words

Funny you should say that in defense of classical methods of teaching literacy, which for me consisted of eight years of memorizing lists of words and regurgitating them on weekly spelling quizzes.

Weekly spelling quizzes. Memorized lists of ten to fifteen words at a time.

All the way into high school.
I usually just go to a “new” site that isn’t cached by my browser, that seems to do the trick. But I agree it’s an insanely bad user experience and an absolute disgrace that a better solution hasn’t been implemented yet.
Moore’s Law, Supply Chains and Security
I was thinking of making the client code open source (eventually) so that users can know that their privacy is respected
I wanted to send my tax person my documents but he used email which I am a little uncomfortable using so I figured I could build an app
It should happen extremely infrequently, and when it does, the odds are it isn't because someone is that good, but rather in the right position to reap the benefit of a previously unexploitable network effect. This indicates the Market may be in a position to restructure/reorganize to take into account a new local maximum/minima.

The original point the poster made still stands. The point of the invisible hand is to parallelize capital expenditure decisions. Once everything consolidates in a few hands, the market is no longer operating in that mode. You have few people making increasingly large and underinformed decisions about capital movement, which coincidentally, further constrains the ability for money to move throughout the world unless your people sitting on top of capital are spending each and every day doing nothing but trying to unload capital to facilitate the rest of the world's business.

The idea of a Free Market does not discount the possibility of Market participants organizing to redistribute and reprime the Market optimizer in the name of shifting away from destabilizing economic circumstances. After all,a market that can no longer function due to civil unrest makes no one but the engines of violence any money.

The sooner people start to to take that to heart, the better we'll all end up.
See also: AgingBiotech.info
Specifically AgingBiotech.info/companies
(esp. the clinical stage & clinical trials columns).
Qi Number: A Number that can feed you
I do not know. What source?
We can always hope that Intel catches up to TSMC, but it doesn't look like that so far.
Congratulations, Andy!

I have been following along since you first picked up Guile and began running with it.

Displacing badly-designed, slow scripting languages is the natural home for Lisp, and Guile is the right vehicle for it.
This article is an obvious propaganda piece. The CDC findings linked within, while boring to read, at least provide a more neutral view.
> This is like a pharmaceutical company...

If there was anybody who would be motivated to scapegoat a single actor or cause for dysfunction in the medical industry it's me.

I've endured debilitating health challenges, including severe pain, for almost half my life. I've had plenty of time and motivation to research and contemplate everything that's wrong with the medical system, including corrupt dealings between pharmaceutical companies, regulators, research institutions and medical practitioners.

And, much like apportioning blame to VCs, there is some truth to this point of view.

But it's not the whole story.

At least as significant a factor is that there is a real, legitimate need for pharmaceutical opioids, and a widespread epidemic of "pain" that is little-understood by mainstream medical researchers and practitioners, which is mostly to do with the fact that physiology is extremely complex and still only partially understood.

Fortunately, I've never had to turn to opioids or other pharmaceuticals to treat my pain conditions, and after many years of research and experimentation, have been able to become pain-free via natural - though unconventional - approaches.

I think it would be great if other people had the access and motivation I've had to achieve good health, rather than ending up dependent on opioids or languishing in other ways.

But 10+ years of thinking about it, including plenty of, yes, curious conversation, has taught me that problems in the medical system can't all be simplistically blamed on corrupt pharmaceutical companies.

> tonal arguments to dismiss the hardest of questions

What "hard questions" was the root commenter raising?

Real "hard questions" involve honestly considering all facets of a topic, and taking on the responsibility of contributing to the formulation solutions that are practical and effective.

> Perhaps this is not a true intellectual community

In what way was the root comment more "intellectual" than what I'm advocating?
Military prefers locally sources parts because if war breaks out you need absolute certainly you can get the critical parts you need to build whatever weapons you don't have. For short war this isn't a big deal because you are stuck with whatever you have one hand. For a longer war you need to buy more weapons - and that means you need a source you can buy them from. Friends and enemies change all the time, so the only way to be 100% sure is to produce your own parts in your country.
Given the highly localised and sudden/synchronised bout of illness associated with vaping, to me it immediately seemed reasonable to assume contamination of a specific batch of products rather than the act of vaping in general being an issue.

I'm not saying vaping doesn't perhaps have long term negative effects, just that the pattern of illness suggested an issue with specific products.
While I agree that collecting more data opens up the possibility for more complex, exciting analysis, gene expression data is no magic bullet. It is often noisy and still prone to experimental error because biological systems are so heterogeneous. Also, for a lot of investigations, there are only a handful of samples which means that the number of distinct data points for a specific transcript are very low. You typically end up with many columns but few rows in your dataset which makes modeling biological systems quite challenging.
Any detail specifically on the tunnels? That just mentioned 200km of track, but not whether above or below grade
Students call for open access to publicly funded research
> More roads mean more people using them to do something they want to do.

I'd argue that a lot of people don't want to drive a car, they want to get to their destination.
Where options other than driving are available, then they weigh cost/convenience to make their decision.

My view isn't that cars travel is innately evil, or that building roads is always terrible - but that so much more money is spent on building more roads than on public transit options.

For some reason we ignore the last 60+ years of evidence to show that building more roads doesn't lead to reduced traffic. It's simply not possible to build out roads fast enough to beat the rise in traffic.

If you build public transit options that get people between locations they want to travel, ensure that it's run on time, clean, and affordable - then people who already drive will evaluate that cost/convenience function for themselves and decide that public transport is actually better. This results in much reduced road traffic.
That and there was no EPA, no environmental design reviews, not much permitting, lax or zero safety standards (today it is a huge deal when somebody dies on a construction project... no so much back then). There was no ADA accessibility standards, no elevators or required wheelchair access, there was very little underground.

If all the businesses along the block you are trenching through back then went under... so fucking what?

If your 24/7 jackhammers kept all the block up the whole night you’d tell them to take a hike.... etc, etc, etc.

If turns out if you care about any or all of those things, your costs go up. Back then it was all just negative externalities that got foisted on the neighborhoods around them. Think of the negative externalities causes by our interstate highway system. Good luck building that now! It literally divided entire neighborhoods. The entire thing would be require to go into a tunnel under the city. No way would people tolerate that shit now.
Earth shine is a thing.
Auto-complete is at least very helpful in two regards:
- "Don't make me think". I don't want to wast my brain bandwidth on remembering the details of tens of thousands of the methods/properties/functions, but instead on the logics/architecture/communication of the app I'm building.
- Method/property discover-ability, especially for new classes/interfaces/libraries.
I think only BMWs support it right now.
If you want a serious answer: try and build a house. I did. It will expose you to the bananas state of local government.

Planning/zoning will kill you, it's simply illegal to build most types of houses in most of the US. There was a recent blog post about this I can't find, but it outlined all the houses that exist that are now practically illegal. For example, mixed use where there's a business on the ground floor. Or building 3 stories in a 2-story zone. Or having an ADU. The list is endless. In fact my current town just made it illegal to build single family units next to multi-family (with a buffer), and we only have two places in the town where you're allowed to build office space. Retail is slightly better, there are three places that's okay.

If you get through planning, then permits will kill you. The permits to demolish our place (different town!) were more than buying a new house. I'm not kidding.

If you get through permits then good luck with inspections.

What musk is doing with tunnels is what the entire tech industry is doing: working in a zone with a lot less rules. It's illegal to make a building but you can make any website you want. Though that is going away too, it'll get regulated to death eventually and you can already see it starting to happen with data and privacy laws.

The main escape from all this, as far as I've been able to find, is Texas. It's apparently still legal to build things there.
Pentagon Says No Specific Evidence Iran Was Plotting to Attack U.S. Embassies
I expect people to tell me the truth as they believe it. I think that's a pretty universally known standard.
check https://twitter.com/dvassallo

He self published a book recently.
I hope this spurs the government into action. NYC is absolutely flooded with perfectly legitimate looking vape cartridges filled with questionable product. They're often sold as being from a "dispensary brand" although they're obviously not. As an example, these were readily available for years despite the fact that the brand never even existed in the first place:

https://merryjane.com/culture/are-smart-cart-vapes-legit-and...
Dang, I'm almost jealous. I couldn't resist the temptation and hope that the movies could maybe possibly vaguely live up to the legacy. Unfortunately I didn't quite anticipate how those images would forever alter my vision of the story/world. Though, I've purposely waited a long time and ignored everything about it, letting the memories fade, so I can re-read the trilogy and hopefully rediscover the greatness. :)
I started reading The Hobbit to my son (5 years old). We read half a chapter every night, or even less before he falls sleep. He loves it, and asks me to read to him when I almost forgot to do so. He asks A LOT of questions about new words and differences with the movies (he is a big fan of them). Our pace is quite slow, but it is a great time together.
Forty-seven is the saddest age of all, study finds
> less cleanly

Python has a number of these warts. Same with classes and type annotations.
I don't think this is a deliberate disinformation problem, it's simply that good information and proper investigations take time. In the meantime, people speculating (primarily on social media) dominates and those opinions become indistinguishable from good information to most people, if they ever even see the definitive results at all.

This dynamic has affected almost every thing I pay attention to on the internet. It's depressing.