News for hackers. Stuff that matters.
Re:If Not SPAs, What? by treis on Wednesday October 28, 2020 @06:44PM (#24925024)
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.
Re:If Not SPAs, What? by rolae on Wednesday October 28, 2020 @07:34PM (#24925396)
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.
Re:If Not SPAs, What? by nullsense on Wednesday October 28, 2020 @07:02PM (#24925166)
You want a web browser talking directly to an RDBMS of some kind?
Re:If Not SPAs, What? by treis on Wednesday October 28, 2020 @07:08PM (#24925206)
Yes, like we had with WebSQL until it was deprecated. Basically a SQLite db per site.
Re:If Not SPAs, What? by knubie on Wednesday October 28, 2020 @07:23PM (#24925314)
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.
Re:If Not SPAs, What? by throw_m239339 on Wednesday October 28, 2020 @09:20PM (#24926069)
> 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.

Re:If Not SPAs, What? by yawaramin on Thursday October 29, 2020 @01:21PM (#24932817)
'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!'
Re:If Not SPAs, What? by pier25 on Wednesday October 28, 2020 @09:45PM (#24926203)
You can run queries to FaunaDB on the browser with FQL which is quite powerful.