skysight-inc/HackerNews huggingface dataset:
I do use sqlite too to process csv file, but I either rely on csvkit to generate the schema from the csv or create the table with raw sql before inserting data in the sqlite database.
Can you explain this last part?

This is why I usually stop myself from trying anything very complex with shell scripts: unlike scripting languages, half the power of shell is hiding inside little piles of punctuation marks that I don’t think I can even Google!
I worked for a mobile operator for 5 years starting in 2001. We had 20 months to bootstrap the company and get at least 3 million customers. There were no virtual operators back then. We had to have our network, our software, our everything. We were a big startup, about 3k people.

I think that the only way to pull that off is working all together in an office. Too many things to do, people to talk with, known and unknown unknowns to figure out, etc.

But a couple of years after launch, when the dust settled down? Working from home would start to be possible.

I'm self employed and working from home now, for almost 17 years. The only two things that would make me go back to an office are either I can't find a customer for a long time or somebody covers me with gold, really a lot of it.
> But the entire system of the vehicle, and the way we use vehicles, and the way those form factors affect society and people's lives are very, very complex.

But that's no different from combustion cars. What matters is that the motor (by far the most complex part of a combustion car) is now a simple part in an electric car. The rest stays about the same in terms of complexity. So the overall complexity has gone down!

Say a combustion car had 100 complexity units, of which the motor has 50, the rest has also 50.

For a electric vehicle the complexity of the motor is say, 5 units. The rest is the same. So the overall complexity is 55.

You may ask why electric cars are so much more expensive when they are less complex. The obvious answer is that the batteries are expensive.
Offshoring roulette lessons from outsourcing to India, China and the Philippines
> 8. Carry a water bottle (copper ideal).

It's toxic…

Copper pots are not copper on the inside because of this reason.
I'm curious how many of these are just recycling open ai.
Taking as granted that “China” is systematically behind this crisis is so helpful to shift the blame from decades of failed prohibition-based drug policies in the US.
Is it possible that the Chinese government is just avoiding acting? Of course, because they’re dealing with an internal problem of an adversary state that would do exactly the same (and has done the same) if the roles were reversed.
Moreover, these drugs trades are just an over-optimization of a free market offer, and work exactly like a perfectly tuned capitalist device.
Blaming the opioid crisis on China is a very convenient scapegoat that gives America the opportunity to watch away from the profound root causes hidden in its own society that made it possible.
The remarkable case of the triple agent (2009/2019)
It's not better, since it's toxic.
Canonical has graduated to become a bad idea through crazy leadership.
Try https://huggingface.co/ehartford/WizardLM-7B-Uncensored and related models. They're not even trained on smut, just the neutered responses were removed before the RLHF stage (IIUC)
Consistency? I don't quite understand. Automobiles have benefitted from the largest public subsidies in history, starting from the interstate highway system, to oil industry subsidies, all the way to the current subsidies for EV purchases. Comparing bicycling subsidies to automobile subsidies would be absurd since the value of automobile subsidies eclipses the others!
I agree it's indeed one of the best tool to process csv files. Using basic coreutils command are going to be soon very limited and brittle to process csv files.
Indeed but NO! CHINAAAA!
As a ML outsider, this was the first I’ve ever heard of it. Obviously I’m not the target audience, but I’m just shocked that I didn’t even know Intel was in the game.
I used to have a similar opinion, but today I'm not so much against it. There was a project where I did not have access to the "official" database (Oracle) and was forced to develop against MySQL instead. Granted, it was a reasonably simple application, but still, most of the queries _just_worked_ on both MySQL and Oracle.
I would also argue that for querying you don't need ORM (might be better off with something like Jooq), but for complex updates, ORM can be a godsend.
Totally. It's not just about the language, it's one of those cases where the sheer quantity of threatening messages has a quality all its own.

