skysight-inc/HackerNews huggingface dataset:
I am attracted to these types of DSLs but . . .

I work with a number of legacy data sources that often have models that are not ORM-friendly.

I fall into SQL code patterns that seem left behind by tools like this on a regular basis, particularly using SQL functions without default grouping because I'll select other stuff higher up.

A simple example:

select
col1,
col2,
some_function() over (partition by col1,col2 order by col1,col2) as some_ck
where <some conditions>

This is often part of a larger query (e.g., this is embedded in bowels of a some longer "chain" of SQL where I will be using some_ck to decide on which tuples I want in the end).

I get pretty significant mileage out of this - meaning I write much less other code around it to handle the data.

I guess my complaint is that I often find the SQL DSLs lacking in expressiveness that I use regularly enough to miss.

Of course, this could be because I've spent too much time hacking around in legacy data in "real soon now" mode rather than in "hmm . . . let's clean up this data model" mode.
Vignete mauro
Is organizing your bookshelf in iBooks shit work? After reading the article, I'm sure the author would classify it as such. But Apple is smart enough to figure this stuff out. In fact, they're experts at it. What's Apple's reasoning?
Very, very true. But it seems to me that the people who want this sort of thing (people who make decision on golf courses) don't really like the sound of Clojure.

Although I'm fully aware some firms are dysfunctional, it seems to require a strange alignment of the planets for someone to decide on using immutant.
The Moon isn't faster. The velocities you care about for Solar System impacts are sun-relative. The Earth and Moon have essentially the same velocity relative to the sun, since they orbit it together. The Moon moves a bit slower at new phase and faster at full phase because its Earth-relative velocity subtracts from or adds to its Sun-relative velocity, but the former is 1 km/sec and the latter is 30 km/sec, small potatoes.

As for who gets hit; Earth's mass is 81 times that of the Moon so it attracts objects 81 times as strongly. Really, the Moon would only get hit if Earth already pulled an object into a collision course or near-miss and the Moon just happened to get in the way at the right time. Earth has 4x the diameter so presents 16x the cross-sectional target that the Moon does.
Don't like Lists? Don't use them. I have almost a dozen lists on Facebook and I use them extensively (as if they're Circles basically). The only annoying thing is that Facebook decides to change my default publication privacy every time I publish to a specific list.

I don't understand, are the features themselves bad? Who's forcing you to use Twitter lists, or Facebook lists, or even Circles?
The laggy scrolling is likely because they're not using native scrolling, but rather using the same JS based scrolling they use in the web app to overcome issues with iOS 4's support for fixed CSS positioning. However, since the toolbar is native in the app, they should just use native scrolling.
Gioco per Ragazze - Vesti Chocolate Girl
In other words, what you get out of a conference is often based on what you put into it. :) Of course, that's true of anything.
Retrospective on the Design and Philosophy of Firefox
In-store pickup, self-checkout likely coming to Apple Store near you
That love thing is typically gushing and odd.

I like my iPhone 3G, but it's annoyance at no longer receiving security updates, and lack of iCloud support, that would make me spend money to upgrade. Not love.
Build Mobile Apps with Web Technology
See also ClojureQL

http://clojureql.org/documentation.html

Which doesn't have as nice a website but may have superior semantics.
Amazing San Francisco & Bay Area UI/UX Designers
Some interesting links I found while searching for a low-power server/NAS for myself:

8.5W Core i3-based desktop computer
http://ssj3gohan.tweakblogs.net/blog/6112/85w-core-i3-based-...

(from wikipedia: core-i5 mac mini consumes 13W while idle, core2duo model uses 10W)

building a 8x2TB NAS
http://www.willudesign.com/BlackDwarfTop.html
But hey: the current mobile version of Reader looks and runs much nicer on a Mac than the desktop vertsion.
The problem is that, anecdotally, no one seems to use Lists

That anecdote is not really worth much. Especially because those lists are probably very important for those who do use them.

Most people won't care about filtering their social relationships, until they do care. At that point, you want them to have the option.
I'm not judging what England should do right now. I'm judging what some Sweden prosecutors did before.
On paper, it doesn't make any sense. Why should an expensive developer spend time learning cheap tasks? Surely we can hire someone to do it.

But the math doesn't work like that on a team.

