nusmella (u/nusmella)

nusmella commented on Accidental database programming sqlsync.dev/posts/stop-bu... · Posted by u/thunderbong

nusmella · 2 years ago

An old company I worked for used project management software with a check-in/out mechanism for making changes. When you "check out" a project it downloads a copy that you change locally, then "check in" uploads it back to the server. A project is "locked" while in the "checked out" state. We all felt it was an archaic mechanism in a word of live updating apps.

After 10 years of building SPA "web apps", that data synchronization mechanism feels ahead of its time.

nusmella commented on NPMprune: Remove unnecessary files from node_modules to optimize storage github.com/xthezealot/npm... · Posted by u/arthurwhite

arthurwhite · 2 years ago

While pnpm optimizes storage and reduces duplication, it does not inherently remove non-essential files (like documentation, Markdown, or test files) within the dependencies.

Also, when you create a Docker image, you avoid packing in dev tools that aren't absolutely essential (such as pnpm).

nusmella · 2 years ago

Even the alpine nodejs images have pnpm and yarn nowadays

nusmella commented on Amazon Aurora Limitless Database aws.amazon.com/blogs/aws/... · Posted by u/samaysharma

Agent766 · 2 years ago

I can't wait until people find its limits!

nusmella · 2 years ago

I can't wait until people find its limits... in production!

nusmella commented on Google Drive files suddenly disappeared support.google.com/drive/... · Posted by u/vedlin

nusmella · 2 years ago

My Pixel 5 bricked recently after the latest android update.

Waited weeks to upgrade so that upgrade issues could be resolved by Google.

Lesson learned.

nusmella commented on The Curse of Docker computer.rip/2023-11-25-t... · Posted by u/sklargh

eviks · 2 years ago

Has any great design been invented that isn't tied to hardcoded paths preventing multiple versions of the same library etc and would allow easy linking to any version? Nix? Anything else?

nusmella · 2 years ago

I don't know if this is normal or if anyone else does it but I usually either download binaries or compile from source and move the executable to /usr/local/bin/ and create a symlink. Lets me easily switch between versions. I avoid using a package manager for anything where I want control over the version and installation.

- curl -fSLJO $RELEASE

- tar xvf $DOWNLOAD.tar.gz && cd $DOWNLOAD`

- make .

- mv $EXECUTABLE /usr/local/bin/$EXECUTABLE-$VERSION`

- ln -s /usr/local/bin/$EXECUTABLE-$VERSION /usr/local/bin/$EXECUTABLE

- # chmod 750, chown root:$appuser, etc

Works great for everything I've tried thus far. Redis, HAproy, Prometheus exporters, and many more.

nusmella commented on Aurora I/O optimized config saved 90% DB cost graphite.dev/blog/how-an-... · Posted by u/fosterfriends

Ozzie_osman · 2 years ago

Curious what you mean by switching from Aurora to Postgres? AWS offers Postgres on Aurora, and Postgres on regular RDS. Do you mean you switched to RDS, or off of AWS altogether, or something else?

nusmella · 2 years ago

I mean that we switched from RDS Aurora Postgres to RDS regular Postgres

nusmella commented on Aurora I/O optimized config saved 90% DB cost graphite.dev/blog/how-an-... · Posted by u/fosterfriends

nusmella · 2 years ago

We have a 10TB database we switched from Aurora to Postgres and it cut out bill by 80%. However, there are some differences in our schema such as now using native partitions so it's hard to tell how much $ is due to the switch and how much due to our table and query design.

We have a similar story with DynamoDB too.

nusmella commented on My journey away from the JAMstack spicyweb.dev/farewell-jam... · Posted by u/brycewray

nusmella · 2 years ago

I don't understand the appeal of serverless.

>it costs less

That's only true if you have low traffic in which case why not host from a $50/mo (at most) VPC? If a business can pay your salary then surely they can afford an extra $50/mo cloud costs.

>you don't have to manage servers

However now you have to learn to write serverless functions that will execute in an environment fundamentally different from your local machine making it more difficult to develop. So you've reduced time spent in devops and increased time spent in development.

nusmella commented on Whom the gods would destroy, they first give real-time analytics (2013) mcfunley.com/whom-the-god... · Posted by u/sbdchd

PeterCorless · 2 years ago

This is very 2013. Meanwhile in 2023, a decade later, you literally have systems detecting credit card fraud in milliseconds. [Disclosure: I work for StarTree, which is powered by Apache Pinot. We eat petabytes of data for breakfast.]

nusmella · 2 years ago

I wonder if these are the same systems that "detect fraud" and freeze my bank account requiring manual intervention to fix the 2 times a year I send a random family member less than $2,000

u/nusmella

KarmaCake day66July 25, 2023View Original