a thoughtful web.
Good ideas and conversation. No ads, no tracking.   Login or Take a Tour!
paxprose's comments
activity:
paxprose  ·  3370 days ago  ·  link  ·    ·  parent  ·  post: Hubski Converted To SQL – Watch For Bugs!

Thanks a lot rob05c,

Like always, your transparency has been a fantastic treat as a user of hubski's services.

paxprose  ·  3370 days ago  ·  link  ·    ·  parent  ·  post: Hubski prototypical API is here

Where can I send you bacon?

paxprose  ·  3382 days ago  ·  link  ·    ·  parent  ·  post: Personality Insights about You Delivered by IBM's Watson

Thanks! I'm really interested in a bunch of the other api's they offer to interact with watson.

paxprose  ·  3382 days ago  ·  link  ·    ·  parent  ·  post: So, is Windows 10 spying on you? (spoilers: no more than usual)

    I'm running the Windows 10 Insider Preview

That fact kind of invalidates his whole testing regime.

Unless he goes back and tests on release of the OS and his results are the same.

paxprose  ·  3383 days ago  ·  link  ·    ·  parent  ·  post: Devski update: SQL speed issues fixed

Thanks, rob! Your updates are always a treat!

paxprose  ·  3387 days ago  ·  link  ·    ·  parent  ·  post: Hubski development progress update: internal api good, Arc bad, external api sooner.

I can't wait to see how you finalize your approach. I have one co-worker nodding his head violently at the prospect that business logic should be handled by the application and enhanced by interfaces as needed while another swears by handling everything in the db.

I lean toward the latter; but I know nothing.

Thanks for the updates, man. Godspeed.

paxprose  ·  3387 days ago  ·  link  ·    ·  parent  ·  post: Hubski development progress update: internal api good, Arc bad, external api sooner.

I wish there were two of you so one could keep an adequate log of all the shit you have to do throughout your conversion process. I'm sad to have missed your livestream.

Enhancing the performance of your queries is a lot of guesswork without the right tools. I need to hop in feet first in some PostgreSQL but that sweet Cassandra is calling my name.

Does the Arc SQL adapter support the use of stored procedures? Have you tried wrapping a view around one of the bulkier tables to filter the results a little and maybe weed out some unnecessary/problem columns? Is your dataset normalized?

I know a bunch of questions isn't going to help; but holy snark I love me some DB discussion.

paxprose  ·  3388 days ago  ·  link  ·    ·  parent  ·  post: What are you working on today?

I just downloaded DrRacket and made a circle.

paxprose  ·  3388 days ago  ·  link  ·    ·  parent  ·  post: What are you working on today?

We'll have to see it when you're done!

paxprose  ·  3390 days ago  ·  link  ·    ·  parent  ·  post: 5 urgent questions about Windows 10 answered

I guess those questions are the 'urgent' ones.

My "urgent" questions are more along the following:

"Why is your EULA so overreaching and scary?"

"Why do you have privacy settings and then ignore what I set them to?"

"Touching back on the EULA, why must I accept automated updates? I personally have an environment in which stability is key and automated updating has burned me in the past...just kidding, six days ago.

    Updates. The software periodically checks for system and app updates, and downloads and installs them for you. You may obtain updates only from Microsoft or authorized sources, and Microsoft may need to update your system to provide you with those updates. By accepting this agreement, you agree to receive these types of automatic updates without any additional notice.

Did I mention scary?

paxprose  ·  3396 days ago  ·  link  ·    ·  parent  ·  post: Internal API on Github, New Tag: #devski

Haha, I'd call you a blasphemer! Let the application generate the Id?! What kind of voodoo are you throwing out here?! (jk)

I'm slowly finding my love for software development residing within the confines of database work.

