skysight-inc/HackerNews huggingface dataset:
That is quite frankly horse poop.

We use stored procedures. Not by choice; this is a legacy we're stuck with. It is nothing but an unadulterated disaster of a technology regardless of what you use it for. I'm talking 45,000 stored procedures here. 2000 tables. TiB of data. 50,000 requests/second across SOAP/web/desktop etc. It's hell.

Problems with stored procedures:

1) Performance. More code running in the hard to scale-out black box. You're just hanging yourself with hardware and/or license costs in the long run.

2) Maintenance. All database objects are stateful i.e. they have to be loaded to work. The sheer complexity of managing that on top of the table state results in massive cost. Add to that tooling, version control costs as well. Have you tried merging a stored procedure in a language which has no compiler and very loose verification?

3) Orthoganality. Nothing inside the relational model matches the logical concepts in your application. Think of transactions, domain modelling etc.

4) Duplication. You still have to write something in the application to talk to every single one of those stored procedures and map it to and from parameters and back to collections.

5) Transaction scoping. Do you know how expensive it is to introduce distributed transactions? Well it's a ton more cash when EVERYTHING is inside that black box.

6) Lock in. Your stored procedures aren't portable. Good luck trying to shift vendor in the future when you hit a brick wall.

Now I know it's popular to bash on Rails and I wouldn't use it personally but there are people using the same model on top of other platforms, like us.

Sorry but databases are just a hole to put your shit in when you want it out of memory. If you start investing too much in all of the specific functionality you're hanging yourself.
What about when changes are made to the schema, wont the API just be changed in that case?

Wont this lock you in with very hard coupling between your db schema and public REST API?
Charlie Kaufman writing first novel – or maybe it's writing him, or whatever
Fido Facts: Welsh Corgi (Pembroke)
could I get an invite plz?
And #3 can give the positive effect of converting existing paying customers on one product into paying customers on new products.
It's a common way of avoiding/reducing the need to consult a dictionary.
The problem isn't that Markdown is idiotic; the problem is that Hacker News doesn't use Markdown at all.

GitHub and Reddit have conditioned us to think that any halfway decent discussion system must use it :-P
Hello,

If you are interested in lobste.rs invitations send me an email with your "keybase profile" and at least 1 public network identification that will let me know that you're not a self-destructive troll and I'll be happy to help you.

UPDATE: Since I received a lot more emails than I thought and it's time consuming, my offer stands for another 24 hours.

regards
Given the fact that the officer made a u-turn in order to speedily follow her car way before the "failure to signal" happened, it seems to me watching the video without pretty much any context, that the lane change was merely an excuse to pull her over.

Any police officers knows if they really need such an excuse, they just need to follow a given car for a few minutes: it's guaranteed something will happen which justifies the traffic stop.
https://youtu.be/qEGFaOeUm2A?t=31
Globally, it's not.
Hmm no.

Avoid state at all costs. Stored procedures are stateful. Schema and migrations is pain enough already.

Write me a check constraint that validates an email address being put in a varchar column and reports back a sensible message which can be bound to an entry field with metadata about the error.

Write me a constraint and key arrangement which is unique across two and three columns in separate groups.

No. You're wrong.
So I had never heard of lobsters, and just checked its front page and a couple of comments and ... is it Stockholm syndrome to say I prefer the HN design / look and feel?

And is it unfair to lobsters to say the posts all seem very very familiar? Just asking as one is always worried about missing out on the next great thing, but the HN niche seems pretty well filled?
"better moderated"? Isn't that a bit subjective? I left slashdot.org because I found their moderation to be horrible. Hell, in my opinion, the vast majority of reddit's mods are better than slashdot's mods.

The issue is something everyone overlooks when making these kinds of judgements: adaptability. You have to be able to evolve and adapt to the changing times and, most importantly, adapt and evolve with your user base. This is where reddit really shines and one of the big reasons why places like Fark, mefi and slashdot stagnated and quit growing (relatively speaking).

