Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: ESQLate – Build minimum viable admin panels with just SQL

github.com

Post reply on HN
Print view View original

61–70 of 83 posts

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#61

Post by Twisell »

0xff00ffee wrote: post #59

Does anyone else find it humorous that the majority of top-level comments in this thread start with, "Cool! I built something just like this because sucks!" This tells me that (a) it is a common problem, and (b) it is not solved well. I'm guilty too: I manage a large MySQL DB and the admin panels are essentially CRUD UI rendered from the schema. The alt solutions I've clicked on here try to add more functionality, bu…

Feel free to laugh at me but I often miss MS Access layout tools.

MS Access is totally unscalable and due to it's proprietary licence I can't recommend it to anyone... but it was super freaking easy to stich together a graphical UI usable by non expert users.

I'm a SQL/GIS/Dev based on PostgreSQL/PostGis and I would totally harass my boss to buy such a solution if it were to exist. I have no time to learn latest front-end flavor so being able to quickly deploy any customizable AND simple GUI between my SQL illiterate colleagues an our database would by priceless!

If such solution does exist please have a laugh at me for being ignorant and I would really appreciate if you could send some links to that product!

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#62

Post by gavinray »

Super neat idea and tool!

I tried to clone it and run it locally, but it doesn't run. Tried with both yarn and npm.

    > node-sass src/index.scss > public/index.css

    sh: 1: node-sass: not found
    npm ERR! file sh
    npm ERR! code ELIFECYCLE
    npm ERR! errno ENOENT

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#63

Post by marviel »

hadem wrote: post #58
marviel wrote: post #49

Earlier quoted context omitted.

You might find Postgraphile interesting, if you like graphql: https://github.com/graphile/postgraphile

You might also find Hasura interesting for instant GraphQL with Postgres: https://hasura.io/

Thanks! Have you tried both systems? I've never heard of hasura, so don't know the extent to which they compare. At a glance it looks like they serve largely the same problem.

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#64

Post by mstade »

cube2222 wrote: post #38
mstade wrote: post #32

Earlier quoted context omitted.

This is really cool stuff, thanks for sharing! I'm working on a desktop application which has feature to let users query data across a bunch of different data sources, like csv, excel, and some others. The way I've implemented this is by first scanning all applicable files and populating a SQLite database with all the data from these files, a table per file essentially, and then allowing users to execute queries agai…

Glad you like it! I think I've seen an open source project with the approach described by you too. However, I think philosophically we differ in that one of our goals is to push down as much work as possible to the underlying databases and our next big upcoming milestone is streaming (Kafka, possibly database change streams). But yes, it's great that a kind of ecosystem is forming around those ideas!

Absolutely agree regarding difference in approach – and I'm by no means suggesting that yours is in any way worse! In fact, I believe yours is much, much better given the more general use cases it supports. Ours is inherently stateful and requires careful coordination, which works for us because the system is pretty much self contained and it makes things easier, but I don't think it's a good generic solution to be honest.

My point was really that it's nice and validating to see the the whole idea of a unified way to "query all the things!" as it were isn't all that novel. :o)

By the way, if you can think of the name (or a URL even!) of that project you mention I'd be very interesting to take a look at that too. Much obliged!

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#65

Post by cube2222 »

mstade wrote: post #64
cube2222 wrote: post #38

Earlier quoted context omitted.

Glad you like it! I think I've seen an open source project with the approach described by you too. However, I think philosophically we differ in that one of our goals is to push down as much work as possible to the underlying databases and our next big upcoming milestone is streaming (Kafka, possibly database change streams). But yes, it's great that a kind of ecosystem is forming around those ideas!

Absolutely agree regarding difference in approach – and I'm by no means suggesting that yours is in any way worse! In fact, I believe yours is much, much better given the more general use cases it supports. Ours is inherently stateful and requires careful coordination, which works for us because the system is pretty much self contained and it makes things easier, but I don't think it's a good generic solution to be h…