It's as if the court simply refused to consider the whole picture. I tend to agree with those who say that they (as well as the ACLU) blew this one.
Some folks dislike exposing parts (or any) part of their internal network.
> For a hundred and thirty-four dollars, she purchases a box that can be returned to TerraCycle filled with plastic packaging,

No match for domain "BETTACYCLE.COM".

Looks like I found my next startup.
Although the direct effects are awful it feels like we should surely (in the long term) want services to be sustainable - i.e. the cost of the service to be paid for by its users. Where services are not sustainable (and require donations/grants) this should be explicit and transparent.

Cheap money lasted for such a long time that we're all used to being on economic painkillers 24/7.
The overlap of modding and multiplayer is small and usually for coop-ish games where cheating isn't a big deal. Most big modding scenes are for single-player games.
Japan's 14% rise in fish prices hits elderly's healthy eating habit
Seriously. I think posts/articles/etc related to replacement of Software Engineering jobs to AI are exaggerated and probably driven by jealousy or sadism. Just ignore those and move on.

(It was very depressing to believe that Software Engineers will lose jobs)
The study found that, to have a lower environmental impact than a plastic bag, a paper bag would have to be used forty-three times and a cotton tote would have to be used an astonishing seventy-one hundred times. “How many of those bags will last that long?” Franklin-Wallis asks. Walker-Franklin and Jambeck also note that exchanging plastic for other materials may involve “tradeoffs,” including “energy and water use and carbon emissions.”

Why am I not surprised.
This wood breaks screws and bends nails....

I really question if you comprehend the type of wood I'm talking about. The contemporary pine is like butter by comparison...
Because most things fail, but a handful of successes will pay for the failures.
"MEDICINE SHORTAGE REPORTS DATABASE

The medicine shortage reports database includes information about shortages of reportable medicines in Australia

https://apps.tga.gov.au/Prod/msi/search?shortagetype=All"

Here in Australia, 414 medications are in short supply.
I regularly get pharmacists ringing me to inform me that the medication I prescribed for a patient is unavailable.

That is the result of American middleman companies like Premier and Vizient squeezing every last paisa out of Indian generic manufacturers. Some of them decide to close their production lines and switch to manufacturing more profitable medications.
You should spit in the mirror next time you’re in front of it.
This is the kicker for me. Work can’t be done productively from home? Fine then. My laptop goes in my backpack at 5pm when I get into my car, and it stays there until I pull it out at the office at 9am tomorrow.
"we can't require eco-friendly alternatives to plastics because people litter" was not on my bingo sheet for today...
I second this.

There’s also the nutritional side. Food makes you happy but it also keeps you healthy and honey is a nutriments bomb. Not sure about the industrial ersatz.
Companies that claim that work from home doesn't work better not be doing mass foreign outsourcing. US employees can easily tolerate 3 hour timezone spread and be available for instant meetings throughout the day, as well as frequent in person offsites. Plus at this point Michigan is not going to be much more expensive than Bangalore.
Ireland – Telecoms companies ordered by High Court to retain all mobile data
The High Court has granted an order requiring telecommunications companies to retain mobile phone user, traffic and location data for 12 months for the purpose of safeguarding the security of the State. No information has been made available regarding the threat. This continues data retention practices that has already been ruled illegal by the European Court of Justice. See https://curia.europa.eu/jcms/jcms/p1_3863143/el/
They might be making the "best decision", but best decision for whom? Their own career, social standing and property investment portfolio? Or the best decision for the company and employee well-being and productivity?
Yes, starting with Hibernate as a idea of what ORM provides is terrible.

ORM have plenty of flaws, but it's like buying screws on wish and saying using a screwdriver is a terrible experience.
Source: Worked at a ~2k employee multinational when covid hit, it got bought by a bigger corp and got turned into an ~11k employee company later on.

Large companies were already multinational, people from India didn't fly to San Fransisco or Berlin for a meeting, they did it remotely. Some bigwigs and specific consultants did it, but the regular people just used Slack and maybe Zoom to communicate over time zones.

