HNHacker News
TopNewBestAskShowJobs

jastr

561 karma · joined November 21, 2011

CSV Explorer - Open CSVs with millions of rows <https://www.CSVExplorer.com>

The Simple Postcard - Text a photo to send it as a postcard <https://www.TheSimplePostcard.com>

Pretty Print Please - Pretty Print Invalid JSON <https://PrettyPrintPlease.com>

jason (an @ sign) csvexplorer.com

submissionscomments
jastr··on Malicious software libraries found in PyPI posing as well known libraries
pip list --format=legacy | cut -d' ' -f1 | xargs egrep '^(acqusition|apidev-coop|bzip|crypt|django-server|pwd|setup-tools|telnet|urlib3|urllib)$'
jastr··on Malicious software libraries found in PyPI posing as well known libraries
pip list --format=legacy | cut -d' ' -f1 | xargs egrep '^(acqusition|apidev-coop|bzip|crypt|django-server|pwd|setup-tools|telnet|urlib3|urllib)$'
jastr··on Malicious software libraries found in PyPI posing as well known libraries
Avoid some false positives

pip list --format=legacy | cut -d' ' -f1 | xargs egrep '^(acqusition|apidev-coop|bzip|crypt|django-server|pwd|setup-tools|telnet|urlib3|urllib)$'

jastr··on Malicious software libraries found in PyPI posing as well known libraries
To check a few you different requirements.txt files (will look 3 folders deep)

find . -maxdepth 3 -name requirements.txt | xargs egrep '^(acqusition|apidev-coop|bzip|crypt|django-server|pwd|setup-tools|telnet|urlib3|urllib)'

jastr··on Ten Years of Worthless Side Projects
Email me, I can share a technique I use to find them.
jastr··on Ask HN: HNers who got their “Show HNs” on homepage, how is your site doing now?
CSV Explorer, 4 months ago (https://news.ycombinator.com/item?id=14043527). It's a tool to open CSVs that are too big for Excel. It hit the homepage, but many comments were "I would never trust my data in the cloud" or "Why doesn't everyone use Python/Pandas/SQL".

Paying customers now include consultants, journalists, realtors, insurance companies, and others! There are few developers who use it because it saves them time, but they're the exception.

jastr··on “Spiel des Jahres” Game of the Year 2017 winners
Small games with good replay value

1. Jaipur: 2 Players only, acquire different goods to trade in the market.

2. Coup: Multiplayer, lots of bluffing

3. Monopoly Deal: Simple, fast paced game (with little resemblance to Monopoly)

jastr··on Teaching Pandas and Jupyter to Northwestern journalism students
I've found that most of the queries that journalists are trying to run are pretty basic, mostly filtering and histograms. Setting up a virtualenv, dependencies, etc can be tough. And RTFM isn't sufficient for someone getting started. I was surprised that nothing existed for this, so I built it.

It has the basics of a Jupyter notebook - filter, sum, average, plot. So far it's attracted a pretty interesting audience including journalists, but also lawyers and consultants.

www.CSVExplorer.com

jastr··on Don't use Hadoop when your data isn't that big (2013)
For datasets maxing out at 2Gb you can try www.CSVExplorer.com . It might be a good way to give your clients access to their data.

Disclaimer: I built CSV Explorer.

jastr··on Show HN: A tiny python app for viewing Twilio SMS Logs
This little python script will fetch your Twilio SMS logs with a specific user/phone number and display them like a chat app.

I built it because debugging automated conversations through the Twilio logs was really painful!

jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
It sounds like CSV Explorer might work well for them.
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
Update: A one minute demo video - https://youtu.be/RBiDL5neWDc
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
Perhaps - I tried a client-side implementation, but I had issues scaling past a few hundred thousand rows. I understand hesitations of uploading data to the cloud, but I now have users looking at hundreds of millions of rows in seconds thanks to Postgres!
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
I originally wrote it in entirely client side JS, but it didn't scale nicely past a few hundred thousand rows. For the really big datasets, CSV Explorer loads them into Redshift - queries takes a few seconds!
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
Thanks - having worked with health data for a few years I can relate. Unfortunately, I don't have plans for a desktop app right now.
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
Some consultant friends asked for help when they got a 60Gb CSV file from their client! Since then, I've also found that lots of tech companies share CSV internally. I've also worked with journalists attempting to look at large public government datasets.
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
This project came out of some of my contracting work for consultants, journalists, lawyers - people who don't know what a command line is.
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
It's like a Jupyter notebook for non-engineers, people who don't know what python is, eg. consultants.
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
Csvkit is great, and I use it a lot. The target users for CSV Explorer though are mostly non-engineers ie. people who don't use the command line or code.
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
I was in the first batch of YCombinator's Fellowship.
jastr··on Show HN: CSV Explorer (YC F1) - Explore CSVs with Millions of Rows
Hi HN!

A few months ago, a college friend reached out because his consulting company had just received a 60 Gb spreadsheet, and they didn't know what to do with it! They actually tried opening it in Excel.

I'm excited to Show HN CSV Explorer - a simple web tool for opening really big CSVs! Try it out, and let me know how it goes!

jastr··on Show HN: CoolGamer – Create a free website for your game, as easy as it gets
Is there an example site we could see?

The Twitter authorization permissions are excessive. Why does it need to be able to post tweets and update my profile?

jastr··on Ask HN: How to best teach a group of children how to code?
New Weekend Project - A website that teaches the console by leading you to modify the website via the console.
jastr··on Show HN: Interactive Periodic Table
At first I was clicking on elements and nothing happened. Luckily, I scrolled down and realized that the information on the elements was being shown below the fold. You might want to indicate that somehow.

Also, not sure if this is intentional but div#pageBody overlaps the side navigation bar by a few pixels.

jastr··on Show HN: Beautiful chord chart of companies engineers are moving from/to
It's difficult to tell from the visualization the direction the employees are moving.
jastr··on Show HN: QuickPages, a Free Landing Page Builder
Is there a demo site we can see?
jastr··on Ask HN: Successful one-person online businesses?
The landing page looks a bit too sparse (and unprofessional), which would turn me away. [1] Consider filling it out a bit more with: screenshots, pricing, a privacy policy, etc.

Take a look at s3stat.com above for a good example, it's much more polished without much more content.

[1] I send a few thousand SMS a month via Twilio for thesimplepostcard.com

jastr··on Show HN: Front End Design Elements
The effects I was able to see were nice, but I couldn't see most of them. CodePen was just a mess: cross site requests, missing headers, etc.
jastr··on Ask HN: What was your best passive income in 2016?
Exactly. I looked in to charging via their phone bill but couldn't find an API.
jastr··on Ask HN: What was your best passive income in 2016?
I need to find a postcard printer in Europe.
← PreviousPage 2 of 6Next →