Live data from Hacker News

Launch HN: Outerbase (YC W23) – A new UI and editor for your database

news.ycombinator.com

91–100 of 116 posts

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#91

From a quick glance this could be the missing piece for going all in on SQLite for small apps. Most plug-in admins only work with remotely accesible databases like Postgres. How would that work, does Outerbase run locally on my server instance? If it had some functionality for backups and a nice Auth story it could really be a good side project secret weapon.

Hey sorry I missed this one earlier, so right now it doesn't work locally, but definitely something we're exploring.

Also how would you want backups to work? Would you want us to store those for you? Or I guess if it was local would you want them to be stored on your machine at X interval?

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#93

I've been working for 3 years now in a deep tech startup in the agriculture space: we have developed a model, and are running tests with big companies. We rely on a MySQL db for parameters. The core team is me, and 2 of my partners. They are both experts in the field, and don't have much experience with computers, let alone MySQL. Throughout the development of the project, they need to dig into the database to genera…

Why not start with charging your customers? Just because you don’t doesn’t mean your vendors shouldn’t.

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#94

ChatGPT4 can generate the sql for whatever query, and it can create the schema and modify it. How do you position agains near-future ChatGPT based tools for working with data/databases?

as far as i understood they already use gpt3

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#95

I've been working for 3 years now in a deep tech startup in the agriculture space: we have developed a model, and are running tests with big companies. We rely on a MySQL db for parameters. The core team is me, and 2 of my partners. They are both experts in the field, and don't have much experience with computers, let alone MySQL. Throughout the development of the project, they need to dig into the database to genera…

You should try NocoDB!

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#96
> Accessing data is a challenge to team members who aren’t data analysts or engineers

To me it seems that the product is more or less built around this notion. Which is weird. In my experience, unless there are strict reasons why one cannot have access to raw data, access is usually one approval away.

> we pass the relational schema on top so we can easily know the relationships between your tables.

Take a look at any production database that has survived a decade of continuous development. It's batshit crazy. There will be 3 different tokens in field names denoting the very same thing. Some relationships will be defined in the schema, some in procedures, some in application code. Values will be scaled/encoded differently in tables from different generations. Quite possibly there will be "read only" tables of historical data following entirely different schema. What does null value field mean in EAV table? It may mean absence of value (how is it different from absence of the attribute?), explicit inapplicability of the attribute or `any` value.

Not including any of these quirks returns wrong data, but it does not tell you and it is not always obvious that the data is incorrect. Validating complex queries is not that easy. For most business questions wrong data is strictly worse than no data.

IIUC, Outerbase connects directly to the database, takes a dataset that does not easily yield to simple join-and-filter composition, writes a query without incorporating all the data quirks and spits it out to a rather rudimentary sql explorer. That is one of the major reasons why read only access to raw data is restricted in the first place. The value proposition here is murky to say the least - it does not take much training to teach someone to write rudimentary selects.

But if companies take the resources to make data easily analyzable and build a data warehouse, they want to use powerful reporting tool like PowerBI or Tableau. Outerbase seems to fall very short here.

So, where in the team does Outerbase fit? Support and business people need data pre-validated to be correct, DBAs hand-optimize queries. Devs either work with some form of ORM/DAO or write composable queries that need a very specific structure anyway.

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#97
Just some thoughts on it. The op initally talks about data warehouses, but then in the comments they talk about production db. So, I am not sure if I completely understand the problem statement:

1. Why would you want to do data analytics on a production database? There is a reason why data warehouses exists. And you don't want to block your production databases for someone from the business team to run a query. 2. If you'd want to change something in your prod-db, I wouldn't give that permission to a non-technical person. Do they know about the schema thats implemented? data types? 3. If it's just analytics on data warehouses, there are plenty of db visualization tools out there, the so called BI tools. There are plenty, I mean too many out there. In different flavours. What makes this different?

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#98
post #48

"Databases are usually locked down to a few team members..." Not true in my experience. True at very large / very mature companies, but at any In that same vein, in a small company environment you don't harass engineers with query requests, you learn SQL . I've seen hundreds of non-technical users do this (and helped many of them), it's not unusual. Visual query-building tools never help. Even good interfaces like Lo…

All of my jobs big (1k+ engineers) and small (me), the BE engineers had read access to most databases. The larger companies have some access controls, but if you needed access, it was almost always given.

Would you mind chat about how you guys manage access? We are building something in the access management space. Would love to get some feedback!

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#99
I'm sorry but the pricing here is off by like an order of magnitude. This is in the $5/mo category not the $50/user/mo category.

Maybe I'm not the target user.

Please take this as me trying to help. I think many many other users are thinking this but not saying because they know they will get 500 downvotes.

You're saying the value provided is 4x the entire Microsoft Suite + OneDrive + Exchange (for example).

Seems really, really expensive to me

Re: Launch HN: Outerbase (YC W23) – A new UI and editor for your database

#100

Regarding pricing: do you offer monthly subscriptions for "view-only" users? Here's my use-case. I am fine paying $50 a month for someone to make dashboards, create queries, etc. However, that's too much (and significantly above other tools) for the "users" of the product: for example, salespeople who I would like to enable to see what products their customers have used. I'd expect something in the 10-20 range per he…

We hit this pricing issue with almost every tool we used at one point or another. Tools that are priced for someone who uses it every day, but where the value comes from having open access for many people who might use it once a month.
Post reply on HN