←back to thread

464 points sqliteonline | 2 comments | | HN request time: 0.419s | source
Show context
bob1029 ◴[] 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 ◴[] No.45568123[source]
For me: Try queries without the hassle of setting up a database. Learn SQL. Experiment. Etc.
replies(2): >>45568317 #>>45568503 #
WesolyKubeczek ◴[] 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 #
ajmurmann ◴[] 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 #
1. chasil ◴[] 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 #
2. ajmurmann ◴[] 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.