Database abstraction with google apps scriptThis is the the driver for DB.MEMORY described in
The library reference is M96uVZRXXG_RY3c2at9V6tSz3TLx7pV4j
There's nothing to stop us using memory as a back end database. Sounds a little unnecessary, but when you think of it this gives you all the filtering sorting and selection capabilities of a database without actually using a database. Another great benefit is that it allows you to test your database abstraction application (since the querying syntax is exactly the same) without actually using (even before selecting) a backend database and potentially using up some quota... and of course the performance is good. You can also easily combine this with an external database - just query in all the data, and do your normal queries in memory.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Database abstraction and Google Apps Script >