HNHacker News
TopNewBestAskShowJobs

adam_gyroscope

893 karma · joined February 16, 2017

submissionscomments
adam_gyroscope··on Fly Postgres, Managed by Supabase
Nice job & congrats!
adam_gyroscope··on Who will lead the charge to a four-day work week?
(bit.io CEO here) - databricks has a 5 day work week.
adam_gyroscope··on The challenges of supporting foreign key constraints
(And you work for neon)
adam_gyroscope··on How to register a Kei truck in Pennsylvania
This reminds me of the saga Donut went thru to get a similar-sized truck from china: https://youtu.be/yRG0Wai4sR0
adam_gyroscope··on Pushing the limits of NSStatusItem beyond what Apple wants you to do
Nice! It's very apple that the default recommend way is very restricted but there are clever ways to get around that restriction if you dive deep enough.

Also, Swift is so much easier to read then ObjC.

adam_gyroscope··on Building a Database in the 2020s (2022)
bit.io
adam_gyroscope··on The early 90s tech scene that created L0pht, the legendary hackerspace
I had accounts on ATDT East & The Works, and ran a Wafflenet BBS on the south shore of Massachusetts. I was .. 14? 15? And would travel up to the 2600 meetings as often as I could convince my parents to drive me to the T stop. One memorable night I was invited to go to the l0pht and go trashing afterwards. It was awesome, I got a copy of the Nynex dental plan which I gave to someone on The Works who asked for it. No idea why they wanted it. I also met Lemon (later Lady Ada) at the 2600 meetings. I had no idea at the time how big a deal l0pht was, I was just happy older kids tolerated me.
adam_gyroscope··on Ask HN: What would be your stack if you are building an MVP today?
I'd do python + django + bit.io (serverless postgres; I'm the CEO but I built it because I wanted to use it), deployed in a container to k8s somewhere. These are all personal biases to what I've used and know well; for someone new to backend I'd probably recommend next.js + nodepg + bit.io on vercel or similar.
adam_gyroscope··on Serverless PostgreSQL on Replit
Give us a try (i'm the CEO) - bit.io - we're fully serverless Postgres, and most small workloads will fall within our free tier. Happy to answer any questions.
adam_gyroscope··on Writing a Python SQL engine from scratch
We (bit.io) use SQLGlot and love it! We use it in our open-source sqlite->postgres tool, pgsqlite:https://github.com/bitdotioinc/pgsqlite, and in our general SQL parser where we can translate between dialects (https://docs.bit.io/docs/query-translation):

  #!translate:sqlite
  select \* from [foo]

That will translate the given sql (which is in SQLite syntax) into PostgreSQL SQL and then run that query.

Also, Toby & team may be the most responsive open-source maintainers I've ever seen. Open issues are often closed within a day. It's awesome.

adam_gyroscope··on The Majority of PostgreSQL Servers on the Internet Are Insecure
(co-author) - `prefer` is... not great. That'll silently fall back to an unencrypted connection without warning the user.

If you are the one using a programming library directly, you may know that `prefer` does this. If you are using a client that doesn't expose this to you, you may not know that you are using an unencrypted connection after you had set ssl on.

adam_gyroscope··on Pgsqlite: a Python module to import SQLite databases into Postgres
Author here! Happy to answer any questions.
adam_gyroscope··on From Prison to Programming
I’m a mentor for Underdog Devs and love it! Happy to answer any questions.
adam_gyroscope··on Removal of Heroku free product plans
For folks looking for a free Postgres offering, check out bit.io (I'm the founder/CEO) - we're super easy to use. And if you migrate from heroku and mention HN we'll get you a $5 credit if you go pro.
adam_gyroscope··on Learn Postgres at the Playground – Postgres compiled to WASM running in browser
Love this! I think it's time for the database to move closer to the browser.

We spend some time getting the node-postgres library working with websockets so we could go browser->websockify->postgres: https://github.com/bitdotioinc/node-postgres - this lets us use a full-featured postgres client (with, eg, cursor support) in the browser.

adam_gyroscope··on Switching to a four-day workweek (2021)
It's oncall, like any engineering on-call rotation, so there's an SLA for responding to support requests; currently our oncall is 6am-6pm Pacific time (weekdays). So, it's as much as work day as any on-call rotation is.
adam_gyroscope··on Switching to a four-day workweek (2021)
Check out the links in our post on this: https://blog.bit.io/we-have-a-four-day-work-week-and-you-sho...
adam_gyroscope··on Switching to a four-day workweek (2021)
As a founder, the temptation is real, but anecdotally (anecdataly?) I'm so much more motivated on the work days I don't think the extra day matters. But, my company is not big enough to have enough sample data to prove it one way or the other.

Employees do take the extra free time into consideration when comparing offers, since we make offers that are competitive to a 40-hour offer.

Re: sneaky bit of work on the off day. We don't rely on it, or ask for it. We do have an on-call rotation that covers support and site issues on Fridays, but you're in that rotation once every 5 weeks or so.

adam_gyroscope··on Switching to a four-day workweek (2021)
We have a chat box that pops up for all support, and offer support@bit.io. Both get routed to our Intercom instance, and both generate opsgenie alerts for some cases. We do an on-call rotation for answering the support requests.

We don't _yet_ do support on-call on the weekends.

adam_gyroscope··on Switching to a four-day workweek (2021)
Great question. The sad fact of the 4 day work week is that the rest of the world doesn't do it, so external support is a challenge. Right now, my co-founder and I try to do any external customer _meetings_ that have to take place on a friday. But for support we have an on-call rotation (like we do for engineering), and that does cover fridays. So, the support on-call person handles friday support requests.
adam_gyroscope··on Switching to a four-day workweek (2021)
We (bit.io) do a 4 day work week, and have since our founding. It's the 32-hours get paid for 40-hours kinda; our salaries are competitive with companies of the same stage & size who do a 40-hour work week.

I was skeptical at first (I'm the CEO), but my co-founder showed me the data and we've been doing it since the start with no regrets. Happy to answer any practical questions; we're about 10 full time folks right now, work monday-thursday, all remote.

adam_gyroscope··on Ask HN: Who is hiring? (December 2021)
bit.io, inc | Multiple Positions | Remote | https://bit.io

bit.io’s mission is to make data scientists and software engineers immediately productive with data, to remove obstacles to using data, and to make data more accessible. Join us in building a shareable cloud database where users can share their data with anyone in seconds just like a Google doc, query their data without worrying about compute or memory, and combine their data with a growing collection of immediately use-able open data. bit.io is transforming data in the same way GitHub transformed software and open source.

We're a seed-stage, well funded startup, 8 people right now and have just entered beta. We've solving hard problems in the database space and in the UX space, and we've got some really interesting engineering, data science, and special projects positions open.

Find out more about our open positions https://bit.io/jobs?hn

Feel free to reach me on here or adam at bit.io - I'm the CEO & Co-Founder.

adam_gyroscope··on Show HN: Work with CSV files using SQL. For data scientists and engineers
You can do this with bit.io, although it’s not local; import your csv (drag and drop or browse to upload) and get a Postgres database in the cloud. Full disclosure I’m a founder at bit.io.

I love to see anything that makes it easier to use data!

adam_gyroscope··on Ask HN: Who is hiring? (July 2021)
bit.io, inc | SWE & SRE | Remote | https://bit.io

bit.io is building a home for all the worlds data. A single, giant, postgres database where users can share their data with anyone in seconds just like a Google doc, query their data without worrying about compute or memory, and combine their data with a growing collection open data.

We're a seed-stage, well funded startup, 8 people right now and have just entered beta. We've solving hard problems in the database space and in the UX space. Find out more about our open positions https://bit.io/jobs?hn

Feel free to reach me on here or adam at bit.io - I'm the CEO & Co-Founder.

adam_gyroscope··on Ask HN: Who is hiring? (May 2021)
bit.io, inc | Multiple Positions | Remote | https://bit.io

bit.io’s mission is to make data scientists and software engineers immediately productive, to remove obstacles to using data, and to make data more accessible. Join us in building a shareable cloud database where users can share their data with anyone in seconds just like a Google doc, query their data without worrying about compute or memory, and combine their data with a growing collection of immediately use-able open data. bit.io is transforming data in the same way GitHub transformed software and open source.

We're a seed-stage, well funded startup, 8 people right now and have just entered beta. We've solving hard problems in the database space and in the UX space, and we've got some really interesting engineering, data science, and special projects positions open.

Find out more about our open positions https://bit.io/jobs?hn

Feel free to reach me on here or adam at bit.io - I'm the CEO & Co-Founder.

adam_gyroscope··on Ask HN: Who is hiring? (April 2021)
bit.io, inc | Multiple Positions | Remote | https://bit.io

bit.io’s mission is to make data scientists and software engineers immediately productive, to remove obstacles to using data, and to make data more accessible. Join us in building a shareable cloud database where users can share their data with anyone in seconds just like a Google doc, query their data without worrying about compute or memory, and combine their data with a growing collection of immediately use-able open data. bit.io is transforming data in the same way GitHub transformed software and open source.

We're a seed-stage, well funded startup, 8 people right now and have just entered beta. We've solving hard problems in the database space and in the UX space, and we've got some really interesting engineering, data science, and special projects positions open.

Find out more about our open positions https://bit.io/jobs?hn

Feel free to reach me on here or adam at bit.io - I'm the CEO & Co-Founder.

adam_gyroscope··on Ask HN: Who is hiring? (August 2020)
bit.io | bit.io | FE & BE Engineers | San Francisco (REMOTE) | Fulltime

bit.io is looking for a Front-End Engineer and Back-end Engineer working within three hours, +/-, of Pacific Time.

bit.io’s mission is to make data scientists and software engineers immediately productive, to remove obstacles to using data, and to make data more accessible. bit.io is a remote-first, early-stage, well-funded startup.

YOUR JOB: * Work across the stack on all aspects of software engineering for the core product * Collaborate directly with all teammates on a small, productive technology team * Solve petabyte-scale problems in the data space * Design, build, test and deploy a complex data management system * Make broad, impactful technology decisions with responsibility for their outcomes

OUR STACK: Python, Django, Postgres, Go, Java, SQL, GCP, Docker, Kubernetes,

MORE DETAILS: Front-end Engineers: https://jobs.lever.co/bit.io/e80f6558-a048-4abf-80f6-177aa44...

Back-end Engineers: https://jobs.lever.co/bit.io/43e937c7-9654-46d2-bb3c-2b4a163...

adam_gyroscope··on Google and SABRE partner to build travel tech
Former ITA'er here who went through the Google acquisition. This news is interesting because Google's flight search, which used to be ITA Software, is/was very competitive with SABRE - it would have been impossible to imagine them working together like this in the ITA days. Additionally, many of the former ITA folks are at SABRE now.

I always hoped that Google would build a free GDS (global distribution system; basically a broker/layer of indirection and source of truth for travel that requires multiple unrelated carriers). SABRE makes a lot of money on their GDS; a GDS charges something like $5 US a booking, and Google was uniquely positioned to make this free (of course, free to you in exchange for knowing your travel data). It'd have been a nice thing for price-sensitive consumers... maybe it could still happen.

adam_gyroscope··on Inferno Operating System
So, I think so but can’t prove it. In 1998 I didn’t really understand open source licensing so who knows where that code went.
adam_gyroscope··on Inferno Operating System
Back when I was in university we had a small course on Limbo/Inferno because of a connection my university (RIT) had to bell labs. I took the course in... 1998? and wrote a version of Tetris for limbo. The code was awful, but did find a bug in the Tk implementation. This lead me to my proudest/most embarrassing programming moment - apparently, my code ended up in front of Dennis Ritchie, who thought the code was terrible. Whatever, Dennis Ritchie looked at my code!

Anyways, here's the awful code: https://github.com/adamf/limbotris

← PreviousPage 2 of 3Next →