5 ms·

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

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 3y 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 3y 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 3y 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.
- deleted 3y ago
  [deleted]
- infecto 3y ago
  At that point why not use something like Postgres?
  - okr 3y ago
    If ya have sqlite locally, read-only, maybe everything in a single docker image, which you can deploy thousands of times...
    - infecto 3y ago
      I did not really get the sense that was the purpose of this service? This service is SQLite behind an API.
  - kjksf 3y ago
    When it comes to services like that, the underlying db engine is the least interesting aspect. I haven't used SqliteCloud so I can't vouch for them but they make a pretty good case for their technology: https://blog.sqlitecloud.io/how-and-why-we-brought-sqlite-to-the-cloud https://blog.sqlitecloud.io/how-and-why-we-brought-sqlite-to... Pub/Sub is, I believe, a rare functionality with hosted sql databases so if you need that, SqliteCloud is one of few places to get it. They claim they have a unique feature: ability to sync the database to mobile device with CRDT. So you can have a hosted database updated from your backend and have it synced for fast offline access in a mobile app. That, I believe, is something no one else offers. Weblite is also unique to their platform https://docs.sqlitecloud.io/docs/introduction/weblite https://docs.sqlitecloud.io/docs/introduction/weblite And in general, if you're familiar with SQLite, having option to have it hosted by SqliteCloud is better than using e.g. hosted Postgres and having to learn Postgres
    - infecto 3y ago
      That is fair. The CRDT offline sync is interesting.
    - hobs 3y ago
      The difference is you are choosing between "learning postgres and have that tool your entire life" and "learning some vendors proprietary extensions so you can stop using it when they shut down" The only way the personal math makes sense to me is that "learning sqlite" is like half a day of work, "learning postgres" can be significantly more, but its like saying you should just use hammer in the cloud instead of learning how to use screwdriver and other useful tools.
- kjksf 3y ago
  Why Sqlite? They make a pretty good case here https://blog.sqlitecloud.io/how-and-why-we-brought-sqlite-to-the-cloud 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.
  - infecto 3y ago
    I don't think that article is a good case at all and with the lack of transparent pricing even harder to understand. We all care about efficiency but still not sure why I would use this over existing databases which are cheap to throw some more memory at. As you pointed out below I think CRDT is interesting. I would love to see some real-world comparisons to see how much their efficiency claims actually matter.
    - kjksf 3y ago
      I don't like lack of pricing either. It would be a deal breaker for me as far as using their stuff. Maybe that's because they're in beta. But the actual capabilities of their service - it just sounds like you didn't even care to learn what they offer because there's a lot to like. First, it's a hosted SQLite. For those who know SQLite and not other databases is a reason enough to use it over hosted Postgres or hosted Mysql They claim involvement of Richard Hipp, the creator of SQLite. That's as huge boost of credibility right there. They have multi-node replication with Raft. That's not unique but also not something you get everywhere. Most hosted database services just give you a database on a single server. They have Pub/Sub - that's even more rare than multi-node replication. They have offline synch where you can sync your cloud db to a sqlite db on a mobile device. I believe that's both useful to many people and 100% unique to their service. WebLite is also 100% unique and seems very useful to web frontends. They claim they'll provide a way to run your code, compiled to wasm, on their servers. That would also be 100% unique to them. They have SDKs for lots of languages. So technologically that's very compelling and they have useful features not available anywhere else.
infecto 3y 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.
marcobambini 3y 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-bcn 3y 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 3y 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?
- marcobambini 3y ago
  He is an investor in SQLite Cloud, Inc.

Ringz 3y 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 3y 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 3y 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.

deleted 3y ago
[deleted]
infecto 3y ago
At that point why not use something like Postgres?
- okr 3y ago
  If ya have sqlite locally, read-only, maybe everything in a single docker image, which you can deploy thousands of times...
  - infecto 3y ago
    I did not really get the sense that was the purpose of this service? This service is SQLite behind an API.
- kjksf 3y ago
  When it comes to services like that, the underlying db engine is the least interesting aspect. I haven't used SqliteCloud so I can't vouch for them but they make a pretty good case for their technology: https://blog.sqlitecloud.io/how-and-why-we-brought-sqlite-to-the-cloud https://blog.sqlitecloud.io/how-and-why-we-brought-sqlite-to... Pub/Sub is, I believe, a rare functionality with hosted sql databases so if you need that, SqliteCloud is one of few places to get it. They claim they have a unique feature: ability to sync the database to mobile device with CRDT. So you can have a hosted database updated from your backend and have it synced for fast offline access in a mobile app. That, I believe, is something no one else offers. Weblite is also unique to their platform https://docs.sqlitecloud.io/docs/introduction/weblite https://docs.sqlitecloud.io/docs/introduction/weblite And in general, if you're familiar with SQLite, having option to have it hosted by SqliteCloud is better than using e.g. hosted Postgres and having to learn Postgres
  - infecto 3y ago
    That is fair. The CRDT offline sync is interesting.
  - hobs 3y ago
    The difference is you are choosing between "learning postgres and have that tool your entire life" and "learning some vendors proprietary extensions so you can stop using it when they shut down" The only way the personal math makes sense to me is that "learning sqlite" is like half a day of work, "learning postgres" can be significantly more, but its like saying you should just use hammer in the cloud instead of learning how to use screwdriver and other useful tools.
kjksf 3y ago
Why Sqlite? They make a pretty good case here https://blog.sqlitecloud.io/how-and-why-we-brought-sqlite-to-the-cloud 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.
- infecto 3y ago
  I don't think that article is a good case at all and with the lack of transparent pricing even harder to understand. We all care about efficiency but still not sure why I would use this over existing databases which are cheap to throw some more memory at. As you pointed out below I think CRDT is interesting. I would love to see some real-world comparisons to see how much their efficiency claims actually matter.
  - kjksf 3y ago
    I don't like lack of pricing either. It would be a deal breaker for me as far as using their stuff. Maybe that's because they're in beta. But the actual capabilities of their service - it just sounds like you didn't even care to learn what they offer because there's a lot to like. First, it's a hosted SQLite. For those who know SQLite and not other databases is a reason enough to use it over hosted Postgres or hosted Mysql They claim involvement of Richard Hipp, the creator of SQLite. That's as huge boost of credibility right there. They have multi-node replication with Raft. That's not unique but also not something you get everywhere. Most hosted database services just give you a database on a single server. They have Pub/Sub - that's even more rare than multi-node replication. They have offline synch where you can sync your cloud db to a sqlite db on a mobile device. I believe that's both useful to many people and 100% unique to their service. WebLite is also 100% unique and seems very useful to web frontends. They claim they'll provide a way to run your code, compiled to wasm, on their servers. That would also be 100% unique to them. They have SDKs for lots of languages. So technologically that's very compelling and they have useful features not available anywhere else.

infecto 3y 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.

marcobambini 3y 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-bcn 3y 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 3y 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?

marcobambini 3y ago
He is an investor in SQLite Cloud, Inc.