For me:
Try queries without the hassle of setting up a database.
Learn SQL.
Experiment.
Etc.
Be kind and sensible.
sqlite3 some-file.db
The website, however, works on any platform and allows working together in a single shared database.
collaboration sounds nice though, it definitely has a market considering 11k daily users.
You can share a link to grant access to your database, with the connection handled via P2P through WebRTC.
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").
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.
> 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.
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.
sqlite3 :memory:
Anyone else, probably, but then why would you use this tool if you have no need for sqlite?
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.
It will give you a shell that will have SQLite.
For Windows, download the interactive command line tool from sqlite.org.
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.
Some people might not have computers but still want to learn?
When I just started out with linux I was so frustrated with people just listing reams of commands, or files I needed to edit without stating I needed to look in /etc
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.