The conversation

Lessons learnedExperience excerpt · English

Not true in my experience

… Not true in my experience. True at very large / very mature companies, but at any <5-year-old company the DB will be widely accessible, perhaps universally so. Certainly every engineer, every analyst, and every manager will have full access. (I'm sure someone will pipe in to disagree but this has been true for 10 out of the last 10 companies I've worked with). Coming from DigitalOcean and Walmart it's not surprising you would make this mistake, not trying to dunk just want to suggest this might not be as big of a problem as you think. 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 Looker, on top of carefully-crafted data warehouses (which most won't have) are still vastly inferior to SQL and so analysts don't use them. Again, just trying to suggest the problem may not be what you think. Generating queries with a language model won't work. …

Original discussionLaunch HN: Outerbase (YC W23) – A new UI and editor for your database112 source comments · at import
3

What was this responding to?

Parent context · original excerpt

BU

Hi HN – we are Brandon and Brayden (confusing we know), and we are building Outerbase ( https://www.outerbase.com ) a better interface for your databases. Think Google Sheets or Airtable, but on your relational database. We provide a collaborative UI on top of Postgres, MySQL and other databases, enabling teams to view, edit and visualize their data. Here’s our short demo video: https://www.youtube.com/watch?v=38RslBYdZnk Accessing data is a challenge to team members who aren’t data analysts or engineers. Databases are usually locked down to a few team members, and everybody else has to rely on them to get access. Most non-engineers can’t (and don't want to) use developer tools, and developers don't want to write SQL for teammates all day. Technical employees end up being bottlenecks for access to data. In some cases this can be extreme—we’ve seen publicly traded companies with only 2 d…

Full original

Community replies 0

No community replies yet. Add your perspective.

Replies from the source 3

Direct replies available in this import. Original-language excerpts.

IT

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.

Full original
BU

That's a fair comment, If anything them not being locked down makes access to databases easier to connect to Outerbase. I agree that users should learn SQL, even when you use EZQL it returns the actual SQL in a fully-editable IDE that can be modified in whatever way you would want. Do you think that the existing tools out there provide a good environment for those non-technical teams to learn SQL? Maybe I'm biased but I have never been a huge fan of accessing data from the majority of the existing tools as they feel outdated and like tools built mostly for engineers.

Full original
ZI

I agree with everything, but will push back about everyone having access to everything.. I hope that's mostly read-only or at least a very robust auditing/logging strategy employed. At $WORK, we give basically every employee a DB role in Postgres, but we use table/row level access control(s) and most can only see their own records, or the records of their employees(if they are a manager). We encourage them to learn SQL(most don't). We also do strong audit/logging controls(essentially pg_audit) so we track every DB change, forever. Otherwise I completely agree with you that data is almost always quite messy. I can't imagine their EZSQL stuff would work on our data at all. We have tried various other data finding magic stuff, and all of it without fail is basically useless once attached to real data that has lived in the wild for a while(we have data back to the 1990's in our database).

Full original
Continue on Hacker News

Respect different perspectives. Share concrete experiences.

Sign in to post, reply, repost, and quote.