The paper value I've seen in my company is a huge reduction in communication overhead. We aren't constantly pinging each other for revisions of this or changes to that. The design expert will set the original design. Design-savvy developers pay more attention to detail, implement designs more thoroughly, and can make small changes perfectly. It doesn't sound like a lot, but these details are exactly what make a great product.
That's fair. I think it's about prioritizing. At some point, coding new features becomes less important than improving aspects of the design. So the tradeoff will vary with each situation.
How to Change the World (Or...Occupy Yourself)
the point he is making is that users shouldnt have to do this work. The circle feature implies that they will automatically will take care of it when in fact it doesnt. It's a lot of manual labor as he elaborates.
What are you trying to accomplish by following projects on github? Maybe they can make activity on projects more meaningful, like show you more activity if you're a committer or only big commits if the project is very active but you don't often click on activity items.
Bugs happen. It's software

The OP isn't complaining about this bug. He's complaining of what appears to be a systemic problem both technically and in product design with Googles iOS apps. These issues can't just be hand waved away as easily as "It's software"
Google releases, pulls official Gmail app for iPhone, iPad
He's right in that Facebook was helpful by auto-creating certain "groups" of friends for you based on profile information. Where this completely breaks down is once you move past the trivial task of auto-populating categories for your location, school, and work.

As I see it there are three modes of sharing:

The first is where my post is quite innocent and generic, so I just want to declare it to the world. This goes in public.

The second is where my post is pretty irrelevant to most of my friends, and is really only directed at a portion of them. So to prevent clogging the feeds of the rest of my friends, I submit it to a specific group like "Biking Buddies." Facebook can't learn this or automatically set it up. On the other hand, I rarely care enough to only post to a group instead of public.

The third situation is the opposite of the second: there is a very specific group of people that I don't want to see what I'm about to post. Planning a surprise party or uploading party photos from the night before fall here. In that circumstance I only choose to post to a specific group of close friends. Again, something that Facebook can't deduce from my profile.

You can't get around #3 without doing shit work, except by not posting it to begin with. As a developer you can't avoid this: sometimes manual labor really is the only solution to a problem. Until we invent mind-reading, of course.
I would agree - none of the companies in question forces a user to do this type of work. Only enhances the product if that's how you want to use it.
A text editor is "hotness" in the valley? And that makes it worth using? Please someone assure me that "the valley" culture isn't so arrogant and full of itself that one would really be judged for not giving (frankly) two shits about Sublime Text?

(getting downvoted by Sublime Text 2 fans* it appears)
I have a 2010 MBA, a 2010 Apple Bluetooth keyboard and a 2011 Apple USB keyboard (with number pad). They all feel different, even if the switching mechanism is the same - the Bluetooth one is best (by a long way).
X86_64 Assembly Programming: Hello, World
I think writing DSLs for SQL makes little sense.

SQL is already a declarative query DSL, why not just use it? Putting another declarative layer on top buys you little (syntactic sugar for most libraries, this one additionally seems to deal with one-to-many relations, and I hope that support is read-write, not just read-only) — and isolates you from the database below.

In every serious application I've worked on there was a need to use something which the DSL did not support. So why do it at all?
It also broke my GV app notifications. As soon as I logged into Gmail iOS app, I started getting TXTS forwarded to my email (forwarding is OFF). I'm not sure if the 2 are related but thats the only change I made since morning.
If a designer had a great idea for a simple app, then yes a Rails for Dummies book would suffice I'd say. So why not the other way round?

Also, it's not always the case that a developer has spare money to pay a designer with (the ideal situation). I don't have cash but I do have some spare time in the evenings to work on my businesses.
Does HP's Project Moonshot have enough rocket fuel?
Create Your Own CRUD App with MySQL and PHP
CRUD simply stands for Create, Read, Update and Delete and it is the one of the fundamental principles of programming logic that can be expanded and applied to larger projects.For example, let’s imagine we’re creating a social network and we like to have the ability for users to create accounts, edit and update information for those accounts and also delete said accounts; that is CRUD at work.
I work on quick iterations based on an ongoing design and make decisions based on data.

This requires an expansive, ergonomic, and responsive environment. Optimally, three displays running at 1920x1080.

This doesn't mean I somehow shut my brain off when making design decisions or thinking into the future of my code just because I'm not sitting there for 30 minutes before hammering out a punchcard.

Stop romanticizing the bad old days, the whole reason Unix was made was so that we could have fully interactive programming environments.
For one, I don't really feel like the expletive in the title helped his cause at all. A better title would have been "Facebook suggests groupings of your friends for you!"