Most of our legacy application code is generally stable and a lot of tasks I find myself doing is data migration and query optimization. Before that there was a ton of handwritten replication (don't ever do it, please; but if you have to give me a call) but thats all out the window with an in-house automated solution. Almost all my coworkers are database enthusiasts, a few of which I would call fanatics. A couple posses a lifetime of wisdom within the subject that has left me really inspired.

I'm super stoked about you throwing up the schema, thanks a lot!

paxprose  ·  3397 days ago  ·  link  ·    ·  parent  ·  post: Internal API on Github, New Tag: #devski

It might not be a terrible idea to auto increment a primary key on those reference tables for whenever they get big. You'd just put a FK constraint on those one-to-many relationships in the other tables.

create table if not exists "publication_shared_by" (

  id integer identity(1,1), --primary key will help when this table becomes large
  publication_id       integer, -- fk into publication, NOT a pk, one to many
  username text --create a non-clustered index to the 'username' table or something
);

I'm not sure if the identity(1,1) syntax is correct (I work primarily with a T-SQL system).

paxprose  ·  3400 days ago  ·  link  ·    ·  parent  ·  post: Can someone explain to me what the hell is up with the Dota 2 community?

Really all you need to do is get better, or just play with 5's. You'll find that if you're actually playing with competent folks the arguments are generally cogent; albiet a little hostile. At the lower tier matchmaking you get to deal with all sorts of unwelcoming teammates who are frustrated and still learning.

I have a tough time agreeing with the opinion that developers and gaming communities have a moral obligation to take it upon themselves to enforce some code of conduct policy. Policing people's speech is a slippery slope, especially when the fundamental tool (the grand 'ole mute button) already exists to appease those that feel violated. Multiplayer games that are inherently competitive bring inherently competitive people to them. These types of people generally don't enjoy losing and if you're the cause of that, they'll probably let you know.

I'd rather have someone angrily yell at me in an attempt to correct my play-style than me mope in my private chat channel during a game because some algorithm labeled all my teammates as "Toxic Meanies". If what they're spewing in nonsensical garbage, then you mute them; this all seems very melodramatic to try and blow it into the proportion that I think you're attempting to get at.

paxprose  ·  3407 days ago  ·  link  ·    ·  parent  ·  post: Our newest spammer found some bugs

I'm really curious as to how hubski is choosing to deal with automated posting.

It would be a really fun machine learning project to determine if uploads were done by an actual human or a bot. The hard part would be to getting the bot's programmer to think that everything is kosher while you silently associate a filter to their stuff (I think thats what #spam is doing?) to allow users the choice of whether or not to see it.

I'd personally have a great time at attempting to write a bot to test your simulated Hubski-Turing test.

paxprose  ·  3409 days ago  ·  link  ·    ·  parent  ·  post: White House response to Edward Snowden petition

    "Since taking office, President Obama has worked with Congress to secure appropriate reforms that balance the protection of civil liberties with the ability of national security professionals to secure information vital to keep Americans safe.

The Office of Personnel Management (OPM) hack as well as the intrusion to Interior Business Center makes me feel safe as an American /s.

    Instead of constructively addressing these issues, Mr. Snowden's dangerous decision to steal and disclose classified information had severe consequences for the security of our country and the people who work day in and day out to protect it.

Snowden reported that he attempted to do his due diligence and escalate matters through the proper channels, but had no channels to do so. The "danger" as reported by the DoD is that some organizations will alter their behavior making it more difficult to eavesdrop on them. As well, having our allies realize we've been unethically spying on them has caused relationships to go through tension. The former being "unprovable" without classified resources and the latter being common sense.

Unfortunately for the American government, vilifying Snowden won't make anything he revealed go away. Finding him guilty in a kangaroo court won't lessen the impact of the government's blatant abuse technology against its own citizens nor will it fix any of these issues moving forward.

One course of action could be to restructure the NSA's primary objective to auditing and securing existing federal infrastructure. At the same time, hold every single director, congressmen, and senator responsible for contributing to the delinquency of American's privacy; much in the same way they wish to hold Snowden accountable for his actions. Until that happens, I have no qualms about him hiding out in Russia, we're not doing anything to solve the problems he has brought to our attention.

paxprose  ·  3414 days ago  ·  link  ·    ·  parent  ·  post: My wedding was perfect – and I was fat as hell the whole time

As good as thinks she feels about herself now, if she were to lose 100lbs she might actually feel fantastic. This whole "glorify me for who I am," bullshit is nonsense. Results from hard-work and dedication should be celebrated, not the evidence of complacency while perpetually engaged in a mediocre lifestyle.

paxprose  ·  3415 days ago  ·  link  ·    ·  parent  ·  post: Hacker: 'Hundreds of thousands' of vehicles are at risk of attack

Haha! Not my 200,812 mile 2000 Mazda B2500! Who's laughing now?!

