HNHacker News
TopNewBestAskShowJobs

falco925

24 karma · joined September 29, 2014

submissionscomments
falco925··on Ask HN: What is your playbook for profitable SaaS without outside investment?
I have a similar story except I didn't move anywhere to reduce burn, I just worked a full time job and built the company in my off hours. But I did prototype, charging a small fee, for almost 2 yrs too. Once I launched the v1, I went from 1k MRR to 20k MRR within 12 months. Congrats on your success. It's always hard work.
falco925··on Show HN: Simple Python script to automatically upload CSV files to a database
Thanks for at least taking a look and replying =) I do know a bit of Django and will likely extend to other dbs, if there's a need. I originally connected to both HIVE and Greenplum databases because that's what I have at work. As a hobby, I just create postgres dbs on AWS so I mainly connect to those these days. Thanks for the tip.
falco925··on Show HN: Simple Python script to automatically upload CSV files to a database
Just wanted to share a simple py script that I built to automate uploading multiple csv files to a postgres database.

The script will clean the file name and column headers and create the SQL statements to create the db table and upload the file to the database, automatically.

I used this script almost everyday at my past job to upload data from other teams and departments.

I recorded a tutorial on youtube for anyone that wants to try to build it out (links in the README). Hope this is helpful either as a way to easily upload files to a db or as practice getting better building python scripts to automate your work.

falco925··on Ask HN: What is your passive income 2020?
Following you on IG now. I just wanted a medium where your site and it's art work would bubble up on occasion since I'm not always buying artwork. I think IG is perfect considering you just share art work. Perhaps promoting the IG channel more on the website would help?

A mailing list is nice because you're actually collecting emails and can use them somehow in the future. You could collect emails and then send users a welcome email that also promotes your IG channel. It just wasn't obvious you have an IG channel. Hopefully this is helpful.

falco925··on Ask HN: What is your passive income 2020?
very cool. Can I suggest you add a mail list feature to collect emails? I very much want to stay connected with you guys and get your latest news.
falco925··on Ask HN: What is your passive income 2020?
This is a really cool site. Will buy some art from here! Congrats man
falco925··on Ask HN: What is your passive income 2020?
I built a webapp with hundreds of SQL and python questions to help aspiring data scientists practice for their interviews. It's not really passive because it was a massive undertaking to write the questions/solutions and create the app. Now I got to market it by creating video solutions and posting it on Youtube. But I created it to help with my other side job which is teaching data science in the evenings at a university.

https://platform.stratascratch.com

falco925··on Show HN: A collection of 1000 (mostly free) data science interview questions
Hey guys, I've posted here before to show off a collection of 500 SQL and python interview questions (https://platform.stratascratch.com) and got a lot of great feedback from you all. I'm back because I wanted to share 500 more data science interview questions -- this time covering concepts in statistics, modeling, product sense, probability, business cases, and system design. They're all free and were collected from various public sites. But they're free because I'm only 1 person and can't answer them all. I'm hoping the data science community can contribute. These questions all have discussion forums attached to them, sort of like StackOverflow and Reddit style.

I'd love it if you guys could share your thoughts on it! Does this hit the mark as an educational resource to prep for interviews? What can be improved?

And just to be transparent about my end goal here, I'm hoping for this site to be largely free. I just wanted to create a site where people can have technical conversations around data science, and am starting with the niche of interview prep. The coding questions do have an executable IDE with datasets so I do have to charge for most of those questions to pay for my server costs.

falco925··on Show HN: I collected 500 python & SQL questions from data science interviews
Yea, I completely understand what you're talking about. There's many "solutions" because sometimes there's no real solution. In practice and in an interview, often times it's about a dialogue and aligning with an approach and assumptions.

My implementation of having 1 solution isn't good enough. I plan on adding a discussion forum to discuss these exact topics.

falco925··on Show HN: I collected 500 python & SQL questions from data science interviews
In practice, rarely ever. I do my data pulls and some joining and manipulation in SQL. But anything more complicated gets done in python.
falco925··on Show HN: I collected 500 python & SQL questions from data science interviews
Hi, thanks letting me know. I'll make sure to add that feature in ASAP. Appreciate it.
falco925··on Show HN: I collected 500 python & SQL questions from data science interviews
Thanks so much. The data science interviews are a bit of the kitchen sink as well. I am also planning to release a bunch of technical non-coding interview questions that cover statistics, modeling, machine learning, product sense, business cases, etc. The biggest problem I'm facing is that it's taking me forever to write up solutions for these types of questions. I'm thinking about making it a discussion forum so others can help contribute.

But thank you for the kind words. I appreciate you taking the time to look at it.

