skysight-inc/HackerNews huggingface dataset:
You can also not do anything risky at all and not worry about losing your housing. It's very comfortable to let life carry you around when you know that nothing bad can happen to you.

Pessimism aside, there's not much education about the whole concept of being an entrepreneur. Most people wouldn't even know where to start. Everyone is being pushed to either college or a trade school right after high school. Not once in high school has anyone told us that it was even possible to start your own company or startup. I think the concept is simply out of everyone mind.
I do B2B sales (specifically, customer support for consumer-facing businesses), and I'd pay ~$1,000/mo for a service that solves this problem:

Which warm intros should I ask for? There are ~1,000 companies in my ideal customer profile. I've got ~500 friends who I'd feel comfortable asking for warm intros, and say these friends each have ~500 friends. After deduplicating, that's ~100,000 second-degree connections, some of whom are decision-makers at companies I'd like to sell to.

I'd want someone to go through my LinkedIn/Facebook/Instagram/Twitter/etc., and tell me something along the lines of: "Ben might know decision-makers at Companies A, B, C, D, and E." And, conversely, I'd like to know all the possible warm introductions that could lead me to Company A (e.g. "Ben, Max, and Jennifer could possibly introduce you to Alice, Bob, and Cameron at Company A").

All of this information is available to me; it's just a total O(N^2) pain to clean and aggregate it. Like, I can certainly spend an hour listening to podcasts and looking through Ben's LinkedIn connections, Facebook friends, Instagram followers - and seeing if any of them are COOs at CPG brands. But I'll run out of podcasts eventually, and then it's not a very high-leverage use of my time to repeat that process for Max, Jennifer, Nate, Christy, et al.
"A database is an organized collection of data."

By definition. First sentence in wiki. I don't know what are your definitions.
The thread might have been fun of conspiracy theories, but the top comment the whole day was the one giving At&t the benefit of the doubt.

(Fwiw, I was personally on board with the conspiracy theorists.)
W.r.t. XMPP have you seen https://Conversations.im or https://dino.im? I'm using the former daily and the experience is very good, it's a modern messanger. Hangouts is stuck in the past.
Actually if you happen to ssh into the classical proprietary UNIX servers you might end up with plain old vi still.

But yeah, that is why even I as Emacs user always bothered to at least know my way around vi, usually Emacs is most likely not installed.
>Smart computer scientists go to silicon valley

Is it really that easy though for the rest of the world? As an european developer AFIAK there a basically two visas

* H-1B: Hard to get the quota as some big companies abuse it for cheap work

* L-1: Requires 1 year of working at the european branch of the company

H-1B seems really difficult to get, is the L1 easier? At the end of my studies at the moment and considered Silicon Valley, but dismissed the idea due to visa issues and the high cost of living.
You can help the optimizer stumbling by running ANALYZE [1] with representative data present, and turning off auto-analyze. This was intentionally designed as a feature so you could set up the statistics for a db, empty it, deploy it out to the end user and know that the optimizer isn't gonna go off and do something funky.

[1]: https://www.sqlite.org/lang_analyze.html
Because visa agreements made before (H1-B) and after (E-3) this one, by Republicans no less, have included spouse's right to work.
Perhaps you're mistaken? The results discussed in the article claim the opposite, and point out:

"Their first conclusion was that athletes are lousy at identifying whether and why they are sniffling. The original 1980s studies had relied on runners’ self-reports of illness. But newer experiments that actually tested saliva showed that less than a third of marathon runners who thought they had caught a cold actually had. Statistically, their odds of becoming sick were about the same as for anyone else in the race’s host city.

The athletes probably had misinterpreted allergies or short-term scratchiness in their airways after the race as a cold, says John Campbell, a professor at the University of Bath who was a co-author of the new review."
> efficent immigration

