datasette-app
grist-core
datasette-app | grist-core | |
---|---|---|
12 | 52 | |
115 | 6,233 | |
- | 2.3% | |
2.6 | 9.8 | |
about 1 year ago | 7 days ago | |
JavaScript | TypeScript | |
- | Apache License 2.0 |
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.
datasette-app
-
Welcome to Datasette Cloud
Hah, Softbank isn't the goal here!
I realized that Datasette is the first project of my entire career where if I was still working on it in 15 years time I wouldn't feel bored yet. There's just SO MUCH scope for interesting applications of the core idea.
As such, I want to work on it for decades. But it's lonely working on it alone (the community around it has been growing and is delightful, but it's not the same as having a full-time team.)
So the question I'm trying to answer is how to make the project financially sustainable in the long-run - not just for myself, but so I can pay for a team to work on it with me.
There are plenty of other examples of open source projects that have turned SaaS hosting into a sustainable business model - WordPress and GitLab are just two of the best examples. It feels like it's a reasonably well-trodden path.
Plus... I want people to be able to use my software. Currently to use Datasette as an individual you either have to "pip" or "brew" install it, or you can try the macOS Electron app - https://datasette.io/desktop - but I want newsrooms to be able to use it to collaborate on data. And most newsrooms aren't well equipped to configure a Linux server.
So I realized that a hosted SaaS version can solve two issues at once: it can help the audience I care about actually benefit from the value of the software so far, and it provides a reasonably realistic path to financial sustainability for the project as a whole.
And yeah, I'd also like to make a ton of money out of it myself too!
-
Bing: “I will not harm you unless you harm me first”
It would be nice if his stuff worked better, ironically. The Datasette app for Mac seems to be constantly stuck on loading (yes I have 0.2.2):
https://github.com/simonw/datasette-app/issues/139
Amd his screen capture library can't capture Canvas renderings:
https://simonwillison.net/2022/Mar/10/shot-scraper/
Lost two days at work on that.
Speaking of technology not working as expected.
-
Datasette is my data hammer
I'd love to get the desktop app working on Linux and Windows.
I did manage to get a prototype working on Windows, despite having VERY little experience working on that platform: https://github.com/simonw/datasette-app/issues/71
The bit I'm stuck on is how to turn that prototype into an application with an installer that's signed so people can download and run it.
-
Automating screenshots for the Datasette documentation using shot-scraper
I have trouble answering this question myself, and I created it!
The problem I have is that it can be applied to too many different problems.
I personally have used it for the following (a truncated summary):
- Publishing data online to allow other people to explore it, for example https://scotrail.datasette.io and https://russian-ira-facebook-ads.datasettes.com/
- Building websites, by combining it with custom templates. https://datasette.io and https://www.niche-museums.com and https://til.simonwillison.net are three examples
- Building my own combined search engine over a bunch of different data. https://github-to-sqlite.dogsheep.net is this for my GitHub issues and commits and issue comments across 100+ projects
- Similarly, building a code search engine across multiple repos (partly to demonstrate how far you can go with custom plugins): https://ripgrep.datasette.io
- Any time I have a CSV file I open it in the Datasette Desktop macOS app first to start exploring it: https://datasette.io/desktop
- As a prototyping tool. It's the fastest way I know of to get from some data files (CSV or JSON) to a working JSON API - and a GraphQL API too using this plugin: https://datasette.io/plugins/datasette-graphql
- Messing around with geospatial data - here's a write-up of my favourite experiment with that so far: https://simonwillison.net/2021/Jan/24/drawing-shapes-spatial...
This is a bewilderingly wide array of things! And I keep on finding new problems I can apply it to:
Of course, if all you have is a hammer, everything looks like a nail. But thanks to the plugin system (and the amazing flexibility of SQLite under the good) I can reshape my hammer into all sorts of interesting shapes!
I've been trying to capture some of this at https://datasette.io/for
This is one of my biggest marketing challenges for the project though. If someone asks you for an elevator pitch you need to do better than spending 15 minutes talking through a wide ranging bulleted list!
- Upscayl – Free and Open Source AI Image Upscaler for Linux, macOS and Windows
-
What’s the best cheap program to start??
You can use my Datasette software to explore the database: https://datasette.io/desktop - that's the Mac version but you can run the underlying software on Windows too.
-
Cool SQL projects?
Then you can either run "pip install datasette" and "datasette healthkit.db" or you can install the Datasette Desktop app from https://datasette.io/desktop and use that to open the database file.
-
Need helping actually using SQL
You may find my Datasette Desktop Mac application useful: it provides a read-only interface over SQLite and cdn oprn both SQLite files and CSV files: https://datasette.io/desktop
-
JupyterLab Desktop App now available
This is really interesting to see. I've been trying to solve a similar problem over the past few weeks - bundling up a Python web application as an installable Desktop app, in my case for https://datasette.io/desktop - so it's really interesting to see how they've approached the problem.
I ended up including a full copy of Python using https://github.com/indygreg/python-build-standalone - it looks like they've bundled Conda.
I wrote up detailed notes on how I solved the Python bundling problem in https://simonwillison.net/2021/Sep/8/datasette-desktop/#how-... and in https://til.simonwillison.net/electron/python-inside-electro...
-
Datasette Desktop 0.2.0: The annotated release notes
I've been having a ton of fun building this. The code is all open source at https://github.com/simonw/datasette-app - it's my first time working with Electron and the biggest task was figuring out how to bundle Python inside an Electron app, which I wrote about in detail here: https://til.simonwillison.net/electron/python-inside-electron
grist-core
-
Ask HN: Who is hiring? (March 2024)
and poke around. If the words battery correct horse staple mean something to you, you might have an advantage.
The heart of the software you'll be working with: https://github.com/gristlabs/grist-core/
-
Form to DB
Because the single-system paradigm doesn't work any more. However, modern replacements do exist, Airtable is one of the first; it's basically the notion of a "spreadsheet with more structure", and then building forms and such on top of that. I've recently been playing with Grist and like it, although it is rough around the edges.
https://www.getgrist.com
- Ask HN: Spreadsheets like Google Sheets but not from Google?
- Show HN: I made an app that consolidated 18 apps (doc, sheet, form, site, chat)
-
A modern, open-source spreadsheet that goes beyond the grid
i want exactly the opposite - something that does not try to be a spreadsheet, but gives me a grid view of a database table, with concurrent edits a la google sheets, and lets me access the same data from my webapp backend.
i have been searching for this for literally years, all the time maintaining an app as a google sheets script, because much as i would prefer something self-hosted and customisable, that collaborative grid view is the ideal user interface from my users' point of view. so far nothing has fit the bill - basetool (https://github.com/basetool-io/basetool) might have but it's discontinued and underdocumented, and i'm not really a web developer so i don't feel up to the challenge of getting it running and integrated into an app.
grist actually came really close from a ui perspective, but it was too focused on being a spreadsheet and doing computation in the frontend. i filed an issue that explains my use case in more detail: https://github.com/gristlabs/grist-core/issues/422
-
Unicorn Startup Airtable Lays Off 27% of Firm, Shifts Focus to Big Clients
Founder of Grist here (https://www.getgrist.com/):
- focus on small teams and individuals
- open source (with community contributing!)
- can be run self-managed
- portable data (lossless export in SQLite format)
- full of great features (granular access rules, formulas with python, conditional formatting, webhooks, etc etc)
If it's little-known, it's because we spend too much time building, not enough time selling.
- Grist Is the Evolution of Spreadsheets
-
From no-code to co-code
The exact LLM used in the experiment mentioned in this post was upstage-llama-2-70b-instruct-v2.ggmlv3.q2_K. Grist was configured to use it via llama-cpp-python and https://github.com/gristlabs/grist-core#ai-formula-assistant...
-
Microsoft is bringing Python to Excel
https://github.com/gristlabs/grist-core/
-
Welcome to Datasette Cloud
Check out Grist in the ‘Access with sane backend’ space. SQLite, open source and fantastic UX https://www.getgrist.com/ and https://github.com/gristlabs/grist-core
I use and love both Datasette and Grist - they’re complementary.
What are some alternatives?
til - Today I Learned
budibase - Budibase is an open-source low code platform that helps you build internal tools in minutes 🚀
fusionauth-site - Website and documentation for FusionAuth
authentik - The authentication glue you need.
iron.nvim - Interactive Repl Over Neovim
Gotify - A simple server for sending and receiving messages in real-time per WebSocket. (Includes a sleek web-ui)
vscode-nodebook - Node.js notebook
worldle
vscode-jupyter - VS Code Jupyter extension
Trilium Notes - Build your personal knowledge base with Trilium Notes
django-sql-dashboard - Django app for building dashboards using raw SQL queries
yunohost - YunoHost is an operating system aiming to simplify as much as possible the administration of a server. This repository corresponds to the core code, written mostly in Python and Bash.