HNHacker News
TopNewBestAskShowJobs

vanpythonista

33 karma · joined June 14, 2018

submissionscomments
vanpythonista··on My experience with exporting Postgres RDS partitioned tables to S3
You can use a RDS Snapshot to export to S3 in Parquet format: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_...
vanpythonista··on Fast analysis with DuckDB and Pyarrow
Glad you like it. A CSV->Parquet conversion command would certainly be really useful!
vanpythonista··on Fast analysis with DuckDB and Pyarrow
Shameless plug, my project exposes the common Parquet operations using a Rust CLI tool that utilizes the Rust API for Apache Arrow and can be used without any Java/Hadoop/Spark dependencies. Also available a static binary.

https://github.com/manojkarthick/pqrs

vanpythonista··on Show HN: Code Snippet Formatter – for email and docs
The Copy to Clipboard button doesn’t seem to be working in Safari (iOS 15).
vanpythonista··on Postico: A Modern PostgreSQL Client for the Mac
If like you missed doing it when defining the source, you can also go into your data sources list and the sidebar has a "make global" option.
vanpythonista··on Show HN: Open-source app to show meetings in status bar (macOS)
I’ve been using MeetingBar for the past ~6 months and it’s been really handy in seeing and joining the meetings for the day quickly. Thank you for building this!

(My favourite feature is being able to parse the ugly Outlook Safe Links to figure out the type of meeting - teams, zoom, etc)

vanpythonista··on Show HN: OneModel – Diagramming tailor-made for Software Engineers
Thanks! I sent an email. It would also be great if there was a button to change the orientation of the diagram from left-right to top-bottom.
vanpythonista··on Show HN: OneModel – Diagramming tailor-made for Software Engineers
This looks amazing! Thank you :) Is there a way to request more icons to be added or a way to add custom icons? This is the probably the one thing that stops me from replacing draw.io with this!
vanpythonista··on Show HN: GitRel - Install and update binaries via GitHub Releases API
This looks great! There’s also https://github.com/marcosnils/bin that works similarly that you might want to check out!
vanpythonista··on Docker for Mac Without Docker Desktop
Gitlab maintains a fork of docker-machine with critical bug fixes that I've been using recently since Docker deprecated it: https://gitlab.com/gitlab-org/ci-cd/docker-machine
vanpythonista··on GitHub’s engineering team has moved to Codespaces
Microsoft Outlook/Office 365 costs money, but they still analyze your activity and report so called "productivity score". Maybe not sell, but I have no doubt they will analyze the data if they can.
vanpythonista··on Stop using your work laptop or phone for personal stuff, because I know you are
You can install brew in your home directory using the Untar Anywhere approach. I’m particular sceptical of how brew handles permissions, so I always install it to ~/homebrew. One thing to note, if you use this approach Homebrew will not use its precompiled binaries and build everything from source.

https://docs.brew.sh/Installation#untar-anywhere

vanpythonista··on PHP has been removed in macOS Monterey
I've used it as my primary package manager on macOS for six months, but ended up dropping it. My main reasons -

* Nix doesn't have support for GUI apps like homebrew cask does - which meant I couldn't drop homebrew anyway. * The nix ecosystem forums suggest using nix-shell for managing packages for other languages, eg. python, java - but it's been really difficult to convince team members to use nix instead of pyenv, conda, gradle etc

vanpythonista··on M1 Mac owners are experiencing high SSD writes over short periods of time
You can use: brew install smartmontools && smartctl --all /dev/disk0 to get this data
vanpythonista··on Show HN: Reddsaver – CLI tool to download saved media from Reddit
Hi, HN! When browsing Reddit, I usually like to save cool/interesting images, videos and GIFs from various subreddits and wanted a way to download them periodically to my machine. I developed this tool to download such content from the command line using the Reddit API.

It has some great features you might find useful:

  - Multiple media types supported: mp4, gif, gifv along with png/jpg images

  - Multiple hosting providers supported: reddit, imgur, giphy, gfycat, redgifs

  - Option to restrict downloads to specific subreddits

  - Allow automatic unsave of reddit post after downloading

  - A dry-run option to process and show the list of media that would be downloaded without actually downloading them
If you find it interesting, please check the out the GitHub page for more details and/or take a look at the demo. Also, this is my first Rust project, so any feedback is welcome!

GitHub: https://github.com/manojkarthick/reddsaver/ Demo: https://asciinema.org/a/382339

vanpythonista··on Common pronunciations of Linux directories, commands, etc. (2017)
I use "cuttle", but someone I know calls it kubec-tal (Q-beck-tal), which is the weirdest of all the variants.
vanpythonista··on New coronavirus variant: What do we know?
https://threadreaderapp.com/ is a popular choice that allows you to combine a tweet thread into a single page.
vanpythonista··on Jetbrains founders turn billionaires without VC help
The Database plugin from IntelliJ and Datagrip is essentially the same. My guess is people like to have separate tools based on their purpose and Datagrip serves that need.
vanpythonista··on AWS Managed Workflows for Apache Airflow
I like Argo and have used both solutions, but I'm not yet convinced that YAML based workflows are superior to Airflow's Python Code as workflows.
vanpythonista··on Netflix is creating a problem by cancelling TV shows too soon
The cancellations of Santa Clarita Diet and One Day at a Time were completely unwarranted in my opinion.
vanpythonista··on Backing up data like the adult I supposedly am
I'm personally using restic[0] to create encrypted/de-duplicated backups. I use a local external drive and Backblaze B2 to push the snapshots to. There's no server to maintain.

The best thing about restic in my opinion is the ability to mount[1] the snapshots using FUSE to my machine without actually explicitly extracting the backup to a local directory.

[0] https://restic.readthedocs.io/en/latest/index.html [1] https://restic.readthedocs.io/en/latest/050_restore.html#res...

edit: formatting