skysight-inc/HackerNews huggingface dataset:
I have found that this is one of the most redeeming qualities of Next Door. Among the people selling "gently used" crap that no one would even take for free, the NIMBY crowd, the easy racism under the guise of neighborhood watch, the MLM moms, and the "THINK OF THE CHILDEN" crowd, Next Door has been spot on for recommendations.

There are small business owners who make posts every two weeks are so about their super amazing lawn care business providing 10x the quality of TruGreen, but if you ask for recommendations, people flock in droves on both sides. Users give glowing praises for good experiences, and they will absolutely crucify a business for bad experiences. Sometimes you have to tease out details, but it's way better than a context-free review post to Google or Yelp.

It's very common for a review on a website to have a business with a 4 star rating and a couple negative reviews. The negative reviews will only say something like, "Terrible experience. I will never user ${business} again!" Thanks buddy! You've given me 0 reasons to avoid this place. Next Door allows you to engage other locals on why the experience was poor.

I just hope that Next Door doesn't try to pivot and capitalize on this. The system in place is perfect for recommendations, and I would hate for them to create some weird Yelp-esque review system within the app.

Edit: This isn't confined to Next Door. Any forum where you can engage neighbors or locals with conversation will be better than a review site. People rarely go into enough details on why an experience was positive or negative. An HVAC company can refill refrigerant for a low price, but their duct work can be extremely pricey and sub-par. Reviews probably will not capture that type of information without asking what the user had done, how much it cost, promptness, time to complete the work, etc. Added these interview-style questions on a review site probably won't help, because will likely not submit a review where all of these are required fields.
I was attending an event at a local incubator last week when it hit me - and maybe this is obvious to everyone else - that 'startup incubators' are just taking the music industry business model and applying it to entrepreneurs.
Why are your stored procedures not in the code repo?
Very nice resource! I have a suggestion: add a search field that would just search the linked function documentation summaries (depth of 1 web crawl). As someone else mentioned, adding a new section for CLOS would also be useful.

Pardon a shameless plug, but I released the 4th edition of my Common Lisp book yesterday (free to read online, and book is CC licensed so you can share it): https://leanpub.com/lovinglisp
> The notice came from District Attorney Leon Cannizzaro’s office. His prosecutors are using these fake subpoenas to pressure witnesses to talk to them — a tactic that defense lawyers and legal experts said is unethical, if not illegal.

The fact that the DA's office, which does not issue subpoenas, can mail to witnesses a document which says "SUBPOENA" is bold lettering and threatens arrest, is not on its face obviously and flagrantly illegal, is shocking to me.

In a just world everyone in the DA's office who had a hand in this and had the authority to stop it would be charged with falsifying court documents, witness tampering, or whatever other crime(s) were committed in doing this.
Thanks for the recommendation, I'll add it to my reading list!
A few years ago, my little sister decided to buy a herself a gaming PC, built to spec. The shop provided two tiers of building service, and she went with the more expensive "Pro" service. When the machine arrived, it did not boot. CPU error on board lit. Peeking through the back IO panel, I caught a glimpse of CPU pins. Yes, AMD. CPU wasn't seated properly sigh. They still had managed to force the heatsink on it, and the metal bracket was a little bent so after reseating the CPU properly, the sink would sit on rather loose. I'm surprised the pins were intact and the CPU still worked just fine.
OpenShift.io Red Hat announces free cloud-native dev environment
I'm currently using Firebase at work (startup, mobile app, web dashboards), and I think it's got some great features.

It's not a replacement for SQL, but an entirely different product (and has no doubt come a long way since V1, especially with Firebase Functions out recently). You have to make tradeoffs, like data duplication, for the advantages. From the sound of it, the advantages probably aren't relevant to you, but I'm confident they exist for us.

- We only have to store a comparatively small amount of user data for the lifetime value of each user, so the actual database cost is marginal (i.e. data duplication is not expensive to us, as long as reads are fast). (Development) time is (very) expensive.