A couple of years ago I had to take a connected flight where one of the stops was in USA. I was never going to leave the airport, yet I had to form in a line while immigration was doing the routine bottleneck check on dozens of travelers, while my flight time was getting dangerously close. We just had to suck it up, any complaining just brought additional delays. The check was fairly automated, I guess they just needed more agents, or less gratuitous revisions.
The question is not about where FoundationDB can run in general. Sorry if that was unclear.

The question is about (public?) continuous integration testing for changes to FDB against macOS specifically, eg for pull-requests (for example, to allow contributors to make changes targeting other platforms without needing to own a mac for local tests).
The big tech hubs in CA (Toronto, Vancouver) are expensive and traffic is absolutely awful. A quick glance online shows average apartment prices are nearly $2000/mo. So it's almost like you're living in Seattle anyway.

I don't think CA has many technical equivalents to Ohama or Columbus that combine high salaries from numerous F500 companies with Midwestern COL.
I like Oni but last time (a week ago) I tried it I went into the config file to change the colourscheme and the doc wasn't helpful at all. I think it somehow can take a vim config file but it wasn't really clear.
Introducing Dojo 2.0
My point is that it's not possible to write code that works in C if you don't actually target the C abstract machine, unless you're using compiler extensions. It's not even about portability, as my example shows, it's just about basic correctness and having your code behave as expected. Knowing what kind of assembly to expect as the output of the compiler for a given C code is a useful skill for an advanced C programmer looking to write optimized programs but it's really an advanced topic. When I learned C in high school I only had a very fuzzy understanding of what a register was and how memory worked, it didn't stop me from writing useful C code.

That's why I think it's a bad idea to give all these nitty-gritty details about CPU registers and the way the heap and stack are laid out in RAM because in practice C doesn't say anything about that (well, there's the register keyword I suppose). For a C tutorial it's more important to teach the C abstract machine and its rules than the way they map to a given piece of hardware.

Take for instance this sentence from the article:

>You can even tell the compiler to make sure it has an initial value. If you don't, its value may be random garbage that was there before in memory.

I don't think that's a good thing to say. What you want to say is that the value is undefined and reading it is forbidden because that's what it really is. If you decide to use an undefined value somewhere in your code the compiler might swoop in and optimize it away, not use "random garbage that was there before in memory". Undefined is not random, undefined is not garbage, undefined is undefined. You might print it twice and get two different results. You might have a condition "if (uninitialized > 0)" and a condition "if (uninitialized <= 0)" and both may run, or maybe none will. Because there's no such thing as "random garbage in memory" in the C abstract machine, only defined and undefined values which are semantically different.
[video] Is disney the Amazon of entertainment?
That seems like an outlandishly high number. Where did you get that? You're saying that close to 25-33% of foreigners in the bay are Canadian.
I'm a Canadian software engineer working in Seattle. One time on a flight back to the homeland I sat next to a Canadian tech VC. We spoke about the tech scene in Canada, and eventually she started complaining about how all the good engineers leave for the States. I mentioned my experience with the massive 50% pay gap in software engineer salaries, and she said something about how it was the fault of the exchange rate and couldn't be helped. It was a ridiculous excuse and the conversation died pretty quickly after that. If VCs want tech talent, they better pony up the money.
I would also like to outlaw advertising in the following places: the in-flight announcements of airplanes, the loud, blaring tv kiosks at gas stations, and during movie previews.

In other words, create a modicum of public space which doesn’t have constant, intrusive noise.
It looks like this isn't FOSS ($50 for a single website per year). The hosting structure is the same (self-hosted/you are on your own). Compared to Matomo this seems to work on SQLite in addition to MySQL.
How to be great at asking coding questions
Show HN: Serverless Components – easiest way to build apps with cloud services
Show HN: Vuetify color theme explorer
Actually in the US, rural areas are served pretty well by AmTrak as a principal way of getting to big city airports (although more expensive than a drive, AmTrak is way cheaper than using a rural airport to connect to a flight).