Large online communities are highly dynamic. There is user churn, as well as the obvious cultural evolution that takes place. Places like fark and slashdot never evolved and adapted with their users and the changing times so people eventually get bored and leave. It's one of the reasons for their stagnation. Mods have to be adaptable and evolve with their communities.

Reddit is evolution and adaptability personified. It's the culture itself running the show over there (anyone can create a subreddit), so the new users with their new ideas, interests, memes, etc all have a place. When something gets boring, old or loses popularity (like FFFUUU comics) it doesn't hurt the site, just the subreddit. People just move from one subreddit to another instead of moving from one website to another.

And that's the problem with slashdot's mods (and fark's mods too). They're the same people and rarely do they let new blood in. And the new blood instantly conforms to the old guard's way of thinking and policies. The way content gets moderated always remains the same. This might be good short term (some people don't like change) but people do eventually get bored of the same old, same old.
I found this vid quite interesting about Deepmind which kind of shows where things have got to. Their AI algorithm can learn to play Space Invaders and Breakout better than people starting from just being fed the pixels. It doesn't do well at Pacman though because they have not cracked getting it to understand spatial layout and planning ahead. https://www.youtube.com/watch?v=xN1d3qHMIEQ
Recently discussed on HN:

https://news.ycombinator.com/item?id=9909429

https://marc.info/?l=openbsd-tech&m=143725996614627&w=2
This looks very interesting!

1. How does it compare with phantomJS?

2. What's the current webkit version?

3. How often does the javaFX webkit update?
With Data Virtualization providers like Denodo you can create a REST web service with any relational database very easily..

https://community.denodo.com/tutorials/browse/dataservices/2...
By the looks of the photos, none of the street signs are normal parking zone signs, but rather special event signage.

Those are only used for special events and don't change very often. This is a good example for their use. I agree with what others have said about the risks and concerns if this were to be used for ALL parking signs.
Yes, I would love to find that. Less web, less startup, less silicon valley, less brogrammers, but more C++/Fortran/Java, more depth, more performance, more BigCorp, more career. With people who are not impressed by the latest fad, because they have seen the same ten years ago.

Unfortunately, the interesting guys to fill such a forum do not hang out on social platforms and bikeshed a lot. They are busy. Usually you can find a few on project specific forums/mailinglists.
Having watched the two short videos I really don't see any obvious things they could have hidden there. The audio (which I presume is the important part) appears to keep on going, while a short segment of the video repeats. They also mention in the article that "The audio ends more than a minute before the video images do. "

So to me this just sounds like some small parts of the video got repeated by accident, leading to a slightly "extended" video that becomes out of sync with the audio.

But maybe I'm being too naive here, I don't actually know the backstory of this.
Are you sure about that? Cache-Control, Expires? If you don't change the URL IE will cache the response whether you like it or not. 2 ways to handle this are to generate a random number to append as a parameter to change the URL. The other way is to have your web service to tell the browser not to cache with response headers. I have had IE do this to me and made all my web services send back "Cache-Control: no-cache" to prevent IE caching.
The strange phenomenon of musical frisson
a big part of the problem is that a lot of Americans think these are "first world problems" too.
>>> Is it so hard to imagine someone could have a different opinion than you?

It's not hard at all. I'm not in denial, I've read the original article even top to bottom. I know people like this exist. I just don't think it has any relevance today.

>>> not actually instant in practice

Don't take it so literal. The feature is called Google Instant. That's the name.

>>> I believe that's mostly fixed now, bringing the functionality back up to par with the original implementation.

Your argument is... that there are bugs? Yeah, nice one.

>>> Most of the time, I want a document, not a portal or an experience.

In which case, a document should be given to you.

But Google, Facebook, Youtube and many others including "blogging applications" do not offer documents. They are dynamically generated for you, client or server side.