- Rapid development and iteration. I can make additions and make fields redundant with ease in response to customer feedback, my own development choices, and changing product needs. There's no API update needed, as reads are client side. I have data model classes which store the reference in the database, some constructors, and getters and setters (About the same as any other data model + API would have). The release goes live and data just starts being manipulated in a new way. Alterations can have simple defaults with || in JS and ?? in Swift (even if it's just an empty string).

- Minimal backend. Our application doesn't require much backend logic, and that which we do have is mostly event driven with Firebase Functions, upon certain database writes. Works out quite cheap too (for now - most usages don't trigger any functions).

- Caching, and offline first. We take the approach that it doesn't matter if there's a short delay in 95% of our data updating - either due to patchy mobile signal or the data taking time to sync down. Firebase has made on device caching and real time updates to that data a breeze. With GeoFire, we've got instant map search (keys are cached by Firebase and contain sufficient information to filter, etc).

- Declarative security rules are very powerful, and can even reference values in the database itself for security control - effectively. We store a permissions tree in the database for our more complex security logic.

As a bonus, additional features like Authentication, Analytics, Push Notifications, etc are all convenient to have bundled up.

As you can see, most of this isn't about the database tech, but the development speed for us. The perceived costs and inefficiencies may exist in the database itself, but there are massive advantages for the application development as a whole.
What's the point of being true to yourself? That doesn't mean anything anyway.
The most recent OSX version (Sierra) made the change of hiding the option that totally disabled Gatekeeper, but the default hasn't changed. I have a Sierra VM I set up about a month ago, and I just checked the setting and it's at "App Store and identified developers".
Use jsonb inside a Database and use constraints to ensure all requested json attributes (store name,etc..) are present at INSERT/UPDATE time?

That don't seems like rocket science to me... duh...

PS: But of course don't store ID in an object value or you will lost major benefit of RDMS relational constraints.
Yes, and I wish developers could make that choice more easily.

The Electron approach is fine for genuinely large applications. But I've seen many Electron-based Mac desktop apps where the UI has a handful of elements. The equivalent Cocoa app would be maybe 100 kB.

I understand that people won't learn Cocoa just for tiny UIs, so it would be really nice if there were a mostly Electron-compatible solution that would use the system web runtime which is already there (and probably already loaded in active memory).
Concepts, techniques and papers to build a time-series database
Colorido Studios | Front-end Developer | London, UK | £40k - £50k | Full-time, ONSITE | http://coloridostudios.com

Colorido Studios are looking for a front end developer with at least 3+ years experience to join their growing team to deliver exciting projects for a range of global clients. You must be enthusiastic, a good communicator and be able to accurately and quickly translate design work into compelling live digital experiences.

We would ideally like you to have a high level of proficiency with the following:

* Javascript (ES6)

* HTML5

* CSS3 (SCSS or similar)

* Git

* Bash / Linux terminal

Nice to haves:

* AWS / Heroku

* Basic DNS config & management

* Node.js (Express)

* Ruby on Rails (or similar)

About Colorido Studios: We are an award-winning Creative Studio in based Covent Garden. We make wonderful branding, engaging content and indispensable design.

Get in touch! work@coloridostudios.com
A few random comments:

Forth is a great concatenative language, since its the pioneer in that area (I think), but Factor is definitely worth mentioning too as a "modern" take on the paradigm. It essentially tries to be a concatenative Lisp.

ANI was dead even in 2014 when this article was written (which the author acknowledges: "the language seems dead, but the concepts are pretty interesting"). It has some really interesting ideas, but since it never got implemented, I'm not sure how much use there is in discussing it here amongst real languages. It would be useful as a discussion for possible future languages for sure, but its currently still just a concept, so I'm not sure what practical thing you can learn from it right now.
Official announcement: https://www.redhat.com/en/about/press-releases/red-hat-unvei...
Removing the GIL has nothing to do with making breaking changes in the language. It's also an enormously more complicated task, one which hundreds (thousands?) of developers have spent time on over a decade (two?).