But if you live in rural areas, you're choosing to require a vehicle. That's fine. But in cities, are transport is shit in the US.

Even with rural areas, Northern Indiana has the same population density of Scottland. It could easily utilize a decent intercity rail system. The US use to have more passenger track at one time than Western Europe has today!

We had rail once. It went away and we spread out, but if we rebuild it, people will start living closer to it and everyone can benefit.

I think once the US hits a really hard economic collapse (not that piddly one in 2008 the banks just used to buy other banks) is the only time when US politicians will be forced to fix infrastructure (because the poor literally won't be able to go to work, and politicians really only care about the poor once they're no longer generating taxable revenue they can feed to their supporters). Once that happens you will see things change very fast, but things do have to get considerably worse before politicians invest in people.
Software development infrastructure in a box plus strong training materials / guidance for scientists. Increasing numbers of scientists are writing code without any formal CS training, and the outputs are predictably awful and unreliable. It is very common to find no testing, no acceptance criteria, no version control, no formal planning, no code review, no style guide being employed, sparse commenting, fragmented development environments / dependency hell etc. People frequently know that what they are doing is suboptimal, but it is hard to convince them that they should put in the work to use industry best practices for a variety of reasons.

If someone could create a product (probably infrastructure plus a Python IDE) which made doing things the "right way" easy for these users, and which would provide case studies or tutorials to show them WHY doing things correctly is beneficial using analogies to good lab behavior, it would be hugely valuable.
> soul crushingly demotivating

Probably a motivator to get a better / real job? I certainly prefer that over UBI
Salaries between Vancouver BC, and Seattle look to be comparable:

https://www.glassdoor.ca/Salary/Amazon-Vancouver-Salaries-EI...
https://www.glassdoor.ca/Salary/Amazon-Seattle-Salaries-EI_I...
The cost of living between Vancouver and Seattle is very comparable, especially when you account for your biggest input costs, housing, food & transportation. The Salaries most definitely are not. The biggies south of the border set the baseline salary for everyone; when they move north they match the existing, much lower rates.

If I was a new-ish grad and wanted to stay in the PNW there's not a chance I'd pick Vancouver. Seattle has all the same electric cars, dog bakeries and yarn stores that you'll find in the lower mainland, and heading to Whistler for the weekend with more US greenbacks in your pocket would be a lot more fun...
Here are Arxiv pre-prints, which are still a bit different from the published versions:

https://arxiv.org/abs/1802.00126

https://arxiv.org/abs/1802.00457
I'm actually working on a project that's in the process of migrating from SQLite to MySQL as the preferred DB. I'll admit that the reasons we're doing it are probably not applicable to a desktop application like this.

The real wins for us are multithreaded and multiprocess DB I/O. This is something MySQL can handle, but SQLite really isn't designed to do well or efficiently.
Define fairly competent - Is it 4-5 years of experience on production scale system with great traits like commenting, documenting, automated testing and owning code? Or is it something closer to 2-3 years of experience, worked for a company didn't own much code? Market is hot at the moment for the former.

My company is hiring a remote web developer - if you're interested. Salary goes between 80-100k depending on experience. Contact is in my profile.
Canadian here. I get $65,000 USD from my remote American job. That's low enough that people on this forum snicker at me, and high enough that companies in the "tech town" that I live in physically wince when I tell them my salary expectation. I'd rather work locally, but what can I do?
Where does one get Mecanum wheels of a size (durability) suitable for robots?
> I follow what you're getting at, but don't you think a large part of that is due to your own attitudes/perception?

I bet that's part of it, but probably also tied to the general population shift south and to the coasts where the weather is nicer.
Yeah. To be clear, I think even a 150GB sqlite database would perform just fine for beets' purposes.
Ask HN: How do I get out of this self-imposed career rut?
This is hard to even talk about.

I'm a software engineer. I've been doing this job for 20 years. I actually started programming when I was very young, about 35 years ago. By all measures, I should be very advanced career-wise, but I'm being held back by imposter syndrome, low self esteem and social anxiety.

