skysight-inc/HackerNews huggingface dataset:
> Facebook simply integrates their model into FB/Instagram

FB got away with it because Vine and Snap had really awful UX.

I don't remember an app that lasted less time on my phone than Vine, it's almost like it was made exclusively for people glued on their phone all day. Sound on by default? REALLY?
Not to mention the capability to execute any arbitrary executable.
I'm not a big believer in conspiracy theories and I'm the first to admit that this could be entirely coincidental.

However, my gut feeling is that that some of these statements were so unusually phrased or just plain strange that I'm leaning more towards this being a deliberate effort to obscure some unfavourable stories.
More like clickbait. Reading the title might give you the idea that using Vim is wrong. The article then proceeds to tell you that how people get started with Vim is wrong.
Reminds me of the cartoons in Tektronix manuals:

http://w140.com/tekwiki/wiki/Tektronix_Cartoons

I think it was recently discussed on HN.
If your database contains objects like "customer ID", "address" and the like, you already have business considerations (if not logic) inside it. In fact, businesses using databases for business stuff is probably 95% of DB use cases.

If it's something that's not application-specific and fits nicely into the query language (like in the example given) it makes sense to have it inside the DB, because for queries involving sorting, limiting, etc. you can do all that stuff inside the DB and return the few values that interest you, instead of transferring all the data and having to write code to do that inside your app.
Indeed. SQL concepts are insanely powerful, but the language itself feels a little bit old.
Enums and string literals aren't completely interchangable.

Enums are transpired to objects so you can iterate the keys/values. You can't do that with SL which are a transpiler feature only.

Also you can't codedoc string literal values like you can with enums where it shows up with intellisense.

I tend to prefer enums as a result
Get unused routes of your Rails App
The post is from 2010, today in 2019, I'd say that first step could be to install a vim extension in your already existing IDE/editor, VSCode and Idea have good enough vim plugins to start learning insert mode and moving around, and even allow you to search and replace :%s/termA/termB/g
You can also play Vim Adventures[1] if you want to be even more playful.

[1] https://vim-adventures.com/
>> depression comes when you are only applying logic to life and essentially seeing that there is no meaning to it.

Depression is not a question of philosophy of your life.

Philosophy may help you approach the depression, but you can’t get depressed because life is too logical - you may get sad, on the other hand.
Suade |London|Full-time|Onsite

About Suade:
We are a FinTech/RegTech company based in London using modern technologies to develop cutting edge software for regulatory reporting and compliance. We’ve had some notable achievements this year including being selected as part of the FinTech 50 for the third year in a row as well as being recognised by the World Economic Forum as a Technology Pioneer which is a huge honour. other notable examples of past Pioneers including Google (2001), Twitter (2009), Palantir Technologies (2010) and Dropbox (2011).
We are always looking to hire talented individuals and we currently have the following vacancies:
Backend Developer
Front-End Picasso
Regtech Engineer
Linux Orchestrator

Please find the links to our job descriptions https://suade.org/journal/#lead
To apply, please send your CV to work@suade.org
When I switched to Vim, I was at 1/3 of my usual productivity for the first week, and I think at about 1/2 for the first month - author is completely true about that. However, since then, I've been so much more productive over next 7 years that it had definetly been a good decision.

And I don't even use Vim now! Visual Studio, VS Code, all JetBrain editors have competent vim emulation plugins, so the core of my ehnanced productivity, the core and most important feature of Vim, is still paying off.

I just wish I had a spare year to learn and configure Emacs. (Yes, I have tried Spacemacs and other options, many times, and it was so confusing every time that I only believe in learning Emacs from absolute basics withut any plugins now).
Learning a good editor is an investment. You sacrifice some productivity and time now for a massive return on your investment later. Stating the obvious, I know, but so is this article.
One legitimate use case could be calculated values that you want to use in several apps (written in different languages) and in SQL reporting.
Increasing, however.

Gender parity by 2070.

According to Penny Gilbert, partner at intellectual property law firm Powell & Gilbert, it's simply a pipeline issue.

