3 ms·

The missing link, IMHO, is the lack of client side SQL and a sync mechanism. IndexDB is okay, but nobody is going to use it server side. So you kind of always

by treis 6y ago

The missing link, IMHO, is the lack of client side SQL and a sync mechanism. IndexDB is okay, but nobody is going to use it server side. So you kind of always have to end up writing things twice.

nullsense 6y ago
You want a web browser talking directly to an RDBMS of some kind?
- treis 6y ago
  Yes, like we had with WebSQL until it was deprecated. Basically a SQLite db per site.
  - knubie 6y ago
    I think the idea is that IndexedDB acts as a more lower level store that you can build higher level abstractions over, for example PouchDB.
    - throw_m239339 6y ago
      > I think the idea is that IndexedDB acts as a more lower level store that you can build higher level abstractions over, for example PouchDB. AFAIK, the problem was that vendors couldn't agree on which version of SQL/Sqlite they would have to support and nobody wanted to write a SQL spec. MS wanted to use SQL Compact, but it's mainly Mozilla's fault if the spec was dropped. The same Mozilla that dragged its feet for years when it comes to implementing some aspects of web components... But it was a terrible decision IMHO because indexedDB doesn't do what a relational database does and it considerably hurt the development of complex mobile web apps, and now Safari on IOS AFAIK removed support for WebSQL. WebSQL was a fantastic tool for web apps that could be entirely cached on a mobile device (SQL can do a lot). There is no realistic replacement. Even using Sqlite compiled to WASM has a lot of issues (mainly performances and data persistence). To this day I don't know a single efficient and performance RDBMS equivalent to Sqlite built on top of IndexedDB. Mozilla certainly didn't build one.
    - yawaramin 6y ago
      'We removed WebSQL support, but you can build your own using a simple key-value store that we have implemented on top of SQLite! Rejoice!'
  - pier25 6y ago
    You can run queries to FaunaDB on the browser with FQL which is quite powerful.
rolae 6y ago
Meteor.js maybe, not sure of its focus nowaday, back when I played around with it, you had basically a MongoDB that you could query and mutate on the client, everything was then synced via a pub/sub system with the server.

by treis 6y ago

The missing link, IMHO, is the lack of client side SQL and a sync mechanism. IndexDB is okay, but nobody is going to use it server side. So you kind of always have to end up writing things twice.

nullsense 6y ago

You want a web browser talking directly to an RDBMS of some kind?

treis 6y ago
Yes, like we had with WebSQL until it was deprecated. Basically a SQLite db per site.
- knubie 6y ago
  I think the idea is that IndexedDB acts as a more lower level store that you can build higher level abstractions over, for example PouchDB.
  - throw_m239339 6y ago
    > I think the idea is that IndexedDB acts as a more lower level store that you can build higher level abstractions over, for example PouchDB. AFAIK, the problem was that vendors couldn't agree on which version of SQL/Sqlite they would have to support and nobody wanted to write a SQL spec. MS wanted to use SQL Compact, but it's mainly Mozilla's fault if the spec was dropped. The same Mozilla that dragged its feet for years when it comes to implementing some aspects of web components... But it was a terrible decision IMHO because indexedDB doesn't do what a relational database does and it considerably hurt the development of complex mobile web apps, and now Safari on IOS AFAIK removed support for WebSQL. WebSQL was a fantastic tool for web apps that could be entirely cached on a mobile device (SQL can do a lot). There is no realistic replacement. Even using Sqlite compiled to WASM has a lot of issues (mainly performances and data persistence). To this day I don't know a single efficient and performance RDBMS equivalent to Sqlite built on top of IndexedDB. Mozilla certainly didn't build one.
  - yawaramin 6y ago
    'We removed WebSQL support, but you can build your own using a simple key-value store that we have implemented on top of SQLite! Rejoice!'
- pier25 6y ago
  You can run queries to FaunaDB on the browser with FQL which is quite powerful.

rolae 6y ago

Meteor.js maybe, not sure of its focus nowaday, back when I played around with it, you had basically a MongoDB that you could query and mutate on the client, everything was then synced via a pub/sub system with the server.