I feel like I'm unable to progress beyond the "Senior Software Engineer" level. Whenever I look at job ads for principle or lead roles, I can't help but think that I don't have the leadership experience or confidence to even make it worth applying.

I'm also a generalist, and while I have an uncommonly wide background (everything from front end to firmware, network engineering, system administration and security) that does mean that I'm not really an expert in anything.

I just started looking for a new job, and while I'm talking to companies like Amazon and Google, I'm finding it hard to really sell myself.

How do I get out of this rut and progress my career to a level commensurate with my experience?
It’s ridiculous how Manhattan is always brought up as the thing to avoid, when Manhattan has much more humanity and interesting activities than San Francisco.

The problem with Manhattan is that zoning trapped Manhattan in amber, along with most of the cities in the US, so it is no longer responsive to grow with demand.
Replacing CSV with SQLite is one of my goals for the combination of https://github.com/simonw/datasette and https://github.com/simonw/csvs-to-sqlite
And better weather and the cachet of being in a world city.

The brain drain has been going on for decades now...
But lately, the general Canadian media has claimed there is a reversal.
One case in point is Montreal being proclaimed an "AI Hub". It's considered an "AI hub" mainly because of one of the fathers of AI is from there (and one his students coming up with the concept of Adversial networks) and a few companies opening satellite AI branches such as Google and Microsoft. Nonetheless, that likely amounts to a few hundred jobs at best, involved in cutting-hedge AI/ML/DL. Toronto also has a few well-known AI research centers. And these centers haven't seemed to have produced noticeable concrete results. But only time will tell if these pan out, and more importantly produce enough jobs to keep local talent, which in my mind is still very doubtful.
You are not your goals
Not OP, but worked in the field for a time. Trafficking usually means configuring your ad in the campaign management system. What are your targeting parameters, what are your tracking tags, uploading the ad itself, entering in lots of custom information that while conceptually similar across ad platforms usually has different names and often has to be manually entered. A lot of platforms do offer APIs of some sort to help with bulk campaign/ad creation, but there's often no "one stop shop" to be able to set up a google campaign and facebook campaign at the same time. There are some companies working on this, I think usually referred to as (or in conjunction with) "marketing automation".

A mistake can mean - misconfiguring your target (wasting money on ads that won't give you an ROI), misconfiguring your 3rd party tracking (letting data like conversions go unaccounted for, or not having your auditing tags setup, meaning you show ads to fraudulent users that you otherwise wouldn't have to pay for), etc.
Canada's main attraction is the social services and basicaly guaranteed citizenship. The US's main attraction is money and technical opportunities and also some vague promise of a green card.
Oh great so they're only losing the best then?
Linkedin is addictive for a lot of people in sales and business.
Same here in Germany. Talent usually goes to Switzerland or California.
The problem is that management in these companies consider the defunct state of affairs normal. Usually they just consider software just as a external service sadly demanded by the customer.
Your first point is good. I should have stated that "Hypothetical Best Possible Human Driver" has been established. We can do a lot to improve safety in the average driver. But human reaction times, spacial awareness have hard limits. You can only react so fast, and you can only look at what your two eyes can show you at once. Once the average driver starts to approach the best possible human driver, improvements will be very hard to come by.

But your second point, if humans are dumb, their tech will be dumb is demonstrably false. Groups of idiots can collaborate to make 1 fantastic solution to a problem. Or a solution that improves over time. Software also tends to have fairly stable performance, except for specific outages. Where a human may have the capability to be a safe driver, but performance varies drastically based on mood, age, distraction.

I could definitely be wrong. But I would be comfortable betting every penny I have that automated driving will be safer even the best human drivers in 20 years. No one can know the future, but betting on human power instead of technology has been a losing strategy since the printing press was invented.
You haven't driven stick shift until you have driven stick shift in Europe. Extra points if you change gears with the left hand.
Do time crystal exist in higher dimensions than 3d since it has quantum properties? How would time crystals behave in those higher dimensions?
I'm guessing that's probably not apathy but quite the opposite - outright collusion - they care, but about keeping it running rather than shutting it down..
Thank you both for sharing your experiences.

