I don't understand the people trying to convince others that this tool is useless by saying "just do it this way, duh!". It is useful, even from a rapid glimpse at the website.
I'm at the point where I know exactly what comment that is because of the comment ID of 9224. Don't even need to mention rsync, Dropbox, or anything else.
> This method is not available on all devices and does not support sharing or collaboration.
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").
Implicit assumptions: You know what a CLI is, you have one on your system, and how to install the sqlite3 binary somehow.
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
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.
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?
I don't understand the people trying to convince others that this tool is useless by saying "just do it this way, duh!". It is useful, even from a rapid glimpse at the website.
Be kind and sensible.
The just-use-rsync line of thinking doesn't go away https://news.ycombinator.com/item?id=9224
I'm at the point where I know exactly what comment that is because of the comment ID of 9224. Don't even need to mention rsync, Dropbox, or anything else.
> For me: Try queries without the hassle of setting up a database.
That's the whole "database setup" in case of SQLite.
This method is not available on all devices and does not support sharing or collaboration.
The website, however, works on any platform and allows working together in a single shared database.
how does collaboration works for SQLite, since the db is embedded?
3 replies →
you can just share the file, huh
collaboration sounds nice though, it definitely has a market considering 11k daily users.
1 reply →
> This method is not available on all devices and does not support sharing or collaboration.
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").
3 replies →
Implicit assumptions: You know what a CLI is, you have one on your system, and how to install the sqlite3 binary somehow.
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
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.
if you don't want it to be persisted
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?
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.
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?
>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.
2 replies →
Where do I type that in on my iPad?
Some people might not have computers but still want to learn?
Pay for one of the many SQLite Apps on the App Store, like Jobs intended?
I think someone forgot what made the web the most popular platform in the world.