falco925··on Show HN: I collected 500 python & SQL questions from data science interviews
Hey guys, just wanted to share a resource that I created a while back but recently redesigned and relaunched. I collected 500+ data science interview questions for SQL and python coding questions. I kept many of the questions as is and re-wrote others while still testing the same concepts they would test for in interviews. The platform has a fully executable IDE with datasets. Many of the questions are free. I'd love it if you guys could share your thoughts on it! Does this hit the mark as an educational resource to prep for interviews? What can be improved?
falco925··on Show HN: Prepare for SQL interviews with real questions from companies
Hi HN,

I've spent my career continuously prepping and practicing for technical interviews, specifically SQL and python. I also teach SQL and python as an adjunct professor at a local university.

I built Strata Scratch to help others prepare for their technical interviews and brush up on their skills. I loaded it with over 500+ technical interview questions I've sourced from various sites.

The platform is about 2 years old and is growing. It's only a side hustle of mine but it's continuously improving. It's free to try out but has a monthly subscription if you want to see the solutions, otherwise, you can access all the 500 questions.

Any feedback or feature requests would be greatly appreciated!

falco925··on Ask HN: Successful one-person online businesses?
I run an edtech platform that helps users improve their analytical skills and prepare them for technical interviews. It's somewhat niche in that it's a platform focused on beginner marketing analytics and data science.

I launched it 2 years ago, mainly to help me teach a university class more effectively (I wanted something easy for non-technical beginners to learn). I spend about 5-10 hrs a week bouncing around developing and marketing. I make enough to hire a part-time developer that helps me with engineering. Otherwise, I do everything else myself.

The toughest part for me is marketing. Currently, I do a lot of writing on Medium to talk about the industry and will include a short call out to my platform at the end. I've tried other marketing channels like Youtube and Google ads but haven't found anything that beats writing articles.

While the platform is only 2 years old, I make almost 6 figures in revenue and it keeps growing linearly. My ultimate goal is to passively have this income take over my professional salary so that I can have financial freedom. I plan to continue to work, teach, and run this side business because I love all the different aspects that each venture provides me.

falco925··on Compensation in 2019 – new grad tech offers
What is defined as "valuable" to you? People and companies have different definitions, and as your age into the workforce, how you contribute to your work changes.

As a 22 year old dev, "valuable" can be defined as writing code and building products while working 60+ hrs a week, which is what many do in SV. As you age, you write less code and contribute to building products in different ways like architecting the platform and thinking about the business more than the product itself. This is what experience gets you as you age.

I think you're saying that the later deserves more compensation and no 22 year old is worth $200k. I don't think that's true. And most of SV doesn't think that's true. SV likes people that can build and make things, and will pay someone handsomely to build a product and iterate.

falco925··on Show HN: Prepare for technical interviews with real questions from companies
Hi HN,

I've spent my career continuously prepping and practicing for technical interviews, specifically SQL and python, and mainly for marketing analytics and some data science. I also teach SQL and python on the side and need a platform for my students to play around with.

I built Strata Scratch to help people prepare for their technical interviews and brush up on SQL and python. I loaded it with technical interview questions I've sourced from various sites. We created our own underlying datasets and changed the questions a bit keep original and test specific concepts that are often found on interviews.

The platform is MVP-ish, as it's only a side hustle but it's continuously improving. It's free to try out but has a monthly subscription if you want to unlock all the questions. Any feedback would be appreciated.

Here's a link to a Youtube we did also: https://www.youtube.com/watch?v=n6gM265zG68

falco925··on Ask HN: What do productive people do on weekends?
Usually I'm trying to balance out many things, which makes it more difficult than the weekdays:

- getting more sleep - working on my side startup - getting some form of exercise - reading all the things I've queued up during the week - errands around the house - spending time with family

The weekends, I find, are more hectic than the weekdays. There's no set schedule and it changes every weekend.

falco925··on Ask HN: Am I just a wantrepreneur?
I am/was in a similar situation where I really wanted to start something on the side. I spent 6-mo trying out new ideas and experienced all the same problems you did (i.e., tired after work, can't devote enough time to build the product, sucked at marketing, etc).

After 2 years, I finally have a nice SaaS business that's giving me some passive income. What did it for me was that I created a solution that solved MY problem. If you're trying to solve your own problem, turns out you'll spend time on it and most likely many other people have the same problem.

My side project keeps me a bit busy (usually 5-10 hrs a week) but it's really not bad considering that I'm saving time by solving a problem I had.

Just my two cents, as it seems that coming up with the right idea is half the battle.

falco925··on Ask HN: Who here has built a profitable startup while keeping their day job?
I built stratascratch.com working a full-time job and teaching at a university 1-2x a week in the evenings. The idea came from the amount of headaches and inefficiencies I experienced trying to teach non-technical students how to code. I built a platform that made my life easier. It's fairly profitable but not at a scale where I can quit my day job. Since I don't have much free time, I have to hire several freelancers to help with product improvements and sales.

For the record, I don't charge my students to use the platform :P