Interactive SQLite Documentation: Experiment with Queries in Real-Time

https://blog.sqlitecloud.io/interactive-sqlite-documentation-experiment-with-queries-in-real-time

by marcobambini • 2 years ago

123 32 2 years ago

blog.sqlitecloud.io

i love this kinda interactive documentation, its so great to be able to tinker as you learn. well done!

avinassh• 2 years ago

This is a great idea! On a related note, I love how nalgeon [0] has interactive blog posts [1] on SQLite release notes using WASM magic

[0] https://news.ycombinator.com/user?id=nalgeon

[1] https://antonz.org/sqlite-3-45/

james-bcn2• 2 years ago

Nice. But with regards to the SQLite cloud, it annoys the hell out of me that so many of this type of site hide their pricing. It makes no sense to me at all. It just puts me off signing up to test services if I don't know the pricing.

Ringz• 2 years ago

Maybe the result of some short sighted AB testing. I hate that to but I have to admit that I tend to close the tab as fast as possible seeing some prices that don’t correlate with the „amount of benefits“ at that concrete moment. So they try to bind you as long as possible to raise that amount through the „good price“ threshold.

sanitycheck• 2 years ago

Pricing information is the first thing I look for, and if I don't find it I assume it's nowhere near reasonable and close the tab.

Back to the topic of the post, I like the idea and it's definitely a good addition to the standard sqlite docs which can be a little dry/dense in places. It'd be nice if we had some sort of inline DB-browser type view too so we could see what the commands we run actually did without resorting to writing select statements before and after the example. Also not sure why I have to click 'show' to see the command syntax.

rmbyrro• 2 years ago

Even harder to understand is if you need high concurrency, multi-node replication, pub/sub capabilities, etc, what is the point of using SQLite in the first place?

I love SQLite, but don't let love blind out technical decisions, folks.

There are much better, battle-tested tools to solve these problems.

infecto5• 2 years ago

At that point why not use something like Postgres?

kjksf4• 2 years ago

Why Sqlite? They make a pretty good case here https://blog.sqlitecloud.io/how-and-why-we-brought-sqlite-to...

if you need high concurrency, multi-node replication, pub/sub capabilities, etc, what is the point of using SQLite in the first place

SqliteCloud is capable of all those things, so what exactly is your complaint?

multi-node replication and pub/sub are not part of sqlite code but SqliteCloud additions and I see no reason why their implementation of replication or pub/sub should be any worse that other implementations

Sqlite used to be much worse at high concurrency that other databases but it's no longer the case in recent versions with additions of WAL mode and SqliteCloud claims additional perf improvements for high concurrency

There are much better, battle-tested tools to solve these problems.

I meant, it's quite possible but I'll point out an obvious fabrication: you don't know.

You haven't actually tried SqliteCloud, you haven't benchmarked it against other tools so you just don't know.

I'm 97.8% sure of that.

infecto5• 2 years ago

Wow you are not wrong. Maybe it works for them but I would guess they are losing a lot traffic by having no real visible pricing on their website. This is not an enterprise play, I would imagine they are most likely wanting to target developers and developers want to see pricing...especially for something as simple as a database.

marcobambini3• 2 years ago

SQLite Cloud's founder here. Our service is still in beta. We'll announce pricing as soon as we're out of the beta phase. There is no marketing strategy at all here, we are just developing one step at a time.

james-bcn2• 2 years ago

Well you should make that clearer on the website. Perhaps put a pricing tab on the site and on that tab explain that you are in beta and the pricing isn't decided yet. Otherwise it just looks like you hiding the pricing, which annoys people, as you can see in this thread.

tiffanyh• 2 years ago

Backed by the creator of SQLite.

Any more details on that?

Presumably this is Dr Hipp. How involved is he, what does that involvement mean?

marcobambini3• 2 years ago

He is an investor in SQLite Cloud, Inc.

invernomut0• 2 years ago

It seems interesting but I think I prefer to keep another tab with https://www.db-fiddle.com/ to experiment with the syntax.

marcobambini3• 2 years ago

Hi all. SQLite Cloud's founder here. Our service is still in beta. We'll announce pricing as soon as we're out of the beta phase. There is no marketing strategy at all here, we are just developing one step at a time.

russfink• 2 years ago

What is the educational pricing plan? Is there something that is free for small databases that load/exec entirely in the browser?

carl_dr• 2 years ago

Real-Time Query Execution: Write your SQL queries and see the results instantly. Whether you're retrieving data, performing joins, or modifying tables, the Interactive SQLite Console provides immediate feedback.

Types DELETE FROM table ... Oh

I presume you have a commit step or something?

emadda• 2 years ago

Backed by the creator of SQLite.

Is this from the SQLite developers?

jpgvm• 2 years ago

Not exactly no. None of the core SQLite devs seem to have touched this.

They do however claim that Dr Hipp is an investor which if true certainly does lend a lot of credibility.

edublancas• 2 years ago

You can get this for pretty much any language by re-using Jupyter kernels; here's a Python example: https://hidden-truth-8699.ploomberapp.io/

Interactive SQLite Documentation: Experiment with Queries in Real-Time

Related Stories