5 ms·
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
by bob1029 1y ago
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.
- zvmaz 1y agoFor me: Try queries without the hassle of setting up a database. Learn SQL. Experiment. Etc.
- WesolyKubeczek 1y ago> 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.
- cortesoft 1y agoWhere do I type that in on my iPad? Some people might not have computers but still want to learn?
- josefx 1y agoPay for one of the many SQLite Apps on the App Store, like Jobs intended?
- sqliteonline 1y agoThis 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.
- zwnow 1y agoyou can just share the file, huh collaboration sounds nice though, it definitely has a market considering 11k daily users.
- sqliteonline 1y agoIf the database is loaded from an external source (as shown in the examples), using the "Share Script" feature automatically attaches a link to the database. The link allows both the database and the script to be accessed and loaded.
- avinassh 1y agohow does collaboration works for SQLite, since the db is embedded?
- kijin 1y agoUhm, by allowing multiple people to connect to the same database through a webapp like this?
- sqliteonline 1y agoWhen you upload a database to the site, it is stored in your browser's memory or uses OpFS — a local storage within your browser. You can share a link to grant access to your database, with the connection handled via P2P through WebRTC.
- deleted 1y ago[deleted]
- WesolyKubeczek 1y ago> 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").
- oblio 1y agoI think someone forgot what made the web the most popular platform in the world.
- killerstorm 1y agosqlite3 :memory: if you don't want it to be persisted
- ajmurmann 1y agoHow 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?
- jermaustin1 1y agoAs 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?
- encom 1y ago>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.
- chasil 1y agoOn 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.
- ajmurmann 1y agoThanks 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.
- Aeolun 1y agoImplicit 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
- asveikau 1y agoI 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.
- zvmaz 1y agoI 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.
- mchaver 1y agoThe just-use-rsync line of thinking doesn't go away https://news.ycombinator.com/item?id=9224 https://news.ycombinator.com/item?id=9224
- Sohcahtoa82 1y agoI'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.
- deleted 1y ago[deleted]
- tiffanyh 1y agoI would have loved this 25-years ago during university. Would have made homework (and just learning) significantly easier.
- gwbas1c 1y agoIt's clear that the tool is highly useful to the people who use it. 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.
- sqliteonline 1y agoYes, we plan to add starter tips with explanations of their purpose.
- tuveson 1y agoJust to offer another perspective: I think the way your website works right now is actually very nice and the person you’re replying to is wrong. When I go to godbolt.org, it similarly puts me on the screen where I actually want to be, as a person that wants to use that tool. 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.
- jairuhme 1y agoAgree with your edit saying that there should be a landing message that gives a quick overview. But with in a few moments I was able to see that you can create a database and then start inserting tables/records into it. Seems like a pretty good tool to learn how to create and manage a database without the hassle of having to download sqlite and start testing commands that might be new to you in the CLI
- sqliteonline 1y ago> You can <core value proposition> 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.
- LtdJorge 1y agoIf you want your points to appear in different lines in HN, use two backspaces :)
- sqliteonline 1y agoThank you
- crazygringo 1y agoYup, I think it would be a big help if the home page ('/') was a landing page explaining who it's for and why, and why. Is this for students? For prototyping? For quick analysis? Sample data? Importing real data? Use cases are key. 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!)
- qmmmur 1y agoCan’t people decide themselves what it’s for?
- crazygringo 1y agoNo? 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.
- sqliteonline 1y agoThank you for your feedback. The idea was to make the product understandable without additional explanations, but it seems I didn’t achieve that. I have a lot to improve.
- whizzter 1y agoAs an educator I would've loved to have this last time I was teaching SQL. 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.
- benibela 1y agoAt first I thought that was about SQLite development itself