Live data from Hacker News

Show HN: SQLite Online – 11 years of solo development, 11K daily users

sqliteonline.com

121–130 of 153 posts

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#121
post #84
post #80

Earlier quoted context omitted.

It's possible the local legislation disallows charging in non-local currency. Eg. can you charge in rubles in USA?

Sure, you could charge in hotdogs if you wanted to.

I wonder where's the Bank of Hotdogs based in the US? :)

The point is that you need a bank to accept a payment in foreign currency and debit it into your account.

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#122
Your tool has been a huge help in the classroom over the past decade, thank you!

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!

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#123
post #64
post #48

Earlier quoted context omitted.

The person is saying that the description says "subscription" which by definition automatically renews

Not the definition of a subscription. See: magazines, traditionally purchased with one-time annual payments.

Well, those still recur automatically

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#124

Great job and many kudos for the determination to maintain a tool for 11 years! 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,…

I have heard something like “lottery factor” as a more pleasant term. Though personally bus doesn’t bother me.

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#125
post #118

I immediately tried to run .schema and a syntax error was returned.

I assume this is because sqliteonline is using the sqlite library, not running the literal sqlite command line application. Per item 7 in the faq (https://sqlite.org/faq.html), the way to get that info would be to run something like the following:

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.

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#127
post #123
post #64

Earlier quoted context omitted.

Not the definition of a subscription. See: magazines, traditionally purchased with one-time annual payments.

Well, those still recur automatically

To my recollection, not the old fashioned kind where you send in a check/money order for the annual subscription.

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#128
post #112

Unsolicited suggestion: since some people are asking "what is this". 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)

In my opinion that's not good advice. Over the past 11 years this domain already built up some domain reputation and incoming links. Changing the domain for no good reason won't help with people understanding the use case of the site. 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: - C…

i read the parent post's advice as duplicating, rather than changing - e.g., you keep the existing domain, but also the exact same app is available from those other domains.

But you're not wrong - i dont think the domain has a big effect, and personally i'd rather save $10.

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#129

Earlier quoted context omitted.

hey, not to give you "armchair" advice, but I feel like a tool that's existed for 11 years and has 11k daily users is a super serious achievement. 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 of…

Thank you. I have been considering various monetization approaches, evaluating their convenience and potential demand. Unfortunately, certain external factors currently prevent me from implementing everything as I would like. However, I still have several ideas that I hope will be engaging, in demand, and easy to pay for.

[dead]

Re: Show HN: SQLite Online – 11 years of solo development, 11K daily users

#130

Earlier quoted context omitted.

As a rabbit, I'd rather carrots... Isn't this comment a form of Brit defaultism?

My point was more about the original comment is fine from the perspective of an American, but for the rest of the world, it doesn’t really matter if it is USD or rubles - it’s still a foreign transaction. I appreciate that for a large percentage of the world, consumers can probably do an approximation of the USD conversion in their head, and not a rubles one, and therefore, USD may be more friendly. That being said,…

I'd imagine most English-speaking internet users have gotten used to doing local-to-USD conversions. As someone in the US, I usually know about where CAD, AUD, and GBP are relative to me.

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

Post reply on HN