Evidence.dev VS SQLPage - Build SQL-only websites

Dataclips was my first experiences writing SQL. Writing code was a markedly better DX that building dashboards in Tableau, which is why I'm now working on https://evidence.dev - a SSG for creating data from SQL and markdown Previous HN discussions:. - Source: Hacker News / about 21 hours ago

I'm one of the founders of Evidence (https://evidence.dev) - would be great to hear about your experience. Reaching out now! - Source: Hacker News / 1 day ago

Full fledged BI tools like Superset and Metabase are amazing for their intended use cases. But they may be an overkill if your primary use case is to infrequently build semi-interactive reports for non-technical end-users and your use cases are are mostly covered by standard graphs & tables. Esp. So if you are familiar with SQL and have access to the underlying data source. Two nifty utilities I have found to be... - Source: Hacker News / 2 days ago

We use ECharts in our open source BI tool (Evidence) and it's a great library. Has helped us build a declarative syntax for viz which can be version controlled (https://evidence.dev). - Source: Hacker News / 2 days ago

We used ECharts to build our charting library at Evidence and it’s been a great experience overall (https://evidence.dev. - Source: Hacker News / 14 days ago

Full fledged BI tools like Superset and Metabase are amazing for their intended use cases. But they may be an overkill if your primary use case is to infrequently build semi-interactive reports for non-technical end-users and your use cases are are mostly covered by standard graphs & tables. Esp. So if you are familiar with SQL and have access to the underlying data source. Two nifty utilities I have found to be... - Source: Hacker News / 2 days ago

I feel obligated to add a shameless plug here. The idea is very close to a project I presented at pgconf.eu last week: SQLPage https://sql.ophir.dev/ SQLPage has the same goal as postgrest+htmx, but is a little bit higher level. It let's you build your application using prepackaged components you can invoke directly from SQL, without having to write any HTML, CSS, or JS. - Source: Hacker News / 2 months ago

I have been thinking about that a lot recently. Where I work, we spend a very small fraction of our time on building things that are unique to our business. Maybe we are doing something very wrong, but I am under the impression that most of the code that gets written is extremely low-entropy. This low-entropy, repetitive coding is not limited to the user interfaces. We do tend to describe the same structures and... - Source: Hacker News / 3 months ago

The official website for SQLPage (https://sql.ophir.dev/) is written in SQLPage. The source code is here: https://github.com/lovasoa/SQLpage/tree/main/examples/official-site The github README has code snippets and associated screenshots: https://github.com/lovasoa/SQLpage#examples And SQLPage cloud is coming: https://sql.ophir.dev/your-first-sql-website/hosted.sql. - Source: Hacker News / 4 months ago

Yes ! Maybe I'm old-fashioned, but I do still think that SQL is a better interface to databases than excel formulas. I am building an open-source tool that allows quickly building web user interfaces on top of relational databases [1]. Among users are many people without a CS background, and without prior knowledge of SQL. And from the feedback I get, the pain point for getting started is very rarely learning SQL.... - Source: Hacker News / 4 months ago