paxprose  ·  3416 days ago  ·  link  ·    ·  parent  ·  post: What is your day like? What is your typical routine?

I'm a software developer.

Get up at 4:30am get my pre-workout down and grab my stuff to head to the gym.

4:50 - 6:10 Work out, shower, get dressed.

6:20 - Arrive at the office get settled in and check over unfinished work from yesterday or get started on a new task.

4:30pm - Head home.

4:50pm ~ 9:45pm - Enjoy some recreational programming, eat dinner go to sleep.

Start it all over the next day.

Betteridge's law of headlines...

The video of the article states that the behavior doesn't qualify as primitive domestication, but instead the relationship displays qualities of commensalism (it isn't explicitly addressed with that terminology, I'm not a biologist but thats what it looks like to me).

paxprose  ·  3443 days ago  ·  link  ·    ·  parent  ·  post: Dynamically Declaring Functions and Methods

I didn't interpret it like that at all. Thanks a ton. I believe I'm going to attempt to learn and implement lambdas in C# and see how it goes.

paxprose  ·  3443 days ago  ·  link  ·    ·  parent  ·  post: Dynamically Declaring Functions and Methods

Thank you so much, rob05c. My co-worker got a huge kick out of:

| Everything you mention but don't know the terms for:

"He's schooling you, brah!"

"Yeah. Obviously I fucking need it. I can't even articulate in the proper vernacular what I'm trying to do."

paxprose  ·  3443 days ago  ·  link  ·    ·  parent  ·  post: What are you working on today?

That sound awesome. Got any more information? A link? Some snippets?

paxprose  ·  3443 days ago  ·  link  ·    ·  parent  ·  post: Riots in Paris as Uber Undercuts Taxis

Its a weird thing when a vehicle appears that completely bypasses a large majority of existing bureaucracy. Suddenly, all the made up middle-manning that has caused prices to artificially inflate so someone can get their a cut is exposed for what it is: unnecessary bullshit. Services begin to run more efficiently, participants flock to the new framework, abandoning the systemic issues that have developed over decades that; while perhaps was created with the best interest of the industry, merely inhibits the actual flow of goods and services to the public.

Regulation that protects middle men and their peddling interests ultimately hurt consumers. They need to have the foundations of their business model ripped up beneath them because it isn't sturdy enough to support competition.

paxprose  ·  3444 days ago  ·  link  ·    ·  parent  ·  post: How did you learn programming?

I believe I was 15 when my friend started really getting into software development. I watched him grow into owning his own business, and managing some lucrative contracts while becoming a autodidact computer wizard. I always felt I was too dumb, or the complexity so significant that I would never be able to grasp programming.

I was 22 when I finally sat down and created my first 'HelloWorld' program in C#. I piddled and attempted to "get-it" it for about a year. I can honestly say it was frustrating, probably THE most frustrating thing I've ever done. I banged my head against walls for days trying to meagerly grasp the concepts I was using and most of the time I'd lose. I worked with him for about a year afterwards, digging through his designs in within his WPF application; expanding things and creating new features where I could, and inevitably breaking things where I couldn't. I noticed my little side projects growing in complexity and sophistication while I slowly believed I was figuring out what was going on...

Fast forward to today: I'm above a junior level dev now, for sure. While it will be many, many years before I can remotely call myself a senior, I managed to land a job at small but great company doing work for the oil and gas industry (a very big company). I remember six months ago, I was retarded. Six months before that I was an infant. Every six months the cycle continues and I get better. I still have no idea whats going on (but at least I'm getting paid for it now!).

paxprose  ·  3444 days ago  ·  link  ·    ·  parent  ·  post: PayPal Cuts Off Reddit Clone Voat Over 'Obscenity'

Or a community with no admins at all... ;)

paxprose  ·  3445 days ago  ·  link  ·    ·  parent  ·  post: The Feynman Series

Richard Feynman - The World from another point of view

His brilliance is just friggin' inspiring. It demotivates me a little to think that at 14, his knowledge and understanding probably surpassed anything I will hope to achieve in my lifetime.

paxprose  ·  3445 days ago  ·  link  ·    ·  parent  ·  post: Pre-Trip Report: We're off to Curaçao right.... Now.

Have a great work-cation!

paxprose  ·  3450 days ago  ·  link  ·    ·  parent  ·  post: Men's contraceptive pills are coming.

Thats a much better article.