>>> But the users sure seem pleased with the constant evolution of the UI.

I'm pretty sure they would be less happy if Facebook delivered simple documents with no styles attached. And I don't think they hate it as much as they say they do, as Facebook is still actively used.
> "I guess what I meant by "professional" was more people with a formal education in computer science and some years of practical experience. It is just my impression that this is not so much the case here at HN. This being said, I do not mean to be disrespectful towards someone who "only" has practical training (they may be older so that when they studied there was no formal computer-specific education)."

I have to admit this reply does leave me a little speechless. On many levels. Anyway, good luck finding what you're looking for!
I was surprised by this, like other sibling commenters. I was under the impression that common assault is only enacted when the victim is threateningly contacted or injured, or has reasonable fear of that being about to happen. Maybe threatening language might play a part in that.

Having a quick Google, the articles I've come across seem to indicate that swearing at police has in the past been interpreted as illegal, but nothing has mentioned it being classed as assault.

http://www.telegraph.co.uk/news/uknews/law-and-order/8902770...

http://www.theguardian.com/commentisfree/libertycentral/2010...

Not a lawyer, obviously.

Where did that opinion come from? Do you have a source?
Read the comment again, the irritation was not about getting stopped for speeding.
Sure, a medicine may be lethal (but after many trials, errors, cases etc - people developed efficient drugs and medical procedures). But there are many people; it's a big difference if one dies or everyone dies.

