Show HN: Arctype, a cross-platform database GUI for developers and teams (arctype.com)
Think of Arctype as “phpMyAdmin meets Postman”. Most of our team grew up learning how to program using the LAMP stack and we missed the experience of interacting with our databases using phpMyAdmin. We wanted to bring back the experience of a simple app that lets you explore and query your databases, but with an updated and modernized interface.
At the same time, we were heavily inspired by the ease-of-use and collaboration features of Postman. We wanted to create a super useful, collaborative app like Postman that your whole team uses for development—but for databases instead of APIs.
We have a few thousand developers using Arctype today but we haven’t shared it with the HN community yet–we’re excited to hear your feedback! We also have a very active Discord community at arctype.com/discord where developers can ask questions and talk about databases/SQL.
I’m sure the community has a lot of questions, so we’ve compiled a list of the most common ones we get:
“Why isn’t Arctype open source yet?”
It will be soon! We’ve been focusing mostly on features that users have been asking for, as well as performance, stability, and security. We’re not completely happy yet with the documentation and development experience of contributing to Arctype, but this will be a core focus for us in the coming weeks. We just want to make sure it will be very easy for the community to contribute once we publish on GitHub.
“How does Arctype make money?”
Arctype is free (and will be free forever) for most developers. We have a typical SaaS model for large teams based on a per-seat license as well as an enterprise version that companies can run on their own infrastructure.
“Why is Arctype built using Electron?”
We wanted to make it easy for anyone to use Arctype–Electron is currently the most practical solution to make it cross-platform and also accessible via a web app. Apps like VSCode and Discord have shown that it’s possible to achieve decent performance so we’re confident that over time the advantages of developing on Electron will outweigh the slight performance hit compared to native apps.
“Does Arctype need an account?”
You can use Arctype without an account or you can login via email or Google. Certain features such as sharing queries and dashboards with your team require an account.
“Is Arctype secure / does it store credentials?”
All of your credentials are stored locally, and queries are also executed locally on your machine. We do have a feature that lets you automatically share your credentials to your team, but that is strictly opt-in, and all credentials are encrypted on our backend. Additionally, we have an enterprise version that companies can run on their own infrastructure for organizations that have stringent security requirements. If you’d like to learn more, we have more info at arctype.com/security.
“Does Arctype use any analytics software?”
Arctype has usage-based analytics and error reporting (we use Sentry) that we use to improve the app and to help us fix bugs/crashes. However, this can be turned off. Additionally, Arctype can be used fully offline.
“Why doesn’t Arctype support X database?”
Email me at justin at arctype.com :) We’ll make it happen.
67 comments
[ 0.28 ms ] story [ 171 ms ] threadSweet! Excited to have you join the community of open-source data tools. :)
Disclaimer: Worked with them in the past
Unfortunately, as I used it week after week I kept running into cases where it was really slow or completely unresponsive (with no error message or loading indicator), or where it simply was consuming a lot of resources on my Mac. I got in the habit of waiting a few seconds, giving up, killing the app and restarting it.
To be fair, part of the issue may have been me tunneling to a free Fly.io postgres database, which wasn't particularly fast. I eventually got so frustrated I paid for Postico (a barebones native MacOS app), and couldn't be happier.
I realize it takes a lot of time and expertise to build a complex cross-platform web app that doesn't have memory leaks and performance problems, and I hope Arctype will get better over time (like the VSCode or Slack apps). Looking forward to trying it again at some point.
Have you considered transitioning to something that uses the system WebView like Tauri or NeutralinoJS? If you did, what were the blockers?
I will, once again, link to the comment on this very site from a Slack engineer who explained why they moved from system provided Webviews to Electron: https://news.ycombinator.com/item?id=18763449
FWIW: I would pay 100$ yearly for a JetBrains like license to a solution like this written in something like Qt or Gtk that could successfully replace DBeaver for me.
https://slint-ui.com
it's actually written by Qt folks
What are you smoking? :-)
"Lack of x-platform native GUI frameworks" is not the reason for non-native GUI applications.
You're already spoiled for choice if you want to write a reasonably cross-platform native-code application. Personally I use Lazarus (calling into .so/.dll libraries for anything non-GUI).
The difficulty with using the existing frameworks is why developers are choosing Electron.
I don't think throwing another even more difficult and even more time-consuming tech stack into the mix is going to cause GUI application developers to decide "Finally we can do x-platform GUI apps".
If the creators of whatever application decided that it would take too long to design and implement in QtCreator, Flutter, Lazarus or any of the existing rapid tools, I doubt they are going to want to spend even more time doing it in Rust which doesn't even have the rapid-prototyping tooling!
Their software probably is the best example of Swing, but it is still Swing, so performance makes a lot of operations feel slow and it doesn't prioritize data-first so the most intuitive way to do some things is in a blocking manner, with no smooth transitions from/to loader indicators.
In my admittedly limited experience using it, I found that some MySql datatypes seemed to be missing from the table editor (e.g., `TEXT`). Not sure why this is and I haven't had time to dig further.
It's promising, and way better than even some of the other paid options. (Like, what is DBeaver even doing??)
Why? Because I need to be able to do more than just run queries. I need to be able to manage users & permissions, see the current server configuration, kill connections from other clients if necessary, etc.
The collaboration features are a nice touch, that certainly makes this stand out compared to others, but if I still need to use another client as well then it's just not going to work...
https://www.navicat.com/en
arctype.com, intercom.io, sentry.io and s3.amazonaws.com.
These all happen while the window isn't even loaded on first start.
I get that I'm not entitled to anything, but jesus, I dislike the electron age. Well, not that other apps are much better, I'm just sad.
I get it though… I don’t really want my database access tracked either. Maybe it would be better to include this as part of the account creation process. At least then you can tell the user what you're collecting and why.
they should store crash reports locally and next time i open the app ask me whether i want to send them or not
what they decided to do instead is spying
[0]: homepage: https://www.ultorg.com/
[1]: 10m video: https://www.hytradboi.com/2022/ultorg-a-user-interface-for-r...
How focused are you on providing top notch visualizations such as maps with pins using OSM or custom GeoJSON maps, and other more dynamic type of data vis?
Metabase is a great tool but occupies a different space. It’s more about rich visual affordances.
https://www.tableplus.com
how does your product compare to TablePlus?
Just put a demo on the site.
the difference is that they have the resources and employ people who work full-time to not make Electron suck
Hope they can improve, might give it another go once I have time.
> Please move Arctype into your Applications folder
What's the difference?