I think you might be thinking that the impediment to removing the GIL is user code. It is not. The impediment is that CPython - the standard Python runtime - was designed around using the GIL, and it's extraordinarily hard to remove it and still meet the existing single-thread performance goals. There are also ancillary issues surrounding user code - particularly modules written in C, I believe - but the runtime itself is the biggest issue.
Red Hat OpenShift.io – Free, end-to-end, cloud-native development
I'm loving Bandcamp so much. Buy an album once, you get FLAC, plus any other formats you might want (yes, you can always encode FLAC to anything else, but the convenience of just downloading the oggs is nice). I can't imagine buying music from anywhere that doesn't do this now.
It's a little different: an administrative subpoena is authorized by law (an arbitrary agency cannot, in fact, just print the word "subpoena" on a piece of paper and make it a subpoena), and that law is subject, like all laws, to judicial oversight.

HN may be most familiar with the administrative subpoena in the form of the National Security Letter, and such subpoenas have been fought in court.

It's not great, to be clear. We should have all subpoenas / warrants require individual advance approval by a judge. But there's a big difference between a type of subpoena authorized by the legislature, used by the executive, and subject to review from the judiciary (and subject to the entire law being ruled unconstitutional, in theory), and the executive inventing the idea of "administrative subpoena" on their own.
Wall Streets grousing about airlines' raises shows what's wrong with Wall Street
Sun sets on eight domain names managed by CentralNic
Learn to code with style: use linters
One thing I find myself asking a lot is if it's really hard to make a program take advantage of the cores or if the prevalent tooling and paradigms of today make it hard to take advantage of the cores.

While most programs are not embarassingly parallel in nature, I suspect the latter plays a bigger role than most of us tend to admit.
Okay but on the browsers where it's implemented well, it is awesome?

It's not like Skype is designed to run on many architectures per OS either. Just pick one and use it!

My question though -- does WebRTC have better quality videoconferencing than Skype and Hangouts right now on the best browser implementation?
It depends on which police force you are talking about as well. I live in Catalunya, and the local Mosos police force is the main police here. They have quite a few stories of bad hiring practices, silencing ex cops who speak up etc. However, I have also met good people trying make a difference, so I think it all comes down to who you talk to.

This whole police problem in the US looks to me like a few bad people that makes all cops look bad. Add to that, a biased hiring practice and coverup / protecting wrongdoers, and you get the situation you have in the US today where people don't trust the Police. It then becomes a worse and worse as the rift between civilians and police grows bigger.

I think the problem is really in management, where everything becomes political. No one wants to sound like they are soft on crime, so they all make speeches of fighting crime, war on drugs, etc. The wording says it all: "Fight Crime" and "War on drugs" are both very powerful messages, meaning more arms, more violence and not a peaceful solution. Add to this, the short time-spans of some of the turns that these people have in office, its no wonder that no one is trying to solve anything. It would take too long to see results, and they would not be in office or at least fear that they would not be in office. So, short turn patches get applied with a lot of force.

I don't know a solution, but at least we should look at removing as much of the political and financial pressures from police departments, let them hire better people (and yes they might leave after a few years, but that's just how things are now). We also need a cleaner and more transparent system to deal with wrongdoing, whatever happened to Internal Affairs? Are they still a thing? Have they lost power or have the political hands gotten involved there as well?
ATM I haven't dealt with structure yet, just dumped it into a dir. I'll get a chance to take a look this weekend, many thanks!
Do we? I used to build my own PCs about 15 years ago when I had little spare cash. I got the feeling that approximately 5 years ago it became barely worthwhile to self-build even when excluding my own labour. Did I get it wrong?
No one is making you use that platform?
And yet the Pentium G4560 -- one of the cheaper models of their Kaby Lake lineup -- supports both ECC and non-ECC RAM. I suspect the only reason behind lack of ECC support on their mainstream processors is just market segmentation.
Yeah, I think the good ORMs make the simple case _really_ simple (like User.getById(1234)) while letting you drop down to raw SQL easily when you need it. Any ORM that doesn't let you do that is not worth using, IMO.
Electron makes Java looks good!
Show HN: Jolt Alarm – Wake up to a new song every day
Something I saw on Twitter once:

How to be a 10x programmer: make 10 other 1x programmers into 2x programmers.
This first paragraph applies exactly to us! We're the offshoot now because of a bloated central IT system and now that we have a good thing going, there's a corporate push to modernize IT and bring back all our offshoots to one place.

Loved the vampire/garlic analogy!
You can simply refund the money and tell your friend to send somewhere else , well that's what I did
It almost baits me to pitch the company I work for. I would think we keep sales cheaper because of efficiency.

We were very very good at setting up a very efficient pipeline of demo setter (sdr) to demo performer and closer (ae). I believe this is one of the more cost effective ways to scale because the specialization allows for getting really good at that one part of the pipeline.
Hey guys I created Jolt Alarm because I was sick of waking up to the same song every day. This is a cool new way to discover new music and to replace your boring ringtone. I'd love to hear what you think.
Angie's List used to be awesome. When we bought our current house, we needed an array of professionals for various services, and we hired all of them via Angie's List reviews. Every single one was great. We have found that having a large number of relevant positive reviews on Angie's List to be an extremely strong indicator that the pro will do good work.

However, over the past few years, it really seems like it has stagnated, and it's clear they've changed their focus. It's harder to find people who have many recent reviews, and they're always trying to push "coupons" in your face.

These days more often than not, I get recommendations from our neighborhood Facebook group (sometime Nextdoor as well, but Facebook is much more active here). The track record isn't quite as good as Angie's List was in the glory days, but it's a lot better than Yelp or just randomly searching.

Hiring service pros is so stressful, and such a minefield. So many of them are flakes or terrible at what they do. It seems like it should be a no brainer to have a service that reliably connects you with people who will do awesome work on your home. But I guess it's too hard to monetize that...
Keeping churn in check is very important. High churn means something is wrong with the product.... Or maybe not? Implementation and support are important parts of the equation too. Product can't be garbage though.
Which product owner? Totally agree with you, but the reason why it's delivered this way right now is a technical implementation detail. Electron could focus on delivering an API that abstracts away differences between runtime engines (as most web frameworks do). I'm sure bundling chrome in is a boon to simplicity inside electron, so maybe the distinction matters within electron, but i'm not sure that distinction should matter for downstream projects...
> currently there is no technology that allow us to say that this table column stores actually column names that can be used in queries and have to be treated as normal columns.

That's because the column name is part of the RDBMS' structure, as is the type, for the most part. If you want to read a column and use the row values as the column names, that can be done, it's just a query. The DBMS is going to have to scan the whole table (or lean on the index) for that column anyway. I can't think of why I'd want the RDBMS to do that for me and imply the column names, rather than me implement it in code. I'm managing the column names as data at that point. That's if you still think it's a good idea.