You confirm my concerns and, really, my expectations as well.
Me and most of my engineering friends faced this decision 5 years ago. We all had to decide between offers from one of the big 5, or remaining in the Toronto-Waterloo region. I'm the only one who stayed. And that's only because I was presented with a really interesting opportunity not available to most.

I can only speak to the University of Waterloo, but there was this idea that the only goal worth perusing was a cali job. 'Cali or Bust' was one of those sayings that was said jokingly, but you know, people were also kind of serious about it. Even really great paying jobs in Toronto or Waterloo are not as desirable as the exact same position out west.
https://en.wikiquote.org/wiki/The_General_Theory_of_Employme...

"If the Treasury were to fill old bottles with banknotes, bury them at suitable depths in disused coal mines which are then filled up to the surface with town rubbish, and leave it private enterprise on well tried principles of laissez-faire to dig the notes up again (the right to do so being obtained, of course, by tendering for leases of the note-bearing territory), there need be no more unemployment and, with the help of the repercussions, the real income of the community, and its capital wealth also, would probably become a good deal greater than it actually is."
Something I didn't know until recently is how much better the wages are for Canadians that work as contractors to large companies/banks that bill to their own companies. I understand that this is probably out of reach to younger folks with no experience but finally realized the appeal of a contractor here.
Canada is in a really tough spot here. I've always admired Canadian culture/values, and in the abstract, would love to live in Canada one day. However, as a Software developer, the compensation and opportunities that one can find in SF/Seattle/NYC dwarf anything in Canada. Until this changes, Canada is always going to lose its brightest engineers, which will in turn worsen the problem even further.

Some solutions I can think of, which might help:

- Aggressively pursue the brightest non-American engineers, who are hesitant to move to USA because of immigration restrictions.

- Offer very lucrative perks to the major software companies, to expand their engineering presence in Canada. Yes, it stinks having to offer tax-breaks, but at least it will help build initial momentum.

- Aggressively encourage/fund/facilitate startups. Unlike salaried employees, startups aren't turned off by the low-engineering-wages. Once Canada can grow 5-10 startups into major established companies with Canadian HQs, that will really boost the local engineering ecosystem and job market.
For me, its been about rekindling the desire to make/do things and hack around like I used to love doing, instead of twitch, HN, tv, etc.
This is like what happened before the big bang.
The .db file can change, even if the data/records don't.
One approach is to dump the sql to text and store that in git. (e.g. https://stackoverflow.com/a/846665)
How to Burn Down the Two-Party System (2016)
I see you stand strong against people who say the right things with impolite words. Fine, your choice. But honestly, the more i watch these things the more i notice that you NEVER stand as strong against people who say vile hateful things in nice words.

Given this, it shouldn't be a surprise to you that people feel more and more that it's not worth to try and make an effort to stay nice if that's how "the top" behaves.
> Any run-of-the-mill engineer can design something which is elegant. A good engineer designs systems to be efficient. A great engineer designs them to be effective.

This is awesome. I don't know how many times I've seen over engineering in the field. It's crazy. Well we may one day want to do X.
I am surprised no one has mentioned mastodon. Organizations or individuals can set up their own server and people can interact with their local communities that can police and or use the data as they want, AND there is a federated feed of all the mastodon instances where you interact in a public forum.
> Actually if you happen to ssh into the classical proprietary UNIX servers you might end up with plain old vi still.

Let's be honest: out of 10000000000's of SSH connections in a given 24 hours span, how many are to a "classical proprietary UNIX server"? 0.0001% maybe ? Is it really a use case worth optimizing for ? They should be treated as applicances, not as general-purpose computers.