"Even more experimenting" is a bad idea. The current situation is bad and we should change its causes. (Otherwise it's like healing tooth with painkillers.) Here I would guess that the average value of risk is highly negative (as in any case with dealing with complex systems).

And there are many imaginable consequences, which are far worse than the current pace of global worming. E.g. poisoning biosphere, accelerating global warming, etc.

And, no, global warming is not an asteroid impact (i.e. killing everyone and everything), so "all or nothing" is a poor mentality (and deadly dangerous!).
Indeed, the main problems are uncontrolled side effects. That's what happens when a system is really complex. Even if you just look at weather forecast (which is just really the visible surface of climate change), the models we have are just starting to be working for the immediate future and it's still impossible to predict anything reliably two/three weeks ahead despite the massive amount of money poured into the complex field of meteorology. It's good to gather ideas about what we could do but we don't have any idea of the massive side effects which are going to happen. Almost anything related to climate change is quite speculative and still in research.
Are you planning to open source it?

Can you give an example of how it works? Say navigate to a page, fill in a form, click submit and verify that some text is present after submitting the form
There was a 2011 ruling in England where the judge said that officers were so regularly on the receiving end of the "rather commonplace" expletive that it was unlikely to cause them "harassment, alarm or distress".

The Met continues to arrest people for swearing at police as they rejected the ruling. I know that Police Scotland continue to arrest people for swearing at police but I'm not sure how/if it has affected forces in England and Wales. At the time it was reported that the precedent could likely quash any future charges in similar circumstances.
Now imagine a database of photos of each sign, taken in various states at various times of day, and add a little Photoshop or other image-editing program of choice... this is too exploitable, both by those looking for free parking and those wanting to extract more parking tickets.
In terms of money and skills I guess
super interesting...Google's really digging into mapping, first with the revamped MyMaps and now with this...I'm just wondering if a timeline is the best way to see places...If I had a great date with my girlfriend a few months ago, I don't remember the day or even month...there's gotta be a better UX, no?
"... build up a mountain of resources so large that the Allies could roll over any possible opposition. ..."

LSG - https://en.wikipedia.org/wiki/Loss_of_Strength_Gradient
They tried to include horses too, although the case was dropped: http://news.bbc.co.uk/2/hi/uk_news/england/oxfordshire/46060...

There's 2011 advice provided to the Met which says that courts are unlikely to convict because officers are assumed to be robust: http://www.bbc.co.uk/news/magazine-15816761

It's probably a bad idea to direct insults at officers (because no-one likes being called a fucking facist wanker) and results will vary by location.
I'd be interested to see a benchmark. PostgREST is fast! And it is also a piece of software that tries to "do one thing really well". It deploys as a binary, which is also a big plus compared to these "first install this list of dependencies at these ranges of versions before using our product".

Last thing: is Denodo open source? It is not listed at "why use Denodo", so I guess not...
Again, I'm not saying there is much difference - just that there are languages that use two separate words for those concepts and don't have a (common) one for both.

For example, in Polish you'd classify aspirin as a medicine ("lek", "lekarstwo") and caffeine as a stimulating substance ("używka"). There is another word that is used to refer to harmful addictive substances like cocaine ("narkotyk"). There is no generally used word in Polish that encompasses all three terms.
How exactly did you test the usability?

The first thing i noticed was the checkbox label "Prevent duplicate votes?" was not clickable.
It has the property of working well. But it requires you to learn its inner workings first. If you achieve some agree of inner understanding it becomes (one of) the best CVS you have ever used.
https://dzone.com/links - more technical although probably not much less web
> I think the bread and butter that users care about is not so much heavy number crunching but rather quick cold code that needs to run once or twice and get out of the way.

I care about HTML and CSS with as little JavaScript as possible. The best code to optimize is the one isn't there in first place.
Well, you cannot isolate the code, you cannot unit test it, you cannot use a debugger, cannot set breakpoint, have stack traces etc. You are tied to the database at all times.

In my experience, every stored procedure that is larger than 2-3 lines is a headache.
Java Arraylist to Map speed comparison
There's an underlying element here. Some people have developed a sort of belief system around the idea of carbon emissions being intrinsically amoral. For them, man-made CO2 emissions are dirty, gross, and fundamentally sinful. Ameliorating the impact of CO2 on the climate is thus something like purchasing a religious indulgence in that worldview. Anything that enables continued carbon emissions without humanity suffering the consequences is thus seen as extremely morally suspect.
You could always write a custom API using any one of the many libraries/frameworks fit to do so.

If you want to use Haskell (easy binary deploys, fast and strict type safety for cheaper maintenance, less bugs, easy refactoring) you could have a look at servant[1].

[1]: https://github.com/haskell-servant/servant
I love the quality of the site - top notch implementation of e-commerce portal.

Could you forward me the coordinates of the person who built the site?

gesman at mensk.com
Your question is far too vague. For example, how do you personally
define "web-focused" or "technical" or "professional"? All of those
definitions matter a whole lot. Also, you left out an important aspect,
namely if you're looking for a discussion forum or an aggregator?

Since I'm blindly guessing at what you mean, the following suggestions
might not be what you want, but they're the best I can do.

https://lobste.rs/

http://slashdot.org/

http://www.datatau.com/

http://skimfeed.com/

http://hackurls.com/

http://filll.com/news/

http://talll.com/news/

A similar question to yours, with lots of subreddit answers:

https://news.ycombinator.com/item?id=7254884

There have been other "Alternatives to HN" type posts over the years, and a quick search will find them

If you're in the mood for skimming to find interesting titles, you can
even skim the big HN rss feed:

https://news.ycombinator.com/bigrss

Lastly, on HN you can see the submissions from a given HN user, so if
you find someone who regularly submits stories that interest you, you
can check their submission history. For example:

https://news.ycombinator.com/submitted?id=jcr
4 Reasons to Prefer Face-To-Face Meetings When It Comes to Business Networking
Ask HN: How can I prepare for my new job as a software developer?
Hello,

In September I will start my first real job as a software developer (mainly backend) in a great company. What's the best thing I can do to prepare for it (i.e. to quickstart instead of having to learn everything on the job)? Study algorithms and refresh some of the stuff I studied in my CS courses? Or learn the stack they use on a daily basis in depth (e.g. frameworks, DBs, etc.)?

Thank you!
This sums it up really well.
Are you having issues with speed? You can't accelerate Scons or most other Make tools, and CI is still slow when running thousands of tests.
well, potentially the audio could be edited as well, which is much easier to fake than video
I wanted to block the breaking banner and did this pretty easily but I thought I'd take it further and make a tool to avoid procrastination and/or play tricks on your friends.

TL;DR:

- Add this to your hosts file to block:

127.0.0.1 polling.bbc.co.uk

- Add this instead for fun:

192.30.252.153 polling.bbc.co.uk

Full write-up here:
https://unop.uk/dev/breaking-the-news-blocking-the-bbc-news-...
To be fair, when it comes to financial regulations and banking, there are very few governments that would hold their ground and stand firm against U.S pressure.

And those nations capable of standing their ground against the U.S (China, Russia, etc) wouldn't stand against them because it's in their best interests too. In fact, it appears Russia and China are becoming more strict on Bitcoins than even the U.S is. China and Russia don't like not having total control.
Desktop Slider
I've been pulled over (1997) while being a passenger in a older (1970sh) truck in Palo Alto at night. The officer was really friendly, asked what we were doing in the neighborhood (We were driving around slowly, looking for a house we were trying to visit), and wished us a good evening after confirming we were on the up-up. The driver (my friend) was hispanic, I'm a white guy. License and Tags were up to date - it was just a kind of crummy truck. I thought it was really weird, but he said that sort of thing had happened to him several times - he attributed it a lot more to the truck being in a nice neighborhood than him personally.

On the flip side, a couple years earlier, when I had just moved to the Bay area in 1995 (from Vancouver,BC ) I had gotten a bit lost with friends, and had slowed down, and were stopping at various intersections in East Palo Alto trying to get our bearing. (I just realized - this is something anybody who grows up with GPS enabled smartphones will never have to do) A police office pulled us over to find out what we were doing, and then suggested (once again, really nicely), that we probably shouldn't be stopping in this neighborhood at that time of night (East Palo Alto, unbeknownst to us, was a very high-crime area in 1995)

I guess my point is - Police pull people over when their spidey sense goes off all the time. And it can be all sorts of things that will trigger it. I guess I'm blessed with white skin, but the many interactions I've had with police in which they've engaged me because whatever it was I was doing seemed sketchy at the time, always ended up well. Though, honestly - they've got guns, so I've also been pretty sensitive to the fact that if I made them nervous they might shoot me.
Yep, and it's about as painful as you might expect.

Unfortunately we have a number of clients using our product (particularly government) which still expect it to be supported :(
I live in London, and you can tell South/East/North/West London apart with relatively little practice. On top of that there are several distinct dialects in the surrounding areas (1-2 hours travel out of inner London), as well as a few different sociolects (dialects spoken by distinct socio-economic groups more than separated by area).
CFML is not a computer language. It's two things: (1) a program that takes as input an ML program (more precisely a Caml program, i.e. Ocaml without objects) and computes the characteristic formula (expressed in the logic of Coq) of the program; (2) a Coq library, more precisely a library of Coq tactics, that enables users interactively to manipulate characteristic formulae of Caml programs in Coq.

So Charguéraud's CFML is far away from cold fusion that context can always disambiguate. And if not ... is the sky going to fall down?
Yes!! http://heliumhq.com (commercial; I'm one of the people behind it)
> My concern would be that these new displays might be harder to read depending on lighting conditions.

They address that in the last sentence:

> And for folks who have trouble reading dull, iron-colored screens, they also feature little lights that illuminate the text at night.
I worked for a company where one of the clients required that all the source code be periodically archived and shipped to them so that if we went out of business they could potentially run it themselves. Practically, they wouldn't be able to because of the sheer complexity of all the different services. It was a minor pain to do this for them but the contract was worth it.

Having said that, I am a big fan of open sourcing projects of they fail. Why not? What do you have to lose?