There is no SQLite in the browser, unless you are talking about something like https://github.com/kripken/sql.js, though that is very heavy and is in-memory only. There are a number of packages that provide an abstraction over IndexedDB, such as Dexie.js, AlaSQL, Nano-SQL, Lovefield, etc. Maybe have a look at their codebases to get a sense of the complexity involved.
Anthony On Monday, April 29, 2019 at 8:47:36 PM UTC-4, Scott Hunter wrote: > > > The direction from web2py to web3py seems to be applications where the > server is responsible for (relatively) static pages which use Javascript > for their dynamic aspects & talking to the server via an API, primarily for > interaction w/ the database. > > In the spirit of Progressive Web Apps, one could imagine getting to the > point where instead of making calls to the server, Javascript functions are > called instead to interact w/ an SQLite DB under the browser's control. > Doing so via something like pyDAL, but replacing Python with Javascript & > only needing to support SQLite would not only ease the burden of writing > such code, but make it easier to make a transition between these two DB > locations. > > I'm actually thinking specifically of being able to deploy a pared-down > version of a "normal" application which could perform most of its > functionality off-line, and use online access only for transferring > information in bulk between the local DB and the one in the cloud. The > more that those applications can share code, the better. (I've > accomplished this goal, somewhat clunkily, by deploying the web2py binary > w/ a limited version of the app in the cloud; an approach as I've described > above seems that it wouldn't be nearly as brittle.) > > Does this make any sense? Would something like a jsDAL be prohibitively > difficult to write, or not really worth the effort? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.