COVID just forced everyone to up their game with this, all meeting rooms got big displays, 4k cameras and Zoom integration after RTO was an option.

People going home got allowances to buy better gear for their home office (Mine was already good, so I upgraded my home theater setup). I had multiple work friends who moved hundreds of kilometers away from the city where our office was.

Even now most people are still 99-100% remote. They only come to the office when there are company-wide parties or team events.

Now I work for a smaller startup-ish company and we're mostly remote, it's recommended to drop by the office once a week, but it's not enforced. Some are there every day, some only come for the parties.

I personally know multiple highly experienced people (20+ years in the field) who 100% refuse any offers that aren't fully remote.
It's a lot about recycling and very little about how it's poisoning human beings.

I have a lot of unpopular opinions about plastic. I personally think it's not that big of a deal. Benzine compounds are naaty, but they're in your drinking water. I don't like them. But most plastic is organic compounds since it comes from oil. There are already microbes metabolizing it in the wild, and it's a rich energy source that most organisms aren't using, you can expect that adapted niche to be filled very quickly by those organisms. Additionally, I think there's too much of an aversion to burning it. Whether its for disposal or for fuel via depolymerization, I think we need to be burning more plastic. If you're worried about CO2 bear in mind, this stuff is in the environment and will decompose eventually. Overall I'm not that concerned about it, besides some things like PFAS and benzine compounds.

And all that said, I'd bet money I dispose of significantly less plastic than the average European. First is water bottles. I don't do water bottles. I use those 5 gallon jugs and a hand pump dispenser on amazon, it works like a super soaker or a garden sprayer. That alone has me ahead of most Americans. Beyond that I prefer paper bags, and glass over plastic containers. It's just lifestyle decisions, I hardly care but I do it, it's not even effort at this point, it's just different habits. If you care and can't be bothered and I don't care and do it, do you really care? Avoiding single use plastic in your household is not really all that hard, things you can't avoid like linings in cans and what not aren't the problem, grocery bags and water bottles are the big ones, and you can do other things like never buy teflon, which I also do.
> "State monitoring" are just different metrics

True but also misleading. In the end everything is really math but that is unhelpful. What matters is the model you apply to your numbers. And state monitoring as thought by Nagios is that you have 4 states: ok, warning, critical, unknown. And you have hard and soft states. This can be replicated with prometheus queries but it's incredibly complex and error prone, not to mention you will destroy your metrics storage IO.

Theory crafting aside I've created in a few months a monitoring system using Icinga that had virtually no false positives or negatives. That you could trust to phone you straight though without fear it will miss something important for business or wake you up for nothing. I never saw anything like this done with metrics or logs done by anybody.
Any plans for bringing Ladybird to other operating systems?
> What the article says is that the shortage of vital generic drugs, such as cisplatin and carboplatin used in cancer treatment, primarily stems from the financial struggles of the generic drug industry.

Then perhaps the government should be building plants to produce these domestically as clearly they need to be a common good rather than subject to the free market, no?

Or, perhaps, we shouldn't allow medical equipment and supplies to be manufactured overseas and imported as that results in cheap overseas manufacturers dumping product at prices sufficiently low that they will cut corners hoping the FDA doesn't catch them all the while driving out domestic suppliers?

Or, perhaps, any company found to have imported drugs from a plant that won't pass FDA inspection needs to have its executives sitting in fucking jail so that US companies have a vested interest in directly inspecting their overseas plants?

See, there are solutions ...
I have coworkers debating how to automatically update half a hundred build scripts to pick up new runtime versions.

I’ve long, long since given up getting the, to realize that separate build plans are only accomplishing one thing: Enabling (as in codependency) a bunch of bad, slow tests in two sections of the code to persist instead of needing to be rewritten.

This project has no proper reason to be more than a dozen modules, and we’ve spent time on tooling to reduce the burden of managing so many repos at once.

