|almost 2 years ago||23 days ago|
|-||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.
What If OpenDocument Used SQLite?
8 projects | news.ycombinator.com | 18 Sep 2023
In any case, homebrew can't install prerequisite osxfuse onto Ventura.
There is also this, which seems to work: https://github.com/jilio/sqlitefs
Why SQLite may become foundational for digital progress
9 projects | news.ycombinator.com | 22 May 2022
Ask HN: What are some unpopular technologies you wish people knew more about?
56 projects | news.ycombinator.com | 2 Dec 2023
Don't overlook https://datasette.io/ even though it does much more than endpoints.
Effective GPT-4 Programming
2 projects | news.ycombinator.com | 14 Nov 2023
What is Glamorous Toolkit v1.0?
3 projects | news.ycombinator.com | 5 Nov 2023
OK, having watched the video at https://www.youtube.com/watch?v=lqogvp1dGpk (8 minutes, so 4 minutes if you 2x it) I understand why they have such a hard time answering the question "What is Glamorous Toolkit?"
It's effectively a combination of a Smalltalk IDE, a Jupyter/Observable-style notebook environment and a tool somewhat like R Studio.
It's a hard thing to categorize, because it's not exactly the same kind of thing as anything else.
I emphasize wit the challenge: I have a similar problem with my https://datasette.io/ project.
Portugal. The Man – Official Website Is a Google Sheets Document
7 projects | news.ycombinator.com | 3 Nov 2023
Thanks for the response, I was looking at your site from mobile earlier and it didn't jump out at me that it could also be used to edit data (tho I now see it mentioned clearly). Might be worth calling it out in a section as easy editing.
Btw how would you compare this to https://datasette.io/ which is the first thing that came to mind? Is yours a bit more developer oriented?
Seeking Help to Preserve Rare WWII Database on Windows 98
2 projects | news.ycombinator.com | 18 Sep 2023
Looks like it's an Access database. Perhaps convert it to SQLite and publish with something like https://datasette.io/?
I think the problem is, thread author doesn't know how to rip an ISO of the CD or move the database out; looks like they are getting help already though.
Why my favourite API is a zipfile on the European Central Bank's website
10 projects | news.ycombinator.com | 15 Sep 2023
You might find a lot of interesting tools in the Datasette ecosystem. Data dashboarding for SQLite with all sorts of import and export and visualization plugins.
GitHub – GSA/code-gov: An informative repo for all Code.gov repos
12 projects | news.ycombinator.com | 9 Sep 2023
> You can use this tool to open any SQLite database file that is hosted online and served with a `access-control-allow-origin: ` CORS header. Files served by GitHub Pages automatically include this header, as do database files that have been published online using `datasette publish`.*
> [...] You can paste in the "raw" URL to a file, but Datasette Lite also has a shortcut: if you paste in the URL to a page on GitHub or a Gist it will automatically convert it to the "raw" URL for you
> To load a Parquet file, pass a URL to `?parquet=`
There are various *-to-sqlite utilities that load data into a SQLite database for use with e.g. datasette. E.g. Pandas with `dtype_backend='arrow'` saves to Parquet.
datasette plugins are written in Python and/or JS w/ pluggy:
Why Open Source?
5 projects | news.ycombinator.com | 21 Aug 2023
I'm building https://www.datasette.cloud/ and https://datasette.io/ almost entirely open source for a number of commercial reasons.
1. I want organizations (initially newsrooms that care about data journalism, but rapidly growing beyond that) to be able to trust the product. The default result of 95% of startups is to go out of business, and going all-in on a product that then blinks out of existence is bad! When I'm selecting a vendor this is a thing I always consider, so I'd like my customers to feel confident that they have the ultimate escape hatch - run it yourself - should they ever need it.
2. Newsrooms in particular have learned this lesson before, many times over. Remember Google Fusion Tables? https://en.wikipedia.org/wiki/Google_Fusion_Tables That's just one relatively recent example.
3. Datasette is an ecosystem play. There are over 100 plugins already - https://datasette.io/plugins - and I hope for there to be thousands more. Developers don't invest nearly as heavily in building and releasing plugins for closed-source platforms.
4. Open source is a way for me to punch _way_ above my weight. I can have a much larger impact on the world by participating in open source, compared to if everything I'd been building had been closed.
Welcome to Datasette Cloud
6 projects | news.ycombinator.com | 20 Aug 2023
The https://datasette.io/ homepage has that video.
Htmx is part of the GitHub Accelerator
12 projects | news.ycombinator.com | 16 Aug 2023
I dropped Accept header support from https://datasette.io/ because it's open source software that I build for other people to use, and I knew that it was very likely one of my users would choose to run it behind Cloudflare (or run it on a vendor like Vercel who might have a partnership with Cloudflare).
What are some alternatives?
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
duckdb - DuckDB is an in-process SQL OLAP Database Management System
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
litestream - Streaming replication for SQLite.
Sequel-Ace - MySQL/MariaDB database management for macOS
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
roapi - Create full-fledged APIs for slowly moving datasets without writing a single line of code.
dbhub.io - A "Cloud" for SQLite databases. Collaborative development for your data. 😊
Sapper - The next small thing in web development, powered by Svelte
temporal_tables - Temporal Tables PostgreSQL Extension