The other piece that jumps out at me is that when you do something like that, you're really building a variably wide table, but not letting the DBMS manage it as a wide table. Instead, every query is going to require either you or the DBMS to transpose rows to columns at some point in the query - if it's a simple select, only on the return, which won't be that expensive, but some joins are going to require it to happen earlier. I'm not smart enough to know whether it'll be computationally expensive to the point of being a showstopper, but I do know it'll require a lot of memory if you want it done fast, or you have to do it slow in scratch/spool.
TravelPerk | Senior Frontend Developer | Barcelona | ONSITE travelperk.com We are looking for a talented Senior Front-end Developer with a passion to develop a performant single-page web application with great user experience. You will work as a part of the team that builds a next-generation application for business travel. This position involves: Building and maintaining reusable, testable UI components. Writing a readable, well-documented code. Working closely with our product team to build new features. Working in an Agile environment. Being able to mentor/coach/train other colleagues as a subject matter expert. What do we offer? Competitive compensation including base salary, bonus and equity in the company. 24 vacation days per year and flexible working hours. This position requires full-time, in-house work in Barcelona, Spain. We can help with relocation from anywhere in the world. English is the official language at the office. Spanish is NOT required. The link to apply is http://bit.ly/front-eng-tk
> But that goes completely against the "skills matrix" concept. The whole point of Moneyball is that the Oakland players were flawed given standard metrics

If anything I think I'm advocating against using "standard metrics", and opting to create ones that are meaningful to what it takes to ship software in your company. Where standard metrics are the ones that result in hiring the traditionally "best" developers.

> corporate-bs mumbo-jumbo

Mumbo? Perhaps. Jumbo? Perhaps not!
I wasn't really suggesting anything, but if I were, Postgres and its binary JSON (`jsonb`) would be there alongside with full and easy indexing support and other SQL nicities like constraints, triggers, transactions, custom procedures, etc.

There are also excellent out-of-the-box support for arrays, enums, custom types, and JS procedures if you so desire. All that comes with consistent syntax, great aggregation functions, JOINs; and all those 43 years of advancement mentioned in general.

Read the docs, you'll be amazed with what you're missing :)

General overview
https://www.postgresql.org/docs/current/static/tutorial.html

JSON support specifically
https://www.postgresql.org/docs/current/static/datatype-json...
Show HN : Pillr – Automated property management
TravelPerk | Senior Back-End Developer | Barcelona | ONSITE travelperk.com Are you a Back-End Developer with extensive Python experience? Do you particularly enjoy working with amazing people, having fun at work and building something awesome? If so, this role may just be a fit. As a senior developer you will work as a part of the team that builds a next-generation application for business travel. On a day-to-day basis you will work with our product team to design, architect and implement the back-end of our product. Your code will run fast, efficiently and will never break. This position involves: System architecture design, implementation and testing. Product development in Python and Django of a travel related web-based product. Integrations between our product to 3rd party APIs. Work in Agile environment with strong attention to a well-documented code, unit testing and continuous integration. Being able to mentor/coach/train other colleagues as a subject matter expert. What do we offer? Competitive compensation including base salary, bonus and equity in the company. 24 vacation days per year and flexible working hours. This position requires full-time, in-house work in Barcelona, Spain. We can help with relocation from anywhere in the world. English is the official language at the office. Spanish is NOT required. The link to apply is http://bit.ly/backend-eng-tk
SQL is code. Not sure how that escapes people.
> We spend too much time asking if volumes and quality are ok.

I agree, but that happens on teleconferences using phonelines, too. So not really a video conference only thing.

I'm not sure if all those problems are truly UX only problems though. How useful is an n-way latency graph Volume gauges, I see that more as a hardware fault. When using a phone or an iPad, that question never comes up. Audio feedback, IMO hardware/driver issue. Again, speakerphone is okay. High compression is obvious from the blockiness.
Well, now you're just as 'schemaless' as any NoSQL, so that's neither an advantage nor a disadvantage over it.

There are other differences, both advantages and disadvantages to doing this with Postgres (which is the only db with a type called 'jsonb' I think?), vs some kind of non-SQL document store. I agree that as Postgres json(b) gets better and better, the disadvantages decrease. And one of the main advantages to me is simply not having to have another system to run and understand, since postgres is probably already there.

But it's always trade-offs and choices, that you make better with more experience and better understanding of your domain. It's definitely not a "duh, it's always obvious" thing. Unless your domain is so simple that it doesn't hardly matter.
How do I use the Internet of Things for my business?