bshipp

36 ms·

361.
by bshipp 8y ago
Don't forget about the 'ATTACH DATABASE' option as well. It is great for linking up individual SQLite databases when you need to do a broad-based query across multiple sources. https://www.sqlite.org/lang_at
362.
by bshipp 8y ago
As with anything, it depends on what you want to do. One of my SQLite databases has a text column that's 500 million rows (it's an 80GB file). Even with a standard COLLATE NOCASE b-tree index, searching out a word in the middle
363.
by bshipp 8y ago
I tend to use postgresql in my daily work now but I will always carry a flame for sqlite, my first DB experience. I still use it for rapidly parsing and normalizing huge text files, as well as the backend for numerous one-off webscrapers.
364.
by bshipp 8y ago
What the heck, how is it that I haven't seen these yet? Maybe one of the downfalls of becoming comfortable enough with the syntax that I'm not having to look up documentation on the docker website anymore is that I'm more an
365.
by bshipp 8y ago
I agree, that's a very useful and necessary distinction that I neglected to include in my original comment. Without those spontaneous user-composed opinions and anecdotes, the platform would quickly become (or perhaps already has becom
366.
by bshipp 8y ago
That's a little disingenous. No doubt you are correct that 99.9% of the user-generated content is benign, but that 99.9% of user-generated content would likely not represent 99.9% of viewer traffic. If only 0.01% of toxic content by t
367.
by bshipp 8y ago
oh, for the love of...two hours into work and I read this thread and there's a fat-fingered spelling error that I can't edit anymore. The url is obviously http://web.archive.org/save/https://<url-
368.
by bshipp 8y ago
if you're finding stuff that's not on archive.org just append web.atchive.org/save/ in front of the url to get the crawler to capture it. I used to have a chrome and Firefox JavaScript bookmarklet to do it in one click b
369.
by bshipp 8y ago
Given the amount of mojibake I've had to clean out of databases I'd have thought that data scientists would be the first to latch on to sane Unicode handling instead of the willy-nilly string handling inherent with py2.
370.
by bshipp 8y ago
I have an assortment of Django and flask-based websites and Django still works fine for new projects from my perspective, with the normal caveat that it really depends on what you want to do with it. If i had to redo some of my projects I&
371.
by bshipp 8y ago
> PyPy has stagnated seems to me that they just released updates bringing it in alignment with python 3.6, which is only one version behind current, no? I'm curious why they couldn't run the pure python implementations throu
372.
by bshipp 8y ago
For a brief moment I had a flashback to my early university days pecking away at my pine email terminal, and wondered how in the world that client was still kicking all these years later. Alas, no such luck. Pine is dead.
373.
by bshipp 8y ago
This has happened to me numerous times. I set up an appointment in Outlook assuming I'll be there remotely via webconference and then end up having to travel there in person. I've been bitten enough times to double-check the time
374.
by bshipp 8y ago
If I'm going from my personal experience when travelling across timezones, I generally set my phone to the local time, check it about 5 times, call the front desk and request a wake-up call, and set the bedside alarm. All three have f
375.
by bshipp 8y ago
In situations with ambiguity like this, it's probably best to ask the user instead of make assumptions. I would not be remotely perturbed if my phone had a pop up when I stepped off the plane asking me if I still wanted to wake up at 7
376.
by bshipp 8y ago
Criticisms of the underlying hardware/software aside, my intuitive answer to the headline question is "because governments are buying them." Perhaps the esteemed Senators should undertake a short naval-gazing exercise and ask
377.
by bshipp 8y ago
I'm not sure how productive I'll end up being, but it's way more fun to play with than Visio.
378.
by bshipp 8y ago
I feel like Bill Murray in Punxsutawney. Didn't we just see this article yesterday? https://news.ycombinator.com/item?id=19492562 Here was my comment from yesterday morning: >Question 1: What problems am I trying
379.
by bshipp 8y ago
Thanks for the response, and I will definitely take another look at MongoDB and it's recent enhancements!
380.
by bshipp 8y ago
>Question 1: What problems am I trying to solve? I wish I had really thought about this when I first wrote my largest web scraper. At the time, I was still relatively new to database design and programming in general. This web scraper
381.
by bshipp 8y ago
It's too bad they messed up the title on this submission, because this is a fun article to read. I was in a similar financial position, living in a million-plus city with rent that was over $1400/mo and two kids, with a third on
382.
by bshipp 8y ago
I think the standards in academia are quite different than those in the workplace, primarily because the expected outcomes are quite different. In academia, the instructors are attempting to tease out your understanding of the underlying co
383.
by bshipp 8y ago
You're absolutely right. In another comment I stated: > Again, I reiterate that these people aren't leaving because of the open office space concept. Removing all of the walls in the office just happened to also remove any re
384.
by bshipp 8y ago
I used to swear by mechanical keyboards; I wrote my entire thesis on one, much to the chagrin of my graduate student officemate. She still brings it up when I see her, twelve years later! For me, the difference was similar to weighted vs u
385.
by bshipp 8y ago
I think it's very much workplace-centric. The new manager who implemented this open office system came from a commodity sales background, so having all of these salespeople in the same room increased communication efficiency. However,
386.
by bshipp 8y ago
We need some sort of security vulnerability name generator. A google search later and of course it already exists, hahaha: https://paulbellamy.com/vulnerability-name-generator/
387.
by bshipp 8y ago
I also prefer the open source concept, but I always have--in the back of my mind--the case of Azer Koçulu: https://qz.com/646467/how-one-programmer-broke-the-internet-... I recognize that it's a leap to go from de
388.
by bshipp 8y ago
Our office just converted to an open space design with fancy desks that elevate for standing or drop to sit. Although it's a small office, one of my coworkers already left (and refuses to communicate with any of the management except
389.
by bshipp 8y ago
Although I have immense respect for the effort gone into Antlr and the potential it has, I must admit that on the few times in the past I've attempted to leverage it I've never felt more stupid than trying to figure out how to gen
390.
by bshipp 8y ago
I'm not an expert coder by any stretch of the imagination, but the linter built into Pycharm does a decent job of identifying the most egregious typing errors, IMHO. I think a lot of it really comes down to how much domain knowledge yo

More ›