The site takes a long time to load: is your internet slow?
If you have an old version of the browser update to the latest or use the latest version of chrome.
Close all tabs with the site and reload the last one.
support: z@sqliteonline.com
downloadable font: Glyph bbox was incorrect (glyph ids 33 55 62 81 82 83 84 87 88 89 90 112 119 120 123 139 159 162 164 166 178 184 185 217 218 272 273 274 275 279 281 284 290 291 292 309 310 319 321 323 326 329 330 331 332 333 334 339 341 347 349 351 352 353 354 357 358 361 366 367 370 371 414 431 436 444 445 458 460 464 465 483 505 508 511 514 516 517 518 520 521 538 539 546 568 574 579 580 585 586 594 596 599 602 603 616 618 622 627 629 630 633 634 638 643 645 651 654 665 675 685 686 688 691) (font-family: "FontAwesome" style:normal weight:400 stretch:100 src index:1) source: https://sqliteonline.com/fonts/fontawesome-webfont.woff2?v=4...
using deprecated parameters for the initialization function; pass a single object instead sog3.js:2251:21
Uncaught (in promise) ReferenceError: RTCPeerConnection is not defined <anonymous> https://sqliteonline.com/f/agw31.0.26.min.js:49 async* https://sqliteonline.com/f/agw31.0.26.min.js:87 async* https://sqliteonline.com/f/agw31.0.26.min.js:89
RTCPeerConnection is available in Firefox and Chrome since 2017... son unless the browser is veeery old... Maybe something blocking RTC?
Could you share some numbers like a ballpark of subscribers?
Just show and charge 10 USD. You can localize that other currency (Rubles?) if GeoIP matches.
The point is that you need a bank to accept a payment in foreign currency and debit it into your account.
I'd vicariously love for you to be able to make some/more revenue with this!
+1 on @redox99's comment that charging in rubles is most probably confusing, and that a flat $10 usd/month would be easier. I also would think that renewal should actually be on by default, not off - if people want the service and/or to support you, having auto renewal off is more of a hassle for them (the customers who want to pay you!) as they'd have to have to... re-enable their service? every 30-90 days?
and another point I wanted to bring up is that it feels to me like a small text-based advertisement from ethicalads.io (the folks behind the ads on Read the Docs sites) or carbonads.net (btw I have no affiliation to either) could definitely... bring in some not-bad revenue pretty much immediately?
again, huge congrats on your project and I truly wish you'll be able to find some path to monetization. cheers!
As a Brit, I'd rather GBP...
Isn't this comment a form of US defaultism?
Isn't this comment a form of Brit defaultism?
Even if you don't know the conversion, something in the range of 50-200% is a lot easier to adjust to, whereas Rubles are on a very different scale (1 GBP = 108 Rubles)
Obviously the ideal would be local listings, but USD is probably the most-familiar reference point if you have to choose exactly one
So it will be safer to just use languages you are comfortable with, like English and Russian. Especially on pages that concern money. :)
> No auto-renewal
That's not subscription.
Similar to ChatGPT.
But those who knew what it is, their usage is huge.
At the time there were dozens of search engines and new ones every day. Everybody knew what search engines were, and what they offered. Google did not invent the form field -> SRP pattern; people were already used to that. Google was able to rise above the field because 1. yes the homepage was nice, but more importantly 2. the results were so much better than competitors.
I don't understand the comparison to SQLite online because what are the well-known competitors, and what is it even trying to do?
Not even going to touch the ChatGPT comparison.
The clean interface just stood out as the other competitors at the time we're bogged down by ads. So a quick loading page in a time of slow internet connections, was a very nice user-centric feature.
And FURTHERMORE, the $ sign is incorrectly to the right of the numbers. It should be $10. Personally, this shows such a lack of product thinking, and simply hacking away at a tool instead of delivering a service.
(or: just solicit feedback in a space frequented by designers, and harness the power of being wrong on the internet ;)
I thankfully have no use for the tool since I no longer have to code SQL - the world is a better place for it.
It raises the question how many more "bus tools"[1] are there? Tools maintained and developed by a single developer with whom, when hit by a bus, the tool would die.
[1] no offence meant but "bus developers" is the term I learnt, it seems a little cruel to speak of folks being hit by buses - is there something better nowadays?
Maybe buy a new domain name like below (and direct to your existing from this new url).
EasyLearnSQL.com
TrySQLonline.com
LearnOnlineSQL.com
All of these domain names are available for sale under $10.And the more descriptive name might allow you to not have to change the UI.
(Very cool project by the way and congrats on 11 years)
The domain doesn't really matter so much as you can see with "replit.com", "chatgpt.com" or "stripe.com" which don't explain anything either.
If you want to invest time I'd suggest:
- Clean up design (Remove multiple disclaimers, side bar etc.)
- Add h1/h2 that instantly explains what this is about
- Have a list of simple examples that can be executed, not just "select * from demo"
- If you want to increase traffic, take a look at "site:sqliteonline.com" on Google. There's currently only 14 pages indexed, so lots of low hanging fruits to optimize. Could also be extended by having pages dedicated to examples or a topic that people can land on if they search for things like "left join sqlite" etc.
- Change site title from "SQL Online AiDE - Next gen SQL Editor | SQL Compiler" to something explaining what this is about.
But you're not wrong - i dont think the domain has a big effect, and personally i'd rather save $10.
You can also use secondary domains for landing pages. But that's probably out of pet projects' scope.
It would be apropos to at least have an "about" dialog somewhere, or maybe one of those "quick tour" popups.
SELECT * FROM sqlite_schema WHERE type='table' ORDER BY name;
The website does seem to correctly return the names/schemas of whatever tables you've created if you run the command above, but the editor (incorrectly) adds red squigglies around the command, since I guess it doesn't realize this is allowed.
Cool, but, you're not breaking any Guinness world record.
There are solo founders behind many websites and tools and you might not even know that.
Having a quick online link to get students started is really useful from a student motivation standpoint. This allows them to get a sense of the query flow before having to set up their own database or moving on to other DBMSes.
Congratulations on 11 years!
Also where is it based ? And your payment processor ?
I like to support learning platforms like this financially, when they work of course, but that's going to be a problem if you're based in Russia.
Privacy minded users might have it disabled by default since it's a good fingerprinting source.
Currently the website doesn't load if WebRTC is disabled.
bob1029•1d ago
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•1d ago
WesolyKubeczek•1d ago
sqliteonline•1d ago
The website, however, works on any platform and allows working together in a single shared database.
zwnow•1d ago
collaboration sounds nice though, it definitely has a market considering 11k daily users.
sqliteonline•1d ago
avinassh•1d ago
kijin•1d ago
sqliteonline•1d ago
You can share a link to grant access to your database, with the connection handled via P2P through WebRTC.
WesolyKubeczek•1d ago
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").
rat9988•1d ago
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.
jermaustin1•1d ago
> 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.
hombre_fatal•1d ago
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.
oblio•1d ago
killerstorm•1d ago
ajmurmann•1d ago
jermaustin1•1d ago
Anyone else, probably, but then why would you use this tool if you have no need for sqlite?
encom•1d ago
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.
conductr•1d ago
somehnguy•1d ago
chasil•1d ago
It will give you a shell that will have SQLite.
For Windows, download the interactive command line tool from sqlite.org.
ajmurmann•1d ago
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.
cortesoft•1d ago
Some people might not have computers but still want to learn?
josefx•1d ago
Aeolun•1d ago
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•1d ago
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•1d ago
Be kind and sensible.
mchaver•1d ago
Sohcahtoa82•1d ago
tiffanyh•1d ago
Would have made homework (and just learning) significantly easier.
gwbas1c•1d ago
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•1d ago
tuveson•9h ago
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•1d ago
sqliteonline•1d ago
It may be difficult to briefly describe all the website’s capabilities right now, but the key features include:
LtdJorge•1d ago
sqliteonline•1d ago
crazygringo•1d ago
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•1d ago
crazygringo•1d ago
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•1d ago
whizzter•1d ago
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•1d ago