If you don’t have a small mountain of builds you have to compose, you don’t have the queuing problems that go along with them.
What your typical Linux system looked like in 2003. We've come so far
I think the fundamental issue is that a single 'cell' (value) can contain newlines, so you can't just assume each line is a 'row' and trivially parallelize.

The problem is perhaps most obvious when you consider that the value of a single cell could itself be a CSV, and this could be recursive
Won't it also kill you if you put something acidic in the bottle? Like water with a spritz of lemon? That's why copper pots have a lining, anyway.
https://en.m.wikipedia.org/wiki/Verdigris
AMD’s EPYC 7J13: Zen 3 Customized
We've all been there:

Them: Hello, <name>

8-16 hours pass

Me: Hello, did you need something?

8-16 hours pass

Them: How are you?

8- 16 hours pass

.....

https://www.nohello.com
I am not particularly opinionated on the matter and i think i can appreciate both sides of the argument.

SQL is somewhat analogous to C. It is entirely legitimate to look at its archaic usability features and wonder if we could not do better and at the same time it has hit a sweet spot of adaptation to the domain that ensured its longevity.

Something that might shake up things a bit is graph databases / query languages. We can think of them as a generalization of the sql universe and an opportunity to modernize it
Does something count as a Pizza when it doesn't even have tomato sauce?
"design patterns" and especially one specific pattern such as "object orientation" are just part of code, i.e., easy, according to GP.
Really the answer is to just quit working and become a hunter/gatherer, or travel the world.

I’m only half-joking.
I'm reading Nathan Myhrvold's excellent Book Modernist Pizza at the moment: https://modernistcuisine.com/books/modernist-pizza/

The book along with its excellent predecessor Modernist Bread and the companion podcasts to both do a great job of both illustrating the history of bread and pizza but also debunking a lot of popular myths about their origin.

A lot of pizza (and bread for that matter) traditions and styles are much more recent than you might think. I'd highly recommend the volumes to anyone curious about the topic.
OT, I just realised now we are in year 2023 a “century” house interpreted literally can apply to something built post-WWI. I wonder how the term would work going forward.
We can electrify the processes, make the power grid mostly green and require industrial processes to recycle most of its water. In fact the tech exists and the legislation exists and works.
It currently runs on SerenityOS, Linux and macOS. And Windows with WSL (I know, I know..)

We’ve also seen screenshots of Ladybird on FreeBSD, Haiku, and even Android at one point. Those are not maintained though, but we’ll come back to them eventually I’m sure :)
Not the original responder - hibernate has had projections to solve #1 for ages, the rest are on point IMO.
Counter-question: why should the UI style even be defined by your platform, and not by the user?

Why can't I install UI themes which makes the UI look like whatever I want? Why does the user interface of the Apple user next to me have to look exactly the same as mine?

