←back to thread

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

(sqliteonline.com)
464 points sqliteonline | 1 comments | 13 Oct 25 12:46 UTC | HN request time: 0.201s | source
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. asveikau ◴[13 Oct 25 19:16 UTC] No.45572222[source]▶
I had the same reaction, why not just use the command line interface?

From there, I guess the value this adds is:

1. There is a UI, i.e. it has some autocomplete of sql syntax and it shows tables in a ... tabular format.

2. As others have mentioned, there are sharing features. Yes you could share a .db file, but with this you can also send a link viewable in a browser, with specific queries, etc.

#1 reminds me of MS Access from back in the day. Those were sql dbs underneath, but they had some interfaces to show you how to build queries. It wasn't a bad way to dip your toes into the basics of sql.