Smart Mobile Studio and the SQLite engine (!)

SQLite is now 100% native JS

I am so excited right now I can hardly type straight. This is so awesome that I hardly know where to begin!

Some guy decided to port over the whole SQLite engine from C to JavaScript.  That’s right, not an interface to use the DLL, or read the tables or anything like that; a complete and full port of the entire SQLite database engine converted to JavaScript.

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.

Who would have thought – SQLite converted to JavaScript running happily in the browser