It may be difficult to briefly describe all the website’s capabilities right now, but the key features include: * Federated queries across external and internal data sources. * Using query history as a source for new requests. * Collaborative access to databases — both server and local, with structure synchronization. * Automatic chart generation based on queries. * And much more, including hidden features that are not yet easy to summarize.
Be kind and sensible.
sqlite3 some-file.db
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
The website, however, works on any platform and allows working together in a single shared database.
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.
collaboration sounds nice though, it definitely has a market considering 11k daily users.
Some people might not have computers but still want to learn?
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.
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.
That being said, I feel like I'm dumped into the playground without understanding what I am playing with. A few short paragraphs, examples, screenshots, explanations, ect, would go very far.
I think an “About” page or docs would greatly help people that want to know all of the features offered by the site, but I think the default of dropping you into the tool is ideal.
Would have made homework (and just learning) significantly easier.
And then have a big hero button leading to the the actual tool ('/app' or '/playground' or whatever). Maybe preloaded with different sample data depending on the use case.
Right now, being dumped into a complicated interface with zero explanation is very confusing. (None of this is to criticize the project itself, just to help identify it to the people who might find the most value in it!)
I don't have the time to spend 10 minutes getting to know a product's features to try to figure out what it might be for.
Just tell me what it's for.
I mean, it's great if people can figure out other uses for it too. If they want to use it in a new way, awesome -- don't get me wrong. But products are generally built with specific purposes in mind. So don't hide those.
1: No install
2: Ephermal (just reload if you've messed up?)
3: Good syntax highlighting
4: Visual UI to navigate the model
Why to pay for it though? That's a harder nut to crack, the UI is quite nice compared to many I've seen so maybe sell as an addon for those that provider hosted databases, collaborative spaces or as a desktop app. No obvious slam dunks though.
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.