(I'm also mainly an Apple user, and I don't like some 'traditional' Linux desktop clunkiness - mainly related to the touchpad - but criticizing a desktop environment (which the user is free to install or uninstall) for its looks is a bit ridiculous - especially from a user of a system where replacing the desktop environment isn't even possible).
That actually makes a lot of sense, I did not know that. Thank you!
Healthcare is very, very far from "an example of perfect competition". For example, there are apparently plentiful supplies of both drugs discussed in the article in China, but they can't be legally used because they don't have the appropriate FDA paperwork, purchasing agreements with the middlemen who distribute drugs, etc etc.
StinkyFish01
Unless you mean particular artwork called "Eiffel Tower At Night", Eiffel Tower is 3d object. Making photo of it gives you opportunity to involve your own creative invention. But photocopy of 2d artwork seems to me to be clearly just a copy, not a derivative that deserves own protection distinct from protection of the source art. Even more so than transcribed text of audio recording.
As a matter of fact, most European Uber drivers do exactly this. I'm from Poland and over last few years I've seen a single(!) Uber driver actually using built in navigation.
Also most of them also work for Bolt at the same time and juggle orders from both...
> But no-one uses different databases.

I do. And I use Hibernate to abstract over mysql and oracle, since I want to keep clients that use both.
You need a little more work than that, but it make it possible.
Hibernate is not the technology I love the most, but it does some non trivial work like managing the unit of work, graph caching and mapping that can be useful. It is also highly prone to be used wrong by devs.
You might not need hibernate, sometimes it might help. It should probably be used less than what you see in the wild, though.
KPIs adapt to circumstances but the thing about power is correct. I seen many power plays and the size of the "army" of the managers and how much they could assert control were important parts of them. If employees are dispersed they can't help the "generals" too much.
Query builders solve those problems without the complexity of ORMs.
There are Graphite-compatible monitoring systems, which use much more efficient storage format than Whisper. They resolve the most annoying issues associated with Graphite for large-scale setups - high disk IO and high disk space usage. See [1] and [2].

[1] https://github.com/go-graphite/carbon-clickhouse

[2] https://docs.victoriametrics.com/#graphite-api-usage
I really don't think there is any skill you can master in 6 months.

I am assuming OP already knew this and is not trying to be literal.
You started with the worse ORM in existance.

There are ORM with good pros/cons ratios out there. Python has espacially good ones:

- Django comes with a clunky and poor performing one, but it's very well integrated, super practical, productive and has nice ergonomics.

- Peewee gives you an ORM in a small package, which makes writing those little programs a joy when you don't need anything fancy, but feel lazy.

- SQLAlchemy requires a lot more investment, but is very flexible, generates clean SQL and has extremely correct behavior. It also exposes a lower level query builder for when you don't want the OOP paradigm and wish to express idiomatic SQL behavior, but abstracted away with Python.

This becomes a standard engineering decision, where you analyze the ROI.
The issue is that any Rust code is going to be targeted at performance processing (since otherwise you would write it in a higher level language). And for performance processing, you need to use unsafe (because at some point, the most efficient thing is getting or setting data at a certain memory address without anything extra). Look at any big Rust project, like Amazon Firecracker, and its littered with unsafes.
This is the same mentality that got UK to pass a referendum for Brexit.

As absurd an idea might be, it doesn't mean we can stand still and do nothing because we're sure the idea is so dumb it won't come to fruition. We need to fight it to prevent it from becoming a reality.
I live in an area where there is no air quality monitoring stations nearby, and was thinking about setting up my own little station to contribute the data.

I mostly look at aqicn.org and wondering if the airgradient kits can share data with that website?

I think I need someone to explain to me how some of these open source air quality monitors share their data and what websites can use the data.
Spiced flatbreads of the middle east are pretty damn good.

I think enough people, early enough, tried every combination of tasty things on bread. Oil and vinegar with bread were probably found thousands of years ago.

Tomato and corn don't arrive in the Old World until the early 16th c. Cheese goes back to 7th mill. BCE but was too expensive for most people.
Companies that expect people to work in an office will not compensate for commute time. Once employees gained the time which would have been spent on the commute to do other things including work & personal matters, it becomes difficult to justify sacrificing that time every day to improve "company culture".
Well I know there is no way to tell for sure, but just hacker to hacker did you use GPT to write it?
Nope. If it works and it's stupid, it's still stupid.

Just because companies can get stuff done in dumb ways doesn't mean those ways aren't dumb, it means that by brute force, sunk cost and obstinacy they can make things happen. There are any number of technical and non-technical dumb things in any large organization. You definitely can't assume something isn't dumb just because a company does it.

Noone is looking down on ORMs because they work, people are looking down on them because they don't work well enough to justify their downsides in most use cases. That's why people call it an anti-pattern. Yes you can get it to work but in general it's going to make things worse not better.

Now are some things that people call "anti-patterns" actually the right thing in certain circumstances? Absolutely. Just because something sucks in one situation doesn't mean it isn't the right choice in another.
Twitter's infuriating thing is that it flashes up "7 notifications" when you first load the page, then hides it for a few minutes, then shows it again. This is so tricksy. I assume they are trying to reward you for staying on the site.