"If we want to see more women filing patents, then we need to see more women taking up Stem subjects at university and going on to careers in research," she says.

Currently only about a quarter of the UK workforce in Stem industries is female and fewer girls and women study these subjects at secondary school and university, despite efforts to diagnose and solve this imbalance.
Baseball Saw a Million More Empty Seats. Does It Matter?
Vim is a tool like any other tool. Well, a powerful tool. Having a good editor is essential when working with text. For any task pick the right tool for the job. An expert task requires expert tools. There are many good expert tools. Pick your poison.
> But after contemplating it, is this really necessary?

No, you could always do the materialized equivalent via triggers, so it's not necessary for correctness. And since this feature is limited to the materialized form, too, it doesn't offer much change other than simpler expression of what is going on (which, to be fair, is a big win.)

> I fear for putting business logic and meanings into the wrong the layer

If you don't have some mechanism for calculated columns, you are forced to put domain logic that belongs in the DB in the app layer, which is especially problematic in the (increasingly out of fashion, apparently) circumstance where there are multiple consumers of a DB, as it promotes inconsistency.
I was on tiktok for a couple months and never saw anything like that! Lots of memes and some really creative stuff with music and sketching but absolutely nothing pornographic.
The Hitchhiker’s Guide to the Galaxy: 40 years of parody and predictions
I disagree. This is just an extreme example, but take it down one or two levels and it's extremely common.

Ruby has had this kind of syntax since forever and it's one of the things that people love about it.

> The problem might be that we have most likely not yet handled the edge case situation where a.b and a.b.c doesn't exist

That's not an edge case, that's an expected case. If it doesn't exist, nothing is supposed to happen.
> The MemorEM device is being developed by NeuroEM Therapeutics, and we should point out that two of the authors behind the new study founded the company – so there is some vested commercial interest here.

Nevertheless, the results seem promising in spite of the ridiculously small number of participants, and if other researchers are able to replicate them - that is, if the original study has enough details to build a device with identical EM function - and confirm the results, especially the lack of side-effects claimed by the team, this could be great news to all of us.
I think there's an sql injection in your /settings route. feed-query also looks extremely sketchy too. In general never build queries with javascript template strings from unsanitized user input.
As an aside... I am still a huge fan of Coffeescript as my main driver. I'm learning more about TypeScript and Rust, but Coffeescript remains my language for concision/expression :)

All of the above need method chaining, though:

https://en.wikipedia.org/wiki/Method_chaining
I use Sky. I wasn't aware of this. :(

I also use my own router so I assume it doesn't affect me or does this mean that their network doesn't allow other DNS servers?

How would that affect a VPN? I use PIA and they have their own DNS servers.

I'll need to experiment with this when I get home I think.
Live Interview with Startup Founders Jillian and Gary from Safe&the City [video]
This is a quite detailed article with some great photos. It really shows the cultural harmony there. However, there are bunch of wrong claims and inaccuracies about the politics of the region and some parts are downright offensive.
> The paperwork is a strong incentive to avoid keeping data you don't need.

The paperwork is a modest incentive to avoid keeping data Google doesn't need. The problem is that what people need is not necessarily the same as what Google's surveillance and manipulation profit machine needs.

I don't need Google to keep a hyper-detailed record of every site I visit, but Google's business model means that they "need" to do it. So they do.

>> And Google's employees have a large incentive to not see any issues with collecting all the personal information that exists.

You see, Googlers are incentivized not to see the ethical catastrophe that is collecting the data they "need" to collect in order to implement and enhance Google's surveillance and manipulation profit machine.

Sure, if some data are irrelevant to the surveillance and manipulation profit machine, there is a modest incentive not to collect those data. The problem is that Google "needs" a great deal of highly personal, sensitive data whose aggregation poses societal risks that can hardly be overstated. But, since Google--and therefore, Googlers' salaries, bonuses, and RSU gains--"needs" those data, Googlers are incentivized to rationalize its collection, aggregation, and exploitation.
Airbnb Leans Toward Direct Listing over Traditional IPO
An NSLOOKUP will tell you the DNS server that your query went to.
Good question. I’m not sure I care if I’m honest. It tastes pretty good and keeps me alive :)
The related article about using CPU alignment checking for "type checking" tagged pointers is quite interesting. I wonder if this technique has been used before (in lisp machines or something?). I'd be interested in hearing about practical matters like performance and CPU support too.

