Show HN: Insomnia-like client for SQLite

#1

Post by vdemedes » Mon, Nov 08, 2021, 5:52 PM UTC

Show HN: Insomnia-like client for SQLite
rosefinchapp.com

Re: Show HN: Insomnia-like client for SQLite

#2

Post by mosselman » Mon, Nov 08, 2021, 9:36 PM UTC

It looks beautiful. How much work would it be to add support for more than just SQLite? Postgres would personally make me happy.

Re: Show HN: Insomnia-like client for SQLite

#3

Post by vdemedes » Mon, Nov 08, 2021, 9:40 PM UTC

mosselman wrote: post #2

It looks beautiful. How much work would it be to add support for more than just SQLite? Postgres would personally make me happy.

Thank you! I started with SQLite, because that's what I use the most, but I'm planning to add support for MySQL and PostgreSQL in the coming weeks.

Re: Show HN: Insomnia-like client for SQLite

#4

Post by colbyhub » Mon, Nov 08, 2021, 9:47 PM UTC

I love this -- I would use this if there was Linux support!

Until then, I'll have to get by with SQLime or DBeaver :(

Re: Show HN: Insomnia-like client for SQLite

#5

Post by westoncb » Mon, Nov 08, 2021, 9:47 PM UTC

Hi vdemedes—nice work! I'm curious whether you've considered putting this in the mac app store or not, or what your reasoning was around that.

Also curious if you did beta testing if you could tell us anything about what that process was like (e.g. finding people, collecting feedback on bugs or usability issues)

(Just curious since I'm working on a desktop app with similar pricing etc., not in the database space though)

Re: Show HN: Insomnia-like client for SQLite

#6

Post by tempodox » Mon, Nov 08, 2021, 9:49 PM UTC

As for SQLite GUIs, there is also the free open-source cross-platform SQLiteStudio.

https://sqlitestudio.pl

Re: Show HN: Insomnia-like client for SQLite

#7

Post by vdemedes » Mon, Nov 08, 2021, 9:56 PM UTC

colbyhub wrote: post #4

I love this -- I would use this if there was Linux support! Until then, I'll have to get by with SQLime or DBeaver :(

Thank you! If it takes off, I'll consider adding Linux support. Until then I want to ship high quality experience for Mac, rather than subpar experience for everyone. ;)

Re: Show HN: Insomnia-like client for SQLite

#8

Post by vdemedes » Mon, Nov 08, 2021, 9:59 PM UTC

tempodox wrote: post #6

As for SQLite GUIs, there is also the free open-source cross-platform SQLiteStudio. https://sqlitestudio.pl

There are great apps out there, but all of them are too complicated and too powerful. What I wanted is to have a nice minimalistic app where I could collect all my queries that I often use for debugging various stuff. That's why I won't add things like data editing or schema changes to Rosefinch. If you need extensive features like that, you'll definitely be better of with SQLiteStudio or alternatives ;)

Re: Show HN: Insomnia-like client for SQLite

#9

Post by vdemedes » Mon, Nov 08, 2021, 10:05 PM UTC

westoncb wrote: post #5

Hi vdemedes—nice work! I'm curious whether you've considered putting this in the mac app store or not, or what your reasoning was around that. Also curious if you did beta testing if you could tell us anything about what that process was like (e.g. finding people, collecting feedback on bugs or usability issues) (Just curious since I'm working on a desktop app with similar pricing etc., not in the database space thou…

Hey, thank you!

> I'm curious whether you've considered putting this in the mac app store or not, or what your reasoning was around that.

I haven't put it on Mac App Store for two reasons primarily:

1. I already figured out licensing, integration with Paddle, building and distribution for my previous app, so I was able to reuse 99% of it 2. I wanted to have full control over rolling out updates quickly in case a critical bug appears

> Also curious if you did beta testing if you could tell us anything about what that process was like

I tested it myself, because I was building this app for my needs, so I kind of knew exactly what I wanted it to do. I also received regular extensive feedback from a friend, who's also helped me shape the app a lot.

Re: Show HN: Insomnia-like client for SQLite

#10

Post by andrewl » Mon, Nov 08, 2021, 10:23 PM UTC

tempodox wrote: post #6

As for SQLite GUIs, there is also the free open-source cross-platform SQLiteStudio. https://sqlitestudio.pl

SQLite is a big part of our tool chain, and has been very good to us. We’ve been using DB Browser for SQLite[1] for several years. It runs on Windows, Mac, and Linux.

Rosefinch looks nice, but I’m not seeing a real use case. If I had a bunch of queries I was always running, I’d probably just make them views, available to me in any client, including the command line. (Sometimes the command line is best.)

If I didn’t want to go that far, DB Browser for SQLite lets you save a work session. Whatever tabs of SQL you have open are preserved, and can be run again at will, the same as Rosefinch. You can also rename them from their default names, which are just SQL 1, SQL2, etc.

It does a lot, but stays out of your way.

[1] https://sqlitebrowser.org