I also thought his example was contrived. I mean, is there anyone who's so worried about their social networks that they will hem and haw over whether someone is a coworker or drinking buddy or whatever? And if there is someone like that, well thank goodness Google+ supports their neuroses!
None or very few. Apple was not a startup when it was polishing products to perfection. For a startup, the first imperative should be to stay afloat, or to generate enough revenue to even begin thinking about features that may be "nice" sometime in the future.
In my experience, Prompt is much better app for straightforward terminal use than iSSH. It handles meta keys very well includig the hardware ESC key on the wireless keyboard that iSSH could not, last time I tried it.
The issue I had with ClojureQL is that it seems like the wrong abstraction to me. Myself and others I've talked to have found ourselves fighting with how it tries to model data and more specifically the kind of queries it generates. For example, it is very quick to use rather inefficient sub-selects.
Thanks a lot, certainly more helpful than a best of luck wish.

1) What we're doing really isn't any different at all than people just going to events with friends and then meeting potential friends to date. We want to replicate the way dating works in the real world online. So we are providing an online platform to generate more of these interactions. There is certainly the recognition that people are looking for dates so that changes things a bit.

2)Users will be able to search for dates for themselves or set their friends up on dates as a matchmaker. We're coming up with ways to incentivize the matchmakers but for the meantime are hoping users will find the experience of matchmaking fun. There is concern that the matchmaker will be put in an awkward situation if the date does not go well for their friend, but that really isn't any different than setting someone up offline.

3)There is no cost to businesses to use TLF. We help businesses solve the "butts in seats" problem so they are happy to work with us to arrange a deal that allows us to have users prepay for their dates.

4)We are starting with singles events.

5)We completely agree. Our focus is on the offline interaction between users. Our site will only serve as a means for quickly setting up a shared experience offline.

We are actively looking for a woman to bring on board! When developing the concept we gathered feedback from as many of our girlfriends as we could.

P.S. Although we may be two college guys who read HN we'd like to think we have a decent understanding of the fairer sex.

Thanks again!
Why didn't Google+ import from Google Contacts? I have done a fair bit of organizing there. I would communicate similarly on Google+ as I do by email.
Hackers, Magic and the Problem of Understanding Too Much
This is true. SJ talks about it in one of the Mossberg interviews, I think D8.
While that's all true, the majority of the article has nothing to do with any of that.

It's mostly about basic functionality that's very reasonable to expect, but that for whatever reason doesn't work.
Yahoo reinvents TV-tagging app IntoNow
Not in UIWebView for third-party apps, unless something has changed drastically. Nitro requires that the app be able to set the execute bit on arbitrary pages in memory. Third party apps can't be granted that privilege without essentially throwing the entire app approval process out the window.
Twitter quietly debuts new ‘Top News’ and ‘Top People’
So, it's not magic because it can't read my mind, thus it's a bad feature because it takes work to fully, fully utilize? I guess I'm still missing the point. It'd be nice if Google knew my relationship with these people or somehow knew my best friends from my colleagues or tech interests, but that's asking a bit much.
Gimme Your Money: A Half-Baked History of Shareware
Are you sure of that? My understanding is that there's no difference between single and multi-monitors, ergonomically.
Gold is an industrial metal, though
The iPhone Argument For Pop Music
Facebook also supports my "neuroses" [sic] too. And thankfully. I have tech friends, family, and high school friends that don't know what "linux" is. I like to share articles, a lot, for discussion. I'm "neurotic" because I like to target who I share that stuff with?
Right, because you shouldn't strongly disincentivize behavior that tries to extort people by abusing the legal system and curtailing information freedom. While we're at it, let's stop looking at anything that stinks of a pattern of immoral business practices (that ruin thousands or millions of lives). Only lock up the small-time thieves and fighters (the old-fashioned criminals). Amen to you brother.
If there's more than a little visible desktop around my terminal, I feel like I'm working through a keyhole. Also, being able to stretch out horizontally to 160 characters or more is wonderfully relaxing; it makes chaining two or three tests in an IF readable, in the process saving at least two lines of vertical space, which is in far shorter supply on modern 16:9 displays. (Although, it seems you use your iPad in portrait orientation, which reverses these benefits, I suppose).
Play’n Go Signs Online Gambling Deal
CrazyBlindDate
What do you guys think of the CrazyBlindDate idea? They are on CrunchBase.

http://www.crunchbase.com/company/crazyblinddate

I really like the online dating concept, and have thought about going after the blind date market. Would love to hear your thoughts.
Infrastructure as a Service Providers and Scheduled Outages
http://twitter.com/#!/raganwald/status/131738600931995648

:-P
Obviously the one that is more of a widespread issue. Obesity costs more money to deal with because there are infinitely more obese people in the world than there are who are addicted to heroin. Fast food is legalized which means criminal organizations aren't going to cash in with it, but it does mean more people are going to be eating it because it's easier to obtain.

Certain narcotics are very clearly adverse because they are extremely addictive with very very small amount of use. You argue against "clearly adverse narcotics", does that mean you think it is responsible to make all narcotics legal? Should people be able to get heroin as easily as they get cigarettes, never mind the kids who would easily be able to go get some dude to buy them a hit of heroin or meth.