https://weinholt.se/articles/alignment-check/
Linux Security Summit 2019: Writing Linux Kernel Modules in Safe Rust
Arguably, a robust RDBMS with user defined functions (such as PostgreSQL) are the ideal place for core domain semantics.

What is missing is a modern tool chain that addresses the painpoints of such a development model.
Why do you think placing business logic into the database system is a layering violation?

Just because most developers use their DB as a dumb store doesn't mean it needs to be. There are also plenty of successful software systems that place the majority of their business logic and use a generic programming language and runtime only for the presentation layer.

If you're comfortable fully exploiting the capabilities of your DB, then the intelligent combination of a relational model with custom data types, constraints, triggers, views and stored procedures can make the DB the perfect place to implement business logic.
I believe you mean National Semiconductor

NI is an instrumentation board maker that got started in the 80's.
I’m not saying this is the right solution, but we do face the problem of application-calculated attributes that have meaning in an API and in the application, but are not persisted to disk. A trivial example from our education domain might be % correct, assuming we’ve persisted the possible score and an achieved score on a question or test.

When we ELT to the data warehouse, analysts and internal users want to report on reason about these calculations. But then we face the quandary — do we re-implement that business logic in the ELT? Or do we go back and make sure we persist everything, even these values that are so quick and light to calculate and build in the application later? Or do we (shudder) make the ELT load from a bulk API, rather than just copying across the DB?

I could imagine someone talking themselves into using these calculated columns as a solution. I wouldn’t recommend it, but I can see the ELT problem prompting it.
Twitter bought then killed vine...
FORTRAN has some "beautiful" implicit typing rules. Most FORTRAN programmers will disable this with an `implicit none` statement because nobody likes the type of the variable being defined by which character it starts with. So, if the implicit typing rules are in play, i,j,k are definitely integers, otherwise they can be something else.

Offhand, (it has been a long time since I programmed in FORTRAN) I do not know how the scoping rules regarding `implicit none` function with globals. Presumably i, j, k are integers (which would be the implicit type) so it might not be a problem, but they are also often used as basis vectors... so they might be vectors and `implicit none` becomes important.

Also possible, you are dealing with some really old FORTRAN60 compatible code and they are actually iteration control variables and a subroutine wrapped around an arithmetic if is advancing the control variables (which is why they are in global scope) and the outer arithmetic if is performing the branch control as an ur-for loop with gotos. This was the original spaghetti code.
Please Follow on Twitter Sensors
> It is written in R6RS Scheme and a wafer thin amount of assembly. Once it has been bootstrapped it can self-compile. There is no C code in the compiler or the runtime.

> ...multiboot binaries for bare hardware

Multiple brownie points combo!

Congratulations on the work achieved.
But tbh our school system just teaches a baseline of abilities we think our youths should know.
I honestly don't believe pupils are expected to know everything besides what was agreed on...
Why is this not obvious to everybody?
Why we switched from Spacy to Flair to anonymize French case law
I found this book to be very helpful, I'm not done yet but so far I'm really enjoying it.

"Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity."

https://www.amazon.com/Joe-Celkos-Thinking-Sets-Management/d...
There is definitely room for a scheme compiler. But the scheme ecosystem felt extremely fractured the last time I took a look. Chicken had a decent but aging repo. Chez had a great compiler (I prefer not compiling to C) but it's package ecosystem was not something well advertised if it did have one. Racket has too many dialects which might appeal to some but found the number of sub languages overwhelming for a casual schemer.
>The obvious answer is...

Did you know that there are massive streams of CO2 available for the taking?

https://www.reuters.com/article/us-australia-lng-carbon-fb/f...
Due to shared hosting you can't map every IP to a hostname, and encrypted SNI is a thing.
> IMO these types of calcs are better done in your app, where you can at least write a test and assert it's doing the right thing.

