Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

sqliteonline.com

Post reply on HN
Print view View original

61–70 of 153 posts

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

#61

Post by kijin »

sqliteonline wrote: post #33
TiredOfLife wrote: post #25

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.

Could you please advise where the issue might be?

Not the parent, but I see that several messages related to buying a subscription are translated into the locale of my browser. In my language, it just feels a little amateurish. In other languages, perhaps it might contain something totally wrong.

So it will be safer to just use languages you are comfortable with, like English and Russian. Especially on pages that concern money. :)

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

#62

Post by sqliteonline »

kijin wrote: post #61
sqliteonline wrote: post #33

Earlier quoted context omitted.

Could you please advise where the issue might be?

Not the parent, but I see that several messages related to buying a subscription are translated into the locale of my browser. In my language, it just feels a little amateurish. In other languages, perhaps it might contain something totally wrong. So it will be safer to just use languages you are comfortable with, like English and Russian. Especially on pages that concern money. :)

Thank you. I used an LLM for translation, hoping to achieve a high-quality result and make the service convenient for users. It seems I was mistaken.

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

#63

Post by sqliteonline »

avinassh wrote: post #20
sqliteonline wrote: post #13

Earlier quoted context omitted.

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?

When 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.

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

#64

Post by dangus »

ezfe wrote: post #48
sqliteonline wrote: post #32

Earlier quoted context omitted.

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.

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.

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

#65

Post by Aeolun »

WesolyKubeczek wrote: post #12
zvmaz wrote: post #5

Earlier quoted context omitted.

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

> 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.

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

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

#66

Post by Towaway69 »

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, it seems a little cruel to speak of folks being hit by buses - is there something better nowadays?

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

#67

Post by hombre_fatal »

jermaustin1 wrote: post #52
rat9988 wrote: post #34

Earlier quoted context omitted.

> doesn't even require connectivity (which might be a problem "on some devices" or "in some locations"). 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 develop…

> You are just trying to prove a point instead of understanding it. > 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.

It was just one item in a list and they used "etc." which prob refers to all the other obvious upsides, like why you would use pgadmin/postico to write postgres queries instead of psql cli.

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.

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

#68

Post by mchaver »

zvmaz wrote: post #19
zvmaz wrote: post #5

Earlier quoted context omitted.

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

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

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

#69

Post by josefx »

cortesoft wrote: post #59
WesolyKubeczek wrote: post #12

Earlier quoted context omitted.

> 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.

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?

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

#70

Post by sqliteonline »

bob1029 wrote: post #2

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 with this tool." would have radically altered my initial perception.

> You can

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.
Post reply on HN