upvote

points

by euroderf13 hours ago |
comments
upvoteby joren-13 hours ago|
next
[-]
As mentioned below I have been building the 'read' side of this: a data publication platform. I wanted to avoid any server side components. The communication / write part and updating the server-side sqlite database would need running components on the server which I wanted to avoid.

The 'write' part would technically be very doable and not that different from other back-ends.

https://github.com/GhentCDH/Pihka

reply
upvoteby mstipetic13 hours ago|
prev|
next
[-]
Did you have a look at https://evidence.dev
reply
upvoteby potatoman223 hours ago|
prev|
next
[-]
It's not specific to SQLlite per se, but that's what most dashboard builders are
reply
upvoteby dsego10 hours ago|
prev|
next
[-]
Something like sync engines? I think there are a bunch nowadays.

https://syntax.fm/show/924/sync-engines-and-local-data

reply
upvoteby uberex10 hours ago|
prev|
next
[-]
Like MS Access on web?
reply
upvoteby jumpkick7 hours ago|
parent|
[-]
Imagine if this were built into browsers and you only had to serve a SQLite file.
reply
upvoteby simonw3 hours ago|
parent|
[-]
I have a version of Datasette that runs entirely in the browser (using Pyodide and WebAssembly) and it's smaller than a lot of modern React homepages (12.35MB):

https://lite.datasette.io/

My more recent prototype shrinks that to 10.47 MB transferred: https://simonw.github.io/research/pyodide-asgi-browser/datas...

reply
upvoteby iLoveOncall11 hours ago|
prev|
[-]
Because it's pretty much worthless.

You almost never need just a basic list of all the data in your table, even if you're able to filter and sort it. There's no moat there at all. People need serious BI tools, and that throws simplicity out of the window (PowerBI, QuickSight, etc.).

reply
upvoteby mpeg5 hours ago|
parent|
[-]
I disagree, a lot of the time people buy "serious BI tools" precisely because they think they need all that power and complexity.

In reality, what most people need is much simpler, a mini app with some curated datasets and simple filters, maybe some AI querying if we want to get fancy. There's some companies out there that work with big data, but for the rest of us small data is ok.

reply
upvoteby simonw3 hours ago|
parent|
next
[-]
I think of Datasette as a "small data" platform, where small data is anything that would fit on my phone.

My phone has 1TB of storage.

reply
upvoteby mpeg1 hours ago|
parent|
[-]
I've used that with companies I consult for, everyone thinks they should do what Google does, so sometimes I'll drop them the "your whole company data fits in my phone/laptop" line to make them understand the (lack of) scale
reply
upvoteby uberex2 hours ago|
parent|
prev|
[-]
duckdb -ui
reply
upvoteby mpeg1 hours ago|
parent|
[-]
Data engineers hate this one simple trick
reply