←back to thread

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

(sqliteonline.com)
464 points sqliteonline | 7 comments | 13 Oct 25 12:46 UTC | HN request time: 0.888s | 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. ajmurmann ◴[13 Oct 25 15:03 UTC] No.45569094[source]▶
How do I get this sqlite3 command to work on my Chromebook? When I type this in on my Windows machine it's not working either. Are there other steps I need to take first?
replies(3): >>45569245 #>>45569309 #>>45570762 #
2. jermaustin1 ◴[13 Oct 25 15:14 UTC] No.45569245[source]▶
As a developer, on your development machine, if you use sqlite even infrequently, then no.

Anyone else, probably, but then why would you use this tool if you have no need for sqlite?

3. encom ◴[13 Oct 25 15:19 UTC] No.45569309[source]▶
>my Chromebook

LOL

>my Windows

If you're the kind of person who even knows what SQL, SQLite or hell even a database is, you already know SQLite runs on pretty much anything.

replies(1): >>45571810 #
4. chasil ◴[13 Oct 25 17:06 UTC] No.45570762[source]▶
On your Chromebook, load the Linux subsystem, which you can find in settings.

It will give you a shell that will have SQLite.

For Windows, download the interactive command line tool from sqlite.org.

replies(1): >>45574781 #
5. conductr ◴[13 Oct 25 18:36 UTC] No.45571810[source]▶
Why would you assume that's the kind of person you're responding to? Their question alone leads me to believe it's exactly not that kind of person.
replies(1): >>45573171 #
6. somehnguy ◴[13 Oct 25 20:46 UTC] No.45573171{3}[source]▶
Their question was sarcasm basically saying this site provides convenience by way of not needing any up front steps.
7. ajmurmann ◴[14 Oct 25 00:13 UTC] No.45574781[source]▶
Thanks for your answer! That said, I know how to install SQLite and am well-familiar with it.

My point was that the parent's comment did not tell the full story. A student just trying to do the first baby steps with SQL won't know any of this. Yet with the website shown here, they can immediately focus on the actual SQL, no matter what devise they are on, as long as it has a functioning browser.