HNHacker News
TopNewBestAskShowJobs

brayden_wilmoth

22 karma · joined April 21, 2020

submissionscomments
brayden_wilmoth··on Outerbase: 10GB managed SQLite databases in early access
Sorry, try again. There was a rogue feature flag keeping it restricted from some users seeing it as an option.
brayden_wilmoth··on Show HN: Outerbase Studio – Open-Source Database GUI
More of the collaboration features and team features have been or are being built into the Outerbase cloud offering. You can already invite teammates, share resources, see whose looking at what databases, and more there.
brayden_wilmoth··on Show HN: Outerbase Studio – Open-Source Database GUI
Correct. Our goal is to have all of our data sources across all Outerbase products powered by our SDK - https://github.com/outerbase/sdk. Currently the Studio product is not powered by it but our cloud and other offerings are.
brayden_wilmoth··on Show HN: Outerbase Studio – Open-Source Database GUI
You can connect to your SQLite databases from the browser too without the Electron app if you wanted: https://studio.outerbase.com/connect
brayden_wilmoth··on Show HN: Outerbase Studio – Open-Source Database GUI
Tauri when we last tried it was using your default browser to power it, which is great in theory. When we went to use newer API's such as the Popover API then browsers like Safari had a subpar user experience for a number of reasons of its own.

As much as the performance and lightweight aspects of Tauri are great we also have to weight the consistency of user experience which Electron gives having Chromium built into it. All that said... it's worth us taking a second look to see if Tauri will work for us in this use case!

brayden_wilmoth··on Starbase: SQLite on the Edge
He commented here: https://github.com/Brayden/starbasedb/issues/12
brayden_wilmoth··on Starbase: SQLite on the Edge
Yes, of course! Sorry didn't mean to make it seem insignificant – was quite excited to see him show up there from a personal fanboy perspective.
brayden_wilmoth··on Starbase: SQLite on the Edge
Appreciate the candidness to your response here. Honestly we put this brand and website together in two days and we wanted to have some fun with it. That said there is a lot more we can do to make the website more informative, and we'll be sure to improve it as we go. Expect more blog posts, tutorials and implementation guides this week.
brayden_wilmoth··on Starbase: SQLite on the Edge
We don't cache query responses in the Starbase application layer. When we originally set out to build this, we were under the assumption we had to handle the ACID transactional support ourselves. Thankfully someone from Cloudflare shed some light for us as you can see in our Github issues and open PR's :)

Learn more about that here: https://github.com/Brayden/starbasedb/issues/12

brayden_wilmoth··on Starbase: SQLite on the Edge
Still think there is a lot we can add to StarbaseDB to make the developer experience on SQLite databases better, and personally I think it starts with a better external interface. Provide a frictionless way to get started. Then figuring out how to improve developer experiences on how they interface with databases.

Is it auto-accessible REST endpoints? Easy to implement websocket support for the database? Data replication for scaling reads? Offline data syncing? A lot of potential wins for a layer like this to build on.

brayden_wilmoth··on Starbase: SQLite on the Edge
Had no idea this was put on HN today. Author of StarbaseDB here, will get a bug fix for the blog redirection pushed out soon! Thanks for bringing this up.
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Noted, we'll take a look into this. Thanks for bringing to our attention!
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
The Mac app that's referenced is our downloadable Electron application for Mac's. The alternative is to use Outerbase via our website.

In terms of serving Outerbase on-prem, it's an enterprise offering we do support.

brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
We are looking into this. Apologies for the issue. Plain IP addresses should work no problem. If it helps to connect and debug together feel free to send me an email at - brayden [at] outerbase [dot] com.
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Great question. The three you've listed have their own great use cases as a visual spreadsheet layout for databases.

Some of our features that really help us stand out from this particular pack are the fact you can use EZQL in Outerbase to ask natural language questions on your database without knowing how to query (we'll even expose the SQL if you're interested in what was produced, great for learning SQL). Very helpful for larger databases. In addition to that you can take these queries and create data visualization right in our tool.

brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Thanks for the suggestions.

For the SQL stuff being displayed, we like that it gives non-technical users an opportunity to learn SQL along the way. Now providing it as an optional UI is a worthy consideration for us to perhaps make.

We do have a self-hosted version on our enterprise offering currently but I understand it might not be the most desirable for non-enterprise customers.

brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
We are working on providing VPN tunnel connections or VPC-to-VPC connections as well, but it's not quite available today. Thanks for sharing this concern with us!
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Absolutely. Feel free to reach out to us and we would love to connect & compare notes :)
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
At the moment we only support hosted databases and nothing from the local machine but we are working on adding support for this really soon! It's been much requested.
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Good to know! Can take a look at the fact no error messages were surfaced to help identify the problem. If you want to hop on a call together and figure out the issue email me at - brayden [at] outerbase [dot] com - and I'm happy to hop on and get this working for you.
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Maybe the largest core beneficiary from a tool such as Outerbase are in fact product teams. That's where we know at larger companies pain is felt.

We do have a Slack integration that isn't launched YET but is in internal testing to be released soon. Glad to hear this feedback and know we're on the right track with thoughts here!

brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Our thinking behind BI, we believe, is quite different than how we think Power BI, Looker, and Tableau look at the problem.

Today's large tools require in-depth specialized knowledge on the data as well as how to apply it to create dashboards. Our mission is to create data tools that non-developers can understand, use, and create impact with on day 1.

One feature we're really excited about is how to hold a conversation with your database to fine tune the chart you want in natural language, and have "verified" sources come in to double check what has been produced meets the expectations of the business. Certainly a lot more things on the way as well.

brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
We hope that it is the interface that you need!

To be entirely candid and honest, returning a lot of rows presents problems on our end as well at the moment. It's something we are actively working on improving for large data sets to create the best user experience without having to concern yourself about what you're returning.

For our EZQL (natural language to SQL) you don't necessarily need to have foreign keys to infer relationships between tables. We try to infer those relationships for you.

brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Hmm I wonder if this is a caching issue. It seems to be working on our part and no data is ever loaded. If you'd be willing to talk through a bit further I'd love to. brayden [at] outerbase [dot] com.
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Yes, great question! We do have support for connecting to databases over SSH on our very near term release roadmap. Avoiding exposing databases to the internet is a common theme we hear and is important for us to tackle quickly.
brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Currently we allow databases to whitelist our IP address and access from anywhere.

For internal databases we do offer VPN and on-prem (Dockerized) solutions for our enterprise customers.

Private databases that are on localhost we don't _currently_ support on our native Mac app but it's on our roadmap!

brayden_wilmoth··on Launch HN: Outerbase (YC W23) – A new UI and editor for your database
Thanks for the call out here on this bug!

We are working on a resolution to this issue right now. This is an issue with our logout function on the frontend not removing the auth token. There is no risk of scope access outside of your machine.

We will push out a fix shortly.

EDIT: Fix has been deployed. Thanks again!