evidence
mathesar
evidence | mathesar | |
---|---|---|
45 | 53 | |
3,351 | 2,209 | |
5.3% | 2.1% | |
10.0 | 9.9 | |
3 days ago | 7 days ago | |
JavaScript | Python | |
MIT License | GNU General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
evidence
-
Ask HN: What's the best charting library for customer-facing dashboards?
We use echarts at https://evidence.dev and have been quite happy with it. We do a lot of embedded analytics and it's worked well for us.
-
SQLPage – Building a full web application with nothing but SQL queries [video]
It’s interesting to me how far you have pushed the SQL language in this framework, such that it truly is “SQL only”.
The challenge as I see it with enabling analysts to build websites is that you need to build abstractions to get from familiar (SQL, yaml) - the language of analytics, to new (HTML, CSS, JS) - the language of the web browser
As one of the maintainers of Evidence (https://evidence.dev), one of the things I’ve often considered is how accessible our syntax is to analysts. Our syntax combines SQL and Markdown, with MDX style components e.g.
The are inherently webdev-ey, and I do think they put off potential users.
On the flip-side, by adhering to web standards, you get extensibility out of the box, and working out what to do is just a Google search away.
Anyway, thanks for the thought provoking piece.
-
Blazer: Business Intelligence Made Simple
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:
-
Is Tableau Dead?
I'm one of the founders of Evidence (https://evidence.dev) - would be great to hear about your experience. Reaching out now!
-
Apache Superset
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 very useful for latter kind of use cases are SQLPage and Evidence.
They make it very convenient to whip out some SQL and convert that to a neat professional looking web ui that can be forwarded to an end user. In case of Evidence it is a statically generated site, and in case of SQLPage it is a web app that connects to a live database.
SQLPage: https://sql.ophir.dev/
Evidence: https://evidence.dev
-
A love letter to Apache Echarts
We used ECharts to build our charting library at Evidence and it’s been a great experience overall (https://evidence.dev).
We started with D3 and a few other tools, but felt that we get a lot more out of the box with ECharts, like interactivity and an events API. ECharts is also a lot more extensible than people give it credit for.
If anyone is curious, we documented the process of selecting a charting library after assessing several options: https://github.com/evidence-dev/evidence/issues/136
- Evidence, a static site generator for data apps
-
Observable 2.0, a static site generator for data apps
The new direction seems very similar to what evidence has been doing for a while
https://evidence.dev
-
PRQL as a DuckDB Extension
I'm quite excited about this, and would also love to have it distributed as an NPM package.
I work on an OSS web framework for reporting/ decision support applications (https://github.com/evidence-dev/evidence), and we use WASM duckDB as our query engine. Several folks have asked for PRQL support, and this looks like it could be a pretty seamless way to add it.
-
Nota is a language for writing documents, like academic papers and blog posts
> Not sure the language you choose matters as much as making the API usable by a wide audience.
Fully agree with this, and having typeset my masters thesis and later my resume using LaTeX, I think that the “authoring experience” is 100% the place to focus on improving.
If you’re interested in the “markup to document publishing” space, you might also be interested in the open-source report publishing tool I’m now working on, Evidence (https://github.com/evidence-dev/evidence)
It’s similarly based on markdown, though uses code fences to execute code, HTML style tags for charts and components, and {…} for JavaScript, i.e.
---
mathesar
-
Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable
Congratulations on launching, it's nice to see more open source products in this area (I work on https://mathesar.org/). Feel free to reach out if you'd like to talk and compare notes.
-
A modern, open-source spreadsheet that goes beyond the grid
This is what we're trying to do with [Mathesar](https://github.com/centerofci/mathesar). We probably don't meet your needs yet because we don't support real-time concurrent editing, but we're actively working on the project and it is early days.
-
Show HN: Visual DB – Airtable alternative for your own database
I'm an engineer on the Mathesar core team and I'd just like to clarify that Mathesar does support grouping to some extent. Here is a screenshot[1] that demonstrates the grouping functionality. Grouping levels are unlimited. You can play with this functionality on our live demo[2]. It's worth mentioning that Mathesar does not yet have the capability to expand and collapse groups, but that feature is planned[3].
Best of luck building Visual DB! Nice to see more innovation in this space!
[1]: https://mathesar.org/assets/crm-table-zoomed.png
[2]: https://demo.mathesar.org/
[3]: https://github.com/centerofci/mathesar/issues/475
-
Ask HN: What’s the best GUI you’ve ever used for managing/querying databases?
I’m not sure if it’s okay to plug my project, but I work on Mathesar (https://github.com/centerofci/mathesar) which can be used as a Postgres GUI. We’re putting a lot of product/design effort into making it nice to use for non technical users.
Otherwise, I just use the command line.
-
I'm So Frustrated Finding a NocoDB Alternative (Need a Postgres / SQL-Based Spreadsheet)
We're trying to do this with Mathesar: https://github.com/centerofci/mathesar. Some feedback would be great!
-
Undb – open-source airtable alternative
We're trying to build a community driven project in this space - https://github.com/centerofci/mathesar. We just did our alpha release a couple of months ago.
I'm philosophically opposed to open core (Mathesar is run out of a non-profit), but I can see why other projects do it – finding funding for a big project like this is difficult without VCs (who expect returns).
-
MS Access alternative?
I'm working on https://mathesar.org/ – it's an open source database solution built on Postgres, you can import data, connect to multiple databases, edit data and build reports. It can't connect to non-Postgres databases, so it may not work for you.
-
Release announcement: Mathesar v0.1.2
We've just released Mathesar v0.1.2. Major new features are support for multiple databases in the UI and more options for installing Mathesar. We also made a bunch of smaller UX improvements and fixed a few bugs. Our full release notes are here: https://github.com/centerofci/mathesar/releases/tag/0.1.2
-
I want to create sheets that work like Airtable (www.airtable.com) and use it in my django application any suggestions on how it can be done.
We did this for our open source project, Mathesar (https://github.com/centerofci/mathesar), which also uses Django. It's a lot of work. You can take a look at our code if it's helpful.
- Ask HN: What are Airtable alternatives with higher rate limits?
What are some alternatives?
metriql - The metrics layer for your data. Join us at https://metriql.com/slack
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
superset - Apache Superset is a Data Visualization and Data Exploration Platform
mito - The mitosheet package, trymito.io, and other public Mito code.
Trino - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
Mattermost - Mattermost is an open source platform for secure collaboration across the entire software development lifecycle..
streamlit - Streamlit — A faster way to build and share data apps.
apitable - 🚀🎉📚 APITable, an API-oriented low-code platform for building collaborative apps and better than all other Airtable open-source alternatives.
re_data - re_data - fix data issues before your users & CEO would discover them 😊
budibase - Budibase is an open-source low code platform that helps you build internal tools in minutes 🚀
lightdash - Self-serve BI to 10x your data team ⚡️
trivy - Find vulnerabilities, misconfigurations, secrets, SBOM in containers, Kubernetes, code repositories, clouds and more