Smart Mobile Studio and the SQLite engine (!)
I am so excited right now I can hardly type straight. This is so awesome that I hardly know where to begin!
This means that you dont need to fiddle with WebSQL or whatever restriction browser vendors have put on reading data. The entire SQLite engine itself is now capable of running inside your Smart Mobile Studio applications.
So you can load, download and even generate binary SQLite database files. If you have a script on your server to accept uploads you can even save those files — or what about creating a SQLite editor so people can design their tables in the browser?
Needless to say I am really happy about this find and jumped straight into it to write a wrapper. I’m not sure we will be able to get this into the next update – but if not, you can download it from this website. It is just to fantastic not to include.
This means you don’t get one DB engine in the next update – but two! system.dataset and system.sqlite all in one go.