I can write a test for the db logic, too.

> It also makes it a lot easier to reason about your code if the logic is in the app rather than bits of it stuck in column definitions.

Its a lot easier to be confident that all consumers of the DB, regardless of whether they are coming through a particular app, have the correct view of the data if the non-app-specific domain logic is in the database.
It really depends on what your app does, and how software development is structured at your company.

In general though, materialized views and computed columns are much more useful for reporting than replacing application logic.

They also can be useful to smooth out upgrading line-of-buisness software, where say the old system needs several separate values, but the new system only needs 1, and derives the others. You would use something like this to make the 2 systems play nice until the migration is complete.
HackerRank | Bangalore, India | Fulltime | Senior/Lead DevOPs | ONSITE | www.hackerrank.com

HackerRank is a Y Combinator alumnus backed by tier one Silicon Valley VCs. We are a skills-based hiring platform that helps companies evaluate technical skills, better. We’re driving a new paradigm shift by eliminating resumes and creating opportunities for hundreds of thousands of programmers worldwide. We have a community of 5M+ developers and 1,000+ customers across industries, and the best part is we are just getting started. Our customers - including VMware, Twitter, Capital One and many other Fortune 100 companies - rely on HackerRank to build strong engineering teams.

We're hiring across engineering for the following roles:

- Senior/Lead DevOps - SE: Frontend lead/architect, with a focus on React.

Good pay with following benefits:

- Insurance to all Employees (term life, personal accident, medical, gratuity) along with insurance to their dependents(medical).

- Employee stock options, flexible work hours and time off.

- Tech talks every week.

- Onsite gym, telephone, internet etc. Our pantry is stocked with healthy snacks, fruits, Coffee and free catered lunch every day.

- Ping pong, hoverboard, foosball, PS4 and many office celebrations like Mafia games, outings, movie evenings to name a few!

Please send an email to anil@hackerrank.com with "WHOISHIRING" in the subject line, with your resume/CV, and a little bit about yourself and relevant experience.
I'm a simpleton when it comes to AI/ML, but this was pretty impressive to me! It's really interesting how well this seems to have paired up because the portraits, while generic-ish, do seem like they're legitimate human creations. There's probably an overworked animation studio out there that would be interested in this.
I think it aged insanely well. DBs are often a bottleneck and need to be heavily optimized so you need to spend some time explaining to your database what it is that you really need, but in general, SQL is all about telling what do you want and not worrying about how it's going to get done. That's how programming languages should look like.

We have so many ORMs and most often they look more ugly than pure SQL to me, especially when it comes to more complex queries.

You could write a translator (something like coffeescript -> JS but X -> SQL), but can you really come up with a syntax that's enough of an improvement that it would be worth using it?
Location: London, UK

Remote: Sure, not particularly looking but open.

Willing to relocate: No

Technologies:

- Development: Git, Docker, SSH, Bash, macOS, Linux

- Programming: JavaScript, Python, Solidity, SQL, Go

- Markup: HTML, CSS, Pug/Jade, Markdown

- Frontend: jQuery, Bootstrap, SemanticUI, Webpack

- Web & Mobile: Node.JS, React/Redux, React Native, GraphQL

- Databases: MongoDB, DynamoDB, PostgreSQL, MySQL

- Cloud: AWS, GCP, DigitalOcean, Heroku

Résumé/CV:

Versatile software engineer and cloud solutions architect with 6
years of experience building applications and managing complex architectures. Focused in React/RN, Javascript, Linux and AWS (CSAA). Interested in Fintech and Cybersec

https://drive.google.com/file/d/1KaEG6cj7N-fV6sPOcDc62sqdP17...

https://oschvr.com

http://github.com/oschvr

https://stackoverflow.com/users/3356769/oschvr

Email: oscarchavezromero@gmail.com
As an analyst, either for reporting or machine learning tasks, it scratches my itch.