One mistake run with heroin or meth can fuck your life up for good, no matter what kind of person you are. Proper education and good life styles are a much more effective defense against drugs then legalization.
Very good, clear dissection of PROTECT-IP/E-PARASITES Act. WTB more like this from TC.
Or why not create a dating site which only allows women to contact men?

By creating a one-way dating channel, you can filter out a lot of the behavior which drives women away from sites. Make it a virtual Sadie Hawkins dance.
Moonlighting can be bad for your career
I think Google (along with many other companies) are systematically betting on the decline of native apps. And frankly, I'd prefer a webview app than no app at all
This is actually the first time i've seen a downvoted comment that i just, really can't understand why it was downvoted. Anyone care to explain?

Occasionally an unintended downvote happens when someone on a touchscreen tries to scroll or upvote.
In this case, an embedded DSL brings all the goodies of Lisp's code-as-data to SQL.
Fedora Project loves to challenge the status quo. First it was interface naming, now it's binary locations. What next?
There is definitely room for a ton of innovation and improvement in the online dating industry. Online dating isn't going anywhere and will continue to grow. Social networks and dating sites can be a great way to meet new people. We want to limit the online interaction and have people share an offline experience together as soon as possible. The artificial contact that current online dating platforms provide cannot replace the interpersonal connection that happens in the real life.
I didn't know this, but to be fair webkit's inspector is as good as firebug for my needs and doesn't leak.

Maybe the answer is to roll firebug into default firefox to force the issue and get the leaks addressed?
Startups generally don't have the luxury of cash reserves that Apple has. Apple can afford to be patient and release things when they are ready. Startups usually cannot.
Updated original comment to match.

I was actually wondering about that, something felt wrong about vi only being 20, but not enough to actually look it up. And yeah, I was using the '73-'74 TECO macros date for emacs.
Officially Sanctioned Brothels in WWII Sex and the Somme
Mobblestouch: W3C Touch Events and Gestures
Dear author of Clojure library, please always put a Leiningen dependency string in your home page ([korma "0.2.0"] in this case).

Apart from that, I like what I see, especially how it use c3p0 for connection pooling by default.
That's the point: it's very difficult to automatically determine what someone wants when they follow a project. Sometimes I only want to bookmark it because I know I'll find it useful in the future. Other times, I only care when a new stable version of it is released, with a changelog. When I'm a participant I want to see more details, like new issues or commits.

Instead, because of the lack of options, we're left with an unusable wall of notifications. Smaller projects get drowned out by larger ones, and it tells me every little detail of what is going on with every single project. I'm pretty sure I've never clicked on a single link from it in the past few years of using GitHub.
Visually Examine Google Scholar Search Result with R Wordcloud
The new iPhone's battery life is nearly the same as the old one. What may cause issues (for some people) is the new version of iOS - whatever it is, the problem has something to do with the software configuration. It's not hitting all the users and it seems to be hitting some people with older phones (iPhone 3gs, iPhone 4) when they update.
The author seems to be missing a gigantic point of order here. The reason why Facebook is algorithmically able to determine groups for you is because you, the user, have already entered in fields for Work, School, Location, etc. So the user has had to do a small amount of shit work for Facebook to do its magic.

Of course, that's a very small amount of work relative to manually placing friends into circles. But G+ does not (yet) have the same kind of parsed personal/profile information, which would require the same mechanism that FB has (deciding who to reveal what parts of your profile to)...and which, as far as I can tell, is not trivial to implement, or to graft on to the existing Google Account structure.

Of course, Google can ALREADY do this for you. No doubt they have mined enough information about each user, including locations of IP addresses, to fill out most of your boilerplate profile info. It doesn't take the EFF to realize the privacy implications of auto-filling your circles with people who don't realize that Google's algorithm has correctly guessed their location, age, school and workplace and is now implicitly exposing such information.
I just thought the same thing seeing this post on frontpage and the feedback request submission I made less than one hour ago about my new startup asaclock being flagged from #6 on frontpage to 3rd (now 4th) page without a (IMHO) good reason.
The main reason that drove me to delete my G+ account was the way circles were managed. I had done pretty well so far with 300+ people in my circles but then made the mistake of importing some shared lists into pre-configured lists and ended up with a bunch of grannies posting in my Node.js circle. To comb through, curate and modify a 600+ user circle proved to be way too much shit work than I was willing to do, so I just went ahead and deleted the account.

And I didn't even begin to address the amount of shit content replicated across all of my social media accounts by the same people.