mmckelvy

12 ms·

61.
by mmckelvy 7y ago
A lot of these answers seem to focus on app analytics (e.g. collecting clicks, page views, etc. from Segment). How are people collecting / integrating financial data (e.g. sales, subscriptions, expenses)?
62.
by mmckelvy 7y ago
Man made noise is certainly a nuisance, but I think “nature” is not always as quiet as we like to think. A few years ago I spent a week out in the middle of the Costa Rican jungle — miles from anyone. One thing that stuck with me was how l
63.
by mmckelvy 7y ago
Long time React user here, have started experimenting with hooks. My general sense is the useState hook is a pretty neat idea, but useEffect and friends need some work. Definitely doesn't have that same "completely makes sense,
64.
by mmckelvy 7y ago
I'm not sure an ORM adds much in the way of casting data or preventing malicious input. Both of those features are readily available in Postgres itself. As far as formatting, the usual drivers (e.g. node-postgres) return rows as simp
65.
by mmckelvy 7y ago
For cases like this, I use pl/pgsql functions and dynamic queries. Dynamic queries take extra care and aren't the most pleasant things to write, but they can handle the GET /things with 10 parameters endpoints quite well.
66.
by mmckelvy 7y ago
I'm a web developer (React / Node.js) and I bought the first edition of this book (it was called Mastering PostgreSQL in Application Development then). I can say that it really changed the way I approach building apps. I definit
67.
by mmckelvy 7y ago
In my experience, you don't really have to target es5 anymore. Most browsers support new features all the way through es2018. My Babel / Webpack config is pretty minimal these days.
68.
by mmckelvy 7y ago
> Close to the metal craft. Loved this phrase.
69.
by mmckelvy 7y ago
> We found that no one actually wants to use these tools— they just have to, and that the only people who were satisfied with the state of things were folks who had assistants they could offload the work onto. I suspect this is the case
70.
by mmckelvy 7y ago
Completely agree. I think web development is a lot simpler and faster without GraphQL.
71.
by mmckelvy 7y ago
Such a good point. I think MS Office peaked with Office 2003. Most changes since have made the product slightly worse in my opinion.
72.
by mmckelvy 7y ago
Is it effective to query across different data sources / SaaS services without first aggregating all the data in some sort of data warehouse?
73.
by mmckelvy 7y ago
I actually think there's an opportunity in the opposite direction: convert your SaaS apps to spreadsheets. Instead of having to log into 10 different SaaS apps, you simply make a few menu selections from within Excel / GSheets and
74.
by mmckelvy 7y ago
This. A spreadsheet is the best UI for most data intensive / business apps.
75.
by mmckelvy 7y ago
My general sense is that high quality software always wins in the long run. I'd argue that is the primary reason Google has rapidly gained share in markets traditionally dominated by Microsoft and other enterprise software companies -
76.
by mmckelvy 7y ago
With shared spreadsheets, this should become less and less of an issue going forward I would think.
77.
by mmckelvy 7y ago
With formulas, custom formats, charts, etc. I think you can make a pretty solid case that Excel is far more than a form. But even if you are just using it as a form, with bulk operations and keyboard shortcuts, it's usually much easier
78.
by mmckelvy 7y ago
> As React webapps get large and start to contain a lot of complex components, they often do not perform well and manifest low FPS in browser. Is this something you have actually experienced? Can you cite an example of running into this
79.
by mmckelvy 7y ago
- Because a spreadsheet is the best UI for many business applications (far better than an HTML table on a webpage). - Because Excel allows the user to (i) perform ad-hoc calculations, (ii) audit the input and outputs, and (iii) easily modif
80.
by mmckelvy 7y ago
Sigh. I really wish people would just accept the fact that JavaScript is a dynamically typed language and stop making things unnecessarily difficult.
81.
by mmckelvy 7y ago
I've been searching for a basic React UI component system for awhile now. There are a lot of systems available, but each one has significant drawbacks to the point I end up just rolling my own. I think an ideal system would have a core
82.
by mmckelvy 8y ago
Web components will never take off because they are HTML-first and rely on DOM apis. The reason React is so popular and the reason it dethroned Angular, Backbone, etc. is because it is JavaScript-first. In other words, it gives you the pow
83.
by mmckelvy 8y ago
I've used Barman for physical backups (I used the streaming backup option). Works well, though it's a bit of a slog to get set up the first time (the docs can be confusing in some areas) but once it's up it's great.
84.
by mmckelvy 8y ago
Related aside, what's the best way to run Microsoft Office on a Linux box? My ideal setup would be Linux for everything but Office programs, which I'd prefer to run in a Windows environment.
85.
by mmckelvy 8y ago
I think the cracks in "break the rules" startups such as Uber, Airbnb, Tesla, etc. are starting to show. However, I think these companies have surfaced some interesting product ideas with accompanying demand. More established pl
86.
by mmckelvy 8y ago
How much of this stuff is taken care of out of the box by Hapi.js? I'm an Express user but was taking a look at Hapi.js the other day and it seems like it handles at least of a few of these concerns.
87.
by mmckelvy 8y ago
Funny, I was just looking for something like this. I specifically wanted a note taking app where I could use my text editor and all its power but see the notes rendered close to real time. Great timing! Will give it a look.
88.
by mmckelvy 8y ago
How many banks do you have in your network? Is there a place I can see which institutions you support?
89.
by mmckelvy 8y ago
I've always thought fraud would be much more preventable if credit card companies would simply send you a text or verification code each time your card was charged, or require a PIN. It seems this is difficult for the big credit card c
90.
by mmckelvy 8y ago
In addition to the animation, I liked the "immersive" feel of the main pages. This effect seems to be created by allowing the navigation elements to "frame" the entire screen and then placing a single piece of content a

More ›