I'm often creating wide, flat views with extended attributes. Many columns are nearly identical, for example, year as an integer, year a date type, etc. This is trivial with views, but ...

For fast query performance, I usually materialize those views. But that's a multi-step and often manual process, requiring schedules or triggers. This feature combines both of those worlds, with fewer total database objects. Especially with ALTER TABLE.
if TS can recognize the difference between the last two, why have an `asserts` annotation at all?
I keep reading about productivity on vi vs other browsers. That's cool, however the thing that makes me want to use vi with proficiency is another though: availability. I spend a lot of time in ssh or docker sessions and not knowing vi can severely hinder my job.
The color palette makes it look like a video game.
If TikTok is the new Vine than who is the next David Dobrik?
Agreed. After all, if you wanted to keep all "business logic" out of the db you wouldn't even use foreign key constraints.
I thought this was a counter-thread to the Who wants to be hired one lol
Feels like a natural part of the late stage of the credit cycle (FOMO).

Read this somewhere: in 1999 risk meant bumping into someone and finding out he/she makes more money daytrading stocks. In 2002 it meant owning stocks.
I assume he means the title. It's clearly clickbait at the very least.
Location: Pakistan
Remote: Yes
Willing to relocate: Yes
Technologies: Full stack software and web developer
.Net, ASP.Net, C#, SQL server, DevOps, TFS, Git, Javascript, Jquery
Résumé/CV: https://drive.google.com/file/d/1tAA8kaEL80DmujRPJC6doWDc0sM1CBPG/view?usp=sharing
Email: zakhc1@gmail.com
From Safari I expect you're on a Mac. In that case either wait for release 70 or install beta. (And possibly enable webrender as well) The difference is massive in both cpu and energy usage.
Be honest, isn't carbon capture a big distraction and was only mentioned for the media.
I much prefer it to arcane JS(ON) query formats someone dreamed up in a hurry, only to avoid SQL. Only exception I can think of was RethinkDB
And it doesn't even tell you the substance. If you say "super glue", I have no idea what to do. If you say "cyanoacrylate", I can get it for a euro.
AlleAktien.de | Software Engineer, Web Vue.JS | REMOTE | ONSITE/Singapore/Munich | Full Time | https://www.alleaktien.de
At AlleAktien.de we're providing German retail and institutional investors with "Germany's best equity research" (according to our members) >> https://www.alleaktien.de/lp2

We analyze mostly S&P500 and Chinese companies in a fundamental way and a very long-term (10-15+ years) perspective, to enable (private) investors to make the best possible investment decisions.

As our first Web Engineer (Vue.JS/React), you will be first-on-platform helping shape and build our Websit from scratch. We've built a great WEB experience already and our customers love and recommend us. We've found product-market-fit and have a strong and steady monthly MRR growth north of 35% since 1.5 years. You'll lead the design of a quantitative finance platform which will display long-term company financials (revenue, EBIT, profit, debt, dividends, ... over last 30 years)

Read more here: https://www.alleaktien.de Or contact me: michael at alleaktien dot de
Oh, can I resist..
Nope, sorry.
Everyone who tried to convince me to use vim plugins was wrong. Keep it clean :)
Vim is my daily driver for programming, which is my job, in my office we're 2 using vim, we exchange tips and tricks sometimes, and ask questions that are exceedingly specific, and it just becomes nicer and nicer to work with text as I get better. I do need to experiment with multi-line cursor, that I mess from vscode studio.

The article is well written, and the authors has a good point. I don't think there are that many situations where "dive in head first" is that good of an idea.. Slip in where you can find ground, and work your way out until you learn to swim. I'd never switch off my cursor keys, I don't CARE if it's supposed to be more efficient. That's how I feel right now, maybe one day, I'll feel different, but if I do, I won't recommend any new users to do the same, that's just silly.. I mean, that'd do nothing but scare them away and make their lives miserable.
I don't think a site like HN should be rewarding sites for using clickbaity titles. Maybe it's just me.
tiktok feed will show you what it thinks you want to see more of based on your past behavior. It looks like you and the parent commenter have different viewing habits!