I didn't want to come of as suggesting you meant any of that, not at all! Just comparing approaches.

I think it was this: https://github.com/simonw/datasette though supports only CSV files.

There's also Apache Drill which works with a lot of data sources, which is philosophically closer to OctoSQL.

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#66

Post by mstade »

cube2222 wrote: post #65
mstade wrote: post #64

Earlier quoted context omitted.

Absolutely agree regarding difference in approach – and I'm by no means suggesting that yours is in any way worse! In fact, I believe yours is much, much better given the more general use cases it supports. Ours is inherently stateful and requires careful coordination, which works for us because the system is pretty much self contained and it makes things easier, but I don't think it's a good generic solution to be h…

I didn't want to come of as suggesting you meant any of that, not at all! Just comparing approaches. I think it was this: https://github.com/simonw/datasette though supports only CSV files. There's also Apache Drill which works with a lot of data sources, which is philosophically closer to OctoSQL.

Haha, I'm sorry – I didn't mean to sound accusatory or anything like that. Text based communication can be tricky! :o) I very much appreciate the comparison!

Also, many thanks for the link and Apache Drill mention, will definitely look into these as well. Much obliged!

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#67

Post by vosper »

marviel wrote: post #63
hadem wrote: post #58

Earlier quoted context omitted.

You might also find Hasura interesting for instant GraphQL with Postgres: https://hasura.io/

Thanks! Have you tried both systems? I've never heard of hasura, so don't know the extent to which they compare. At a glance it looks like they serve largely the same problem.

I have tried both, but only a bit and for a personal project. In the end I went with Hasura because I like the admin interface, and I think the way it maps graphQL to SQL makes for easier-to-read (and write) graphQL queries.

I actually tried PostgREST first, because I had never used GraphQL and was more familiar with RESTful APIs. But I would go straight to Hasura if I was starting today.

When you combine graphql was graphql-codegen you can get typechecked queries, which is really nice.

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#68

Post by tyingq »

0xff00ffee wrote: post #59

Does anyone else find it humorous that the majority of top-level comments in this thread start with, "Cool! I built something just like this because sucks!" This tells me that (a) it is a common problem, and (b) it is not solved well. I'm guilty too: I manage a large MySQL DB and the admin panels are essentially CRUD UI rendered from the schema. The alt solutions I've clicked on here try to add more functionality, bu…

There are decent top-to-bottom solutions like Quickbase and Google's Appmaker. I think "generic" is just hard to mix well into other code. Works better if you control the whole stack.

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#69

Post by ianmobbs »

airstrike wrote: post #57
Rowern wrote: post #21

This looks pretty interesting! If anyone is looking for a tool to build a full fledge Back Office I warmly recommend react-admin ( https://github.com/marmelab/react-admin/ ). Been using it for a year now and we went from 0 back office to a feature full one in no time!

Or, you know, just use Django ;-)

This is a great option for stacks not built on Django!

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#70

Post by aidos »

marviel wrote: post #63
hadem wrote: post #58

Earlier quoted context omitted.

You might also find Hasura interesting for instant GraphQL with Postgres: https://hasura.io/

Thanks! Have you tried both systems? I've never heard of hasura, so don't know the extent to which they compare. At a glance it looks like they serve largely the same problem.

We’re using Hasura. Not affiliated but we do pay for their support (great team to work with).

Hasura have taken a few unusual steps that actually turn out to be good choices. They have their own version of row level security that you configure via the admin console. It plays very nicely with their subscription queries so there’s very little load on the dB (they effectively poll the dB and build a temp table of the config Params of each connected client so they can pull back the data for every subscription in a single query). It works really well in practice.

We kicked the tyres on most the products in the space (and even had our own implementation using socket io). There were a couple of things about Hasura that didn’t seem to make sense but after a quick call with them we decided that between their answers, and the team themselves, it was the product we liked and trusted the most.

Highly recommended.

Post reply on HN