HN user

dkroy

668 karma

Personal Portfolio:

www.dylanroy.com

---

Email:

dylan dot k dot roy at gmail

Posts37
Comments177
View on HN
techcrunch.com 11mo ago

Three weeks after acquiring Windsurf, Cognition offers staff the exit door

dkroy
30pts8
apigum.com 3y ago

Show HN: I created a product to connect any API to Google Sheet

dkroy
2pts1
www.usesql.com 3y ago

Show HN: Extract information from websites using SQL

dkroy
1pts1
www.usesql.com 5y ago

Show HN: Use SQL Across Your Google Sheets, APIs, Airtables, and More

dkroy
1pts2
medium.com 5y ago

A New Dimension to Your Photos Using Python

dkroy
2pts0
www.businessinsider.com 5y ago

Eviction startup gets gig workers to help landlords kick people out

dkroy
67pts107
news.ycombinator.com 6y ago

Ask HN: My GCP Account Has been Hacked What do I do?

dkroy
27pts5
news.ycombinator.com 8y ago

Ask HN: IO Domain Issues?

dkroy
2pts1
github.com 8y ago

Ephemeral Hadoop Clusters Using GCP by Spotify

dkroy
3pts0
github.com 10y ago

Python implementation of Spark's RDD

dkroy
2pts0
blogs.wsj.com 11y ago

Amazon to Remove Confederate Flag Items

dkroy
2pts2
www.youtube.com 11y ago

Machine Learning for Video Games

dkroy
1pts0
tidal.com 11y ago

High Fidelity Music Streaming by Jay Z

dkroy
14pts4
whitehouse.gov 11y ago

Whitehouse Website Let Their SSL Certificate Expire

dkroy
10pts8
techcrunch.com 11y ago

This Device Could Make It Easier to Find Your Veins

dkroy
1pts0
github.com 12y ago

Plugin System for Python

dkroy
6pts0
mbasic.facebook.com 12y ago

Basic Mobile Site for Facebook?

dkroy
1pts0
github.com 12y ago

Multi-Git

dkroy
2pts0
www.humblebundle.com 12y ago

Humble Sid Meier Bundle

dkroy
1pts0
here.com 12y ago

Here.com is Nokia Maps

dkroy
1pts0
github.com 12y ago

Easy to Use HTTP Client for C#

dkroy
3pts0
bin.mediatemple.net 12y ago

A Letter From Media Temple Founder

dkroy
50pts47
tickerpal.com 12y ago

Show HN: Watch your stocks with TickerPal

dkroy
2pts1
www.cnn.com 13y ago

IT director who raised questions about Zimmerman case is fired

dkroy
1pts0
www.npr.org 13y ago

Netflix Is Bringing Back Arrested Development

dkroy
1pts0
mashable.com 13y ago

Interactive Google Doodle Zamboni Game

dkroy
1pts0
thenextweb.com 13y ago

Valve plans to sell apps via Steam ranging from “creativity to productivity”

dkroy
6pts5
github.com 13y ago

A Better Twitter Bootstrap Modal

dkroy
358pts71
news.ycombinator.com 13y ago

Heroku Privacy Policy Has an Application Error

dkroy
1pts2
wiki.mozilla.org 13y ago

Mozilla Open Badges Project

dkroy
2pts1

Cool idea, though hats off to anyone who got cohere-transcribe to show up as serving the model. I could get device to show up, but kept having issues getting their server to properly serve the model though it could just be the device I tested.

As I had been building out my other product UseSQL I noticed another adjacent product that had a lot of potential run by another IndieHacker. I have since taken the product over. Added a number of features, fixed a few bugs, and pulled together a couple of demos. I have since started dogfooding this product, and figured I would share it with the world.

I am very excited to share this product as I don't think I have built a product that has leaked into my daily left as much as this one.

Feel free to give this product a try as there is a free plan if you want to take it for a spin. Thanks again! If you like it enough to start paying don't forget to snag that discount on my Product Hunt post https://www.producthunt.com/posts/apigum-2 otherwise I wouldn't be against any upvote love on the post. Happy holidays!

After initially launching UseSQL, and using it on a large number of my other projects I discovered another area where this product could be applied to another use case. Data extraction and scraping from websites.

Prior to this new addition, I would either learn another scraping API or since I know Python build out a new scraper each time. At this point that's a thing of the past since now all I need to know is SQL.

I've already started using this to send myself email digests of a number of sites, such as HN, that I actively read so in other words, haven't really scratched the surface of how a person could be using this feature.

Please be kind, but me know what you think. I added a demo so you could try it yourself if you click through to the link.

If you liked it feel free to drop by product hunt and send some love with an upvote here https://www.producthunt.com/posts/usesql-for-web-scraping.

When trying Sample Code 3 converting the TypeScript to Python the conversion was incorrect. Probably worth swapping that out for another sample if the owner is in this thread. As I was writing this I noticed that this wasn't a Show HN post.

Hello my fellow HNers, this is the creator here. After continuing to write boilerplate code to connect multiple data sources together I finally decided to take a more platform-driven approach and came up with a way that I could continue to add more integrations in a scalable way. This API is the result of that effort.

Let me know what you think. I am by no means a copywriting expert so can add videos, and better explanations, but added a demo section here if you want to play around with it: https://www.usesql.com/demo

I really would welcome this on my current stack as someone who now primarily works in GCP and is constantly updating architecture diagrams. I love any tool that will help create automated assets to assist with documentation as they really help prevent tribal knowledge and reduce that constant overhead of keeping everything up to date.

Wow, I did not expect clickbait to make its way to the number 1 spot on HN. I would be curious to see if this was due to some someone gaming the algorithm or people carelessly upvoting the headline. Though it is a bit funny that the platform that clickbait is most prevalent on is part of the topic of discussion. Youtube subscribers in this case = Grandkids in the title.

This question may be an odd one, but how did you create the little cartoons in your blog post? I feel like they really improved my experience as a reader, and if I were to create content in the future I wouldn't mind knowing if there was an easy way to include something similar for someone with little to no artistic skill.

Edit: Found my answer in this blog post of yours https://mtlynch.io/how-to-hire-a-cartoonist/

How has this affected tax revenue on these legalization experiments? How has this affected drug related crime as well? Is this increase bad? I would love for someone to dig up these answers as I have referenced Portugal's policy in many arguments, but never the ones we have been trying out here at home as they are newer and often more restrictive in comparison.

You got my attention with the open-sourced not taking app for programmers. I downloaded it because it was free and had markdown support. This project could even better if it tried to up-sell people with a SaaS offering that would sync all of the desktop apps under a a certain account, but also offer an open source version of that.