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

https://sqliteonline.com/

80•sqliteonline•1h ago

Comments

bob1029•1h ago

I am really struggling to figure out what this is or how it provides value.

zvmaz•1h ago

For me: Try queries without the hassle of setting up a database. Learn SQL. Experiment. Etc.

WesolyKubeczek•57m 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.

sqliteonline•54m ago

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.

zwnow•49m ago

you can just share the file, huh

collaboration sounds nice though, it definitely has a market considering 11k daily users.

sqliteonline•43m ago

If 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•36m ago

how does collaboration works for SQLite, since the db is embedded?

WesolyKubeczek•17m 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•29m ago

I think someone forgot what made the web the most popular platform in the world.

killerstorm•23m ago

   sqlite3 :memory:

if you don't want it to be persisted

zvmaz•38m ago

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.

tiffanyh•1h ago

I would have loved this 25-years ago during university.

Would have made homework (and just learning) significantly easier.

foofoo12•1h ago

I get this message:

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

foofoo12•1h ago

Current Firefox on Linux. This is the console message:

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

sqliteonline•1h ago

You may be using an outdated browser version that doesn’t support some features. Please update your browser to the latest version for the website to work properly.

tecleandor•53m ago

I also get the glyph message on my Firefox 144.0b8 and it runs fast here, so I guess that shouldn't be the reason...

RTCPeerConnection is available in Firefox and Chrome since 2017... son unless the browser is veeery old... Maybe something blocking RTC?

sqliteonline•46m ago

Yes, the issue may be caused by WebRTC being disabled in your browser settings.

hu3•1h ago

Cool project. Congrats for keeping it up for so long!

Could you share some numbers like a ballpark of subscribers?

sqliteonline•1h ago

Thank you, unfortunately, almost zero.

hu3•1h ago

Thanks for sharing. Still valuable for me in any interview if someone says they kept a service up for 11 years. Shows determination.

stronglikedan•42m ago

Holy bus factor, Batman! Train somebody up already FFS! People are relying on you. 11 years of solo development is nothing to brag about when people are paying you for a service.

oooyay•31m ago

Some things in life are just not that serious. People can have passion projects they plan on going nowhere.

melvinchus•32m ago

Incredible persistence. Eleven years maintaining a live product at that scale is no small feat. SQLite is timeless — this kind of craftsmanship is what keeps the web interesting.

hung•20m ago

cool story, AI

FitchApps•30m ago

What a nice tool. Thank you for building and maintaining the product. I casually use it to validate SQL joins

sqliteonline•14m ago

Thank you! I hope it will capture your interest with new features in the future.

TiredOfLife•24m ago

Don't localise messages if you don't have anyone to proofread. Browsers have built in translation nowadays that users can activate if they need.

sqliteonline•9m ago

Could you please advise where the issue might be?

jve•23m ago

The paid subscription lists this feature:

> No auto-renewal

That's not subscription.

sqliteonline•11m ago

I aim to make the product convenient and as straightforward as possible. It's better to extend its use when needed than to worry about when to stop.