Most active commenters
  • sqliteonline(3)

←back to thread

Show HN: SQLite Online – 11 years of solo development, 11K daily users

(sqliteonline.com)
464 points sqliteonline | 11 comments | 13 Oct 25 12:46 UTC | HN request time: 0.554s | source | bottom
Show context
bob1029 ◴[13 Oct 25 13:23 UTC] No.45568063[source]▶
I am really struggling to figure out what this is or how it provides value.

Edit:

This discussion isn't exactly what I was hoping for. I was looking for ways to better highlight the features or value proposition of this site. Not defenestrate it altogether.

E.g.: A simple modal that says "Welcome to SQLite Online! You can <core value proposition> with this tool." would have radically altered my initial perception.

replies(9): >>45568123 #>>45568268 #>>45568275 #>>45568972 #>>45569041 #>>45570012 #>>45570236 #>>45570287 #>>45570447 #
zvmaz ◴[13 Oct 25 13:29 UTC] No.45568123[source]▶
For me: Try queries without the hassle of setting up a database. Learn SQL. Experiment. Etc.
replies(2): >>45568317 #>>45568503 #
WesolyKubeczek ◴[13 Oct 25 13:48 UTC] No.45568317[source]▶
> For me: Try queries without the hassle of setting up a database.

    sqlite3 some-file.db
That's the whole "database setup" in case of SQLite.
replies(7): >>45568349 #>>45568579 #>>45568639 #>>45569094 #>>45569483 #>>45569819 #>>45572222 #
1. sqliteonline ◴[13 Oct 25 13:52 UTC] No.45568349[source]▶
This method is not available on all devices and does not support sharing or collaboration.

The website, however, works on any platform and allows working together in a single shared database.

replies(3): >>45568402 #>>45568523 #>>45568704 #
2. zwnow ◴[13 Oct 25 13:57 UTC] No.45568402[source]▶
you can just share the file, huh

collaboration sounds nice though, it definitely has a market considering 11k daily users.

replies(1): >>45568472 #
3. sqliteonline ◴[13 Oct 25 14:03 UTC] No.45568472[source]▶
If the database is loaded from an external source (as shown in the examples), using the "Share Script" feature automatically attaches a link to the database. The link allows both the database and the script to be accessed and loaded.
4. avinassh ◴[13 Oct 25 14:10 UTC] No.45568523[source]▶
how does collaboration works for SQLite, since the db is embedded?
replies(2): >>45569343 #>>45569776 #
5. WesolyKubeczek ◴[13 Oct 25 14:28 UTC] No.45568704[source]▶
> This method is not available on all devices and does not support sharing or collaboration.

The parent cites "hassle of creating the database" and does not mention sharing or collaborating. I showed that it doesn't get more hassle-free than this and doesn't even require connectivity (which might be a problem "on some devices" or "in some locations").

replies(1): >>45568904 #
6. rat9988 ◴[13 Oct 25 14:48 UTC] No.45568904[source]▶
> doesn't even require connectivity (which might be a problem "on some devices" or "in some locations").

You are just trying to prove a point instead of understanding it.

> "hassle of creating the database" and does not mention sharing or collaborating.

He might just have summarized everything as "hassle of creating the database".

Not everything on internet is supposed to be a debate with highly and carefully developped wording.

replies(1): >>45569275 #
7. jermaustin1 ◴[13 Oct 25 15:17 UTC] No.45569275{3}[source]▶
> You are just trying to prove a point instead of understanding it.

> He might just have summarized everything as "hassle of creating the database".

You are also making an assumption, though. That person might not have known "sqlite3 mydb.db" is all you need to create a sqlite database.

replies(1): >>45569851 #
8. kijin ◴[13 Oct 25 15:21 UTC] No.45569343[source]▶
Uhm, by allowing multiple people to connect to the same database through a webapp like this?
9. sqliteonline ◴[13 Oct 25 15:54 UTC] No.45569776[source]▶
When you upload a database to the site, it is stored in your browser's memory or uses OpFS — a local storage within your browser.

You can share a link to grant access to your database, with the connection handled via P2P through WebRTC.

replies(1): >>45571938 #
10. hombre_fatal ◴[13 Oct 25 16:00 UTC] No.45569851{4}[source]▶
It was just one item in a list and they used "etc." which prob refers to all the other obvious upsides, like why you would use pgadmin/postico to write postgres queries instead of psql cli.

So to double down on that one detail as if it were a load bearing remark comes off as trying to win a point.

If `sqlite3 test.db` launched a rich UI with tabs and such, then maybe they'd be onto something, but it does not.

11. ◴[13 Oct 25 18:46 UTC] No.45571938{3}[source]▶