from Hacker News

Web SQL Database: In Memoriam (2014)

by mucholove on 10/11/21, 2:23 PM with 20 comments

  • by thayne on 10/11/21, 2:48 PM

    I really don't get why Mozilla argued that they would have to re-implement SQLite for WebSQL, but then used SQLite for IndexedDB. Why were they so opposed to using SQLite for WebSQL?
  • by themihai on 10/11/21, 6:01 PM

    Once we have storage foundation[0] we can install "any" db in the browser. Of course the communication protocol would have to be tweaked a bit. Until then see absurd sql[1]

    [0] https://web.dev/storage-foundation/

    [1] https://hackaday.com/2021/08/24/sqlite-on-the-web-absurd-sql...

  • by ArtTimeInvestor on 10/11/21, 4:04 PM

    It would be the biggest irony ever if the web settles on sql.js [1] plus persistance based on IndexedDB.

    Then to comfortably store data, we would have SQLite running in WebAssembly persisting the data via the awkward IndexedDB API which uses the comfortable SQLite API to store the data in native SQLite.

    [1] https://sql.js.org

  • by 8trackbattlecat on 10/11/21, 6:40 PM

    At the time (2010?), WebSQL was the only way to store more than 5MB of data on both android chrome and ios safari. (Used it slightly ridiculously for storing base64 photos when there was no data connection.) It was quite frustrating when it got deprecated, it felt like they were killing the only way to get close to parity with native apps. I refused to use firefox for about 5 years.
  • by InfiniteRand on 10/11/21, 9:01 PM

    What is the developer experience these days with IndexedDB. I stopped working web development shortly after IndexedDB started getting implemented, and I know the early implementations had some rough edges, my understanding is that there was some effort to improve apis over the last 5 or 6 years. So I would be interested if someone with some experience could speak to it
  • by mucholove on 10/11/21, 2:24 PM

    Getting acquainted with Javascript and the web today. Really wish I had this. Would make life very, very, very easy. :)

    Today you get ABSURD: https://news.ycombinator.com/item?id=28156831

  • by postalrat on 10/11/21, 6:08 PM

    https://github.com/WICG/indexed-db-observers/blob/gh-pages/E...

    Give me that and we can forget about web sql.